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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1095942026-03-21T12:23:37ZJulie—Carroll1974-10-14UHC-17928-78•••-••-2893nulljulie.carroll@gmail.com··456 Pine DriveGLENDALEAZ85388GRP-7327NAVIGATE-HMO··
ENRENR-1027122026-07-15T02:57:11ZTheresaVPierce20010912UHC-22598-55•••-••-9041(662) 742-2690theresa.pierce86@gmail.com4585 Park PlaceSeattleWA98107GRP-4025MEDICARE-ADV-B
ENRENR-1154682026-08-09T07:30:57ZjuliaD··jensen1964-03-28UHC-01842-56•••-••-82628856956043—8676 Sunset BlvdTampa·FL33667GRP-1577navigate-hmo
ENR ENR-1164282026-07-14T18:43:49ZKathleen T··Salazar19880037UHC-62432-29•••-••-9449+1 582 676 2980kathleen.salazar79@icloud.com··-N/A—NULLGRP-1620SELECT-EPO
ENRENR-1136042026-05-11T22:52:50ZKellyXWheeler·1991-02-01UHC-68101-84null3362980567KELLY.WHEELER92@GMAIL.COM1216 Harbor BlvdChandlerAZ85279GRP-9145SELECT-EPO
ENRENR-1269472026-01-25T04:05:47ZBRUCE—NELSON1993-03-13UHC7213531NULL12429460806bruce.nelson@gmail.com9238 Oak StNashvilleTN-GRP-6624OPTIONS-PPO
ENR ENR-1127192026-09-15T03:23:29ZJoshau··BHoffman1972-01-13UHC-75819-13•••-••-2409(337) 941-7652N/A4968 INDIAN SCHOOL ROAD·AustinTX78725GRP-4035MEDICARE-ADV-B
ENRENR-1115392026-08-02T04:17:20ZJACOB—CRUZ1988-07-09UHC0469002•••-••-65149257108550jacob.cruz59@aol.com··7937 LINCOLN WAY·San DiegoCA92162GRP-3019··NAVIGATE-HMO
ENRENR-1418642026-07-07T14:58:47Zcarl—campbell1967-03-26UHC-64261-86•••-••-2427nullCARL.CAMPBELL@PROTON.ME8324 Sage Ct Apt 37EDEN PRAIRIEMN55324GRP-3156CHOICE-PLUS-PPO
ENRENR-1416952026-07-18T04:29:42ZOMARHDUNCAN1991-06-09UHC5470201•••-••-4234N/Aomar.duncan85@aol.com2120 CAMELBACK RDColumbusOH43270GRP-2595SELECT-EPO
ENRENR-1259922026-04-15T16:54:29ZMary L··—Park2008-03-21UHC-76025-30•••-••-58738557223871mary.park23@hotmail.com2838 Mesa Dr Apt 39PlanoTX75055GRP-4686MEDICARE-ADV-B
ENRENR-1363332026-07-31T09:38:46ZGeraldJ.Cole1991-12-21UHC5670590•••-••-8683+1 363 375 5047gerald.cole@gmail.com3808 Highland AveHOUSTONtx77030GRP-3331OPTIONS-PPO
ENRENR-1330572026-06-06T16:04:43ZPtaterson, NicholasE.—·09-10-1966UHC9291336•••-••-66944209904362·nicholas.patterson62@icloud.com8555 Valley View DrNashvilleTN37296GRP-3071OPTIONS-PPO
ENRENR-1241122026-02-26T20:26:20ZKELLYKGARDNER1969-11-19N/A•••-••-22163255514310KELLY.GARDNER31@AOL.COM6746 CENTRAL AVEMESAAZ85232GRP-2864CHOICE-PLUS-PPO··
ENRENR-1076892026-09-05T04:18:44ZSofiaO.Duncan06/28/38-•••-••-335617576423281—2365 River RdDenverCO80217-6885GRP-6321MEDICARE-ADV-B
ENRENR-1056992026-07-01T19:03:25ZKyleBGuzman1/15/1954·UHC-10602-08•••-••-08894266404283NULL··4117 Central AveSAN ANTONIOTX78258GRP-7866CHOICE-PLUS-PPO
ENRENR-135005 2026-01-16T15:25:44ZAbigail G—Young19920227UHC-96753-20•••-••-0881588.731.5256abigail.young20@aol.com9294 Indian School Road Apt 16Los AngelesCAnullGRP-4738MEDICARE-ADV-A
ENRENR-1302842026-05-24T04:39:24ZSanda—Allen·09/15/1953uhc-81023-98•••-••-0465——7497 CANYON ROADTempeAZ85235GRP-6656·CHOICE-PLUS-PPO
ENRENR-1235332026-05-28T09:19:50ZStevenBButler1948-12-19UHC-75930-09··•••-••-1604(831) 606-0927null3328 Lake View RdAustinTX78765GRP-2020MEDICARE-ADV-B
ENR ENR-1406302026-08-01T23:05:35ZKimberlyYWright9187-09-02UHC-39402-30•••-••-0441+1 929 624 1168kimberly.wright22@proton.me4002 Market StNashvilleTennessee37271GRP-2277OPTIONS-PPO··
ENRENR-1344192026-05-30T04:15:50ZbryanY.bradley—UHC5603471•••-••-33862126093209·bryan.bradley23@icloud.com5040 Oak StMiamiFL··33161GRP-0275NAVIGATE-HMO
ENRENR-1109402026-07-19T07:13:34ZVICKYYJAMES1946-03-05UHC-93973-31•••-••-427013277420415VICTORIA.JAMES@AOL.COM4992 Hillcrest RdDenverCO80219GRP-4207OPTIONS-PPO
ENRENR-1386052026-06-08T17:21:15ZOMARXFORD01-08-2003UHC-27228-51•••-••-5713967-523-2713·omar.ford@aol.com2289 Ridge Rd···SAN ANTONIOTexas78299··GRP-9221NAVIGATE-HMO
ENRENR-1088612026-01-13T17:37:08Zeddward—delgado1/16/1986UHC-98565-10··•••-••-2381+1 445 317 6477edward.delgado@hotmail.com8051 Market StreetAtlantaGA··30380-1971GRP-4393CORE-HMO
ENRENR-1250452026-02-10T22:43:34Z WalterM.Gilbbert5/27/1963UHC-67455-85•••-••-51814285885393—2595 Maple Avenue·ChandlerAZ85266··GRP-6605MEDICARE-ADV-A
ENRENR-1163612026-07-08T03:05:41ZNICOLE—ELLIS1956-04-26UHC4622728•••-••-2394·9567801821nicole.ellis@yahoo.com8243 Central AvenuePhoenixAZ85044GRP-7682CORE-HMO
ENRENR-1267392026-02-16T01:32:58ZJoshua—Bell1982-01-09UHC-11814-06•••-••-6150+1 814 983 1571JOSHUA.BELL@HOTMAIL.COM2664 Lincoln WayMiamiFL33196GRP-8468MEDICARE-ADV-A
ENRENR-1246622026-01-31T06:17:23ZDYLAN—·PERRY12-11-1991UHC0469913•••-••-5532940-243-8613dylan.perry@aol.com1794 Cedar LnDENVERCO80244GRP-7637OPTIONS-PPO
ENRENR-1059262026-10-01T20:16:33ZHenryY.Little·0306-19-97UHC-90229-54•••-••-24064777783428—6925 Hillcrest RoadPlanoTX··75017GRP-0962SELECT-EPO
ENRENR-1339872026-02-06T11:40:14ZAshleyPBryatn2001-60-04UHC-46537-83•••-••-8345553.610.7150ashley.bryant@outlook.com7372 Pine DriveMiamiFL··33162GRP-9311··NAVIGATE-HMO
ENRENR-1214232026-09-12T06:01:37ZLinda—Berry··1952-07-22UHC-94854-16•••-••-2091908-565-1714N/A5051 SUNSET BOULEVARDMinneapolismn55413-8824GRP-2493OPTIONS-PPO
ENRENR-1041832026-06-03T10:48:59ZYUKI—RICHARDSON19820208UHC-64259-10•••-••-2936+1 614 433 0688yuki.richardson@outlook.com2434 Forest AvenueEden Prairie·MN55340GRP-0444NAVIGATE-HMO
ENRENR-1006602026-09-03T03:08:39ZOlson, SophiaY—·1971-08-04UHC-24314-77•••-••-0471nullUNKNOWN4458 Mesa DrLas VegasNV89169-9801GRP-3910CHOICE-PLUS-PPO
ENRENR-1301262026-08-21T15:49:47ZAshley··Hudson·1972-10-24UHC-94895-79NULL371-225-0580ashley.hudson46@aol.com56 Central AvenueDallasTX75223GRP-5537OPTIONS-PPO
ENRENR-1122432026-09-10T10:37:17ZLaura·DWallace12/10/47UHC-16225-98•••-••-3105(642) 614-9549LAURA.WALLACE@YAHOO.COM9541 Indian School RdAustinTX·78733GRP-9181core-hmo
ENRENR-1122372026-06-18T20:06:58ZRaymondI.Campbell2002-11-15UHC8838596··•••-••-57765217027raymond.campbell75@yahoo.com5500 Ocean AveGlendaleAZ85328GRP-7707··CHOICE-PLUS-PPO
ENRENR-1011762026-08-29T17:51:22ZAshley··—Thomas1983-03-07UHC-49242-29—404-225-6977-7181 Ocean AvenueTampaFL33642··GRP-3924CHOICE-PLUS-PPO
ENRENR-1382892026-06-22T05:38:32ZNoahDGeorge··1956-09-22UHC-49449-53•••-••-9873720-912-1097N/A2933 Pine Drive Apt 31Las VegasNV89197GRP-1857MEDICARE-ADV-A··
ENRENR-1415942026-03-29T19:01:25ZDOROTHY—RUSSELL1990-09-17UHC9962504•••-••-9024-dorothy.russell9@outlook.com9373 Spring StMesa··AZ85208GRP-9816choice-plus-ppo··
ENRENR-1129622026-06-17T13:45:59ZAnn—Ferguson2050-06-16UHC-90827-12•••-••-8830(459) 743-7797ann.ferguson41@aol.com2004 PINE DRScottsdaleAZ85208GRP-4466NAVIGATE-HMO
ENRENR-1430342026-09-24T02:45:37ZDavidK·PerryUNKNOWNUHC-81654-23•••-••-46435179320743david.perry@proton.me1212 Oak St Apt 26Los AngelesCA90009GRP-6304OPTIONS-PPO
ENRENR-1221312026-06-08T05:49:26ZSUSAN—HERRERA1977-09-13UHC-51841-46··•••-••-4828942-219-6219susan.herrera@gmail.com6558 PARK PL·AustinTX78751GRP-0309··CHOICE-PLUS-PPO
ENRENR-109303 2026-08-03T21:36:35ZGerald—Kennedy10-03-1977UHC-54614-81•••-••-1526(385) 806-0050GERALD.KENNEDY72@ICLOUD.COM6525 Camelback RoadORLANDOFL32885GRP-8665CHOICE-PLUS-PPO
ENRENR-1262652026-06-19T11:18:42ZMateoSDiaz··1952-06-25UHC-92907-25•••-••-221715253721839—2968 Apache Boulevard #166HOUSTONtx77085GRP-1621MEDICARE-ADV-A
ENRENR-1372432026-04-19T23:00:54ZJosh—Munoz··2003-01-12UHC-13562-40··•••-••-9996(840) 964-7411joshua.munoz@hotmail.com5125 Park Place··SeattleWA98119GRP-3490CORE-HMO
ENRENR-1405582026-05-12T10:29:43Zpat····ruizSep 23, 1953UHC-33799-24•••-••-2331nullN/A5562 Desert Sky BoulevardAustinTX78768GRP-2609SELECT-EPO
ENRENR-1371052026-01-30T16:24:51Zjessica··—carroll6/12/1942UHC-09268-29•••-••-143615033331504jessica.carroll62@gmail.com9859 Sage Ct Apt 29JacksonvilleFL32206GRP-2629CHOICE-PLUS-PPO
ENR ENR-1281722026-05-05T13:43:14ZMariaQGarcia10-09-1981UHC-26872-43•••-••-6206628-771-4238MARIA.GARCIA@GMAIL.COM3787 Mountain View DrHoustonTX77048··GRP-7001select-epo
ENRENR-1057102026-02-17T11:54:22ZMarianaSDelgado1989-10-06UHC-41386-07N/A882-658-8091mariana.delgado@icloud.com516 Maple AvenueORLANDOfl32818GRP-1743··SELECT-EPO
ENRENR-1190962026-05-17T15:19:35ZBRANDON·ATORRES1955-11-27UHC-26652-20-286-887-4840······4878 Canyon RoadChandlerAZ85267GRP-4644MEDICARE-ADV-B··
43,101 rows, page 46 of 863PreviousNext

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.677Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty