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-1068392026-08-26T23:26:18ZDorothyAGray1945-08-20UHC-28039-87-+1 797 663 4776dorothy.gray@outlook.com9607 Meadow LaneLas VegasNV89155GRP-6117MEDICARE-ADV-B
ENR ENR-1151362026-01-05T06:29:59Z·LindaLSmith1989-09-17UHC-68199-20•••-••-68898909450678N/A6905 Hillcrest RoadTempeAZ85222GRP-6601MEDICARE-ADV-A
ENRENR-1106322026-01-12T03:26:02Zgregory—franklin2000-06-12—N/A+1 902 372 7137gregory.franklin94@aol.com5586 Pine DriveLos Angeles··CA90053GRP-8956MEDICARE-ADV-A
ENRENR-1293882026-04-11T04:01:02ZDANIELZBLACK2005-02-09UHC-29762-38•••-••-00799508577341daniel.black12@aol.com4370 SPRING STPHOENIXAZ85078GRP-0848CHOICE-PLUS-PPO
ENRENR-1369882026-01-01T02:43:55ZGeorge—Herrera1952-10-09UHC-45914-08•••-••-9096UNKNOWN—337 MESA DRATLANTAGA30307GRP-1713MEDICARE-ADV-B
ENRENR-1231032026-10-11T00:47:01ZSingh, JeffreyK—Oct 28, 2008UHC-30073-49•••-••-5216905.458.8942UNKNOWN3844 CEDAR LANELas VegasNVnullGRP-3182MEDICARE-ADV-B
ENRENR-1426622026-05-02T13:57:16ZSusanGPerez1938-06-23·UHC-09172-06•••-••-45848805255677susan.perez@proton.me8072 SAGE COURTChandlerAZ85239GRP-5822CORE-HMO
ENRENR-1179122026-06-17T06:34:30Zandrea—patterson1943-10-02UHC-20066-43•••-••-7227(432) 298-9936ANDREA.PATTERSON62@YAHOO.COM6818 HILLCREST ROADSan DiegoCA—GRP-8831OPTIONS-PPO
ENRENR-1312812026-03-24T10:56:46ZRUSSELLSWARD09/05/1968UHC-88290-82—8239992782—1653 Maple AvenueGlendaleAZ85323GRP-1182CORE-HMO
ENRENR-1044232026-04-11T06:08:03ZMarshall, Kate——1943-08-16UHC-61716-65•••-••-0166(571) 988-6069UNKNOWN6981 Grand Ave··Fresno·CA93735GRP-2747NAVIGATE-HMO
ENRENR-1175692026-09-30T15:58:57ZPHILIP··SHARVEY1960-11-20UHC9003644•••-••-378917964360147—7673 Union StreetDallasTX75200GRP-2771NAVIGATE-HMO
ENRENR-137334 2026-02-13T02:21:20ZKYLLE····PETERSNULLUHC-90273-30•••-••-515719627644449kyle.peters@outlook.com··6379 WILLOW COURTOrlandoFLN/AGRP-2505CORE-HMO
ENRENR-1100522026-08-22T09:28:35ZSarahBFord1998-10-01UHC-23807-49•••-••-878918177010911SARAH.FORD@YAHOO.COM7721 MAPLE AVENUEPHOENIXAZ85088GRP-2306·OPTIONS-PPO
ENRENR-1049662026-02-28T15:35:00ZCarlson, StephaineG—16-04-1977UHC-71608-01•••-••-2228488.981.7882stephanie.carlson@yahoo.com9790 Cedar LnGilbertAZ85205GRP-1259OPTIONS-PPO
ENRENR-1153762026-04-25T23:40:03ZDonna·IStephens03/07/1984UHC-67995-44•••-••-4857545-827-6708—1758 Mountain View DrPlanoTX75067GRP-7778CHOICE-PLUS-PPO
ENRENR-1399952026-08-05T18:49:04ZSandraN.Reynolds1971-06-18UHC-49352-15•••-••-0590479-307-2564SANDRA.REYNOLDS@AOL.COM5740 INDIAN SCHOOL ROADScottsdaleAZ85229··GRP-1608MEDICARE-ADV-A
ENRENR-1052042026-09-05T22:59:28ZMark—Hudson2002-05-17··UHC-88797-59•••-••-6029(332) 377-2261mark.hudson61@aol.com2758 BroadwayGilbertArizona85283GRP-0571OPTIONS-PPO
ENRENR-1054322026-09-06T20:30:30ZSamuel··Bailey19510903UHC-84204-56•••-••-3291(212) 873-4571samuel.bailey@proton.me8625 Grand AvenueNashvilleTN37227GRP-6486MEDICARE-ADV-A
ENRENR-1113522026-08-10T04:55:55ZRalph—Le1950-06-26UHC-25349-55•••-••-7396428-534-6230ralph.le@outlook.com513 Highland AveEden PrairieMinnesota55341··GRP-7304MEDICARE-ADV-B
ENR ENR-1342382026-03-19T16:44:02ZHiroshi—Garza2005-11-05UHC-77416-36•••-••-92288065786361hiroshi.garza@aol.com3626 INDIAN SCHOOL RDPlanoTX75018·GRP-5015NAVIGATE-HMO
ENRENR-1232512026-08-02T07:30:40ZJoseph—Hansen1940-08-18·UHC-21743-38•••-••-9621814.780.4187JOSEPH.HANSEN54@PROTON.ME6929 BROADWAYHouston·tx77032GRP-7300MEDICARE-ADV-B
ENRENR-104562 2026-01-19T09:25:09ZhenryH.long1969-04-28UHC-73738-13•••-••-51302295816028··UNKNOWN·3353 Spring StreetChandlerAZ85274GRP-7745·CHOICE-PLUS-PPO
ENRENR-1266512026-07-12T21:14:03ZBradleyK··Scott23-10-1997UHC-32362-04•••-••-9519(553) 572-8090bradley.scott@outlook.com1514 Camelback RdTempeAZ85216GRP-3605SELECT-EPO
ENRENR-1212582026-09-26T09:10:05ZDORISTJACKSON1964-10-17UHC-46932-02··•••-••-9726·3072851734DORIS.JACKSON39@HOTMAIL.COM7288 OCEAN AVEGLENDALEAZ85348GRP-5045·CHOICE-PLUS-PPO
ENRENR-1049472026-03-27T12:05:21ZDEBORAHB·BISHOP1961-04-12UHC-53289-31··•••-••-0737803-973-2355—7177 BASELINE ROADPHOENIXAZ·85079GRP-4378options-ppo
ENRENR-1070682026-02-05T01:40:32ZNATALIEELARSON1999-01-13··UHC-29101-12•••-••-59237118741072null199 Grand AvePlanoTX·75040GRP-5586SELECT-EPO
ENRENR-1126762026-04-04T08:05:02ZAlice—Bennett1981-10-20UHC-05340-64•••-••-216714112656633alice.bennett52@yahoo.com2277 Pine Drive #829DallasTexasnullGRP-9745choice-plus-ppo
ENRENR-1380652026-07-24T04:58:23ZMatthews, Marilyn——1961-05-19UHC-75503-07•••-••-0176+1 533 211 4737marilyn.matthews@aol.com6552 Canyon RdAtlantaGA30352-7051GRP-8949··MEDICARE-ADV-A
ENRENR-1302392026-08-19T00:48:57Z JamesZHerrera11/09/1979UHC-24048-03•••-••-1993(344) 704-3368JAMES.HERRERA15@HOTMAIL.COM6370 Meadow LnSEATTLEwa98144GRP-4649CHOICE-PLUS-PPO
ENRENR-1286192026-01-13T06:44:55ZLittle, Vincent····—1980-02-28UHC-06876-42•••-••-75476794154910—1858 Market StPhoenixAZ85033GRP-1491CHOICE-PLUS-PPO
ENRENR-1221472026-09-02T02:54:16ZAmberCJackson·1940-04-15UHC-61032-14•••-••-5173966.995.9429AMBER.JACKSON@GMAIL.COM5632 Pine DriveColumbusOH···43216GRP-7038MEDICARE-ADV-B
ENRENR-1407552026-03-07T20:26:59ZColeman—Edward1938-04-08·UHC-02650-81•••-••-8434(212) 669-4821edward.coleman@yahoo.com·8603 Bayshore DriveHoustonTX77084GRP-6592SELECT-EPO
ENRENR-1038722026-03-02T20:00:49ZMargaret—Gutierrez06-10-1961UHC-64472-08•••-••-80576784883519margaret.gutierrez@proton.me2129 Forest AvenueScottsdaleAZ85257GRP-0957NAVIGATE-HMO
ENRENR-1250722026-04-22T11:45:29ZMariaZ.··Johnson19941004UHC-32040-91•••-••-390718106280399··—5389 Indian School RoadLos AngelesCA90045GRP-0401··NAVIGATE-HMO
ENRENR-1330052026-02-09T18:30:49ZCHARLES—·CHAN1978-06-13UHC5701254•••-••-8875827.494.0267CHARLES.CHEN@PROTON.ME2023 MEADOW LNTucsonAZnull·GRP-8096CHOICE-PLUS-PPO··
ENRENR-1385552026-04-08T02:34:46ZGarrett, BeverlyT—19581203UHC-81988-70•••-••-98989237699337—3178 BASELINE ROADChandler·AZ85295-9802GRP-8179MEDICARE-ADV-A
ENRENR-1373962026-04-29T23:37:19ZAlbert—Kim1960-05-01·UHC-94099-84•••-••-72258179101715albert.kim@yahoo.com7346 Spring StreetLas VegasNV89151GRP-3294CORE-HMO
ENRENR-1013862026-10-07T23:37:23Zdebra—weaver1964-12-08uhc-98417-45•••-••-4353(715) 222-7119debra.weaver@proton.me9635 PARK PLAtlanta··GA30391··GRP-3724·MEDICARE-ADV-B
ENRENR-1150802026-04-28T01:36:06ZJAAKEF··CARR1973-06-23UHC-11223-36•••-••-05153893918393jacob.carr@proton.me·2448 Canyon Rd·TUCSONAZ85707GRP-0898NAVIGATE-HMO
ENRENR-1201362026-09-18T17:01:56Z·DANIELLEL.BANKS10/19/1942UHC1537358•••-••-32847158864057danielle.banks67@gmail.com38 Forest AvenueLOS ANGELESCANULLGRP-2754MEDICARE-ADV-B
ENRENR-1232712026-10-08T17:08:15Z·Anna—Scott19570413UHC-58273-66•••-••-0122(912) 524-1538ANNA.SCOTT44@AOL.COM5832 DESERT SKY BOULEVARDMesaAZ85290GRP-2916OPTIONS-PPO
ENRENR-1132702026-09-04T09:56:33ZJANETB.BAILEYnullUHC-68660-89··—(797) 828-5678janet.bailey@outlook.com4559 BAYSHORE DRIVE·OrlandoFL32861GRP-0836CHOICE-PLUS-PPO
ENRENR-1170582026-07-23T18:35:46ZHarold—Gonzales06/19/80UHC-74823-63•••-••-6131(272) 576-8115HAROLD.GONZALES86@GMAIL.COM6248 Camelback Road #635TucsonAZ85713GRP-0803MEDICARE-ADV-A
ENRENR-1360672026-05-03T23:38:41Z·LaurenRMurphy1969-08-21UHC-46397-91•••-••-23839237297088LAUREN.MURPHY69@PROTON.ME6265 OCEAN AVENUEMesaAZ85264GRP-3939MEDICARE-ADV-B
ENRENR-1092822026-09-06T05:09:19ZAlexis—Burke1951-01-13UNKNOWN•••-••-4335—alexis.burke@yahoo.com6809 Valley View DriveTUCSONAZ85747GRP-6347CORE-HMO
ENRENR-1056572026-02-08T13:34:01ZAndreaECarr1967-08-01UHC-30099-41•••-••-48112133135396··ANDREA.CARR@YAHOO.COM8551 Desert Sky BlvdORLANDOFL32888GRP-8673·MEDICARE-ADV-B
ENRENR-1076742026-08-10T14:35:12ZRUTH··Y.STEPHENS11/26/1956UHC-49733-39•••-••-1177(416) 288-1086ruth.stephens@icloud.com3218 Grand AvenueDenverCO80292GRP-1630SELECT-EPO
ENRENR-1029202026-02-19T23:47:06Zanthony—wong1939-02-17UHC-96640-09··—(292) 341-7071UNKNOWN4634 Sage CourtFresnoCA93703GRP-0384NAVIGATE-HMO
ENRENR-1242652026-01-21T18:26:31ZLoganIWagner·Mar 2, 1977UHC-44134-51•••-••-21914549516436LOGAN.WAGNER83@PROTON.ME289 Willow Ct··TempeAZ85227GRP-2578MEDICARE-ADV-B
ENRENR-1059142026-03-24T15:16:10Z·Heather—Soto1972-04-28UHC9294991null974-255-9371·HEATHER.SOTO10@PROTON.ME4780 UNION STREETTampaFL··33662GRP-9463CORE-HMO
43,101 rows, page 42 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:34.803Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty