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-1387972026-04-02T05:03:41ZDENISE—GRAY2001-03-07—•••-••-7895973-481-9759denise.gray@hotmail.com6142 Indian School RdColumbusOH43203GRP-6672CORE-HMO
ENRENR-1187232026-10-01T23:09:57ZBrittanyARomero1960-07-06UHC-23742-38•••-••-7965(300) 364-2246·brittany.romero55@yahoo.com·1712 Ridge RoadDallasTX75267GRP-1029MEDICARE-ADV-A
ENRENR-1244792026-07-24T17:06:53ZCunningham, Jesse—····1979-01-08··UHC-74903-88•••-••-22198618908687JESSE.CUNNINGHAM@ICLOUD.COM8321 MESA DRDallasTX75224·GRP-3399NAVIGATE-HMO
ENRENR-1357442026-09-21T17:12:30ZDORIS—RYANAug 24, 1981UHC-04166-33-(359) 690-9950null2666 Sage CourtMINNEAPOLISMNN/AGRP-1211SELECT-EPO
ENRENR-1092302026-02-12T14:10:37ZStephanieV.Hart1987-08-13UHC-79424-39•••-••-396518822966984stephanie.hart@proton.me9207 Park PlAustinTX·78730GRP-7378CORE-HMO··
ENRENR-1258082026-05-20T21:57:40ZJESSICAPLANE··20-09-1971UHC-38571-56•••-••-781617589210613jessica.lane@proton.me·7112 Grand Avenue·PhoenixAZ85052·GRP-0995CORE-HMO
ENRENR-1068532026-09-12T08:35:50ZbradleyOtran1967-01-22UHC-24626-93•••-••-5960(972) 202-8941bradley.tran67@proton.me1840 Mesa DrNashvilleTN·37257GRP-3216SELECT-EPO
ENRENR-1385182026-02-18T12:06:37ZJEREMYWDUN7/21/1989UHC-55421-50•••-••-43588174769707—8291 Maple AveHOUSTON··TX77080GRP-2741CHOICE-PLUS-PPO
ENRENR-1402482026-02-02T04:53:21ZBryan—Wallace9164-12-01UHC4320036•••-••-82536908774170—399 DESERT SKY BOULEVARDNashvilleTN37226-4521GRP-8321medicare-adv-a
ENRENR-1389482026-04-25T01:32:52ZDabraTCarlson1955-01-16UHC-48214-96•••-••-1581822-553-3351debra.carlson21@gmail.com3548 MOUNTAIN VIEW DRIVEScottsdaleAZ85231-2507GRP-7096MEDICARE-ADV-B
ENRENR-1273612026-07-29T01:40:07ZAshleyAPena1957-02-20UHC-93084-46•••-••-0057(423) 789-3266ashley.pena@yahoo.com5362 Church StLos AngelesCA90017GRP-9610··CHOICE-PLUS-PPO
ENRENR-1343452026-01-22T06:08:48ZKATHRYNY.REID1978-02-14UHC-51465-34•••-••-07367579101309kathryn.reid@outlook.com1710 Lake View RoadSeattleWA98187GRP-3830CORE-HMO
ENRENR-1413992026-07-25T01:10:30ZJONAFHARRIS1994-07-26UHC-53549-85•••-••-3921378-452-6914—2628 Lincoln WayMinneapolisMN55446GRP-8479CHOICE-PLUS-PPO
ENRENR-1000022026-07-22T16:56:21ZLAURA—ALVARADO1939-03-06UHC-46111-16•••-••-3696(208) 204-6344null4347 Church St··PlanoTX75086GRP-5461NAVIGATE-HMO
ENRENR-1071802026-04-27T17:31:49ZTERRYQ.··WONG··1942-08-17UHC-43194-92··•••-••-67538886964622—4830 Hillcrest RdFRESNOCA93700GRP-2446··SELECT-EPO
ENRENR-1091452026-01-31T20:26:46ZPrice, PriyaT··—2/12/1961UHC-82854-83•••-••-8931—priya.price33@aol.com8797 BASELINE ROADCharlotteNC28253GRP-8327SELECT-EPO
ENRENR-1350482026-08-31T23:10:30ZLoganVSchultz2004-02-28UHC-94309-77•••-••-10987955031148logan.schultz@hotmail.com8298 Indian School RoadPlanoTX75032·GRP-2676MEDICARE-ADV-A
ENRENR-1029222026-06-09T21:14:00ZGeorge—Moore06/26/1961UHC-38208-36··•••-••-9941(474) 628-8076george.moore@gmail.com3677 Valley View DriveAtlantaGA30352GRP-5103MEDICARE-ADV-B··
ENR ENR-1030592026-01-14T09:44:26ZJack L.—·Lee08/09/1991UHC-43520-33•••-••-9239(441) 788-5629jack.lee@yahoo.comN/A··UNKNOWN—GRP-4649·MEDICARE-ADV-B
ENRENR-1147542026-08-11T11:53:14ZBRYAN·····MORRISON1992-11-17UHC-63751-61•••-••-57324375779bryan.morrison3@hotmail.com·2645 HARBOR BOULEVARD Apt 40·SeattleWA98155GRP-6204MEDICARE-ADV-B··
ENRENR-1115152026-06-05T18:42:13ZLarry, CruzO.—1999-07-15UHC-19187-56•••-••-8073(625) 249-8024—1872 ELM STREETSeattle··Washington·98128GRP-7475MEDICARE-ADV-B
ENRENR-1312352026-05-19T17:48:37ZDiana··Aguilar··2003-11-20UHC-20499-18•••-••-7206+1 521 615 5886diana.aguilar69@gmail.com2189 JEFFERSON AVENUEEden PrairieMNUNKNOWNGRP-6122··navigate-hmo
ENRENR-1159592026-09-29T13:30:36ZAaronT.Daniels2004-01-07UHC-38053-93•••-••-9249—aaron.daniels@outlook.com1963 CANYON RDEden PrairieMN55327GRP-3313CORE-HMO
ENRENR-1288372026-10-17T05:13:31ZNoah—Park1979-10-18UHC-63320-76•••-••-35853307778973··NOAH.PARK@YAHOO.COM9779 Harbor BlvdTucsonAZNULLGRP-8018OPTIONS-PPO
ENRENR-1222052026-07-22T17:35:15ZAdamYJimenez19870217UHC0605268····(507) 270-7810adam.jimenez@gmail.com263 Lincoln WayOrlandoFlorida32830GRP-7739MEDICARE-ADV-A
ENR ENR-1207002026-10-09T21:33:27ZCherylH.Ford1964-04-11UHC-70418-38•••-••-3813NULLCHERYL.FORD83@HOTMAIL.COM1793 HIGHLAND AVENUESacramentoCA95809GRP-9386·NAVIGATE-HMO
ENRENR-1004912026-03-05T17:26:27ZPatryciaXMitchell20080901UHC-58066-27•••-••-1447883-756-6993PATRICIA.MITCHELL29@ICLOUD.COM513 HILLCREST ROADGilbertaz85298-0833GRP-8196··OPTIONS-PPO
ENRENR-1130512026-04-22T18:27:07Zjennifer··J·spencer1966-11-04UHC-44714-09•••-••-77363012810334jennifer.spencer23@aol.com4977 Bayshore DrLas Vegas··NV89172GRP-4708CORE-HMO
ENRENR-1219502026-02-02T07:31:46ZDianeBRyan01-02-1990UHC-57339-60•••-••-4588279-859-2775UNKNOWN207 Pine DrNashvilleTN37259GRP-5013CHOICE-PLUS-PPO
ENRENR-1147232026-04-24T18:53:44ZMei—Ellis1938-06-27UHC-77487-48•••-••-69605126153601mei.ellis@proton.me·1321 RIDGE RDSAN ANTONIOTX78276GRP-1255CHOICE-PLUS-PPO
ENRENR-1035902026-07-13T16:39:34Zjustin—·ramos1/11/1962UHC7003033•••-••-56624076350873justin.ramos@aol.com4154 Valley View Dr·GlendaleAZ··85327GRP-1612CHOICE-PLUS-PPO
ENRENR-1190302026-08-12T14:57:45Z·BruceAWoodJul 12, 2005·UHC-29182-73•••-••-7934497-639-4392bruce.wood57@icloud.com7942 Church StreetTampa·FL33626GRP-9211navigate-hmo
ENRENR-1161842026-05-25T22:24:12ZWalter—Cunningham1943-01-05UHC3937875•••-••-3276343.258.0850··WALTER.CUNNINGHAM@YAHOO.COM523 PALM DRIVEPlanoTX75056-3033GRP-4626SELECT-EPO
ENRENR-1172882026-06-21T11:37:34ZJanniceAAustin05/20/1986UHC-71582-77•••-••-6565+1 893 921 8217janice.austin@icloud.com3680 Valley View Drive··TEMPEAZ85272-3571·GRP-2351OPTIONS-PPO
ENRENR-1172822026-08-19T02:24:25ZZACHERYPMORALES08/08/95·UHC-95210-09—5612126194zachary.morales@icloud.com9060 Washington StreetTampaFL33656GRP-2317NAVIGATE-HMO
ENRENR-1075912026-03-11T20:36:28ZSilva, Carl··C—May 6, 1973UHC-81611-01•••-••-8021—carol.silva35@proton.me7969 Lincoln WayDenverCO80293GRP-1768··MEDICARE-ADV-B
ENRENR-1405302026-04-02T15:03:35ZLoganIGonzales19781211UHC-75319-48··•••-••-2738(309) 734-9085logan.gonzales4@hotmail.com4772 WILLOW CTCharlotteNC28263·GRP-8229CHOICE-PLUS-PPO
ENRENR-1083862026-06-15T17:58:00ZAnn··—Rid19890625UHC-69943-35•••-••-2378(375) 548-8751ann.reid36@gmail.com8701 Hillcrest RdNashville··TN—GRP-9097NAVIGATE-HMO
ENRENR-1415282026-01-23T16:36:29ZSantiagoMHoffman1988-02-13UHC-83483-10•••-••-6669(724) 501-6599—2511 HARBOR BLVDOrlandoFL32877GRP-9345CORE-HMO
ENRENR-1322972026-02-18T21:16:39ZELIZABETH····JOHNSON8/9/1956·UHC-09419-50•••-••-3302719-311-8670ELIZABETH.JOHNSON62@PROTON.ME6599 River RdPhoenixArizona85020GRP-5752MEDICARE-ADV-B··
ENRENR-1332562026-04-28T16:57:21Zmichelle—simmons1941-02-28UHC-88476-26N/A17266261276··-7751 BroadwayAustinTX78715GRP-6177CORE-HMO
ENRENR-1339032026-09-23T08:04:54Z Roberts, Emma——1991-08-21UHC-03591-23··•••-••-4293535-456-6351EMMA.ROBERTS@PROTON.ME5631 MESA DRIVE Apt 22FresnoCA93740GRP-0500NAVIGATE-HMO
ENRENR-1319902026-06-17T06:56:38ZGuzman, Richard—····2003-11-26··UHC-19581-78··•••-••-4006nullrichard.guzman@icloud.com8451 PARK PLMesaAZ85268··GRP-5811OPTIONS-PPO
ENRENR-125407 2026-09-01T22:06:25ZSantos, KathleenE—12/09/56UHC-88039-83•••-••-33417267525817kathleen.santos31@icloud.com367 OAK STREETNashvilleTN37296GRP-5304CORE-HMO
ENRENR-1130752026-06-18T01:44:44ZELIJAHGWALSH1981-12-21UHC-25295-90•••-••-1691386-808-8859UNKNOWN5002 River Rd··NashvilleTennessee37227··GRP-8835MEDICARE-ADV-A
ENRENR-1399582026-05-29T01:49:59ZLuciaHDavis19660129UHC-07405-19•••-••-8525+1 652 283 1502LUCIA.DAVIS@YAHOO.COM390 SAGE COURT··ChandlerAZ85206GRP-0799CHOICE-PLUS-PPO
ENRENR-1284702026-05-01T10:39:49ZmeiYbailey1988-11-25·UHC-05096-38•••-••-042018112399240null2507 BroadwayAtlantaGeorgia30339GRP-0285·NAVIGATE-HMO
ENRENR-1356382026-02-22T23:49:56ZSAMANTHAN.·SPENCER1998-11-24UHC-00058-48•••-••-5969NULLN/A6140 GRAND AVENUEEden PrairieMN55307GRP-1099SELECT-EPO
ENRENR-1197102026-09-25T02:36:04ZPriyaB.Rice12/11/1957UHC9253576•••-••-0631208-433-0337null9320 Bayshore DrCHANDLERAZ··85250GRP-3056·NAVIGATE-HMO
ENRENR-1279312026-02-07T07:43:55Z—J.··—7/9/1957UHC-47898-35—18826073302NULL7361 Main StCOLUMBUSOH43276-6886GRP-1560OPTIONS-PPO
43,101 rows, page 311 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.604Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty