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-1342332026-01-29T22:26:24ZROY—REED1975-08-05·UHC-26068-80•••-••-52736882559284UNKNOWN4501 INDIAN SCHOOL RDFRESNOCA93786-8302GRP-3026··SELECT-EPO
ENRENR-1354812026-05-05T05:59:36ZDYLANR··SMITH1950-05-05UHC-24470-31•••-••-5317864-978-6708DYLAN.SMITH@YAHOO.COM602 Mountain View DriveEden PrairieMN55302GRP-7265MEDICARE-ADV-A
ENRENR-1061292026-08-11T08:59:29ZGregory··—Johnson1981-05-06UHC-38059-86•••-••-5503893.266.2268gregory.johnson@hotmail.com2227 RIVER RDFRESNOCA93707GRP-9997·MEDICARE-ADV-A
ENRENR-1119262026-02-11T04:55:31ZANTHONY—WANG1991-07-23UHC-64043-02•••-••-6372(948) 684-6751anthony.wang16@gmail.com·5874 HILLCREST RDSan AntonioTX78224GRP-5457CORE-HMO
ENRENR-133373 2026-01-16T18:15:40ZRUTH W—RSOE1997-12-20UHC-90723-35•••-••-7742+1 952 931 7242RUTH.ROSE30@OUTLOOK.COM8340 MAPLE AVENUEDALLAStx75212··GRP-5000CHOICE-PLUS-PPO
ENR ENR-1179572026-03-24T00:22:59ZKaren—Luna1909-04-10UHC-61000-68•••-••-33232092799432KAREN.LUNA49@PROTON.ME4710 SAGE COURT #101Los AngelesCalifornia90031···GRP-4076MEDICARE-ADV-A
ENRENR-1108672026-08-06T01:20:54ZAmy—Washington17-03-2007UHC-18716-04•••-••-05957856291425AMY.WASHINGTON68@HOTMAIL.COM7684 Mountain View DriveGlendaleAZ85365GRP-2835MEDICARE-ADV-A
ENRENR-1371062026-01-30T16:24:51Zjessica··—carroll6/12/1942UHC-09268-29•••-••-143615033331504jessica.carroll62@gmail.com9859 Sage Ct Apt 29JacksonvilleFL32206GRP-2629CHOICE-PLUS-PPO
ENRENR-1103862026-09-03T15:23:24ZAhmed····Yang09/10/1989UHC-50770-15•••-••-9517(599) 923-1234AHMED.YANG15@YAHOO.COM7620 Union StSan AntonioTX78208GRP-3592MEDICARE-ADV-B
ENRENR-1217432026-02-19T15:35:00ZMADISON····MEYEER···1954-09-22UHC-69234-89•••-••-4271786-702-3315—6065 Ridge RdTampaFL33615GRP-2239MEDICARE-ADV-A
ENRENR-1240142026-04-21T13:09:19ZChris—Warren1963-10-03UHC-94627-48•••-••-8806(802) 667-9446N/AUNKNOWNN/A—-GRP-2884MEDICARE-ADV-B
ENRENR-1391552026-07-05T01:55:13ZDANPRICHARDS23-08-1988UHC-49911-56N/A5132450933daniel.richards@icloud.com6157 GRAND AVEAUSTINTX—GRP-0821·CHOICE-PLUS-PPO
ENRENR-1084862026-10-09T22:36:25ZEric·T·Long11/4/1956UHC-21628-91UNKNOWN+1 606 819 7313N/A4296 RIVER RDSan AntonioTexas78273GRP-6391NAVIGATE-HMO
ENRENR-1028082026-03-19T14:41:24ZMADISONWBAANKS··7/14/1952UHC-91735-12•••-••-3482(758) 519-6642madison.banks@hotmail.com559 Valley View DriveAustin··TX78718GRP-0958NAVIGATE-HMO
ENRENR-1000362026-09-21T04:16:33ZAlexander—DixonMay 7, 1982UHC-80497-62•••-••-4150218.577.0010—3121 Jefferson AvenueAustinTX··78777-6678GRP-5054·SELECT-EPO
ENRENR-1317892026-08-30T20:24:18ZMARCUSEMYERS1989-08-13UHC-24628-03•••-••-3811(481) 577-6632N/A95 Lake View RdTUCSONAZ85700GRP-8793CORE-HMO
ENRENR-1053112026-02-19T17:48:01ZYang, EugeneW—19640215UHC-43655-69•••-••-1033467-225-8196—1127 Palm Drive #815·DenverCO80204GRP-0884MEDICARE-ADV-A
ENRENR-140884 2026-09-08T12:16:53Z·JENNIFER—FERNANDEZNov 26, 1996··—•••-••-6896+1 497 591 2191JENNIFER.FERNANDEZ46@PROTON.ME5119 Grand AveSan AntonioTX78217GRP-5979NAVIGATE-HMO
ENRENR-1145062026-10-10T08:10:23Zluis··clark1983-08-07UHC-84938-13•••-••-67914297624luis.clark@aol.com8275 Church St #723COLUMBUS··oh43264GRP-0772medicare-adv-b
ENRENR-1038092026-10-16T23:50:06ZNatalieSGommez1995-02-13UHC-66938-15•••-••-7621796.851.7045natalie.gomez38@yahoo.com7200 Harbor BlvdMinneapolisMN55438GRP-7040MEDICARE-ADV-B
ENRENR-1370272026-02-28T01:46:25ZDenise—Lopez1943-02-06UHC-27821-65•••-••-6303—null1337 Sage CtScottsdaleAZ85206GRP-4990OPTIONS-PPO
ENRENR-1131402026-03-16T12:33:07ZReid, LindaB—1978-11-23UHC-35716-54•••-••-0487·486-233-9430··6383 Market StreetTempeAZ85242-6937GRP-1524NAVIGATE-HMO
ENRENR-1046802026-05-03T12:56:24ZMary—Edwards1949-09-06UHC-73331-86•••-••-9533NULLUNKNOWN7363 FOREST AVEMiamiFL33176GRP-1546NAVIGATE-HMO
ENRENR-1251832026-09-19T20:40:03ZTERRY——1994-07-21·UHC-97302-84•••-••-38323747824898terry.sims@outlook.com1875 INDIAN SCHOOL RDDallasTX75254GRP-8580MEDICARE-ADV-B
ENRENR-1183992026-05-07T15:44:07ZANNL.MENDEZFeb 12, 1964UHC-31441-46—(316) 848-9959ANN.MENDEZ@HOTMAIL.COM9039 Hillcrest RoadPlanoTX75042GRP-9829MEDICARE-ADV-B
ENRENR-1127132026-05-29T07:53:40ZDylan··—·Berry1983-09-18UHC-73876-98UNKNOWN8685107101—7702 Harbor BlvdPlanoTXNULL·GRP-6924·SELECT-EPO
ENRENR-1041312026-09-04T03:30:07ZDouglasSTran1989-11-23uhc-80256-41•••-••-1780340-277-8579NULL3176 Jefferson AvenueSan DiegoCA92141GRP-7052OPTIONS-PPO
ENRENR-1304602026-07-10T14:08:22ZJames—SmithSep 1, 1960UHC-01630-29•••-••-0269(288) 634-9456-·5082 Desert Sky BoulevardAtlantaGA30332GRP-9165NAVIGATE-HMO
ENRENR-1361922026-03-26T00:05:42ZAlice U.—Davis2002-06-01UHC-14521-52•••-••-3221UNKNOWNalice.davis@icloud.com··6411 DESERT SKY BOULEVARDMiamifl33108-1228GRP-3257··CHOICE-PLUS-PPO
ENRENR-1369952026-04-16T22:21:06ZDanielleB.Snyder01/22/52UHC-99715-48•••-••-2231(440) 898-5301danielle.snyder@hotmail.com2495 MESA DRIVETempeAZ85248GRP-6973CORE-HMO
ENRENR-1212412026-02-25T22:54:36ZTurneer, EugeneQ—1999-11-14UHC-36409-32•••-••-4342(452) 850-2747eugene.turner@proton.me5304 APACHE BLVDLas VegasNV89113·GRP-8732SELECT-EPO
ENRENR-1169152026-04-23T18:47:28ZWard, Hiroshi——1948-09-11UHC-38573-73•••-••-806415685421715NULL8831 MAPLE AVENUEGILBERTAZ·85279GRP-5690MEDICARE-ADV-A
ENRENR-1124482026-08-08T07:54:24ZJERRY—ANDERSONDec 25, 2006UHC0229666•••-••-2077+1 755 700 9346·jerry.anderson@aol.com5218 Lake View RoadSan Antonio·TX78227GRP-4348MEDICARE-ADV-A··
ENRENR-109798 2026-03-25T21:19:28ZCHERYL—MURPHYOct 27, 1980UHC-27069-71•••-••-9345(295) 904-7310-3441 Oak StNashvilleTN··37202GRP-3621SELECT-EPO··
ENRENR-1058332026-01-09T01:37:07ZJeffreyVJordan1968-06-26UHC-70105-62•••-••-3750UNKNOWNUNKNOWN5488 Canyon RoadATLANTAGA30389GRP-1080NAVIGATE-HMO
ENRENR-1000762026-05-03T06:45:57Z·JACK—SIMS12/7/1988UHC-53521-04•••-••-2820(711) 223-8107JACK.SIMS48@GMAIL.COM580 Lincoln Way·GilbertAZ85258GRP-6324CHOICE-PLUS-PPO
ENRENR-1188362026-01-11T14:39:58ZSTEPHANIE—MEJIA1984-11-12··UHC-10286-01•••-••-6978(564) 847-6984stephanie.mejia69@gmail.com3840 HIGHLAND AVEGlendaleaz85383-8540GRP-2531·MEDICARE-ADV-B
ENRENR-1384342026-06-12T22:43:18ZRAY—RICHARDS1962-10-21UHC-30938-76•••-••-1929518.384.0984raymond.richards@aol.com·4610 Union StCHARLOTTENC28270GRP-7104MEDICARE-ADV-A
ENRENR-1039082026-05-12T08:04:47ZCHRITSIAN—POWELLOct 20, 1951UHC-89584-18•••-••-04495026916416christian.powell@outlook.com5482 Union StreetScottsdaleAZ85228-7532GRP-2972·NAVIGATE-HMO
ENRENR-1034162026-04-05T15:27:33ZCherylFVasquez1997-07-02UHC-07968-99•••-••-5924(868) 569-1985cheryl.vasquez8@proton.me6164 Jefferson AvenueHoustonTX77061GRP-6318CORE-HMO
ENRENR-1088852026-01-15T01:55:03ZLISA··V.BLACK2004-02-19·UHC-99966-50•••-••-13349313676743-9421 Grand AvenueSacramentoCA95815GRP-2173SELECT-EPO
ENRENR-1184282026-04-16T17:58:02ZJOSHVGRIFFIN1983-10-16UHC-65735-65•••-••-39707497250019joshua.griffin22@gmail.com4411 APACHE BOULEVARDPhoenixAZ85006GRP-6412··MEDICARE-ADV-A
ENRENR-1088792026-05-14T01:14:12ZBobbyPFowler05-05-1992·UHC-04956-87—326.680.8727BOBBY.FOWLER86@OUTLOOK.COM7072 HARBOR BLVDPLANOTX75045GRP-3219MEDICARE-ADV-B
ENRENR-1027792026-06-15T14:32:39Z Alexis—Mejia2000-68-18UHC-10534-16•••-••-4995N/ANULL530 Baseline RoadTucson·az—GRP-9883·NAVIGATE-HMO
ENR ENR-1094732026-06-07T05:58:43ZMATEO··GKELLY1944-02-18UHC-31865-88•••-••-7564911-999-9247mateo.kelly@yahoo.com8436 Pine DriveCharlotteNC28215GRP-3718MEDICARE-ADV-B
ENRENR-1139802026-05-02T13:22:23ZHolmes, AnthonyC··—14-10-1952UHC-53979-37NULL(816) 674-0284anthony.holmes25@outlook.com3009 SAGE COURTDenverco80255GRP-5651·CHOICE-PLUS-PPO
ENRENR-1415232026-07-02T03:49:48ZDOUGLAS—ALEANDER2006-09-15UHC-59235-15•••-••-5322280-637-9105DOUGLAS.ALEXANDER@AOL.COM2798 Harbor Blvd··Eden PrairieMN55388GRP-6995OPTIONS-PPO
ENRENR-1112342026-04-12T16:20:04ZTyler—Thomas08/01/1948UHC-19916-14•••-••-963417237238977null6416 PINE DRSAN ANTONIOTXNULLGRP-5566NAVIGATE-HMO
ENRENR-122969 2026-04-16T18:22:45ZANNAM·POWELL1946-10-25··UHC-86202-91•••-••-31793936651404ANNA.POWELL49@ICLOUD.COM5670 Canyon RoadCharlotteNC28255-2897GRP-9449SELECT-EPO
ENRENR-1337802026-07-22T10:56:08ZAlice·IHunter2006-08-21UHC-81231-21•••-••-6407-ALICE.HUNTER@OUTLOOK.COM—N/AUNKNOWN-GRP-0622OPTIONS-PPO
43,101 rows, page 293 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:43.454Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty