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
TPATPA-628712026-09-16T16:24:19ZJose—Jensen1939-09-04NULLUNKNOWN-NULL4470 CHURCH STMesaAZ85243—NULL
CLMCLM-4307952026-05-18T23:44:28ZBrittanyEWells2001-01-14··UHC8752364UNKNOWN8825068brittany.wells38@hotmail.com1690 JEFFERSON AVEAustinTX78737—options-ppo
ENRENR-1076862026-10-05T14:15:31ZLindaNWashington1995-04-16UHC-27369-86•••-••-3376(446) 694-0620——N/ANULL-GRP-0130CORE-HMO
PRVPRV-291312026-01-24T05:02:12Z BruceTGarrett07/12/62UHC-64079-01•••-••-0032——383 CENTRAL AVEMiami·FL33114-6005-OPTIONS-PPO
TPATPA-602722026-05-15T23:29:39Z SarahZ.Guzman··Sep 6, 1994UNKNOWN•••-••-8406null—2359 Canyon RdMinneapolisMN55417UNKNOWN—
CLMCLM-4259612026-07-03T18:32:34ZEllis, Martha——1988-04-26UHC-36344-06N/A··-N/A6810 Grand AvenueDenverCOnullGRP-6716null
ENRENR-1310452026-02-08T04:27:23ZWEI—POWELL1941-11-23UHC-98037-52•••-••-2857+1 715 428 7219WEI.POWELL22@GMAIL.COM4446 Indian School Road·PlanoTX75069GRP-8084SELECT-EPO
ENRENR-1260762026-10-17T13:05:05ZLauren—Vasquez08/26/1966UHC-24175-19•••-••-5155+1 286 849 2167lauren.vasquez@outlook.com7678 Grand AvenueTempeAZ85274GRP-9262MEDICARE-ADV-A
TPATPA-610342026-06-14T10:03:28ZMEI—BAILEY11/9/1966UNKNOWN—·5165565888—1353 DESERT SKY BLVDTampaFL33632—UNKNOWN
ENRENR-1074612026-08-10T03:09:12ZmariaJmejia01/27/1941UHC-10112-07•••-••-7261(377) 898-9096maria.mejia11@gmail.com3535 Market StSan Diego··CA92117GRP-6977CHOICE-PLUS-PPO
CLMCLM-4127022026-02-02T04:50:20Z·Alexander, AbbyU—1940-03-04——······6190 Indian School RdAtlantaGA30392-5971··—MEDICARE-ADV-B··
CLMCLM-4038752026-07-04T18:57:06ZAdams, Denise··—2001-05-06UHC-45015-90UNKNOWN16419711157-4206 Lincoln WayColumbusOH43262GRP-4502null
CLMCLM-401419 2026-08-10T08:33:21ZPRIYA—LI1944-12-01UHC-86490-50N/A··819-622-1582-9388 CENTRAL AVENUEChandlerAZ·85242GRP-3873OPTIONS-PPO
ENRENR-1030442026-03-14T07:26:15ZMatthew—Allen1989-07-11UHC-24160-93•••-••-2517230.651.5265UNKNOWN558 Forest AveEden PrairieMN55396·GRP-6800NAVIGATE-HMO
CLMCLM-4009262026-08-28T14:24:38ZChen, PriyaF.—03-03-1999-··•••-••-4709-—6678 Ridge Road··NashvilleTN37262UNKNOWNN/A
ENRENR-1345262026-01-16T22:40:13ZMARIANAP.HAMILTON05/16/63UHC-80048-60•••-••-4189(858) 335-8665MARIANA.HAMILTON@GMAIL.COM5035 River RoadDenverCO80290GRP-5705SELECT-EPO
CLMCLM-4064512026-09-03T18:47:45ZSOPHIA—MARQUEZ19860901—UNKNOWN··nullN/A8540 Market StreetSan AntonioTX78292UNKNOWNNAVIGATE-HMO
CLMCLM-4174022026-05-08T20:29:32ZDonna—Alverez1998-03-26UHC-21436-41N/AN/ANULL—nullUNKNOWNN/AGRP-2130-
CLMCLM-4103602026-05-12T22:17:30ZAhmed—Riley2007-03-13-—NULLUNKNOWN5024 Hillcrest RdJacksonvilleFlorida—GRP-6391······
PRVPRV-257132026-04-11T00:06:00ZWalter Y··Richards1971-02-20-NULL567-615-4464walter.richards@outlook.com1942 Highland AvenueChandleraz85251—NULL
CLM CLM-4111892026-08-03T09:55:09ZDOTTRICHARDSON1948-07-07·UNKNOWN——·N/A9509 INDIAN SCHOOL RD Apt 35CharlotteNC28278-2184GRP-6886—
TPATPA-622722026-04-20T17:30:35Zaustin—gibson01/01/85NULL———8410 SAGE CTSEATTLEWA98137··GRP-3037OPTIONS-PPO
ENRENR-1358592026-02-26T23:29:08ZSophiaGRivera1983-06-15UHC-90624-07•••-••-9357644-932-9611SOPHIA.RIVERA69@PROTON.ME8091 BroadwayGilbertAZ85228-6766GRP-3434NAVIGATE-HMO
ENRENR-1363822026-05-31T02:51:13Zwayne—colman1988-03-06UHC-59222-88•••-••-7500UNKNOWNwayne.coleman1@proton.me178 Union StreetAustinTX78770GRP-7725NAVIGATE-HMO
PRVPRV-248662026-03-26T23:15:41ZJean—Vega19941010UHC-31783-01N/A512.981.5459··276 Market StLos AngelesCA90082—UNKNOWN
ENRENR-1355492026-06-15T06:01:59ZBetty—Graham1992-12-20UHC-83929-04•••-••-6824(558) 422-2148··betty.graham67@icloud.com2502 Spring StreetGilbertArizona85228·GRP-9694SELECT-EPO
TPATPA-590622026-06-02T15:23:17ZCarlosSSchmidt1942-01-28N/A—6087291157—886 RIDGE ROAD Apt 3AtlantaGAnullGRP-0935OPTIONS-PPO
ENRENR-1202352026-05-27T08:38:11ZKennethKKennedyJul 3, 1997UHC-75623-35—563.866.6962—2830 Valley View DriveMinneapolis·MN55413GRP-6252MEDICARE-ADV-B
ENRENR-1377072026-06-24T05:32:14Z·DEBRA—LANE1964-09-16UHC4772991•••-••-059214969140218··DEBRA.LANE@PROTON.ME8702 Sage CourtMIAMI·FL33167GRP-1881NAVIGATE-HMO
ENRENR-1299832026-03-28T21:11:59ZAmed··—Murray1969-10-08UHC-25565-57•••-••-2365215-298-4239AHMED.MURRAY@YAHOO.COM8022 Lincoln WayAtlantaGeorgia30353GRP-8537OPTIONS-PPO
CLMCLM-4150962026-03-23T21:20:04ZRobertZDominguez1993-01-23UHC-72381-88•••-••-3805——··—UNKNOWN—UNKNOWNNULL
ENRENR-1241102026-03-13T21:27:19Zjuan—perez1986-11-07UHC-24176-23•••-••-22607855519171NULL8445 Apache BoulevardTucsonAZ85791GRP-3081CORE-HMO
ENRENR-1115862026-09-13T16:34:00ZOmarGLi1996-07-21UHC-18128-45•••-••-1976657-529-1530OMAR.LI@ICLOUD.COM·1345 Oak StSan DiegoCA92195GRP-1788select-epo
CLMCLM-4079592026-03-26T14:49:41ZBEVERLY—GONZALES1944-03-03UHC-28012-85N/AUNKNOWN—7684 HARBOR BOULEVARDCOLUMBUSOhio43247——
ENRENR-1290412026-01-19T01:06:51ZPAUL··F.ROMERO11/27/71UHC-28842-64-3842538140paul.romero12@proton.me8261 Harbor BoulevardMiamiFLUNKNOWNGRP-3479MEDICARE-ADV-B
ENRENR-1168822026-08-08T13:22:20ZAlexanderVWashington1964-11-02UHC6307977•••-••-3901(530) 220-8911alexander.washington69@gmail.com1654 Oak StSacramentoCA95827··GRP-9692OPTIONS-PPO··
ENRENR-1066972026-05-11T11:42:06ZJonathanPBell1988-02-22UHC-75396-89··•••-••-78906559020671jonathan.bell@gmail.com4740 Forest AvenueSACRAMENTOCA—GRP-4406MEDICARE-ADV-A
CLM CLM-4204412026-08-17T02:40:09Z·Omar—AllenJul 16, 1997null•••-••-42917754676155—5570 Lincoln WayCharlotte·NC28298-5859GRP-7033N/A
CLMCLM-4294662026-03-15T22:50:30Z CAROL—TURNER19880604UHC6610225··UNKNOWNCAROL.TURNER@HOTMAIL.COMnullN/AN/A—UNKNOWNSELECT-EPO
ENRENR-1340602026-02-02T01:36:40ZSophia—Wheeler06/08/1999UHC-19164-05•••-••-7337(558) 307-9320—6232 BASELINE ROADTAMPAFlorida33631GRP-3601SELECT-EPO
CLMCLM-4205892026-05-11T04:59:18ZEmma—Sanderrs1948-08-06UHC-54455-12•••-••-7756-emma.sanders@outlook.com6865 Sage CtNashvilleTN37297GRP-1150CHOICE-PLUS-PPO
ENRENR-1138882026-07-24T19:44:06ZCunninghem, Terry····—10/11/66UHC-72436-57•••-••-4968661-842-1003NULL1040 Baseline RdAustinTX·78784GRP-3925MEDICARE-ADV-B
ENRENR-1077252026-04-11T00:45:26ZNancy—Stephens··2007-05-08UHC-48987-01•••-••-0376UNKNOWN—5003 Pine DriveSan DiegoCA92149-9065GRP-1328··MEDICARE-ADV-B
ENRENR-1048032026-10-04T06:39:23ZCHARLOTTE—LARSON1966-06-23UHC-19304-02•••-••-1067+1 705 553 2353charlotte.larson@proton.me368 Sunset BlvdScottsdaleAZ85235GRP-8615NAVIGATE-HMO
ENRENR-1189332026-02-11T02:24:30ZWilliams, Joan——2007-11-03UHC-24622-43—765-985-3593joan.williams@yahoo.com8522 Jefferson AveOrlando·FL32821GRP-1611OPTIONS-PPO
TPATPA-599652026-02-07T06:52:19ZHANNAH—WHITE1953-06-08UHC-97230-82—null—4277 PALM DREden Prairie··MN55368—·SELECT-EPO
PRVPRV-219682026-04-12T23:21:25ZKennethR.Hunter1970-02-17UHC-04666-05NULL431-596-8454null7067 INDIAN SCHOOL RDFresno··CA93789null-
ENRENR-1038062026-09-30T16:01:21ZKatherine—Hudson1980-02-02UHC-30420-12—+1 575 602 0543KATHERINE.HUDSON81@PROTON.ME4697 Sunset BoulevardSAN ANTONIO·TX·78269GRP-5815MEDICARE-ADV-A
CLMCLM-4031792026-02-05T10:52:47ZROY—RAY1946-07-24UHC-74378-53NULL—roy.ray@aol.com176 Central AvePHOENIXaz85055GRP-8588SELECT-EPO
PRV PRV-258552026-03-17T01:58:21ZRIOS—MAOSN1939-11-04UHC-42367-40·N/A····MASON.RIOS79@PROTON.ME2850 Valley View Dr··TampaFL33690null—
100,000 rows, page 231 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:37.737Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty