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-1145302026-05-03T13:10:15ZAndrea—·Li1954-10-09UHC-66640-67—4199503324andrea.li@outlook.com4255 Maple Ave·SCOTTSDALEAZ85274··GRP-0791CORE-HMO
ENRENR-1004052026-08-22T01:09:17ZHIROSHISDIXONJul 11, 1948UHC-60496-43•••-••-9401758-694-0131hiroshi.dixon@proton.me3935 Bayshore DrSan DiegoCA·92113GRP-5490SELECT-EPO
ENRENR-1267942026-08-16T08:37:44ZGEORGE—WEAVER1961-03-13UHC-08783-42··•••-••-56752528982810GEORGE.WEAVER11@AOL.COM6059 Bayshore DriveSan AntonioTX78243GRP-6787navigate-hmo
ENRENR-1002672026-07-14T07:31:21ZKATHRYNJKELLY1955-01-24uhc-61592-30—658-651-3640KATHRYN.KELLY@GMAIL.COM6310 CEDAR LNMesaArizona85255GRP-7902options-ppo
ENRENR-1318122026-02-23T16:41:44ZTONYI·CARTER1967-05-05UHC2624520•••-••-7332910-989-3969anthony.carter@yahoo.com8844 Harbor BlvdMinneapolismn55483GRP-6282MEDICARE-ADV-B
ENRENR-1181792026-09-01T04:11:23ZJUSTINA.JOHNSON2004-07-03UHC-07622-05•••-••-8029665-622-8532justin.johnson28@gmail.com4490 Palm Dr·TempeAZ85293GRP-7038CORE-HMO
ENRENR-1139362026-10-07T18:24:13ZElizabethDFord1994-09-24UHC-15207-07-(957) 251-7586elizabeth.ford@aol.com7411 Hillcrest RoadTucson··AZ85775GRP-1368OPTIONS-PPO
ENRENR-1421252026-01-25T02:36:49Z·Amber····Murphy3/4/1948UHC-50156-12UNKNOWN703-201-1060AMBER.MURPHY@HOTMAIL.COM7183 Apache BoulevardATLANTAGA30364GRP-0535OPTIONS-PPO
ENRENR-1124962026-04-30T21:53:19ZJustin—Russell26-06-1972··UHC-18051-11····15302051450JUSTIN.RUSSELL68@OUTLOOK.COM2618 CHURCH STREETNASHVILLETN37221GRP-3817OPTIONS-PPO
ENRENR-1132502026-07-31T21:12:42ZGeraldWMeyer1943-09-27UHC-45403-71—·500.472.0980null301 HILLCREST RDJacksonvilleFL32203GRP-8790··SELECT-EPO
ENRENR-1303292026-09-19T18:11:55ZNathan—Watkins1974-08-06UHC-86219-04•••-••-5895798-324-3819nathan.watkins@outlook.com2794 Market StMinneapolisMN55461GRP-2760CHOICE-PLUS-PPO
ENRENR-1375692026-06-04T00:54:12ZKATHERINE—PADILA08-06-1943UHC-78445-75•••-••-6803(941) 677-4613katherine.padilla@gmail.com4199 RIDGE ROADSeattleWA·98116GRP-5954MEDICARE-ADV-B
ENRENR-1286052026-09-06T19:23:03ZKEVINTFRANKLIN2005-10-11UHC6067540•••-••-7320(753) 296-8146kevin.franklin@yahoo.com9126 CENTRAL AVEEden PrairieMN55388GRP-4688MEDICARE-ADV-A
ENRENR-1195202026-04-03T12:26:16ZGonzalez, DeborahI—1945-11-14·UHC-20343-70•••-••-8286(888) 556-3042NULL—UNKNOWNN/A—GRP-9960MEDICARE-ADV-B
ENRENR-1044542026-01-07T03:14:03ZJessicaG··Brns20-05-2007UHC-28147-73··486-363-3735··null8189 Sage CourtSeattleWA-GRP-8822OPTIONS-PPO
ENRENR-1190052026-02-06T12:03:44ZWillie··—Barnes1986-01-11UHC7205281•••-••-1241475-305-2583willie.barnes6@yahoo.com3387 Cedar LaneNASHVILLETN37265GRP-7563SELECT-EPO··
ENRENR-1253912026-01-06T13:45:28ZMelissaCMcDonald2001-06-20·UHC-49869-26•••-••-4645461-932-7306melissa.mcdonald@aol.com4944 Pine Dr·Los AngelesCA90076·GRP-4429NAVIGATE-HMO··
ENRENR-1113992026-06-27T17:24:33ZAARONB.DUNCAN5/10/1958UHC-17184-61•••-••-3693901.205.9601N/A7780 Grand Avenue··ATLANTAGA30325GRP-9074·CHOICE-PLUS-PPO
ENRENR-1128312026-03-07T14:33:27Zaaron—·lee1997-12-14UHC-61672-34•••-••-36776599303·AARON.LEE@ICLOUD.COM9253 Spring StreetTucsonAZ85748GRP-7546SELECT-EPO
ENRENR-1269202026-04-26T11:17:05ZLSA—HOWARD10-05-1998UHC-91518-18•••-••-4268651.304.6411··NULL7671 Spring StreetHoustonTX77003GRP-9853MEDICARE-ADV-B··
ENRENR-1169402026-07-11T15:07:31ZMarcusVGibson06/28/06UHC-21771-30•••-••-4760(488) 546-4662marcus.gibson62@hotmail.com8845 Market StSeattleWA98105-6946GRP-6573OPTIONS-PPO
ENRENR-1255872026-04-14T00:06:50ZLuna, Donna——02-02-1994UNKNOWNN/A963.989.3508DONNA.LUNA9@HOTMAIL.COM4405 WILLOW CT Apt 19Eden PrairieMN55333GRP-1233·NAVIGATE-HMO
ENRENR-1047492026-08-18T01:46:04ZSantiago—Ferguson1959-12-01UHC-37057-84—810-556-3227SANTIAGO.FERGUSON@OUTLOOK.COM6259 Pine DrSeattleWA98197-7293GRP-8461CORE-HMO
ENRENR-1110482026-07-10T05:16:30ZScott, AishaH—·19500905UHC-97838-17•••-••-6786978.908.1586AISHA.SCOTT@OUTLOOK.COM8705 Ridge Rd··OrlandoFL··32885GRP-5234CORE-HMO
ENRENR-1363462026-04-24T13:08:58ZRiley, DebraU.—1972-01-01UHC-50659-18•••-••-1067(448) 373-7672DEBRA.RILEY@GMAIL.COM6684 BROADWAY··HoustonTX·77005GRP-3835CHOICE-PLUS-PPO
ENRENR-1041632026-01-19T18:09:16Z·Henry—Bishop1968-11-06UHC-63852-39•••-••-5100nullhenry.bishop@aol.com1886 CHURCH ST··AtlantaGA30311GRP-0675OPTIONS-PPO
ENRENR-1337492026-01-18T22:24:14ZDeborahT.Thomas··2006-10-03UHC-85752-93•••-••-6863(762) 447-8605deborah.thomas46@yahoo.com258 Canyon RoadTampaFlorida33605GRP-3551NAVIGATE-HMO
ENRENR-1185542026-04-13T14:31:45ZDEISE H—PETERS19890107UHC7901766•••-••-0362232-264-9701DENISE.PETERS22@AOL.COM7113 Park PlNashvilleTN37252GRP-1363·SELECT-EPO
ENRENR-1045532026-07-21T01:30:06ZChrristianVMunoz02/12/92UHC-66109-89··•••-••-6426N/A—1973 Cedar LnSacramento··CA95894-0561GRP-1118·SELECT-EPO
ENRENR-1345182026-07-20T14:09:04ZJoyceAPerez1977-06-24UHC-21788-68•••-••-0750+1 574 843 5293joyce.perez61@proton.me9017 Washington StreetDallasTX75245GRP-1787MEDICARE-ADV-A
ENRENR-1075922026-09-16T01:43:41ZAlexander, AnaW—19980314UHC-52420-37•••-••-6377(781) 550-8348ana.alexander92@hotmail.com9045 Spring StreetAustinTX78706GRP-0565NAVIGATE-HMO
ENRENR-1095452026-03-23T18:12:49Z Kim—White07/03/44UHC-64583-03•••-••-2165+1 398 854 2727KIMBERLY.WHITE95@AOL.COM6560 Camelback Rd Apt 10San AntonioTX78255GRP-5058MEDICARE-ADV-B
ENRENR-117560 2026-04-12T07:09:57ZPatrickV.Jordan1964-07-10UHC2902352NULL(542) 353-0470—9666 BroadwayGlendaleAZ85340GRP-0905MEDICARE-ADV-B
ENRENR-1138352026-09-23T07:37:20ZWelch, SofiaP—2005-09-24UHC-60104-27•••-••-6560N/Anull9888 MAIN STREETEden PrairieMinnesota55330GRP-0266NAVIGATE-HMO··
ENRENR-1151202026-09-18T10:56:48ZYang, Santiago C.——12/24/2003UHC-56718-75•••-••-00417315560259santiago.yang6@hotmail.com8600 SUNSET BOULEVARDSan DiegoCA92176GRP-1301MEDICARE-ADV-B··
ENRENR-1130012026-05-04T15:28:50ZBryan—Williams2007-08-09··UHC-08951-32•••-••-1759219.836.5668bryan.williams@icloud.com3380 Park Place #671TempeAZ85201-0490··GRP-4659MEDICARE-ADV-A
ENRENR-1380642026-03-08T21:33:25ZRaymondW.MasonJan 9, 1997UHC0255895•••-••-04614969159365raymond.mason@yahoo.com··2597 MOUNTAIN VIEW DRIVEAustinTexas78747GRP-7595OPTIONS-PPO
ENRENR-1406312026-09-08T09:58:02ZMateoR.··Harvey19691225·UHC-78172-12•••-••-5967(570) 791-9171mateo.harvey57@gmail.com8811 Mountain View Drive·Las VegasNV89180-8554GRP-4122NAVIGATE-HMO
ENRENR-1150272026-04-07T11:24:53ZMARCW.VARGAS1963-10-09UHC-88195-06•••-••-98896507277297MARCUS.VARGAS@AOL.COM6355 Indian School RdSAN DIEGOCA92126GRP-9179CHOICE-PLUS-PPO
ENRENR-1301212026-02-01T18:39:51ZPRIYA—TRAN1999-02-19UHC-29446-44•••-••-96566343265866priya.tran27@icloud.com7535 Main StChandlerAZ85283GRP-5448CORE-HMO
ENR ENR-1210522026-05-25T09:10:00ZOrtiz, Billy··R.—10/20/2006UHC7808515•••-••-678517948078515NULL3156 Bayshore DrEden PrairieMN55357··GRP-3841SELECT-EPO
ENRENR-115233 2026-08-13T12:16:34ZJerryBDay07/17/1959UHC-84674-73•••-••-3998223.327.0204jerry.day9@aol.com5139 Palm DrMiamiFL33156GRP-1033CORE-HMO
ENRENR-1429782026-01-26T21:50:48ZThomas, MadisonU—1945-05-25UHC-45958-44•••-••-0713(385) 386-3289madison.thomas@aol.com9336 Maple Ave Apt 27MinneapolisMN55440GRP-6656··SELECT-EPO
ENRENR-1138002026-06-29T19:03:04ZJANET—ELLIOTT1976-09-18UHC-44835-28•••-••-5618(349) 418-5569janet.elliott@proton.me5041 Mountain View DrGilbertAZ85216GRP-0238select-epo
ENRENR-1390092026-07-18T05:47:26ZSTEVENB.WALSHOct 13, 1970UHC-26249-94•••-••-8921N/ANULL9161 Main StOrlandoFL—GRP-2773MEDICARE-ADV-B
ENRENR-1118562026-09-14T04:21:39ZCheryl—Dunn1987-12-14UHC-78434-31•••-••-6758275-651-7999CHERYL.DUNN23@ICLOUD.COM6313 HIGHLAND AVEEden PrairieMN55363GRP-2336SELECT-EPO
ENRENR-1041692026-07-31T23:03:35ZnatalieG.·larson19980222UHC-23457-95•••-••-7481(681) 598-4181NATALIE.LARSON@HOTMAIL.COM1153 Washington StPlanoTX75013GRP-7249MEDICARE-ADV-B··
ENRENR-1250842026-02-10T15:19:49ZLynch, GeraldY.—1951-07-10UHC-68982-25•••-••-7499(982) 416-0671··N/A4618 Main StSacramentoCA95885··GRP-3134MEDICARE-ADV-A
ENRENR-116971 2026-08-19T20:57:37ZDonnaSEdwards1999-01-16UHC-67089-11•••-••-63488245361463—6844 Union Street Apt 16Austin··TX·78737GRP-8220MEDICARE-ADV-A
ENRENR-1060682026-03-05T15:29:32ZHeather—Cox1967-10-08NULL•••-••-602918907093599—7145 Apache BoulevardDallasTX75253GRP-7236NAVIGATE-HMO
43,101 rows, page 250 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.635Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty