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
PRVPRV-25825 2026-05-25T17:07:35ZDanielleXCox19430412UNKNOWNN/A(713) 400-7297DANIELLE.COX@OUTLOOK.COM5635 Spring StSACRAMENTOCalifornia·95887—N/A
ENRENR-1040892026-05-10T09:55:22Z·NOAHPWILSON07/12/1942UHC2266758—481-984-0815UNKNOWN1183 SPRING STREETNashvilleTN37275··GRP-1104MEDICARE-ADV-B
TPATPA-58565 2026-06-03T23:03:18ZJerry—Lane1949-10-23———-2060 OCEAN AVEOrlandoFL32820UNKNOWNN/A
CLMCLM-4111262026-02-18T16:04:03ZEthan—GriffinOct 13, 1999UHC-23197-88—303.357.4813-8239 Willow CtMinneapolisMN55423GRP-3887UNKNOWN
CLMCLM-4062892026-09-05T08:53:05ZJUDY—ALEXANDER1990-09-12—•••-••-9682null-6007 GRAND AVENUEDallasTX75261GRP-8030SELECT-EPO
ENRENR-1283962026-06-24T17:21:48ZCarlos··Sullivan·1948-05-15UHC-14063-41null573.659.8305CARLOS.SULLIVAN@AOL.COM4850 Mountain View DriveDenver·CO80260GRP-0255CHOICE-PLUS-PPO
CLMCLM-4067452026-02-05T07:06:28ZPatricia—Mendez20040701-•••-••-9713——7575 Union St··Minneapolis··MN55404GRP-3407MEDICARE-ADV-A
TPATPA-566112026-09-03T04:05:42ZDENISE—WELLS1998-09-06—•••-••-7438UNKNOWN··8604 Lincoln Way Apt 27COLUMBUSOHUNKNOWN-CORE-HMO
TPATPA-580632026-05-16T10:12:42ZBRENDA—THOMPSON01/18/1986—•••-••-1590null—7461 Lincoln WaySeattleWA98165—CORE-HMO
PRV PRV-232102026-08-21T22:21:21ZFATIMA—COLLNIS1999-12-24UHC-63611-25•••-••-4377(634) 305-3581null9073 Lincoln WayDenverCO80205—····
CLMCLM-4013092026-05-28T00:59:51ZSara······Hall1958-06-02··UHC-08168-65•••-••-8162N/AUNKNOWN7589 DESERT SKY BLVDTEMPEAZ85276GRP-8457CORE-HMO
ENRENR-1399652026-02-02T21:17:36ZGERALD—ANDERSON1999-08-03UHC-60914-75•••-••-0608nullgerald.anderson18@icloud.com6481 Lake View Road··MesaAZ-··GRP-3457SELECT-EPO
CLMCLM-4207372026-03-19T21:57:30ZRebecca—Henry—UHC-09021-94NULL9670897-8916 Spring StreetLOS ANGELESCA90017··GRP-0626MEDICARE-ADV-B··
ENRENR-1283972026-07-10T05:57:54ZKATHERINEMGARZA12/13/77UHC-34249-92—·13798157969katherine.garza@yahoo.com910 LINCOLN WAYTampaFL33644GRP-9508NAVIGATE-HMO
CLMCLM-4106132026-10-04T21:02:54ZMei—Weber2005-05-07UHC-36230-97•••-••-1616(526) 349-1293mei.weber@yahoo.com3077 Jefferson AveSan AntonioTX78217—null
TPATPA-592532026-10-16T18:25:36ZJoshua—Williamson1987-07-19—•••-••-1163—joshua.williamson77@aol.com··2202 Apache BoulevardJacksonvilleFL—UNKNOWN··CHOICE-PLUS-PPO
CLMCLM-4281332026-08-09T09:12:11ZJack—Wheeler·3/14/1946-•••-••-40562299443579····1276 CENTRAL AVETempeAZ85227GRP-3229NULL
CLM CLM-4153042026-07-28T11:54:39ZAmy—·Lawrence9/23/2003—N/AN/A··null··2012 MOUNTAIN VIEW DRIVEDenverColorado80247GRP-6488UNKNOWN
CLM CLM-4225662026-03-03T21:28:35ZRyan—Harrison16-11-1958·UHC-72506-79•••-••-43235703612668—2325 Washington StreetAtlantaGA30353GRP-3110MEDICARE-ADV-B
CLMCLM-4084462026-06-15T08:58:19ZALICE—HOWARD05/11/1990UNKNOWN—2779082283N/A8259 Grand AvenueFresnoCA93726N/ASELECT-EPO
ENRENR-1313102026-02-10T08:21:13ZAbigailR.Gutierez1951-05-02UHC-54068-46•••-••-3161753-626-1696—5075 SAGE CTPLANOTexas75062GRP-2913CHOICE-PLUS-PPO
ENRENR-1042542026-04-25T11:22:34Z ALEXANDERR.TURNER1994-07-02UHC-44580-36•••-••-67623565819790alexander.turner75@outlook.com171 Camelback RoadMinneapolisMN55479GRP-3110CORE-HMO
ENRENR-1263182026-04-10T19:39:18ZMARIA—HOLMES19440628UHC-41418-76•••-••-9565NULL—3447 Desert Sky BoulevardTEMPEAZ·85290-0430GRP-3683CORE-HMO
ENRENR-1148312026-03-10T01:15:17ZSTEPHANIE··HAYES5206-19-82uhc-35079-82•••-••-8772-stephanie.hayes60@aol.com6718 ELM STScottsdaleAZ85232GRP-2582OPTIONS-PPO
CLMCLM-4007692026-04-13T14:30:00ZSaraKPhillips2002-08-13uhc-60451-51•••-••-4472971-999-3287N/A5025 Desert Sky Blvd #533ORLANDOFL32803—SELECT-EPO··
ENR ENR-1308862026-09-07T14:25:12ZBruceZ.Hart19761126UHC-51692-81•••-••-0555884-214-4282bruce.hart79@outlook.com2479 Mesa DrTucsonAZ·85786GRP-4924SELECT-EPO
CLMCLM-4149792026-02-23T03:27:50ZDIEGOMFOX·2002-12-07—•••-••-0403N/A-—-NULLUNKNOWNGRP-9919SELECT-EPO
TPATPA-60813 2026-09-28T16:40:29Zkenneth—reynolds1947-05-04NULL•••-••-7562——1528 Jefferson AvenueGILBERT··AZ85211NULL—
TPATPA-597242026-01-30T02:25:47Zjoan—edwards07/06/1956UNKNOWNNULL····null4205 UNION STREETDallasTX75293UNKNOWN-
CLMCLM-4288512026-04-12T04:53:46ZNancy—Soto19660702—N/A(671) 373-2691N/A4811 WASHINGTON STNASHVILLETN37257NULLN/A
CLMCLM-4074172026-06-07T09:35:29ZRachel—Munoz03/17/04UHC1593704—8985084666null7646 BAYSHORE DRIVEEden Prairiemn55307GRP-5816-
TPATPA-581702026-01-26T06:58:22Z———19940207null•••-••-0901nullN/A5068 Ocean AvenueDallasTX75218—null
TPATPA-508912026-01-01T10:32:22ZRAYMOND···HART1973-03-08UNKNOWNNULL441-406-2269raymond.hart78@icloud.com2095 MARKET STREETEden Prairie·MN55309——
CLMCLM-4047632026-06-13T05:16:49ZROBERTB.PERKINS1968-11-24UHC-38217-24-UNKNOWN—7520 Ocean AvenueJacksonvilleFL32240GRP-3467N/A
ENRENR-1205572026-09-05T00:24:06Z·PHILIIPYWARD01/18/1982UHC-04779-18•••-••-5373273-979-5001··philip.ward75@aol.com··2868 Desert Sky BoulevardFresnoCA93749GRP-6970SELECT-EPO
ENRENR-1346252026-09-16T01:55:59ZETHAN—WATSON12/07/77UHC-77561-28null(238) 920-2282ethan.watson@outlook.com4309 Valley View DrTampaFL33626GRP-5769NAVIGATE-HMO
ENRENR-1230292026-01-19T22:41:54ZGLORIA—NELSON08-09-1954UHC-36758-70•••-••-1080486-480-2720GLORIA.NELSON@OUTLOOK.COM8017 Main StNashvilleTN37206GRP-9021options-ppo
ENRENR-1227542026-07-22T07:05:36ZJackB.Alexander··1971-04-20UHC-89498-08•••-••-7772(723) 740-4966NULL··7505 Mesa Dr #306GilbertAZ85215GRP-2177SELECT-EPO
CLMCLM-4260592026-03-27T03:27:40ZCarol—Arnold1994-11-22·uhc-29564-55—+1 431 775 1242—8501 Central AvenueMinneapolisMN55461GRP-8487N/A
CLMCLM-4232702026-04-30T07:24:53ZBRITTANYO.SANDOVAL·1970-02-25UHC-22787-33··•••-••-37479126413441··—9784 Jefferson AvenueCharlotteNC28253-1603GRP-0624—
ENRENR-1109322026-02-23T23:03:26Zalan A—wilson·2001-03-06N/A•••-••-2301—alan.wilson77@outlook.com9375 Camelback Road #912COLUMBUSOH43279GRP-2217SELECT-EPO
ENRENR-1132952026-04-02T08:16:04ZJOHN—CHAVEZ·1988-08-11UHC-47303-17•••-••-8037(535) 546-4218UNKNOWN7160 Valley View DrSAN ANTONIOTX78222GRP-2553NAVIGATE-HMO
ENRENR-1190692026-06-07T10:17:43ZKellyU··Patterson19481203UHC-93961-32•••-••-7266605-379-8623kelly.patterson11@hotmail.com·124 Grand AvenueGilbertAZ85259GRP-3800SELECT-EPO
CLMCLM-4285362026-04-07T16:19:49Zvictoria—coleman1979-06-14UHC4837466•••-••-5615N/A··7682 VALLEY VIEW DRScottsdale··AZ85292UNKNOWNnull
CLMCLM-4271432026-07-30T21:35:58ZMargaret—Foster1950-06-28UHC-01099-35—N/A—9550 Highland AvenuePhoenix·AZ85045—MEDICARE-ADV-A
ENR ENR-1341352026-06-30T05:59:40ZANN··R.··BANKS19960614UHC-98310-32•••-••-4380594.714.5082··-1224 Park Pl·DALLASTX75244GRP-6572select-epo
TPATPA-517712026-09-04T14:52:13ZGABRIELCPAYNE1954-05-06-——gabriel.payne92@icloud.com379 Spring StSan DiegoCA92184···NULL—
ENR ENR-1312372026-07-12T06:55:53ZSAMUEL—MARTINEZ1993-03-02uhc-63883-31•••-••-3393204.445.0890·samuel.martinez55@icloud.com3969 LAKE VIEW RDSan AntonioTX78262GRP-8231CHOICE-PLUS-PPO
ENRENR-1402872026-03-01T18:08:22ZCamilaACastillo07/24/00UHC-26142-58•••-••-5484308.475.0346—7096 Central AvenueTampaFL33614GRP-1495MEDICARE-ADV-B
CLMCLM-4213162026-08-11T16:13:46ZABIGAIL—SOTO1975-12-20—•••-••-4347453-303-0412N/A——UNKNOWN··—GRP-5127options-ppo
100,000 rows, page 207 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:37.724Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty