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-4133102026-02-19T22:30:24ZMariaPDean··10/07/2007N/A•••-••-9581—-··6450 LINCOLN WAY·TempeAZ85296-7974GRP-2579··MEDICARE-ADV-B
CLMCLM-4163722026-03-10T10:08:21ZRichardson, Jeffrey—····2002-02-03null··•••-••-8957(582) 942-0586NULLUNKNOWN-—nullnull—
CLMCLM-4309482026-07-03T14:41:28ZEricKFlores1962-10-19UHC-95939-27-UNKNOWN-N/A····-NULLGRP-4227—
CLMCLM-4258962026-04-10T16:11:14ZSusanKPerry2003-07-18—•••-••-84744237405827—5019 Meadow LnOrlandoFL32862GRP-6678OPTIONS-PPO
ENRENR-1191062026-04-16T21:46:07ZJONATHANPSULLIVAN·1969-06-09·UHC0284976•••-••-3158+1 666 888 5855JONATHAN.SULLIVAN41@PROTON.ME2307 FOREST AVENUE Apt 6··CharlotteNCnullGRP-3972SELECT-EPO··
ENRENR-1181672026-10-05T23:54:46ZAisha—Moore1967-04-23UHC8681693•••-••-4777(289) 867-9169UNKNOWN1722 Market StreetChandlerAZ85204··GRP-4600OPTIONS-PPO
PRVPRV-244132026-08-13T22:03:33ZCYNTHIA··WSANDERS1982-11-05UHC-47513-40•••-••-2604909.617.3880-··3725 Central AvenueTempeAZ85213··—CORE-HMO
CLMCLM-4080892026-08-16T21:50:52ZkathrynA.·perryJul 27, 1971—•••-••-8627(769) 491-1117—N/AN/AN/AnullGRP-3202—
TPATPA-550312026-02-03T10:23:22ZKing, Angeela··—1988-12-23·UHC-91366-31•••-••-4961568.937.6706····6442 Main StMesaAZ··85269-3137UNKNOWN—
ENRENR-1184292026-08-31T13:43:59ZJoshuaVGriffin·1983-10-16UHC-65735-65•••-••-3970·+1 749 725 0019joshua.griffin22@gmail.com4411 APACHE BLVD··Phoenix··AZ85006··GRP-6412medicare-adv-a
CLMCLM-4246232026-02-05T22:09:53Z·Morgan, Bradley——1948-01-20UHC-42385-27NULLNULL—6148 Cedar LnAtlantaGA30359-8277GRP-4347null
CLMCLM-4017652026-08-02T05:35:17ZWalter—Wang13-09-1947—•••-••-6814null-5093 Grand Ave #799PlanoTX75090GRP-1011N/A
TPATPA-601062026-06-23T07:49:54ZDiana—Mills·1954-03-08NULL•••-••-3100—null-—NULLNULLnullMEDICARE-ADV-B
ENRENR-1181582026-06-29T17:42:34ZDelgado, AmberR.··—2007-09-14··UHC-82226-03•••-••-4864882.814.6582AMBER.DELGADO55@HOTMAIL.COM4846 Market Street #531ChandlerAZ85241··GRP-2848MEDICARE-ADV-A
ENRENR-1359112026-09-24T00:37:05ZWilson, FrankY··—2001-08-26··UHC-42985-12•••-••-6306(473) 503-4402frank.wilson70@gmail.com7791 HIGHLAND AVENUEFRESNOCA93799·GRP-7258NAVIGATE-HMO
CLMCLM-4150232026-09-28T12:58:05ZJanice—Herrera19860918UHC-91917-46-null—2585 GRAND AVENUEAustinTX78760-2252GRP-3803—
TPATPA-570492026-09-09T12:56:44ZNathan—Burns1951-06-09—•••-••-6313nullnull9807 Mesa Drive #200AustinTX··78779NULL—
CLM CLM-4289502026-02-10T05:46:53Z Priya··Rioos02/14/1981UHC-31247-21—NULLpriya.rios@gmail.com1393 Canyon Rd·Chandler·Arizona85293-choice-plus-ppo
CLMCLM-4198022026-01-23T06:17:23ZFrances—Heny2001-02-07—N/A··—NULL—--null·GRP-9014NAVIGATE-HMO
CLMCLM-4001662026-09-26T09:50:31ZCharlotte—Wheeler1964-03-13UHC-02876-57UNKNOWN(674) 537-3346UNKNOWN8961 PARK PLACESacramentoCA95844-3388N/A····
TPATPA-639312026-04-07T05:45:59ZZACHARY—SCOTT19491224UNKNOWN•••-••-27366067826986UNKNOWN8108 Canyon RoadPlanoTX75085GRP-5690—
ENRENR-1125582026-02-18T05:22:08ZrandyUkennedy1954-11-01UHC-29773-41NULL9732274314randy.kennedy@yahoo.com5003 Union StreetLas VegasNevada89159GRP-9958MEDICARE-ADV-A
CLMCLM-4244992026-10-18T12:24:29ZCHARLES—NGUYEN1981-01-23··uhc-11107-77•••-••-8001——7463 FOREST AVESacramentoCA95831GRP-2155NAVIGATE-HMO
ENR ENR-112339 2026-02-07T16:09:36ZChristian—Foster05/16/1967UHC-88351-38•••-••-5439·15647815697CHRISTIAN.FOSTER@PROTON.ME7933 Elm StAUSTINtx78771GRP-2419OPTIONS-PPO
ENRENR-1040062026-09-17T21:36:53ZNicholasUMendez19690124UHC-40687-45•••-••-0502753-550-7689nicholas.mendez45@icloud.com··1628 Ocean Ave··Columbusoh—GRP-4308MEDICARE-ADV-A
CLMCLM-4173442026-03-17T19:26:20ZANA—MASON05/06/60UHC-37551-83•••-••-1603·314.889.8155—4563 Lincoln WayEden PrairieMN55381GRP-1658—
CLMCLM-4094822026-03-27T19:41:40ZDiego—Mason1942-06-19UHC-86673-18•••-••-7712NULL—2375 SAGE CT·MESAAZ85216GRP-7185-
ENRENR-1371812026-06-13T17:42:37ZDanielleC.Grant1943-09-06UHC-38072-86··•••-••-6130743-653-8896N/A9196 Harbor BlvdCharlotteNCnullGRP-8107SELECT-EPO··
ENRENR-1430042026-01-09T15:51:45Z·Roger—Fowler10/07/1938UHC-32949-91•••-••-51794577934953roger.fowler@aol.com·6511 CAMELBACK ROADSacramentoCA95815GRP-1934NAVIGATE-HMO
CLMCLM-4053992026-10-11T05:42:30ZVIRGINIA—SMITH07/22/01·UHC6202473N/Anullnull··9017 Palm Drive Apt 40AtlantaGeorgiaUNKNOWNGRP-1354MEDICARE-ADV-A
ENRENR-1023342026-04-17T01:38:58ZAnnSRyes1967-04-16UHC-80982-32UNKNOWN——10 Jefferson Avenue #851MesaAZ85220·GRP-0687MEDICARE-ADV-B
ENRENR-121344 2026-08-22T13:23:11ZSTPHEN—WEBER1987-01-28UHC-69344-67•••-••-9565NULL—8952 Sage CourtCharlotteNorth Carolina28253GRP-2278OPTIONS-PPO
TPATPA-526842026-04-18T16:41:51ZWei—Daniels10/20/2007UHC-15768-48•••-••-8886——————NULL—
CLMCLM-4151142026-07-05T16:55:43ZCharles··—Hill1994-12-10UHC-05062-59N/A—null7232 Grand Avenue Apt 22DenverCO80239GRP-4349—
CLMCLM-4206042026-07-17T14:33:22ZBilly··Wong··1989-02-21null•••-••-8090(736) 658-5740—5293 RIDGE ROADPlanoTX75096-1952GRP-6751NAVIGATE-HMO
ENRENR-1308452026-06-01T12:34:56ZBruceTGraham1938-04-24UHC-62566-62•••-••-9212774-762-7572NULL5761 ELM STREET··TampaFL33641GRP-4283OPTIONS-PPO
ENRENR-1267822026-09-18T11:50:37ZJohnston, Santiago——1947-06-08UHC-07734-93•••-••-10576914980202santiago.johnston@yahoo.com8790 Palm DriveGILBERTAZ85246GRP-6959CORE-HMO
ENRENR-1039072026-07-09T01:34:25ZwillieVwoods··02/18/01UHC-13925-39•••-••-8177(946) 897-7509WILLIE.WOODS52@GMAIL.COM6332 BroadwayPhoenixAZ—GRP-3099CHOICE-PLUS-PPO
ENRENR-1227802026-02-04T00:54:55ZMICHELLE—WALKER08/05/03UHC-17580-14•••-••-498713015838848··-7539 BAYSHORE DRIVE Apt 19JacksonvilleFL32259GRP-5013CHOICE-PLUS-PPO
CLMCLM-4182292026-02-27T05:07:57ZJeanKSingh1951-03-25UHC-61363-09UNKNOWN··+1 442 600 5971-··6624 HILLCREST ROADPHOENIXAZ85054GRP-9542MEDICARE-ADV-B
CLMCLM-4047032026-10-03T08:58:48ZJOSEPH··OBRIEN10/10/1978———N/A1682 Sage CourtOrlandoFL32897N/A—
PRVPRV-295862026-03-30T17:10:37ZMason—Pyane1979-11-17UHC-28896-14-·3238353551—5013 Forest AvenueAtlantaGA30385null—
ENRENR-1242082026-03-19T04:18:51ZJerryI.Patel1984-07-01UHC-16622-15•••-••-72725747010969jerry.patel80@gmail.com8468 LAKE VIEW RDMINNEAPOLISMN55427GRP-8182MEDICARE-ADV-B
CLMCLM-4046872026-05-05T02:24:42ZAshley—Bowman··Jun 17, 1978UHC-45993-85•••-••-3365(549) 371-3290UNKNOWN1097 Oak StTEMPEArizona85271GRP-9699··null
TPATPA-595632026-10-05T17:00:22ZCHARLOTTE—HAYES1991-01-15NULL—nullUNKNOWNUNKNOWN———nullUNKNOWN
CLMCLM-4235772026-04-04T04:33:29Z PeterYHernandez-—•••-••-9194889-460-0573-7574 BASELINE ROADGILBERTAZ85204NULLMEDICARE-ADV-A
ENRENR-112738 2026-07-02T05:53:02ZSHARNODROMERO1952-10-26——-SHARON.ROMERO@ICLOUD.COM5377 DESERT SKY BLVDLAS VEGASNV89188GRP-7312NAVIGATE-HMO
CLMCLM-4288842026-07-29T08:54:56ZGarcia, Austin——1972-07-16UHC-61676-05—null—8689 MEADOW LANESACRAMENTO··CA95863GRP-1300—
ENRENR-1430852026-02-26T00:13:56ZBradley—Salazar1964-10-18UHC-55091-67•••-••-9359-—6012 VALLEY VIEW DRIVEDallasTX75231·GRP-4987MEDICARE-ADV-A
ENRENR-1102902026-07-02T06:50:00ZRussell—Hunt1961-09-13UHC2046499•••-••-2468N/ARUSSELL.HUNT@ICLOUD.COM6588 HIGHLAND AVENUETampa··FL33604GRP-2112CHOICE-PLUS-PPO
100,000 rows, page 139 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.694Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty