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-1259752026-07-08T22:24:43Z DONNA—WONGnullUHC-05699-88•••-••-5419·17386614629—7147 Mountain View DrGlendale··az85396GRP-6364CORE-HMO
ENRENR-1101972026-07-15T18:14:24ZHeather—Hansen1938-08-09UHC-02209-49•••-••-2891(884) 956-6802heather.hansen49@yahoo.com———nullGRP-5315MEDICARE-ADV-B
ENRENR-1259402026-03-17T09:43:43ZRalph····Fisher1980-10-06UHC0367705··—+1 474 756 0716ralph.fisher@hotmail.com4339 Elm StreetCharlotteNC28268GRP-0676MEDICARE-ADV-A
ENRENR-1053842026-04-11T05:29:36ZNANCY······PALMER11-12-1975UHC-18015-69•••-••-82818348821792NANCY.PALMER@HOTMAIL.COM4573 ELM STREETDallasTX—GRP-3787SELECT-EPO
ENRENR-1092842026-08-27T01:35:04ZAhmed··TCastillo19930518··UHC-05258-96null—ahmed.castillo@gmail.com8177 Maple Ave·SEATTLEWA···98103GRP-1586CHOICE-PLUS-PPO
ENRENR-1318372026-02-21T20:28:26ZJULIE—ALEXANDER22-01-1996UHC-03560-02•••-••-1377(798) 355-4718julie.alexander@hotmail.com6091 HIGHLAND AVEMiamiFL33103GRP-3753CHOICE-PLUS-PPO
ENRENR-1042222026-01-20T13:23:04ZDOROTHY—PORTER02/02/93UHC-87180-08•••-••-0550545-745-0390dorothy.porter@yahoo.com··1891 Park PlEden PrairieMN55393GRP-7145MEDICARE-ADV-A
ENRENR-1132672026-02-10T23:44:19ZMARGARETA.·MCDONALD1956-09-28UHC9174989•••-••-44623995052188·margaret.mcdonald82@outlook.com2489 Forest AveSacramentoCA95843-6321GRP-7710NAVIGATE-HMO
ENRENR-1118712026-03-16T16:05:13Z Debra—Bailey1956-10-06·UHC-28481-12•••-••-43386614439082debra.bailey71@proton.me817 INDIAN SCHOOL ROADTAMPAFL33698GRP-4030·CHOICE-PLUS-PPO
ENRENR-1018022026-01-30T09:10:03ZChristine··Ramos1939-07-04UHC-62694-69•••-••-57614657126832christine.ramos@proton.me5274 Valley View DrAtlantaGA30387GRP-3634CHOICE-PLUS-PPO
ENRENR-1333292026-09-08T12:15:36ZDianePStephens2008-09-28uhc-70379-01•••-••-95303739888509—·4615 Desert Sky BlvdScottsdaleAZ85244GRP-6884NAVIGATE-HMO
ENRENR-1180682026-08-06T22:35:13ZMadison—Jenkins1983-01-05UHC-28890-43•••-••-9615443-474-3157madison.jenkins78@proton.me··1615 Church St··SAN DIEGOca92128GRP-9272··MEDICARE-ADV-B
ENRENR-139836 2026-01-24T03:56:21ZHiroshi—Tran1986-02-04UHC-69597-53•••-••-49102873701322null5710 JEFFERSON AVETEMPEAZ85226GRP-9926CORE-HMO
ENRENR-1330942026-07-13T11:32:39ZRoger—Carroll1989-12-15UHC0252879•••-••-0269(479) 308-5509roger.carroll16@hotmail.com7101 BroadwayPhoenixAZ85039GRP-9164CORE-HMO
ENRENR-1131652026-10-16T17:53:42ZNOAHIREID1965-08-22UHC-33195-95•••-••-2724—noah.reid21@icloud.com360 Sage CourtCharlotteNC28208GRP-7370MEDICARE-ADV-A
ENRENR-1404442026-07-09T11:18:16ZZacharyZRiley2000-09-17UHC-04990-86··•••-••-6864(518) 352-8692—428 Park PlColumbusOH··43285GRP-6477··CHOICE-PLUS-PPO
ENRENR-122712 2026-07-05T02:20:41ZSUSAN—TORRES1966-10-26UHC-91325-54•••-••-30128694894317··susan.torres45@hotmail.com5449 Hillcrest RdAtlantaGA30319GRP-6610SELECT-EPO
ENRENR-1205012026-05-31T07:03:58ZahmedEroberts19690313UHC-17205-50•••-••-4520·-ahmed.roberts@aol.com5808 Sage CourtSeattleWA98185GRP-5055NAVIGATE-HMO
ENRENR-1076082026-07-12T19:19:57ZJordan, PamelaU—1982-06-16UHC-28186-78·N/A865-690-7925··pamela.jordan92@icloud.com···2690 HIGHLAND AVEPhoenixAZ85048GRP-8050··MEDICARE-ADV-B
ENRENR-104214 2026-03-19T22:55:58ZJACKHFISHER20-07-1998UHC-01029-95•••-••-9978—·N/A2171 Mountain View Drive·CharlotteNC28288-3343GRP-7442SELECT-EPO
ENRENR-1120102026-05-27T20:04:03Z·KIMBERLY··JORDAN1939-02-15UHC-22422-34•••-••-9257(327) 697-7774-8240 Mountain View DrivePlanoTX75079-8761GRP-0978··NAVIGATE-HMO
ENRENR-1114082026-10-08T04:37:01ZGluria··—Clark1991-04-21··UHC-39156-96•••-••-5506947-748-9153—9679 Mesa DrSan DiegoCA92144GRP-9483NAVIGATE-HMO
ENRENR-1058382026-08-18T02:32:24ZSandraAWashington2/22/1954UHC-11593-76•••-••-2053(389) 538-5402—9381 Canyon RoadMINNEAPOLISMN55486GRP-8883MEDICARE-ADV-B
ENRENR-1175062026-06-30T00:40:03ZSAMANTHA—FOWLER1956-09-06UHC-87948-44•••-••-3986293-309-5486samantha.fowler@gmail.com—N/AUNKNOWNNULLGRP-7742MEDICARE-ADV-B
ENRENR-1135892026-04-18T03:55:13ZDebraG.Green2007-10-20UHC-25289-02•••-••-5139(359) 913-3461debra.green@yahoo.com4502 Spring StMiamiFL33199-0906GRP-8166MEDICARE-ADV-B
ENRENR-1358052026-01-04T02:02:03ZPATRICIAO.DUNCAN11/7/2004UHC-06336-29•••-••-6903+1 588 411 9837PATRICIA.DUNCAN@OUTLOOK.COM186 Main StreetMesaAZ85296GRP-3195options-ppo
ENRENR-1061482026-05-27T10:41:23ZRomero, PamelaE—1940-25-07UHC-33943-25•••-••-2058(689) 795-5953pamela.romero@outlook.com647 Lincoln WayChandlerAZ85252GRP-2069MEDICARE-ADV-B
ENRENR-1253242026-05-02T05:26:48ZMichelle—Jenkins··1979-10-13UHC-18507-38•••-••-7222+1 366 230 4887N/A·3941 Maple AveScottsdaleAZ85231GRP-4193OPTIONS-PPO
ENRENR-1235232026-09-01T18:21:34ZNICHOLAS—PHILLIPS·1957-03-18UHC-84262-52•••-••-6317235-516-5565nicholas.phillips4@aol.com5733 Oak StChandlerAZ85219GRP-8247CORE-HMO
ENRENR-1172392026-06-17T21:28:01ZSARAH·SHANSEN1960-08-17··uhc-44827-08•••-••-6459N/Asarah.hansen84@yahoo.com4346 Cedar LaneLAS VEGASNV89184GRP-9472MEDICARE-ADV-A
ENRENR-1054662026-02-23T10:09:11ZalexisZdavis··1952-08-28UHC-98113-37•••-••-8399283-613-2995ALEXIS.DAVIS50@AOL.COM3470 Bayshore DriveLos Angeles··CA··—GRP-0845OPTIONS-PPO
ENRENR-1172802026-03-19T11:37:45ZBurns, JoeD—1999-02-22UHC-36384-52•••-••-6362481-942-6737··joe.burns5@gmail.com4862 Central Avenue··JacksonvilleFL··32251GRP-5472SELECT-EPO
ENRENR-1073782026-08-11T19:21:32ZAbby—Arnold1980-05-19UHC7986361•••-••-0454261-333-5475abigail.arnold43@hotmail.com4960 Jefferson Avenue Apt 9Gilbertaz85232GRP-6967·OPTIONS-PPO
ENRENR-1419672026-10-10T17:03:33ZRAYMOND—·MARSHALL2000-01-09UHC-03201-32•••-••-83445066502raymond.marshall@aol.com6050 Central AvenueSacramentoCA95876GRP-7882CORE-HMO
ENRENR-1252462026-06-13T15:23:50Z lauraM··price··1977-09-21UHC-86279-58•••-••-4441·(508) 865-7931laura.price67@yahoo.com6260 VALLEY VIEW DRIVE #308·SacramentoCA95827GRP-1864NAVIGATE-HMO··
ENRENR-1347292026-04-17T11:06:53ZJanice··—Elliott11/21/78UHC-88834-73•••-••-6179798-943-9023janice.elliott7@proton.me7504 Sage Ct Apt 39San AntonioTX78291GRP-2069··OPTIONS-PPO
ENR ENR-1189482026-02-23T17:18:30ZRaymondTWegner19820517UHC-58396-99N/A(941) 226-5879raymond.wagner13@gmail.com3582 OCEAN AVEDenverCO80228GRP-5332CHOICE-PLUS-PPO··
ENRENR-1412832026-05-23T10:54:30ZHendersonA.Emily1967-08-08UHC-81453-36•••-••-7267859.803.5084emily.henderson89@yahoo.com3328 CHURCH STSan Diego··CA—GRP-7932NAVIGATE-HMO
ENRENR-1205212026-01-18T09:54:36ZBrown, TimothyB.—1962-05-07UHC-81996-24•••-••-2506NULLN/A··2918 Highland AveCharlotteNC28209GRP-2900OPTIONS-PPO
ENRENR-1294132026-07-30T10:30:57ZEmmaB.Silva19770611UHC-22819-36•••-••-2395(361) 325-8723emma.silva@outlook.com7932 Grand AveTucsonAZ85788GRP-8265MEDICARE-ADV-A
ENRENR-1164302026-02-07T17:52:04Zsamuel C—kelley··7/10/1955UHC-55006-25•••-••-7289(704) 611-0385SAMUEL.KELLEY@HOTMAIL.COM6204 Union StreetOrlandoFL32816··GRP-6834NAVIGATE-HMO
ENR ENR-1354302026-04-07T00:20:43ZARTHUR—DAVIS1997-09-01UHC-18956-17··•••-••-7003592-297-9448ARTHUR.DAVIS@HOTMAIL.COM·1241 Jefferson AvenueChandlerAZ85272GRP-2779··MEDICARE-ADV-B
ENRENR-1009652026-10-05T11:34:57ZDOUGLASMMORALES1952-08-19UHC-93164-60··-··(917) 245-4353douglas.morales@proton.me··2023 Maple AveGilbertAZ85226GRP-9405··MEDICARE-ADV-B
ENR ENR-1190592026-07-26T03:53:43ZEddieFFord1941-12-17UHC-01186-58N/A(477) 796-8781edward.ford@proton.me8722 Central AvenueGilbertAZ-GRP-0429MEDICARE-ADV-B
ENRENR-1284632026-09-17T11:50:46Z RANDYILYNCHSep 27, 1996UHC-19138-60•••-••-0270(878) 767-9973randy.lynch16@outlook.com·269 Canyon RdEden PrairieMN55336GRP-1419OPTIONS-PPO
ENRENR-1167462026-03-23T20:56:47ZNicole—Weber··01-04-2008·UHC-33244-23•••-••-0028226-300-3086nicole.weber@gmail.com8660 Broadway Apt 6GlendaleAZ85354GRP-5351NAVIGATE-HMO
ENRENR-1192392026-04-13T19:20:47Zlus—jenkins1958-10-19UHC-57726-75•••-••-7137NULLLUIS.JENKINS@PROTON.ME7476 Ridge RoadPhoenixAZ-GRP-1822OPTIONS-PPO
ENRENR-1367462026-10-04T22:42:36Z·Melissa—Gutierrez·05/03/1960UHC-41808-13•••-••-9041237-355-4865melissa.gutierrez46@hotmail.com9384 BroadwaySAN DIEGOCA92157GRP-1419SELECT-EPO
ENRENR-1043652026-10-03T18:22:02ZJohnRPalmer07/24/1951UHC-49938-60•••-••-0543(919) 789-8404john.palmer@hotmail.com2782 Park PlaceOrlandoFL32882GRP-6475CHOICE-PLUS-PPO
ENRENR-126018 2026-01-11T17:21:17ZGeorgeE.James1951-11-26UHC-68020-52•••-••-85163958203155george.james@icloud.com4063 Willow CourtColumbusOH43203GRP-3855CORE-HMO
43,101 rows, page 177 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.309Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty