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-1018172026-02-19T15:04:37ZYUKIXGREEN19700813UHC-53218-39•••-••-1298+1 783 562 0480null6180 JEFFERSON AVESan Antonio··TX78223GRP-3444OPTIONS-PPO
ENRENR-1333082026-02-11T12:36:31ZMegan—Ortiz08/20/1961UHC-20744-18•••-••-7383409-586-0385N/A9249 Desert Sky Boulevard··Los AngelesCA—GRP-1014OPTIONS-PPO··
ENRENR-1326792026-08-23T10:43:01Zjeremy—gilbert1977-02-25··-•••-••-24698279693160JEREMY.GILBERT@HOTMAIL.COM9363 VALLEY VIEW DRIVEColumbusOhio43275GRP-6118·MEDICARE-ADV-A
ENRENR-1074372026-09-18T10:00:50ZJOHNV.··BRYANT08/23/1988UHC-34316-31•••-••-3813621.560.2163··john.bryant73@icloud.com3418 Canyon RdColumbusOH43288GRP-4131NAVIGATE-HMO
ENRENR-1057292026-04-25T12:00:02ZKATHY—CRUZ1967-10-10·UHC-59287-85•••-••-9820nullkathleen.cruz@hotmail.com9570 Church Street Apt 14San Diego·CA92175GRP-0933MEDICARE-ADV-B
ENRENR-1123572026-06-26T08:45:39ZGardner, JonathanG—12/22/1959UHC-56406-57•••-••-33282607069786JONATHAN.GARDNER@OUTLOOK.COM4766 CANYON ROADDallasTX75244GRP-4810CHOICE-PLUS-PPO
ENRENR-1381002026-01-15T18:35:00ZMasonFPorter15-02-1965UHC-54272-63•••-••-33349097807963-6442 APACHE BOULEVARD #590San DiegoCA92148GRP-7561·CORE-HMO
ENRENR-1414242026-09-21T22:51:54ZChrisitan—Henry10/11/1946UHC-60838-89•••-••-4678704-399-7321christian.henry@aol.com1252 JEFFERSON AVENUEScottsdaleArizona85203···GRP-5424CORE-HMO
ENRENR-1191352026-07-06T18:50:21ZJeffreyZSilva1991-11-28UHC-10307-66•••-••-2925N/A·jeffrey.silva59@proton.me5130 Elm StLas VegasNevada89199GRP-3627MEDICARE-ADV-A
ENRENR-1214742026-05-05T21:00:57ZDonnaB.Kim1963-03-16UHC-64234-68•••-••-8876350-691-8676—5079 OCEAN AVENUECharlotteNC28239GRP-5888SELECT-EPO
ENRENR-1275192026-06-07T02:00:32ZVasquez, TimothyH—19460816UHC-40176-50····897-227-1401—4462 Baseline RdSan Antonio··TX78200GRP-0209··NAVIGATE-HMO
ENRENR-1267662026-04-19T11:38:05ZGreene, Donna——·1989-01-17UHC-31782-23•••-••-164018568609815donna.greene81@proton.me5500 Hillcrest RdSAN DIEGOCalifornia92179GRP-7933MEDICARE-ADV-A
ENRENR-1393132026-10-02T23:49:39ZDiane—James11/15/1956UHC-35653-34•••-••-6661747-330-6118··diane.james@icloud.com7761 CEDAR LANETampaFL33642GRP-8937CHOICE-PLUS-PPO
ENR ENR-1323332026-04-10T13:25:49ZGraceSBarnes2001-12-22UHC0261034•••-••-2587(753) 230-2229grace.barnes@yahoo.com3180 Harbor BoulevardOrlandoFL32868-0204GRP-6097MEDICARE-ADV-B
ENRENR-1240862026-10-03T02:06:53ZAmy—Palmer1962-11-23UHC1168255•••-••-2938nullAMY.PALMER@AOL.COM·7688 River RdEden PrairieMN55355GRP-9434MEDICARE-ADV-B
ENRENR-1166702026-05-29T03:45:12ZFrankV.West20080719UHC-04003-72•••-••-4262(365) 272-2280frank.west42@icloud.com9071 Cedar LaneTempeAZ85266GRP-3172choice-plus-ppo
ENRENR-1231432026-02-09T10:29:13ZNathanOWest1965-08-26UHC-01348-64•••-••-0439(850) 963-1061nathan.west23@icloud.com5136 BASELINE ROAD··Columbusoh43228GRP-8048MEDICARE-ADV-B
ENRENR-1104112026-05-01T06:51:54ZSeanCChapman1991-12-25UHC6657779•••-••-516917942644904—6667 Cedar LaneEden PrairieMN·55398GRP-7935MEDICARE-ADV-A
ENRENR-1398612026-10-12T11:12:08Zkathryn—obrien09/23/1987UHC5953324•••-••-6113(741) 263-2886KATHRYN.OBRIEN@OUTLOOK.COM650 APACHE BLVDPhoenixArizona85022GRP-0434MEDICARE-ADV-B
ENRENR-1167572026-05-14T10:12:51ZSean··Matthews2008-04-28UHC-14473-06•••-••-7585(686) 818-0716SEAN.MATTHEWS@GMAIL.COM7946 Central AvenueMesa··AZ85261GRP-7887MEDICARE-ADV-B
ENRENR-1210152026-02-20T16:40:46ZGeraldMNelson1995-12-21UHC-75926-86N/A-gerald.nelson7@aol.com2068 Elm StreetGlendaleAZ85301GRP-5946SELECT-EPO
ENRENR-1189702026-06-19T07:45:37Zhunter—joan··1950-10-22UHC-46112-23•••-••-2138+1 488 681 8551joan.hunter@proton.me3968 Harbor BlvdORLANDOFL32812GRP-2624options-ppo
ENRENR-1091002026-08-14T05:53:08ZMatthew··KMontgomery10/03/1972UHC-40390-81•••-••-8525+1 907 944 6751matthew.montgomery96@proton.me4920 Lake View RoadCharlotteNC28279·GRP-9394CORE-HMO
ENRENR-1116582026-03-22T18:04:36ZZacharyNBryant2006-07-04UHC-87908-27•••-••-3729null—1840 Sage CtCharlotteNC28253GRP-6561MEDICARE-ADV-A
ENRENR-1327922026-06-29T01:45:14ZWeiB·Rodriguez·19440920UHC-29509-85•••-••-11439508259985—8123 MOUNTAIN VIEW DRIVETempeAZ85254··GRP-6597·NAVIGATE-HMO
ENRENR-1051262026-07-01T01:58:56Z Christina—Cruz·9/5/1986UHC-96388-39•••-••-0900·13087113051UNKNOWN4501 JEFFERSON AVENUEEden Prairiemn55391·GRP-5836CHOICE-PLUS-PPO
ENRENR-1288172026-09-03T14:42:13ZNathanTMunoz1969-05-26UHC-14152-14UNKNOWN943-224-7692NATHAN.MUNOZ@YAHOO.COM8839 Spring St Apt 30SCOTTSDALE·AZ85254GRP-4868MEDICARE-ADV-A··
ENRENR-1256742026-06-21T06:18:37ZJenkins—Emily1991-03-01UHC6313122•••-••-2118(733) 785-5742NULL3664 Camelback RoadAustinTX78775GRP-2202··CHOICE-PLUS-PPO
ENRENR-1114272026-04-14T03:16:48ZAndyNWalsh1494-08-05UHC-17683-33•••-••-831716976538246ANDREW.WALSH@AOL.COM4949 BASELINE RDJacksonvilleFL32292GRP-0580·MEDICARE-ADV-A
ENRENR-1154272026-02-18T10:28:31ZANDREAV.GUERRERO1953-09-12UHC-24890-23•••-••-59164084500877andrea.guerrero33@proton.me9204 DESERT SKY BLVDGilbertAZ85230·GRP-7440OPTIONS-PPO
ENRENR-1407722026-03-25T05:10:47ZSantiagoDHarrison1991-02-26UHC-19182-27•••-••-4263(772) 526-2836—7141 Elm StreetTampaFL33697GRP-8478medicare-adv-a
ENRENR-1062612026-09-12T22:33:17Zjasoon·Abooyd1989-11-16·UHC-91703-40•••-••-44743906071501jason.boyd72@yahoo.com8446 Jefferson AvenueTampaFL33624GRP-5200OPTIONS-PPO
ENRENR-1407612026-07-19T03:41:45ZVictoriaXCarlson1954-02-14UHC-90942-50NULL(723) 910-8560UNKNOWN7747 UNION STFresnoCA93752GRP-7441MEDICARE-ADV-A
ENRENR-1353422026-02-18T16:09:07ZBillyCMills1946-11-11UHC-12680-16•••-••-0558+1 960 309 5488billy.mills@icloud.com8661 INDIAN SCHOOL ROADPLANO··TX75097·GRP-1468CHOICE-PLUS-PPO
ENRENR-132102 2026-01-03T19:41:48ZBRANDONJSCHMIDT4/9/1957UHC-43499-71•••-••-7191970-751-1443BRANDON.SCHMIDT@HOTMAIL.COM2141 Union StreetDenverCO··80292GRP-0867MEDICARE-ADV-A··
ENRENR-1245532026-09-14T00:31:50Z·kellyN.hunt13-12-1985UHC1332131•••-••-586315738653865KELLY.HUNT@ICLOUD.COM6920 WILLOW COURTSacramentoCA·-GRP-8041OPTIONS-PPO
ENRENR-1274802026-01-31T23:50:40ZSusan·TStone12/16/1989·UHC-24130-69•••-••-4868+1 495 319 1631—8690 MESA DRIVETempeAZ85223GRP-4910NAVIGATE-HMO
ENRENR-1156892026-10-14T16:41:43ZKYLECKENNEDY1942-03-20UHC-01849-87•••-••-0672989.677.4999··kyle.kennedy82@aol.com5973 MEADOW LANEOrlandoFL32876··GRP-5609MEDICARE-ADV-A
ENRENR-1357562026-02-24T17:24:40ZBlack, Harold——1953-02-20UHC-08811-16•••-••-0400753-652-2416HAROLD.BLACK@OUTLOOK.COM1814 Lincoln WaySan DiegoCA92187GRP-0914MEDICARE-ADV-B
ENR ENR-1027612026-03-17T17:13:55ZDIANAT.HERRERA06/23/1963UHC-29988-99•••-••-968513056230488··diana.herrera@aol.com2719 Spring StreetMinneapolisMN-GRP-6042CORE-HMO
ENRENR-1409382026-04-22T02:24:44ZCheryl—Shaw1962-08-16UHC-24491-02•••-••-75756294745819··cheryl.shaw27@outlook.com5165 Washington StCharlotte··NC28246GRP-9252MEDICARE-ADV-A··
ENRENR-1407402026-06-24T10:09:07ZTHOMAS—AUSTIN11-09-1974UHC-23139-42•••-••-8149NULLthomas.austin64@proton.me4378 Maple AvenueGlendaleAZ85378GRP-9949MEDICARE-ADV-A
ENRENR-1387942026-01-16T01:31:56ZJustinK.Matthews2008-02-18UHC-38023-50•••-••-7735+1 251 389 0024justin.matthews@proton.me5546 MAPLE AVECharlotteNC28255··GRP-3999NAVIGATE-HMO
ENRENR-1404832026-03-28T19:37:36Z·Jeremy—Perez1995-01-02UHC-76154-90—(574) 510-8490—1871 Valley View DriveColumbusOH43214GRP-5307NAVIGATE-HMO
ENRENR-122302 2026-06-05T17:30:46ZMeiL.Morrison04-11-1979UHC-89772-23•••-••-2983(711) 773-3046mei.morrison@gmail.com9548 ELM STOrlandoFL32826GRP-4090OPTIONS-PPO
ENRENR-1158112026-07-11T23:07:28ZSAMUELQADAMS1951-06-02UHC-73260-83•••-••-4937+1 933 534 7991SAMUEL.ADAMS@PROTON.ME1053 MEADOW LNLos AngelesCA90005-0384GRP-7130MEDICARE-ADV-A
ENRENR-1153742026-07-04T21:15:30ZDOUGLASUWALKER06/08/1993UHC-39642-73—588-927-7270DOUGLAS.WALKER45@PROTON.ME·1960 Ocean AveTampaFLN/AGRP-3138MEDICARE-ADV-B
ENRENR-105629 2026-01-29T02:41:09ZAndreaT.Vazquez06/12/1978uhc-22645-45··•••-••-655917957729916andrea.vazquez45@hotmail.com8128 PARK PLACESacramentoCA95825GRP-7669MEDICARE-ADV-B
ENRENR-1102082026-08-02T01:59:21ZSusan—JimenezApr 7, 2003UHC-96912-58•••-••-3814(412) 906-2436susan.jimenez@outlook.com3298 Mountain View DrTEMPEAZUNKNOWNGRP-7856medicare-adv-b
ENRENR-1220942026-09-01T02:23:31ZArjunR.PowellApr 16, 1962UHC-79018-17—4007847arjun.powell@yahoo.com3746 Spring StAtlantaGA30369GRP-6213SELECT-EPO
43,101 rows, page 72 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:36.705Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty