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-4028062026-07-18T06:24:27ZLaura····Harper1954-08-11—··8494369446··null7036 Lake View RdLos AngelesCA—GRP-6418SELECT-EPO
ENRENR-1147522026-07-13T08:43:32ZSTEPHANIE—TORRES2006-11-14UHC-99975-09•••-••-5765(628) 250-8197stephanie.torres@aol.com3934 FOREST AVEMesaAZ·85295GRP-8647MEDICARE-ADV-B··
CLM CLM-4266292026-01-16T18:44:51ZJACQUELINE—WANG09/15/39UHC-08240-16—NULL—2150 Bayshore DrOrlandoFL32882··NULLSELECT-EPO
ENRENR-1148662026-02-10T12:57:08ZMariaYSngh19870218uhc-25269-47•••-••-2274421.287.6631maria.singh63@yahoo.com3060 LINCOLN WAY··AUSTINTX78790GRP-3973MEDICARE-ADV-B
CLMCLM-4230452026-01-05T20:55:08ZAmy—·Andrews1944-02-27UHC-03390-19•••-••-1802543.688.2075—3903 Bayshore Drive··Jacksonvillefl32265null·SELECT-EPO
ENRENR-1285282026-05-10T09:44:09ZJOHN—ELLIS1967-12-18··UHC-60213-77•••-••-2650(735) 990-2102NULL1681 River RdScottsdaleAZ85221GRP-3614MEDICARE-ADV-A
CLMCLM-4241092026-04-24T22:37:09ZOmar····Ferguson11/04/50·-····7145674UNKNOWN7551 Harbor BlvdLos AngelesCA90022GRP-3486MEDICARE-ADV-B
CLMCLM-4213652026-03-18T06:25:49ZSantiago, Lori——02/12/1993UHC-83318-54•••-••-13584878488971-3583 Hillcrest RdTempeAZ85206N/ASELECT-EPO
TPATPA-502312026-06-18T00:50:04ZMarthaAMartinez1965-11-09UHC7158561•••-••-6977NULL··4824 Maple AveScottsdaleAZ85261GRP-5586NULL
TPATPA-578182026-01-22T13:01:05ZBrandonI.Bell·12/08/55N/A—(925) 767-8922····—NULL—N/A-NAVIGATE-HMO
CLMCLM-4318882026-08-16T19:56:16ZDiiego—Evans1964-06-28N/A•••-••-06904486606449NULL5946 Mountain View DrEden PrairieMinnesota55392-0605GRP-4590OPTIONS-PPO
CLMCLM-4178742026-10-18T18:44:19ZAlexander—Reid1978-02-16UHC-77022-69—5743413426—4432 Lake View RdAustinTexas78712GRP-0718·MEDICARE-ADV-B
PRVPRV-210002026-01-15T12:19:14ZTerry—Padilla07/25/1940UHC-74052-85•••-••-90573276196347—5031 Camelback RdPlanoTX75003-NULL
ENRENR-1306532026-02-10T15:16:54Z·Madison—Hawkins··1950-04-28·UHC-18827-80•••-••-2626636-543-2404madison.hawkins@hotmail.com3643 Forest Avenue Apt 20GilbertAZ85231··GRP-7551MEDICARE-ADV-B
CLMCLM-4014332026-08-09T19:02:46ZSOPHIA—PIERCE1973-09-32·UHC-04501-42•••-••-621614766693777sophia.pierce@outlook.com6744 DESERT SKY BLVDGlendaleAZ85382nullSELECT-EPO··
CLMCLM-4089312026-05-16T20:19:49ZKevin—Powell1944-02-06nullnull14584483116·null8193 UNION STTucsonAZ85762N/AUNKNOWN
PRVPRV-228292026-03-28T00:20:26Zaisha······mason2002-10-17UHC-99034-92—(411) 670-5178··aisha.mason26@outlook.com5568 Hillcrest RoadSan DiegoCalifornia·92148—null
TPATPA-615742026-04-09T09:17:48ZANNA—PAYNE··11/27/1966nullN/A——3257 Market St #795AustinTX78786··-—
ENRENR-1054262026-08-06T17:46:10ZJckD.Lopez1939-01-02UHC-39912-26null4199459800null6158 CEDAR LNAustinTX78782GRP-0733NAVIGATE-HMO
CLMCLM-4107912026-09-11T17:45:55ZLuciaFEdwards1970-06-17UHC-42348-35··•••-••-5585(437) 475-1530—6382 JEFFERSON AVEDALLASTX75299GRP-0152MEDICARE-ADV-B
TPATPA-628652026-06-12T14:25:42ZWood, Roy——1950-08-01—N/A765-575-4581—5991 Church St #616SacramentoCA95881—UNKNOWN
TPATPA-57271 2026-09-30T21:08:18ZRonald—Rojas1943-10-01N/A—·-N/A6395 Valley View DrMiami·FL33199GRP-0179NULL
ENRENR-1172892026-03-21T12:56:59ZTIMOTHYSSTONE1970-03-26UHC-35791-77•••-••-0650·2627238203timothy.stone@gmail.com1872 Ridge RoadChandlerAZ85237GRP-5255CHOICE-PLUS-PPO
ENRENR-1028592026-09-21T14:27:12ZMaryC·Ward1948-03-13UHC1762599•••-••-26879532774··mary.ward70@hotmail.com4346 Indian School RoadHoustonTX77059·GRP-6967CHOICE-PLUS-PPO
PRVPRV-224322026-02-22T16:57:44ZMateoKClark2006-01-06N/A-(857) 465-9904mateo.clark7@aol.com399 MESA DR Apt 29ScottsdaleAZ85204nullNULL
CLMCLM-4196232026-03-23T19:27:31Z Logan··—Jacobs1/17/2008UHC-61833-29•••-••-8554410-245-8437—1439 Church StreetGilbertAZ85242GRP-9465CHOICE-PLUS-PPO
ENRENR-1033812026-08-05T03:22:49ZTorres, DonnaG—10/11/1981UHC-70484-11•••-••-80649959668DONNA.TORRES70@PROTON.ME8447 Willow Court Apt 11·Orlandofl32879-2412GRP-8174NAVIGATE-HMO
ENRENR-1026942026-06-04T05:13:00ZKELLYV.EVANS19900711UHC-53747-07•••-••-8327876.587.3832kelly.evans@hotmail.com2275 MEADOW LANEFresnoCalifornia93780·GRP-4875medicare-adv-b
ENRENR-1008182026-01-31T22:16:10ZMarcus—Hall1946-12-15UHC-89525-68NULL654-763-0255marcus.hall@aol.com2861 MAPLE AVENUETucsonAZ85712GRP-3315··CHOICE-PLUS-PPO
CLMCLM-4034312026-07-02T15:47:22ZHannah—Marquez1994-04-08UHC-08190-39•••-••-215714044465148hannah.marquez18@gmail.comN/A—NULL-·GRP-9297medicare-adv-b
CLMCLM-4041382026-08-04T21:10:53ZWillie·VSchmidt5/12/1942··UHC-28576-15•••-••-6299UNKNOWNUNKNOWN446 Maple AveHoustonTX77030GRP-7830medicare-adv-b
CLMCLM-4212762026-05-13T13:27:49ZJANETEBROWN1939-08-23N/A-——nullnull—N/AGRP-5902—
TPATPA-508692026-07-31T03:14:54ZArthurMGrant··23-10-1960N/AN/AUNKNOWN·UNKNOWN1067 Pine DriveMIAMIFL33114——
CLMCLM-4222052026-08-08T06:08:25ZKEVIN—REYESApr 9, 1938UHC-54672-04•••-••-7373571-647-8007—172 Sage CtSeattleWA98171GRP-9023SELECT-EPO
CLMCLM-4030612026-06-24T08:32:50Z JuanSSilva1974-10-08UHC-07687-33-UNKNOWN··—5111 Mountain View DrLas VegasNV89175GRP-8527CHOICE-PLUS-PPO
TPATPA-597832026-02-16T23:34:09ZHenry—Burtn11-07-1978null-+1 645 843 5996UNKNOWN1268 Cedar LaneCHARLOTTE··nc28206UNKNOWNCORE-HMO
ENRENR-1381392026-02-12T17:09:06ZPhilipNGarrett04/13/98UHC-73051-83•••-••-9985316.385.0943philip.garrett@yahoo.com2283 MARKET STREETAtlantaGA30375GRP-9744MEDICARE-ADV-B
ENRENR-1176602026-07-17T11:10:52ZMyers, DoorthyO.—1983-07-22UHC-06278-26•••-••-052012969997738dorothy.myers42@gmail.com8147 HARBOR BOULEVARDHoustonTexas77041GRP-0502CHOICE-PLUS-PPO
ENRENR-1357092026-03-14T19:27:16ZMICHELLE—SOTO06/18/1948UHC7179495···(459) 671-5037michelle.soto@proton.me4713 Lincoln WayScottsdaleaz85295-0692GRP-8018NAVIGATE-HMO
CLMCLM-4106722026-04-26T03:55:38ZJeffrey—·SimmonsMar 8, 1977UHC-64891-47•••-••-97668809483626—6175 RIVER ROADTEMPEArizona85240GRP-1847MEDICARE-ADV-A
ENRENR-1072752026-10-06T10:33:27ZNATHANKTUCKER1982-07-18UHC-69609-12•••-••-4480505.895.5843nathan.tucker@proton.me573 UNION STREETHoustonTX77009GRP-4582NAVIGATE-HMO
ENRENR-1245502026-07-12T09:50:38Z AndreaQContreras2003-07-26UHC-43923-96•••-••-50044053634910ANDREA.CONTRERAS@PROTON.ME2966 MARKET STREETDenverCO80210GRP-4492NAVIGATE-HMO
ENRENR-122443 2026-01-21T19:24:43ZChristina—Hamilton10/13/1958UHC-45758-40•••-••-6795297-545-2179christina.hamilton@aol.com5486 Willow CtMinneapolisMinnesota55484··GRP-6072CORE-HMO
ENRENR-1030322026-07-28T21:49:07ZABBYWELLIS·1967-06-11UHC-68582-42•••-••-4346(542) 430-4509abigail.ellis@aol.com4371 CAMELBACK RDAustinTX78766GRP-3899CORE-HMO
ENRENR-1057892026-04-29T10:36:09ZAlexis·VDay··1997-09-07UHC-68769-03•••-••-3017648-220-9403ALEXIS.DAY67@OUTLOOK.COM5370 Ocean AveSan AntonioTX78239GRP-2995OPTIONS-PPO
CLMCLM-4017672026-07-23T12:36:20Z JUAN—OLSON07/18/1972UHC-11468-94null4134918263—8046 SPRING STREETCharlotteNC28286GRP-4024CHOICE-PLUS-PPO
ENRENR-1374982026-06-22T21:32:51ZKENNETHP.VALDEZ1947-10-28UHC-39425-26•••-••-308313699945930kenneth.valdez@proton.me9128 Ridge RdSacramentoCA95804GRP-2317NAVIGATE-HMO··
ENRENR-1307902026-10-12T19:45:23ZReyes, TheresaZ—1943-03-20UHC-09610-32•••-••-0937747.573.6121··—NULL—NULLGRP-1001CORE-HMO··
ENRENR-1356092026-04-14T01:35:09Z EVELYN X—GARZA2000-07-13UHC-78260-67··•••-••-4545757.999.6738evelyn.garza@proton.me7059 Sage CourtCOLUMBUSOH43272GRP-3689CORE-HMO
ENRENR-1274952026-08-30T16:50:09ZMeganU·Young12/18/48UHC-21896-85•••-••-6881718-571-6491UNKNOWN2273 Park PlGlendale··AZ85302GRP-6611OPTIONS-PPO
100,000 rows, page 248 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.749Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty