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-1011292026-05-12T03:40:37ZScott··EAlexander1938-02-10UHC-45983-33null401-991-6993scott.alexander31@proton.me6524 Lincoln WayGLENDALEAZ85392GRP-5251CORE-HMO
ENRENR-1262702026-09-01T08:02:28ZRalphEJacobs1982-04-19UHC-34844-14•••-••-6671·(646) 902-3287ralph.jacobs@gmail.com3178 Lincoln WayJacksonvilleFL32271GRP-2145SELECT-EPO
ENRENR-1408342026-09-25T05:45:14ZBakeer··Daneille··1945-05-02UHC-85743-44•••-••-2347309-708-4953danielle.baker66@outlook.com129 Maple AveSan AntonioTX78252GRP-7764SELECT-EPO
ENRENR-1094662026-06-12T17:15:39ZNATALIEXGARZA··14-04-1971UHC-25802-28•••-••-49612354109462natalie.garza1@outlook.com5124 CENTRAL AVEEDEN PRAIRIEMN55310GRP-7729OPTIONS-PPO
ENRENR-1007892026-07-24T10:17:13Z·Pirce, GayrJ··—1946-12-25UHC-75471-11null(421) 806-6659··gary.price@gmail.com4343 Market StSeattlewa98127··GRP-4363·MEDICARE-ADV-A
ENRENR-1180942026-03-14T03:21:33ZCARLOS—CARPENNTER·2008-06-12UHC-93262-81•••-••-6320475-303-0901CARLOS.CARPENTER88@OUTLOOK.COM833 Canyon Road #692ScottsdaleAZ85207··GRP-7735MEDICARE-ADV-B
ENRENR-1060602026-07-22T02:22:46Z·EugeneWTucker1989-07-13UHC-26271-13null17955307172eugene.tucker63@outlook.com9002 Maple AvenueGlendale··AZ85380GRP-5405CHOICE-PLUS-PPO
ENR ENR-1068182026-03-28T15:10:55ZLawreceFWagner·1952-08-03UHC-91965-87•••-••-11199752639074lawrence.wagner@yahoo.comNULLnullUNKNOWN··GRP-2322NAVIGATE-HMO
ENRENR-1418362026-08-30T01:10:45ZMelissa—Olson1942-10-19··UHC-23020-91•••-••-6756····melissa.olson89@gmail.com5972 Mesa Drive··MINNEAPOLIS··MN55470··GRP-1733SELECT-EPO
ENRENR-1048972026-09-12T13:22:21ZbryanAguerrero06/06/1988UHC-91293-76•••-••-2508+1 300 578 0486····7948 Ridge RdSacramentoCA·95888-3714GRP-5294CHOICE-PLUS-PPO
ENRENR-1327272026-07-16T02:16:16ZBarbaraRTran10/22/1968UHC-40168-78•••-••-9939306-262-0856·barbara.tran@gmail.com7626 Sunset BlvdTAMPAFL-GRP-2217NAVIGATE-HMO
ENRENR-138134 2026-08-04T16:05:31Z·thomasNgray1996-09-03uhc-10187-67•••-••-1066(910) 535-5447thomas.gray49@icloud.com6470 BASELINE ROADAtlantaGA30340GRP-8124·MEDICARE-ADV-B
ENRENR-1333172026-07-01T19:38:08ZMary—Valdez04/02/44UHC9987688—2917274599NULL·4738 Maple AveChandlerAZ85268GRP-6259NAVIGATE-HMO
ENRENR-1418292026-07-24T23:35:38Z·JASONRHERNANDEZ·1946-12-19UHC-57671-39•••-••-5084(479) 455-5954jason.hernandez67@hotmail.com841 HARBOR BLVDMESAAZ85208-2654GRP-6263··CORE-HMO
ENRENR-1329052026-07-17T11:21:34ZLARRYV.DUNCAN1989-04-28UHC-94999-36•••-••-4110(688) 594-6290larry.duncan@aol.com9313 Baseline RdEden PrairieMN55346GRP-2182NAVIGATE-HMO
ENRENR-1268542026-05-19T12:06:39ZBruce—Flores1966-11-27UHC1643741•••-••-91354078173894bruce.flores18@aol.com8234 Market StNashvilleTN··37212GRP-8990NAVIGATE-HMO··
ENRENR-1114872026-02-16T15:53:22ZRonaldUAlvarez19-03-1994uhc-65432-23UNKNOWN(748) 342-1406—1061 Spring StreetFresnoCA··93709GRP-9974CHOICE-PLUS-PPO
ENRENR-1394732026-09-08T15:08:04ZValentinaFOwens19741125UHC-07257-28•••-••-1783940.320.6101-8420 Jefferson AvenueNashvilleTN··37232GRP-0795CHOICE-PLUS-PPO
ENRENR-1414062026-08-31T04:16:14ZAMANDAT.KIM1964-02-23UHC-20779-93N/A(655) 914-4934AMANDA.KIM@AOL.COM6184 Harbor BlvdScottsdaleAZ85226GRP-5859SELECT-EPO
ENRENR-1420812026-03-03T14:47:42ZWAYNE—LI01/10/60UHC-00692-94•••-••-1465618.461.4168—7279 Mountain View DriveJacksonvilleFlorida32265··GRP-3394MEDICARE-ADV-B
ENRENR-1094022026-06-05T19:42:10ZKate—Oliver1943-02-06UHC-86421-93•••-••-81948503904778katherine.oliver@yahoo.com6198 Meadow LnDallasTX75295GRP-3635SELECT-EPO
ENRENR-1355592026-02-24T01:24:40Z·George—West1994-12-28UHC-85557-32•••-••-85654487562851george.west@hotmail.com1635 Mountain View DrMesaAZ·85219GRP-1457NAVIGATE-HMO
ENRENR-1313762026-01-04T03:45:52ZKaren—Harrison01/26/87·UHC-86250-15•••-••-1653UNKNOWNUNKNOWN718 Canyon RdJacksonvilleFL·32207GRP-8028SELECT-EPO
ENRENR-122503 2026-02-10T15:40:04ZDONALD—DUNCAN1962-07-13UHC-03962-67•••-••-3680785-302-6888DONALD.DUNCAN@GMAIL.COM8339 Mountain View DriveMesaAZ85244GRP-9321MEDICARE-ADV-B
ENRENR-1133532026-05-06T14:26:08ZROGERU.RAY19770803UHC-43599-50—(787) 500-8643roger.ray@icloud.com4127 Apache Blvd·MesaArizona··85214-1674GRP-9426OPTIONS-PPO
ENRENR-1138012026-06-03T12:23:31ZjanetTelliottSep 18, 1976UHC-44835-28•••-••-56183494185569N/A5041 Mountain View DrGilbertAZ85216GRP-0238SELECT-EPO
ENRENR-1418032026-04-07T19:47:17ZCrlos—Tucker1981-10-07UHC-87861-85•••-••-3304·333-463-0761carlos.tucker8@aol.com344 Elm St Apt 16ColumbusOH43294GRP-7370MEDICARE-ADV-A
ENRENR-114050 2026-02-13T15:57:18ZPeter—Willis12/24/46UHC-19939-26•••-••-4461+1 435 493 9382··peter.willis@aol.com1547 Camelback RdJACKSONVILLEFL32252GRP-6246NAVIGATE-HMO
ENRENR-135779 2026-06-28T04:36:51ZsantiagoT.lane1946-01-18UHC8341550•••-••-8186699-397-4272santiago.lane@gmail.com1353 Grand AveMiamiFL33198GRP-7252CHOICE-PLUS-PPO··
ENRENR-1177282026-03-06T10:05:39ZLi, Greg——1994-10-04UHC-53739-09UNKNOWN(334) 241-6899GREGORY.LI@YAHOO.COM-—NULL—GRP-8840CHOICE-PLUS-PPO
ENRENR-1054042026-02-19T07:45:39ZAmanda—Morrison2003-01-12··UHC-73807-14UNKNOWN·12494692364amanda.morrison@yahoo.com6629 Indian School RoadTampaFL33645GRP-4490NAVIGATE-HMO
ENRENR-1119222026-04-09T11:56:37ZSOPHIA—HARRIS1939-08-24UHC0706971•••-••-5089617-901-2513SOPHIA.HARRIS96@PROTON.ME8447 Camelback Road··TampaFlorida33665GRP-8643SELECT-EPO
ENRENR-1220502026-09-17T18:51:04ZKyleJVega2006-05-23·uhc-33666-83•••-••-0210·9236953488KYLE.VEGA53@HOTMAIL.COM377 WASHINGTON STREETSacramentoCA95829GRP-7629··SELECT-EPO
ENRENR-1372122026-05-09T14:09:18ZJONATHANQ.·BROOKS1999-03-02UHC-27135-67•••-••-7944846-583-4201jonathan.brooks22@aol.com4731 SUNSET BOULEVARDLOS ANGELESCA90089GRP-8485·CORE-HMO
ENRENR-1003492026-02-06T09:54:55ZAdams, Jeremy——1971-07-04UHC-96734-62•••-••-50283987907224NULL4817 Oak StreetAustinTX·78775GRP-9275OPTIONS-PPO
ENRENR-1266862026-07-15T06:11:38ZASHLEYL.LAWSON·1942-07-23UHC-23259-90•••-••-4711nullASHLEY.LAWSON81@OUTLOOK.COM5048 Canyon RoadFRESNOCA·93734GRP-5131·MEDICARE-ADV-A
ENRENR-102981 2026-03-02T08:56:11ZRussellUJensen1960-08-26UHC-60553-97N/A(864) 628-3416russell.jensen14@gmail.com3170 MAIN STREETScottsdaleArizona85274-5679GRP-1404OPTIONS-PPO
ENRENR-1036002026-07-16T05:11:38ZHIROSHIS.RICHARDS1983-02-20UHC-72946-18•••-••-6865583-234-7104NULL7384 VALLEY VIEW DRGlendaleAZ85353GRP-5892OPTIONS-PPO
ENRENR-1138592026-09-25T08:24:47ZSean—·Silva1959-05-03UHC-15160-88•••-••-428817673356525null7819 Church StChandleraz85221GRP-0782OPTIONS-PPO
ENRENR-1171422026-09-15T12:41:37ZDianaVLane·1940-04-01UHC-50137-28•••-••-3122768-370-4962null·3196 SUNSET BOULEVARDEden PrairieMinnesota55378GRP-2966CHOICE-PLUS-PPO
ENRENR-1358232026-05-30T04:24:31ZAbigail—Stephens1949-09-04UHC-27778-62··•••-••-1688(327) 479-1689ABIGAIL.STEPHENS73@YAHOO.COM····---GRP-3063CHOICE-PLUS-PPO
ENRENR-1255142026-10-08T04:39:21ZRebeccaO.Tucker1993-04-25UHC8324780—3319960397—5279 ELM STREETLos Angeles·California90000GRP-8753CORE-HMO
ENRENR-1316142026-02-15T12:51:08ZCheryl—Gray1950-06-23UHC-21057-88-236-824-4049·cheryl.gray25@proton.meN/AN/ANULLNULLGRP-2077CHOICE-PLUS-PPO
ENRENR-1168992026-05-18T08:03:24ZSantiago, Joshua—··03/26/06UHC2384359··•••-••-7953—-8004 MOUNTAIN VIEW DRIVECharlotteNC28257GRP-9243MEDICARE-ADV-B
ENRENR-1255682026-09-28T11:48:44ZCHARLOTTE—WEBER1960-43-02UHC-81561-06•••-••-9360744.532.8343charlotte.weber67@gmail.com6065 SAGE COURTScottsdaleAZ85265GRP-6824NAVIGATE-HMO
ENRENR-1089002026-01-10T05:06:20ZLarryS.Gibson28-12-1958UHC-74898-55•••-••-13899375549069··LARRY.GIBSON53@OUTLOOK.COM7539 Cedar LaneDallasTX··75298GRP-6391·NAVIGATE-HMO
ENRENR-1061902026-10-18T23:52:50ZCharles—Chapman1947-07-13UHC-47214-68•••-••-18944886556297charles.chapman36@icloud.com884 CANYON ROADTempeAZ85266GRP-3815CORE-HMO··
ENRENR-1378442026-04-18T03:52:12ZDaniel—Marshall1940-12-06UHC-91743-60•••-••-55968664121691···daniel.marshall@gmail.com6761 HILLCREST ROADNashville··Tennessee37286·GRP-3606CHOICE-PLUS-PPO
ENRENR-1427852026-01-19T22:19:44ZBILLYZ.SIMS1985-06-01UHC-33994-41•••-••-102118147959905billy.sims@hotmail.com4686 Grand AvenueTAMPAFL33684GRP-2478OPTIONS-PPO
ENRENR-1239672026-01-06T04:11:18ZTerry·AMedina1966-02-08UHC-89474-97··•••-••-59855184330047TERRY.MEDINA99@OUTLOOK.COM9633 Sage CtEden PrairieMinnesota55316GRP-9759··MEDICARE-ADV-A
43,101 rows, page 44 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:34.805Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty