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
CLM CLM-4165902026-07-10T16:17:40ZEvelyn··GBakar1953-06-08UHC-01180-54•••-••-4683N/AN/A2621 Union StreetColumbusOHNULLUNKNOWNCHOICE-PLUS-PPO
ENRENR-1084652026-04-24T11:02:04ZBRIANEFLORES2001-06-10UHC-95145-33•••-••-4123+1 256 622 8454-438 BASELINE ROADTucsonAZ85741GRP-2096MEDICARE-ADV-A
TPATPA-58943 2026-04-21T23:10:11ZRachel—Palmer1964-11-16—•••-••-2767——6979 Lake View RdNashvilleTN·37204UNKNOWN—
CLMCLM-4242442026-09-01T03:59:08ZJUDITHX.SNYDER1983-01-13null··—UNKNOWN—7887 Bayshore DrMesaAZ85282—null
PRV PRV-271212026-07-16T04:42:34ZRussell····Hudson1991-72-26UHC-77582-79•••-••-2290(853) 923-0202N/A2756 Washington StreetSan AntonioTX78297—UNKNOWN
ENRENR-1346452026-09-25T08:31:57Z·ZacharyVSullivaan1967-01-19UHC-50266-48•••-••-1551628.974.6065ZACHARY.SULLIVAN@ICLOUD.COM7407 Valley View Drive·AtlantaGA30306GRP-8439·MEDICARE-ADV-B
ENRENR-1352682026-10-02T08:58:30Zkimberly—fox1899-06-07UHC-78140-79··•••-••-62228758928832—3661 Bayshore DrHoustonTX77087·GRP-8691CHOICE-PLUS-PPO
ENRENR-1215052026-01-24T08:55:34ZJamse, DeborahK····12/13/1944·UHC-46277-47•••-••-4403523.307.4985UNKNOWN335 Indian School RoadTempeAZ·85285GRP-6563NAVIGATE-HMO
TPATPA-641892026-06-06T05:34:15Z·DIANA—MENDEZ··1939-03-19-NULL(318) 301-3203diana.mendez@outlook.com4576 Canyon RoadSacramentoCA95815GRP-4666—
ENRENR-1026032026-02-02T15:36:26ZLINDA—CRAWFORD··1993-12-72UHC-89035-43•••-••-7378+1 554 527 9805··LINDA.CRAWFORD27@PROTON.ME·8402 Washington StDENVERCO·80274GRP-8871OPTIONS-PPO
CLMCLM-4319772026-04-01T03:39:22ZSAMUEL—RAY·10/1/1998UHC-71219-67•••-••-44633219583527samuel.ray85@outlook.com9124 Spring StCharlotteNC28299GRP-1035MEDICARE-ADV-A
ENRENR-1239792026-04-20T18:45:41ZRussellORobinson19600326UHC-60313-10•••-••-69592680438N/A4046 LAKE VIEW RDEden PrairieMN-GRP-8119MEDICARE-ADV-B
ENRENR-1321462026-08-09T15:35:34ZMaryHNguyen1990-03-12UHC-55840-85•••-••-3127NULL··mary.nguyen@icloud.com7858 River RoadLos AngelesCA-GRP-1321SELECT-EPO
CLMCLM-4203392026-01-15T09:50:40ZArjun··Woods2005-05-15··UHC-68559-43•••-••-66507995572816-——-nullGRP-6493OPTIONS-PPO
ENRENR-1422132026-07-13T21:41:51ZFrank—Owens1799-11-28UHC6684215NULL(277) 732-1620frank.owens87@yahoo.com7234 Washington StreetSacramentoCA95800GRP-6496NAVIGATE-HMO
ENRENR-1081962026-06-16T20:04:27ZTimothy—FloresOct 14, 1980uhc-53330-02•••-••-4130—null2143 Apache BlvdGlendaleAZ·85350GRP-0638MEDICARE-ADV-B
CLMCLM-4142782026-01-18T02:39:01ZZACHARY—WATKINS03/15/1962—•••-••-2958—N/A9266 Ridge RoadAtlantaGA30322GRP-9913MEDICARE-ADV-A
CLMCLM-4302312026-03-01T04:33:12ZNATALIE—JOHNSTONMar 3, 1963UHC-51311-29•••-••-4577427.855.6740NULL2698 Elm StAtlantaGA30306GRP-7216CHOICE-PLUS-PPO
PRVPRV-283272026-03-29T04:20:07Z Evelyn—Simpson01/11/1979UHC-33527-89—338-612-9001-6787 FOREST AVEDallasTX75241nullnull
CLMCLM-4194622026-06-03T10:52:51ZNathan—Day1974-08-11UHC-96207-66NULL9135715049UNKNOWNNULL-··UNKNOWN—N/Anull
ENRENR-1109692026-08-26T12:47:50Z DEBRAS.GUERRERO—UHC-79292-33•••-••-0578(465) 800-6169··6541 Willow CtPlanoTX75018GRP-5085NAVIGATE-HMO
CLMCLM-4090802026-09-19T11:26:47ZROBERTNTRAN1978-03-12UHC-15067-68•••-••-7900——-UNKNOWNnull—-null
CLMCLM-4211782026-01-02T10:34:27ZWillieK.Le··1709-19-96UHC-73240-85•••-••-2921(572) 518-4926———null····GRP-6191CHOICE-PLUS-PPO
PRVPRV-263542026-06-04T11:15:33ZKIMHHARVEY19600128UNKNOWN··null3391567UNKNOWN1939 Palm DriveMiamiFL··33153-8600UNKNOWNNULL
CLMCLM-422854 2026-08-27T22:06:45ZBetty—Fox19670904UHC-83505-18•••-••-5512-UNKNOWN6071 Grand AvenueNashvilleTN37213-OPTIONS-PPO
CLMCLM-427011 2026-03-21T16:37:42ZJoe—Dean12/13/2006UHC-39253-08—589.841.2283null-NULL—-GRP-0792··CORE-HMO
TPATPA-616732026-10-03T15:59:16ZRios, Kevin——19850320··null—248-201-6127—-NULL———NAVIGATE-HMO
CLMCLM-4108302026-05-10T04:00:22ZStevenNGreen2007-05-26UHC-83463-90UNKNOWN9166339086—N/ANULLnull··—GRP-8644MEDICARE-ADV-B
CLMCLM-405150 2026-09-26T14:33:52ZMARILYN··MUNOZ08-07-1944—··nullN/A··———··UNKNOWN·NULL
TPATPA-50852 2026-05-25T02:10:37ZWALTER—PALMER19791215N/AUNKNOWN··799-749-6707····——NULLN/Anull—
CLMCLM-4325792026-02-25T06:28:48ZZachary—Mitchell1987-08-27UHC-77378-20UNKNOWN··UNKNOWN—5449 Jefferson AvenueCharlottenc·28278nullnull
TPATPA-548272026-07-05T10:17:22ZMatthew—Harper11/8/1987UHC-68492-17--—1568 Central AveGILBERTAZ85224GRP-8757···MEDICARE-ADV-A
CLMCLM-4243192026-08-31T19:25:08Zisabella—carter1997-09-23·UHC-24455-27—nullNULL1199 Park Place·MESAAZ85206N/ACHOICE-PLUS-PPO
CLMCLM-4107872026-09-10T21:41:55ZMarilynGReyes·Mar 28, 1964UHC-39493-80———NULL-NULL—GRP-5783SELECT-EPO
CLMCLM-4017472026-04-09T05:50:29ZSAMATNHA—CONTRERAS1946-02-09uhc-40230-62N/A····N/A9591 BroadwayGlendaleAZ85316GRP-6198CHOICE-PLUS-PPO
ENRENR-1264932026-04-09T02:30:42ZGerald—Hayes1989-05-12UHC-56156-16•••-••-7649-—6065 Oak StreetCHARLOTTENC28248GRP-2290MEDICARE-ADV-B
CLMCLM-4078632026-07-08T01:23:47ZPETER—·MILLS2005-05-05·UHC-45739-09-231-707-1599N/A351 Central AvenueSacramentoCA·95881—OPTIONS-PPO
CLMCLM-4028442026-04-22T21:26:59Z·Chavez, WillL.—2002-04-28UHC-79231-34··—NULL-8109 VALLEY VIEW DRIVEMinneapolisMN55491UNKNOWNSELECT-EPO
ENRENR-1040232026-08-01T05:39:29ZWillie—Johnson2000-09-26UHC-99714-66•••-••-9105(355) 268-6917-7432 CENTRAL AVENUEHoustonTX77081GRP-7785CHOICE-PLUS-PPO
ENRENR-1156652026-07-18T08:14:01ZDinaa—Santiago12/23/1970···UHC-54379-94•••-••-0741243-213-6066DIANA.SANTIAGO@HOTMAIL.COM9561 Canyon RdLos AngelesCA··90098GRP-1892CORE-HMO
PRVPRV-218402026-05-10T14:50:36ZCruz, Emily··——2006-02-24-—·737-647-5456N/A9514 Spring StMesaArizona85245N/A—
TPATPA-540242026-10-18T21:14:15Z·Phillips, Joan——04/28/45··NULL—682-682-9052-1773 Mesa DrAustintx78782-8178—MEDICARE-ADV-A
TPATPA-593892026-02-09T03:14:55ZAlan—Lynch1993-06-03··N/A•••-••-3315·N/AN/A-NULL-null—NULL
ENRENR-1199682026-01-17T20:44:39ZJudith—Gutieerrez1991-04-19UHC5956029•••-••-0185—JUDITH.GUTIERREZ@ICLOUD.COM2662 Indian School RoadTempeAZ85255GRP-3070OPTIONS-PPO
TPATPA-601772026-06-22T22:41:17ZRYANU.SOTO··2002-11-11··UNKNOWN•••-••-8728-N/A8891 UNION STTempeAZ85233·GRP-0921null
PRVPRV-252372026-10-10T08:33:25ZSophia—Harrison1964-02-25null—881.482.5729NULLNULL-N/AN/A—MEDICARE-ADV-B
ENRENR-1115182026-08-18T08:06:00Z Yuki—Payne1981-03-02·UHC-49250-28•••-••-5277(478) 969-2520yuki.payne99@outlook.com348 Maple AvenueNashvilleTN37245GRP-8796MEDICARE-ADV-B
ENRENR-1232752026-05-12T20:54:56Z SANTIAGO—BANKS1990-09-21UHC-04409-41•••-••-5224·5467618163santiago.banks@icloud.com1347 Mesa DrColumbusOH43222GRP-9887NAVIGATE-HMO
ENRENR-1214032026-08-15T13:59:11ZChristianY.Castillo10/17/73UHC9789844•••-••-82446993727418CHRISTIAN.CASTILLO@PROTON.ME5226 Mountain View DriveSan DiegoCA92123-3124GRP-1516MEDICARE-ADV-B
PRVPRV-226672026-04-01T13:38:17ZDoris—Stewart1968-03-04UHC-07596-64-619-451-1077—5776 Sage CourtMinneapolisMN55480··N/AN/A
100,000 rows, page 32 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:34.768Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty