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-1061822026-02-25T02:56:06ZMatthew··—Castillo1997-01-14UHC-52678-81•••-••-2212208-202-8417matthew.castillo@proton.me875 Church StSacramentoCA95839GRP-6612MEDICARE-ADV-B
ENR ENR-1270082026-04-05T21:06:54ZYUKIU··AGUILAR1948-08-07UHC-15243-44•••-••-1472+1 280 680 2898YUKI.AGUILAR53@ICLOUD.COM1365 Ridge RoadLos AngelesCA90076GRP-6605SELECT-EPO
ENRENR-1377642026-06-03T02:55:05ZBilly—Vargas1955-10-23UHC5586583•••-••-086413144192218BILLY.VARGAS@ICLOUD.COM4649 Sage CourtSan AntonioTX78278-6922GRP-9643NAVIGATE-HMO
ENRENR-1099892026-07-20T06:10:19ZWilliamO.McDonald1987-08-17··UHC0436574•••-••-24025639889435··N/A2281 PINE DRIVELas VegasNVUNKNOWNGRP-4289MEDICARE-ADV-A
ENRENR-1422272026-03-06T12:55:47ZHarris, ArjunE.—1956-09-01UHC-30276-02•••-••-527316762220766—8466 Apache BoulevardMinneapolisMN55486GRP-9673MEDICARE-ADV-A
ENRENR-1073862026-01-12T01:19:43Z HIROSHIESPENCER1942-07-21UHC-57930-92•••-••-7019(877) 947-3411HIROSHI.SPENCER@OUTLOOK.COM6871 Valley View Drive··FresnoCA93767GRP-8653CORE-HMO
ENRENR-1389872026-10-18T08:59:55ZCHARLOTTER.ROJAS1962-09-24UHC-15473-96•••-••-8063557.290.8464CHARLOTTE.ROJAS4@ICLOUD.COM1589 River RoadSeattleWA98163GRP-4690MEDICARE-ADV-B
ENRENR-1383912026-04-08T19:17:27ZJeffrey··L.Stewart··14-09-1951—•••-••-7623(809) 667-9938—9574 MAPLE AVEOrlandoFL32899-3902GRP-1277SELECT-EPO
ENRENR-1107642026-04-24T16:59:17ZOwensODonna2000-87-10UHC-85375-59•••-••-26514068516946DONNA.OWENS@PROTON.ME8046 OAK STREETGlendaleAZ85349GRP-8872MEDICARE-ADV-B
ENRENR-1269682026-02-21T05:35:53ZRogerKHoward1981-11-11UHC-06462-65•••-••-8112(571) 849-4467roger.howard@gmail.com8865 Bayshore Drive Apt 36TampaFL33630GRP-1084CORE-HMO
ENRENR-1162982026-07-19T22:10:33ZJACK—RUSSELL19720412UHC-66734-66•••-••-4251(671) 954-2282jack.russell27@yahoo.com—UNKNOWN··—-GRP-3876NAVIGATE-HMO
ENRENR-1273092026-09-11T08:41:23ZKellyMGordon19600628UHC-12821-62•••-••-28296136441940kelly.gordon@icloud.com2520 Indian School RoadSan AntonioTX78264·GRP-3030medicare-adv-a
ENRENR-1376382026-10-11T11:02:45ZZACHARY—YOUNG1960-06-23UHC-34768-50•••-••-656413274328626zachary.young@icloud.com·2670 APACHE BOULEVARDFresnoCA93767GRP-2429OPTIONS-PPO
ENRENR-1270412026-05-28T07:35:39Z JOYCE—ANDREWS04/05/2003UHC-90507-70•••-••-5945(411) 898-4468—4125 Indian School RdDenverCO80243-9574GRP-1624SELECT-EPO
ENRENR-1105682026-07-14T18:14:56ZThomsI.Sullivan1982-02-28UHC-43686-23····17659727137UNKNOWN3863 River RdTampaFlorida33672GRP-2560·CHOICE-PLUS-PPO
ENRENR-1067632026-09-06T14:13:53ZDebraTBaileey11/17/1998UHC-31273-63null17817078933N/A6890 SUNSET BLVDEden PrairieMN55336GRP-8551core-hmo
ENRENR-1180022026-05-07T17:15:20Zaaron··medina··19950113UHC7616782•••-••-7033(689) 637-5123—8141 Jefferson AveMiamiFL·33176GRP-3953CORE-HMO
ENRENR-1342542026-05-29T15:58:14ZJese·PPark1950-02-11UHC-31353-24NULL948-722-5676N/A5096 VALLEY VIEW DRCharlotteNorth CarolinaNULLGRP-9634NAVIGATE-HMO
ENRENR-1135262026-01-12T23:09:01ZangelaJ.foster1989-05-22··UHC-87261-18•••-••-0785(613) 685-5579angela.foster74@icloud.com5359 BASELINE ROADSan Antonio··TX78284GRP-5178medicare-adv-b
ENRENR-1150212026-01-04T06:59:34ZVirginiaTWright01/25/1950·UHC-50653-70NULL748-272-6254null4695 Market St··Los AngelesCA90035GRP-7828MEDICARE-ADV-B
ENRENR-1074392026-09-15T04:33:03ZChristineMHughes1972-03-10UHC-91365-45•••-••-5862284-935-7452christine.hughes@outlook.com6850 Baseline RdSeattleWA98113·GRP-9464·MEDICARE-ADV-A
ENRENR-1288982026-05-16T20:36:07ZHAROLDI.NUNEZ·1994-02-23UHC-70318-42•••-••-5706+1 770 212 8551HAROLD.NUNEZ@ICLOUD.COM8831 GRAND AVETucson··AZ85719GRP-5964MEDICARE-ADV-B
ENRENR-1051992026-04-30T18:19:22ZAdamTCarpenter17-10-2004UHC-12197-98•••-••-02449389440706—8779 Central Avenue·CharlotteNC28234GRP-8046CHOICE-PLUS-PPO
ENRENR-1289372026-07-25T17:08:09ZSchmidt, Matthew——1990-04-09UHC-21293-99•••-••-08307876960213null5622 Elm StreetSeattleWA98151GRP-0103NAVIGATE-HMO
ENRENR-1337682026-07-14T08:12:28ZHaroldY··Porter05/01/1942UHC-09588-38•••-••-0802269.862.1952·NULL2658 GRAND AVEGlendaleArizona85372··GRP-7148OPTIONS-PPO
ENRENR-1114652026-08-29T04:16:57ZGaryKStone1958-03-14UHC-84473-40•••-••-3295373-254-4516GARY.STONE42@HOTMAIL.COM9048 Church StreetSan AntonioTXNULLGRP-1030SELECT-EPO
ENRENR-1185212026-06-19T09:21:30ZDEBORAH··R.···BURKE1985-12-12UHC-62683-57•••-••-93726935816501N/A2403 MAPLE AVENUE·COLUMBUSOH43209GRP-1655MEDICARE-ADV-B··
ENRENR-1306602026-02-19T12:43:43ZCarl—Cook·2004-02-25UHC-49730-21•••-••-7297+1 411 811 8381carl.cook58@gmail.com9307 Camelback RdPlanoTX75022GRP-6539CHOICE-PLUS-PPO
ENRENR-1017742026-08-03T09:09:13Z·JeanMBennett1988-07-22UHC-16157-76•••-••-85253654517983jean.bennett@hotmail.com435 HARBOR BLVDLas VegasNV89134GRP-8567SELECT-EPO··
ENRENR-1053122026-02-25T15:41:57ZPriyaSPena2004-10-22UHC-70426-23•••-••-849719008685574priya.pena41@outlook.com5528 Willow CourtMESAAZ—GRP-3175NAVIGATE-HMO
ENRENR-1090472026-09-03T12:05:27Z·Stewart, Betty·H.—1963-09-14-NULL7302207701-468 Highland AvenueColumbusOH43208GRP-0710MEDICARE-ADV-A
ENRENR-1239932026-07-14T08:59:11Zamy—mccy10/19/1971··UHC4271667•••-••-1269N/A-7151 BROADWAY··ChandlerAZ85294GRP-4032SELECT-EPO··
ENRENR-1016652026-02-10T13:00:13ZVirginiaL.Thomas5/17/1988UHC-94590-15•••-••-6591+1 912 570 1293null1797 LAKE VIEW RDGILBERTArizona85235GRP-3150MEDICARE-ADV-A
ENRENR-1334932026-02-11T02:05:33ZMICHAEL—BAKER·20030712UHC-14690-92•••-••-228315117080718-3497 OAK STREETEden PrairieMN55304GRP-5726MEDICARE-ADV-A
ENRENR-1179582026-09-08T04:57:38Zarthur—richards5/11/1984UHC-97857-60•••-••-9267529-736-8430—4040 Baseline RdLos AngelesCalifornia90045GRP-1516MEDICARE-ADV-A
ENRENR-1021382026-09-22T15:12:48ZAaronU.Padilla1948-01-22·UHC-23716-20•••-••-5606364-659-9158aaron.padilla65@proton.me3528 UNION STREETLos AngelesCA90017GRP-9289OPTIONS-PPO
ENRENR-1320212026-07-18T06:14:10Zjudith—daniels1991-09-06··UHC-07841-73•••-••-5671635.417.8899judith.daniels38@proton.me7465 Camelback RdNashvilleTN37250GRP-1773MEDICARE-ADV-B
ENRENR-1194472026-09-06T16:30:05ZEugene—Fowler03-11-1938UHC-40729-20•••-••-30417253341434·EUGENE.FOWLER@ICLOUD.COM·5011 Desert Sky BoulevardPhoenixAZ85090··GRP-0866NAVIGATE-HMO
ENRENR-1300332026-06-23T15:54:50Z·Stephanie—·Williamson1940-95-06UHC-63783-56•••-••-856919729341424stephanie.williamson8@aol.com4702 CENTRAL AVENUEAustinTX78722GRP-4774MEDICARE-ADV-A
ENR ENR-1249942026-05-15T21:57:48Z Sarah—Luna·1994-12-16uhc-62532-33•••-••-46013068784444sarah.luna82@icloud.com7313 BAYSHORE DRIVESacramentoCA··95800GRP-8505OPTIONS-PPO··
ENRENR-1263422026-01-30T16:58:07ZJulie—Parker11/17/57··UHC-17844-10•••-••-3119(866) 899-8377julie.parker33@gmail.com5167 MAIN STREETNASHVILLETN—GRP-5168SELECT-EPO
ENRENR-1313592026-03-26T03:44:04ZLUCIA—·MRPHY1946-03-09··uhc-37602-07•••-••-2196786-226-9637lucia.murphy@aol.com5132 Main StPhoenixAZ85090GRP-8076SELECT-EPO
ENRENR-1149752026-07-11T03:24:56ZMateo—Medina03/15/50UHC-80796-72··N/A+1 774 953 0209MATEO.MEDINA@AOL.COM5639 Willow CourtSACRAMENTOCalifornia95805GRP-7214CHOICE-PLUS-PPO
ENRENR-1068232026-06-25T22:23:35ZJACOB—SCOTT·1995-09-05UHC-63996-57•••-••-6004236.642.7446jacob.scott16@yahoo.com5350 Apache Boulevard··DenverCO—GRP-0549MEDICARE-ADV-B
ENRENR-1314352026-09-13T23:11:13ZMASON—SCHULTZ·1/26/1953UHC-06517-82··•••-••-2798460-918-8267MASON.SCHULTZ@PROTON.ME8463 Willow CourtCHANDLERaz85202GRP-9145MEDICARE-ADV-A
ENRENR-1384132026-09-09T10:51:32ZCHARLOTTE—·AUSSTIN1940-10-01··UHC-73196-91N/A-charlotte.austin95@gmail.com1874 PALM DRIVE·ScottsdaleArizona85240GRP-3392OPTIONS-PPO
ENRENR-1279482026-03-08T11:34:00Z·Clark, MichelleO··—1987-06-28UHC-76779-12•••-••-8538(718) 627-5243—4196 Union Street #234MiamiFL33116GRP-9549SELECT-EPO
ENRENR-103847 2026-07-06T05:13:42ZKIMBERLYA.BUTLER1938-02-21UHC-78911-70UNKNOWN·+1 569 576 7545kimberly.butler73@icloud.com8151 MESA DR Apt 15SEATTLEWA98180GRP-2589OPTIONS-PPO
ENRENR-1169142026-05-04T03:37:58ZKAYLA—MITCHELL1972-05-03UHC-33883-90•••-••-2021+1 231 945 8898kayla.mitchell@yahoo.com178 Forest Ave Apt 15CharlotteNC28265GRP-5686CHOICE-PLUS-PPO
ENRENR-1136942026-05-22T11:17:03ZRebeccaSSpencer1981-04-06UHC-40057-75··•••-••-05577437495281—5824 Bayshore DrHoustonTX77006GRP-2119NAVIGATE-HMO
43,101 rows, page 245 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.627Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty