Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4120222026-03-08T19:47:51ZPATRICIAGMUNOZ1947-10-21NULL··•••-••-88099294153586—·3866 UNION STREETTucson··AZ85757·GRP-8628·-
PRVPRV-295062026-04-26T17:00:22ZJula—Feilds1992-07-08UHC-03539-69NULL··6579697UNKNOWN7380 BAYSHORE DRIVEPhoenixAZ85050UNKNOWN—
CLMCLM-4105632026-05-24T23:47:42ZNelson, Mei——05/06/1998UHC-81996-09•••-••-44399375833268-6349 INDIAN SCHOOL RD #558San AntonioTX78263-6751null—
PRV PRV-211612026-02-13T18:06:39ZChristopher—Williamson··2002-02-28null··NULL5136237039--··—UNKNOWNUNKNOWNNULL··null
ENRENR-1417902026-01-24T04:53:52ZLaurenPTomas10/12/1956UHC-69988-20•••-••-9551522-740-5024lauren.thomas36@yahoo.comnull··—NULLNULLGRP-3405MEDICARE-ADV-A
ENRENR-1008812026-01-03T03:36:25ZRUUTH—MILLERN/AUHC-03583-56•••-••-25125207015238—1269 Canyon RoadSacramentoCA95879GRP-0717SELECT-EPO
ENRENR-1265352026-04-29T22:33:05ZHiroshi—Johnson12/14/1952·UHC-05965-18•••-••-7510533-718-3772HIROSHI.JOHNSON77@HOTMAIL.COM5623 RIVER RDJACKSONVILLEFL32217GRP-4016MEDICARE-ADV-B
ENRENR-1261382026-05-27T11:06:34ZEircH.SnyderJan 27, 1971··UHC-51431-79··667-680-3896eric.snyder@aol.com4671 UNION STREETSCOTTSDALEAZ85283GRP-4118CHOICE-PLUS-PPO
CLMCLM-4084102026-06-25T01:31:34ZLUIS····PETERSON9/10/1981UHC-91715-29•••-••-4695636-537-4820-807 Canyon Rd··Los AngelesCAUNKNOWN—NULL
PRVPRV-265132026-09-07T22:18:16Zvincent—campbell1982-11-20UHC-21729-18N/A+1 313 725 7856vincent.campbell@proton.me6665 Pine DrSan AntonioTX78254··N/A
TPATPA-523382026-04-14T15:44:29Z·Amy—Washngton1963-07-27UHC-41659-76•••-••-8543-NULL··8281 MOUNTAIN VIEW DRIVEFresnoCA93710-SELECT-EPO
ENRENR-1405512026-07-24T18:21:38ZTurner, ScottV—21-05-1951UHC2965632··•••-••-1718434-583-9565SCOTT.TURNER85@YAHOO.COM3002 Lake View Road Apt 35TampaFL33668GRP-6696··NAVIGATE-HMO
ENRENR-1189662026-03-30T17:42:30ZDENISE—JACKSON1955-09-27UHC5100090•••-••-5789(653) 872-8958DENISE.JACKSON64@AOL.COM··6184 Union Street #847CharlotteNC28282GRP-3028MEDICARE-ADV-A
CLMCLM-4269122026-04-26T10:35:14ZSUE—MORRISON1959-02-28UHC-92801-47•••-••-5423UNKNOWN····2746 Apache BlvdDenverCO··80252N/ACHOICE-PLUS-PPO
TPATPA-522262026-10-09T12:47:12ZJacobs, Nathan——Jul 4, 1946··NULLUNKNOWNnullnathan.jacobs@aol.com3405 Pine DrSeattlewa98114N/AUNKNOWN
ENRENR-1147662026-06-29T05:52:31ZZACHARYH.THOMPSON1959-02-24—•••-••-040318112505484ZACHARY.THOMPSON42@PROTON.ME320 WASHINGTON STTampaFL···33695GRP-7988··CORE-HMO
PRVPRV-263392026-02-12T17:18:28ZannaY.greene1986-02-14UNKNOWN•••-••-8419(987) 521-7391··ANNA.GREENE20@YAHOO.COM9359 Lake View RoadDenverCO80222-··
PRVPRV-227142026-05-30T15:46:22ZCAROL—LANE1956-06-01—-(575) 749-9827carol.lane@gmail.com7896 Willow CourtMESAAZ85250UNKNOWNN/A··
CLMCLM-4012102026-01-24T17:38:48Z Deborah—Castro1946-08-12NULL•••-••-5330-—2479 Baseline Rd··ChandlerArizona85238··nullNULL
PRVPRV-239072026-02-02T21:12:03ZBell, Andrew——08/20/64UHC1539125—+1 277 242 8230····5494 Union StreetSan AntonioTX78287··N/AMEDICARE-ADV-A
TPATPA-583312026-10-04T20:01:59Z ETHAN—PERRY06/27/07uhc-68803-96—-··124 PARK PLEden PrairieMN55357-8559N/A····
ENRENR-1107362026-06-23T03:11:38ZPadilla, Paul——1957-12-06UHC-43955-02•••-••-2179(653) 578-4633paul.padilla24@proton.me—NULL—N/AGRP-5977MEDICARE-ADV-A
ENRENR-1092862026-07-11T18:22:06ZDABORAH—ROBERTS4/2/1975UHC-29217-76•••-••-0023372-631-1947deborah.roberts@yahoo.com9278 Meadow LaneSan AntonioTX78253GRP-3018MEDICARE-ADV-B
ENRENR-1018172026-02-19T15:04:37ZYUKIXGREEN19700813UHC-53218-39•••-••-1298+1 783 562 0480null6180 JEFFERSON AVESan Antonio··TX78223GRP-3444OPTIONS-PPO
PRVPRV-279352026-04-27T04:19:53ZMendoza, Adam——02/27/1956UHC-49778-06N/A+1 823 822 5670nullN/A—-null—MEDICARE-ADV-B··
ENRENR-1333082026-02-11T12:36:31ZMegan—Ortiz08/20/1961UHC-20744-18•••-••-7383409-586-0385N/A9249 Desert Sky Boulevard··Los AngelesCA—GRP-1014OPTIONS-PPO··
CLMCLM-4041042026-07-27T21:34:36ZZacharyRCarpenter09/12/1946N/A—3255728760—NULL—·null··-OPTIONS-PPO
ENRENR-1326792026-08-23T10:43:01Zjeremy—gilbert1977-02-25··-•••-••-24698279693160JEREMY.GILBERT@HOTMAIL.COM9363 VALLEY VIEW DRIVEColumbusOhio43275GRP-6118·MEDICARE-ADV-A
CLMCLM-4021212026-08-18T08:29:45Z ROGER—LAWSON1951-02-25UHC-16804-72•••-••-2005null·N/A9864 Washington StTempeAZ85210··GRP-8845-
ENRENR-1074372026-09-18T10:00:50ZJOHNV.··BRYANT08/23/1988UHC-34316-31•••-••-3813621.560.2163··john.bryant73@icloud.com3418 Canyon RdColumbusOH43288GRP-4131NAVIGATE-HMO
CLMCLM-4073152026-03-12T03:58:15ZEmily—Specer2002-01-14UHC-55914-20•••-••-9818null—7951 Bayshore Dr Apt 15Los AngelesCA90029GRP-3111NULL
TPATPA-531942026-04-08T08:01:47Z HEATHERKARNOLD1939-10-06UHC-93459-97•••-••-8907—heather.arnold49@icloud.comN/A—N/AUNKNOWNGRP-6532··NAVIGATE-HMO
ENRENR-1057292026-04-25T12:00:02ZKATHY—CRUZ1967-10-10·UHC-59287-85•••-••-9820nullkathleen.cruz@hotmail.com9570 Church Street Apt 14San Diego·CA92175GRP-0933MEDICARE-ADV-B
ENRENR-1123572026-06-26T08:45:39ZGardner, JonathanG—12/22/1959UHC-56406-57•••-••-33282607069786JONATHAN.GARDNER@OUTLOOK.COM4766 CANYON ROADDallasTX75244GRP-4810CHOICE-PLUS-PPO
TPATPA-542362026-03-27T11:39:26ZMegan—Reed2005-11-11nullNULLNULL—8402 MESA DRIVE #666SacramentoCA95812··GRP-1069—
CLMCLM-4221032026-01-24T13:45:25Zjean—chavez1965-06-07UHC-97809-22—(767) 331-3354JEAN.CHAVEZ85@OUTLOOK.COMnull—·nullnull—null
TPATPA-532832026-08-28T09:41:48ZMEGAN—RIVERA12/11/1971-N/A—megan.rivera@yahoo.com4402 Elm StreetSan AntonioTXnullnullUNKNOWN
ENRENR-1381002026-01-15T18:35:00ZMasonFPorter15-02-1965UHC-54272-63•••-••-33349097807963-6442 APACHE BOULEVARD #590San DiegoCA92148GRP-7561·CORE-HMO
TPATPA-617082026-05-03T06:40:30ZTHOMAS—SIMS·1971-03-19—N/A9817131418N/A4750 GRAND AVEOrlandoFL32898GRP-7811null
TPATPA-640832026-01-15T15:05:50ZralphW.··wood19-08-1959-•••-••-0275UNKNOWNUNKNOWN5440 Lake View RdCharlotteNC28250N/A—
ENRENR-1414242026-09-21T22:51:54ZChrisitan—Henry10/11/1946UHC-60838-89•••-••-4678704-399-7321christian.henry@aol.com1252 JEFFERSON AVENUEScottsdaleArizona85203···GRP-5424CORE-HMO
ENRENR-1191352026-07-06T18:50:21ZJeffreyZSilva1991-11-28UHC-10307-66•••-••-2925N/A·jeffrey.silva59@proton.me5130 Elm StLas VegasNevada89199GRP-3627MEDICARE-ADV-A
CLM CLM-417645 2026-02-14T08:14:28ZDiana—Bailey1999-10-21UHC-96404-93—18945819690diana.bailey74@proton.me7001 Central AveSan AntonioTX78246GRP-8968UNKNOWN
PRVPRV-22324 2026-01-12T04:31:52ZAmanda—Peters03-11-1967····N/A928-968-9090-2524 SPRING STMinneapolisMN55488··N/A
TPATPA-616012026-07-06T16:33:59ZAan—Greene1943-11-23null•••-••-5713539.733.1749—9748 OAK STCOLUMBUSOH43243UNKNOWNMEDICARE-ADV-A
CLMCLM-4060542026-06-14T07:56:04Zlaura—perkins28-09-1956UHC-63015-71•••-••-18068206778065··UNKNOWN5448 BASELINE RDMinneapolisMN55493GRP-9529MEDICARE-ADV-B
TPATPA-583892026-01-28T12:15:16ZMrk—Greene1991-10-25N/A—2454801147NULL—UNKNOWNNULL··——UNKNOWN
PRVPRV-202452026-06-27T01:20:30Z·Sofia—Chavez1996-12-23UHC-70365-92--SOFIA.CHAVEZ25@GMAIL.COM3709 Sunset BlvdLos AngelesCA90067null···NAVIGATE-HMO
TPATPA-583232026-04-10T07:04:30ZLarry····Chapman1981-11-16-•••-••-1964—UNKNOWN3349 Union StEDEN PRAIRIEMN55390-1001N/A—
CLMCLM-4014942026-07-01T04:03:17ZSofia—Chen1996-09-25UHC1845222NULL(455) 741-9514SOFIA.CHEN@OUTLOOK.COM7943 Washington StPhoenixAZ85006nullUNKNOWN
100,000 rows, page 163 of 2,000PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:36.705Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty