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-114267 2026-04-28T16:08:26ZBruceHPerkins4/11/1997UHC-22797-74NULL988-605-6822bruce.perkins10@proton.me··2502 CHURCH STOrlandoFL32874GRP-4597MEDICARE-ADV-A
CLMCLM-4286212026-06-08T14:24:36ZNATALIE—PALER1959-12-10UHC-45579-15•••-••-5830·8732669924N/A1713 Ridge RoadOrlandoFL··32891·GRP-4234UNKNOWN
CLM CLM-4316702026-06-02T03:32:32ZSOPHIA—HALL1942-01-17UHC-60987-96•••-••-7967(557) 242-5063UNKNOWN6314 Ridge RoadLos AngelesCA90067-9901GRP-9745medicare-adv-a
ENR ENR-135276 2026-01-03T06:34:03ZAmanda—Santiago1951-07-28UHC-25419-96•••-••-444718874936783·amanda.santiago97@proton.me275 Park PlAustinTX78788GRP-2680MEDICARE-ADV-B
CLMCLM-4069592026-08-21T05:01:33Z·JOE····CARLSON05/21/2001—•••-••-81584792771673—9839 Harbor BoulevardSan AntonioTX78297GRP-6953····
CLMCLM-4153102026-09-02T16:48:53ZBrandonG.Rivera1991-04-07UHC-19255-33•••-••-2281null··—null-null——OPTIONS-PPO
ENRENR-1226772026-09-22T00:00:53ZJack—Campbell3/16/1968UHC-15180-41•••-••-2280(304) 326-0715jack.campbell86@outlook.com1440 Grand AveLas VegasNV—GRP-1631NAVIGATE-HMO
CLMCLM-4087802026-05-11T10:09:32ZRANDY··HERNANDEZ1980-10-19—null846-854-6648·-5165 Grand AvenueDenver··CO80243-2978GRP-2523MEDICARE-ADV-A
CLM CLM-4310592026-06-14T09:32:01ZJON—HUNT05/28/91—-(233) 893-2043—UNKNOWNNULL—nullGRP-6553N/A
ENRENR-1381372026-01-22T14:23:35ZpeterIcarlson5/26/1949UHC-51214-95•••-••-2584(259) 270-1194peter.carlson@aol.com206 MAPLE AVETempeArizona85230GRP-7869··MEDICARE-ADV-B··
TPATPA-619292026-09-30T03:37:22ZAARONZMURPHYJan 6, 1966····•••-••-6162(957) 732-7505—5832 Mountain View DrChandlerArizonaN/AGRP-8441null
ENRENR-1127522026-09-19T16:40:24ZKELLYEFLORES04/25/1971UHC-51326-64—(323) 244-9263kelly.flores27@aol.com4492 PARK PLACEScottsdaleArizona85258GRP-8390·options-ppo
CLMCLM-4282502026-07-12T06:16:12ZMark—Ferguson2006-06-06UHC-22617-37null··NULL—UNKNOWN—·NULL-GRP-5861-··
ENRENR-1272622026-01-15T20:57:20Zrebecca··Dhenry05/02/1995UHC-09021-94•••-••-4685(967) 967-0897REBECCA.HENRY@PROTON.ME8916 SPRING STREET·Los AngelesCA-GRP-0626MEDICARE-ADV-B
ENRENR-1022912026-09-29T20:07:10ZOMAR··ZCRUZ22-12-1940·UHC-43088-14•••-••-4296·NULLN/A6656 Desert Sky BoulevardFRESNOCalifornia93740GRP-5317CHOICE-PLUS-PPO
ENRENR-1043082026-06-15T18:08:04ZCarlson, Madison L——1311-20-06··UHC-83035-31-926-353-7422madison.carlson28@gmail.com789 Willow CourtDenverCO80287-5393GRP-4102CHOICE-PLUS-PPO
ENRENR-1155272026-07-09T23:39:48ZLuis·H·Munoz1963-10-07UHC-84496-65•••-••-3482568-311-3536N/A8503 Oak StreetAtlantaGA30354-1663GRP-9827OPTIONS-PPO
ENRENR-1376702026-07-19T15:37:27ZFrances—Spencer1992-07-12UHC7156741•••-••-46334759978054frances.spencer@icloud.com1557 Spring StSAN DIEGO·CA92173··GRP-0253OPTIONS-PPO
PRVPRV-280422026-06-01T20:02:29ZGloriaWWardSep 2, 1968··UNKNOWNnull496-892-4413gloria.ward92@yahoo.com-N/A—NULLUNKNOWNN/A
TPATPA-555762026-06-20T14:45:57ZJanet—Carpenter19870509UNKNOWN-NULL—9345 Sunset BoulevardAtlantaGA30390-3946GRP-6907NULL
ENRENR-1114262026-03-05T05:50:24ZterryZaustin1950-11-15UHC-94531-66null8574219838TERRY.AUSTIN99@PROTON.ME3745 PARK PLACE #465GLENDALEAZ·85389GRP-6042MEDICARE-ADV-A
ENRENR-1173632026-02-16T22:32:06ZARJUNCCRUZ2002-01-18UHC-63818-91•••-••-6631761-478-0340arjun.cruz@hotmail.com2954 PALM DREden Prairiemn55315GRP-7980SELECT-EPO
ENRENR-1137172026-01-28T16:17:59ZMARGARETL··OWENS··1976-07-02UHC-56821-54•••-••-7933(866) 353-9190UNKNOWN549 Oak StreetTampaFL33638·GRP-5350MEDICARE-ADV-B
TPATPA-537742026-08-09T15:04:29ZMurphy, Susan······1996-06-03··NULL•••-••-3532UNKNOWN——UNKNOWNUNKNOWN--null
ENRENR-1104542026-06-12T09:12:50ZCHRISTINEFHAWKINS19600302UHC-65939-84•••-••-4974—N/A5849 Harbor BoulevardSan AntonioTX78254GRP-6941CORE-HMO
CLMCLM-4200492026-10-03T04:54:25ZAlanO··Pierce·19700122-•••-••-5293nullnull4710 CAMELBACK RDCHARLOTTENC28235GRP-4301NAVIGATE-HMO
TPATPA-553842026-08-10T20:23:52ZMontgomery, Joan——6/7/2006——·····UNKNOWN2668 Park Place·GlendaleAZ·85327nullNULL
ENRENR-1306392026-03-03T19:54:58ZValentina—·Freeman1967-01-26UHC6421141•••-••-8501(684) 472-1103valentina.freeman66@gmail.com5602 Harbor BlvdLas VegasNV89139GRP-9767NAVIGATE-HMO
ENRENR-1222492026-04-14T17:31:26ZNatalieOShwa1966-08-15UHC-04451-66•••-••-0843(239) 601-4239NATALIE.SHAW@PROTON.ME491 Palm DrSACRAMENTO··CA95819GRP-7134MEDICARE-ADV-A
CLMCLM-4241602026-06-29T01:54:35Zranyd—maldonado1963-10-24N/A•••-••-51695507664265—8563 Apache BlvdGLENDALEAZ85369nullMEDICARE-ADV-A
ENRENR-1173042026-08-30T10:01:24ZNATHAN—FERNANDEZ1993-03-22NULL•••-••-5277591.992.3960nathan.fernandez23@proton.me5278 River RdJacksonvilleFlorida··32247GRP-9436SELECT-EPO
TPATPA-558722026-01-21T07:06:11Zpaul—patel·11/22/42N/A-——8622 Bayshore DriveTucsonAZ85741GRP-1068·CHOICE-PLUS-PPO
CLMCLM-4189032026-01-19T16:09:21Z AUSTIN··BRYANT1970-09-14NULL—··N/A··—-UNKNOWNNULLN/A-
TPA TPA-611752026-09-19T21:34:26ZGlooria··—King19760072UHC-54429-89UNKNOWN—N/A932 OCEAN AVE Apt 5Denver·CO80271——
PRVPRV-212472026-02-12T09:22:45ZTereasNGeorge02-06-1971··nullnull(498) 560-3209teresa.george62@outlook.com·1320 RIDGE RDSan DiegoCalifornia92124-0966UNKNOWN—
TPATPA-543332026-07-19T08:57:27ZAlexis—Ruiz1973-05-05NULL•••-••-7317··—3858 HARBOR BOULEVARDSacramentoCANULLUNKNOWN··MEDICARE-ADV-A
CLMCLM-4051792026-03-19T05:25:49Zmarilyn—aguilar1977-06-02UHC9737790···3483797null3638 Bayshore DrDALLASTX·75200GRP-8608··SELECT-EPO
ENRENR-1250752026-02-13T20:16:40ZGerald—Little11/14/1996uhc-94042-51•••-••-66886915941652GERALD.LITTLE@OUTLOOK.COM3476 OCEAN AVENUEColumbusOhio43297-8500GRP-1598NAVIGATE-HMO
CLMCLM-4245482026-01-09T00:49:28ZWilliam—Allen2006-07-18··UHC-31377-42•••-••-5813N/AN/A9630 Mountain View DrMiamifl33163GRP-8555OPTIONS-PPO
ENRENR-1170892026-10-13T21:27:44Zdot··H··bowman1944-05-01UHC-44242-68—2958774800dorothy.bowman22@gmail.com4394 Canyon Rd··GILBERT··AZ85292GRP-9860SELECT-EPO
PRVPRV-258152026-07-04T16:11:45ZWarren, Eugene——3/23/1965UHC-16651-20—573.990.4544··—4103 Bayshore Dr Apt 24GilbertAZ85277null-
PRVPRV-263902026-05-15T21:22:00ZPAMELAQGRANT06/15/49—•••-••-0999+1 712 335 3593·pamela.grant@proton.me6343 MAPLE AVENUEDenverCO80235N/A—
PRVPRV-225812026-03-26T12:06:23ZJUDITHH.LOPEZ1955-12-23UHC-71589-82—+1 865 650 4963-7203 Market StreetColumbusOH43283-0367N/ANULL
ENRENR-1049762026-05-13T20:26:44ZSusanBKim·1987-02-04UHC-90882-73•••-••-9200+1 938 572 3040SUSAN.KIM@GMAIL.COM9058 Camelback RdMinneapolisMN—GRP-6264··MEDICARE-ADV-A
CLM CLM-4064682026-07-19T08:41:32ZShirley—Collins07/07/60UHC-48765-83null209-998-9594null2678 PINE DRIVE #987TucsonAZ85790——
TPATPA-615452026-05-12T09:09:58ZERICMANDREWS1969-06-10null—845-789-3306-2279 Park Place·AustinTexas78750GRP-2936NAVIGATE-HMO
ENRENR-1372782026-02-27T22:33:52ZCamilaXHill06/27/67UHC-12011-96•••-••-5524(404) 341-5428camila.hill@yahoo.com8268 Broadway··Los AngelesCA90079GRP-2825··MEDICARE-ADV-A
ENRENR-1196022026-02-02T02:27:20ZMADISON—WHEELER1971-01-22UHC-77320-73•••-••-9354(549) 630-3576—1054 Market StFresnoCA93735GRP-8073MEDICARE-ADV-A
ENRENR-1375362026-02-25T18:23:42Z·MARKA.YOUNG5/20/1967UHC-00268-39——MARK.YOUNG60@ICLOUD.COM··1847 Spring StChandlerAZ··85272-6558GRP-9727CHOICE-PLUS-PPO
CLMCLM-4236292026-10-08T08:45:51ZKnight, Joan——1997-11-15UHC-05751-15•••-••-0027941.470.3845—3802 Highland AvenueFresnoCA·93796GRP-2850UNKNOWN
100,000 rows, page 82 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.797Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty