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-1054292026-05-19T10:28:32Z ZACHARY··R.LUNA3/4/1949UHC-56365-90•••-••-2682(499) 382-5921—8165 Harbor BoulevardGlendaleAZ85350GRP-7241SELECT-EPO
CLMCLM-4153502026-05-20T01:12:32Z·Margaret—OBrien1996-11-16UHC-43459-75-—·nullUNKNOWNN/A·NULL-GRP-8513null
PRVPRV-236672026-04-29T14:54:17Zdennis—·castro20000506·UHC-54013-05•••-••-9730·326.844.2329dennis.castro@yahoo.com5520 Washington StMiamiFL33174—··
CLMCLM-4034352026-04-22T00:03:28ZRYAN··PATEL2008-04-15—NULLNULLRYAN.PATEL@YAHOO.COM2016 PINE DRIVESAN ANTONIOTexas78270GRP-3701-
CLMCLM-4217712026-01-08T18:08:44ZJOSE—PEREZ19800425UHC-94809-39•••-••-7105(626) 556-7316·N/A—nullUNKNOWN····GRP-6901N/A
CLMCLM-4245722026-01-01T18:03:49ZGary—Knight02-09-1974UHC-98151-65null—NULL———N/AUNKNOWNMEDICARE-ADV-B··
ENRENR-1189622026-02-15T09:29:34ZCHRISTIANDORTEGA19891028UHC-60388-18•••-••-7825368.361.9780UNKNOWNUNKNOWNNULL——GRP-7093·OPTIONS-PPO
ENRENR-1325172026-10-14T21:39:29ZKelly—·Carpenter2004-07-26UHC-64131-81•••-••-4358+1 901 559 7621kelly.carpenter@outlook.com9304 Mountain View DriveORLANDOFlorida··32878GRP-0812SELECT-EPO
CLM CLM-4259152026-07-31T15:23:47ZRuth—Ross04/21/70N/A-UNKNOWN·NULL3071 Canyon RoadPhoenixAZ85096GRP-5355CORE-HMO
CLMCLM-4125892026-03-02T23:28:35ZRoss, Jesse——07/10/40UHC-10623-58NULL··UNKNOWNjesse.ross81@proton.me—null-··null—SELECT-EPO
ENRENR-1007982026-06-20T09:45:34ZALAN—CONTRERAS1939-06-09UHC9686671•••-••-5516539.429.1294alan.contreras29@gmail.com··7196 BAYSHORE DRIVETampa·FL33627GRP-7998CHOICE-PLUS-PPO
CLMCLM-4071512026-01-21T18:25:30ZHannah—Rose19691116——+1 246 535 5809NULL3727 Sunset BlvdDenverCO—GRP-0531—
ENRENR-1367892026-07-19T10:48:00ZSharon·KTorres1996-03-18UHC-27817-88•••-••-5806(258) 728-1043SHARON.TORRES22@AOL.COM2398 Highland Ave #363DallasTX75299GRP-8284SELECT-EPO
ENRENR-1386942026-05-30T14:20:15ZMELISSA—SOTO2005-02-14UHC-93543-82•••-••-5540364-525-1963-8505 Valley View DriveEden PrairieMN55350GRP-2615OPTIONS-PPO
TPATPA-515012026-03-30T07:39:57ZJustin—Fisher3/26/1939—UNKNOWN··NULL5138 Central AveMinneapolisMN55450GRP-0171NULL
ENRENR-1367702026-05-25T00:58:15Zdonald—santos91590811UHC-53519-21•••-••-7641+1 511 516 1080DONALD.SANTOS39@YAHOO.COM2431 Indian School RoadColumbusOhio43292GRP-9094MEDICARE-ADV-B
PRVPRV-207312026-01-29T01:57:08ZAUSTINCHOLMES1976-02-25N/A—3899321696NULL2810 Spring Street #349SAN DIEGOCA92123null-
TPATPA-574372026-07-10T15:36:40Zandrea—casitllo1989-08-21—•••-••-8983—null6085 Camelback RoadPhoenixAZ85044NULL—
ENRENR-1206052026-06-22T11:37:05ZRonaldJ.Wilson1978-08-14UHC-62608-94•••-••-4621863.560.6194NULL7705 Desert Sky Boulevard·OrlandoFL32822GRP-7036MEDICARE-ADV-B
ENRENR-1016612026-10-17T11:31:46ZChristopher—Coleman1950-04-12UHC-32322-15•••-••-6233597.288.6469null1911 OCEAN AVEMIAMIFL··33172··GRP-3054SELECT-EPO
ENRENR-1411852026-02-12T02:06:01ZCook, Kyle——2001-09-07UHC-25023-44•••-••-448212166147611N/A9327 BroadwaySCOTTSDALEAZ85241GRP-3240MEDICARE-ADV-B
TPATPA-571372026-02-13T03:46:22ZMARIA—CHEN09-10-2006UNKNOWNnull-··—5649 Elm StreetEden PrairieMN55345——
TPATPA-581392026-09-04T10:54:14ZjackYdunn2007-02-20-······JACK.DUNN1@OUTLOOK.COM414 Broadway Apt 40NashvilleTN37216GRP-7721—
CLMCLM-4217972026-07-29T02:12:51Z·Kathleen—·Tran1975-04-20UHC-59783-86•••-••-488513623599237-4373 Central AvenueMIAMIFL33166GRP-3439null
CLMCLM-4165092026-02-14T12:43:12ZRoy—Watson1990-06-04——523.827.1614—9508 Park PlScottsdaleAZ85285GRP-3749choice-plus-ppo
CLMCLM-4103482026-02-22T19:49:01ZDiana—Mills1941-03-15UNKNOWNnull(971) 519-3934DIANA.MILLS@YAHOO.COM3531 Market StreetAustinTX78771GRP-8540NAVIGATE-HMO
ENRENR-1048192026-09-20T15:37:14ZKarenCSanders1938-12-05UHC-22618-73•••-••-1217(583) 394-0764KAREN.SANDERS15@PROTON.ME2097 Union StreetChandlerAZ85273GRP-2110SELECT-EPO
CLM CLM-4253152026-07-15T19:49:02ZRalphP.··Henderson1/1/1993UNKNOWN—254-794-1469—--NULLnullGRP-2556UNKNOWN
TPATPA-61926 2026-08-19T23:25:14ZSarah··—Carroll1969-05-06UNKNOWN—UNKNOWN—UNKNOWN—nullNULL—NAVIGATE-HMO
CLMCLM-4183412026-05-05T21:04:16ZDouglasH.Gomez1989-08-20UHC-25187-47•••-••-4667—douglas.gomez@aol.com—-·N/A—·GRP-3986····
ENRENR-1000302026-08-07T11:50:56ZEmmaFScott1975-09-03UHC-71092-24•••-••-4270(789) 271-1737emma.scott@outlook.com1376 Hillcrest RoadPhoenixAZNULLGRP-6069MEDICARE-ADV-A
ENRENR-1014762026-02-10T10:48:41ZLOGAN—SIMS1982-02-26UHC-95454-32•••-••-5010(253) 818-0435logan.sims63@hotmail.com539 MEADOW LANEHouston·TX77006GRP-1881NAVIGATE-HMO
CLMCLM-4161072026-10-05T05:47:40ZRaymnd—Duncan06/13/1986UHC-84562-95NULL2309328749NULL———-GRP-5757—
CLMCLM-4018652026-05-28T08:45:38ZGARY—·WALKER1999-02-04null····785-304-5209null6703 Cedar Lane·San DiegoCA92189··NULL—
TPATPA-60548 2026-09-06T14:49:03ZAndrea—Rivear01/09/46N/A·N/AUNKNOWNNULL·-UNKNOWN——N/A-
CLMCLM-4068962026-04-15T04:41:16Z·PatrickV.Cunningham1958-10-14UHC-50542-14UNKNOWN211-813-6467—2632 Canyon RdTucsonAZ··85739GRP-3762CORE-HMO
TPATPA-628152026-03-06T20:17:03ZAndrea··Morrison1968-07-20··—•••-••-6127—-7960 JEFFERSON AVE #395HoustonTX77095GRP-8071··OPTIONS-PPO
TPATPA-502552026-04-26T13:14:27ZRoger—Bell1986-11-02N/A•••-••-1403·null—7058 Meadow LnMiamiFlorida33133GRP-8391MEDICARE-ADV-B
CLMCLM-4103872026-08-29T04:02:05ZJeeremy—Cook1948-08-19UHC-20902-98null5055715690··-7234 Indian School RdColumbusOH43239-7557·GRP-7088CORE-HMO
PRVPRV-291702026-09-10T08:40:08ZCHRISTINE—ROBINSON6/5/1972UHC-30697-65NULL··513.371.9111—9172 MEADOW LANE··Las VegasNV89111—NAVIGATE-HMO
ENRENR-1403322026-06-27T01:07:29ZBanks, Brittany—··1948-07-03UHC-86957-86•••-••-30809155051099brittany.banks@aol.com493 Camelback RdOrlandoFL32858GRP-3018OPTIONS-PPO
ENRENR-1378772026-05-08T12:41:45Z Perez, Luis··——2002-08-15UHC-57144-77•••-••-1347883-933-8205luis.perez@icloud.comnullNULLnull—GRP-7436OPTIONS-PPO
ENRENR-1124892026-08-03T05:30:12Z BRANDON··B···RYAN1973-09-13UHC-38669-58•••-••-9160(318) 253-9892UNKNOWN8174 BroadwayEDEN PRAIRIEMN55311··GRP-5707··SELECT-EPO··
PRVPRV-218822026-09-28T06:34:26Z———1945-05-06UHC-12903-25UNKNOWN8283946181N/A8733 PARK PLLos AngelesCANULLnull-
ENRENR-1003932026-01-21T05:06:44Z Alan—Herrera1946-03-09UHC-14048-79•••-••-7482(221) 540-3363alan.herrera@gmail.com6548 Sunset BlvdCOLUMBUS··OH43272GRP-9012CORE-HMO
CLMCLM-4271672026-07-31T05:35:00ZJOHN··——1969-04-10·UHC-98605-67-——nullNULLN/A-GRP-0627—
CLMCLM-4200892026-10-09T20:55:41ZAlbert—Wells1942-06-27UHC-36051-25•••-••-6845nullALBERT.WELLS5@OUTLOOK.COM··5848 Market StPhoenixAZ85039GRP-9218NULL
ENRENR-1307412026-03-13T19:52:50ZCATHERINE—DUNN01/15/2006UHC-47487-63•••-••-9450(365) 445-6298CATHERINE.DUNN@AOL.COM3644 Elm St·Las VegasNV89147GRP-8345·SELECT-EPO
CLMCLM-4191112026-10-10T10:15:43ZJackie—Nelson1956-08-17N/A-nullnull9235 JEFFERSON AVENUELOS ANGELESCA90026-N/A
ENR ENR-1124582026-09-26T19:20:53ZEmilyWBurns1967-05-03UHC-65846-64null289-339-6858emily.burns76@hotmail.com3055 DESERT SKY BOULEVARDCharlotteNC28265GRP-6280OPTIONS-PPO
100,000 rows, page 106 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.679Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty