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-1191422026-03-24T06:38:23Z ·Justin—Hernandez·1973-03-15UHC-16233-08•••-••-6123+1 941 543 7237justin.hernandez@gmail.com2480 Cedar LnDenverCO80221GRP-1735NAVIGATE-HMO
ENRENR-1015972026-07-30T06:00:08ZDorothyO.Richards1944-08-27UHC-27953-85•••-••-9870348-559-7269DOROTHY.RICHARDS87@YAHOO.COM5882 Elm StTempeAZ85287GRP-8400MEDICARE-ADV-A
ENRENR-1231082026-10-11T09:36:27Zkelly—edwards2004-12-24UHC9263223•••-••-1090909-506-6660—150 Lincoln WayEden Prairie·MinnesotaNULLGRP-1679OPTIONS-PPO··
ENRENR-1310952026-08-11T15:31:01ZBEN—STEPHENS2000-09-03UHC-97938-47•••-••-9150(579) 793-7196BENJAMIN.STEPHENS43@YAHOO.COM7552 Sunset BlvdScottsdaleAZ85263GRP-5932MEDICARE-ADV-A··
ENRENR-1027632026-06-05T20:36:07ZBobby—Huwell1958-12-16UHC-79796-62•••-••-89716763100784bobby.howell89@outlook.com4683 Spring StreetSacramentoCA95854GRP-5048MEDICARE-ADV-B
ENRENR-1391012026-03-13T05:59:26ZKatherine—Herrera1945-05-12UHC-75560-68•••-••-7820(389) 555-4600katherine.herrera98@yahoo.com··3859 Forest AveSan AntonioTXnullGRP-1259CHOICE-PLUS-PPO
ENRENR-1028702026-04-21T12:52:18ZChristopherUMendoza1940-07-08UHC-01903-53•••-••-08547615025764CHRISTOPHER.MENDOZA62@PROTON.ME3250 Meadow Lane #944SeattleWashington98110GRP-1248NAVIGATE-HMO
ENRENR-1085022026-03-09T23:18:20ZHELEN—WEBB1971-02-27UHC-48043-73•••-••-7503(231) 739-5609helen.webb@yahoo.com8349 BROADWAYLos AngelesCalifornia90035GRP-4577MEDICARE-ADV-B
ENRENR-1181892026-03-30T02:54:21ZkathrynXsims1967-11-06UHC-39197-67•••-••-9301975-301-8836KATHRYN.SIMS23@OUTLOOK.COM9716 RIVER ROAD Apt 17MINNEAPOLISMNN/AGRP-2823MEDICARE-ADV-A
ENRENR-1398042026-07-21T21:47:44ZBryan··WeberJul 26, 1945UHC-47291-99•••-••-850314356732579bryan.weber85@icloud.com5198 Willow CtFresnoCA93772GRP-9558CHOICE-PLUS-PPO
ENRENR-115581 2026-03-29T05:27:22ZYang, Henry····—1987-12-03UHC-64402-89•••-••-0897711-760-5827HENRY.YANG45@PROTON.ME4104 Highland AveDallasTX75298GRP-9065select-epo
ENRENR-1378792026-03-16T21:35:55ZMadisonWFlores1998-03-13—•••-••-5993+1 261 752 0872·MADISON.FLORES40@OUTLOOK.COM3715 Main StreetFresno··CA93757GRP-3184medicare-adv-b
ENRENR-1299642026-03-01T08:03:40ZJOSE—HOLMES03-06-1986UHC-99216-44—2479018921jose.holmes82@proton.me4808 Meadow Ln·San DiegoCA92189··GRP-3442MEDICARE-ADV-B··
ENRENR-1196652026-09-18T09:33:33ZChuckLCooper09/21/1957UHC-86600-48NULL(570) 647-4458charles.cooper@proton.me599 CEDAR LN·Eden PrairieMN··55375·GRP-7559MEDICARE-ADV-A
ENRENR-1106692026-05-28T02:00:06ZJEAN—WOODS1968-08-23UHC-85580-03•••-••-1373749.814.3792jean.woods15@hotmail.comUNKNOWN—UNKNOWN—GRP-9149··CHOICE-PLUS-PPO
ENRENR-1166132026-04-09T04:45:36ZOmar—Bakr12/17/1982UHC-82232-61•••-••-2095(794) 695-5898OMAR.BAKER57@OUTLOOK.COM5030 Desert Sky BoulevardOrlando·FL—GRP-6402MEDICARE-ADV-A
ENRENR-1277852026-07-04T10:44:33ZSeanXRoberts23-10-1969UHC-99121-47•••-••-4256405.234.8038sean.roberts22@yahoo.com8385 Bayshore DriveMesaAZ85226GRP-3455medicare-adv-b
ENRENR-1134112026-06-11T18:05:37Z DeniseQGuerrero1997-11-18UHC-92483-29N/A(584) 711-3510DENISE.GUERRERO@GMAIL.COM4184 Highland AvenueTUCSONAZ85734GRP-8036SELECT-EPO
ENRENR-1236182026-01-05T02:19:59ZLAUREN—MUNOZ·1989-07-19UHC-64060-30•••-••-0201nulllauren.munoz12@proton.me8553 MAPLE AVEDallastx·75224GRP-3198CHOICE-PLUS-PPO
ENRENR-1417982026-09-09T10:13:05ZEDWARDO.SANTOS1980-10-27UHC-53994-50•••-••-41735116092edward.santos@yahoo.com·7324 River RoadCharlotteNC28249-4059·GRP-8269NAVIGATE-HMO
ENRENR-1145052026-06-27T12:44:28ZYoungEYuki1996-07-28UHC-62181-02•••-••-99239112513503yuki.young@yahoo.com··3765 Central AveGlendaleArizona85393GRP-4169MEDICARE-ADV-B
ENRENR-1379782026-08-26T08:47:11ZPriyaPValdez1962-08-15UHC-79291-64•••-••-23244966934089priya.valdez77@aol.com3451 Willow CourtTempeAZ85217GRP-8033OPTIONS-PPO
ENRENR-1282922026-04-30T19:27:28Z HNERY—CHENN/AUHC3323714··•••-••-5319359-557-7703·HENRY.CHEN@PROTON.ME7603 SUNSET BOULEVARDDallasTX75297-8136GRP-3718CHOICE-PLUS-PPO
ENRENR-1174412026-10-04T10:44:05ZGARYLMILLER··04/20/1993UHC-58590-92•••-••-39512112920633-··6416 Harbor BoulevardLos Angelesca90038GRP-2490CORE-HMO
ENRENR-1143482026-07-02T20:17:10Zaisha—miller19481019UHC-31707-73•••-••-8947·(597) 363-5984aisha.miller@yahoo.com··5672 ELM STREET #540AUSTINTX·78716GRP-0571CORE-HMO
ENRENR-1026402026-02-18T11:29:52ZDORIS—·OWENS1976-10-07UHC-50196-22•••-••-6469490.618.4510DORIS.OWENS87@OUTLOOK.COM3552 Highland AvenueMinneapolisMN55408-6252GRP-6753MEDICARE-ADV-A
ENRENR-1216812026-06-20T02:09:46ZJoanJ.Price1950-02-35NULL•••-••-1041+1 276 621 8860—390 Park PlaceCOLUMBUSOH43262GRP-6940core-hmo
ENRENR-1212122026-09-19T23:50:05Z·NANCYBJONES5/18/1950UHC-53125-95—(982) 718-5668NANCY.JONES21@OUTLOOK.COM··6297 Hillcrest Rd #320LAS VEGASNV89198··GRP-3567OPTIONS-PPO
ENRENR-1266542026-09-04T15:12:47ZMaria··HCarter07/21/41··UHC-99707-79•••-••-8008(936) 584-7459maria.carter96@yahoo.com·4284 Pine DrGilbertAZ85297··GRP-3483···CHOICE-PLUS-PPO
ENRENR-1358172026-02-07T09:53:44ZSaraLFreeman19860622UHC-04806-77•••-••-8578+1 830 997 3647sara.freeman@outlook.com2306 Cedar LnDallasTXN/AGRP-9906CHOICE-PLUS-PPO
ENRENR-1312032026-05-31T20:02:07ZMADISON—BENNETT1987-08-09UHC-18742-54•••-••-2740(391) 984-2076MADISON.BENNETT52@HOTMAIL.COM·8827 HIGHLAND AVELas VegasNVnullGRP-0243CORE-HMO
ENRENR-1348192026-09-22T18:28:52ZHarold—Myers22-09-1971UHC-42540-15NULL(950) 549-4076··harold.myers@gmail.com9113 Indian School RoadJacksonvilleFL32299GRP-7908MEDICARE-ADV-A
ENRENR-1287812026-04-29T13:33:49ZGarrett, Katherine——1995-02-20UHC-28181-31•••-••-0456(325) 458-5437N/A6193 PINE DRIVE··San AntonioTX78259-2882GRP-4010SELECT-EPO
ENR ENR-1187182026-08-29T18:45:42ZWong, JonathanF—04/11/76UHC-36675-44•••-••-82695996510525jonathan.wong34@proton.me7028 CANYON ROADOrlandoFL32815GRP-4920SELECT-EPO
ENRENR-1304492026-05-30T15:30:11Z·AdamDWood1/5/1941UHC-86873-43•••-••-2697795-523-5880··8490 Highland AvenueCharlotteNC28251GRP-8720··OPTIONS-PPO
ENRENR-1366512026-03-23T03:34:29ZLAURAN.WAGNER·1965-11-27UHC-30017-27•••-••-1937UNKNOWNlaura.wagner@yahoo.com7724 Lincoln Way #851CHARLOTTENorth Carolina28246GRP-6522MEDICARE-ADV-A··
ENRENR-1385992026-02-25T17:55:54ZGregoryC.Roberts·1939-06-13UHC-77088-92•••-••-8574875.457.5584gregory.roberts21@aol.com2851 MEADOW LNJacksonvilleFL32289GRP-3613NAVIGATE-HMO
ENRENR-1376302026-06-23T16:43:45ZVincent·OOwens1940-03-06UHC-82525-96··•••-••-42983325679622vincent.owens40@icloud.com7679 Church StJacksonvilleFL32222-2878GRP-6301CHOICE-PLUS-PPO
ENRENR-1103072026-04-14T14:44:06ZYUKIJFREEMAN1964-12-08UHC-15344-01•••-••-4918+1 392 511 4397·yuki.freeman31@gmail.com971 Market StDallasTX75249GRP-1680SELECT-EPO
ENRENR-1192832026-05-13T12:31:41ZPhilipFShaw1960-12-18UHC8133684—·(949) 223-5526philip.shaw@proton.me9709 Highland AvenueCharlotteNC28261GRP-6627NAVIGATE-HMO
ENRENR-1089862026-07-31T14:10:27ZaaronBsmith1947-09-28uhc-12751-91•••-••-39363963702963AARON.SMITH@HOTMAIL.COM6483 Washington StreetGilbertAZ85253GRP-2389OPTIONS-PPO
ENRENR-1122592026-01-27T07:56:22Zcarl·W.peterson2/24/1955UHC5636627•••-••-6271433-539-0980··—1835 Lincoln WayHoustonTexas77088··GRP-8453OPTIONS-PPO
ENRENR-1292212026-08-01T03:28:05ZAMBERJWARD2008-04-19UHC-90288-15UNKNOWN217-517-5241amber.ward@icloud.com1260 Willow CourtAustinTX78734GRP-6161select-epo
ENRENR-1075812026-07-31T16:23:09ZMarkD.EspinozaDec 3, 1947UHC-46329-47•••-••-02246137008519mark.espinoza@hotmail.com6501 Willow CtTampa·FL33687GRP-4792OPTIONS-PPO
ENRENR-1134792026-10-09T17:33:35ZChapman, VincentG.—2001-08-26UHC-05422-13null721-359-4201VINCENT.CHAPMAN17@YAHOO.COM694 Lake View RoadTampaFL·33609GRP-5099CORE-HMO
ENRENR-1387292026-05-16T14:47:14ZSofiaM.··Richards06/09/97UHC-38846-21•••-••-7932531.889.6083SOFIA.RICHARDS@AOL.COM7080 Market StTampaFL33690GRP-2377NAVIGATE-HMO
ENRENR-1017452026-04-24T16:44:05ZOMARG.ALVAREZ1969-02-23UHC-90628-42-9706578344omar.alvarez@icloud.com273 Indian School RdSeattleWashington98193GRP-4210SELECT-EPO
ENRENR-1334052026-05-09T01:23:58ZStephenY.Webb06/21/50UHC-02013-78•••-••-1139(702) 864-1262N/A3827 Camelback Road #983MesaAZ85215GRP-0960SELECT-EPO
ENRENR-1182122026-05-05T09:02:18ZADAM—WELCH1599-06-12UHC-45041-79•••-••-55619463128704adam.welch@icloud.com4241 DESERT SKY BLVDTampa·FL33648·GRP-1545CHOICE-PLUS-PPO
ENRENR-1232252026-08-28T22:55:34ZMateo—Wallace5/21/1980UHC-01998-49N/A(889) 522-5399MATEO.WALLACE@ICLOUD.COM8602 Harbor BlvdDENVER··CO80228GRP-3536CHOICE-PLUS-PPO
43,101 rows, page 296 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.457Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty