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
ENR ENR-1368672026-02-23T18:34:26ZPaulAHayes1972-04-21UHC-62424-22•••-••-7044(541) 457-0519paul.hayes@gmail.com·2956 PARK PLDenverCO80251·GRP-7827NAVIGATE-HMO
ENRENR-1165812026-03-26T17:51:14ZEric····Bradley2003-07-12·UHC-27162-40•••-••-72418167000493··eric.bradley@aol.com3766 Main St·Orlandofl32810GRP-0577SELECT-EPO
ENRENR-1129602026-04-03T12:15:53ZSTEPHANIE—HUGHES06/17/07UHC-83080-68•••-••-2429+1 399 627 6055—8651 Grand AveSan DiegoCalifornia92124·GRP-6391MEDICARE-ADV-A
ENRENR-1191052026-09-16T21:36:15ZLori F—Hunt05/24/90UHC-23583-92•••-••-21033428429051lori.hunt@proton.me4504 FOREST AVEPlanoTX75013GRP-0823MEDICARE-ADV-B
ENRENR-1084462026-02-01T05:28:11ZPHIIP—BRADLEY28-06-1945UHC-47879-82•••-••-4225629.984.4473philip.bradley@icloud.com2457 HILLCREST RDMinneapolisMN55448GRP-9547NAVIGATE-HMO
ENRENR-1014602026-02-01T15:12:28Zjordan—welchNov 13, 2001UHC-43144-83•••-••-99142712167241-2704 MAPLE AVENUEDenverColorado80226··GRP-2357CORE-HMO
ENRENR-1314702026-02-28T03:06:12ZNunez, Laura··B.—1969-01-27UHC5688353—·(858) 473-2755laura.nunez56@proton.me———·nullGRP-0760CHOICE-PLUS-PPO
ENRENR-1158802026-10-08T19:01:55ZWashington, JosephX.—03/12/1992UHC-01161-96•••-••-2215——3388 Bayshore DrSan Diego··CA92148GRP-3258NAVIGATE-HMO
ENRENR-1233102026-05-19T19:32:35ZMEGAN—LANE·1964-12-19·UHC-47487-90•••-••-09693222988733··MEGAN.LANE@AOL.COM5431 Market StreetHoustonTX77036GRP-0263CHOICE-PLUS-PPO
ENRENR-1002912026-01-08T07:18:48ZReyes, Nathan——28-02-1958UHC-33555-36····645.643.3521nathan.reyes20@gmail.com3880 Market StLOS ANGELESCA90015GRP-5667MEDICARE-ADV-A
ENRENR-1283092026-08-06T07:22:51ZVICTORIACFIELDS1943-08-20UHC7035974•••-••-5979(619) 488-5016VICTORIA.FIELDS@ICLOUD.COM··4522 Mesa DriveMinneapolisMN55473GRP-8823SELECT-EPO
ENRENR-1380532026-08-22T15:07:55ZIsabellaRMcDonald03-02-1965UHC4258712•••-••-4624(897) 348-0903isabella.mcdonald72@gmail.com4192 Willow Court·OrlandoFL·32816GRP-1821OPTIONS-PPO··
ENRENR-1182842026-05-10T15:57:00ZBarbara··Shaw1954-03-19UHC-83540-31•••-••-2946·805-292-3555barbara.shaw7@outlook.com2946 BroadwayChandlerAZ85290GRP-1723·MEDICARE-ADV-B
ENRENR-1095462026-07-01T13:44:49ZDebra—Rojas·1990-11-06UHC-98536-76·UNKNOWN5406173727debra.rojas@outlook.com1359 Desert Sky BlvdAtlantaGA30359GRP-9258choice-plus-ppo
ENRENR-1069362026-01-11T19:51:06ZRaymond·····Simmons19720203UHC4344849•••-••-091715704047418UNKNOWN5242 Desert Sky BlvdNashvilleTennessee37204GRP-3841MEDICARE-ADV-A
ENRENR-1304152026-04-22T12:18:14Z·Stephen—Gonzales05/06/85··UHC-33555-92null+1 814 998 3344··stephen.gonzales77@hotmail.com·789 Highland Ave Apt 30TucsonAZ85780GRP-7595MEDICARE-ADV-A
ENRENR-1030612026-09-14T16:48:03ZJUSTINSROSS1967-06-09UHC-47202-05-3745207214JUSTIN.ROSS41@GMAIL.COM3558 Market StreetSacramentoCA95800GRP-6797CORE-HMO
ENRENR-1129012026-06-04T17:47:37Znicholas—harris1967-05-19UHC-74346-37•••-••-45609659816··nicholas.harris3@hotmail.com2764 WASHINGTON STFresno··CA93729GRP-0793CORE-HMO
ENRENR-1369422026-05-29T04:36:22ZmeganIperez1981-42-22UHC-14015-28•••-••-61594484811664null1460 Bayshore DrMIAMIFL33161GRP-2028OPTIONS-PPO
ENRENR-1113512026-06-09T21:53:25ZMatthewODay··1971-04-04UHC-65445-38•••-••-4577284-928-2812NULL··3392 Washington StNashvilleTN37226GRP-4562CORE-HMO
ENR ENR-1170472026-08-07T14:15:10ZRuth—Vazquez2006-09-08UHC1161556—243-961-7794ruth.vazquez2@hotmail.com3458 Oak St Apt 38San AntonioTX78282GRP-4819MEDICARE-ADV-A
ENRENR-1150812026-03-14T16:28:39ZArjunN.Cooper1997-01-20UHC-97990-01•••-••-6224910-210-6468··arjun.cooper@hotmail.com3243 Ocean AvenueFresnoCalifornia93794GRP-4607NAVIGATE-HMO
ENRENR-1201132026-01-28T02:13:46ZbrittanyO.lopez2007-09-28UHC-60602-70null15839624422brittany.lopez@aol.com3394 Maple Avenue··MinneapolisMN55431GRP-8458NAVIGATE-HMO
ENRENR-1371462026-01-12T07:36:05ZDoris··Brooks21-09-1945UHC-60379-29•••-••-59297549480379DORIS.BROOKS7@ICLOUD.COM7254 SPRING STREET·DallasTX75263··GRP-4826SELECT-EPO
ENRENR-1006582026-07-25T06:08:35ZHiroshi—Ortega11/11/79UHC-36461-06•••-••-07547748608302·hiroshi.ortega@icloud.com188 Elm StAustin··TX78799GRP-1116MEDICARE-ADV-B
ENRENR-1093142026-03-08T22:39:35ZSofiaC.Thomas2001-05-06··UHC-67835-89NULL2337845661N/A4069 River RdMesaAZ85254GRP-4870SELECT-EPO
ENRENR-1326612026-06-23T03:15:12ZAustin, JudithH.—11/12/48UHC-16752-93•••-••-7760445.868.8624JUDITH.AUSTIN33@AOL.COM1210 Maple AveSacramentoCA95846GRP-5890SELECT-EPO
ENRENR-1378692026-04-14T22:38:58ZAaronFSalazar10/18/1962UHC-14420-33•••-••-4016(988) 604-9189aaron.salazar@aol.com5728 Willow CtLos AngelesCA90034GRP-2210MEDICARE-ADV-A
ENRENR-1237582026-01-08T03:22:54ZZachary—Maldonado22-02-1987UHC-14103-56•••-••-4120—ZACHARY.MALDONADO@YAHOO.COM3999 UNION STHouston··TX77083-8886GRP-3560CHOICE-PLUS-PPO
ENRENR-1266272026-09-23T04:42:31ZPowell, SandraX—·1996-04-25N/A•••-••-6735(975) 850-5545sandra.powell@yahoo.com9548 Main StLos AngelesCA90026-6789GRP-0175CORE-HMO
ENRENR-1000292026-08-17T05:49:54ZLane, Timothy—··1980-03-16··UHC-70224-52•••-••-81533955053334timothy.lane2@hotmail.com···2915 MOUNTAIN VIEW DRMiamifl33157GRP-9445··SELECT-EPO
ENRENR-1386032026-05-05T22:22:10ZDANIEL··U.GREEN1946-02-17UHC2907058•••-••-51703202522313daniel.green@yahoo.com4763 Jefferson AveSan Antonio··tx78260GRP-6629MEDICARE-ADV-A
ENRENR-1227052026-10-02T22:13:28ZElizabethUDiazApr 19, 2001UHC-43655-21null263-225-6735··—4787 Oak StreetTampaFL33671-2505GRP-3083·SELECT-EPO
ENRENR-1187942026-08-30T10:45:49ZJoshuaZ.Gommez1951-11-12UHC-15543-16—7467252332—2449 Highland AvenueAtlantaGA30381GRP-1945OPTIONS-PPO
ENRENR-1192992026-09-04T14:29:37ZJULIADGRAHAM··2006-04-17··UHC-59944-91•••-••-4919UNKNOWNNULL1535 Cedar LaneDENVERCO80244GRP-2415CORE-HMO
ENRENR-1172092026-05-08T05:01:27ZHENRYX.HANSON1963-10-24UHC-69978-70•••-••-9977215-547-1729—8735 Bayshore DrHoustonTX77067-9354GRP-9864MEDICARE-ADV-B
ENRENR-1234952026-01-27T22:41:34ZBradley··George1962-07-12UHC-69200-97N/A·2703995001BRADLEY.GEORGE64@OUTLOOK.COM7412 Maple AvenueHOUSTONTX77099GRP-7866OPTIONS-PPO
ENRENR-1146232026-03-21T22:39:53Z Joshua··Yang1940-09-11·UHC2978890•••-••-5706·+1 638 453 6285joshua.yang72@gmail.com960 CENTRAL AVETampa·FL33622GRP-5636CORE-HMO
ENRENR-1363522026-01-01T11:45:32ZHarold··IBerry1956-02-23UHC8772731•••-••-9047—N/A8824 MEADOW LANESan AntonioTX78234GRP-9861NAVIGATE-HMO
ENRENR-1282302026-03-02T15:52:52ZGeorgeXRobinson1999-01-11UHC-33174-40UNKNOWN(958) 913-8536george.robinson48@hotmail.com4700 Highland Ave·MIAMIFL33160GRP-5606options-ppo
ENRENR-1414652026-04-13T05:33:00ZSeanD.CunninghamSep 7, 1948UHC-84508-19•••-••-2438973-933-6958sean.cunningham@icloud.com6245 Jefferson AveHOUSTONtx77057GRP-4876CORE-HMO
ENRENR-1016542026-09-26T06:16:36ZJoanECarroll1998-08-14UHC-14707-27null·(309) 908-0034NULL8102 Willow CtMINNEAPOLISMN55424GRP-8540··MEDICARE-ADV-A
ENR ENR-1031402026-07-04T08:11:40ZSHARON—HUNT1954-12-21UHC4145676•••-••-7034·(970) 916-8811sharon.hunt@aol.com··2580 CAMELBACK ROADAtlantaGA30337GRP-3664CHOICE-PLUS-PPO
ENRENR-1170752026-06-25T20:58:56ZMATEOE··BARNES1954-02-13UHC-54709-71•••-••-7017759-849-8133—7827 Hillcrest RoadAtlantaGA30335GRP-5709SELECT-EPO
ENRENR-1405712026-06-02T11:47:25ZElijahBGreene1999-02-21UHC-47987-55•••-••-87929253747574elijah.greene@aol.com8743 Willow CourtSan AntonioTX78291GRP-6078CORE-HMO
ENRENR-1371202026-05-03T13:12:56ZZACHARYI.BANKSJul 3, 1983UHC-61243-13—(925) 907-5168ZACHARY.BANKS@YAHOO.COM2526 Union Street··OrlandoFL32802-1136GRP-4453MEDICARE-ADV-B
ENRENR-1198602026-09-29T12:41:22ZJordanWEllis2004-09-04UHC-92342-99•••-••-9016407-298-7303JORDAN.ELLIS54@OUTLOOK.COM9877 Mesa Dr···HoustonTX77026GRP-5205MEDICARE-ADV-A
ENRENR-1052872026-06-06T23:38:16ZROBERTA.WANG03-08-1951UHC-24041-45•••-••-5080(238) 665-0626robert.wang24@proton.me167 Harbor BlvdSACRAMENTOCA95888GRP-1677medicare-adv-b
ENRENR-1358852026-09-21T09:17:21Z CharlesXHoward1976-05-21UHC-52765-28•••-••-3961NULLcharles.howard@hotmail.com·4247 Main StScottsdaleAZ85244GRP-7666MEDICARE-ADV-B
ENRENR-1308332026-08-27T21:18:34Z MeiH.Richards1968-07-04UHC-37060-25•••-••-766812779225026UNKNOWN··4068 Grand AvenueNashvilleTN37205GRP-3790OPTIONS-PPO
43,101 rows, page 171 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.500Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty