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-1338402026-08-30T18:27:26ZSCOTTZDUNCAN06/06/70UHC-34340-60•••-••-7686(201) 442-1258scott.duncan35@gmail.com71 Bayshore DrLOS ANGELESCA90071··GRP-0102NAVIGATE-HMO
ENRENR-1405592026-05-12T10:29:43Zpat····ruizSep 23, 1953UHC-33799-24•••-••-2331nullN/A5562 Desert Sky BoulevardAustinTX78768GRP-2609SELECT-EPO
ENRENR-1284342026-10-03T16:40:52ZMariana—Autsin1967-10-15UHC-60247-95null(787) 539-2929NULL5576 Oak StDenverCO80282GRP-9519MEDICARE-ADV-A
ENRENR-1234582026-08-09T17:04:18ZDominguez, WalterP.—·19441103UHC-68577-83•••-••-3601404-299-4976walter.dominguez@proton.me7860 Palm DriveAtlantaGA30304GRP-8567MEDICARE-ADV-B
ENRENR-102751 2026-10-10T09:43:57Zrachel····espinoza1955-09-10UHC-13174-25•••-••-8952350-603-1190rachel.espinoza90@gmail.com4838 Hillcrest RdLos AngelesCA90052-6673GRP-5364options-ppo
ENRENR-1276272026-08-15T07:49:31Z charlesB.park10/5/1981·UHC-62409-36•••-••-85297554475383charles.park79@gmail.com949 Canyon Road···OrlandoFL32850GRP-2939CHOICE-PLUS-PPO
ENRENR-1013082026-07-25T01:50:37ZBEVERLYX.DOMINGUEZ1963-06-01UHC-31657-36•••-••-5759923-350-0104··BEVERLY.DOMINGUEZ@GMAIL.COM2507 Cedar LnSan DiegoCA92172-1357GRP-7759MEDICARE-ADV-B
ENRENR-1214252026-01-04T21:43:16ZEmilyA.Brown12/10/1943UHC-53245-33•••-••-5215—emily.brown61@icloud.com8526 Valley View DrEden PrairieMN55332-4586GRP-4107MEDICARE-ADV-B
ENRENR-1273882026-05-30T15:37:19ZNathanIHowell1964-12-06UHC-07876-80•••-••-7782(924) 610-9802·nathan.howell75@aol.com5739 MAIN ST #263MiamiFL33146·GRP-3055MEDICARE-ADV-A
ENRENR-1215802026-07-08T02:05:46Z·MELISSA—ANDERSON7/2/1981UHC0012395•••-••-7710(327) 603-5760N/A8861 CANYON RDAtlantaGeorgia30362GRP-2990MEDICARE-ADV-B
ENRENR-1298312026-01-03T00:11:50ZchristineNcontreras03-08-2008UHC-67401-81•••-••-5916·14453392976christine.contreras92@gmail.com5571 Meadow Ln #461OrlandoFL32849GRP-2496MEDICARE-ADV-A
ENRENR-1250432026-06-23T22:48:32ZRomero, FattimaK—1948-06-21UHC-50296-36•••-••-12624778499732fatima.romero35@outlook.com2284 Desert Sky BlvdSan DiegoCA92166·GRP-6858CHOICE-PLUS-PPO
ENRENR-1427542026-09-11T04:32:53ZCHARLOTTE—LYNCH1978-11-05UHC-58530-01•••-••-8431204-624-8320CHARLOTTE.LYNCH@HOTMAIL.COM9516 Cedar LnLAS VEGASNV89120GRP-6876CORE-HMO
ENRENR-1099672026-04-07T18:20:48ZJonathanRGardner2005-01-12UHC-39941-90•••-••-5329+1 568 888 2951JONATHAN.GARDNER3@ICLOUD.COM5168 RIDGE ROADGilbert·AZ85265··GRP-2672MEDICARE-ADV-A
ENRENR-1355892026-06-02T17:49:12ZJuliaE.Brwon1989-05-17UHC-01468-21•••-••-6352950-230-3813JULIA.BROWN@OUTLOOK.COM8084 Main StSacramentoCA·95885GRP-2590NAVIGATE-HMO
ENRENR-1400092026-09-08T17:52:25ZDelgado, Vincent——2/12/1960UHC-58815-25•••-••-6416740.212.6774vincent.delgado39@aol.com5442 SUNSET BLVDMIAMIFL33162GRP-4598SELECT-EPO
ENRENR-1012112026-04-22T17:08:19ZCHRIZTIANI.WILILAMSON1974-08-05UHC-01208-77•••-••-3650(664) 670-2564CHRISTIAN.WILLIAMSON@ICLOUD.COM3455 Oak StCHANDLERAZ85285-7886GRP-3640MEDICARE-ADV-B
ENR ENR-1306012026-01-17T05:52:06ZSCOTT—DUNCAN19971026UHC-47476-28•••-••-2074·525-373-6120—4543 Indian School RoadGilbert··AZ85261··GRP-9357SELECT-EPO
ENRENR-1165292026-04-07T11:58:12ZPhilip—Morales1963-02-13UHC-36559-45—725-307-1982··PHILIP.MORALES@ICLOUD.COM5117 OAK STSan AntonioTX··-GRP-4611MEDICARE-ADV-A
ENR ENR-1374842026-02-27T07:37:26ZCAMILAWROBERTS10/8/1962UHC-00540-94•••-••-9760-null6271 Spring StreetAtlantaGA30315GRP-9395CHOICE-PLUS-PPO
ENRENR-1045072026-08-17T02:21:14Z·RYAMONDVRILEY1973-12-25UHC-77200-05•••-••-88218431450RAYMOND.RILEY@ICLOUD.COM375 MARKET STREETScottsdaleAZ85269·GRP-0790OPTIONS-PPO
ENRENR-1097532026-09-28T01:14:15ZCAROL—MARTINEZ19720511UHC9383627•••-••-725219649427273carol.martinez@aol.com3394 River Rd #101··MESAAZ85253GRP-8743CHOICE-PLUS-PPO··
ENRENR-1326232026-03-03T02:28:34ZVictoriaHHerrera··1985-11-07UHC-13803-78•••-••-717416482891546VICTORIA.HERRERA@YAHOO.COM6217 Park PlaceAustinTX78727-4102··GRP-0615··OPTIONS-PPO
ENRENR-1205412026-07-28T11:02:17ZRALPH—KNIGHT1949-10-18UHC-81725-26•••-••-78795938532084-9517 Maple Avenue #957DenverCO80230GRP-8600CHOICE-PLUS-PPO
ENRENR-1405572026-08-19T18:42:35ZAUSTIN—ESPINOZA20030223··UHC-00961-08•••-••-8085+1 313 346 8698austin.espinoza@outlook.com2063 VALLEY VIEW DRMinneapolisMNNULL·GRP-1557SELECT-EPO
ENRENR-1156882026-08-12T03:25:43ZkyleC··kennedy1942-03-20UHC-01849-87•••-••-06729896774999··NULL5973 Meadow LaneOrlandoFL··32876GRP-5609MEDICARE-ADV-A
ENRENR-1078752026-01-24T10:47:21ZSANTIAGOJMENDOZA1953-03-28UHC1478934•••-••-1575526-353-4623SANTIAGO.MENDOZA@OUTLOOK.COM4061 Oak StLas VegasNV89147GRP-5301MEDICARE-ADV-A
ENRENR-1353082026-06-04T23:30:05ZMarkIHunt··24-01-1979UHC-14722-67•••-••-5836800.759.5729mark.hunt18@aol.com6380 LAKE VIEW ROADCharlotte·NC28257-0255GRP-7560medicare-adv-b
ENRENR-1294102026-09-14T04:57:25ZThomas, WayneS····1954-02-10UHC-60306-66•••-••-1255(771) 463-0083wayne.thomas@aol.com4016 JEFFERSON AVENUESEATTLEWA98168GRP-2398CHOICE-PLUS-PPO
ENRENR-1000832026-10-13T06:56:24ZMelissa D—Fields09/13/51UHC-11822-38•••-••-1840(801) 474-6440melissa.fields63@aol.com754 CENTRAL AVENUEHoustonTX77085GRP-9803SELECT-EPO
ENRENR-1222442026-08-06T17:41:19ZStephenX··Maruez1949-04-06UHC-65576-81•••-••-2386780.397.7499stephen.marquez73@hotmail.com1177 Valley View DriveCharlotteNC28283GRP-3687CHOICE-PLUS-PPO
ENRENR-1065192026-05-09T13:51:07ZKATHRYN—TRUNER1952-02-22UHC-15096-04null521-791-3689UNKNOWN1319 Harbor BoulevardEden PrairieMN··55396GRP-2122select-epo
ENRENR-1127742026-06-11T22:03:12ZCHERYLO.GRAHAM··1981-01-16UHC-72022-38•••-••-474819784971779cheryl.graham@gmail.com6905 Elm StMinneapolisMinnesota55411··GRP-3006CHOICE-PLUS-PPO
ENRENR-1270662026-05-10T23:13:22ZFrances—Guerrero19610823UHC-33432-90•••-••-1244nullUNKNOWN——··UNKNOWNGRP-5301MEDICARE-ADV-B
ENRENR-1207512026-01-31T04:31:42ZERICABELLOct 3, 1943UHC-12366-37·null734-973-8013ERIC.BELL72@AOL.COM6105 Bayshore Dr Apt 9DENVERCO80258GRP-8224OPTIONS-PPO
ENRENR-1073612026-01-03T17:50:33ZBradley, William——03/20/1964UHC-33492-59•••-••-2560N/AWILLIAM.BRADLEY39@AOL.COM9247 Jefferson AvenueGlendaleAZ85349GRP-3826OPTIONS-PPO
ENRENR-1050802026-10-01T08:41:16ZSARAH··—WILLIAMS2001-09-16UHC-18323-04•••-••-3372616.663.1163—1699 Market StJACKSONVILLEFL32282GRP-1812CORE-HMO
ENRENR-1364942026-06-18T06:56:28ZROGERZROBERTSON05/06/02··UHC-81335-37··•••-••-9942·764-941-0369-2995 HILLCREST RD··DenverCO80224GRP-8578MEDICARE-ADV-A
ENRENR-1262722026-01-25T20:25:28ZMateo—Hansen01/23/1996UHC-39094-52•••-••-2856545-338-7079MATEO.HANSEN2@AOL.COM·1668 Jefferson AveChandlerAZ85243··GRP-9170OPTIONS-PPO
ENRENR-1296672026-06-27T02:26:07Z Hamilton, AngelaE—Jul 12, 1940UHC-79266-88•••-••-82853734346613angela.hamilton81@yahoo.com2240 Market Street··CHANDLERAZ85202GRP-2243CHOICE-PLUS-PPO
ENRENR-1232882026-01-18T21:28:01ZWEI··GHARRIS1954-03-16UHC-52056-94NULL539-474-8760-5028 Ridge RoadColumbusOH43212GRP-5068MEDICARE-ADV-A
ENRENR-1022102026-05-12T12:57:52ZJUDITHZSANTIAGO19520324UHC-25546-73•••-••-84923866895554judith.santiago@proton.me2694 Market Street·DENVERCO80216GRP-7053SELECT-EPO
ENRENR-1208822026-01-31T12:27:25ZSamanha—Crawford2006-05-16UHC5041288•••-••-1900(527) 303-6319—5510 Highland AvenueTAMPAFL33685GRP-9755·SELECT-EPO
ENRENR-1236112026-06-12T08:07:03Zkevin—cunningham1962-09-09UHC-16646-65•••-••-12392608973093kevin.cunningham97@proton.me4566 Forest Avenue #209Phoenix··AZ85099··GRP-9678SELECT-EPO
ENRENR-1279082026-04-15T02:51:20ZDIEGO—HOLMES19731201··UHC-69313-48····null—1427 Palm DrTempeAZ85241GRP-7461·MEDICARE-ADV-A
ENRENR-1347672026-06-05T02:09:07ZbrianBcarpenter1975-09-10uhc-74079-84•••-••-0695588-533-2447NULL··3989 BROADWAY·Denverco80290GRP-9712MEDICARE-ADV-B
ENRENR-1071712026-09-30T20:22:00ZBrandonLTucker10/06/01UHC-42340-69•••-••-27199463279177brandon.tucker20@aol.com--N/ANULLGRP-6253CHOICE-PLUS-PPO
ENR ENR-1302512026-01-31T23:02:03ZWheeler, Madison——1999-01-23UHC1997509•••-••-4049(637) 629-8696madison.wheeler@outlook.com2668 Grand AvenuePhoenixAZ85090··GRP-0606CHOICE-PLUS-PPO
ENRENR-1020622026-09-12T18:08:51ZDavid·XGraham09/12/2003UHC-28829-66•••-••-1516(907) 728-4379david.graham8@gmail.com2470 Lincoln WayPlanoTX75031GRP-8526OPTIONS-PPO
ENRENR-1172962026-07-20T03:44:42ZALICE—FISHER1970-09-28UHC-66476-36•••-••-8087(941) 850-7322—8729 Park PlHouston·Texas77078GRP-7722MEDICARE-ADV-B
43,101 rows, page 189 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:40.326Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty