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-1023992026-10-15T04:41:12ZHANNAH—·GILBERT1952-03-02UHC-34071-38-2876459697—·9838 Grand AveLAS VEGAS··NV·89155GRP-1574CHOICE-PLUS-PPO
ENRENR-1097892026-04-23T22:42:47ZEDWARDM.MRENO1994-11-20null•••-••-46004806532070edward.moreno@proton.me1636 Lake View RoadGilbertaz85233GRP-5746CHOICE-PLUS-PPO
ENRENR-1068432026-02-09T18:25:18ZLsaLWelch1975-03-28UHC2841439··•••-••-9740632-797-5083LISA.WELCH@HOTMAIL.COM7329 Maple AvenueTempeAZ85261GRP-1834OPTIONS-PPO··
ENRENR-1180552026-03-19T05:13:47ZVasquez, JerryI.··1939-08-13UHC-41128-37•••-••-1300638-957-2398jerry.vasquez@gmail.com6965 Camelback RdTAMPAfl33681GRP-9383OPTIONS-PPO
ENRENR-1254552026-03-20T12:57:54ZPATRICK—VALDEZ2004-08-20UHC-24291-94—-patrick.valdez@gmail.com4711 Pine DriveColumbusOH43210GRP-9916OPTIONS-PPO··
ENRENR-1034622026-06-18T09:08:57Z Arthur—Burton1996-05-21UHC-20218-65—17665852638arthur.burton@proton.me8899 Cedar LaneJacksonvilleFL32238GRP-5508NAVIGATE-HMO
ENRENR-1232582026-03-13T09:14:45ZRUIZ··—CYNTHIA2004-07-03UHC-99876-79•••-••-80973079561426cynthia.ruiz78@icloud.com1310 HIGHLAND AVENUE Apt 31DenverCO80239GRP-9464NAVIGATE-HMO
ENRENR-1107212026-02-27T22:34:24ZSofiaTGilbert1963-04-20UHC-81250-85•••-••-3449(336) 337-2415sofia.gilbert66@outlook.com2715 LAKE VIEW RDSan AntonioTX78258GRP-1303SELECT-EPO
ENRENR-1013632026-06-30T20:55:55Z Gloria—Stone··28-03-1954UHC-49958-85•••-••-2562268.714.2191gloria.stone22@gmail.com7547 BROADWAYSeattlewa98141GRP-7757··MEDICARE-ADV-A
ENRENR-1358402026-06-20T22:50:43ZKarenTLopez1990-21-05UHC-99332-07•••-••-4528(688) 804-5170karen.lopez92@aol.com4053 GRAND AVENUEOrlandoFlorida32850GRP-7965MEDICARE-ADV-A
ENRENR-1220702026-05-25T08:26:45ZANTHONY—JACKSONNov 11, 1996UHC-47435-53•••-••-4836708-497-1104—7175 MESA DRIVE Apt 24DallasTX75263-7282GRP-4800CHOICE-PLUS-PPO
ENRENR-1398702026-09-19T16:42:26ZKyleD.Ray··1993-08-17UHC9392170NULL244-612-7525kyle.ray80@aol.com··2370 RIVER ROADMesaAZ85269·GRP-5662OPTIONS-PPO··
ENRENR-1187802026-09-10T06:47:30ZMegan—·Watson1975-04-10UHC-62910-31•••-••-1224927.423.7287NULL257 PINE DRIVEMiamiFL33164GRP-7134OPTIONS-PPO
ENRENR-1247792026-03-07T18:48:45ZArjunNRojas1990-12-11·UHC-64386-50•••-••-8421(459) 454-1601ARJUN.ROJAS@PROTON.ME9833 Jefferson AveChandlerAZ85299GRP-6075CHOICE-PLUS-PPO
ENRENR-1319812026-05-15T21:13:01ZAna··PBurns2008-04-14UHC-01372-41•••-••-0517(904) 407-7794ANA.BURNS67@GMAIL.COM5119 Willow Ct #425DallasTX75272GRP-3950·NAVIGATE-HMO
ENRENR-1108782026-10-17T04:49:50ZLoriB.Kelly1989-08-16UHC-57425-29N/A·(889) 392-9142LORI.KELLY32@GMAIL.COM4987 Mountain View DrPlanoTX75089GRP-6892··SELECT-EPO
ENRENR-1406972026-09-10T07:53:25ZADAM—·SANDUVAL19531027UHC-00748-96•••-••-514716173363432ADAM.SANDOVAL@OUTLOOK.COM5983 Forest AveChandlerAZ··GRP-9081SELECT-EPO
ENRENR-1063562026-05-20T03:58:40ZMaria—Andrews19810618UHC-78082-79•••-••-986519003222109maria.andrews81@proton.me9752 Mountain View DrEden PrairieMN—GRP-8991··NAVIGATE-HMO
ENRENR-1037802026-01-02T06:53:06ZLINDA W.··HENRY19830714··UHC-84983-22•••-••-9682(411) 268-7226LINDA.HENRY@ICLOUD.COM7924 CHURCH STTampaFL33607GRP-8625OPTIONS-PPO
ENRENR-1398292026-02-28T15:03:11Z Ray—Carlson1975-09-18··UHC-58887-83•••-••-9085-raymond.carlson@proton.me2186 Baseline RdATLANTAGA30342GRP-2044CORE-HMO
ENRENR-1246702026-06-08T10:35:37ZrandyBharperJan 7, 1969UHC-38448-91•••-••-5263(253) 998-8561RANDY.HARPER@PROTON.ME5247 Baseline RdCharlotteNC28298GRP-4017OPTIONS-PPO
ENRENR-1367912026-02-12T09:18:11ZLuis—Davis1951-08-17·UHC-97659-22•••-••-96049921226UNKNOWN447 BAYSHORE DRIVESan DiegoCA92107GRP-2250SELECT-EPO
ENRENR-1116252026-03-17T20:31:35ZJacqueline·ORiley2006-10-07UHC-86510-44null4195641011—943 Jefferson AvenuePlanoTX75020GRP-1984SELECT-EPO
ENRENR-1379362026-09-12T07:28:26ZChapman, Gloria——19381011UHC-10323-58•••-••-3942478-263-0196-4425 Mesa Dr #964DENVERCO80291GRP-1308OPTIONS-PPO
ENRENR-1120952026-08-08T10:47:01Z—M—1973-10-03—•••-••-9029684-627-8951JUAN.MURPHY@AOL.COM147 Canyon RoadTampaFL33668·GRP-1277CHOICE-PLUS-PPO
ENRENR-1153292026-07-15T19:00:10ZJsaonM.MorenoDec 24, 1977UHC-09388-80•••-••-55258438637jason.moreno73@gmail.com7109 Pine DriveMesaAZ85270GRP-8231SELECT-EPO··
ENRENR-1057622026-02-20T11:50:35ZJYOCE—CUNNNINGHAM1996-05-08··UHC-00031-41··•••-••-4958N/Ajoyce.cunningham@yahoo.com3225 PINE DRIVEMinneapolisMN55480·GRP-6455MEDICARE-ADV-B
ENRENR-1347092026-02-27T22:03:50ZAngelaZLucasJan 2, 1947—•••-••-92843776312997angela.lucas@yahoo.com3075 HARBOR BLVDGLENDALEArizona85337GRP-4121CORE-HMO
ENRENR-1092932026-09-21T16:50:14Z·ANNA—·MARSHALL20040925UHC-40846-63•••-••-0907736-653-2932anna.marshall@proton.me3775 Sunset Blvd··MinneapolisMinnesota55452GRP-8963SELECT-EPO
ENRENR-1345122026-01-06T16:38:29ZNATALIEDLE06/24/2004UHC-92405-09····506-477-8317natalie.le22@yahoo.com·2037 Willow CtDenverCO80254GRP-2955MEDICARE-ADV-B
ENRENR-1334592026-01-27T22:31:21ZElijahV.Lynch11/08/1952UHC-37755-50•••-••-3704—NULL3236 Camelback RdAustinTX78748GRP-1347··NAVIGATE-HMO
ENRENR-1043642026-05-12T05:33:29ZJOHN—PALMER1951-07-24UHC-49938-60··9197898404-2782 PARK PLOrlandoFL32882GRP-6475CHOICE-PLUS-PPO··
ENRENR-1317312026-03-05T16:20:11ZKATHRYN—MCDONALD1990-02-24UHC-36310-12•••-••-0134-kathryn.mcdonald@outlook.com7145 Elm StPhoenixAZ85060GRP-5642CORE-HMO··
ENRENR-1224182026-07-14T18:54:30ZBradley, OliviaK··—1950-11-05UHC-21842-25•••-••-39755058067939olivia.bradley@aol.com293 Grand AveSacramentoCA95873GRP-5659MEDICARE-ADV-B
ENRENR-1427442026-06-20T20:11:02ZAMANDA—BENNETT···08-01-2004UHC-35446-77•••-••-8286482-762-9839AMANDA.BENNETT@PROTON.ME6065 Union StreetColumbusOH43251GRP-7664·CORE-HMO
ENRENR-1180262026-07-12T05:50:33ZDonald—Ray19561023UHC-01772-80•••-••-96835739124756donald.ray@gmail.com6568 Willow Ct Apt 14MINNEAPOLISMN55405GRP-0614CHOICE-PLUS-PPO
ENRENR-1360402026-05-30T18:46:53ZBARBARAFARMSTRONG··1597-11-26UHC-32868-18•••-••-77077755853934barbara.armstrong@hotmail.com4485 CANYON RDDALLASTexas75260·GRP-1938SELECT-EPO
ENRENR-1035292026-09-27T18:06:43ZHaroldTWelch11/24/1941UHC-33123-36•••-••-90002585733297harold.welch35@aol.com2563 Maple AvenueGilbertAZ·85202GRP-0104options-ppo
ENRENR-1318412026-02-02T00:25:25ZCharlotteTTurner1961-12-18UHC-11473-27•••-••-8785613-935-6098—7851 Union StreetNashvilleTNnullGRP-3974MEDICARE-ADV-B
ENRENR-1273302026-06-05T13:45:30ZBrown, Pamela——2003-11-10UHC-00296-23•••-••-8299-UNKNOWN6660 Maple Avenue Apt 23OrlandoFL32806GRP-5986SELECT-EPO
ENRENR-1009502026-05-28T05:55:00ZBenjamni—Wodos1961-03-12UHC-81131-71•••-••-24382442624625··-1285 Grand AvenueMinneapolisMN55401GRP-6994CHOICE-PLUS-PPO
ENRENR-107526 2026-04-26T09:21:05ZMeganPLunaMar 28, 1944UHC-29621-49—6682034810megan.luna72@yahoo.com79 Baseline RoadNashville··Tennessee37205GRP-1936MEDICARE-ADV-B
ENRENR-1140382026-07-10T01:42:42ZNelson, Valentina——1985-02-09UHC-73808-52•••-••-9530430-889-5410valentina.nelson@gmail.com7819 Baseline Road Apt 32··Columbus··OH43250GRP-2110choice-plus-ppo
ENRENR-1108532026-01-27T03:19:06ZABIGGAILJVASQUEZ01/02/1992UHC-90186-63··UNKNOWN··—UNKNOWN—UNKNOWNnullGRP-3918navigate-hmo
ENRENR-1145362026-08-13T15:08:54ZKatherineJ.Hudson1981-09-18UHC-65731-01•••-••-5983(662) 442-7253KATHERINE.HUDSON@PROTON.ME829 Market StSeattleWA98173GRP-7253··NAVIGATE-HMO
ENRENR-1108422026-03-19T05:31:12ZTaylor, Bobby—··19800428UHC-42987-60•••-••-0545+1 803 848 3258BOBBY.TAYLOR47@OUTLOOK.COM··7916 Forest AveTUCSONAZ···85796·GRP-3882SELECT-EPO
ENRENR-1043472026-02-20T13:01:24ZMATEO—COOPER1992-07-07UHC-54482-85•••-••-602618504563929mateo.cooper52@proton.me3037 Baseline RdMesaArizona85211-2771GRP-0206select-epo
ENRENR-1365942026-08-14T01:29:09ZJONP.·KIM1955-06-09UHC-91150-32-16298448189JONATHAN.KIM@OUTLOOK.COM··7813 BroadwayChandler·AZ85281GRP-6445choice-plus-ppo
ENRENR-1275962026-07-15T02:00:57ZMarcusG.Parker2004-07-08UHC1804088null(246) 235-5190MARCUS.PARKER37@PROTON.ME9631 River RdMesaAZ85238GRP-0958CORE-HMO··
ENRENR-1001732026-05-05T03:51:32Z·Sofia—Lawson1963-09-07UHC-68415-31•••-••-2940(658) 417-9415null1830 LAKE VIEW ROADNashvilleTN37231GRP-7674MEDICARE-ADV-B
43,101 rows, page 288 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.446Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty