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-1067782026-02-04T17:02:05Z DylanB.Nunez1999-04-17UHC4090219—18162583903dylan.nunez@gmail.com9491 APACHE BOULEVARDCOLUMBUSOHNULLGRP-6714MEDICARE-ADV-A
ENRENR-1081662026-04-12T08:34:14Z MARIAELITTLE1969-04-02UHC-16279-83•••-••-9319(356) 700-0765·maria.little@icloud.com1839 Apache BoulevardColumbusOH43238GRP-6770MEDICARE-ADV-A
ENRENR-1328542026-03-28T18:40:08ZMarilyn····Hunt12/14/41UHC-10199-34•••-••-1382-marilyn.hunt@icloud.com9381 SUNSET BOULEVARDLAS VEGAS··NV89177··GRP-4103NAVIGATE-HMO
ENRENR-1329872026-06-25T19:24:32ZJoanO.Mills·1970-09-16UHC-14255-29UNKNOWN(538) 317-6581JOAN.MILLS50@OUTLOOK.COM9345 Elm StreetTampafl33679GRP-8956MEDICARE-ADV-B
ENRENR-1116312026-03-08T10:19:04ZLAWRENCEYROBERTS1956-11-01UHC-06365-07•••-••-18427295057933lawrence.roberts98@yahoo.com8764 Ocean Ave #600TucsonAZ85760GRP-6751MEDICARE-ADV-B
ENRENR-1294612026-05-07T02:18:31ZBobbyN.Wilson·1980-12-08UHC-65025-01•••-••-2738(874) 916-7812—·2048 Lake View Road·San AntonioTX78246GRP-1788SELECT-EPO
ENR ENR-1425702026-01-19T14:18:44ZStephanieI.Richardson01/26/1983UHC-21541-96•••-••-4088(630) 533-1400stephanie.richardson@proton.me312 Park PlaceAtlantaGA30304GRP-6444MEDICARE-ADV-A
ENRENR-1270482026-04-02T18:48:55ZMichael—Dixon12/28/64UHC-35051-53··•••-••-0407(454) 477-3061michael.dixon@gmail.com8648 Church StMesaAZ85285··GRP-3640MEDICARE-ADV-B
ENRENR-1357742026-02-03T19:46:14ZJEREMY—WEST1938-07-24UHC-33653-23•••-••-811414207577384jeremy.west39@yahoo.com3262 Baseline Road Apt 32ScottsdaleAZ85232GRP-5449MEDICARE-ADV-A
ENRENR-1131982026-05-16T19:44:14ZCynthiaO.Contreras1978-03-06UHC5091371•••-••-7171+1 786 777 4387··cynthia.contreras46@proton.me··4353 WASHINGTON STPhoenixAZ85043GRP-5952CHOICE-PLUS-PPO
ENRENR-1321532026-06-10T19:42:37Z PaulXEvansNov 3, 1972UHC-64104-74•••-••-4588649-662-3518paul.evans79@outlook.com3078 Main StEden PrairieMN55310GRP-3770CORE-HMO
ENR ENR-1053482026-08-18T11:07:17ZSAMUEL—ROBERTSON19560620UHC-79235-86-8814829234samuel.robertson63@proton.me620 Bayshore DriveSan DiegoCA··92124GRP-1378··NAVIGATE-HMO
ENRENR-1066252026-06-13T09:23:13ZPaul—Wells2007-12-28UHC-24929-38•••-••-02279393438475paul.wells70@outlook.com—null·N/ANULLGRP-7766··CORE-HMO
ENRENR-1298732026-03-11T15:52:05ZPamelaS.Gibson1977-06-23UHC-10674-80•••-••-9105(319) 690-1133pamela.gibson23@gmail.com6284 MESA DRIVEJACKSONVILLEFL32211GRP-2970MEDICARE-ADV-A
ENR ENR-1019112026-10-10T11:06:58ZCHRISTOPHARZRYAN1941-12-27UHC-96863-13UNKNOWN(706) 712-3212christopher.ryan47@aol.comUNKNOWNN/A——GRP-2720NAVIGATE-HMO
ENRENR-1417232026-07-21T00:00:35ZMark—Hnry1980-11-23UHC-38838-78•••-••-8224508-529-1567··mark.henry93@icloud.com1685 Market StOrlandoFL32816GRP-0271SELECT-EPO
ENRENR-1378552026-06-13T02:03:58ZCharles—Fields1974-01-11UHC-66165-35•••-••-88862042611547charles.fields@icloud.com8642 Valley View DriveGlendaleaz85394GRP-6804MEDICARE-ADV-B
ENRENR-1090352026-04-06T13:54:48Z JESSE—BROOKS1959-09-04·UHC-74204-51•••-••-6061805.856.1241JESSE.BROOKS@HOTMAIL.COM7865 Meadow LnEden PrairieMN55365GRP-0491·SELECT-EPO
ENR ENR-1175522026-01-02T12:08:37ZAISHAYHAMILTON1952-12-06UHC-91392-64•••-••-7394395-308-1587AISHA.HAMILTON@ICLOUD.COM7189 Valley View DrMIAMIFlorida33181GRP-1825MEDICARE-ADV-A
ENRENR-1409122026-09-19T11:13:28ZHELEN·WMUNOZ1999-08-23UHC-77450-32•••-••-444316505700591helen.munoz85@aol.com7417 FOREST AVESan DiegoCA92146GRP-1505MEDICARE-ADV-A
ENRENR-1298522026-02-28T17:29:07ZSofia—Rudriguez1941-08-23UHC-80555-02•••-••-585819885105438sofia.rodriguez69@outlook.com5934 Harbor BoulevardAtlantaGeorgia30349GRP-0193CHOICE-PLUS-PPO
ENRENR-110978 2026-10-03T04:12:48ZSUSANJ.ESTRADA1994-10-02UHC-49084-09•••-••-9782410-369-6377SUSAN.ESTRADA@GMAIL.COM2377 Highland AveSan DiegoCA92141·GRP-1377SELECT-EPO
ENRENR-1190242026-09-04T22:00:41ZAshleyOValdez02/10/99UHC-62343-53—235.862.3232ashley.valdez@hotmail.com483 Hillcrest RdGlendaleAZ··85388GRP-2267OPTIONS-PPO
ENRENR-1375732026-02-03T10:56:20ZCHRISTOPHERSYOUNG1993-07-09UHC2760779•••-••-84633524015851N/A1866 Church StCHANDLERAZ·85269GRP-5069OPTIONS-PPO
ENRENR-1108722026-01-26T00:53:23ZKennedy, Sam··——10/7/2001UHC-13635-82•••-••-5533(838) 836-6336SAMUEL.KENNEDY66@HOTMAIL.COM3167 Church St·TempeAZ85231GRP-9555CORE-HMO
ENRENR-1237652026-10-03T15:48:08ZEDWARD—FOWLER2006-03-17UHC-79666-91•••-••-7358·(377) 539-2506edward.fowler@hotmail.com··630 Lincoln WayGLENDALEAZ85356GRP-5362OPTIONS-PPO
ENRENR-1080932026-01-22T21:48:23Z·CAROLJ.ALLEN·1949-11-14UHC-29947-52•••-••-4276(509) 893-5303NULL6323 Elm StMESAArizona85257GRP-1426CORE-HMO
ENRENR-1092892026-08-15T11:11:32ZHANNAHQTUCKRE11/08/57UHC-11072-98•••-••-4422+1 721 796 3172hannah.tucker@icloud.com7083 Market StreetSan DiegoCalifornia·92120-1752GRP-5667MEDICARE-ADV-B··
ENRENR-1401432026-08-04T04:21:44ZFRANCES····TUCKER19910713UHC-24971-18•••-••-24065785472frances.tucker65@hotmail.com237 PINE DRIVECharlotteNC28233GRP-4568CHOICE-PLUS-PPO··
ENRENR-1346782026-03-02T20:18:17ZScott—Garcia10/27/38UHC-93685-32NULL528-430-4823scott.garcia@outlook.com··5651 Market StMesaAZ··85228-2162GRP-3603··SELECT-EPO
ENRENR-1210582026-01-16T09:06:01ZarthurRjones10/25/52UHC-47132-05··•••-••-0138(691) 713-3101null··6332 Camelback RoadTucsonAZ85705GRP-7960OPTIONS-PPO
ENRENR-1015392026-09-21T04:20:24ZNicholasHMyers1991-12-01UHC-06759-45•••-••-8499726-408-7788·UNKNOWN8423 HIGHLAND AVEMiamiFL33112GRP-9926SELECT-EPO
ENRENR-1351642026-07-18T20:20:46Z NICOLEBSIMPSON1951-06-27UHC-75258-85•••-••-1761253-262-6271nicole.simpson@aol.com6289 Harbor BlvdLos AngelesCA90073GRP-9030MEDICARE-ADV-B
ENRENR-1106792026-07-13T05:57:29Z HAROLD··HUNT1943-12-24UHC-87704-14•••-••-6124837-332-8788harold.hunt95@hotmail.com6737 Lincoln WayAUSTINTX78743GRP-5725··CHOICE-PLUS-PPO
ENR ENR-1006532026-07-03T18:51:20ZRoobertQWelch2/9/1985UHC-71028-83•••-••-58664636892094ROBERT.WELCH90@HOTMAIL.COM5032 Park Place··TempeAZ85214···GRP-0247CORE-HMO
ENRENR-1282082026-05-03T13:53:15ZRONALD—HAWKINS1977-12-28UHC-86137-83•••-••-3431724-535-5578null1589 Lincoln Way·Miami·FL33149GRP-2896SELECT-EPO
ENRENR-1249552026-03-23T09:08:58ZShirley····Adams3/11/1958··UHC-87919-53—9054980219—2419 Sunset BlvdTampaFlorida33625GRP-9627CORE-HMO
ENRENR-1111432026-01-12T08:23:05Z ROY—JIMENEZ2000-04-02null•••-••-918316695175320roy.jimenez65@aol.com9219 Apache Boulevard Apt 30GlendaleAZ85382-4897GRP-4685OPTIONS-PPO
ENRENR-1134832026-08-25T05:15:04ZLISA··FMORALES10/19/46UHC-21468-84•••-••-91787265391lisa.morales76@outlook.com2095 Washington Street Apt 1SAN DIEGOCA92193GRP-8991CHOICE-PLUS-PPO
ENRENR-1277722026-05-26T03:45:59Z·MARYD.SHAW1949-10-03UHC-02636-81•••-••-83714666966525mary.shaw@aol.com8227 Jefferson AveEDEN PRAIRIEMN55310GRP-2595options-ppo
ENRENR-1042112026-10-04T21:52:18ZteresaPwang1980-01-09UHC-66405-35•••-••-3572(965) 542-9232teresa.wang@gmail.com1451 SPRING STREETLOS ANGELESCA90051GRP-0425MEDICARE-ADV-A
ENRENR-1023962026-06-26T10:03:26ZLUCIA··TURNER··2001-01-12uhc-13056-72•••-••-2461570-495-1378UNKNOWN7359 Willow Court··CharlotteNC28240GRP-2154CORE-HMO
ENRENR-1179142026-07-18T22:25:35Zlawrence—robertson11/8/2007UHC-69336-06—6277215926-9471 Lake View RdNASHVILLETN··37283GRP-2992SELECT-EPO
ENRENR-1321892026-07-14T11:37:46Zmary—reed06/18/1955UHC-36246-28··•••-••-5875(544) 915-8128mary.reed72@icloud.com4582 Mesa DrivePhoenixAZ85066GRP-6634SELECT-EPO
ENRENR-1146982026-09-26T00:28:59ZMarcus—Estrada2007-06-03UHC-26311-70•••-••-7278353.961.8461·marcus.estrada@yahoo.com396 Sage CtGlendaleAZ85364GRP-8793NAVIGATE-HMO
ENRENR-1036122026-04-23T22:35:42Zlori—webb1953-05-26UHC-66007-02•••-••-10433435757831lori.webb@proton.me6897 Spring StreetMinneapolisMN55441GRP-4591choice-plus-ppo
ENRENR-1316162026-04-13T01:07:47ZSANDRA—VALDEZ1950-03-32UHC-92310-32•••-••-3360(767) 669-9383sandra.valdez@icloud.com4090 Main StreetTAMPAFlorida33604GRP-0634OPTIONS-PPO
ENRENR-1068922026-06-12T17:37:07ZNTAALIEG··PIERCE1950-07-28UHC-98122-35—16014274167NATALIE.PIERCE@GMAIL.COM···8841 HILLCREST ROADEden PrairieMN55369GRP-6731OPTIONS-PPO
ENRENR-1041482026-09-02T17:21:23Z anthony—knight22-06-1973UHC-86954-11•••-••-5360(446) 983-9018ANTHONY.KNIGHT13@GMAIL.COM7521 Market StSAN DIEGOCA92153GRP-9526MEDICARE-ADV-A
ENRENR-1140552026-03-26T07:28:55ZFlores—Anna1972-04-18UHC-40667-22—5205346546ANNA.FLORES@GMAIL.COM6029 Grand AvenueGILBERTAZ85244GRP-8597MEDICARE-ADV-B
43,101 rows, page 167 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:38.496Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty