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-1005662026-07-12T17:53:24Zjanet—robinson05/14/1949UHC-84144-35•••-••-9750510-884-6379-4133 Spring StreetTampaFL33628-1882GRP-7572CHOICE-PLUS-PPO
ENRENR-1310022026-05-08T11:05:09ZWillie—Griffin1973-05-18UHC-28365-71•••-••-1618(547) 855-0900NULL458 Sage CtPHOENIXAZ85056GRP-3817CORE-HMO
ENRENR-1129772026-02-03T12:55:25ZEmma—Pena06-04-1947UHC-88943-09•••-••-8888421-257-0652EMMA.PENA@PROTON.ME8350 OAK STREETColumbusOH43242·GRP-1033OPTIONS-PPO
ENRENR-1050722026-03-27T04:30:07ZSUSANYRAY1945-09-20UHC-29128-75•••-••-47507508211015··3121 Meadow LaneMesaAZ—GRP-6655NAVIGATE-HMO
ENRENR-1140152026-04-23T19:51:15ZCampbell, Steven——·09/20/1996UHC-56403-13•••-••-0586(443) 279-4992·steven.campbell@hotmail.com5909 Central AvenueORLANDOFL32898-5055GRP-3021MEDICARE-ADV-A
ENRENR-1178992026-08-08T04:06:09ZRUTH—BROOKS11/18/62UHC-73684-25•••-••-5969(447) 218-7387ruth.brooks@icloud.com298 Church Street··DenverCO80237-4930GRP-8909CORE-HMO
ENRENR-1003432026-03-24T07:21:20Zpeter—henderson1987-10-12UHC7389941•••-••-3628—peter.henderson@gmail.com···436 Baseline RoadOrlandoFL32812GRP-7897SELECT-EPO
ENRENR-1355112026-09-01T05:29:29ZjordanA.·lynch1984-07-10UHC-08022-22•••-••-131719358866033jordan.lynch33@yahoo.com660 Mesa DriveAustinTX··78773GRP-1931CHOICE-PLUS-PPO
ENRENR-1128442026-06-16T02:12:27ZDanielE.Flores1959-12-17···UHC-10911-11•••-••-9315·4650887daniel.flores3@yahoo.com4711 Mesa Drive #570MesaArizona85281GRP-1381CHOICE-PLUS-PPO
ENRENR-1137272026-07-04T18:08:28ZDIAANE—BURKE··2005-07-17UHC-64090-94•••-••-93978889678215diane.burke76@gmail.com4779 Union StDenver·co80222GRP-9561CHOICE-PLUS-PPO
ENRENR-1151372026-03-15T20:00:53ZSTEPHENZPALMER1966-10-14UHC-65719-03•••-••-0488+1 452 984 1893UNKNOWN5084 Forest AveSan Antonio·TX78217GRP-4510CHOICE-PLUS-PPO
ENRENR-1309882026-06-25T07:38:58ZBrandon—Cunningham20-06-1965UHC-63026-22•••-••-9604N/A—4695 Indian School RdSacramentoCA95893GRP-0683NAVIGATE-HMO
ENRENR-1043572026-03-28T10:37:25ZRogerLRyan28-08-1975UHC-35596-61•••-••-5325+1 494 635 5377—5731 Ridge RdMinneapolisMN55463GRP-7709CHOICE-PLUS-PPO
ENRENR-1417352026-09-06T11:01:50ZCooper, ChristineB—4/27/1963UHC-90180-01•••-••-3643(836) 676-7236—4649 Camelback RdTampaFL33646GRP-5756SELECT-EPO
ENRENR-1059822026-07-14T10:12:24ZJAMESBBROOKS1955-06-16UHC-89968-28•••-••-3962712-538-7893james.brooks@hotmail.com2383 GRAND AVENUESacramentoCalifornia95863GRP-1189·CORE-HMO
ENRENR-1123242026-04-22T08:58:33ZHeather·PVargasOct 14, 2004UHC-46929-91•••-••-8736·(528) 959-5041N/A4373 Main StreetAtlantaGA30336GRP-4538NAVIGATE-HMO
ENRENR-1413302026-04-11T11:27:44ZRebeccaQ.Jones27-05-1967UHC-46908-53•••-••-31747535833803REBECCA.JONES36@YAHOO.COM7642 Lincoln WaySeattleWashington98182GRP-0894··CORE-HMO
ENRENR-1130722026-04-17T03:05:20ZKATHLEENOWILLIAMSON19641104UHC-41645-14•••-••-192719418056680·KATHLEEN.WILLIAMSON@AOL.COM7680 INDIAN SCHOOL RD·CharlotteNorth Carolina28244-5537GRP-1653CHOICE-PLUS-PPO
ENRENR-1244982026-07-17T02:18:17ZScott—BowmanJun 20, 1972UHC-43015-79•••-••-6733(895) 409-6440SCOTT.BOWMAN81@OUTLOOK.COM2445 Sage CourtCHANDLERAZ85299GRP-0470SELECT-EPO
ENRENR-1280292026-04-03T04:11:22Z·Judith—Li23-07-1997UHC-04715-18··18563546742·JUDITH.LI@YAHOO.COM5324 Cedar Ln·TempeAZ85224··GRP-7874OPTIONS-PPO
ENRENR-1222172026-02-12T01:47:25Zcynthia—simmons19780201UHC-98654-66·null9496516240cynthia.simmons37@hotmail.com··4343 SPRING STREETSeattleWA98162GRP-3744··SELECT-EPO
ENRENR-1303952026-01-05T04:38:38ZBrian—Gonzales14-02-1993UHC-44363-15•••-••-32305682296724brian.gonzales49@gmail.com7880 Maple Avenue·PhoenixAZ85036GRP-5622SELECT-EPO
ENRENR-1233332026-03-20T12:20:36ZCheryl—·Cunningham1963-02-20UHC-69862-58—18194278892cheryl.cunningham@hotmail.com9223 Elm StreetSeattleWA98192GRP-5376SELECT-EPO
ENRENR-1370872026-01-23T22:19:43ZaaronM.le1974-02-22UHC-71460-55··•••-••-8091—aaron.le@proton.me1451 APACHE BOULEVARD·SAN DIEGOCalifornia··92157GRP-8581·OPTIONS-PPO
ENRENR-1009822026-04-24T16:17:32ZGERALD—MCDONALD19680201UHC-64585-32•••-••-9566672-970-3578gerald.mcdonald54@yahoo.com4413 Maple AvenueFresnoCA93789GRP-0313MEDICARE-ADV-A
ENRENR-1185632026-07-25T14:26:14ZDanielD.Lawson1943-08-17UHC-81760-97•••-••-37094253018752daniel.lawson22@aol.com2782 Highland Avenue··San DiegoCA92105GRP-7783MEDICARE-ADV-B
ENRENR-1043632026-04-28T01:32:44ZdianaA.·king2000-01-26UHC-18540-14•••-••-0892(573) 966-6934NULL4599 Elm StJacksonvilleFL32244GRP-0499medicare-adv-b
ENR ENR-1135152026-02-14T12:59:56Zjoshua—cook1959-11-20UHC-57439-68•••-••-1897808-644-9812joshua.cook@hotmail.com352 Apache BlvdTucsonAZ85785GRP-3422MEDICARE-ADV-A
ENRENR-1053032026-08-22T19:38:27ZROGER—WATSONApr 27, 1948UHC-88620-95•••-••-8723436-791-4775roger.watson@yahoo.com6246 FOREST AVEMINNEAPOLISMN55429-8763GRP-8180MEDICARE-ADV-A
ENRENR-1005862026-07-25T17:06:54ZJEREMY—MITCHELL1946-04-04UHC-63000-58•••-••-47572136969429-UNKNOWNUNKNOWNNULL—GRP-1001MEDICARE-ADV-B
ENRENR-1373832026-08-27T07:59:45ZABGAIL—HANSON1989-08-08·UHC-48519-93•••-••-2900832-779-9402abigail.hanson68@hotmail.com··9129 Canyon RdFRESNOCAnull···GRP-4281CHOICE-PLUS-PPO
ENRENR-1052092026-03-05T16:48:30ZAndrew—Rivera1983-06-13UHC-42281-66•••-••-5124(902) 722-2780—3452 BroadwayNashvilleTN37242GRP-5170··OPTIONS-PPO
ENR ENR-1318772026-08-04T03:06:29ZReed, VincentI.—1983-06-27UHC0235517•••-••-9023·+1 823 584 8001vincent.reed@proton.me6135 Hillcrest RoadCHARLOTTENorth Carolina28255-1172GRP-5117MEDICARE-ADV-A
ENRENR-1281932026-10-08T09:52:03ZJoeYFerguson1938-03-21··UHC-87999-31•••-••-2797310-249-8049·joe.ferguson42@yahoo.com··UNKNOWNNULLnullGRP-0984MEDICARE-ADV-B
ENRENR-1040392026-07-08T20:54:15ZMARIAJPEREZ2000-02-01UHC-43747-20•••-••-5110587-410-0049maria.perez@gmail.com4692 Grand Ave Apt 38Denverco80296GRP-0293··OPTIONS-PPO··
ENRENR-1245422026-10-09T02:45:33ZKimQKelly1984-07-09UHC-14965-69··NULL581-663-2495kimberly.kelly@gmail.com2592 Grand AveAtlantaGA30326-5234GRP-6880MEDICARE-ADV-B
ENRENR-1304362026-08-02T21:53:42ZKeith··—Reid1955-08-15UHC-01857-96•••-••-3290750-659-7342keith.reid71@hotmail.com··4715 Jefferson AveLAS VEGASNV89174-3756GRP-2352SELECT-EPO
ENRENR-1130302026-03-29T00:37:21ZEmily·FBurke··Dec 12, 1989UHC-42752-22UNKNOWN·8883969391emily.burke99@hotmail.com7509 Elm StreetAtlantaGA30372GRP-2902MEDICARE-ADV-B
ENRENR-1054792026-02-04T20:11:00ZEric··Moreon1942-10-23nullNULL3372886910eric.moreno81@hotmail.com8842 Sage Court·Los AngelesCA90094GRP-8403CORE-HMO
ENRENR-1154712026-07-14T20:22:08ZAliceWFreemanApr 4, 1968··UHC-80293-63•••-••-8709UNKNOWNALICE.FREEMAN30@HOTMAIL.COM6953 Pine DrFresnoCA93789··GRP-1958MEDICARE-ADV-B
ENRENR-1365512026-06-04T15:57:46ZMASON—LAWRENCE··1946-08-12UHC-62902-14UNKNOWN602-721-0466NULL-··null——GRP-2615MEDICARE-ADV-B··
ENRENR-1413292026-08-03T03:40:04Z BECKYQ··JONES19670527UHC4690853•••-••-3174+1 753 583 3803—7642 LINCOLN WAY Apt 9SeattleWA98182GRP-0894CORE-HMO··
ENRENR-1410602026-02-11T00:16:46ZPEGGY—WATSON2007-04-27UHC5372004•••-••-335617522404124MARGARET.WATSON39@GMAIL.COM5608 Elm StreetOrlandoFL32883-6974GRP-2974OPTIONS-PPO··
ENRENR-1228682026-03-17T01:44:33ZPaulIWoods2007-09-24··UHC4106657•••-••-7614(566) 970-6230paul.woods@outlook.com8824 Spring StreetScottsdale··AZ85296-8496GRP-8751NAVIGATE-HMO
ENRENR-1213232026-02-21T22:59:14Z GloriaG.··Miller1988-09-11UHC-04119-68•••-••-5462·3153675577—7263 Cedar LnColumbusOhio43288GRP-6308MEDICARE-ADV-B
ENRENR-1157432026-05-26T17:52:30ZAbigail—Taylor07/02/1942UHC-63413-52•••-••-04468879935145ABIGAIL.TAYLOR80@OUTLOOK.COM7514 Market StreetDallasTX75234GRP-0204MEDICARE-ADV-A
ENRENR-1279372026-10-05T23:55:19ZCarolFRose1975-01-26UHC-39091-36•••-••-2118790-488-9698NULL·4217 WILLOW CTTampaFlorida33639·GRP-0939SELECT-EPO··
ENRENR-1093452026-08-30T10:20:25ZSUSANW··JOHNSON1971-08-02UHC-29736-17•••-••-31833788428081—6551 Camelback RdSan Antoniotx78202GRP-6086CORE-HMO
ENRENR-1171042026-04-09T06:48:18ZMichael—GeorgeDec 10, 1997UHC-99535-98•••-••-4738696-921-8894michael.george@icloud.com499 SUNSET BOULEVARDLos AngelesCAN/AGRP-3989CORE-HMO
ENRENR-1331682026-07-09T23:57:56ZJean··Long07/08/1952UHC-19794-22—222-875-6796JEAN.LONG@HOTMAIL.COM6765 SPRING STMesaAZ85238GRP-1567OPTIONS-PPO
43,101 rows, page 315 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:43.608Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty