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-1407632026-03-24T19:39:45ZOrtiz, RogerF.—12/15/1995UHC-75248-64•••-••-9807450-455-8871ROGER.ORTIZ@ICLOUD.COM4346 Lincoln WayHoustonTX77035GRP-6586NAVIGATE-HMO
ENRENR-1180182026-01-25T21:44:29ZGLORIA—RAYJun 2, 1982UHC-76213-90•••-••-2998(823) 277-3658gloria.ray@yahoo.com64 Central AveTUCSONAZ85712GRP-6219MEDICARE-ADV-A
ENRENR-1036552026-02-07T14:04:31ZCastroD.Laura1938-03-14UHC-77112-55——null5820 RIDGE RDFRESNOCA93740-6169GRP-9807MEDICARE-ADV-A
ENRENR-1360092026-02-05T13:23:22ZAHMEDNGRANT1988-04-16UHC-81442-49•••-••-6691·230-755-8400—8056 SAGE CT Apt 20NashvilleTN37279GRP-4088CHOICE-PLUS-PPO
ENRENR-1015092026-08-31T17:45:16ZKaran—Baker06/10/51·UHC-03116-01•••-••-0415478.419.3990karen.baker55@aol.com3263 HILLCREST ROADJacksonvilleFL32238GRP-2439·NAVIGATE-HMO
ENRENR-1429722026-01-11T06:42:17Z·AnaMAdams1999-09-22UHC-88260-03•••-••-96172344895727··N/A8157 Harbor BlvdORLANDOFL32887GRP-6704NAVIGATE-HMO
ENRENR-1093262026-03-14T23:20:54ZChristine—Olson2008-04-26UHC-45936-68•••-••-03007777389373christine.olson23@yahoo.com8172 Main StreetEden PrairieMN55381GRP-6658OPTIONS-PPO
ENRENR-1224522026-06-13T21:49:15ZYUKI—RIOS1979-11-21UHC-04431-12•••-••-9184+1 542 579 7223yuki.rios62@proton.me2827 Central AveORLANDOFL32883GRP-3095··MEDICARE-ADV-A
ENRENR-1409362026-02-24T05:18:29ZNANCYONGUYEN·1946-06-01UHC-55395-55•••-••-0077659-763-6293NULL4782 Pine DrCharlotteNC28206·GRP-7089MEDICARE-ADV-B
ENRENR-1377592026-10-09T15:15:59ZAhmedIStephens2002-05-21UHC-96212-94•••-••-560113982448873ahmed.stephens@gmail.com7204 Indian School RdMiamiFlorida33173GRP-2269·SELECT-EPO
ENRENR-1329392026-05-26T14:39:42ZEmma—Davis1971-03-17UHC-44979-84•••-••-08224045502751-·3791 MEADOW LANELas VegasNV89168·GRP-8118CHOICE-PLUS-PPO
ENRENR-1024122026-04-29T07:11:23ZPaul—Lopez19660501·UHC-40853-63—3739226087—4018 RIDGE ROADScottsdaleAZ85290GRP-2625OPTIONS-PPO
ENRENR-1381692026-07-14T09:32:51ZMaryN.··Foster1951-04-20··UHC-86800-69•••-••-4397(206) 805-3512mary.foster92@gmail.com4689 CHURCH STGlendaleAZ··85324GRP-0669CHOICE-PLUS-PPO
ENRENR-1299092026-02-04T08:54:18ZPorter, Joyce——1963-11-26UHC-48696-87•••-••-6285——7574 Jefferson AvenueDallasTX75216-6281GRP-3695MEDICARE-ADV-B
ENRENR-1282132026-09-29T11:09:23ZCastillo, JesseP.—1947-02-15UHC6458282•••-••-9415950-929-3843JESSE.CASTILLO59@OUTLOOK.COM1838 Palm DrPlanotx75086GRP-4491NAVIGATE-HMO
ENRENR-1190352026-05-19T15:25:40ZluciaCrussell01/23/69UHC1398743•••-••-587313372614470lucia.russell53@aol.com8135 Jefferson AvenueFresnoCA93767GRP-1118SELECT-EPO
ENRENR-1272632026-03-15T02:42:13Z REBECCA··HEENRY02-05-1995··UHC-09021-94•••-••-4685967-967-0897REBECCA.HENRY@PROTON.ME8916 Spring StreetLos AngelesCA90017·GRP-0626MEDICARE-ADV-B
ENRENR-1042052026-01-24T08:29:00ZRichard—Henry1978-06-16UHC-39882-07•••-••-5127848-295-9786RICHARD.HENRY@YAHOO.COM7513 SPRING STAtlantaGA30352GRP-1237medicare-adv-a
ENRENR-1053822026-09-01T04:04:03ZCHRISTOPHERGWILLIAMSON2002-02-28UHC-02046-10•••-••-68015136237039·christopher.williamson89@hotmail.com7615 DESERT SKY BLVDCHARLOTTENC28279·GRP-6165NAVIGATE-HMO
ENRENR-1408122026-02-02T07:57:15Zanna—·hudson1951-03-14UHC-78384-29··—(714) 798-6255anna.hudson81@proton.me9254 Highland Ave··TUCSONArizona85727GRP-8608CHOICE-PLUS-PPO
ENRENR-1136742026-04-01T00:39:55ZJames, Chris——1949-11-18··UHC-33225-10-776-981-8609CHRISTINE.JAMES@PROTON.MENULL-—-GRP-7239MEDICARE-ADV-A
ENRENR-1230112026-06-23T17:27:38ZTYLERDHENRY1986-08-10UHC-53217-87null(359) 371-8694TYLER.HENRY@YAHOO.COM···3742 PALM DRIVENASHVILLE·TN37277GRP-2216MEDICARE-ADV-B
ENRENR-1147162026-01-29T03:55:59ZbrandonMbennett1950-02-23··UHC-33676-78•••-••-9878673-220-8340brandon.bennett35@aol.com3332 Bayshore DriveSacramentoCA95871·GRP-6214NAVIGATE-HMO
ENRENR-1414102026-03-01T22:15:51ZMasonQ.Stone1983-10-10UHC-99380-45•••-••-6524+1 472 674 8703MASON.STONE@HOTMAIL.COM5591 Park PlGlendaleaz85392GRP-5739MEDICARE-ADV-B
ENRENR-1422212026-06-25T19:19:51ZHIROSHIHFOSTER1940-02-21UHC-49240-89•••-••-5304(700) 682-0143—8090 Main StScottsdaleAZ85252GRP-5861NAVIGATE-HMO
ENRENR-1217812026-09-22T15:00:14ZheryG.wright1961-10-25UHC-33871-08•••-••-712414256908677NULL6857 Spring StCharlotteNC28283GRP-1014CORE-HMO
ENRENR-1169802026-01-25T23:10:39ZSharonLCooper1985-01-14—•••-••-65058854771235·SHARON.COOPER47@AOL.COM2375 Lincoln WayFresnoCA—GRP-0509CHOICE-PLUS-PPO
ENRENR-1406892026-04-30T10:50:04ZArthurAMarshall1983-04-25UHC-12148-09•••-••-0492+1 558 225 5662arthur.marshall@hotmail.com2973 Forest Avenue··TAMPAFL33616GRP-5105SELECT-EPO
ENRENR-1208002026-06-19T16:39:01ZHELEN·A.FOX2007-11-02UHC-23893-43null(606) 988-4288··N/A9156 Church StJACKSONVILLEFL32223-4230GRP-2467CORE-HMO
ENRENR-1380052026-09-05T02:16:36ZJesseC.Alexander1976-06-28·UHC-79136-15•••-••-5651692-553-7029jesse.alexander83@proton.me875 Central AveLOS ANGELESCA90071GRP-0247··CHOICE-PLUS-PPO
ENRENR-1348542026-05-10T21:58:29ZJeremy—Alexander2/12/1938UHC-93768-64•••-••-5043——8476 HILLCREST RD··MesaAZ85290··GRP-6884MEDICARE-ADV-B
ENR ENR-1030572026-08-28T22:07:55ZHEATHERGBOYD10/26/54UHC-21223-18•••-••-7165(951) 995-7781heather.boyd@hotmail.com4167 RIDGE ROADMINNEAPOLISMN55492GRP-4502MEDICARE-ADV-A
ENRENR-1359072026-03-05T06:06:32ZMary—Mitchell2004-09-09UHC-84412-57•••-••-20312293845925mary.mitchell11@yahoo.com2269 Maple AveDALLASTX75280GRP-5645MEDICARE-ADV-B
ENRENR-1260862026-07-21T02:37:44ZHunt—Noah2004-06-14UHC-24276-37null4369389818noah.hunt@gmail.com3532 HIGHLAND AVESeattleWA—GRP-7864OPTIONS-PPO
ENRENR-1102342026-04-12T01:43:31ZKaren—Jones··16971102UHC-56622-38·UNKNOWN7678303974karen.jones@yahoo.com9265 River RdHouston·TX77034·GRP-2737MEDICARE-ADV-A
ENRENR-131756 2026-02-02T15:38:26ZBrenda—Carpenter1953-05-23UHC-50968-55•••-••-4793(335) 443-2906NULL4125 CANYON RD #218MinneapolisMN55419GRP-4824MEDICARE-ADV-B
ENRENR-1136172026-06-09T15:32:44ZTriciaFHayes1993-05-27UHC8406091•••-••-8047619-410-0159patricia.hayes43@yahoo.com6331 Hillcrest RoadSacramentoCA95813GRP-7870OPTIONS-PPO
ENRENR-1162712026-02-20T12:06:25ZMadison—Webb1957-09-20··UHC-00101-50•••-••-1196·2077875107madison.webb47@hotmail.com2888 MARKET STREETTucsonAZ85716GRP-8607MEDICARE-ADV-B
ENRENR-1216182026-01-01T00:30:02ZHiroshiF.Roberts1959-02-21·UHC-02113-02—783-613-9730NULL6214 Broadway #518GlendaleAZ·NULLGRP-5968OPTIONS-PPO
ENRENR-1227682026-02-21T23:40:39Z WayneJMatthews1953-07-06UHC-13783-22•••-••-59686537451332N/A8347 MARKET STREET #903ScottsdaleArizona···85295GRP-7027navigate-hmo
ENRENR-1406662026-05-14T15:10:56ZFrankX.Wright1955-11-03UHC-79600-13•••-••-9701964-623-8772frank.wright49@icloud.com9434 OCEAN AVENUE Apt 4HoustonTX77031·GRP-2737MEDICARE-ADV-A
ENRENR-1423512026-06-14T15:03:27ZThompson, JamesR—1980-11-03UHC3591401•••-••-7493840-796-1407james.thompson@outlook.com6516 Park PlSacramentoCA95829-6588GRP-9706MEDICARE-ADV-B
ENR ENR-1291932026-04-22T03:35:09ZROGER·X.PETARS5/9/1968UHC-90693-56•••-••-629019636620056roger.peters77@yahoo.com7864 Lincoln WayScottsdaleAZ85272GRP-2464MEDICARE-ADV-B··
ENRENR-1014532026-08-29T20:23:12Zkeith·Haustin1953-12-13UHC-93089-47•••-••-0662+1 712 488 1562keith.austin71@gmail.com3449 Elm StMINNEAPOLISMN55466GRP-4141MEDICARE-ADV-A
ENRENR-1370922026-03-30T06:35:15ZROSS—BEVERLYJul 26, 1960··UHC1056444•••-••-6718339-689-9358BEVERLY.ROSS63@PROTON.ME8373 Hillcrest Rd #311Eden PrairieMN55370GRP-4069core-hmo
ENRENR-1033582026-09-03T11:30:31ZJulieEOlson1972-11-08UHC-69723-76•••-••-6237+1 578 307 6515-2676 Hillcrest RoadJacksonvilleFloridanull··GRP-5834CHOICE-PLUS-PPO
ENRENR-110108 2026-06-20T17:25:51ZJackie—Peters1986-06-16UHC-89558-37•••-••-32474646550jacqueline.peters@icloud.com9069 Forest AvenueJacksonville·FL32228GRP-9370MEDICARE-ADV-A
ENRENR-1088552026-07-20T20:27:05ZAHMEDMHUDSON03/10/2000UHC-80428-70•••-••-151119817944266ahmed.hudson54@hotmail.com4171 Valley View Dr Apt 33SacramentoCalifornia···95809GRP-5359NAVIGATE-HMO
ENRENR-1055922026-06-22T11:25:37ZSantiago—Herrera1965-05-20UHC-36829-74—297-533-6713·santiago.herrera89@yahoo.com9406 Washington StreetMESAAZ85267-6384GRP-7872SELECT-EPO
ENRENR-1111042026-09-11T22:49:57ZmarilynXreynolds1945-06-15UHC-46674-53•••-••-9104850.968.2835—5503 Central Avenue Apt 2Orlando··FL32865GRP-7718SELECT-EPO
43,101 rows, page 238 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.619Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty