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-122796 2026-09-28T20:48:42ZRUSSSELLALONG1993-02-19UHC-26038-09····18278847497russell.long@outlook.com1286 BroadwayGLENDALEAZ—GRP-6691CORE-HMO··
ENRENR-1142602026-07-02T15:52:54ZBRENDADROJAS1985-06-14uhc-14306-22N/A(555) 659-2334—1484 GRAND AVENUE··CHANDLERAZ85228GRP-1292SELECT-EPO
ENRENR-1407222026-01-10T16:58:50ZGabriel—SimmonsJun 26, 1986UHC-85429-50•••-••-6974-gabriel.simmons27@gmail.com5181 BAYSHORE DRIVESan DiegoCA92175GRP-1913MEDICARE-ADV-A
ENRENR-1124192026-07-21T03:06:20ZEllis, Jessica····—1997-03-05UHC-51002-75•••-••-38818908184992JESSICA.ELLIS@ICLOUD.COM2135 Mesa DrJacksonvilleFL32280GRP-1759NAVIGATE-HMO
ENRENR-1053292026-01-16T00:17:38ZDiane—Vargas··1974-11-27UHC-50003-24•••-••-3056812.775.7599diane.vargas27@icloud.com2681 Central AvenueMiamiFL33181GRP-2277CORE-HMO
ENRENR-1193572026-03-19T10:33:33Z·MARCUSZWEAVER04/01/2001UHC-34510-39•••-••-94686392871813—·7557 Sage CourtTampaFL33685·GRP-2919·OPTIONS-PPO
ENRENR-1407602026-05-14T03:51:46Z Lauren—Snyder1956-08-01··UHC-29407-99—6469188966LAUREN.SNYDER@GMAIL.COM4984 Lincoln WayChandlerAZ85266GRP-5121·OPTIONS-PPO
ENRENR-1319442026-05-17T12:12:30ZdennisH.ford1939-10-12·UHC-80301-90•••-••-68033693041dennis.ford40@yahoo.com8159 Desert Sky BoulevardFresnoCA93752GRP-5352CHOICE-PLUS-PPO
ENRENR-1153322026-09-27T08:18:52ZMarilynQMarshall·1942-03-23UHC-01570-52•••-••-4898UNKNOWN—8369 Hillcrest RoadChandlerAZ85226-6362GRP-5226MEDICARE-ADV-B
ENRENR-1318572026-08-10T23:59:16ZCYNTHIA—RAY1952-08-09UHC-95030-16•••-••-9022·2423345231NULL5099 Ocean AvenueSacramentoCalifornia95899GRP-3985MEDICARE-ADV-A
ENRENR-1293612026-09-10T15:59:24ZSTEPHANIE—PIERCE2002-01-17·UHC-62587-15•••-••-43959496940620stephanie.pierce@icloud.com3231 Park PlATLANTAGA30306GRP-7786CHOICE-PLUS-PPO
ENRENR-1280092026-10-02T13:44:10ZPaulCJones1966-12-22UHC-37331-16•••-••-6796273-217-3708paul.jones@gmail.com7405 MESA DRMiamiFL33149GRP-0880CORE-HMO
ENRENR-1424692026-02-07T13:54:10ZEthan··Mejia3/7/1972UHC-73398-16•••-••-9592559-250-7804ethan.mejia@outlook.com6031 FOREST AVENUESan AntonioTX78274GRP-4875MEDICARE-ADV-B
ENRENR-1122862026-01-19T11:31:32ZJoanSGilbert1995-06-14··UHC-72248-27•••-••-3151251.723.9798joan.gilbert@icloud.com··6266 Valley View DriveAUSTINTexas··78702GRP-6612SELECT-EPO
ENRENR-1417522026-08-06T17:13:02ZBruce—Sandoval12/02/45uhc-23741-56•••-••-023615496220755bruce.sandoval@yahoo.com2479 MESA DRMesaAZ85282GRP-7617OPTIONS-PPO
ENRENR-1089622026-01-16T22:31:02ZSpencer, NancyH.—9/6/2009UHC-62462-17•••-••-9831680-376-1098nancy.spencer@yahoo.com··6931 Ocean AvenueCharlottenc28255GRP-0565MEDICARE-ADV-B
ENRENR-1133692026-02-25T20:34:48ZHENRYIHUNTER··19910603UHC-15194-32—9137236559henry.hunter@gmail.com1192 OAK ST #167Las VegasNV89128GRP-1438CHOICE-PLUS-PPO
ENRENR-1049792026-01-27T02:24:55ZAmandaLHunt01/17/1954UHC-86125-97•••-••-8382null-··6446 Cedar Ln···AUSTINTX78712GRP-9238OPTIONS-PPO
ENRENR-1386702026-02-20T02:37:05ZLARRYYMORGAN1971-01-28UHC9630208•••-••-9699(825) 594-0810larry.morgan@proton.me6143 OAK STREETTucson·ArizonanullGRP-9318OPTIONS-PPO
ENRENR-1220062026-01-15T10:46:26ZJohnson, DorothyI.—1991-08-11UHC-06781-18•••-••-1533(860) 741-0124DOROTHY.JOHNSON@PROTON.ME2664 Elm StOrlandoFL32880GRP-5391CHOICE-PLUS-PPO
ENRENR-1023492026-07-06T00:23:43Z debraV.··white··1951-01-13UHC-67594-75•••-••-9797-DEBRA.WHITE86@PROTON.ME7964 Valley View DrMINNEAPOLISmn55491-0156GRP-6140MEDICARE-ADV-A
ENRENR-1049852026-09-05T10:48:26ZMarkLBrown1952-05-07UHC-62184-34•••-••-1880(880) 286-7788mark.brown5@outlook.com1243 MEADOW LANEMesaAZ85248·GRP-6748CHOICE-PLUS-PPO
ENRENR-1250682026-08-25T03:52:39ZHeatherVBerry6/17/2004··UHC-78489-95•••-••-3308(221) 845-0099N/A4277 SPRING STREETSan AntonioTexas78243GRP-3102CORE-HMO
ENRENR-1010032026-06-06T20:06:44ZMELISSA—JOHNSTON1975-06-08UHC-05580-07•••-••-9471(888) 869-4461MELISSA.JOHNSTON66@AOL.COM7998 Apache Boulevard·FresnoCA··93776-9853GRP-0685·CHOICE-PLUS-PPO
ENRENR-1368952026-01-12T23:07:46Zchristopher—rees19550623UHC-22598-31•••-••-76815548437644—3907 River RdColumbusOH43214GRP-3468SELECT-EPO
ENRENR-1238752026-05-21T15:34:52ZKATHERINEA.··RODRIGUEZNULL·UHC-60482-17•••-••-66964708167449·katherine.rodriguez@gmail.com9607 Camelback RdEDEN PRAIRIEMN55394GRP-6135MEDICARE-ADV-A
ENR ENR-1071732026-05-20T23:21:03ZAllen, Kathryn——1967-10-10··UHC-03261-39•••-••-79215147068kathryn.allen33@outlook.com1368 Main StreetAustinTX78747GRP-1987MEDICARE-ADV-A
ENRENR-1242502026-03-30T08:32:12ZTurner, Kevin——04/04/1952UHC-45401-60•••-••-9508(622) 367-8928KEVIN.TURNER22@ICLOUD.COM·5027 OCEAN AVEColumbusOH··43240GRP-6603CHOICE-PLUS-PPO
ENRENR-1240612026-01-06T02:26:53ZDavid—VargsJan 14, 1987UHC-69891-28•••-••-8318(842) 641-3232DAVID.VARGAS@AOL.COM8035 LINCOLN WAYSan AntonioTX78208GRP-8345CHOICE-PLUS-PPO
ENRENR-1088462026-01-22T12:22:13ZCARL—·OWENS2001-01-10UHC2425002•••-••-0995(824) 307-1686CARL.OWENS57@PROTON.ME·1298 FOREST AVENUEMinneapolisMinnesotaUNKNOWNGRP-5075SELECT-EPO
ENRENR-1281912026-08-04T03:56:26ZDeborah—Santiago5/25/1961·UHC-35269-37•••-••-4460651-233-3945deborah.santiago89@yahoo.com8215 Washington StreetCHANDLER·AZ·85273GRP-5092OPTIONS-PPO
ENRENR-1107962026-03-25T13:03:40ZCamilaW.SandovalSep 18, 1983UHC-60824-59—459-217-9167···camila.sandoval43@hotmail.com5221 BroadwaySeattleWA98142GRP-0386MEDICARE-ADV-A
ENRENR-1352752026-01-10T13:46:54ZAmanda—Santiago1951-07-28UHC-25419-96•••-••-444718874936783amanda.santiago97@proton.me275 Park PlaceAustinTX78788GRP-2680MEDICARE-ADV-B
ENRENR-1327052026-10-15T04:28:18ZBenett, Austin—····Oct 24, 1948UHC9828993•••-••-402012318273358austin.bennett10@hotmail.com7038 MESA DRGILBERTAZ85223GRP-3185NAVIGATE-HMO
ENRENR-1029772026-03-04T21:55:06ZTerryT.Maldonado1978-09-25UHC-64891-84—+1 937 233 7375TERRY.MALDONADO@OUTLOOK.COM5556 Desert Sky Boulevard·GlendaleAZ—GRP-9776MEDICARE-ADV-A
ENR ENR-1079872026-03-10T07:41:46ZsaraW.burton1938-03-28UHC-95297-67·NULL529.976.8788·UNKNOWN2589 Canyon RdAtlantaGA30328GRP-0305CHOICE-PLUS-PPO
ENRENR-1392942026-02-02T10:25:10ZHelenX.Ellis1965-08-01UHC-88505-77—811-259-3769HELEN.ELLIS26@ICLOUD.COM7967 Church St #733EDEN PRAIRIEMN55306GRP-2725OPTIONS-PPO
ENRENR-1009362026-02-23T16:55:28ZAbigailHSimmons1953-06-10UHC-39038-39-··18013629545abigail.simmons@gmail.com749 CANYON ROADJacksonvilleFlorida32209-0817GRP-0893CHOICE-PLUS-PPO
ENRENR-1076592026-08-17T12:40:33ZWallace—Barbara2152-19-84UHC-80497-35UNKNOWN7297947—3506 WILLOW CTPhoenixAZ85081GRP-8003CORE-HMO
ENRENR-1366872026-05-31T15:43:37ZSaraN.Peters1940-02-05UHC-44196-57•••-••-23772386133189—795 BROADWAYColumbusOH43208GRP-3470SELECT-EPO
ENR ENR-1354142026-10-15T09:08:19ZGutierrez, NathanV.—1953-07-17UHC8933604•••-••-9107(222) 365-3337nathan.gutierrez91@icloud.com8953 Sunset BoulevardSeattleWA98198GRP-6600SELECT-EPO··
ENRENR-1346972026-09-28T13:56:12ZCYNTHIAD.CARLSON1997-07-15UHC-39422-61•••-••-11565851258cynthia.carlson@proton.me4545 Park PlChandleraz85297GRP-4627OPTIONS-PPO
ENRENR-1289702026-10-17T10:14:54ZGLORIAH.BROOKS1946-03-27UHC-73625-05•••-••-09613253953961N/A9448 Cedar LnOrlando·FL32813GRP-2290··MEDICARE-ADV-A
ENRENR-1416062026-03-15T05:30:13ZandreaC.·matthews1974-04-26·UHC-26184-74N/A(423) 402-3147andrea.matthews28@gmail.com·1602 Canyon RoadTempeAZ85203GRP-9817NAVIGATE-HMO··
ENRENR-1122162026-05-15T18:52:01ZCarol, LaneS.—1956-06-01UHC1400002UNKNOWN(575) 749-9827—7896 WILLOW CTMesaArizona85250GRP-3416SELECT-EPO
ENRENR-1089442026-08-30T18:29:46Z virginia—clark··2/25/1948UHC-21787-94•••-••-9678+1 969 605 2278VIRGINIA.CLARK@PROTON.ME670 Sage CourtGlendaleArizona85356GRP-8363CORE-HMO
ENRENR-1167682026-03-16T15:01:49ZFields, DebraK—1973-06-12UHC-12024-33•••-••-5843(701) 527-9901debra.fields@yahoo.com1358 PINE DRIVE··PhoenixAZ85093··GRP-3147CORE-HMO
ENRENR-1112962026-03-17T04:15:07Zjacob—ramos1995-08-12UHC-33058-43•••-••-702616749511125JACOB.RAMOS89@AOL.COM1304 SAGE CTLas VegasNV89131GRP-5590OPTIONS-PPO
ENRENR-1421492026-03-07T00:21:54ZHeather—Robinson2006-09-18UHC-35050-60•••-••-1057711-599-0097UNKNOWN··1313 Canyon RdLOS ANGELESCA90085GRP-1901CORE-HMO
ENRENR-1264582026-03-27T07:04:05ZDavid—Pteerson1982-03-16uhc-64170-21•••-••-288313687919880—1308 Apache BoulevardAtlantaGA30308GRP-0173··MEDICARE-ADV-B
43,101 rows, page 3 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-19T19:54:25.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty