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-1126912026-04-28T22:17:23ZCampbell, Debra·W—1941-04-21UHC-20616-86•••-••-5386—DEBRA.CAMPBELL3@PROTON.ME2817 Ridge RoadLas VegasNV··89175GRP-8923MEDICARE-ADV-A
ENRENR-1261292026-06-02T03:45:16ZAustinDTorres·1941-04-06UHC-31919-33•••-••-886818057207276austin.torres@outlook.com5369 Bayshore DrTUCSONAZ85767GRP-7007CORE-HMO
ENRENR-1032952026-06-15T10:24:11ZMateoO.Jackson1990-04-07UHC-48696-50•••-••-0564949.471.1696MATEO.JACKSON@PROTON.ME3971 Lincoln WayLas VegasNV89146-7437GRP-6426MEDICARE-ADV-B
ENRENR-1225772026-02-06T13:04:58Zdanielle—peterson·25-01-1949UHC-54962-64•••-••-4849258-484-6687danielle.peterson50@gmail.com1519 Jefferson AvenueMesaAZUNKNOWNGRP-7114NAVIGATE-HMO
ENRENR-1259432026-07-18T05:20:37ZCARLOSPSTEPHENS1956-08-03UHC-00407-90•••-••-8638857-413-9303carlos.stephens@icloud.com1541 Elm St #718·ScottsdaleAZ85225-4837·GRP-6676·MEDICARE-ADV-A
ENRENR-1005892026-03-26T22:34:56ZBRADLEY·UCARROLL02-12-2004··UHC-60033-71•••-••-58197620897BRADLEY.CARROLL67@AOL.COM1790 HIGHLAND AVEColumbusOH43233GRP-0258medicare-adv-a
ENRENR-1425522026-07-12T17:01:18ZpeterD.ford2008-08-16UHC-36877-23•••-••-3618nullpeter.ford@hotmail.com4564 Bayshore DriveColumbusOH43291GRP-9042NAVIGATE-HMO
ENRENR-1116222026-04-09T06:55:21Z MaryR.Moreno··1992-12-28UHC-34202-75•••-••-900219167791678mary.moreno48@proton.me··2055 Cedar LanePhoenixAZ85050GRP-7933SELECT-EPO
ENRENR-1187832026-01-09T05:23:27Z·rayQlawrence1949-08-08UHC-59874-28•••-••-1569-RAYMOND.LAWRENCE@YAHOO.COM9838 CANYON RD·SEATTLE·WA98109-5518GRP-9033OPTIONS-PPO
ENRENR-1322492026-04-25T03:55:56ZwilliamW·rivera1971-03-13UHC-47674-88··NULL·(512) 281-0729william.rivera@yahoo.com3566 WILLOW CTSAN DIEGOCA92191GRP-4792OPTIONS-PPO
ENRENR-1190862026-01-26T14:02:26ZJerryPRichards19-09-1948UHC-20592-54•••-••-14872136522293jerry.richards@aol.com738 Mountain View DrivePhoenixaz85047··GRP-1333OPTIONS-PPO
ENRENR-1118732026-07-07T02:38:29ZVINCENTWHUNT21-07-2005UHC-40298-01•••-••-1414739-575-8266VINCENT.HUNT8@AOL.COM4087 DESERT SKY BLVDLos AngelesCA90085GRP-4832NAVIGATE-HMO
ENRENR-1274472026-04-14T15:25:06ZIsabella··QPerkins1973-04-10UHC7048393•••-••-1047(879) 493-4207—3173 Valley View DrJacksonvilleFLNULL·GRP-9398MEDICARE-ADV-A
ENRENR-1066492026-03-20T13:38:20ZDANIELLEATRAN··06/11/2000UHC-38090-89•••-••-5715284-441-1405danielle.tran27@hotmail.com2769 Valley View DrLos AngelesCA90052GRP-8062SELECT-EPO
ENRENR-1396522026-05-02T17:45:12ZMaria—Phillips·1946-06-06UHC-74762-42UNKNOWN··(922) 522-7859·MARIA.PHILLIPS59@YAHOO.COM4248 Sage CourtSan DiegoCA92177GRP-5543MEDICARE-ADV-A
ENRENR-1412492026-05-05T17:15:10ZMarcusN.Cook·01-01-1964UHC-19387-98•••-••-74624797180487—2570 Forest AvenueSAN DIEGOCA92163GRP-7666NAVIGATE-HMO
ENRENR-1091372026-06-10T22:09:11ZChristain—Walker1970-03-18UHC3909579•••-••-5227—christian.walker8@icloud.com2675 PINE DRTampaFL—GRP-7443SELECT-EPO
ENRENR-1269482026-10-06T12:29:59ZAMY—PARKER27-08-1949UHC-35686-59•••-••-30628375359392amy.parker@hotmail.com6090 CENTRAL AVENUEGlendaleAZ85341GRP-8286OPTIONS-PPO
ENRENR-1344502026-03-17T13:48:30ZSTEPHANIE—WELLS1946-07-10UHC-03130-72•••-••-7356(842) 652-0455STEPHANIE.WELLS@HOTMAIL.COM4291 VALLEY VIEW DRIVEGILBERTAZ85233GRP-9915SELECT-EPO
ENRENR-1339922026-07-06T11:24:35ZArjun—Fernandez1950-04-22UHC-20619-13•••-••-0125+1 901 307 5807arjun.fernandez@yahoo.com3885 PARK PLACE··MinneapolisMN55436··GRP-1628CHOICE-PLUS-PPO··
ENRENR-1286272026-02-04T08:48:58ZAmy—Daniels2007-04-09UHC-65236-29•••-••-9551nullamy.daniels@icloud.com673 Bayshore DriveDenverColorado80282GRP-1647OPTIONS-PPO
ENRENR-1214152026-09-28T01:03:06ZBRANDONR.GARCIA19451204UHC-75549-84•••-••-2246(941) 363-7070—3377 Lincoln WaySan AntonioTX78271GRP-7537CHOICE-PLUS-PPO
ENRENR-1016342026-07-24T12:26:16ZSarah—Morgan2002-03-23UHC-99604-97•••-••-5492N/A—8322 PINE DRIVEFresnoCA93747GRP-0312CORE-HMO
ENRENR-1081442026-09-19T09:44:23Z·ALEXIS—HUNTERSep 9, 1946UHC-63667-27•••-••-6075745-935-1930ALEXIS.HUNTER@PROTON.ME4609 Mesa DrSeattleWA98191·GRP-0686CHOICE-PLUS-PPO
ENRENR-1376262026-09-06T15:30:05ZAnthony—Clark8/14/1986UHC-44110-59•••-••-0478924-651-4107anthony.clark24@proton.me8696 Forest AveSan AntonioTX78208-7452GRP-1323OPTIONS-PPO
ENRENR-1262082026-05-15T15:35:25ZJASON—PERKINS17-10-1952··UHC-39994-05··4063973767·N/A3316 Harbor BoulevardMinneapolisMN55482GRP-9755NAVIGATE-HMO··
ENRENR-1011852026-01-10T18:53:19ZEricGHoffman·nullUHC4473783•••-••-0241758.378.0776eric.hoffman@hotmail.com4427 DESERT SKY BOULEVARDPlanoTX75048GRP-4313MEDICARE-ADV-A
ENRENR-1363962026-01-14T11:39:49ZJORDANEFLORES··07/12/1944UHC-62790-30··•••-••-7634762-503-2040jordan.flores68@icloud.com7559 Hillcrest Road·MinneapolisMinnesota55479GRP-6639··MEDICARE-ADV-B
ENRENR-1304762026-07-01T23:17:49ZCarol—James1953-11-16UHC-44524-66N/A780-764-9703CAROL.JAMES96@YAHOO.COM7355 Main StCharlotteNC28254GRP-3823OPTIONS-PPO
ENRENR-1408322026-07-01T21:07:09ZMarianaCReynolds1965-10-05UHC3173011•••-••-8631931-884-4426mariana.reynolds69@gmail.com9222 SAGE COURTDallasTX75211GRP-0723NAVIGATE-HMO··
ENRENR-1283742026-02-28T06:02:04ZJUSTINX.·BARNESJun 25, 1994UHC-81905-48null—-2955 Elm StreetMesaAZ85228GRP-2607SELECT-EPO
ENRENR-1183182026-09-11T16:41:29ZGARYVJENSEN07/25/1950·UHC5911440•••-••-65343903753976GARY.JENSEN@PROTON.ME·104 OAK STGilbert··AZ85236GRP-4019CORE-HMO
ENRENR-1057582026-04-18T02:39:24ZJaet—Harris19580417UHC-34545-51•••-••-2733886.440.1179JANET.HARRIS@GMAIL.COM8158 Highland AvenueTucsonaz85726GRP-5685CHOICE-PLUS-PPO
ENRENR-1075672026-06-17T04:51:07ZDennis—Harris1939-08-08UHC-83030-05•••-••-6649(456) 577-2543··DENNIS.HARRIS19@GMAIL.COM5864 MAIN STREETSan AntonioTX78262·GRP-9990MEDICARE-ADV-B
ENRENR-1322342026-08-28T05:24:03ZVargas, Andrew——19410624UHC-46683-84•••-••-2772—ANDREW.VARGAS73@AOL.COM8072 MOUNTAIN VIEW DRIVE #982San DiegoCA92104GRP-9189OPTIONS-PPO
ENRENR-1265922026-07-09T12:59:33ZElliott, RaymondR—4/25/1956UHC-34636-62•••-••-60408403759083raymond.elliott22@icloud.com8816 Forest AveDENVERCO80284GRP-2995MEDICARE-ADV-B
ENRENR-1218972026-09-01T20:49:09Z·Catherine—Lee1967-03-15UHC-31793-24•••-••-41472495267catherine.lee80@gmail.com1926 Union StreetChandlerAZ··85249-4131GRP-0424··OPTIONS-PPO
ENRENR-1191462026-01-14T06:18:26ZJOANRHARRISON··1952-04-11UHC-53275-48N/A669-780-2629joan.harrison@aol.com2850 Canyon RdCHARLOTTENC28227GRP-9018MEDICARE-ADV-B
ENRENR-1047602026-05-27T02:45:11ZMichelleJPerkins1962-12-16UHC7220733•••-••-491318898278125NULL7224 Lake View RdTAMPAFL33672GRP-6412CHOICE-PLUS-PPO··
ENRENR-1259852026-02-06T06:46:51ZCHRISTINA··WLEWIS23-08-1955UHC-10969-44•••-••-4644534.859.6742christina.lewis48@gmail.com8303 INDIAN SCHOOL RDChandler···AZNULLGRP-1560OPTIONS-PPO
ENRENR-1119552026-07-02T04:12:11ZRobertT.Yang1997-08-15UHC-85622-65N/A595-940-9130robert.yang5@outlook.com·1172 Oak StreetOrlandoFlorida32866··GRP-6625CORE-HMO
ENRENR-1270422026-06-08T20:38:53Z·joyce—andrews2003-04-05UHC-90507-70•••-••-594514118984468null···4125 Indian School RoadDenverCO80243-1801GRP-1624SELECT-EPO
ENRENR-1402372026-01-30T19:52:12ZZacharySDanils1974-07-23UHC-72083-20•••-••-6388·(803) 324-8380ZACHARY.DANIELS67@AOL.COM5811 APACHE BLVDMinneapolisMN55415GRP-1103MEDICARE-ADV-B
ENRENR-1387392026-08-11T14:36:36ZChristian··Campbell1997-08-12UHC-27250-91•••-••-5729·707-234-8648CHRISTIAN.CAMPBELL48@YAHOO.COM·9801 Lake View RoadMesaAZ85244-8676GRP-2150··SELECT-EPO
ENRENR-1277362026-03-23T23:08:08Z EvelynC.Maldonado1948-06-11·UHC-85610-69•••-••-5008629.740.6729evelyn.maldonado34@icloud.com379 Spring StreetAustinTX78730GRP-5065OPTIONS-PPO
ENRENR-110528 2026-05-18T06:48:37ZAlexis·TOlson1978-08-06·UHC-98786-49•••-••-13117066290341UNKNOWN8688 Bayshore DrOrlando·FL32832GRP-1601CHOICE-PLUS-PPO
ENRENR-1389732026-08-24T03:10:46ZLaura··Torres1978-04-10··UHC-22561-29•••-••-9581432-877-1091NULL5328 Meadow LaneAUSTINTexas78771GRP-1935OPTIONS-PPO
ENRENR-1145502026-08-06T08:36:38ZGABRYELLHARRISON1947-08-24UHC-73884-55NULL-GABRIEL.HARRISON3@GMAIL.COM2663 Meadow Lane··Jacksonville··Florida32291GRP-3976MEDICARE-ADV-A
ENRENR-1199042026-02-02T09:46:16ZJacob—Banks1988-07-10UHC-77320-90•••-••-1442454-848-8407jacob.banks@yahoo.com5849 Cedar LaneMesaArizona85267GRP-9933CORE-HMO
ENRENR-123105 2026-01-14T08:57:50ZJOSESRYAN06/08/48UHC-19407-98•••-••-0423·3531374null··5976 MARKET STREETGILBERTAZ85281GRP-4858CHOICE-PLUS-PPO
43,101 rows, page 179 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.314Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty