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-1417432026-02-09T13:16:55ZdianaJ.salazar02/17/01UHC-69415-54•••-••-3556937.557.4820—9622 Desert Sky BlvdSacramentoCA95884GRP-4074MEDICARE-ADV-B
ENRENR-1307682026-02-20T02:53:15ZCATHERINE—KELLEYOct 15, 2004UHC-76862-04•••-••-5739(387) 657-2925catherine.kelley@icloud.com2734 Pine DrJACKSONVILLE··FL32205GRP-5030··NAVIGATE-HMO··
ENRENR-1146512026-10-07T16:48:58ZCatherineKJensenOct 25, 1947UHC-06420-48—5464331855catherine.jensen38@gmail.com4835 GRAND AVENUETucsonAZ85735GRP-9704MEDICARE-ADV-A
ENRENR-1424752026-08-01T04:27:45ZJEREMY—MENDEZ··09/14/1987·UHC-21632-60•••-••-8589666.979.5351UNKNOWN9855 Sage CtTampaFlorida33660GRP-5723··OPTIONS-PPO
ENRENR-1267552026-10-01T21:14:20ZEvelyn··—Ramos9189-05-05UHC-70497-07•••-••-556316395603325··evelyn.ramos21@yahoo.com8644 Elm StreetPlanoTXNULLGRP-4998CORE-HMO
ENRENR-1197662026-04-09T04:28:20Z Arjun—Rojas19960822UHC-54131-59•••-••-4280476-399-2693UNKNOWN6172 Market StNashvilleTennessee37286GRP-4453NAVIGATE-HMO
ENRENR-1056942026-04-28T20:05:33Z·Andrea—Scott···Nov 13, 1942UHC-49963-79•••-••-3958(549) 420-8731—5272 Maple AveChandlerAZ·85271GRP-4836OPTIONS-PPO
ENRENR-1364982026-07-06T02:57:34ZANTHONY—MYERS1978-05-08UHC-74006-37•••-••-8298·+1 342 240 5515anthony.myers@gmail.com4764 Sunset Boulevard #930Eden PrairieMN55334GRP-4018NAVIGATE-HMO
ENR ENR-100728 2026-07-03T07:20:53ZMADISONFCOOK1960-01-25·UHC-96515-99—4014081478madison.cook59@yahoo.com8386 Spring St·TucsonArizona85738GRP-3453CHOICE-PLUS-PPO
ENRENR-1246092026-10-06T06:40:01ZCAROLXWALKER1946-02-09UHC-06553-34—(946) 248-9514··NULL8826 CANYON RDSacramentoCA95891-9704··GRP-9830SELECT-EPO
ENRENR-1370662026-07-02T21:11:13ZcatheirneTtaylor1942-11-26UHC-40952-61•••-••-0043·(961) 533-3401null7794 PARK PLACELas VegasNevada89146GRP-8235··CORE-HMO
ENRENR-1074262026-01-15T10:32:44ZRAMOND··PPATEL12/18/1947UHC-94437-25•••-••-5174627.989.5240raymond.patel@yahoo.com5334 Meadow Ln··DenverCO····GRP-0809SELECT-EPO
ENR ENR-1178892026-05-05T15:27:02ZJames—RihcardsonJan 12, 1980UHC-23684-06•••-••-2718(486) 414-7668james.richardson@yahoo.com9452 Mesa DrOrlandoFL32871GRP-7022CHOICE-PLUS-PPO
ENRENR-1358412026-06-01T09:08:51ZSARAHFFREEMAN2008-03-23UHC-43778-26•••-••-5732874-367-5533sarah.freeman@hotmail.com7830 HILLCREST RDTempeAZ85206GRP-2423MEDICARE-ADV-B
ENRENR-1343662026-04-17T03:29:36Z Russell J.—Holmes07/10/1969UHC-68851-64•••-••-9575+1 411 385 8348russell.holmes41@gmail.com6297 Sage Ct #452··AtlantaGA30312GRP-8967CHOICE-PLUS-PPO
ENRENR-1215912026-02-06T13:15:14ZLAURAABLAKK1958-12-07UHC-92939-08·N/A(370) 200-6820laura.black27@hotmail.com3594 Washington StreetHoustonTX77092·GRP-8089NAVIGATE-HMO
ENRENR-131339 2026-05-24T21:21:11ZRALPH—HOFFMAN1983-12-26UHC-55886-66•••-••-02345636661849ralph.hoffman@aol.com··962 INDIAN SCHOOL RDSeattleWA98107-0955GRP-6503NAVIGATE-HMO
ENRENR-1189432026-09-20T22:39:30ZAhmed—Jones03/22/43uhc-81105-23•••-••-38333932081531UNKNOWN2851 Indian School RdMiamiFL33127GRP-3352NAVIGATE-HMO
ENRENR-1104332026-05-24T03:26:45ZTURNRVDEBRA1994-08-06UHC-81707-43•••-••-7718+1 960 857 0465DEBRA.TURNER@HOTMAIL.COM906 CHURCH STREETNASHVILLE··TennesseeNULLGRP-4291SELECT-EPO
ENRENR-1248722026-08-03T04:36:25ZGloriaPFranklin1974-06-06UHC-58135-07•••-••-22352646625596gloria.franklin21@yahoo.com9640 Meadow LaneNashvilleTN37203··GRP-0257CHOICE-PLUS-PPO
ENRENR-1325582026-07-25T11:34:49ZDebraR.KnightApr 27, 1991UHC-42617-07•••-••-5793NULLdebra.knight38@yahoo.com4546 CHURCH STREETTampaFL33644GRP-3633NAVIGATE-HMO
ENRENR-1324142026-05-07T06:06:22ZKaren—Perez·1939-01-22UHC7140838•••-••-5297458-526-0815karen.perez82@yahoo.com5839 BROADWAYTucsonAZ85776GRP-1815NAVIGATE-HMO
ENRENR-1245672026-05-26T02:51:56ZJudithPGreen1960-11-26UHC-40902-13•••-••-7634432-864-0259JUDITH.GREEN10@PROTON.ME1436 Central AvenueAtlantaGAUNKNOWNGRP-7814CHOICE-PLUS-PPO
ENRENR-1327932026-05-06T20:04:34ZHall, Christopher——21-02-1951UHC-25937-42•••-••-1933562.961.5109CHRISTOPHER.HALL@ICLOUD.COM·1703 Spring StreetEDEN PRAIRIEMN55302GRP-7446CHOICE-PLUS-PPO··
ENRENR-1021472026-02-06T14:10:59ZNathanM.··Armstrong·02/06/42UHC-15778-11•••-••-1930N/Anathan.armstrong@outlook.com5140 Highland Ave·OrlandoFLNULLGRP-9651OPTIONS-PPO
ENRENR-1154172026-06-06T10:57:29ZKAYLA—VARGAS1987-08-09UHC-09167-84•••-••-57726776316839··kayla.vargas52@gmail.com9824 Elm StreetSCOTTSDALEAZ85239GRP-4647NAVIGATE-HMO··
ENRENR-1347312026-02-05T15:57:35ZJULIE—FOX1939-08-04UHC-79877-01•••-••-1824692-294-6043julie.fox@yahoo.com···5009 WILLOW CTMinneapolismn55460GRP-4717OPTIONS-PPO
ENRENR-1389632026-05-26T05:37:41ZJoshua—Park1943-06-03UHC-09752-86··•••-••-6443+1 836 959 2846joshua.park@aol.com5944 Church StAustinTX78727GRP-8938··CHOICE-PLUS-PPO
ENRENR-1268832026-04-29T10:08:44ZHelenUDominguez2000-05-20UHC9605746NULL2974512622HELEN.DOMINGUEZ88@AOL.COM320 Pine DrEden PrairieMN55369GRP-4144NAVIGATE-HMO··
ENRENR-1279822026-01-14T07:24:47ZABIGAILZCUNNINGHAM1939-09-28UHC-07249-40•••-••-69998772953074abigail.cunningham@outlook.com··4046 Oak StTAMPA··Florida33663GRP-7847NAVIGATE-HMO··
ENRENR-1106172026-07-14T03:34:04ZDIANA····ROSE1953-12-09·UHC-04067-20•••-••-9655352-387-9342diana.rose17@proton.me653 Harbor BoulevardMESAAZ85227-6774GRP-3212·MEDICARE-ADV-B
ENRENR-1121902026-01-02T16:00:46ZAndy··Salazar1982-11-12UHC-40525-97•••-••-2101+1 780 475 0049andrew.salazar@hotmail.com1044 OAK STScottsdaleAZ85246-8354·GRP-8667select-epo
ENRENR-1123022026-08-18T03:38:46ZmateoFpadilla04/21/1938UHC-63917-46•••-••-2430(268) 497-8011MATEO.PADILLA92@OUTLOOK.COM··8385 Forest Avenue··San DiegoCA92113GRP-7485··MEDICARE-ADV-B
ENRENR-1303692026-06-21T06:52:38ZedwardXvaldez··2006-10-03UHC-62382-43•••-••-7515(867) 836-5610EDWARD.VALDEZ@PROTON.ME608 CHURCH ST Apt 2ChandlerAZUNKNOWN···GRP-5042MEDICARE-ADV-A
ENRENR-1344022026-09-18T00:58:42ZVirginia··—Mjia2006-02-17UHC2901039•••-••-03172412314554VIRGINIA.MEJIA96@HOTMAIL.COM5994 Canyon Road Apt 22FresnoCA··93767GRP-1344SELECT-EPO
ENRENR-1173382026-08-16T04:21:26ZEmilyWHolmes9179-07-01UHC-72045-46•••-••-6055(772) 267-5177·EMILY.HOLMES59@PROTON.ME1886 Desert Sky BoulevardScottsdaleAZ85216GRP-4610MEDICARE-ADV-A
ENR ENR-1119612026-08-19T09:53:28ZkathrynSmorris1945-11-03UHC-54409-02•••-••-96314239564422kathryn.morris@icloud.com·2221 Forest AveJACKSONVILLEFL32234GRP-2986CHOICE-PLUS-PPO
ENRENR-1380962026-04-29T18:15:05ZThomas—Cruz1998-03-20UHC-85435-68•••-••-80036077454-5054 MAIN STREETPHOENIXAZ85085GRP-9585·OPTIONS-PPO
ENRENR-1253282026-03-30T01:23:19ZMargaretSMartin2003-07-16UHC-04183-02•••-••-2861+1 722 399 8376MARGARET.MARTIN@OUTLOOK.COM8044 Pine DrFresnoCA93709GRP-7048NAVIGATE-HMO
ENRENR-1400232026-09-07T20:29:44ZAlbert··—Weaver3/6/1950UHC-17326-17•••-••-3660+1 898 585 8206—4070 Forest AvenueSan AntonioTX78284GRP-1283OPTIONS-PPO
ENRENR-1104792026-03-06T01:01:40ZCastro, Madion——1960-12-26UHC2812860•••-••-7050227-566-7996madison.castro@proton.me5257 Hillcrest RoadORLANDOFloridaN/AGRP-7746CORE-HMO
ENRENR-1350232026-09-18T03:48:35ZSHARONC.GRAY01/01/60UHC-95468-33•••-••-3058(329) 659-5868SHARON.GRAY45@OUTLOOK.COM4386 Pine Dr··Eden Prairiemn·55363GRP-7911CHOICE-PLUS-PPO
ENRENR-104193 2026-01-07T13:37:58Z·JoshJ.Nunez1946-06-23UHC-94654-81•••-••-3760721-662-3691NULL9303 Sunset BlvdMinneapolis··MN55431GRP-5689·OPTIONS-PPO
ENRENR-1298412026-05-08T11:02:22ZWilliamVPierce1971-02-24UHC-54866-35··•••-••-6820628-268-5089··4291 PINE DRSan AntonioTX78228GRP-0332MEDICARE-ADV-B··
ENRENR-1068202026-07-21T07:06:12ZCHARLOTTEC.DELGADO1981-08-19UHC-38844-27null943-705-6172—·8620 BASELINE RDAtlantaGA·30317·GRP-7258MEDICARE-ADV-A
ENRENR-1278082026-08-18T01:07:15ZSaraZWood1953-02-26UHC-63850-64•••-••-9061(377) 266-0464UNKNOWN89 Pine DrOrlandoFloridaN/AGRP-3757SELECT-EPO
ENRENR-1391022026-08-10T15:42:28Z jerryFsilva1992-04-01UHC-95309-73•••-••-106319523877745JERRY.SILVA19@ICLOUD.COM5244 Ocean AvenueChandlerAZ85212GRP-3835MEDICARE-ADV-A
ENRENR-1017762026-06-23T19:50:07ZNicholas—Perry1972-02-16UHC-33463-19•••-••-3394303.549.0621nicholas.perry@gmail.com3968 Sunset BlvdSan AntonioTX78221GRP-8409CHOICE-PLUS-PPO
ENRENR-1067072026-06-10T14:41:02ZDORISUDIAZ1942-02-19UHC-30771-40•••-••-29467727867759null9094 Desert Sky Blvd #290AustinTX78724GRP-5198··MEDICARE-ADV-A
ENRENR-1071512026-09-07T01:33:10ZDianaGHanson1989-01-07UHC-23006-28•••-••-6345668-489-1550diana.hanson@icloud.com2739 HILLCREST ROAD··FRESNOCA93730GRP-6143CORE-HMO
43,101 rows, page 113 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:37.753Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty