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-4270262026-02-12T06:34:51ZMEGAN—GRANT1953-01-22——658-357-5003N/A9586 Forest AveGlendaleAZ85306GRP-0729N/A
PRVPRV-236332026-05-09T13:04:47ZLane, Kathleen——2001-01-26—UNKNOWN(494) 972-5027KATHLEEN.LANE@YAHOO.COM7643 HIGHLAND AVENUE Apt 13MiamiFL33193-NULL
CLMCLM-4257452026-09-23T07:57:26ZJAMEES—·LI·03-12-2003NULLNULL——823 Bayshore DriveHoustonTX77063GRP-7745—
PRVPRV-260732026-08-13T04:52:16ZDIEGOHPATEL1946-05-27null—676.629.7575··-4558 SAGE COURTPlanoTexas75023UNKNOWNUNKNOWN
ENRENR-1290792026-10-06T09:23:58Z·PatrickCPerry03/14/41UHC-46043-58•••-••-9912·7205086916PATRICK.PERRY84@AOL.COM1482 Indian School RdMinneapolisMN55408··GRP-6710CORE-HMO
ENRENR-1283062026-08-22T16:29:36ZERICFREED··1963-01-18UHC-79375-83•••-••-67702111128null8032 Market St Apt 36DenverCO·80263GRP-0990MEDICARE-ADV-A
CLM CLM-4073182026-01-03T11:25:12ZJASONH.FOWLER19400826··UHC-57273-87——-—NULLUNKNOWN—GRP-9059NULL
TPATPA-510062026-08-25T10:23:16ZETHAN—DANIELS26-09-1950UHC-99842-56null—NULL-NULLNULLnull——
CLMCLM-4011372026-01-10T07:38:51ZNATALIEHWILLIAMS1960-03-13—•••-••-70744678449886null-—UNKNOWN—N/A—
CLMCLM-4136902026-10-17T11:44:19ZVIRGINIA—ROBERTS··1992-01-18UHC2329208nullUNKNOWNnull1146 Sunset BoulevardLOS ANGELESCA90079—CORE-HMO
CLM CLM-4174302026-03-27T20:34:03ZMariaRJenkins1941-07-28N/A—3763851298-771 Ridge RdDenverCO····GRP-5840—
TPATPA-61849 2026-05-14T22:07:49ZDEBORAH—MARTIN1956-07-01·UHC5213904—NULLdeborah.martin68@outlook.com8438 Ridge RoadHoustonTX77077UNKNOWNSELECT-EPO
ENRENR-1146182026-02-28T03:37:23Z·JeanU.Thomas9/5/1942UHC-89179-46•••-••-6794(229) 920-8257JEAN.THOMAS@YAHOO.COM7194 Ocean AveScottsdaleAZ85242GRP-1854MEDICARE-ADV-B
TPATPA-633502026-05-09T04:50:41ZGABRIEL··PRICE1985-07-23-··•••-••-30545046017098N/A3420 Elm StLAS VEGASNV··89103—OPTIONS-PPO
ENRENR-1153662026-10-09T22:02:01ZJacob··Richards08/16/03UHC-68186-91•••-••-17014035636538N/A5371 Lincoln WayAUSTINTX78733GRP-2775MEDICARE-ADV-B
ENRENR-1216962026-03-26T04:40:28ZBrittany—Gilbert02/15/2002UHC-09613-64NULLUNKNOWNbrittany.gilbert19@hotmail.com4053 Ridge RdATLANTAGA··30382GRP-5128MEDICARE-ADV-A
ENRENR-1287572026-03-07T18:08:57ZHannah—Carlson1975-11-20UHC1489354•••-••-005317082454469HANNAH.CARLSON61@ICLOUD.COM2563 Forest AvenueCharlotteNC28277GRP-2002SELECT-EPO··
TPATPA-568972026-06-29T04:14:16ZWalsh, Henry——27-08-1949null··18319492219··HENRY.WALSH@GMAIL.COM7903 Meadow LnGilbertAZ··85277-1631UNKNOWN—
ENRENR-1423262026-04-18T18:41:08ZCARLZ.WEST1/6/1992·UHC4211204•••-••-5055·6097489464carl.west73@yahoo.com3663 GRAND AVEGlendaleaz85353GRP-1270NAVIGATE-HMO··
PRVPRV-246292026-05-26T19:36:45ZTheresa—Young19400110··•••-••-25562378236056-97 BroadwaySacramentoCA·95843-3751··—
ENRENR-107336 2026-04-01T16:55:54ZAaron··UMorrison1970-05-11UHC-12185-91··•••-••-2776(757) 363-4652aaron.morrison30@hotmail.com6790 SAGE COURTNashvilleTN37223GRP-4365CHOICE-PLUS-PPO
CLMCLM-4176552026-01-05T12:06:00ZROY—POWELL1957-05-17UHC-89409-50null··(536) 241-3046—5845 Main StDALLASTXN/AGRP-0937NAVIGATE-HMO
ENRENR-1098132026-07-13T04:58:54ZMason—Ramirez03-05-1964UHC-58089-01··•••-••-01055642570MASON.RAMIREZ@GMAIL.COM3165 Spring StreetFresnoca93769··GRP-7674CHOICE-PLUS-PPO
TPATPA-504322026-03-31T09:57:15ZTheresa—·Santiago03/28/1976··—N/AUNKNOWNNULL9056 Bayshore DrivePhoenixAZ85029UNKNOWN····
ENRENR-1202522026-10-02T08:28:13Zbobyb—chapman14-07-1998UHC-34658-22null6199083428bobby.chapman12@gmail.com3244 Central AveSan Diego··ca92182·GRP-1118SELECT-EPO
CLMCLM-4250962026-07-29T21:26:20ZWhite, ValentinaT—10/18/1946UHC-42715-20—+1 598 915 3520-5207 Jefferson AvenueGilbertAZ85222GRP-0450CHOICE-PLUS-PPO
ENRENR-1267972026-02-20T06:21:23ZKelly····Phillips6/3/1999UHC-92671-52•••-••-66417003394KELLY.PHILLIPS24@ICLOUD.COM7460 Sunset BlvdJacksonvilleFL32292GRP-8356MEDICARE-ADV-B
ENRENR-1262902026-10-17T02:22:42ZSOFIAQWILLIAMS1970-02-20UHC-94539-95•••-••-8854(256) 356-5103SOFIA.WILLIAMS@HOTMAIL.COM3918 Pine Drive··AustinTX78796GRP-3178··CHOICE-PLUS-PPO
CLMCLM-4061262026-05-08T01:21:10ZmichelleWnelson08/08/1947UHC-68864-27nullN/AUNKNOWNUNKNOWNUNKNOWNNULL—GRP-2787N/A
TPATPA-523942026-05-21T23:42:07ZDiane····Santigao1982-08-20N/A•••-••-8297612-483-5022null—UNKNOWNUNKNOWNnull—-
ENRENR-1201852026-03-10T04:17:35ZteresaG.grdon1991-07-14UHC-38136-28•••-••-81219567337385TERESA.GORDON67@OUTLOOK.COM1022 Camelback RdEden PrairieMinnesota55372GRP-6360SELECT-EPO
CLMCLM-410618 2026-10-11T23:40:09ZSanders, Ronald—····08/24/78UHC3163229———7520 Church StMinneapolisMN55414GRP-6303—
ENRENR-1337942026-09-15T17:05:57ZPerry, Denise——1957-06-25UHC-72358-97•••-••-27219299768570denise.perry93@aol.com7200 Forest Ave··Orlando··FL32862GRP-0609MEDICARE-ADV-A··
CLMCLM-4281232026-02-17T18:55:18ZDylan—Day11/15/46UHC-32420-88nullN/A·null8287 Central AvenueGilbertAZ85275·GRP-9281CORE-HMO
CLMCLM-4217792026-07-17T00:56:03ZAnderson, RachelU—1940-09-13··—•••-••-39456015173508NULL8708 Union StLas VegasNevada89130N/A···NAVIGATE-HMO
PRVPRV-279332026-05-12T21:12:08ZTerry—Lane22-07-2004UHC-64702-47—·(690) 702-5122terry.lane47@gmail.com5422 CANYON ROADSacramentoCA95833UNKNOWN—
ENRENR-1397942026-03-25T06:10:27ZBRIAN—BURKEJun 24, 2003uhc-91013-14··—9425866095brian.burke@gmail.com4636 Union StreetFresnoCAnullGRP-6879CHOICE-PLUS-PPO
CLMCLM-4136452026-04-23T17:45:52Z DianaYWeaver2001-11-18UHC4728885NULL——7705 PARK PLACEMiamiFL33157GRP-7396····
CLMCLM-4034822026-06-21T03:00:17Z nicole—lucas1989-08-13NULL•••-••-621115065642684—1029 Elm StreetEden PrairieMN55345GRP-3868N/A
CLMCLM-4182002026-09-21T18:40:58ZLaura··Guzman1971-04-20N/A-+1 884 768 3138N/A3197 Ridge Road Apt 3PlanoTX75022-8131N/AMEDICARE-ADV-A
ENRENR-1338882026-01-26T15:03:05ZSANTIAGO···HUNT19660321UHC6595430•••-••-4815(551) 613-1042santiago.hunt@aol.com8227 Apache BoulevardEden PrairieMN55369GRP-9147MEDICARE-ADV-A
CLMCLM-4003522026-05-28T06:30:33ZMASON—KYLE2008-01-36··UHC-92667-29•••-••-7598941-380-4832-9092 PARK PLOrlandoFL32888GRP-3399··—
ENRENR-1004662026-05-01T17:10:59ZAmberPNguyen02/06/74UHC-57730-01•••-••-4536(756) 306-8536amber.nguyen@gmail.com6177 MOUNTAIN VIEW DRIVESacramentoCA95815-1378GRP-4426SELECT-EPO
ENRENR-1052312026-10-11T13:00:23ZMaryD.Romero·04/13/43UHC-71438-17•••-••-9554(587) 970-0560NULL1277 RIVER RDDenverCO80265GRP-6185MEDICARE-ADV-B
CLMCLM-4245472026-01-07T08:57:20ZWilliam—Allen2006-07-18UHC-31377-42NULL(803) 311-7613—····-UNKNOWNnullN/Anull··
ENRENR-1039732026-06-23T10:46:24ZJEAN·NSANTIAGO1943-08-12UHC-49960-87•••-••-1516578-661-3242jean.santiago@gmail.com3517 Highland AvenueLos AngelesCA90038GRP-6746CORE-HMO
PRVPRV-272002026-02-02T15:28:48ZAMYYSIMPSON19401205N/A—N/AN/A7977 BAYSHORE DRJacksonvilleFL32260——
ENRENR-1209562026-07-17T14:51:35ZJUDITH—·LUCAS19813208UHC-82017-35•••-••-2317428-405-0195judith.lucas47@hotmail.com5675 BAYSHORE DR #815OrlandoFL··32894GRP-6205options-ppo
ENRENR-1276522026-02-05T19:44:13Z joseJchapman1947-03-16UHC-16119-29•••-••-8839971.326.5250—3582 PINE DRIVESacramentoCalifornia95883GRP-2013CHOICE-PLUS-PPO
CLMCLM-4198902026-01-13T16:19:57ZelijahO.adams1968-01-13N/A•••-••-6532——4148 Highland AvenueDenverCO·80274UNKNOWNOPTIONS-PPO
100,000 rows, page 60 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.784Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty