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-1320762026-08-11T01:38:24ZBradley·QBanes01/18/86UHC-02728-80-6305500274-1932 Spring St··GlendaleAZ85338-6697GRP-7501OPTIONS-PPO
ENRENR-1202302026-08-10T16:44:48ZPriya—Berry19580707null··•••-••-7384-priya.berry@gmail.com6745 Elm StreetCHANDLER··AZ85274GRP-1129OPTIONS-PPO
CLMCLM-4166892026-07-08T13:33:44ZHeattherX.·George10/5/2008—N/A3808845622·NULL—NULL····null—UNKNOWN
CLMCLM-4082672026-02-08T18:18:14ZjordanY.richards09/09/1950··UHC-06514-86•••-••-1817--327 MAIN STJacksonvilleFL32256·-N/A
ENRENR-1192072026-01-07T20:35:35ZDenise—Roberts1972-02-15UHC-19669-31•••-••-2149(807) 573-6788-5846 Indian School RdHoustonTX77037GRP-7357navigate-hmo
ENRENR-1024922026-03-08T11:26:44ZgloraQmeyer1988-01-23UHC2546017•••-••-90045222390186—8279 Willow CtDALLAS··Texas75212-0319GRP-2859MEDICARE-ADV-B
ENRENR-1390722026-05-19T11:04:17ZGRACE—GARZA11/10/02UHC-70601-88•••-••-2744(900) 658-2811—7828 Maple AvenueCHANDLERAZ85281GRP-7839CHOICE-PLUS-PPO
CLMCLM-4285852026-07-22T04:15:46ZWayen—DunnSep 20, 1981UNKNOWN•••-••-0207(454) 671-3779··N/A2552 WILLOW CTSacramentoCA95878··UNKNOWNNAVIGATE-HMO
ENRENR-1339192026-02-17T11:54:03ZMegan—Allen1946-09-15UHC-94421-04•••-••-28264885583995megan.allen@yahoo.com3172 Central AveSan DiegoCA··92182GRP-9282MEDICARE-ADV-A
PRV PRV-295822026-04-12T18:49:14ZDoris—Meyer20-12-1960-NULLN/A—7944 Valley View Drive Apt 25PLANOTX75036-NULL
TPATPA-502792026-06-06T23:41:44ZEmma—Rogers2001-11-18—•••-••-3030NULLUNKNOWN6134 Lincoln WayPhoenixAZ85048-UNKNOWN
ENRENR-1165002026-05-21T14:40:55ZSOFIA·A.RIOS2005-02-03UHC-29478-20•••-••-0389+1 493 244 4921·SOFIA.RIOS61@AOL.COM9897 UNION ST·SeattleWA98134·GRP-4887navigate-hmo
CLMCLM-4194352026-01-15T16:45:40ZJonQSilva05/10/06—•••-••-5928-··8190 Cedar LnFresnoCA93752·GRP-5471MEDICARE-ADV-B
CLMCLM-4114992026-08-09T22:43:13ZJack—Clark1957-06-05null•••-••-8758641.523.5981—6822 HARBOR BOULEVARDAtlantaGA30388UNKNOWNCHOICE-PLUS-PPO
ENRENR-1293622026-08-15T06:53:41Z ABIGAILESANDERS1975-03-11UHC-08668-77•••-••-07734526986abigail.sanders@yahoo.com9314 Baseline RoadTucsonaz85746GRP-2097SELECT-EPO
CLMCLM-4304352026-05-25T11:57:00Z KATHLEEN S—MOORE1989-12-27UHC-75963-29null433.997.6390UNKNOWN6354 Sage CtSan DiegoCA92109GRP-0536MEDICARE-ADV-A
PRVPRV-274642026-03-29T04:42:41ZBetty—Watkins1994-07-17UHC-83199-38—(393) 203-5504betty.watkins@gmail.com6891 Palm DriveTempeAZ85286-5833UNKNOWNN/A
TPATPA-531362026-01-29T18:11:04ZJose—Kim20000408··NULL··-N/A-7840 RIVER RDEden PrairieMinnesota55338-N/A
ENRENR-1175552026-03-20T04:33:35ZLuisOPeters12/1/2000UHC-99143-52•••-••-46276960258LUIS.PETERS35@GMAIL.COM4568 Cedar LnAustinTX78737GRP-6989CHOICE-PLUS-PPO
ENRENR-105172 2026-01-03T11:47:34ZShirleyWHerrera26-02-1993UHC-42017-70—(571) 972-8607shirley.herrera57@outlook.com8706 Baseline RoadFRESNOCA··93701GRP-9507MEDICARE-ADV-A
CLMCLM-4211082026-04-17T14:35:01ZDENNISNPARK1948-06-15UHC-17765-89•••-••-0816N/AN/A—-——·GRP-8763MEDICARE-ADV-A
CLMCLM-4328182026-02-05T07:44:03Zbrittany—reyes01/21/1949UHC-87647-23•••-••-6279null—UNKNOWNNULL—-GRP-9157··N/A
CLMCLM-4166052026-02-17T07:03:55Zabigail—palmer9/23/2007UHC-54190-01UNKNOWN··-—5914 PALM DRIVEDallasTX75235—MEDICARE-ADV-A
CLMCLM-4131742026-01-02T22:18:06ZMason—Rice1993-10-07UHC-17524-08null(296) 204-6244—7281 HILLCREST ROADScottsdaleAZ85237UNKNOWNNAVIGATE-HMO
ENRENR-1281232026-03-27T17:52:28ZMarcusBHowell1/1/1997UHC-94996-60•••-••-7839(841) 991-5857MARCUS.HOWELL78@PROTON.ME337 Mesa DrSan AntonioTX·78216GRP-4529·MEDICARE-ADV-A
ENRENR-1031272026-09-05T17:42:12ZMATEO··X·CRUZ1997-11-02UHC-97388-23•••-••-1235918-918-3062—1694 Sage CtSeattleWA98103GRP-4155OPTIONS-PPO
ENRENR-1184472026-07-22T07:30:44ZChristina—Larson1995-09-26UHC-33882-58•••-••-5344311.217.0105CHRISTINA.LARSON@OUTLOOK.COM7029 Market StreetLas VegasNevada89190GRP-0557CORE-HMO
CLMCLM-4125332026-03-20T17:23:31ZAndrea—King08/14/1980UHC-59243-19•••-••-6051null—nullUNKNOWN··-nullGRP-6447—
ENRENR-1166622026-04-12T02:44:18Z SamuelJRogers1947-01-25UHC-45434-25•••-••-6542·5555703216null9453 Sage CtTAMPAFL33692GRP-6249·MEDICARE-ADV-B
PRVPRV-241182026-07-02T20:56:28ZDENNIS—CONTRERAS—N/Anull—null·1344 MOUNTAIN VIEW DRIVEORLANDOFlorida32830-7798N/Anull
ENRENR-101399 2026-04-18T12:16:12ZJamesMBryant2000-12-16UHC-67105-34•••-••-1455793-541-8540JAMES.BRYANT23@YAHOO.COM8331 MESA DRGLENDALEAZ85377GRP-1274CHOICE-PLUS-PPO
ENRENR-1415612026-09-12T23:48:49ZBarbara—Kennedy1941-02-15UHC-78704-95•••-••-3257+1 473 894 6831barbara.kennedy@aol.com1436 Indian School RdSacramentoCA95889GRP-4619MEDICARE-ADV-B
ENRENR-1427182026-01-26T16:14:44ZCHRISTIANTPRICE1944-08-02UHC-56714-75··•••-••-9523UNKNOWN—1279 CHURCH STTucsonAZ85725-3147GRP-4528CORE-HMO
CLMCLM-4167852026-04-17T16:49:46ZVinent··Santiago20-10-1945N/A•••-••-4194UNKNOWN····7380 Ocean AveAtlanta··GA30392GRP-5553N/A
ENRENR-1135322026-04-17T00:18:06ZMeganTGarcia1979-11-28··UHC-85835-94•••-••-9446(829) 650-6587N/A9530 Forest AvenueAustinTX78723-1577GRP-4579CHOICE-PLUS-PPO
ENRENR-1151342026-04-24T12:29:21ZHeatherQFranklin3/14/2002UHC-57300-58•••-••-8538(213) 823-2750··UNKNOWN8801 BASELINE ROAD Apt 30DenverCO80240GRP-0512·NAVIGATE-HMO
ENRENR-1105842026-02-23T12:24:03ZCarlos—Stone1982-01-01·UHC-21036-35•••-••-2447791-604-9053CARLOS.STONE@YAHOO.COM3927 Lincoln WayAtlanta·GA30345GRP-5865NAVIGATE-HMO
ENRENR-1216552026-09-14T13:27:27ZANDREWWCOOPER1983-06-12—•••-••-4834(832) 993-5777andrew.cooper@icloud.com805 Desert Sky BoulevardCharlotteNC28211GRP-3110CORE-HMO
ENRENR-1276082026-07-18T15:36:12ZVirginiaCSantiago25-01-1972UHC-93186-39•••-••-7226·8053130390virginia.santiago@icloud.com9491 Highland AvenueSAN ANTONIOTX78220GRP-0339SELECT-EPO
ENRENR-1256392026-03-30T10:27:24ZNathan—Day19730811UHC-96207-66•••-••-91979135715049nathan.day12@hotmail.com3247 Maple AveChandlerArizona85245GRP-6556SELECT-EPO
CLMCLM-4169172026-01-06T16:29:08ZCAROLFWHEELER1943-02-08—•••-••-2407····—6835 Maple AveDenverCO80242—NULL
TPATPA-627932026-08-30T12:23:28ZPriya··Rios··1918-02-14··——NULLPRIYA.RIOS@GMAIL.COM610 Desert Sky Boulevard·Eden PrairieMN55387—MEDICARE-ADV-A
PRVPRV-26614 2026-08-20T18:23:43ZSharon—Campbell1956-06-07UHC-06772-04—+1 446 504 1093SHARON.CAMPBELL@PROTON.ME878 Canyon RdTucsonAZ85718—NULL··
ENRENR-1028272026-06-14T11:16:55ZSTEVENF.JACKSON1970-04-26UHC-10598-74•••-••-74864329754276STEVEN.JACKSON45@ICLOUD.COM··6686 Oak StTampaFL···33619GRP-1698MEDICARE-ADV-B
ENRENR-1287562026-08-28T22:48:53Zwong—jennifer12-05-1982UHC-71421-79•••-••-0180+1 606 684 9565—4080 Valley View DriveTucsonAZ·85790GRP-5317CHOICE-PLUS-PPO
CLMCLM-4145412026-06-13T09:30:31ZBobby—Carroll1998-09-03UHC5682760•••-••-170814596140892····8355 Palm Drive Apt 24CHANDLERAZ85254GRP-9512OPTIONS-PPO
ENRENR-1005342026-08-14T21:25:43ZDANIEL·DHOWELL20-09-2008UHC-61033-62•••-••-7759574.391.8569DANIEL.HOWELL45@AOL.COM8402 CHURCH STMesaAZ85222GRP-9506CHOICE-PLUS-PPO
PRVPRV-284522026-07-06T13:24:50ZPriya—Phillips1984-06-03-•••-••-4745+1 485 313 4742—1868 Hillcrest RdMIAMIFL33156N/Amedicare-adv-b
CLMCLM-4004622026-07-23T13:52:06ZDavid—Coleman·3/23/1950—N/A·(744) 446-5866—2925 Main Street #565ScottsdaleAZ85286GRP-7046NULL
TPATPA-625062026-01-09T14:57:17Z Ashley—Jimenez1971-12-23··NULL•••-••-1075958-495-3788ashley.jimenez2@icloud.com—UNKNOWNN/ANULL—CHOICE-PLUS-PPO
100,000 rows, page 93 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.802Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty