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-1158942026-05-31T20:00:48ZRUTHGDUNN12/22/2002UHC-79382-41•••-••-1720·(274) 947-7649—1310 Apache BlvdTampafl—GRP-7753CORE-HMO
ENRENR-1310602026-01-20T15:19:44ZJUSTINW.GARRETT1988-09-04NULL•••-••-6072(748) 510-2147null··1158 River RoadTAMPAFL33677GRP-4380medicare-adv-b
ENRENR-1366742026-08-19T17:01:18ZSANDRA·TJESEN1993-12-28UHC-72704-42···NULL877-573-9605NULL2493 Meadow Lane··Las VegasNVNULLGRP-2669OPTIONS-PPO
ENRENR-1022782026-02-04T15:51:48Z·CAROL—CARTER1941-03-06UHC-13659-35•••-••-6893(277) 335-3263UNKNOWN1517 Apache BlvdEden PrairieMN55369GRP-8264CHOICE-PLUS-PPO
ENRENR-1163902026-07-27T02:42:06ZDenise—Daniels1958-09-09UHC-62235-28•••-••-18846357629-6821 Meadow LnDallasTX75235GRP-7812CORE-HMO
ENRENR-1388522026-06-27T15:58:55ZHeatherURodriguez1942-02-16UHC-31342-40•••-••-6883300-808-3557heather.rodriguez@gmail.com460 Washington StreetMesaAZ85276GRP-1436MEDICARE-ADV-A
ENRENR-1138162026-01-07T19:27:32ZAmber—MitchellNov 14, 1943UHC-14221-60null519.994.4051-8182 Ridge RoadSacramentoCA95855GRP-1958SELECT-EPO
ENRENR-1008672026-05-18T02:39:21ZThomasAArnold2006-02-21UHC-89089-69•••-••-0498(202) 740-8513thomas.arnold94@aol.com1279 Forest AvenueMIAMIFlorida33181GRP-4352SELECT-EPO
ENRENR-1276312026-07-31T18:53:50ZEmily—Gonzalez06/09/84UHC-18091-41•••-••-7507(845) 995-6614N/A6656 RIVER ROAD·LOS ANGELESCA90034GRP-9977SELECT-EPO
ENRENR-123710 2026-05-04T17:51:48ZMarianaOHenderson·19751121UHC-66782-51•••-••-3439245-787-2277mariana.henderson@hotmail.com3178 Church StreetGilbertAZ85281GRP-2021NAVIGATE-HMO
ENRENR-138508 2026-02-21T12:34:15ZSharonQGibson1963-05-10UHC-70124-58•••-••-28174425597694sharon.gibson@aol.com4807 Baseline RdFresnoCA93714GRP-8370NAVIGATE-HMO
ENRENR-1026822026-07-08T20:44:00ZCharlotte B.—Smith12/17/1992UHC-45559-79•••-••-9969566.779.6574-·2953 Cedar LaneTAMPA·FL33699GRP-8897SELECT-EPO
ENRENR-1227252026-09-15T01:40:07ZAndrea··TLopez19431006UHC-05099-19•••-••-0756UNKNOWNANDREA.LOPEZ14@YAHOO.COM688 Valley View DriveMiamiFL33199GRP-7153MEDICARE-ADV-B
ENRENR-1213842026-08-21T19:23:05ZMorrison, FrancesS··—2006-04-09UHC-14630-02•••-••-43802715309872frances.morrison39@icloud.com5632 Baseline Road·NashvilleTN37262GRP-3992··OPTIONS-PPO
ENRENR-1023502026-03-27T06:49:25ZmatthewYgbison05-03-1973UHC-41424-77•••-••-4361361-267-8988-7642 MARKET STREETSacramentoCalifornia95816-2939GRP-7570NAVIGATE-HMO
ENRENR-1351072026-01-31T11:20:21ZJamesI.FreemanJan 4, 1985UHC-64293-35•••-••-7142—james.freeman72@aol.com6336 MARKET STREETCharlotteNC—GRP-3152MEDICARE-ADV-B
ENRENR-1219252026-01-24T14:06:46ZDeborah—Webb1956-10-16UHC-83661-45•••-••-0993(387) 358-1411deborah.webb@hotmail.com3508 Apache BoulevardSEATTLEWA98101GRP-4737MEDICARE-ADV-B
ENR ENR-1044602026-02-01T21:05:45ZMaldonado, Rachel——1940-03-05UHC-51088-81•••-••-1858—rachel.maldonado@icloud.com·1474 RIDGE ROADSacramentoCA95818GRP-5554CHOICE-PLUS-PPO
ENRENR-121944 2026-05-27T21:24:01ZAhmedHLewis1986-11-18UHC-62800-86•••-••-1152NULLAHMED.LEWIS@OUTLOOK.COM1864 Baseline RoadMiamiFlorida··33155GRP-2080CHOICE-PLUS-PPO
ENRENR-137221 2026-04-10T20:16:20ZtimothyJguzman1956-04-14UHC-86387-31•••-••-2992921-654-8684TIMOTHY.GUZMAN@YAHOO.COM1038 MESA DRSeattleWA98168GRP-6152MEDICARE-ADV-A
ENRENR-1238952026-09-28T11:38:22ZJessicaM.Boyd1977-11-15UHC-79586-37UNKNOWN5289719406JESSICA.BOYD71@ICLOUD.COM602 Cedar LnDenverCO80297GRP-2400MEDICARE-ADV-A
ENRENR-1143572026-07-25T12:11:58ZJackZBarnes1971-01-20UHC-12560-65•••-••-25044799329111jack.barnes@icloud.com8140 MAPLE AVENUECharlotteNC28250GRP-7318OPTIONS-PPO
ENRENR-1331482026-06-28T01:07:34ZSamanthaDValdez4/2/1973UHC-63204-93•••-••-14518598316933samantha.valdez68@hotmail.com7008 WASHINGTON STDenverCO80273GRP-1926SELECT-EPO
ENRENR-1372982026-06-16T13:50:53Zamber—obrien1986-01-02UHC-23418-47—6093746320—8267 SPRING STHOUSTONTX77031GRP-5927CORE-HMO
ENRENR-1427162026-02-03T01:51:22ZGeorge····Coleman1930-95-05UHC-22944-32NULL(286) 921-0112··7711 VALLEY VIEW DRIVESacramento··CA95896GRP-3695··MEDICARE-ADV-A
ENRENR-1360832026-10-08T23:55:01ZStephen—Le6/13/1969UHC-20135-30•••-••-69726429512670stephen.le@aol.com4470 Jefferson AvenueNASHVILLETN-GRP-7461SELECT-EPO
ENRENR-1143122026-01-31T16:24:39ZASHLEYFESPINOZA03/07/95UHC-29663-82•••-••-4538(597) 888-5504ashley.espinoza@gmail.com4517 Ocean AveGLENDALEAZ85308·GRP-4178NAVIGATE-HMO
ENRENR-1402922026-07-11T14:48:58ZAlan—Aguilar··1964-11-24uhc-36939-26··•••-••-4611685-817-0704—2959 LAKE VIEW RDAtlantaGA30392··GRP-9600··CHOICE-PLUS-PPO
ENRENR-1012372026-01-12T11:59:32ZSARRATGARDNER07-06-2001uhc-60628-62•••-••-0613268.549.7540—3480 Sage CourtFRESNOCA93717GRP-4129CORE-HMO
ENRENR-1006482026-07-18T13:44:52ZFrankZ.Medina1968-07-25··UHC-52511-21•••-••-2540UNKNOWN··frank.medina@aol.com8665 Cedar LnTampaFL33624GRP-8649navigate-hmo··
ENRENR-1004622026-10-01T13:39:13ZTerry—Edwards1951-05-18UHC-82887-97•••-••-15299146355492terry.edwards@aol.com1429 DESERT SKY BLVDMiami··FL33169·GRP-4954CHOICE-PLUS-PPO
ENRENR-1234022026-01-29T05:02:13ZWalter—Chavez1994-05-07UHC-49446-32—3416809590null7980 Maple Ave Apt 22Austintx·78761GRP-5337MEDICARE-ADV-B··
ENRENR-1370782026-09-03T13:37:36Z JASON R.—MORGAN2006-04-10UHC-31457-91•••-••-5109504-271-8566NULL2752 HILLCREST ROADTampaFLN/AGRP-2075OPTIONS-PPO
ENRENR-1078272026-06-28T07:52:08Zjanice—phillips19-07-1982··UHC-17792-86•••-••-0026(821) 670-8173JANICE.PHILLIPS12@GMAIL.COM5098 Pine DrDallasTX75203GRP-2723MEDICARE-ADV-A
ENRENR-1189902026-09-18T04:54:40ZGloria—Richardson1981-06-07UHC-97404-89—(816) 822-2234NULL920 Meadow LnTempeAZ85293GRP-9519CORE-HMO
ENRENR-1298872026-10-02T02:12:58ZBrendaGWillis1953-12-11UHC1592805•••-••-5411895-925-8544brenda.willis@hotmail.com9873 Union St Apt 17·PlanoTX75022·GRP-4207MEDICARE-ADV-A
ENRENR-1383222026-07-03T08:15:24ZKENNETH—MCDONALD12/23/2002UHC-23880-38N/A2342356337UNKNOWN·1501 River RdTampaFL33610-9553GRP-9920CHOICE-PLUS-PPO
ENRENR-1041002026-04-19T09:17:34ZRachel—Orttega··11/23/02UHC-30814-10UNKNOWN16176168733N/A7804 Hillcrest Rd··San DiegoCalifornia92136GRP-9638MEDICARE-ADV-A
ENRENR-1250882026-02-17T12:49:56ZCHRISTINAT.CLARK1974-11-10UHC-10282-83•••-••-9952488-377-5230christina.clark60@gmail.com·NULL—UNKNOWN··NULLGRP-8147MEDICARE-ADV-B
ENRENR-1380922026-09-04T03:09:40ZPowellYTheresaJan 21, 1989UHC-35121-61N/A539-251-7226theresa.powell@aol.com852 LINCOLN WAY··NashvilleTN37278GRP-3314CHOICE-PLUS-PPO
ENRENR-1092722026-08-28T01:44:27Z·MariL.·Collins1938-11-13uhc-92321-89•••-••-5689(636) 210-4997—9590 Central AvenueMesaAZ85261GRP-8831NAVIGATE-HMO
ENRENR-1179922026-01-09T10:30:00ZBRADLEYU.FOWLR1996-12-25UHC-39855-06•••-••-5921—N/A9853 Lake View RdGilbertazNULLGRP-6941MEDICARE-ADV-B
ENRENR-1293502026-08-03T16:37:41ZTerresa····GoznalesApr 21, 1942UHC-97031-33•••-••-3706+1 215 234 7945NULL7497 Park PlaceAustinTX·78716·GRP-2000SELECT-EPO
ENRENR-112101 2026-07-07T16:03:25ZJeremy—OrtegaSep 9, 2003··UHC-87553-57•••-••-60136756763560jeremy.ortega62@proton.me9112 Mesa DriveAtlantaga·30373GRP-1514·CORE-HMO
ENR ENR-1034892026-08-28T21:18:05ZFRANCESXBERRY1944-11-28UHC-94512-88•••-••-4694(587) 818-8656FRANCES.BERRY@YAHOO.COM1982 DESERT SKY BOULEVARDDallasTX75231GRP-8474NAVIGATE-HMO
ENRENR-1133712026-01-15T15:17:31ZANN—LAWSON1968-10-16UHC-56133-10·-+1 573 701 4616ann.lawson@aol.com9722 CAMELBACK RDCharlotteNorth Carolina28260GRP-5124CHOICE-PLUS-PPO
ENRENR-1383632026-02-04T04:07:14ZALAN—MCDONALD1978-06-07UHC-93299-85··•••-••-0716768.879.2119null775 JEFFERSON AVEOrlandoFL32814-9713GRP-4298MEDICARE-ADV-B
ENRENR-1369692026-05-09T07:51:48ZVictoria—Ramirez1987-10-14UHC-23414-82•••-••-3349(482) 845-7852victoria.ramirez46@aol.com3413 Desert Sky Blvd·MESAAZ85267··GRP-5875·core-hmo
ENRENR-1025892026-07-10T16:28:24Z·Adams, JaniceT—19601020UHC4960518—(259) 893-3633janice.adams@yahoo.com6917 FOREST AVENUEGilbert··AZ85242GRP-5613CHOICE-PLUS-PPO
ENRENR-1158952026-06-08T23:41:00ZRuth—Dunn2002-12-22UHC-79382-41—-·UNKNOWN1310 Apache BoulevardTAMPA·FL33623GRP-7753CORE-HMO
43,101 rows, page 192 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:40.330Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty