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-1194352026-08-17T12:39:41ZCAAROL—PETERS1985-03-27·UHC-96890-16•••-••-2371355-356-6629—9826 Baseline RdSan AntonioTX78215-5176GRP-1735CHOICE-PLUS-PPO
CLMCLM-4044492026-05-09T21:19:41ZJustin—Crawford10/08/82····NULL-N/A3216 Park Pl··HOUSTONTX77003·GRP-6280SELECT-EPO
TPATPA-506002026-08-07T08:38:56Zeric—cole1992-11-06UNKNOWN—(612) 389-1797UNKNOWN360 Apache BlvdTempeAZ85296—SELECT-EPO
ENRENR-1173152026-02-18T23:01:47ZStevenO.Wagner··1938-02-24UHC-58486-02•••-••-2915264-943-2064null2800 Highland AvenueLos AngelesCA90059GRP-4122CORE-HMO
CLMCLM-4288882026-10-03T15:07:34Z AMBER—SANDOVAL06/05/65UHC-51743-96•••-••-5777——6060 SUNSET BLVD·FresnoCA93764GRP-7380NAVIGATE-HMO
CLMCLM-4144362026-10-15T23:49:35ZWei—Washington18-12-1938N/A-UNKNOWNNULL——NULL—GRP-2179NAVIGATE-HMO
CLMCLM-4098292026-03-08T22:26:24Z Lewis, RogerK.—1952-04-16····UNKNOWN(944) 844-5964——UNKNOWN-NULLGRP-9621-··
ENRENR-1240602026-02-27T09:12:29ZtylerR·wng2006-10-02UHC4430251-5778173676tyler.wong19@outlook.com3487 BroadwayGilbertArizona85223GRP-3432·MEDICARE-ADV-A
CLMCLM-4277262026-06-05T04:18:29ZJulie··—Reynolds02/23/1973UHC-34699-95UNKNOWN(916) 276-5095julie.reynolds@aol.comN/ANULL—N/AGRP-3798N/A
ENRENR-1375982026-05-23T15:34:41ZRalph—Arnold1998-08-26UHC-79978-65•••-••-99123792078RALPH.ARNOLD24@GMAIL.COM1334 Jefferson AvenueSan AntonioTX78254GRP-9752CHOICE-PLUS-PPO
ENRENR-1412142026-07-03T12:25:13Zjoan—ruiz1955-05-01··UHC-01996-90•••-••-3850914.751.1705joan.ruiz@outlook.com3273 Ridge RoadColumbusOH43212GRP-0462NAVIGATE-HMO
ENRENR-1103952026-06-15T15:40:13Zphilip—ryanDec 10, 1967UHC-79440-41•••-••-3722592-310-3303null8311 Highland AveLas VegasNV89114GRP-2375core-hmo
CLMCLM-4227032026-05-04T11:58:11ZDUNNALOLIVER1964-01-19NULL—(618) 872-9640UNKNOWN5562 BROADWAYSeattleWashington98176··UNKNOWNNULL
TPATPA-561012026-09-26T08:44:13ZAmanda—Johnston1994-09-04N/A•••-••-4665·16613493211null4504 Valley View Dr #504ScottsdaleAZ85253nullN/A
CLMCLM-4120262026-08-21T19:16:59ZKENNETH—HARRISON1961-04-04UHC-81468-72———1680 Lake View RoadLas VegasNV89177GRP-5886NAVIGATE-HMO
CLMCLM-4040412026-05-25T04:04:10ZMeyer, Bruce——03/22/64··UHC-94064-25-——1979 JEFFERSON AVENUE #151HoustonTX77031NULLNAVIGATE-HMO
PRVPRV-24953 2026-04-17T23:18:28ZMark··Mills1962-04-06—-647-742-3538mark.mills89@outlook.com5792 BroadwayGlendaleAZNULLnull-
TPATPA-573112026-02-03T16:20:05ZWAYNE—BAILEY07/10/2007··—UNKNOWNNULLN/A8816 Forest AvenuePhoenixAZ85017-9136—N/A
ENRENR-1162402026-07-02T05:29:58ZKelly—Butler06-02-1962UHC-76133-16•••-••-4248300.928.5640kelly.butler@proton.me1324 HILLCREST RDMiamiFL33130GRP-6686MEDICARE-ADV-B
ENRENR-1273272026-01-03T05:47:12ZSndra—Patel1950-01-10UHC-84344-21•••-••-2702788-894-6895sandra.patel@outlook.com5464 Canyon RoadMiamiFL33101-8521GRP-4500SELECT-EPO
TPATPA-593772026-06-17T18:37:19ZPaul—Payne19490604nullnull381-535-2733null1440 MESA DREden PrairieMNnull—····
ENRENR-1082662026-01-24T21:27:06Z—C—08-10-1953··UHC-26846-56•••-••-8617941-528-2095MATEO.JACOBS19@GMAIL.COM3747 Ocean AvenueSan AntonioTX78246GRP-8725NAVIGATE-HMO
CLMCLM-4130972026-08-29T09:42:19ZSarah—Tucker1943-09-21UHC-46506-60NULL··556-355-7300UNKNOWN8369 Mountain View DrSacramentoCA·95819—NAVIGATE-HMO
TPATPA-641482026-09-09T10:07:53ZBOBYB—BAILEY1943-08-01null-····NULL2275 Baseline Road Apt 37PLANOTX··75032—NULL
ENRENR-1249652026-02-07T17:52:20Z·Peter··Washington1951-06-03UHC-58356-44•••-••-704018408904613··-5478 Church StreetAustinTX78794GRP-5153NAVIGATE-HMO
ENRENR-1302212026-01-08T04:40:48ZOLIVIA—COOPER1981-09-05UHC-66987-31•••-••-15926877811662—·683 Bayshore DrMinneapolisMNN/AGRP-4230CORE-HMO
CLMCLM-4132732026-05-28T22:15:46ZJoe—Peters1999-06-14UHC-86752-62——--NULLN/AUNKNOWN—NAVIGATE-HMO
CLMCLM-4147302026-01-08T01:45:20ZAngela—Perkins19400604UHC-30106-31··—(271) 997-1511····4170 Oak StreetPlanoTX75017GRP-3861null
ENRENR-1402452026-09-15T00:41:25ZSANDRA··MMCCOY··1999-11-15UHC-43501-97•••-••-4873268-818-3877sandra.mccoy@gmail.com2098 Camelback RdScottsdaleAZ85282GRP-1237··OPTIONS-PPO
CLM CLM-4152412026-08-06T23:39:46ZannKgonzaez27-10-1960null··•••-••-43132788362292———N/ANULLUNKNOWN—
ENRENR-1307212026-03-15T02:40:22Z BILLYAWATKINS19901107UHC-49351-53•••-••-15555172848724billy.watkins@proton.me4593 RIVER RDLAS VEGASNV··89153GRP-2651··OPTIONS-PPO
PRVPRV-202142026-05-24T04:46:49ZDieo—Holmes05/21/1965—NULL5844510758null5512 Sage Court #596··ScottsdaleArizona85238-2937nullUNKNOWN
ENRENR-1016022026-03-07T01:22:17ZDenise—Young-UHC-41868-77•••-••-37974146877186N/A3958 SUNSET BOULEVARDTampaFL33655GRP-8741CHOICE-PLUS-PPO
CLMCLM-4304982026-10-13T09:49:08Zraymnd—peters08/03/1972··•••-••-3563941-696-2019··—2221 Lake View RdAustinTX78732GRP-6072MEDICARE-ADV-B
ENRENR-1300062026-08-20T03:05:21ZBRANDON—FLORES1953-08-11UHC-82145-28—6908262458brandon.flores@icloud.com·9438 Valley View DriveChandlerAZ85270··GRP-4671OPTIONS-PPO
PRVPRV-285442026-08-04T18:09:46ZAMBER—OLSON1965-06-20—•••-••-533216602446586null1119 Mesa DrTempeArizona85254··UNKNOWN
CLMCLM-4142722026-10-12T20:10:05ZAdamHHrper1995-09-18-··•••-••-5077nullUNKNOWN——N/AUNKNOWN-—
ENRENR-1338182026-03-10T01:25:29ZBETTYWBENNETT1983-07-08UHC-71334-47N/A7785039119BETTY.BENNETT@OUTLOOK.COM5946 Forest AvenueTEMPEAZ85205GRP-7488·NAVIGATE-HMO
CLMCLM-4021462026-10-07T16:36:46ZThomas—Morales··1965-01-26UHC-74441-71NULL7658409003NULL5241 Jefferson AvenueDenverCO80274GRP-0617MEDICARE-ADV-B
ENR ENR-1386752026-01-03T11:27:32ZLORI—HERNANDEZ1996-06-14uhc-45820-26•••-••-0217(582) 250-5650··lori.hernandez@aol.com8190 BASELINE ROADLos AngelesCA90073··GRP-6164OPTIONS-PPO
CLMCLM-4218852026-07-22T00:48:54ZMARTHA—BROWN1957-06-11uhc-05954-71—····NULL6487 River RoadSacramentoCA95893GRP-6015-
ENRENR-1169312026-08-14T01:43:45Z———19890505UHC-37714-69•••-••-8607(462) 349-0761UNKNOWN8237 Central Ave #803DallasTX75216GRP-0774NAVIGATE-HMO
ENRENR-1078892026-09-01T10:21:43ZBrianVPerkins1971-11-22UHC-98944-17•••-••-55068145373716brian.perkins32@icloud.com2848 Sage CourtSeattleWA98188GRP-5563CORE-HMO
CLMCLM-4019242026-08-12T13:40:14ZTERESA—HARVY1995-07-24N/Anull+1 334 783 6443—4064 Palm DrMesaaz85261nullNAVIGATE-HMO
CLMCLM-4120112026-03-20T09:32:30ZCampbell, JoseW—1980-01-09-NULLNULL—5850 UNION STREETJacksonvilleFL·32269GRP-5520NAVIGATE-HMO
ENRENR-1001762026-05-09T10:40:50ZBetty—Weaver19630801UHC-27224-84•••-••-5264513-717-6082N/A662 PALM DRIVEGlendaleArizona··NULLGRP-3047NAVIGATE-HMO
CLMCLM-4072842026-01-26T03:25:19ZDylan—Rojas1974-10-07—NULL812-288-4690null4391 Camelback RoadAustinTX78762GRP-0970··OPTIONS-PPO
PRV PRV-23521 2026-07-02T11:52:04ZBeverly Z—HarrisonMar 11, 1962·UHC7608744null·14336407608—8994 Cedar LaneSacramentoCalifornia95836····N/A
ENRENR-1208052026-06-14T00:11:39ZWayneL.··Ford1970-01-13UHC-66292-19•••-••-0358(922) 311-3570—1973 Palm Drive·CHANDLERAZ85277-9789GRP-4132OPTIONS-PPO
ENRENR-1024742026-09-27T07:47:15Z AishaFWeaver1999-10-25UHC-45713-40UNKNOWN359-327-3458—6879 Jefferson AvenueLas VegasNV89110GRP-6697MEDICARE-ADV-B
100,000 rows, page 72 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.792Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty