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
ENRENR-117333 2026-09-24T17:55:39ZJames, Junathan·O—·1965-04-14UHC-64223-13•••-••-6273····-4591 Mesa Drive··San AntonioTX78288GRP-8076CHOICE-PLUS-PPO
TPATPA-504652026-06-10T17:26:55ZMelissaMMoreno09/17/2000N/A-N/Anull7186 Lake View RoadChandlerArizona85207UNKNOWNOPTIONS-PPO
ENRENR-1188252026-02-16T20:09:17ZbradleyFwarren09/15/1949UHC-68145-62•••-••-3569(381) 430-4989bradley.warren3@icloud.com8313 Sage CourtLas VegasNV89170GRP-7637OPTIONS-PPO
TPATPA-56442 2026-10-14T19:59:44ZMartinez, Jacob——2005-03-05—-··UNKNOWNjacob.martinez31@proton.me·922 Camelback RoadDallasTX··75258····—
CLMCLM-4079272026-01-12T23:39:19ZJEREMY—REYES1973-02-03UHC-87372-54null5131662UNKNOWN5668 CHURCH STTempeAZ85276GRP-2281··
ENRENR-1375072026-07-24T12:23:08Z Jacubs, LauraZ—03/21/1985UHC-87411-82•••-••-4240·7919226255laura.jacobs19@outlook.com··2503 Lincoln WayATLANTAGA30384GRP-5449MEDICARE-ADV-B
CLMCLM-4081372026-04-19T22:45:13ZJOSEPH—SCOTT1975-08-21UNKNOWN•••-••-7139(427) 689-1203joseph.scott10@aol.com7502 Desert Sky BoulevardAustinTX78761GRP-1972null
CLMCLM-4153962026-06-04T09:08:55ZKATHYNWATKINS5/26/1972UHC-19886-37NULL18113903013-630 DESERT SKY BOULEVARDCharlotteNC28297-2727GRP-5006OPTIONS-PPO
CLMCLM-4048822026-09-26T13:08:03ZKayla—Williamson07/14/2008null•••-••-1974+1 443 244 6373———UNKNOWNUNKNOWNGRP-0637CHOICE-PLUS-PPO
ENRENR-1358982026-01-03T13:33:23Zadam—richards2008-09-20UHC-56502-17•••-••-0405(776) 455-7343adam.richards80@aol.com1893 Sage CourtMiamiFL33111GRP-4345NAVIGATE-HMO
CLMCLM-4186652026-05-25T03:57:43ZGary—Brown1950-01-24UHC-63458-01•••-••-5967(458) 847-6731gary.brown@gmail.com5247 Jefferson AvenueTucsonArizona··85789—null
ENR ENR-1250672026-07-22T18:34:16ZPATRICIAH.ALLEN20020827·UHC-01447-36•••-••-4516414-645-9706N/A2191 CEDAR LN··CharlotteNC28254GRP-9729··core-hmo
TPATPA-527142026-01-02T18:21:03ZJudith—Dunn1969-02-18··NULLN/A(425) 719-8931··3345 Meadow LaneAtlanta·GA—GRP-5103NULL
CLMCLM-4259852026-10-11T08:12:51ZMichelle—JimenezSep 17, 1994——(656) 389-8913null5351 HILLCREST ROADScottsdaleAZ85255—NAVIGATE-HMO
CLM CLM-4304082026-05-05T00:06:06ZLUCIA—CAMPBELL·1990-05-09UHC-20371-54null-—8774 Maple AveFresnoCA93723··GRP-0849CHOICE-PLUS-PPO
ENRENR-123287 2026-10-15T04:50:28ZHarrison, SophiaH—1964-02-25UHC-44046-20•••-••-2848+1 881 482 5729sophia.harrison47@outlook.com···1060 Grand AvePhoenixAZ85096-7425GRP-4660MEDICARE-ADV-B
TPATPA-582242026-03-19T21:13:54Z EDWARD—RUSSELL1991-02-21—-9966099·edward.russell@outlook.com7133 Meadow LnTucsonAZ85795GRP-3858·NULL
ENRENR-1244642026-02-26T15:47:55ZDORISGJACOBS1/16/2000UHC-45965-80•••-••-9953—doris.jacobs@proton.me4453 Baseline RoadCHARLOTTENC28287GRP-6430options-ppo
CLMCLM-4048752026-07-24T22:18:07ZJerry—Hawkins—UHC-79567-63•••-••-45769046466195-——--GRP-6335NULL
ENRENR-1346032026-02-21T06:01:43Zcarol····grant13-07-1939UHC-58128-35N/A(256) 377-8166carol.grant88@outlook.com9824 Sunset BlvdSan DiegoCA·92139GRP-3592CHOICE-PLUS-PPO
ENRENR-1344842026-01-17T05:52:52ZPerez, CherylH··Apr 1, 1963UHC-28681-13-6088639791CHERYL.PEREZ93@YAHOO.COMnull-——GRP-9511NAVIGATE-HMO
CLMCLM-4225722026-03-13T13:44:12ZCARL—BURNS08-04-1967UHC-58968-04NULL5543241443UNKNOWN8720 Highland AvenueGlendaleAZ85393null—
ENRENR-1058702026-08-16T19:01:22ZGerald····Mitchell1951-04-24UHC-05369-83•••-••-36124477314017gerald.mitchell61@outlook.com551 Park PlSan DiegoCA··92117GRP-6168··SELECT-EPO
ENRENR-1422852026-04-04T05:49:19ZHelen—Green1990-05-19UHC-47620-65•••-••-9059·NULLhelen.green@aol.com1088 SPRING STGlendaleAZ85354·GRP-2981SELECT-EPO
ENRENR-1018282026-04-02T21:38:11ZCATHERINE—MARSHALL19591217UHC-98347-36•••-••-8472486-866-1722catherine.marshall22@yahoo.com8409 Desert Sky BlvdDALLASTX75231GRP-6542MEDICARE-ADV-B
ENRENR-1070882026-09-14T20:36:09ZWarren, Ryan——8/13/1946UHC-88581-01null219-583-5859ryan.warren@yahoo.com243 Sunset BlvdNashville··TNNULLGRP-8970CORE-HMO
TPA TPA-595022026-08-18T01:59:21ZsaraGhoward04/09/1967-UNKNOWN(970) 229-8746NULL4495 Union StreetSan AntonioTexas78244····—
TPATPA-630782026-05-08T15:14:55ZDORIS··—JAMES1972-03-15null•••-••-7263N/A··N/A9312 PINE DRIVEGlendale··AZ85359·NULLnull
CLMCLM-4159842026-02-23T09:01:15ZYuki··Porter1995-02-05-—-—8028 Mesa DrFresnoCA93749··GRP-3009CORE-HMO
CLMCLM-4151462026-01-08T16:20:00Z·CAROL—RAMIREZ23-09-1944-—UNKNOWN—1707 Maple AveMINNEAPOLISMN55464GRP-8170NULL
CLMCLM-4123072026-09-15T07:32:03ZIsabella—Black·09/02/88·NULL•••-••-7548868-657-4633—521 Spring StreetSan DiegoCA92104GRP-9725SELECT-EPO
ENRENR-1059422026-02-27T13:25:39ZGaryP.BurkeMay 22, 1963UHC-88412-98•••-••-579815097344875gary.burke@yahoo.com2576 Lake View RoadMiamiFL33128GRP-1792MEDICARE-ADV-A
ENR ENR-1065072026-02-26T07:12:18ZDenise—Johnston19520212UHC2027955•••-••-4330·912-528-1888N/A5325 BASELINE ROAD··JacksonvilleFL32210GRP-0543SELECT-EPO
TPATPA-530012026-04-28T22:41:32ZMary—Cox1963-06-09····N/A-N/A2441 Canyon RdEden Prairie··MN55375—CHOICE-PLUS-PPO
ENRENR-1234082026-02-25T15:07:20Z rogerHnelson14-06-1989UHC-31937-38•••-••-2695968-475-8967-9244 MOUNTAIN VIEW DRMiamiFL33198·GRP-0484OPTIONS-PPO
CLMCLM-4236112026-01-27T06:57:28ZMEI—CARTERJun 24, 1992UHC-88572-18NULL467-259-4055NULLUNKNOWN—UNKNOWNnullGRP-3826NULL
CLMCLM-4299772026-03-03T11:24:36ZJacob····Jordan09/08/1958-•••-••-5760NULLnull5985 LAKE VIEW ROADMiamiFL·33131GRP-3068-
CLMCLM-4177582026-02-04T03:51:50ZRIOS—ZACHARY1949-06-20UHC-47072-78N/A(698) 218-4977UNKNOWN9062 LINCOLN WAYSacramentoCA95887GRP-7232··NAVIGATE-HMO
PRVPRV-234342026-07-20T00:39:08Z·RobertQDay1942-07-06····N/A(303) 422-4257—5242 River RoadScottsdaleAZ85251-··-
CLMCLM-4320692026-10-12T00:40:36Z·SHIRLEY—BOYD1972-08-14··UHC-95505-65•••-••-6664N/AN/A3550 Ridge RdHoustonTX77024GRP-7640UNKNOWN
CLM CLM-418767 2026-09-08T10:46:31ZSEAN····REYNOLDS1989-10-25UHC-33152-78—578-288-1671N/A7232 BROADWAYCharlotte··North Carolina··28298-9579UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4268632026-09-21T23:42:51ZEUGENE··—CRAWFORD05/05/1954··UHC6670690—9867989533N/A6267 Broadway #435ScottsdaleAZ85277GRP-1528··—
ENRENR-1346552026-01-09T01:32:17ZDENNISN.·PATTERSON1969-03-28UHC-31263-30•••-••-9034953-519-8192··dennis.patterson@hotmail.com3295 Market StreetEden PrairieMN55374-9444GRP-1889OPTIONS-PPO
ENRENR-117297 2026-08-07T22:29:31ZMasonXRice1993-10-07UHC1752408•••-••-8096(296) 204-6244····7281 Hillcrest Rd Apt 28ScottsdaleAZ85237·GRP-1123NAVIGATE-HMO
ENRENR-1303652026-07-10T08:15:10ZSanchez, RobertM—9139-12-19UHC-14192-84-472-831-9605robert.sanchez@icloud.com3138 MEADOW LN··JacksonvilleFL32254GRP-9841NAVIGATE-HMO
PRVPRV-230842026-06-27T18:52:10Z·SOFIIA—WABB1956-09-14UHC-71462-42-—N/A3993 Highland AveOrlandoFL32802—N/A
CLMCLM-4141182026-09-06T00:53:51ZDENNIS—SPENCER01-01-1979—•••-••-3777894-970-3973—4568 Church StMinneapolisMN—GRP-9564—
TPATPA-643832026-04-30T07:33:16ZCHHRISTINA····WILLIAMS1996-12-21-UNKNOWN442-752-5175—9383 OCEAN AVENUETucsonAZ85705GRP-1370OPTIONS-PPO
ENRENR-1085562026-04-21T17:48:57Z·BobbyJMatthews05/04/1973UHC-97499-90—866-745-4117-nullNULLN/A—GRP-6800medicare-adv-a··
ENRENR-1093292026-06-07T02:56:17ZMateo—Kelly1947-07-10UHC-38908-32•••-••-71834894443862mateo.kelly85@proton.me··9270 ELM STREETSan DiegoCA92165GRP-5728OPTIONS-PPO
100,000 rows, page 51 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:34.779Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty