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
CLMCLM-4249292026-03-16T11:28:30ZHenry—·Fisher2005-06-18UHC-12256-45NULL··——nullUNKNOWNNULL—N/A
CLMCLM-4057062026-02-13T22:04:58Zjanice—·hall1988-10-26UHC-51449-87-NULLUNKNOWN2256 Union StHOUSTONTX77077GRP-1648—
ENRENR-1323252026-05-22T03:16:57ZChristineH.·Jensen1948-08-09UHC-15768-95•••-••-5567(665) 295-1829-1765 Mesa Dr··MINNEAPOLIS··MN55462GRP-2412CHOICE-PLUS-PPO
CLMCLM-4131172026-10-18T01:44:46ZJohnston, Anthony——1976-01-26UHC3980489•••-••-51342375899084·UNKNOWN6353 Cedar Ln #964Tampafl33619GRP-0814medicare-adv-a
ENRENR-1028412026-02-21T02:30:19ZnoahLwillis1998-08-17UHC-64010-59•••-••-51347638263661noah.willis@aol.com916 Baseline RoadCharlottenc28225GRP-2082NAVIGATE-HMO
ENRENR-1317602026-09-27T15:26:18ZSAMUEL··—WALKER09/03/60UHC-47130-43•••-••-3401+1 595 242 5340samuel.walker@outlook.com2385 Lincoln WayGILBERTAZ85216GRP-2646MEDICARE-ADV-A
ENRENR-1081602026-10-13T16:24:29ZDAVIDVBURNS1955-03-06UHC-51090-99•••-••-9207(977) 924-0110david.burns87@yahoo.com3663 Park PlaceLos AngelesCA90007GRP-3029·NAVIGATE-HMO
CLMCLM-4272492026-01-26T12:38:35ZJOSHUA—ROSE9/22/1961-····(709) 529-9155—7769 RIDGE ROADMinneapolisMN55456-3704GRP-3638UNKNOWN
CLMCLM-4041172026-05-14T00:41:08ZRaymond—WodDec 17, 1977UHC-43430-18null··+1 413 645 8907—409 Cedar LnLas VegasNV89148GRP-5840—
TPATPA-616452026-01-22T11:04:02ZJenen—Helen11/10/1974—-312-673-7421null5779 Market StreetCharlotteNC28244NULLnull
TPATPA-526272026-05-09T19:58:45ZJimmy—Hamilton1994-09-27null—N/Ajames.hamilton@gmail.com··2485 MOUNTAIN VIEW DRLos AngelesCA90040NULL—
ENRENR-1112402026-07-05T15:46:06ZGABBRIELQVAZQUEZ··Feb 21, 1954UHC2148163•••-••-19064397280630gabriel.vazquez83@yahoo.com529 BASELINE ROADAustinTexas78780GRP-6292CHOICE-PLUS-PPO··
TPATPA-534972026-06-10T02:25:00ZJeremy—·Daniels19610221·UHC-81515-12——-6850 SAGE COURTLas Vegas·Nevada—UNKNOWN··
CLMCLM-4162732026-04-22T00:13:38ZSANTIAGO—JENSEN1992-05-26UHC-40660-07•••-••-624917917563574·UNKNOWN8713 MEADOW LANE Apt 26SeattleWA98137GRP-6666·CORE-HMO
ENRENR-1037772026-07-31T08:21:50ZYoung, Ruth——19890111UHC-18250-65null(678) 443-3901RUTH.YOUNG@YAHOO.COM3975 Ridge Rd #435NashvilleTN37244GRP-7747SELECT-EPO
CLMCLM-4202822026-05-18T16:07:34ZMaria—Cox9/1/1940UHC-85402-44•••-••-7836·8355198846NULL49 Highland AvenuePlanoTX75044··GRP-5192UNKNOWN
PRVPRV-295562026-06-24T15:37:42ZStephanie····Allen18-04-1957UHC-26220-93—(787) 583-3154—3199 MARKET STREETLOS ANGELESCA90086····—
CLMCLM-4129512026-09-02T07:40:43ZJennifer—Watson20400507··—N/AnullJENNIFER.WATSON@AOL.COM9725 HARBOR BLVDTucson·AZ85783GRP-5669MEDICARE-ADV-A
PRVPRV-222252026-07-24T22:09:31ZJOE—SILVA1944-11-08··UHC-53993-88•••-••-6970367-518-0514jose.silva9@aol.com3387 RIVER ROADMesaAZ·85247——
CLMCLM-4135392026-04-12T02:51:01ZKEITH—WOODS03/22/54UHC-83597-46—+1 262 307 3328N/A8189 River Road #873DenverCO80224NULL····
CLMCLM-4046002026-02-15T23:54:24ZDEBORAH—VAZQUEZ4/8/2002N/ANULL·nulldeborah.vazquez96@proton.me7172 Bayshore DriveTUCSONAZ—nullUNKNOWN
PRVPRV-263942026-05-31T13:17:01ZSophia····RayOct 3, 1999——7377922231null707 Valley View DrAUSTINTX78737-2839—NULL
ENRENR-1320072026-03-11T01:14:00ZBradley—Martinez1965-03-12UHC-69554-89•••-••-15505345007BRADLEY.MARTINEZ8@HOTMAIL.COM1459 BROADWAYSacramentoCA95889GRP-8468OPTIONS-PPO
TPATPA-562922026-10-13T18:19:51ZRYAN—DUNCAN1971-05-26—•••-••-87744465996390ryan.duncan@gmail.com6813 Spring StScottsdale·AZ85230-SELECT-EPO
CLMCLM-4118662026-01-09T15:10:13Zhelen—west1953-01-90UHC-20637-25——NULL5497 Lincoln WayMesa·AZnull—null
CLMCLM-4282302026-01-10T22:07:00ZBRYAN····FOSTER20011201UHC-42145-76—4513496968—636 OCEAN AVEFresnoCA93709·NULL—
ENRENR-1095942026-03-21T12:23:37ZJulie—Carroll1974-10-14UHC-17928-78•••-••-2893nulljulie.carroll@gmail.com··456 Pine DriveGLENDALEAZ85388GRP-7327NAVIGATE-HMO··
ENRENR-1027122026-07-15T02:57:11ZTheresaVPierce20010912UHC-22598-55•••-••-9041(662) 742-2690theresa.pierce86@gmail.com4585 Park PlaceSeattleWA98107GRP-4025MEDICARE-ADV-B
CLMCLM-4016392026-07-23T16:20:33ZCharles··—Marquez5/9/1991——5675652015N/AN/A·N/A—UNKNOWNGRP-6357choice-plus-ppo
CLMCLM-4228022026-02-21T09:29:47Z·SHARONTSIMS—UNKNOWNnull8218280N/A6678 CANYON RDATLANTAGeorgia30349GRP-0330NULL
ENRENR-1154682026-08-09T07:30:57ZjuliaD··jensen1964-03-28UHC-01842-56•••-••-82628856956043—8676 Sunset BlvdTampa·FL33667GRP-1577navigate-hmo
CLMCLM-4289292026-10-03T23:14:27Z·Hannah—Valdez·1969-03-27—•••-••-5240UNKNOWN··nullN/A-····-—null
CLMCLM-4039272026-06-27T08:10:30ZHENRY—WAYNE9/6/1983NULL—(677) 428-0066null8107 Indian School Road·MesaAZ85268UNKNOWNSELECT-EPO
ENR ENR-1164282026-07-14T18:43:49ZKathleen T··Salazar19880037UHC-62432-29•••-••-9449+1 582 676 2980kathleen.salazar79@icloud.com··-N/A—NULLGRP-1620SELECT-EPO
PRVPRV-27136 2026-09-15T04:46:52ZWarren, Philip····—26-04-1964UHC-00906-32—6237643552null·416 MEADOW LANENashvilleTN37260——
CLMCLM-4182672026-01-20T19:40:26ZLucia—Jensen9/25/1961—NULLNULLNULL··217 Park PlSan DiegoCA92124GRP-8229SELECT-EPO
TPATPA-593972026-05-27T15:37:30ZDylan—Bowman··Jun 22, 1984··—438-697-6432UNKNOWN2383 CEDAR LN·JacksonvilleFL32237N/A—
ENRENR-1136042026-05-11T22:52:50ZKellyXWheeler·1991-02-01UHC-68101-84null3362980567KELLY.WHEELER92@GMAIL.COM1216 Harbor BlvdChandlerAZ85279GRP-9145SELECT-EPO
CLMCLM-4302012026-03-14T14:48:01Z·PHILIP—OLSON09/07/07null——PHILIP.OLSON@OUTLOOK.COM—UNKNOWN——-MEDICARE-ADV-A
CLMCLM-4262132026-06-27T00:22:07ZNANCY—PETERS19961107UHC-86599-46··nullnull8113 Harbor Blvd··CHANDLERAZ·85237GRP-1573N/A
TPATPA-500112026-08-28T09:19:37ZSarah—Collins1940-09-18··—•••-••-7701—NULL6195 Camelback RoadMesa··AZ85275··N/A-··
ENRENR-1269472026-01-25T04:05:47ZBRUCE—NELSON1993-03-13UHC7213531NULL12429460806bruce.nelson@gmail.com9238 Oak StNashvilleTN-GRP-6624OPTIONS-PPO
CLMCLM-4065732026-01-17T05:10:50ZKyle—Berry8/15/1981UHC-29527-44•••-••-8397361-312-8002··nullN/A········UNKNOWNCHOICE-PLUS-PPO
ENR ENR-1127192026-09-15T03:23:29ZJoshau··BHoffman1972-01-13UHC-75819-13•••-••-2409(337) 941-7652N/A4968 INDIAN SCHOOL ROAD·AustinTX78725GRP-4035MEDICARE-ADV-B
ENRENR-1115392026-08-02T04:17:20ZJACOB—CRUZ1988-07-09UHC0469002•••-••-65149257108550jacob.cruz59@aol.com··7937 LINCOLN WAY·San DiegoCA92162GRP-3019··NAVIGATE-HMO
ENRENR-1418642026-07-07T14:58:47Zcarl—campbell1967-03-26UHC-64261-86•••-••-2427nullCARL.CAMPBELL@PROTON.ME8324 Sage Ct Apt 37EDEN PRAIRIEMN55324GRP-3156CHOICE-PLUS-PPO
ENRENR-1416952026-07-18T04:29:42ZOMARHDUNCAN1991-06-09UHC5470201•••-••-4234N/Aomar.duncan85@aol.com2120 CAMELBACK RDColumbusOH43270GRP-2595SELECT-EPO
CLMCLM-4279812026-03-10T10:42:23ZAbigailRRios05/26/1979UHC-06532-92•••-••-9314··NULL5815 Bayshore Dr #723San AntonioTexas78296N/ASELECT-EPO
ENRENR-1259922026-04-15T16:54:29ZMary L··—Park2008-03-21UHC-76025-30•••-••-58738557223871mary.park23@hotmail.com2838 Mesa Dr Apt 39PlanoTX75055GRP-4686MEDICARE-ADV-B
ENRENR-1363332026-07-31T09:38:46ZGeraldJ.Cole1991-12-21UHC5670590•••-••-8683+1 363 375 5047gerald.cole@gmail.com3808 Highland AveHOUSTONtx77030GRP-3331OPTIONS-PPO
100,000 rows, page 102 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.677Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty