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-1028552026-03-30T01:09:47ZBRADLEY··H—8/15/1987UHC-35169-53•••-••-0526861.695.7227BRADLEY.WARREN@AOL.COM3152 HARBOR BOULEVARDAtlantaGA30325GRP-8962SELECT-EPO
ENRENR-1178532026-06-23T01:51:54ZRobertBContrerasAug 26, 2005UHC9387033•••-••-7664832-767-4829robert.contreras39@aol.com··5931 Central AvenueDALLASTX75265-5026GRP-3681NAVIGATE-HMO
ENRENR-1102252026-09-25T20:33:52ZMARRKN.HARPER1987-01-24UHC-93997-42•••-••-7475202-611-1780mark.harper97@hotmail.com6905 Ocean AveSeattleWA98186GRP-6315CORE-HMO
ENRENR-1159012026-08-13T15:39:36ZAnderson, Sofia——19670126UHC-62309-86•••-••-8757+1 815 417 5839sofia.anderson@outlook.com5335 Forest AvenueFresnoCA93762GRP-0100SELECT-EPO
ENRENR-1355362026-06-08T14:57:48ZJOSHUA···HERRERA1954-10-01uhc-29222-37··•••-••-7967N/Ajoshua.herrera74@yahoo.com8343 WASHINGTON STColumbus·OH·43249GRP-8289MEDICARE-ADV-B
ENRENR-1169182026-03-19T01:38:16Zpatty··Anguyen03/23/05UHC2232164•••-••-5248724-357-8348UNKNOWN6015 Elm StreetFresnoCA93770GRP-0717SELECT-EPO
ENRENR-1238922026-01-15T07:43:32Zgerald—hendersun1955-08-11UHC-18712-38•••-••-93963763026539gerald.henderson81@gmail.com7915 Forest AveGILBERTAZ85218GRP-8662SELECT-EPO
ENRENR-1429612026-02-04T00:48:05ZHaroldPMartinez02/21/1974UHC-09241-21··NULL291-338-6217HAROLD.MARTINEZ@OUTLOOK.COM8897 BroadwayGilbertAZ85237GRP-0207MEDICARE-ADV-B
ENRENR-1383572026-10-16T17:45:18ZRuth··—Hall1974-01-01—N/A—ruth.hall13@proton.me5398 Church StGlendaleAZ85304GRP-9951MEDICARE-ADV-A
ENRENR-1014902026-09-20T01:09:05Zshirley—griffin10/19/1997UHC-13733-19—(638) 994-1304shirley.griffin@yahoo.com—UNKNOWNnull··N/AGRP-9344medicare-adv-a
ENRENR-1216842026-07-15T10:37:02ZRoy—Watson1990-06-04UHC8315241•••-••-9293(523) 827-1614roy.watson82@icloud.com9508 Park PlScottsdaleArizona85285GRP-3749··CHOICE-PLUS-PPO··
ENRENR-1191792026-03-21T05:21:31ZGabrileYGarza1957-01-11UHC-15449-71•••-••-88235595212859gabriel.garza80@outlook.com5766 Baseline RdCHARLOTTENC28292GRP-0405medicare-adv-b
ENRENR-1263382026-01-11T18:16:03ZSalazar, MarcusK.—01/18/00UHC-25548-17—692-207-9750marcus.salazar@aol.com2563 BroadwayAustin·TX78772GRP-8068MEDICARE-ADV-A
ENRENR-1096112026-05-22T20:03:01ZRobertP.Boyd10/27/1997UHC-67639-87•••-••-80389547544robert.boyd@proton.me8420 Central AveGILBERTAZ85277GRP-2012CHOICE-PLUS-PPO
ENRENR-1076712026-09-16T10:05:31ZAnthony—Henderson1991-07-09UHC-01194-99•••-••-5457·2434720043anthony.henderson@aol.com9162 HILLCREST ROAD·MinneapolisMN55478··GRP-1501CHOICE-PLUS-PPO
ENR ENR-1190232026-04-18T20:24:23ZEric—·Coleman·04/20/2007UHC-65472-35•••-••-0984673-591-6329eric.coleman95@yahoo.com2114 Main StreetCharlotteNC28252GRP-7174MEDICARE-ADV-A
ENRENR-1269262026-04-09T12:47:30ZJeremy—Duncan·1949-03-10UHC-03261-36•••-••-74126527112314jeremy.duncan79@proton.me2243 Central AvenueDallasTX·75240GRP-8875NAVIGATE-HMO
ENRENR-1218752026-04-09T12:37:29ZarjunF.patel1973-01-16UHC-11372-33•••-••-3485(358) 784-2801··null2930 MAPLE AVENUEJacksonvilleFL32249GRP-4412··OPTIONS-PPO
ENRENR-1202932026-02-09T04:43:18ZHaroldVVasquez2002-04-18UHC-05206-24•••-••-21465215295672·harold.vasquez23@icloud.com4231 Lake View Road Apt 26MesaAZ85252GRP-5495MEDICARE-ADV-A
ENRENR-1358322026-10-02T03:59:33ZKevinM.Lee7/1/2006·UHC-33968-44•••-••-079112096712560··kevin.lee43@proton.me1981 GRAND AVELas VegasNV89187GRP-3075MEDICARE-ADV-A··
ENRENR-1271192026-05-18T11:30:38Z NATALIE··—ESTRADA1938-05-17UHC-84399-83•••-••-68134355169604UNKNOWN8742 CHURCH STREETFresnoCANULLGRP-4912CORE-HMO
ENRENR-1101472026-04-25T14:53:34ZBilly—Hart01/16/86UHC-23060-35•••-••-3944479-525-4142billy.hart92@icloud.com6343 Ridge RdSan AntonioTX78288GRP-3767NAVIGATE-HMO
ENRENR-1174342026-04-28T04:22:20ZTyler—Tucker19940325UHC-79029-76•••-••-4263665.316.5099TYLER.TUCKER@ICLOUD.COM6236 MESA DRIVE Apt 34ScottsdaleAZ85276GRP-0905CHOICE-PLUS-PPO
ENRENR-1402442026-01-12T10:31:10ZHughes, GeorgeT—1957-09-12UHC-74485-63•••-••-9040·+1 583 720 5436george.hughes@proton.me2144 Hillcrest RoadSAN DIEGOCA92144GRP-8549OPTIONS-PPO
ENRENR-1264992026-02-21T17:19:05ZGREGORY—HAMILTON12/02/69UHC5499902•••-••-65646265361954-4040 Ridge RdNASHVILLETN37267-2562GRP-5883SELECT-EPO··
ENRENR-1414272026-02-07T04:57:31ZEmmaGRichardson··1980-10-14UHC-65412-76•••-••-9314718-820-4004emma.richardson47@hotmail.com877 CENTRAL AVENUEPhoenix·AZ85058GRP-2362··SELECT-EPO
ENRENR-1355312026-08-17T14:00:51ZOlivia··—2003-08-15UHC-01709-43•••-••-10859865406712—4874 Willow CourtSan DiegoCA92165GRP-2966MEDICARE-ADV-A
ENR ENR-1417942026-01-19T16:48:39ZRoyC.Roberts1963-11-14UHC-48616-32•••-••-64273353613449roy.roberts@icloud.com5995 Palm DriveTampaFL33681GRP-3691CHOICE-PLUS-PPO
ENRENR-1103542026-06-28T16:55:20ZLucas, AmberO—Sep 14, 1947UHC-43598-38•••-••-3636526-821-7032AMBER.LUCAS@OUTLOOK.COM5039 SAGE CTPlanoTX75058GRP-5220CORE-HMO
ENRENR-1286082026-04-05T08:00:50ZCHARLESOFULLER19421120uhc-40826-72•••-••-5460(269) 963-2658-227 River RoadCharlotteNorth Carolina28221GRP-8585CORE-HMO
ENRENR-142920 2026-06-10T00:05:41ZPAMELA—GIBSONNov 19, 1970UHC-30740-55•••-••-6249·+1 371 368 6572pamela.gibson59@gmail.com4351 Hillcrest RoadGLENDALEAZ-GRP-5404OPTIONS-PPO
ENRENR-1090552026-05-07T05:29:29ZAnna—Evans·06-01-2005uhc-91885-75•••-••-6558488-775-1985anna.evans91@hotmail.com7407 Valley View DriveNASHVILLETN37275GRP-6006OPTIONS-PPO
ENRENR-1152692026-04-28T21:13:47ZAUSTIN—MORALES1929-04-08UHC-73946-07•••-••-4345NULL—898 BroadwayCharlotteNC28266GRP-9564CHOICE-PLUS-PPO
ENRENR-1099552026-07-30T02:44:56ZAshley··Brooks03/10/91UHC-93298-79•••-••-1961·17187793598ashley.brooks44@yahoo.com1256 Canyon RdPhoenixaz85069GRP-1480SELECT-EPO
ENRENR-1078622026-06-25T19:02:17ZVIRGINIA··—FRANKLIN1957-11-28·UHC-88877-69•••-••-0781551-268-0225NULL2610 Market StreetColumbusOH43258GRP-6895CHOICE-PLUS-PPO
ENRENR-1330182026-07-19T09:01:24ZMatthew—Johnston11/09/63UHC-74830-58•••-••-3526370-289-7811··-··416 Oak StJacksonvilleFL32273-2191GRP-7181MEDICARE-ADV-B
ENRENR-1397482026-09-16T16:21:09ZCHRISTINAGDANIELS09/05/1967UHC-59560-45•••-••-0001(325) 695-7947christina.daniels23@hotmail.com2647 Washington StreetMiamiFL33137GRP-1081·SELECT-EPO
ENRENR-1115402026-06-02T04:34:14ZJacob—Cruz07/09/88UHC-04690-02•••-••-65149257108550UNKNOWN7937 Lincoln WaySan DiegoCA92162GRP-3019NAVIGATE-HMO
ENRENR-1418312026-07-31T17:06:14ZAlbertMLi2003-04-04UHC-03185-27•••-••-4561(286) 477-7055albert.li@aol.com9299 Market StChandlerAZ85253GRP-1631NAVIGATE-HMO
ENRENR-1057742026-07-12T08:58:21ZJEFFREYS··LARSON1955-09-24UHC-00373-95N/A12895514159JEFFREY.LARSON62@OUTLOOK.COM5242 JEFFERSON AVEScottsdaleAZ85236GRP-7679CHOICE-PLUS-PPO
ENRENR-121993 2026-07-09T12:53:38ZGeorge—OBrienOct 28, 1938UHC-11446-55•••-••-5027····—4376 FOREST AVENUESan DiegoCA·92118GRP-9625SELECT-EPO
ENRENR-1314072026-09-10T13:33:57ZOar—·Espinoza1972-06-10UHC-79522-74•••-••-3785(510) 511-2440-4678 Park PlaceGlendaleAZ85344GRP-8719CORE-HMO
ENRENR-1020012026-03-19T04:03:08Z Medina, Kayla——05/27/1953UHC-08933-32•••-••-4198—kayla.medina12@proton.me8044 Forest AvenueMesaAZ85206-7498GRP-6934CHOICE-PLUS-PPO
ENRENR-1313622026-02-07T18:54:35Z·Bryan—Martin2007-01-02UHC-98314-75•••-••-93808194224278bryan.martin@icloud.com··9421 JEFFERSON AVENUE·DenverCO80263GRP-6099CHOICE-PLUS-PPO
ENRENR-119529 2026-04-11T01:10:31Z—R—1990-12-06UHC-66808-42•••-••-6232—aisha.mejia@gmail.com7070 Harbor BlvdGlendaleAZ—GRP-1214MEDICARE-ADV-A
ENRENR-1238432026-06-10T07:19:20ZWallter··BGuzman20-07-1980UHC-84623-41•••-••-4554·926-884-3798—9478 Washington Street··TUCSON·Arizona85787GRP-7276OPTIONS-PPO
ENRENR-1147962026-06-10T22:10:15ZLUISOWATSON9/15/2006UHC-32214-62•••-••-63116013478N/A265 Spring St Apt 19LOS ANGELESCA90034GRP-8818CHOICE-PLUS-PPO
ENRENR-1304412026-05-17T08:09:04Zalexander—scott1953-12-17UHC-75007-57•••-••-8659(590) 708-6926ALEXANDER.SCOTT60@HOTMAIL.COM5305 CENTRAL AVENUE·AtlantaGA30345GRP-3135MEDICARE-ADV-A
ENRENR-1239972026-02-12T17:43:15ZCarolynQArnold1948-10-11UHC-37886-84··•••-••-1738(444) 678-0495CAROLYN.ARNOLD78@GMAIL.COM9558 UNION STHoustonTX77098GRP-2241NAVIGATE-HMO··
ENRENR-1375792026-07-03T19:16:38ZCarlos—Henry1980-07-13UHC-01106-07•••-••-1992(770) 397-3382carlos.henry@outlook.com1706 Jefferson AveMinneapolisMinnesota55419-2077GRP-6833NAVIGATE-HMO
43,101 rows, page 276 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.432Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty