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-1185092026-01-24T12:17:55ZPhilipFMarquezMar 26, 1948UHC-49407-03•••-••-8818·14186488416philip.marquez@yahoo.com7585 CEDAR LN··ColumbusOH43216GRP-7232MEDICARE-ADV-B
TPATPA-569322026-08-16T09:49:11Zjean—russell5/17/1947NULL—277.758.0393UNKNOWN8519 River Rd #721OrlandoFL32896GRP-1782··UNKNOWN
CLM CLM-4066752026-05-13T06:19:04ZWILIAM—·VASQUEZ1939-01-24N/AUNKNOWN··—3942 Union StMinneapolisMN55411null—
PRVPRV-210272026-08-30T13:01:52ZChristian—Perez1978-01-11UHC-47113-40—750-759-8645christian.perez61@yahoo.com··9660 GRAND AVENUETempeAZ85211——
ENRENR-1366772026-04-01T19:37:17ZRuth—JonesMar 16, 1983UHC-19292-41•••-••-3429(437) 992-1122ruth.jones60@aol.com5065 Sage CtFresnocaN/AGRP-1689CORE-HMO··
ENRENR-1310652026-04-22T02:02:33ZMartha··—BradleySep 3, 1969UHC6604335•••-••-4647·+1 808 476 5256N/A385 Market StHouston·TX77051GRP-2526MEDICARE-ADV-B
ENRENR-1327732026-10-02T19:08:29ZAmber—Davis1986-12-09UHC-69598-56•••-••-8094·(862) 767-5311—6588 Main StChandlerAZ85203GRP-6355SELECT-EPO
CLMCLM-4171442026-03-10T12:26:59ZANNA—BURKE1938-07-28NULL•••-••-9831N/A—6502 Mesa DriveDallasTX75203·-MEDICARE-ADV-A
ENRENR-1016782026-09-21T07:30:47ZVINCET—SANDERS1986-02-25·UHC-33261-46•••-••-0578+1 552 981 9291—·811 CEDAR LN·ChandlerAZ85248-4126GRP-9863SELECT-EPO
TPATPA-519442026-06-01T18:11:06ZLOGANNBELL1970-08-22UNKNOWNnull(224) 759-8345logan.bell@icloud.com8447 RIVER RDMiamifl33145——
CLMCLM-4005672026-04-28T19:06:02ZVirginia—Hill1962-09-15UHC-08541-98··nullnull·5020 Ridge RoadTampaFL33666—NAVIGATE-HMO
ENRENR-1350292026-01-29T20:51:13ZCHARLES—ROBINSSON1793-01-24UHC-14595-20•••-••-1068UNKNOWNcharles.robinson27@outlook.com3748 Ocean AvenueTempeArizona85277GRP-2008MEDICARE-ADV-A
CLMCLM-4084242026-10-14T02:55:26ZJulia··ACastillo—null•••-••-3013513.566.4821—6225 Bayshore Dr··Eden PrairieMN55382GRP-4003SELECT-EPO
TPATPA-627402026-03-22T13:17:57ZHannah—Santiago1963-03-04—•••-••-197917224772081·NULL4555 Washington StreetEden PrairieMN55362UNKNOWNNAVIGATE-HMO
ENRENR-112566 2026-07-11T05:53:04ZAndrewOVargas·2000-03-18UHC-80697-36•••-••-5728—andrew.vargas73@outlook.com1220 Baseline RoadLOS ANGELESCA90065GRP-5813MEDICARE-ADV-A
CLMCLM-4056202026-05-13T09:20:15ZJessica—Taylor1951-02-22UHC-33596-12•••-••-1156344.890.0471·null2381 Lincoln Way #287NashvilleTNNULL·GRP-1811··
PRVPRV-236662026-06-02T16:07:42ZDennis—Castro2000-05-06null•••-••-9730·3268442329dennis.castro@yahoo.com5520 Washington Street Apt 16MiamiFlorida33174··MEDICARE-ADV-A
ENRENR-1022282026-02-28T14:16:55Z·Kenneth—·Woods1957-01-16UHC9467757•••-••-227219476207271kenneth.woods20@gmail.com2537 Pine DrLos AngelesCA90097GRP-9767CHOICE-PLUS-PPO
ENR ENR-1106282026-06-07T20:24:48ZMateo—·Ortiz2008-03-27UHC-00765-02•••-••-34489367550311-4680 Forest AveMiamiFlorida33158GRP-0183CHOICE-PLUS-PPO
ENRENR-1387002026-05-04T01:45:03Zangela—simpson03/28/41UHC-88361-45•••-••-20425523173174angela.simpson36@hotmail.com7681 Spring St Apt 39TucsonAZ85740GRP-3763NAVIGATE-HMO
CLMCLM-4158792026-05-11T18:45:41Z·BETTY—HRAT04/17/93UHC-32493-85—8180225null··4852 Union StCharlotteNC··28229·N/AN/A
CLMCLM-4088062026-08-14T18:33:11ZJOAN—ORTEGA1958-03-20··UHC-14047-49•••-••-0335NULL—6390 Ocean AvenueJacksonville·FL32210GRP-8860CHOICE-PLUS-PPO
ENRENR-1394292026-01-10T23:40:12ZLukiaU··Anderson19780403UHC-24339-08•••-••-40728919293647null1049 DESERT SKY BLVDNashvilleTN37206GRP-6800OPTIONS-PPO
CLMCLM-4069202026-02-07T13:04:47ZRobert··—Romero11/18/86··UHC-84309-91N/A289.243.6915-4570 Baseline RoadTucsonAZ85780GRP-6258SELECT-EPO
ENRENR-1233282026-04-10T17:57:11ZChristine—Medina1982-05-25UHC-95954-29•••-••-8448(594) 224-0131UNKNOWN—-nullNULLGRP-1273CHOICE-PLUS-PPO
TPATPA-515092026-08-30T20:31:14ZDavid—Hall1948-06-04—null5856060670—766 CENTRAL AVENUEDenverCO80252··GRP-8437UNKNOWN
ENRENR-1227982026-04-21T09:35:28Ztheresa··Kburns1961-08-13UHC4945691•••-••-2967867-765-1239—6374 River RoadMiamiFL33146GRP-1749··core-hmo
CLMCLM-4016602026-07-06T06:04:27Zchristina—sandoval·1983-12-28UHC-51663-15-UNKNOWN—·257 MEADOW LANEFresnoCA93762NULL··MEDICARE-ADV-B
CLMCLM-4172192026-10-06T07:20:38ZJacqueline—James1991-03-25UHC-45653-48UNKNOWN621-951-1568·UNKNOWN—N/Anull—N/AN/A
ENRENR-1026692026-03-05T11:19:50ZHarvey, Thomas——1944-03-05UHC-88323-46•••-••-3403640.206.0091THOMAS.HARVEY@PROTON.ME7820 Bayshore DrLas VegasNV89123GRP-0962CHOICE-PLUS-PPO
ENRENR-1206292026-03-09T18:12:57ZPeterVBaker2001-04-28UHC9998131•••-••-62229817670571PETER.BAKER61@GMAIL.COM9241 Sunset BlvdFresnoCA93757GRP-0156·MEDICARE-ADV-A
CLMCLM-4209212026-03-04T00:17:11ZDeniseJLucas1997-06-10UHC-21721-41·--N/A··1042 SUNSET BOULEVARDTampaFL—GRP-6446NULL
ENRENR-1382392026-08-13T20:52:11Zcarolyn K.—fuller12/10/1996·UHC-10166-76•••-••-4941(923) 485-2955—5749 Mountain View DrAUSTINTX78736GRP-5712MEDICARE-ADV-A
ENRENR-1046912026-07-07T04:21:01Zgary—jimennez1954-03-21uhc-18639-93•••-••-3799959-688-5709gary.jimenez88@proton.me302 Elm StreetPLANOTX75041GRP-9949MEDICARE-ADV-B
TPATPA-519902026-10-03T19:07:23ZDonald—Torres··Dec 14, 1997UHC-22457-76nullNULLdonald.torres@yahoo.com8591 Central AveSan Diego··CA·92186GRP-6488CORE-HMO
ENRENR-1264302026-04-10T23:45:57ZRonald—CollinsAug 25, 1940UHC-11953-53•••-••-9542nullRONALD.COLLINS51@OUTLOOK.COM7802 Central AveTAMPAFL33616GRP-0600CORE-HMO
ENRENR-1214732026-10-14T22:16:05ZOrtizTStephanie1980-68-02UHC-92874-74•••-••-0318571-287-3717stephanie.ortiz@gmail.com5481 Washington StreetMiami·FL33191GRP-1132MEDICARE-ADV-A
CLM CLM-4072662026-07-12T03:31:30ZGeorge, JuliaD—1959-01-27UNKNOWNN/A(469) 498-1212-2430 VALLEY VIEW DRCharlotteNCNULLGRP-6506··UNKNOWN
ENRENR-114045 2026-05-02T16:53:56ZJustinYWrightMar 15, 1949UHC-64046-67•••-••-1641·+1 987 861 7076justin.wright84@icloud.com1629 Main StreetNashvilleTN37204GRP-6278MEDICARE-ADV-A
TPATPA-603382026-06-27T00:17:58ZLAUREN—COOPER1986-09-13UHC-35857-72-UNKNOWN····——-UNKNOWNGRP-0208—
PRVPRV-244602026-07-14T14:44:54ZLindaCMcDonald03/12/87··UHC-89393-86UNKNOWN3404830878—4266 BROADWAY Apt 3MiamiFL33192-0201-UNKNOWN
PRV PRV-222772026-06-26T01:45:33Z·Patrick—·Morris1992-10-26·N/A-··533.515.1382patrick.morris92@proton.me3131 Palm DriveEden PrairieMN··55381—-
TPATPA-606332026-03-21T22:59:58ZANGELA····WOODS··1978-01-03UNKNOWN•••-••-2477nullNULL3904 Canyon RoadSCOTTSDALE·AZ85226GRP-5642—
PRVPRV-282432026-09-18T05:13:32ZLauren—Dunn1950-02-24UHC-63768-04nullUNKNOWN—5143 Meadow LnLas VegasNV89119N/A··
TPATPA-540792026-04-03T20:52:03ZBrandon—Mejia·19941212——9324177N/A3682 Cedar LaneMinneapolis·MN55463··GRP-4049options-ppo
ENRENR-1184882026-09-26T21:16:07ZAmanda··—ShawUNKNOWNUHC-91321-72N/A863-991-1050amanda.shaw@aol.com7331 Washington StreetColumbusOH43256GRP-9009NAVIGATE-HMO
ENRENR-1086862026-09-11T12:18:58ZDENISET·KING06/10/1989UHC-24696-32··•••-••-4848964.425.6435N/A··1882 FOREST AVEMesaAZ85234GRP-0647MEDICARE-ADV-A
CLMCLM-4082872026-01-15T07:26:33ZJanice··—Stone1974-07-18UHC-82115-89UNKNOWNN/AUNKNOWN6480 Ocean Avenue··ChandlerAZ85290GRP-7510OPTIONS-PPO
PRVPRV-206382026-05-12T15:14:43ZBryan—Payne19561224—····3395765null·5689 Jefferson AvenueSEATTLE·Washington98150NULL··
ENRENR-1248012026-07-14T08:30:18ZJohnCBoyd19550801UHC-18966-41•••-••-2201·(740) 703-1968NULL··4588 Central AvenueMinneapolisMN55485GRP-0889MEDICARE-ADV-B
100,000 rows, page 78 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.795Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty