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-1129852026-01-28T13:54:28ZStevenM.Gray19690702UHC-78165-78•••-••-93836799746630STEVEN.GRAY1@YAHOO.COM8064 DESERT SKY BLVD··ORLANDOFL32870GRP-2492MEDICARE-ADV-A
ENRENR-1423142026-06-08T18:27:30ZNicole—Coleman1951-12-17UHC-99920-82•••-••-6203+1 567 544 8071NICOLE.COLEMAN67@ICLOUD.COM4557 Ridge RoadScottsdaleAZ·85234GRP-2417··NAVIGATE-HMO
ENRENR-1311552026-05-19T16:45:53ZYukiTJohnson06-07-1960··UHC-34539-08•••-••-22502568028066YUKI.JOHNSON@YAHOO.COM·8287 Apache Boulevard Apt 11ColumbusOH43255-2041GRP-2542CORE-HMO
ENRENR-1155952026-05-03T21:15:12ZKathrynYMarqueznullUHC-99441-94•••-••-0673(241) 681-0562KATHRYN.MARQUEZ44@OUTLOOK.COM8346 Baseline RdTucsonAZ85740GRP-9643SELECT-EPO
ENRENR-1050192026-05-07T19:45:25ZARJUNVVARAS20060309uhc-30971-89•••-••-3011250-988-7295UNKNOWN2447 Apache BoulevardSan DiegoCA92187GRP-2648choice-plus-ppo
ENRENR-1286642026-09-18T06:32:21ZJackson, Henry——19891205UHC-36524-58•••-••-53097029960-6758 Forest Avenue·EDEN PRAIRIEMN55323-2429GRP-4563·OPTIONS-PPO
ENRENR-1029752026-07-10T14:16:52ZJENNIFERPSILVA1938-10-06UHC-96114-69•••-••-4992573.883.1960JENNIFER.SILVA70@AOL.COM127 INDIAN SCHOOL ROAD··CharlotteNC28274·GRP-4733CHOICE-PLUS-PPO··
ENRENR-1038912026-07-25T13:49:57ZericFellisUNKNOWN·UHC0346815•••-••-6636476-295-5422ERIC.ELLIS@GMAIL.COM——UNKNOWN··NULLGRP-4949CORE-HMO
ENRENR-1233412026-06-12T01:38:02ZDebra—Anderson10/07/63UHC-15730-68•••-••-5429N/ADEBRA.ANDERSON@OUTLOOK.COM4484 River Rd·AtlantaGA-GRP-1201SELECT-EPO
ENRENR-1068082026-01-01T03:42:31ZDanielleFSchultz1946-09-04UHC-69678-97•••-••-5268374.470.3471danielle.schultz@hotmail.com·9873 MESA DRIVEMiamiFL33120GRP-2489CORE-HMO
ENRENR-1159792026-04-11T02:58:02ZJeffreyZ.Shaw1971-09-20UHC-23558-85•••-••-9440+1 733 378 7295jeffrey.shaw94@icloud.com403 River RdLos AngelesCA90098GRP-7544SELECT-EPO
ENRENR-1080782026-02-08T00:17:01ZAUSTINPROBERTSONApr 21, 1968UHC-38894-44•••-••-4901207.858.7613austin.robertson@proton.me8721 Palm DrLAS VEGAS··nv·89127GRP-3089CHOICE-PLUS-PPO
ENRENR-1147482026-02-11T17:54:03ZEric—Rios1966-11-30UHC-71144-96N/A(350) 283-9364UNKNOWN3440 Willow CourtAtlantaga30382GRP-2724·MEDICARE-ADV-B
ENRENR-1381822026-05-27T17:14:20ZLarryDTaylor19390410UHC-50593-59•••-••-96439124901348larry.taylor@gmail.com3402 OCEAN AVENUETampaFL33652GRP-0400SELECT-EPO
ENRENR-1153792026-03-09T07:47:11Z Angela—Hunt20050402··UHC-92066-14•••-••-9952(334) 455-7266angela.hunt12@yahoo.com7607 Grand Ave··SeattleWA98147GRP-4515MEDICARE-ADV-A··
ENRENR-1161962026-09-27T04:52:53ZPRIYA—WARREN1987-11-26UHC-51416-35•••-••-5858559-650-4206priya.warren@hotmail.com9787 Park PlaceGlendaleAZ85331GRP-7270NAVIGATE-HMO
ENRENR-1103842026-10-09T11:51:23ZNOAH—·EDWARDS04-07-1972UHC-12310-14•••-••-83179478814147NULL··7980 BASELINE ROADHoustonTX··77075-8497GRP-6077MEDICARE-ADV-A
ENRENR-1348942026-03-17T11:27:32ZGERALDTSANDOVAL2003-08-02UHC-55276-10··•••-••-7053(727) 582-7234gerald.sandoval@aol.com7512 Valley View DrPhoenixAZ85065GRP-3718CHOICE-PLUS-PPO
ENRENR-1233142026-01-12T11:38:39Zmaggie—morales1955-04-15·UHC-83089-06—5502968008margaret.morales44@aol.com3331 JEFFERSON AVEMiamiFL33161GRP-1103MEDICARE-ADV-A
ENRENR-1187722026-06-15T00:38:32ZZachary—WatkinsMar 15, 1962UHC-26709-92•••-••-2958(712) 685-3630zachary.watkins@outlook.com9266 RIDGE RDAtlantaGA··30322GRP-9913MEDICARE-ADV-A
ENRENR-1133112026-01-31T01:19:43ZPeterFBrooks1996-05-06uhc-55560-09-885-968-6224·N/A388 Highland Ave #113SacramentoCalifornia95832GRP-7579OPTIONS-PPO
ENRENR-1280682026-02-19T22:10:11ZBowman, AishaU—19510306UHC-79685-07•••-••-955814402392319AISHA.BOWMAN97@HOTMAIL.COM5287 Sage CourtMiamiFL33161GRP-2671OPTIONS-PPO
ENRENR-1111242026-05-25T13:25:33ZMeiEWallaceDec 21, 1956UHC-83382-72•••-••-263013827610724—6717 Pine DrEDEN PRAIRIEMN55375GRP-1373medicare-adv-b
ENRENR-1330262026-03-04T12:12:26ZMontgomery, Justni——1946-04-08UHC-40036-63•••-••-54802729326714—6268 Cedar Lane·Los AngelesCA90091GRP-1754CORE-HMO
ENRENR-1133152026-07-02T04:02:58ZREBECCA—SCHULTZ1951-02-20UHC-71809-10•••-••-63443428799932UNKNOWN765 Sunset BlvdPlanoTX75033GRP-6508MEDICARE-ADV-B
ENRENR-1246462026-10-16T09:17:13ZEugeneK·Nuenz1969-01-28UHC-43631-44•••-••-5559—UNKNOWN2385 Mesa DriveSacramentoCA95807GRP-7684·MEDICARE-ADV-A
ENRENR-1134382026-06-26T01:26:17ZSARAH—LARSON·1993-05-11UHC-85512-59•••-••-7131(446) 764-5531-··6521 RIVER RD #593DallasTX75269GRP-8925NAVIGATE-HMO
ENRENR-1365022026-09-02T04:49:35ZjackImoore·22-07-1966UHC-62350-39•••-••-739512639490973jack.moore41@proton.me8355 FOREST AVENashvilleTN37201GRP-7826CHOICE-PLUS-PPO
ENRENR-1331192026-01-19T00:40:50ZAna—Warren01/25/63UHC-07289-96•••-••-68958985272346ANA.WARREN@OUTLOOK.COM4132 Hillcrest Rd··ChandlerAZ85225GRP-0634MEDICARE-ADV-B
ENRENR-1064512026-09-14T22:51:16ZMarcusYPayne1962-12-06UHC-10387-43N/A15854635926NULL8525 Main StreetAustinTX··78749GRP-8061MEDICARE-ADV-A
ENRENR-1043092026-03-06T00:22:37Znicole—obrien1959-10-03UHC-25889-95····228-416-6385nicole.obrien98@icloud.com-··——GRP-0315OPTIONS-PPO
ENRENR-1270562026-10-16T15:52:08ZFowler, Dorothy——06-02-1990··UHC-10722-65—(536) 359-2077NULL2653 Lincoln WayPhoenixAZ85079GRP-6144NAVIGATE-HMO··
ENRENR-1045822026-07-10T05:04:39ZGLORIA—DOMINGUEZ03/11/1943UHC-76111-65•••-••-5145879-506-2933null9701 Sunset BoulevardLAS VEGAS·NV89158GRP-6165SELECT-EPO
ENRENR-1128342026-02-05T16:54:23ZVazquez, Steven——1997-02-28UHC-56994-16•••-••-7582982-584-1612UNKNOWN2766 Spring StTucsonaz85730GRP-0548MEDICARE-ADV-A
ENRENR-1229092026-03-03T19:30:09ZAndrew—Ross02/09/2003UHC-96333-70•••-••-6867825-258-4957andrew.ross29@hotmail.com8067 MEADOW LANESEATTLEWA98192··GRP-6029CORE-HMO
ENRENR-1321342026-08-27T11:40:39ZJacob—Alvarez19720409UHC-66933-02•••-••-92115552937460jacob.alvarez@outlook.com5535 Indian School RoadColumbusOhio·43282GRP-8718CHOICE-PLUS-PPO
ENRENR-1180532026-05-27T23:06:40ZPHILIPP.PERKINS1985-11-14UHC-26799-26—3898382283UNKNOWN1318 Spring StEden PrairieMN55341-2844GRP-5724MEDICARE-ADV-A
ENRENR-1419462026-09-28T19:58:47Zrandy A—foster2000-01-18UHC-46657-20··•••-••-8490354.472.3810randy.foster@hotmail.com8906 Palm DrDenverCO80215GRP-2382OPTIONS-PPO
ENRENR-1022982026-03-18T05:32:00ZANGELA—FOWLER··1969-11-24UHC-91761-70•••-••-0278(405) 558-1516UNKNOWN1269 SAGE COURT·TempeAZ85283GRP-8618MEDICARE-ADV-B
ENRENR-1113122026-07-15T01:45:55ZMarilynH.Nichols06-03-1944UHC-21475-31—12109932813marilyn.nichols85@aol.com5511 Baseline RdNASHVILLETN37215GRP-2889SELECT-EPO
ENRENR-1117412026-06-15T17:35:05Z JESSE—COLE1951-08-18··UHC-22366-11•••-••-1088210-666-7069jesse.cole67@outlook.com295 Canyon RoadDenverCO80230GRP-5943MEDICARE-ADV-B
ENRENR-1160612026-05-29T08:31:05ZARJUNOWONG1993-08-22·UHC-77127-41•••-••-5604·4293948346arjun.wong@hotmail.com1565 Sunset BoulevardGilbertArizona85242GRP-9980CORE-HMO
ENRENR-132864 2026-08-10T02:55:29ZJordanXBarnes1939-02-03UHC-71584-67•••-••-8370+1 275 229 7252jordan.barnes64@hotmail.com6024 Main StreetScottsdaleAZ·85298GRP-3416NAVIGATE-HMO
ENRENR-1282382026-02-23T14:59:13ZMichael—Hanson19830701UHC-75772-33•••-••-413312112705171michael.hanson@outlook.com3342 Sage CourtFresno·CA93738GRP-8732OPTIONS-PPO
ENRENR-1372402026-01-05T03:33:00ZRAYMOND—HILL1979-07-20UHC-45778-72•••-••-2018-RAYMOND.HILL@OUTLOOK.COM9453 Mountain View DrCHARLOTTENC··28263··GRP-9688choice-plus-ppo
ENRENR-1113022026-02-10T23:22:59ZAshley—Campbell1952-04-19UHC-46550-06•••-••-2902·(913) 778-0311ashley.campbell@hotmail.com3440 Central AvenueTucsonAZ85733GRP-5225CORE-HMO
ENRENR-1374372026-03-10T09:02:54ZMeiHTorres1961-08-22UHC-13007-34UNKNOWN(287) 932-8570mei.torres7@outlook.com7477 Oak StreetFRESNOCA93730GRP-2670SELECT-EPO
ENRENR-1032492026-02-02T06:55:19Z FrancesCSanders19-12-1995UHC-30460-10•••-••-0472(556) 434-5258·frances.sanders@icloud.com9272 MEADOW LNMiamiFL33150-5699GRP-0394·MEDICARE-ADV-B
ENRENR-1017892026-09-10T19:30:41ZarthurBbanks1955-09-13·UHC-07479-38NULL9616569null5876 Bayshore DrSeattleWA98111GRP-4739MEDICARE-ADV-A
ENRENR-1002542026-09-07T08:59:30ZPteerOCarroll9/4/1951UHC-31513-54—(829) 687-5338peter.carroll25@outlook.com1891 Market StreetJacksonvilleFL32200GRP-5114MEDICARE-ADV-B
43,101 rows, page 299 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.460Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty