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
TPA TPA-622172026-09-24T22:18:02ZROY—BURNS1996-01-06UNKNOWNnull····—1170 Church StreetDENVERCO80296UNKNOWNNAVIGATE-HMO··
CLMCLM-4038482026-06-07T12:40:53ZCatherineI·Richardson2005-08-26UHC-15592-78•••-••-48158617857017CATHERINE.RICHARDSON24@ICLOUD.COM2274 CHURCH STREETScottsdaleAZ85238-4162UNKNOWNCORE-HMO
ENRENR-102172 2026-04-13T17:29:49ZMARTHADHARRISON1980-03-26·UHC-15211-78•••-••-86486556061026NULL7138 Lincoln WayDENVERColorado80288-1715·GRP-2987SELECT-EPO
CLMCLM-4047182026-04-03T11:29:22ZSamuel—Johnston1978-02-08NULL———null————-
ENRENR-1147902026-02-11T18:11:19ZStevenM·Phillips1955-03-05UHC-41677-84•••-••-4741617-468-0026··steven.phillips@yahoo.com486 Bayshore DriveNashville·TN37224GRP-7624CHOICE-PLUS-PPO
PRVPRV-292132026-04-22T00:41:01ZRUSSELL—MUNOZ··1963-01-27UHC-30448-14—5286990617russell.munoz44@yahoo.com5968 SPRING STREETSeattleWA98171NULL—
ENRENR-1051642026-08-04T23:53:00ZNoehKJackson1989-03-24UHC-32507-07•••-••-686717162163994NOAH.JACKSON@ICLOUD.COM5598 Bayshore DriveJACKSONVILLEFL·32277GRP-3180MEDICARE-ADV-A
ENRENR-1291652026-01-14T16:33:07ZAndrew—Gerrero07-06-2003UHC-33430-25•••-••-2582(644) 393-3102andrew.guerrero@icloud.com3697 BROADWAYAustinTX78711GRP-6809OPTIONS-PPO
PRVPRV-288902026-09-24T04:14:49ZKayla—·Estrada1996-09-26null•••-••-1376·744-622-2442-9641 Camelback RdTucsonArizona85753·nullSELECT-EPO
ENRENR-1375562026-08-27T03:44:52ZAndrew—·Larson1942-01-06UHC-44561-88•••-••-3132(856) 351-2700UNKNOWN6183 Sage CtCharlotteNC··28280GRP-3366MEDICARE-ADV-B
TPATPA-639552026-04-23T19:45:14ZMARILYN—DOMINNGUEZ·19910414null•••-••-7792-N/A6157 CAMELBACK ROAD #441··FRESNOCA93745·UNKNOWNN/A
ENRENR-1111962026-07-29T22:34:04ZPHILIPUCARLSON1949-02-09··UHC-39625-55•••-••-1940(467) 387-5117PHILIP.CARLSON@GMAIL.COM7382 Highland AveTempeAZ85258GRP-5919OPTIONS-PPO
CLMCLM-4043412026-04-07T07:20:45ZDENNIS····MURHY1974-07-05UHC-83602-05—2563532—8539 Oak Street Apt 18MinneapolisMinnesota··55417GRP-1217null
CLMCLM-412345 2026-09-17T19:57:48ZFrances—Harvey1985-03-28null•••-••-83677026477439N/A3719 MESA DRIVEMinneapolisMN··55414GRP-1326-
TPATPA-569312026-06-15T10:36:42ZJEANTRUSSELL1947-05-17—N/A2777580393-UNKNOWN——····GRP-1782—
CLMCLM-4292132026-05-24T13:13:29Z Betty—MorenoNov 17, 1952UHC-41237-68•••-••-4812-··betty.moreno@yahoo.com4291 WASHINGTON STREETHoustonTX77063GRP-1341NAVIGATE-HMO
TPATPA-524122026-01-12T14:10:40Zalbert——1974-11-08nullN/A(817) 879-4171—6938 Camelback Rd··AtlantaGA30309—··
ENRENR-1390422026-09-13T00:31:21ZMATEO—GUERRRERO·4/8/2001UHC-46112-25•••-••-9912·(762) 417-9507mateo.guerrero@icloud.com955 Elm StSan AntonioTX78240··GRP-0156OPTIONS-PPO
TPATPA-628012026-09-04T05:31:08ZKevin—Willis19780828UNKNOWNNULL—kevin.willis@proton.me8245 VALLEY VIEW DRIVESan DiegoCA92101·-MEDICARE-ADV-A
CLMCLM-4301502026-09-07T11:40:38ZHoward, Samantha—····1955-11-11UHC-54388-27—N/A—7572 Cedar LnGilbertAZ85280UNKNOWN-
CLMCLM-4250212026-07-28T20:44:23ZMARIA—HENRY··1981-02-04NULL··——····4187 CENTRAL AVENUEPlanoTX75053-1212GRP-1023CORE-HMO
PRVPRV-279892026-05-27T09:46:44ZRACHEL—FLORES2006-02-05UHC-97143-27UNKNOWN(864) 356-6599RACHEL.FLORES57@ICLOUD.COM5831 Sunset BlvdPlanoTX75080-N/A
CLMCLM-4317662026-08-28T09:33:30ZHeather—Carpenter21-04-1995UHC2599183-(709) 459-0704N/A7891 Forest AvenueSan DiegoCA·92173NULL—
ENRENR-1230372026-10-15T08:19:05ZWilliamCHenry1964-08-08UHC-07463-82•••-••-4547(973) 741-8757·WILLIAM.HENRY67@ICLOUD.COM912 Apache Boulevard·OrlandoFL32802GRP-1127CORE-HMO
PRVPRV-235022026-05-06T18:44:43ZJenice—Jacobs1965-04-10UNKNOWN-UNKNOWNJANICE.JACOBS69@PROTON.ME631 FOREST AVENUEMesaAZ85270NULLNAVIGATE-HMO
PRVPRV-215142026-06-07T05:46:39Zlogan—riveraJun 13, 1989UNKNOWN•••-••-17489575564909NULL7090 MAPLE AVENUEMESAAZ85237N/A·N/A
TPATPA-535102026-08-13T07:57:51ZNATALIE—PIERCE01/28/1939-•••-••-3972-natalie.pierce56@aol.com9679 WASHINGTON STGlendaleAZ85315GRP-8452OPTIONS-PPO
CLMCLM-4003112026-08-02T01:42:54ZKENNETH····FLORES1991-11-17UHC-45261-61—8689873126—456 MEADOW LANE·GLENDALEAZ85337GRP-9452OPTIONS-PPO
CLMCLM-4178652026-05-12T10:11:14ZJACQUELINECMALDONADO1983-10-05—•••-••-4569NULLN/AUNKNOWN····——N/AN/A
ENRENR-1135552026-04-11T06:24:00ZCampbell, EmmaO—11/15/1971UHC-47039-85•••-••-8455416-311-8053—4875 Central AveMesa··AZ··UNKNOWNGRP-7923NAVIGATE-HMO
CLMCLM-4195352026-02-09T13:38:59ZVincent—Guerrero09/01/1965UHC-79757-63-N/AN/A4646 Baseline Rd··MinneapolisMN55483GRP-5970MEDICARE-ADV-B
PRVPRV-208082026-07-24T16:02:47ZRUTHEWELLS12/08/2003UHC1600769—·18227708183ruth.wells@gmail.com7402 Sage CourtTempe·AZ85264·N/A—
ENRENR-125421 2026-08-06T14:48:04ZJordanH.Watson1999-10-05UHC2272560•••-••-85898255465233—null—-—GRP-3078OPTIONS-PPO
ENRENR-1153172026-06-15T10:21:46ZTerryKColeman19390910UHC-28889-03··•••-••-3837755-353-3818terry.coleman88@proton.me9252 LAKE VIEW ROADGILBERTAZ85229GRP-8526MEDICARE-ADV-A
ENRENR-1369132026-07-03T01:10:56ZMoreno—Aisha1979-05-12UHC2238672•••-••-99518522992387UNKNOWN8472 MESA DRPhoenixAZ85040GRP-2894OPTIONS-PPO
ENRENR-1259412026-03-04T13:28:20Z TYLEROCOLE2004-09-07UHC-10594-20•••-••-6122(445) 301-3486—1535 JEFFERSON AVENUEPhoenixAZ85051GRP-5534navigate-hmo
ENRENR-1398822026-06-19T15:15:49ZDIEGOAYANG1939-12-09UHC-14396-91•••-••-5313(741) 519-6199DIEGO.YANG@YAHOO.COM1596 Canyon RoadMinneapolisMN55486GRP-2204··CHOICE-PLUS-PPO
CLMCLM-4211992026-09-11T03:44:28ZGuzman, Madison——2008-05-25UHC-78690-13—N/A—9638 Park PlGLENDALEAZ85311-NAVIGATE-HMO
CLMCLM-4252972026-06-13T22:29:07ZLe, Roger····—19871214UHC-84334-48—N/A—9800 Cedar LaneAustinTX78739N/ACHOICE-PLUS-PPO
PRVPRV-213352026-01-05T03:40:38ZDEBRAH··MARQUEZMar 18, 1996nullNULL5879686316—6543 Lincoln WayMESAAZ85274-SELECT-EPO
CLMCLM-4184022026-10-04T01:42:29ZLane, Eugene——1976-10-05UHC-40068-81N/A(513) 688-1153N/A8792 Main StCharlotteNC28286GRP-7461SELECT-EPO
PRVPRV-219492026-09-20T03:46:41Z ·Randy—Lawrence02-01-1981··NULLNULL925.848.9130randy.lawrence@proton.me··8287 Highland Ave Apt 37GlendaleAZ85316—MEDICARE-ADV-A
ENRENR-1164122026-02-01T05:02:31ZJULIA—WALLACE1989-04-20UHC-67124-21•••-••-65404626087693null3655 Sage CourtSacramentoCA95819GRP-1060MEDICARE-ADV-B
TPATPA-586312026-02-06T23:53:09ZHANNAH—MORALES2008-03-17··——(636) 316-0943N/A3620 Main StreetAtlantaGA30316GRP-0686··CHOICE-PLUS-PPO
CLMCLM-4191952026-04-26T15:27:01ZSantos, Bruce——1996-02-23N/ANULL(360) 236-2372—4163 OCEAN AVENUEMiami·FL33122-4028··—CORE-HMO
ENRENR-1129192026-09-04T12:28:21ZwayneU.knight1980-34-27UHC-95604-13•••-••-9554(932) 806-7916wayne.knight80@aol.com6599 MARKET STREETChandler··AZ85227GRP-2513SELECT-EPO
CLMCLM-4005002026-08-11T10:42:35ZARTHUR—WRYGHT19431218UHC-32304-69-17375308335··-7348 Baseline RdLas VegasNV89112GRP-9097OPTIONS-PPO
TPATPA-562652026-09-14T13:57:26ZDonna—Howard27-07-1944UHC-14213-46null328-622-2434N/A5111 BAYSHORE DRIVE Apt 37TampaFL33675··—CHOICE-PLUS-PPO
CLMCLM-4273952026-09-05T20:27:38ZJustin—Ruiz1979-04-22UNKNOWN-NULL-6445 JEFFERSON AVENUE Apt 32AustinTX78715·GRP-5991N/A
CLMCLM-4097442026-10-09T23:33:36ZJennifer—Carr9164-06-16—-——UNKNOWN——nullGRP-3562MEDICARE-ADV-B
100,000 rows, page 21 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.762Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty