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-1168682026-10-12T08:22:59ZWILLIAMPBLACK1967-03-21UHC-48987-35—210-934-2109william.black@proton.me·5405 Sunset BlvdJACKSONVILLEFL32243GRP-0440OPTIONS-PPO
ENRENR-111303 2026-03-12T02:30:29ZHudson, Juhn——1999-01-25··UHC-10482-82•••-••-63997161482N/A9203 Broadway·MiamiFL33199GRP-6312MEDICARE-ADV-A
ENRENR-1311532026-09-14T16:14:53ZSAMANTHA—LAWSON1981-03-03UHC-59223-01•••-••-8936(520) 557-6135·SAMANTHA.LAWSON51@AOL.COM2429 Indian School RdMiamiFL33151GRP-4447OPTIONS-PPO
ENRENR-103502 2026-08-04T01:00:40ZfoxSchristopher4/28/1950UHC-01934-28•••-••-3301322-669-2546··christopher.fox14@icloud.com3691 Hillcrest Rd Apt 21AtlantaGA30320GRP-4425MEDICARE-ADV-A
ENRENR-1092672026-04-30T05:20:49ZRoy—Allen1940-01-13UHC-12521-41—N/Aroy.allen@hotmail.com5382 Union StreetATLANTAGA30363GRP-8570CHOICE-PLUS-PPO
ENRENR-1123942026-06-28T04:19:11ZStephanieJFreeman-UHC-23974-43•••-••-96414435742466STEPHANIE.FREEMAN62@YAHOO.COM8960 Spring StreetCHANDLERaz85294GRP-5051CORE-HMO
ENRENR-1187912026-01-16T15:13:09Z AustinBMcDonald25-02-2004UHC-42732-35•••-••-5503852-560-4326austin.mcdonald46@gmail.com7167 Mountain View DriveScottsdaleAZ85255GRP-9532CORE-HMO
ENRENR-1194932026-04-28T06:42:38ZCatherineDCunningham5/20/1999UHC-05596-53N/A671.775.3841catherine.cunningham72@gmail.com3522 Sunset BlvdTampaFL33656GRP-2068NAVIGATE-HMO
ENRENR-1027802026-06-13T03:15:32ZTylerPAustin1973-02-19··UHC-63014-58•••-••-6377501.666.8944UNKNOWN1955 Desert Sky Boulevard·MESAAZ85284GRP-8009OPTIONS-PPO
ENRENR-1197402026-08-11T00:59:28ZAlan··Hoffan1971-07-28UHC-60711-43•••-••-638515624324799null5888 Church StMESAAZ85247GRP-7087MEDICARE-ADV-B
ENR ENR-1347022026-10-15T14:37:05ZGeorgeBBerry1997-04-12UHC-51915-94•••-••-46248788197161george.berry@gmail.com5653 LINCOLN WAYMinneapolisMN55458GRP-7750NAVIGATE-HMO
ENRENR-1089452026-10-09T03:51:51ZDEISE—RYAN1976-07-02UHC4741764•••-••-2332UNKNOWNDENISE.RYAN39@PROTON.ME5141 Baseline Road··Eden PrairieMN55314GRP-2933SELECT-EPO
ENRENR-1222822026-09-05T23:22:21ZMariaIBradley1974-06-06UHC-49276-50•••-••-5547+1 945 940 3670··null··715 APACHE BOULEVARDPhoenixAZ85082GRP-5244MEDICARE-ADV-A
ENRENR-1083982026-01-28T02:40:23ZandreaH.stone09-07-1993UHC-78915-54•••-••-38176978621181andrea.stone8@icloud.com3159 Jefferson AveEden PrairieMN55338GRP-8365MEDICARE-ADV-B
ENRENR-1379472026-08-07T17:18:11ZHAROLDX.WAGNER1938-04-04·UHC-41770-35•••-••-92069334453061—8987 Desert Sky BlvdTucsonAZ85715GRP-2078NAVIGATE-HMO
ENRENR-1187862026-02-05T11:21:00ZSANDRA—VALDEZ1949-11-19UHC-60659-14•••-••-1029(241) 827-1164sandra.valdez@yahoo.com3901 Elm StTucson·AZ85775GRP-0589CORE-HMO··
ENRENR-1226282026-01-26T14:11:02ZJanetI.Vasquez19450220UHC0613879•••-••-6682-·janet.vasquez68@proton.me650 Bayshore Dr·San DiegoCA92107GRP-7183NAVIGATE-HMO
ENRENR-1148682026-04-01T20:52:18ZannNrose··1954-06-20··UHC-05350-91-··+1 947 474 0640··—7301 Mesa DrTucsonAZ85764GRP-5396··CORE-HMO
ENRENR-1001552026-06-06T02:45:38ZSEAN—JORDAN1974-11-07UHC-70598-59•••-••-1790-·sean.jordan96@hotmail.com1511 ELM STREETHoustonTX77092GRP-7069NAVIGATE-HMO
ENRENR-1050032026-02-01T15:28:12ZYUKIE.CHAVEZ1950-05-21UHC-73006-24·NULL-YUKI.CHAVEZ62@OUTLOOK.COM4998 Camelback RoadColumbusOH43233GRP-8714SELECT-EPO
ENRENR-1181822026-03-21T08:12:50ZCarloFRodriguez1988-03-21UHC-06063-90•••-••-44195852069866—·1060 WASHINGTON STREET·TEMPEArizona85251-7181GRP-7049MEDICARE-ADV-B
ENRENR-1175632026-09-29T04:15:01ZAaronNLarson1963-12-24UHC-22371-27•••-••-0971(871) 371-1158··-6922 GRAND AVENUEGlendaleAZ85321GRP-6994·CHOICE-PLUS-PPO
ENRENR-1271682026-01-09T00:15:50ZScott K—Thoas24-07-1970UHC-17753-40-713.474.7562UNKNOWN2385 Park PlaceEden PrairieMN55374GRP-7552CORE-HMO
ENRENR-1376922026-07-24T18:46:42ZETHANSBUTLER1958-01-03··UHC-86946-59··•••-••-5726·(255) 251-6678ethan.butler@hotmail.com4299 Forest Ave #322·ColumbusOhio43284GRP-7972NAVIGATE-HMO··
ENRENR-1018582026-02-07T11:02:49Z·BRUCECCHAVEZ1940-08-25UHC-59211-88•••-••-3355(482) 328-6893bruce.chavez30@proton.me6883 Indian School Rd··FresnoCA93735·GRP-3955MEDICARE-ADV-A
ENRENR-1402572026-01-26T07:06:57ZCarlA··Rios1990-02-14UHC-55056-63•••-••-3378+1 339 400 1200·carl.rios64@aol.com2851 Lake View RoadAtlantaGeorgia30384GRP-5557MEDICARE-ADV-B
ENRENR-1413702026-05-20T22:22:32ZDebbraR.Nelson1954-09-06UHC-90389-27•••-••-37246159566127NULL281 APACHE BLVDSan DiegoCA92114GRP-7595NAVIGATE-HMO
ENRENR-1187702026-05-15T21:00:16ZReed, Ralph——1978-06-03UHC-28797-29UNKNOWN328-906-5305ralph.reed@icloud.com6164 Main StreetNashvilleTN37205GRP-8697·SELECT-EPO
ENRENR-1343552026-08-14T01:21:35ZHelenC.Maldonado1993-11-23UHC-15722-40•••-••-36924666404177NULL6844 HIGHLAND AVENUECharlotteNC28285-1128GRP-4954NAVIGATE-HMO··
ENR ENR-1176202026-10-08T19:03:42ZGabriel—Gray·05/03/62UHC-31656-92•••-••-9409478.761.4161gabriel.gray44@proton.me868 Sage CtColumbusOH—GRP-3245CORE-HMO
ENRENR-1121952026-01-19T01:01:10ZVincent—Griffin1956-01-01UHC4762031UNKNOWN7414986730vincent.griffin70@outlook.com2128 RIVER RD #430ScottsdaleAZ·85204GRP-7390MEDICARE-ADV-B
ENRENR-1192272026-01-24T14:22:11ZLARRYM.FRANKLIN01/19/55UHC-07734-45··•••-••-0659894.505.5515larry.franklin87@gmail.com8091 Sunset Blvd Apt 22AtlantaGA30311GRP-5091CHOICE-PLUS-PPO
ENRENR-1139582026-07-07T16:13:07ZBryan—Gonzzales1962-12-13··UHC-64837-64•••-••-27588196102698N/A··6016 MARKET STREETTampaFLUNKNOWNGRP-3142CORE-HMO
ENRENR-1350432026-07-30T05:02:21ZMELISSA—BUTLER1987-07-14UHC-21038-92•••-••-6252692-280-8759MELISSA.BUTLER88@YAHOO.COM2905 BroadwayCharlotteNCnullGRP-9413··NAVIGATE-HMO
ENRENR-1351542026-08-12T05:59:37ZGEORGE—FORD1991-12-01·UHC7235372•••-••-9499+1 464 813 2727N/A8138 Spring StSCOTTSDALEAZ85280GRP-8025SELECT-EPO
ENRENR-1282662026-10-15T00:41:57ZChristine—Simpson19830424UHC-84786-76•••-••-8707(941) 930-4036CHRISTINE.SIMPSON@PROTON.ME4139 Palm DriveNashvilleTennessee37269GRP-4016CHOICE-PLUS-PPO
ENR ENR-1107382026-05-01T02:29:05ZDunn····Emma1944-10-28UHC-06624-87•••-••-7333511-601-9461EMMA.DUNN12@YAHOO.COM1261 Highland AveDenverColorado··80272GRP-8256MEDICARE-ADV-B
ENRENR-1060152026-08-17T19:05:50ZCamila·SSanchez1948-04-06UHC-10395-56•••-••-8546+1 260 240 0657CAMILA.SANCHEZ75@AOL.COM8452 Valley View DrHoustonTX77074GRP-4030SELECT-EPO
ENRENR-1082552026-08-09T18:22:51ZScottU.Castro12/17/76UHC-49142-95•••-••-3837·(649) 900-6219scott.castro53@yahoo.com7913 Desert Sky BlvdEden PrairieMNN/AGRP-0625SELECT-EPO
ENRENR-107836 2026-09-27T21:18:53ZCarol—Marshall19761016UHC-49170-62—nullcarol.marshall7@proton.me4091 Cedar LaneFresnoca93717GRP-8385··CHOICE-PLUS-PPO
ENRENR-1373432026-03-31T11:15:26ZDanielle—Hayes19600309UHC-23896-63•••-••-8921(601) 655-4805DANIELLE.HAYES@AOL.COM··4866 Hillcrest RoadGlendaleAZ85327GRP-4683OPTIONS-PPO
ENRENR-1104052026-09-09T15:46:01ZOlson, AlexisO—1974-03-23UHC-56808-89•••-••-5541+1 632 861 2995alexis.olson9@aol.com2050 River RdCharlotteNC28221GRP-5100CHOICE-PLUS-PPO
ENRENR-1367862026-09-29T17:10:37ZAmber—·Tran1950-07-23UHC-66499-50•••-••-0051·217-641-4689amber.tran@gmail.com7892 HIGHLAND AVE #733NASHVILLETN37202-7114GRP-6689CHOICE-PLUS-PPO··
ENRENR-1225182026-03-15T16:20:42ZvalenntinaYreid19941224UHC-47746-23•••-••-3105(568) 556-4769VALENTINA.REID@PROTON.ME2772 UNION STREETScottsdaleAZ85232GRP-4962·CORE-HMO
ENRENR-1226862026-02-04T00:22:15ZEdwardN.Gomez1995-05-03UHC-65993-61•••-••-9911274-671-8402edward.gomez@outlook.com6547 Ridge RoadEden PrairieMN55366GRP-1636MEDICARE-ADV-B
ENRENR-1235282026-03-15T19:59:40ZVirginia·SHarris19430423UHC-58262-17•••-••-9740869-460-9340virginia.harris34@gmail.com1341 HARBOR BLVDSEATTLEWA98144GRP-5858OPTIONS-PPO
ENRENR-1023402026-07-28T20:29:16ZhiroshiBcoleman—UHC2482494··•••-••-8200——3352 CENTRAL AVESan AntonioTX·78242GRP-4840NAVIGATE-HMO
ENRENR-1364782026-09-14T01:27:14ZSean—Kelly08/08/2003UHC-24159-74—278-482-6768SEAN.KELLY@YAHOO.COM4766 Grand AvenueEDEN PRAIRIE··MN55307GRP-6924CHOICE-PLUS-PPO
ENRENR-1144542026-08-28T14:52:26ZJULIEX··FLORES·1953-09-21UHC-04097-63•••-••-11034744329UNKNOWN3591 Grand AveChandlerAZ85260GRP-2966OPTIONS-PPO
ENRENR-1134802026-06-07T11:37:10ZRussellI.CampbellOct 19, 1957UHC-57582-13•••-••-3773+1 507 636 8220·UNKNOWN2288 Ridge Rd··MesaAZ85200GRP-8068SELECT-EPO
43,101 rows, page 307 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.600Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty