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-1155072026-02-16T02:58:06ZTERESA·SKNIGHT1969-10-26UHC-05402-97•••-••-4155(698) 540-5208teresa.knight4@outlook.com9898 Apache BoulevardMesaAZ85208-0089GRP-0124MEDICARE-ADV-B
ENRENR-1284822026-10-08T18:02:14ZJEAN—RAMIREZ03/05/05UHC-02634-12··•••-••-2437(537) 672-5919jean.ramirez@aol.com6452 Pine DriveHoustonTX77072··GRP-1948··CORE-HMO
ENRENR-1327242026-03-23T08:40:26ZMARKO··WEBER2004-03-02UHC-65837-43•••-••-32173589842492MARK.WEBER9@AOL.COM7694 Central AvenueScottsdaleAZ85219GRP-1874select-epo
ENRENR-1006552026-02-20T07:25:35ZRaymond··YThomas1948-12-06UHC0932920··•••-••-7371—null9463 Bayshore DriveTampaFL33691GRP-3532SELECT-EPO
ENRENR-1129482026-06-11T18:10:40ZJOEX.THOMAS1980-08-27UHC-66607-08•••-••-072214176737554joe.thomas@proton.me8428 Camelback RoadLos AngelesCA90052GRP-9209SELECT-EPO
ENRENR-1400322026-03-26T19:53:28ZPAMELA··—GUZMAN·1982-06-11UHC-98619-77•••-••-8256+1 409 588 1018—9168 Mountain View Drive·TempeAZ·85257GRP-5175MEDICARE-ADV-A
ENRENR-1314532026-07-07T09:21:05ZDebraFHanson05/14/52UHC-88261-03•••-••-66028846283798UNKNOWN2273 MAIN STSAN DIEGOCA92196GRP-0395OPTIONS-PPO
ENRENR-1311012026-03-30T11:17:39ZLisaM.·Knenedy1957-11-10UHC1314963•••-••-3420+1 651 934 5047LISA.KENNEDY@YAHOO.COM5138 Harbor BoulevardMesaAZ85204-9631GRP-3296MEDICARE-ADV-B
ENR ENR-1027282026-04-26T01:03:11ZKYLEYHOFFMAN11/15/1939UHC-39224-93—(542) 367-7413-1424 Park PlaceTampaFL33697GRP-0227core-hmo
ENRENR-1145342026-10-13T12:15:32ZELIZABETHSTUCKER1981-04-25UHC-35219-28null657-679-5291elizabeth.tucker60@proton.me9246 Main StreetMiamiFL33164GRP-5585MEDICARE-ADV-A
ENRENR-1244672026-05-28T18:38:56ZCATHERINE—COLEMAN08/12/2004UHC-75249-39•••-••-926915508284224catherine.coleman@gmail.com4690 Camelback RdSan AntonioTX78292GRP-9124CORE-HMO
ENRENR-1319782026-07-28T20:09:40ZRACHEL·CLAWSON19420323UHC-27077-99—+1 204 826 5282rachel.lawson82@icloud.com8742 PINE DRHOUSTONTexas77087···GRP-1508CORE-HMO
ENRENR-1075772026-10-14T19:38:11ZEricW·Burns1991-06-28UHC-77346-74•••-••-3151(809) 794-1750eric.burns65@icloud.com5566 PINE DRIVETempeAZ85240··GRP-1266CORE-HMO
ENRENR-1202962026-07-12T20:50:23Z·MasonE.···Wagner1961-12-20UHC2571226•••-••-39157124809239mason.wagner23@outlook.com868 LINCOLN WAYNashville···Tennessee37238GRP-6171CORE-HMO
ENRENR-112457 2026-08-02T03:38:46ZLaura—Dunn1976-02-22·UHC-44881-02•••-••-6800(616) 655-7095·LAURA.DUNN64@OUTLOOK.COM8838 Park PlaceMesaAZ85200GRP-9161medicare-adv-a
ENRENR-1373132026-05-19T08:49:46ZCHARLES—LONG1974-11-18UHC-87647-93•••-••-2400276-452-4129charles.long@hotmail.com9162 HILLCREST ROADSan AntonioTX·78265·GRP-5015OPTIONS-PPO
ENR ENR-1362282026-02-06T16:47:51ZHiroshiHDixon1970-12-01UHC-68326-88•••-••-5492+1 841 658 4235hiroshi.dixon@gmail.com2468 Lake View RoadTempe··AZ85276GRP-3137MEDICARE-ADV-A
ENRENR-1289882026-04-25T16:33:24ZDonaldRPatel1989-03-28··UHC-14764-41•••-••-9843772-441-4294·donald.patel@proton.me·958 CEDAR LANEDenverCO80283GRP-9596OPTIONS-PPO
ENRENR-1391172026-05-24T19:45:51ZParker, Mark——1995-01-16UHC-03784-08•••-••-8802879-886-2295··mark.parker@gmail.com5873 Mountain View DrAtlantaGA30396-3931GRP-1587MEDICARE-ADV-B
ENRENR-1145262026-07-09T18:45:30ZWilliam—Pierce19910514UHC-21838-18•••-••-77657646365649william.pierce6@aol.com6580 Lincoln WaySan DiegoCA92112GRP-3001MEDICARE-ADV-A
ENRENR-1405252026-05-17T11:37:44ZWILLIESHOLMES1977-06-04UHC-22394-73··•••-••-9899714-832-0101—6486 PALM DRIVEPhoenixAZ85091GRP-9485CHOICE-PLUS-PPO
ENRENR-1091792026-07-29T22:04:27ZBRIANBHAWKINS19940727···UHC1414052—(707) 610-9197brian.hawkins@aol.com··6391 Mesa DriveHoustonTX77049GRP-4616CORE-HMO
ENRENR-1349902026-06-29T21:08:13Znicole·Ulee1974-01-26UHC-13335-65•••-••-2317395.547.1006·nicole.lee@gmail.com7184 Hillcrest RdDallasTX75269GRP-9210NAVIGATE-HMO
ENR ENR-1099292026-05-13T19:14:44ZRobertson, JackU—1970-12-17UHC-88651-91•••-••-6061613-960-5593—883 Ocean AveTucsonaz85755GRP-1685MEDICARE-ADV-B
ENRENR-1196332026-09-05T13:32:39ZEmma—Robertson2008-07-02UHC-58103-58•••-••-0286800-400-8331—5593 SPRING STGlendaleAZ85324GRP-9121CORE-HMO
ENRENR-1093182026-01-18T16:17:13ZLAAURA··SSTONE1984-10-19UHC-63188-72•••-••-2990UNKNOWNlaura.stone49@outlook.com7846 WILLOW COURTSeattleWashington98190GRP-8874SELECT-EPO
ENRENR-1389742026-02-10T23:45:40ZLawrence—Ramirez19930311UHC-95611-07•••-••-5273nulllawrence.ramirez78@yahoo.com1423 Cedar Ln Apt 23TucsonArizona85769GRP-3654OPTIONS-PPO
ENRENR-1230302026-02-20T11:39:45ZHANNAH—PEENA1992-02-17UHC2575376•••-••-7751311-975-4984HANNAH.PENA@HOTMAIL.COM6473 CAMELBACK ROADSCOTTSDALEAZ85265GRP-1263·MEDICARE-ADV-A
ENRENR-1239132026-05-03T02:00:10ZDIANE—BARNES1956-12-03UHC7869364•••-••-0323·5219240164DIANE.BARNES80@ICLOUD.COM3474 RIVER ROADDenverCO80282-4197GRP-4286CHOICE-PLUS-PPO
ENRENR-1028012026-05-19T12:33:32ZAMYF.WRIGHT1999-04-28UHC-27128-15··•••-••-6145(262) 739-1349··AMY.WRIGHT@GMAIL.COM9776 Union StSan DiegoCA·92126GRP-9015SELECT-EPO
ENRENR-1161852026-07-02T00:09:49ZCaterineEKim1984-09-28UHC-20559-64•••-••-3547845.841.8887catherine.kim26@icloud.com3360 Church StMesaAZ85213-3016GRP-4820CORE-HMO
ENRENR-1329122026-09-05T22:03:14ZJackson, Emma——·1905-11-25UHC-14402-88•••-••-8570(689) 717-9127—1433 JEFFERSON AVENashvilleTN37238-6315GRP-5266··MEDICARE-ADV-A
ENRENR-1277792026-10-12T16:19:26ZLoganGCarr19390414UHC-24445-30•••-••-4377——1730 Cedar LnLas VegasNevada89168GRP-6333OPTIONS-PPO
ENR ENR-1006412026-08-17T11:01:49ZIsabella····Wang1997-04-11UHC-38725-82•••-••-48487617249isabella.wang67@proton.me·4334 Jefferson AveHoustonTexas77027GRP-5851CORE-HMO··
ENRENR-1248502026-01-20T06:53:47ZOmar—·Lee1956-02-14UHC-17270-62null2693595840·OMAR.LEE4@OUTLOOK.COM348 Palm DrJacksonvilleFL32252GRP-1900··NAVIGATE-HMO
ENRENR-1348852026-09-12T01:32:36ZOwens, PatriciaS—·1950-08-04UHC-87048-14•••-••-3262617-444-0320PATRICIA.OWENS50@PROTON.ME··3078 OCEAN AVENUENASHVILLETN37201·GRP-9441CORE-HMO
ENRENR-1145642026-01-09T12:36:09ZSeanB.Perry05-10-1972UHC-95752-06•••-••-71087489232391sean.perry@hotmail.com8590 Jefferson AveCHANDLERAZ·85206GRP-6172MEDICARE-ADV-B
ENRENR-1132932026-06-23T11:39:51ZMaryNRussell23-12-1942UHC-42213-42•••-••-0294(309) 420-5832mary.russell3@gmail.com6848 Jefferson AveLas VegasNV89179GRP-7384OPTIONS-PPO
ENRENR-1352852026-02-22T01:21:08ZDAVIDJ.RYAN1990-01-19UHC0604057•••-••-99897342478808DAVID.RYAN64@GMAIL.COM5979 Park PlOrlandoFL32832-3592GRP-4714OPTIONS-PPO
ENR ENR-106512 2026-10-09T16:47:16ZArjunF.Lopez··1959-11-20UHC-85521-93—·225.564.1562arjun.lopez@aol.com5286 HIGHLAND AVENUELos AngelesCA90011GRP-9325CORE-HMO
ENRENR-1311682026-05-13T01:04:29Zraymond··—torres03/02/2007UHC-11215-39•••-••-394716008236456raymond.torres@proton.me·6610 PINE DRIVEAustintx78714GRP-3423CHOICE-PLUS-PPO
ENR ENR-1165142026-01-04T11:44:42Zwayne···rojas02/06/1965UHC2922561•••-••-0148333.766.7105wayne.rojas@icloud.com5328 Pine DrFresnoCA93773GRP-5655NAVIGATE-HMO
ENRENR-129228 2026-03-08T08:54:25ZTucker, Wei——12/27/1979UHC-94558-28•••-••-29362356894324-5189 Valley View DriveNashvilleTN37212GRP-6426NAVIGATE-HMO
ENRENR-1415162026-09-06T02:11:14ZEvelynF.Vargas1995-06-15UHC-61305-53•••-••-52785747753420evelyn.vargas@outlook.com8105 Church StreetGlendaleAZ85347-8406GRP-9192CHOICE-PLUS-PPO··
ENRENR-1015582026-08-18T08:23:25ZJulia—Sanders1990-03-17··UHC-75221-78•••-••-28399889045241NULL9533 WASHINGTON STREETDenverCO80232GRP-4746NAVIGATE-HMO
ENRENR-1144112026-06-26T22:16:29ZDOUGLAS·AHALL27-03-1965UHC-41939-31•••-••-3621+1 472 671 8562douglas.hall8@yahoo.com4216 Harbor BoulevardHoustonTX77087-9125GRP-5785MEDICARE-ADV-A
ENRENR-1361902026-10-12T06:20:54Z Joe C.—Day1948-02-19uhc-72292-79····358-898-6299null6135 APACHE BOULEVARDMiamiFL33133GRP-6939SELECT-EPO
ENRENR-1073742026-07-22T17:01:18ZBlack, HeatherG—19830118UHC-29594-73•••-••-8701(655) 548-6532HEATHER.BLACK@PROTON.ME3321 Washington Street··Los AngelesCA90040GRP-7477MEDICARE-ADV-B
ENRENR-1089382026-08-15T21:33:57ZElizabethRFowler1983-08-12UHC-18239-50•••-••-06192159457070ELIZABETH.FOWLER@ICLOUD.COM2647 MAPLE AVEPhoenixAZ85041GRP-2227medicare-adv-a
ENRENR-1258512026-04-01T20:45:01ZCarlson, NicoleD—20-10-1941··UHC-64211-07•••-••-3917349-886-9262UNKNOWN8802 PINE DRIVETampaFLNULLGRP-0483CORE-HMO
43,101 rows, page 82 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.716Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty