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
PRVPRV-259912026-06-27T11:27:09ZFRANCESPVALDEZ1957-04-24UHC-77875-73•••-••-5343·(246) 606-1892FRANCES.VALDEZ67@HOTMAIL.COMNULL———UNKNOWN—
TPATPA-642892026-05-03T23:07:48ZAmanda—Yang1941-10-25UNKNOWN•••-••-0259257-522-3460—7632 Pine DriveDallasTX75255·-MEDICARE-ADV-B
ENRENR-1403492026-04-03T16:46:22ZJudyTKnight—uhc-66791-46·null·621.349.8511judy.knight93@hotmail.com1771 RIDGE ROAD·SCOTTSDALEAZ85284GRP-3235SELECT-EPO
CLMCLM-4039172026-02-09T13:32:57ZWayne··—Marshall05/04/02UHC-10389-42—-NULL8276 Desert Sky BoulevardOrlandoFL32828GRP-3034MEDICARE-ADV-B
PRVPRV-276332026-01-23T21:41:52ZStephanie—Vasquez1949-05-18UHC-25440-72N/A·515-797-0273NULL6735 Central AveSeattleWashington98131——
CLM CLM-4091182026-06-15T19:03:02ZFreeman—Joe2007-11-17UHC-44075-78•••-••-3345UNKNOWNNULL7788 MEADOW LNMIAMIFlorida33128GRP-2533null
ENRENR-1416812026-09-04T21:51:28ZJOE—MATTHEWS22-06-1967UHC-59785-40null-null7710 BroadwayATLANTAGA—GRP-9036MEDICARE-ADV-A
PRV PRV-246672026-10-02T21:11:08ZJerry—Brooks2006-11-13··—(930) 429-1308NULL9445 Market Street··GlendaleAZ··85372NULL·null
CLMCLM-4325012026-01-24T00:01:25ZomarI·bryant1987-03-17UHC-89172-02———-—N/ANULLGRP-8678-
CLMCLM-4039762026-09-19T08:40:28Z·Hannah—Nguyen5/8/1972UHC-20168-56N/ANULLhannah.nguyen@hotmail.com8201 Meadow LnDALLASTX75293——
CLMCLM-4180452026-07-09T03:46:08ZLewis, Jennifer——1973-02-23UHC-67406-74null··NULL—3020 Washington StHoustonTX77090-6295GRP-7767OPTIONS-PPO
ENRENR-1365562026-03-10T02:11:34Z·AnaYBarnes1983-04-19UHC-47145-41•••-••-6267N/AANA.BARNES@HOTMAIL.COM4649 PINE DR Apt 10··ColumbusOH43286·GRP-4899MEDICARE-ADV-B··
CLMCLM-4032882026-06-17T11:59:52Zshirley····harveyDec 25, 1994-•••-••-7377NULL-7830 Pine DrCHANDLERArizona·85217GRP-2524·MEDICARE-ADV-B
ENRENR-1219392026-05-03T12:36:53ZCamila—Romero04/20/41··UHC-45685-14•••-••-6707(396) 804-7708camila.romero45@aol.com6264 Forest AveTampaFlorida33674··GRP-3049CORE-HMO
TPATPA-599542026-05-06T08:53:02Zbetty—cox01/01/44·N/AUNKNOWN—NULL3527 Central AveJACKSONVILLEFL32275—MEDICARE-ADV-B
ENRENR-1257072026-02-14T10:42:05ZGABRIELZ.WARD·1943-02-02UHC-91327-36•••-••-5431330-701-3173gabriel.ward62@outlook.com998 Pine DrSan AntonioTX78250GRP-0276NAVIGATE-HMO
CLMCLM-4269682026-05-11T19:46:03ZChris—Delgado·-NULLnull-····UNKNOWN—UNKNOWN-·GRP-0956·N/A
CLMCLM-415455 2026-07-04T08:29:27ZEugene—Harper1985-02-04·UHC-02390-23•••-••-9657UNKNOWNNULL7637 CENTRAL AVENUECharlotteNC28280NULLCHOICE-PLUS-PPO
PRVPRV-252052026-05-23T03:56:27Zandrew—lawson1940-01-10-··•••-••-75943407428230UNKNOWN··8968 Willow Court #183ORLANDO··FL·32895UNKNOWNNAVIGATE-HMO
ENRENR-1304162026-03-09T12:44:07ZDonnaSRice1949-11-17UHC-89345-39•••-••-5065839-773-7615NULL7748 BASELINE ROAD·GLENDALEaz85314GRP-6516SELECT-EPO
ENRENR-1093482026-01-05T12:37:17Z·RYANM··DUNCAN20021120UHC-30657-74N/A··500-236-3668ryan.duncan@yahoo.com8674 Willow Ct··PlanoTX-GRP-3170CHOICE-PLUS-PPO
ENR ENR-1197742026-03-02T06:19:36ZRobertson, JoyceN—1968-07-26UHC-92098-81··•••-••-5631(663) 767-3916N/A174 CANYON RDCharlotteNC28208GRP-3418CHOICE-PLUS-PPO
TPATPA-553602026-04-29T03:44:07ZLori—Foster1982-11-06-——LORI.FOSTER@ICLOUD.COM·N/A—null—null·-
ENRENR-1348422026-10-18T13:08:49ZAlanP.Holmes—UHC3203580•••-••-79345982509524alan.holmes@icloud.com4324 Baseline RoadMesaAZ85275GRP-5011MEDICARE-ADV-A
TPATPA-520002026-08-19T02:36:44ZJoyce····Roberts1989-04-18—UNKNOWNnull··null7877 Meadow LnGilbertAZ85221—SELECT-EPO··
TPATPA-584792026-10-07T14:00:19ZWilliamson, Kenneth——2005-08-17N/AN/ANULLkenneth.williamson89@aol.com2871 Lake View RdSeattleWA98135-8819—null
CLMCLM-4257702026-09-08T04:13:01ZAdam—Vega1992-02-01UHC-59055-13UNKNOWNNULL—·3499 Canyon RoadChandlerAZ··85205—OPTIONS-PPO
ENRENR-1008832026-07-16T13:29:47ZJUDITTH—CLARK2005-08-21UHC-45844-31-8234827-1289 Elm StJACKSONVILLEFL32201GRP-7581NAVIGATE-HMO
ENRENR-1018492026-10-12T19:40:42ZMurphy, Stephen——11/09/92UHC-54490-83•••-••-4779234-538-4671stephen.murphy32@hotmail.com2604 River RdEden PrairieMN·-GRP-9148CHOICE-PLUS-PPO
TPATPA-602792026-09-07T19:51:00Zjonathan—burke1994-02-09—•••-••-7461UNKNOWN-2114 Spring StDallas·TX—N/A····
ENRENR-1374702026-07-27T02:41:22ZMATTHEWD.SHWA-UHC-20965-71··•••-••-83916278473968MATTHEW.SHAW@AOL.COM1303 OCEAN AVEFresnoCA93793··GRP-3370OPTIONS-PPO
PRVPRV-255602026-01-23T23:47:47Z ·eugene—nunez19690128UNKNOWN-+1 489 935 0703—2385 Mesa DrSacramentoCalifornia95807null··
ENRENR-1153212026-06-25T18:42:53ZSusanEColeman1952-10-13UHC-57625-86•••-••-2138348-477-0801—355 Mountain View Dr·TempeAZ85208GRP-0741CHOICE-PLUS-PPO
PRVPRV-259392026-06-22T16:33:23Zkayla··—richards··01/10/76UHC-42568-66N/A12535320764—2779 Pine DriveDALLASTX75256null-
CLMCLM-4094532026-04-13T16:19:03ZPamela—Yang1945-01-06null•••-••-0593-NULL4873 MARKET STREETDallasTX75230··GRP-7329NAVIGATE-HMO
TPATPA-52573 2026-03-30T10:38:45ZETHAN··LEE19950501nullN/A—NULL··999 Church St·MesaAZ85219··—-
ENRENR-1394792026-09-25T11:26:48ZJason—Smmith1972-06-13UHC-71718-91•••-••-0774255-509-5294JASON.SMITH@GMAIL.COM6480 River RoadGlendaleAZ85315GRP-3630NAVIGATE-HMO
CLMCLM-4034742026-03-19T19:17:09ZKTAHRYN—PIARCE02/21/39UHC9540116•••-••-8786—kathryn.pierce34@gmail.com9528 WASHINGTON ST··Tampafl·N/AGRP-8811CORE-HMO
TPATPA-530842026-10-05T00:41:24ZJanet—McDonald05-06-1982N/A·NULL397.533.7165-5152 SUNSET BLVD··TempeAZ85297····-
PRVPRV-200272026-05-31T05:13:21Z FATIMAA.LYNCH2000-08-22UHC-78829-59UNKNOWN351-868-2231N/A7675 Harbor Blvd··COLUMBUSOH43200NULL·NULL
ENRENR-1382152026-01-11T13:34:04Z CamilaNRios1963-11-18UHC-12493-59··•••-••-37342228906829·CAMILA.RIOS@PROTON.ME3286 Indian School RoadTempeAZ85295GRP-1346core-hmo
ENRENR-1317432026-02-23T17:02:43ZSalazar, William——1969-07-12UHC-91974-52•••-••-9878225-924-8488william.salazar87@outlook.com4437 Valley View DriveNashville··Tennessee—GRP-8327CORE-HMO
CLMCLM-4047302026-03-06T22:15:12ZLuis—JimenezDec 13, 1980UHC-81143-69•••-••-5454null—4600 Forest Avenue··TAMPAfl33661GRP-8007N/A
CLMCLM-4155282026-10-07T21:49:17ZAMYY·WRIGHTJun 1, 1956-—NULLamy.wright@icloud.com295 Meadow Ln #518Tucson·AZ85737GRP-3455NULL
TPATPA-500362026-04-17T17:40:29ZAustinOAguilar1993-07-28··—null—3665 River RoadLos AngelesCA90049-8393—NULL
TPATPA-596372026-03-15T15:26:40ZBEVERLY—VASQUEZ01/13/1980—•••-••-57352784063649—3211 Meadow LnDENVERCO80216GRP-1181—
CLMCLM-4305482026-03-19T05:39:46ZDan····Turner1982-06-20UHC-52643-65•••-••-7408nullN/A5490 Lake View RdTUCSON·az85761N/ASELECT-EPO
CLMCLM-4008222026-05-31T07:14:00ZCarl—OBrien19761012UHC-87879-70··3207359504-3482 Jefferson AvenueMinneapolisMN55456GRP-9229MEDICARE-ADV-B
ENRENR-1353862026-09-03T22:47:25ZMarthaP.Jenkins19870115·UHC-38108-73•••-••-3312294-476-9082MARTHA.JENKINS55@ICLOUD.COM8650 Apache BlvdSacramentoCA95821GRP-5107CORE-HMO
CLMCLM-4140182026-07-23T18:53:43ZMariana R.—Snatiago2006-11-22UHC-36282-56—531-780-7023N/A4386 Jefferson Avenue Apt 23TUCSONAZ·85737UNKNOWNnull
100,000 rows, page 1 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
    line_no records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    loaded_at marks when the row landed in the lakehouse; this batch landed 2026-10-21T12:37:53.957Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty