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
ENRENR-1365902026-01-19T08:32:39ZRyanBLane10/18/1990UHC-41604-71•••-••-5185313.413.8409·ryan.lane@hotmail.com8855 Park PlSeattleWA98134·GRP-9640CHOICE-PLUS-PPO
TPATPA-607872026-08-27T06:05:30ZDouglas—Yang91460825UHC-55719-11—NULLDOUGLAS.YANG@PROTON.ME1930 INDIAN SCHOOL ROADEden PrairieMN·55314N/Anull
ENRENR-1101522026-02-24T23:03:20ZWAYNE—MATTHEWS2002-04-24UHC-65459-63•••-••-9582+1 431 329 0000WAYNE.MATTHEWS13@AOL.COM3219 Desert Sky Boulevard··LOS ANGELESCA··90027GRP-2598CHOICE-PLUS-PPO
CLMCLM-4121092026-06-24T21:12:56ZNunez, Mrailyn—··Aug 16, 1974N/AN/A(489) 716-4544marilyn.nunez64@gmail.com··4466 BroadwayJacksonvilleFL32235·-—
ENRENR-1197272026-07-29T00:03:51ZCheryl—Castro1950-02-04UHC-39022-48•••-••-30394342305814cheryl.castro33@proton.me570 BroadwayPHOENIXArizona85002GRP-7936··CHOICE-PLUS-PPO
ENRENR-1176832026-04-01T10:28:05ZWRIGHTUJOSHUA3019-19-65UHC-71174-31N/A3802215070joshua.wright33@hotmail.com··7265 Desert Sky BlvdChandlerAZ85273GRP-4976NAVIGATE-HMO
ENRENR-1175872026-01-28T12:49:33ZCAMILABSNYDER11/11/51UHC-68703-09•••-••-84593255531780camila.snyder@hotmail.com8443 Valley View Dr··AustinTexas78762GRP-6596CHOICE-PLUS-PPO
ENRENR-1322282026-07-19T07:16:29ZValentina—Kennedy08/06/43UHC-03137-73•••-••-961813525145253valentina.kennedy75@outlook.com5500 Ocean AvenueGlendaleArizona85369GRP-3682SELECT-EPO
CLMCLM-4275792026-08-31T18:12:01ZKatherine—Palmer1982-02-11UHC-33792-42·-13537404409NULL4419 CAMELBACK ROADPlanoTX75047GRP-2288NAVIGATE-HMO
CLMCLM-4315932026-04-17T06:00:54ZYUKI—PAKR2004-04-23UHC-60795-85•••-••-4651--6274 CAMELBACK ROADTampaFL33696·GRP-1341NAVIGATE-HMO
ENRENR-1176492026-09-24T05:52:57ZJohnston, Jason——Jul 21, 1987UHC-86002-96•••-••-1146(965) 565-5802jason.johnston89@hotmail.com5392 HIGHLAND AVESan DiegoCA92102-9254GRP-0375SELECT-EPO
CLMCLM-4119612026-01-01T01:59:08ZAUSTIN····MYERS··25-05-1949·UHC-38620-73—NULL··—UNKNOWN·UNKNOWNnull—N/AUNKNOWN
ENRENR-1227362026-06-18T09:48:48ZRICHARD·NYANG2030-02-05UHC-13935-20•••-••-8422N/ARICHARD.YANG97@YAHOO.COM··5832 Jefferson AveFresnoCA93795GRP-9975·OPTIONS-PPO
CLMCLM-4217592026-02-20T22:50:15ZIsabella—·Kennedy1951-08-10N/AN/A405-236-6527-2989 RIDGE ROADChandler··AZ85217-9042GRP-9841NULL
TPATPA-512482026-01-19T15:20:14ZBenjamin—Greane1994-06-08nullNULLN/AN/A1364 OAK STREETDALLASTX75286GRP-9652MEDICARE-ADV-A
ENRENR-128599 2026-09-22T04:18:47ZKatherineZ.Wilson··1991-03-22UHC6526865•••-••-62395943182924katherine.wilson@yahoo.com··9140 Union StreetNashvilleTN37272GRP-8069SELECT-EPO
ENRENR-1353822026-07-26T08:43:49ZdylaanQsanders··1945-01-11UHC-30628-72•••-••-52387538175011dylan.sanders@aol.com8412 BroadwayMIAMIFL33164GRP-8185··MEDICARE-ADV-B··
CLMCLM-4061762026-05-07T08:33:05ZDENNY··—DAVIS1995-02-16UHC-45986-39—nulldennis.davis16@aol.com1031 Jefferson AveTUCSONAZ—GRP-1625—
TPATPA-540212026-09-24T02:23:15ZSamantha—·Spencer1959-02-23——NULLN/A1630 Lake View RoadDallasTX··75202——
ENRENR-135262 2026-04-15T09:16:02ZAHMED—MURRAY··20050622UHC-20996-25•••-••-7460685-223-6051ahmed.murray6@icloud.com2167 Hillcrest RdAustinTX··78777GRP-1191MEDICARE-ADV-B
ENRENR-1208072026-08-31T08:00:29ZCHARES—WALKER1520-19-52UHC-36240-36•••-••-69474335898997charles.walker32@yahoo.com2543 Oak StOrlandoFL··32828GRP-6625CHOICE-PLUS-PPO
PRVPRV-218642026-01-18T16:34:24Z judithH·collins1940-07-01NULL—803-780-2188-7317 Sage Court #494MinneapolisMN55427null—
ENRENR-1162692026-08-03T09:30:38ZHEATHER··BERRY1949-09-19uhc-91586-85•••-••-0812842.708.4547heather.berry@yahoo.com1192 HILLCREST ROADScottsdaleAZ85284GRP-7481SELECT-EPO··
CLMCLM-4209912026-08-07T10:27:49Zgregory—contrerasOct 4, 1990UHC-39315-75•••-••-17258263552504null5978 MESA DRIVE #834Tampafl33630·GRP-0233NULL
TPATPA-612582026-01-04T12:54:50ZChristina··Campbell1592-12-12—•••-••-6615——·6439 Apache BlvdMiamiFL33141NULL—
CLMCLM-4168852026-09-17T18:41:08ZAisha—Garcia1990-44-27UHC-35298-45NULL(257) 601-1674N/A6404 Union StreetSacramentoCalifornia95876·GRP-6218SELECT-EPO
PRVPRV-247122026-08-16T05:29:51ZCHARLESJ·RAY1951-09-17UNKNOWN-UNKNOWNCHARLES.RAY8@ICLOUD.COM8897 RIDGE RDNashvilletn37227nullUNKNOWN
ENRENR-1018842026-01-13T15:19:45ZALBERT·VCASTRO1982-05-10··UHC-91693-71•••-••-6153(390) 344-3809albert.castro20@icloud.com··3576 Desert Sky BlvdSacramentoCA-GRP-0454medicare-adv-a
CLMCLM-4144592026-10-03T08:20:32ZNoah····Garrett1984-06-17UHC-99638-91UNKNOWN17952268932noah.garrett@yahoo.com3201 Sunset Blvd··Charlotte··NC28246GRP-9539N/A
CLMCLM-4079452026-09-30T21:09:41ZWillie——2000-12-12··UHC-06567-10UNKNOWN2608228641—9015 River RoadMinneapolisMNN/AGRP-3486null
ENRENR-1024732026-05-31T18:00:43Z ·AishaFWeaver10/25/99UHC4571340NULL-AISHA.WEAVER20@HOTMAIL.COM6879 JEFFERSON AVELas VegasNevada89110GRP-6697MEDICARE-ADV-B
CLMCLM-4146052026-08-17T15:48:51ZMarilyn—Hansen19621120————659 BroadwayJACKSONVILLEFL32295GRP-7959CHOICE-PLUS-PPO
ENRENR-1142162026-04-27T22:53:46ZEDWARDYDANIELS1985-10-27UHC-52432-11•••-••-2386334-317-2163edward.daniels97@yahoo.com8035 Central AvenueTampaFL33615GRP-8906MEDICARE-ADV-B
CLMCLM-4033972026-08-14T21:04:32ZJEREMY—MUNOZ1981-41-28UHC-92193-29—(921) 860-2035UNKNOWN1606 CHURCH STEden Prairie··MN55314GRP-0994CORE-HMO
TPATPA-528122026-01-29T01:32:10ZDorothy—Rose1979-11-05null•••-••-0598-—nullN/Anull-··MEDICARE-ADV-A
PRVPRV-289512026-04-28T12:59:57ZWILLIEISIMS19590514N/AUNKNOWN3835495239—3094 Hillcrest RoadPlanoTX75032—OPTIONS-PPO
ENRENR-1352502026-08-24T03:07:19ZJORDAN··—FERGUSON1942-00-69UHC-68665-03•••-••-6251·(325) 491-9247·UNKNOWN6753 SAGE COURTSeattleWA98133GRP-4330MEDICARE-ADV-B
ENRENR-1353032026-05-14T00:08:48ZOMAR—LI··06/27/52UHC-33271-88•••-••-8350—UNKNOWN·2889 Central AvenueMesaAZ85299GRP-0949CORE-HMO
PRVPRV-214922026-06-30T02:44:29ZSTEVENEELLIOTT1998-11-26UHC-18138-25UNKNOWNnullsteven.elliott@yahoo.com8792 Pine DriveGilbertAZ··85241··UNKNOWNSELECT-EPO
CLMCLM-4152142026-09-08T18:52:33ZDOUGLAS—HUNT04-02-1965UHC-18462-40•••-••-8890+1 600 231 6071—··---GRP-2608—
CLMCLM-4309292026-03-20T12:47:40ZJason··—Meyer2002-12-20UHC-71924-51•••-••-1639——412 Canyon RoadLos AngelesCA90053-8732-N/A
CLMCLM-4162102026-03-30T09:11:07ZBarbara—Harris1995-02-21UHC9021348·UNKNOWN260-583-4906NULL5369 Bayshore DrGILBERTAZ85294-CORE-HMO
ENRENR-1139402026-03-03T18:16:11ZRonald—OlsonOct 4, 1939UHC-08656-71•••-••-7809(694) 920-7624ronald.olson@hotmail.com9584 Maple AvenueDallasTX75248GRP-6017CHOICE-PLUS-PPO
CLMCLM-4027802026-06-06T09:37:51ZJohnston····Carol1943-08-12N/A•••-••-4645nullnull130 Elm StreetSeattleWA·98143·UNKNOWN·MEDICARE-ADV-A
ENRENR-1064842026-04-29T05:59:56Z·Owens, GabrielJ—1992-12-11UHC-29998-65•••-••-4763+1 366 665 4353—5073 Desert Sky BoulevardHoustonTX77041-0533GRP-5205NAVIGATE-HMO
TPATPA-576352026-08-28T15:43:20ZMichelle—Walker2003-08-05—•••-••-4987·N/AMICHELLE.WALKER90@YAHOO.COM·NULL—··—NULLCHOICE-PLUS-PPO
CLM CLM-4006082026-09-20T05:55:47ZKenneth—Dunn1950-03-15N/A——····345 Harbor Boulevard #650AtlantaGA30390-2400GRP-4581·MEDICARE-ADV-A
TPATPA-601502026-02-07T10:13:45ZArthur··—·Jimenez2001-02-01N/A•••-••-5083—N/A4586 LAKE VIEW ROADEden PrairieMN55342nullN/A
PRVPRV-237432026-09-20T10:45:05ZCarlos—Howell19780810····•••-••-5055··carlos.howell96@gmail.com5139 Palm DrOrlando··FL32811UNKNOWNMEDICARE-ADV-B
ENRENR-1269212026-08-04T15:05:15ZCharles—Griffin1995-05-22—•••-••-6831370-224-6790charles.griffin25@proton.me3407 Camelback RdHoustonTX77086GRP-2137NAVIGATE-HMO
100,000 rows, page 197 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.721Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty