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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-559852026-06-18T11:32:54Z·Natalie—Bell03/27/05—N/A—NATALIE.BELL87@YAHOO.COM7886 Mountain View DriveCharlotte··NC28264-2504GRP-2900··CHOICE-PLUS-PPO
ENRENR-1309832026-02-05T00:25:50ZDEBORAHDHENDERSON2008-03-10UHC-53868-27—828-251-6961deborah.henderson41@aol.com2283 Grand AvenueScottsdale··AZ85238GRP-2141MEDICARE-ADV-B
TPATPA-627822026-10-11T07:42:42ZDonald—Cooper11-03-1989UHC6218844N/A(575) 698-7106—4619 Central AveLos AngelesCA90000—-
PRVPRV-269792026-07-23T04:01:26ZJanice—Banks22-06-1964UHC-81252-69null(721) 618-3607—·6376 CHURCH STREETScottsdaleAZ85275N/A—
ENRENR-1190312026-01-30T11:42:40ZMatthewXKelly1941-12-05UHC-89605-89NULL367-569-1046matthew.kelly89@proton.me8350 Lincoln WayGilbertAZ85281··GRP-8514··CHOICE-PLUS-PPO
ENRENR-1306762026-04-23T05:15:51ZJAMES G—SMITH··1942-08-18UHC-49345-21•••-••-12617345710297james.smith70@outlook.com3221 OAK ST·CHANDLERAZ85242GRP-7928CHOICE-PLUS-PPO
ENRENR-1128102026-02-04T20:01:49ZDianeIPerry1972-06-28UHC-44965-89•••-••-87282063760734diane.perry@proton.me5899 UNION STREETPhoenixAZ85095GRP-6166core-hmo
CLMCLM-4009572026-01-07T03:40:17ZAndrew—Harper24-03-1978UHC1560356—943-840-0787UNKNOWN·null·N/AN/A—null—
ENRENR-1141922026-10-14T00:03:51Zkevin—·hill19841128UHC-54389-99•••-••-5892—KEVIN.HILL14@HOTMAIL.COM5466 LINCOLN WAY··NashvilleTennessee37215GRP-0480OPTIONS-PPO
CLMCLM-4252362026-03-22T07:12:05ZBrittany—Morales2003-09-13——309-846-2737—·UNKNOWNnull-nullGRP-1646—
PRVPRV-26329 2026-09-30T21:37:26ZBARBARA—JOHNSTON1974-09-16·UHC-72209-44N/A(580) 422-3914NULL5293 Washington StDallasTX75254-3563UNKNOWNMEDICARE-ADV-B
CLMCLM-4131922026-07-14T08:51:21ZFrank—Salazar09/10/88··UHC-98170-43··•••-••-6862521.212.9491NULL7978 Desert Sky BlvdTucsonAZ85718GRP-5393—
CLMCLM-4283872026-03-29T01:46:59ZHAROLD····MONTGOMERY1944-06-22··nullUNKNOWNUNKNOWNharold.montgomery90@proton.me—UNKNOWNnull-UNKNOWNMEDICARE-ADV-A
CLMCLM-4098862026-02-16T04:29:39Z Bobby—Ferguson1954-07-24null•••-••-8083nullUNKNOWN·541 HILLCREST RDOrlandoFL32896GRP-0199CHOICE-PLUS-PPO
ENR ENR-1129092026-01-19T01:55:15ZFerguson, Jeremy——04/14/1959UHC-63513-38•••-••-4431412-871-2018null4716 Indian School Rd·DALLASTX75299GRP-2599CORE-HMO
CLMCLM-4070982026-03-21T02:22:51ZGeraldYWagner19820205UNKNOWN—(627) 946-8172-9744 River RdCharlotteNC··28269GRP-4177MEDICARE-ADV-B
ENRENR-1228402026-08-20T15:27:10Zelizabeth—gibson··1501-59-55UHC-53210-52•••-••-3301+1 333 833 1944ELIZABETH.GIBSON13@HOTMAIL.COM833 Sage CtTampaFL·33661-8992GRP-1940SELECT-EPO
PRVPRV-285402026-04-19T23:22:51ZJESSE—BELL01/06/83null•••-••-1018328-207-5003-6700 SPRING STREETOrlandoFL32859-5741UNKNOWNMEDICARE-ADV-B
ENRENR-1046172026-06-21T11:30:46ZGregoryT.Elliott16-08-1961UHC-34661-18•••-••-2129316.876.2135GREGORY.ELLIOTT57@GMAIL.COM·1131 Central AvenueAtlantaGA30332·GRP-3310OPTIONS-PPO
PRVPRV-268162026-10-06T07:49:38ZDennis—Phillips1996-12-07-—17066237718··—·725 Grand Ave·OrlandoFL32822UNKNOWN—
ENRENR-1218132026-07-28T06:24:55ZLAWRENCEJ·WILLIAMS1987-07-11UHC-68040-19•••-••-5602898.880.4967lawrence.williams@icloud.com7519 Highland AvenueMinneapolisMN55461GRP-7995MEDICARE-ADV-B
ENRENR-1096592026-03-08T10:13:36ZMelissaW.Hayes··2006-10-23UHC-64851-11•••-••-015313796977814melissa.hayes54@proton.me5383 BroadwayDallasTX75269··GRP-8159medicare-adv-b
TPATPA-603242026-05-07T18:25:38ZJames—Smith1942-08-18—null734-571-0297—3221 OAK STChandleraz85242-UNKNOWN
CLMCLM-4163612026-07-20T04:00:47ZBetty—Rodriguez··-··-•••-••-8549—null9758 Forest AvenueHouston··TX77037GRP-6165null
CLMCLM-4155522026-05-31T21:47:15ZGREGORY—HOWARD1941-03-20UHC-16734-85NULLnull—101 Main St Apt 34TucsonAZ85777GRP-9645null
ENRENR-1175612026-05-25T08:42:25ZKyle··Rogers1963-06-16UHC5821307NULL329.936.1596kyle.rogers12@aol.com-—UNKNOWN—GRP-3532NAVIGATE-HMO
CLMCLM-4106712026-05-03T13:29:34Zmichael—lopez1963-01-09——650-290-7866-·578 Willow CourtHOUSTONTX77082UNKNOWNCHOICE-PLUS-PPO
TPATPA-564372026-04-20T11:14:00ZdouglasZ—1972-11-26—-—·NULLnullN/A—N/AGRP-8362—
CLMCLM-4250532026-06-11T14:57:34Z·MarkY·Hughes03/17/41—UNKNOWNUNKNOWNUNKNOWN··null-—N/Anull
ENRENR-1192692026-09-23T00:33:25ZKellyHKim1957-09-20UHC-11790-26•••-••-6292(942) 756-6630—7517 Main StSEATTLEWA98168GRP-0887CORE-HMO
TPATPA-643102026-08-21T17:12:07ZMei··QHowlel19610412UHC-44146-28•••-••-40939004678163null3682 Spring StLas VegasNV89135null··
CLMCLM-4021252026-03-22T13:49:33ZISABELLACDOMINGUEZ2002-03-04—•••-••-9188N/Aisabella.dominguez@yahoo.com5677 Sunset BoulevardLOS ANGELESCA90082N/ASELECT-EPO
ENR ENR-1232472026-06-25T02:35:56ZReynolds, WillieZ.—5/24/1995UHC-16629-32•••-••-2128280-361-2670willie.reynolds27@yahoo.com5688 Ridge RdCHARLOTTENC28293-8781GRP-3993OPTIONS-PPO
TPATPA-537972026-07-20T18:39:20ZDonald—Chavez1993-03-06—UNKNOWN9114512278··—null—··—NULLN/A
PRVPRV-264902026-04-30T13:12:02ZNOAH—WRIGHTJun 4, 1960UNKNOWNNULL7834840937—7972 HILLCREST RDScottsdaleAZ85253N/Anull
TPATPA-555392026-10-17T04:21:26Z KATHY—BROWN1994-08-14UHC-43169-47N/A(746) 922-8012KATHLEEN.BROWN61@ICLOUD.COM3092 Sage CtOrlandoFL32854-2607····N/A
ENRENR-1038642026-10-07T17:49:07Z CarolynSWard2004-03-16UHC5902532•••-••-5069516-229-7629carolyn.ward6@outlook.com9472 Desert Sky BlvdChandlerAZN/AGRP-0864MEDICARE-ADV-B
ENRENR-1114802026-10-08T11:35:30ZCARLOSPLI07/08/1979uhc-60268-18•••-••-48329654796057CARLOS.LI40@HOTMAIL.COM8294 Grand AvenueJacksonvilleFL32266GRP-7399CHOICE-PLUS-PPO
ENRENR-1194252026-08-07T03:51:55Z AHMEDE.OLSON06/22/64UHC-42356-94•••-••-27318796669696ahmed.olson@hotmail.com2114 BAYSHORE DRIVESan DiegoCA—GRP-7064CHOICE-PLUS-PPO
ENRENR-1428682026-01-01T06:36:44ZRICHARDHPERRY1963-03-20·UHC-85723-78•••-••-1568(689) 505-6331richard.perry@icloud.com1196 PARK PL·AtlantaGA30302GRP-2940SELECT-EPO
TPATPA-510932026-05-07T08:26:38ZKELLY—CARTER1964-06-03——7283671484N/A405 Maple AvenueSan AntonioTX78269-5413··nullUNKNOWN
ENRENR-1322272026-02-03T22:06:57ZValentina—Kennedy1943-08-06UHC-03137-73•••-••-96183525145253·N/A5500 Ocean AvenueGlendaleAZ··85369GRP-3682SELECT-EPO
ENRENR-1226752026-10-08T16:33:12ZOmarHAdams1972-10-03UHC-62737-71•••-••-09666619210110N/A8093 Canyon RoadSAN ANTONIOTX78234··GRP-2864SELECT-EPO
TPATPA-508902026-05-14T20:38:13ZRaymond—Hart·1973-03-08NULL•••-••-5927NULLnull——··-—MEDICARE-ADV-A
CLMCLM-4282862026-09-24T06:16:25ZMARK—GUZMAN··19530407UHC-53643-04•••-••-22472234040992mark.guzman8@aol.com9499 Forest AveScottsdaleAZ85292—NULL
ENRENR-121835 2026-04-30T12:58:07ZLOGANOALVARADO07/02/97UHC-87265-64•••-••-0880828-813-9378logan.alvarado53@proton.me8314 Bayshore DrLos AngelesCA90058GRP-3493SELECT-EPO
ENRENR-1133852026-08-25T22:19:05ZLAUREN—GUTIERREZ1989-01-04UHC-74527-12•••-••-8769·854-588-2955·lauren.gutierrez@gmail.com9548 BroadwayORLANDOFL·32831GRP-1733NAVIGATE-HMO
ENRENR-1306162026-08-15T03:53:03ZBrown, HannahO.····1943-07-08UHC-97609-23•••-••-5094·(294) 811-0191—8925 Church StNashvilleTN37299GRP-2481MEDICARE-ADV-B
CLMCLM-4206842026-04-20T00:18:44ZBILLY—RAMIREZ1964-04-15UHC-43295-81—970.534.3969billy.ramirez@icloud.com773 Union StreetCharlotteNC28213GRP-7635·OPTIONS-PPO
CLMCLM-4274022026-05-05T16:38:42ZAMY—·GONZALEZ1985-04-03UHC-77693-65NULL14562595912N/A6841 RIVER RDSAN DIEGOCA92119NULL—
100,000 rows, page 136 of 2,000PreviousNext

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.693Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty