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-1288332026-02-23T08:21:52ZSanchez, Mason——1944-03-26UHC-88232-95•••-••-9766UNKNOWNmason.sanchez@aol.com3167 Market StreetLas VegasNV89174GRP-8704SELECT-EPO
ENRENR-1005012026-04-12T02:05:02ZDonna S—Sullivan1995-08-15·UHC-77457-37•••-••-89987805569180··—3502 LINCOLN WAYDenverCO80223GRP-2806·MEDICARE-ADV-B
CLMCLM-4090492026-05-07T04:48:54ZTHOMAS—WELCH2/15/2007—•••-••-7713nullnull··NULLN/ANULLGRP-3343-
CLM CLM-4047732026-10-10T05:57:38ZMike···Nelson1938-06-07····•••-••-5257——1008 Pine Drive Apt 16SacramentoCA95849—UNKNOWN
TPATPA-608372026-02-14T14:40:43ZDiana—Castro1977-10-11nullN/AN/A—2172 Ocean AvenueOrlando·Florida32838—MEDICARE-ADV-A
ENRENR-1294862026-06-22T17:33:10ZelijahWnguyen1959-04-05UHC-09664-15•••-••-1508566-519-8562elijah.nguyen@yahoo.com858 Jefferson AvenueSAN ANTONIOTX78231GRP-6062CORE-HMO
CLMCLM-4152472026-05-18T12:09:00ZJeremy—VegaAug 14, 1977—NULL12019487213UNKNOWN-N/AUNKNOWNN/A··UNKNOWNOPTIONS-PPO··
ENRENR-1024672026-09-27T00:55:05ZMarcus—Burns1963-11-06UHC-60909-93•••-••-7203597-639-0301N/A2528 Mountain View DrivePlanoTX75058GRP-4408SELECT-EPO
ENRENR-1070952026-01-16T15:02:37ZCooper, JudithH··1957-01-28UHC-10497-18•••-••-70739665560317—·6211 PALM DRIVEEDEN PRAIRIEMinnesota··55331GRP-3972·CORE-HMO
TPA TPA-634932026-06-20T20:19:52ZJackson, Russell——2001-02-14nullnull——3483 Desert Sky BlvdMesaAZ85242-—
ENR ENR-1360632026-05-01T19:29:19ZBrian—MatthewsSep 19, 1963··UHC-27327-14•••-••-9940(264) 316-4895brian.matthews16@aol.com6673 MEADOW LANEMIAMIFL·33132GRP-9763CHOICE-PLUS-PPO
ENRENR-1031422026-09-12T05:05:06Zelizabeth·V.freemanSep 3, 1945··UHC-10340-59•••-••-1010942-661-5399elizabeth.freeman@proton.me3288 VALLEY VIEW DRDenverCO80200GRP-7881OPTIONS-PPO
CLMCLM-4212812026-02-20T17:41:41ZHall, Terry——1988-07-22UHC-83199-44•••-••-2830(761) 479-6806--—null—GRP-2974NAVIGATE-HMO
PRVPRV-205682026-07-16T18:57:23ZSara—·Holmes12/28/1940··—NULL(439) 437-9229null31 CEDAR LNFresnoCA93736—null
ENRENR-1328042026-05-22T23:14:29ZcharlotteDhunter1980-03-17UHC7879132•••-••-1394(669) 458-7562charlotte.hunter81@gmail.com7332 Park Pl #734PlanoTX75075GRP-8429MEDICARE-ADV-A
ENRENR-1398872026-09-12T05:11:12Z Roger—Bailey1/21/1992··UHC-31418-13•••-••-7014-roger.bailey@aol.com6556 WILLOW COURTDenverCO80238GRP-4154MEDICARE-ADV-A
TPA TPA-598082026-02-26T19:28:12ZRYN—REED·01/18/55NULL—UNKNOWNryan.reed@proton.me7022 Elm StreetCHARLOTTENC28289—UNKNOWN
ENRENR-1330822026-04-02T18:04:22Zlawrence—morris02/01/2001UHC-83952-82•••-••-2676·2765935lawrence.morris@hotmail.com3862 Meadow LnDenverCO··80215GRP-7322MEDICARE-ADV-A
TPATPA-615332026-03-23T07:22:32ZMateo—Sims1959-11-11null—954-437-2608—7841 BAYSHORE DRIVEPhoenixAZ85007——
ENRENR-1194212026-04-13T02:37:37Zbenjamin—johnson06/12/89UHC-12502-35•••-••-4001(849) 234-1729benjamin.johnson@hotmail.com5056 Washington StDenverCO80203GRP-0171·NAVIGATE-HMO
ENRENR-1196292026-09-21T19:07:59ZJACKWBUTLER1943-09-03UHC-94540-99•••-••-79773673716195jack.butler@proton.me3465 BroadwayOrlandoFL32833GRP-7374CHOICE-PLUS-PPO
ENRENR-102811 2026-04-07T07:07:10ZgloriaRwashington1983-01-25UHC-72680-37•••-••-9818(963) 989-4896—9741 PALM DR··SeattleWA98178GRP-3957NAVIGATE-HMO
TPATPA-588272026-06-11T23:05:48ZLisaZBradley04/28/83—-645-850-1258—4817 Baseline Rd·NashvilleTN37263N/Anull
ENR ENR-1370742026-04-26T00:23:38ZMARKI.MORRISON19520608UHC-91026-20NULL803-684-7642MARK.MORRISON@AOL.COM4315 Grand Ave··ColumbusOH43278GRP-2277CORE-HMO
CLMCLM-4226262026-03-03T00:46:25ZIsabella—Hanson19690215UHC-86221-59•••-••-5580—isabella.hanson48@gmail.com6627 Apache BoulevardEDEN PRAIRIEMN55326UNKNOWN—
CLMCLM-4022932026-02-22T06:23:45ZTIMOTHY—BRYANT1965-02-15uhc-19534-28null··-—4738 Park Pl·PhoenixAZ85034—UNKNOWN
TPATPA-508342026-01-28T13:11:10Z Albert—Miller1940-02-09-nullUNKNOWN—5580 HILLCREST ROADOrlandoFL32870-4188—NULL
TPATPA-607982026-07-19T03:51:30ZEric····Castillo1996-03-25N/A•••-••-5503nullN/A8778 Ocean Ave #605MinneapolisMN55400GRP-0871CORE-HMO
ENRENR-106249 2026-06-25T22:35:03ZJohn—Mendoza8/28/1968UHC-10918-94•••-••-43945544966829john.mendoza@proton.me9176 Park PlLos Angeles··CA90037·GRP-5621CORE-HMO
PRVPRV-24408 2026-01-17T17:04:47ZAARON··STONE·1966-01-28nullUNKNOWN7802243948AARON.STONE@OUTLOOK.COM··14 Park Place Apt 6GilbertAZ85205UNKNOWN—
TPATPA-567222026-02-13T16:32:18ZAlan—Cole1941-01-04UNKNOWN•••-••-9544—····5628 FOREST AVEAustinTXnullGRP-6191MEDICARE-ADV-B
ENRENR-1016592026-08-07T01:08:23ZJeanMOrtiz···1969-08-16UHC-84970-67•••-••-34347277886712jean.ortiz@hotmail.com9151 Pine Dr··FresnoCA93768GRP-7467OPTIONS-PPO··
ENRENR-1077692026-03-20T15:46:46ZBryanLRoseJun 21, 2000UHC4377082•••-••-0709(922) 772-9481bryan.rose6@icloud.com4892 Baseline Rd #432NASHVILLETN37235GRP-7791MEDICARE-ADV-B
ENR ENR-1020392026-08-01T00:28:54ZRONALDJCRAWFORRD11/23/1946UHC-31165-99•••-••-6014246.440.5025ronald.crawford@yahoo.com8237 Apache Boulevard Apt 16San AntonioTX78278··GRP-7942OPTIONS-PPO··
ENRENR-1151142026-07-10T12:38:19ZFetima—WilsonAug 7, 2001UHC8774775•••-••-2798NULLUNKNOWN949 Highland AveDenverColorado80230GRP-2761CORE-HMO
CLMCLM-4069272026-06-15T18:29:02Z·Matthew—Castro19990228null•••-••-6767938.811.4111····3320 Willow CourtHoustonTX77062—MEDICARE-ADV-B
ENRENR-1183482026-09-09T06:18:50ZJESSE·CMATTHEWS1972-08-06UHC-03287-07•••-••-9836557-479-1019N/A6089 JEFFERSON AVENUETampaFL33654GRP-3909MEDICARE-ADV-B
TPATPA-613402026-01-29T04:46:05ZReyes, Aaron——1946-09-11N/A—240-610-6259aaron.reyes@hotmail.com7541 CANYON RDCharlotteNC28228GRP-1943N/A
TPATPA-563162026-10-01T03:47:02ZCheryl—Jacobs10-07-1974NULL—(835) 253-8081UNKNOWN8057 HARBOR BOULEVARDMinneapolis·MN55439GRP-5660SELECT-EPO
ENRENR-1390952026-07-23T12:29:44ZJosephMBell08/12/1958UHC-06078-43•••-••-7722N/A—2496 Lake View RoadTampaFL33671GRP-4399OPTIONS-PPO
CLMCLM-4215492026-09-05T22:08:17Z·JESSE—·CASITLLO1947-02-15UHC-64582-82•••-••-9415950.929.3843JESSE.CASTILLO59@OUTLOOK.COM-nullNULL—GRP-4491-
CLMCLM-4039892026-05-10T09:14:27Z———1940-06-06null•••-••-8370·····N/AnullN/A—-GRP-6323SELECT-EPO
ENRENR-1000112026-06-01T04:27:45ZAlexanderA··Arnold05/03/97UHC-19853-44•••-••-04638664890400alexander.arnold@proton.me3397 MAPLE AVENUEMesaAZ85265GRP-9329MEDICARE-ADV-B
ENRENR-1325212026-09-27T09:12:47ZDENNIS—HERNANDEZ1969-10-08UHC-11310-74•••-••-47425826675719··—7549 Harbor BoulevardDallasTX75229-6768GRP-7157SELECT-EPO
CLMCLM-4095892026-05-12T08:12:20ZAdamZ.Turnr1959-06-10—•••-••-2129819-960-3611adam.turner5@gmail.com6333 VALLEY VIEW DRFresnoCA93726-9349GRP-3334MEDICARE-ADV-A
ENRENR-141881 2026-02-07T03:09:12Z·MARILYNRBRADLEY·19660913uhc-97072-12•••-••-691217474024779—901 FOREST AVESeattleWA98166-9898GRP-3140MEDICARE-ADV-B
CLMCLM-4270632026-02-22T03:22:39ZAngela—EllisMar 3, 1999N/A··—N/A———UNKNOWN—GRP-1039CHOICE-PLUS-PPO
PRVPRV-281292026-07-25T08:45:12Z·Juditth—Brown05/01/49UHC-78195-69N/A242-458-7884····4374 Pine DrFresnoCA93704-2704UNKNOWNnull
CLMCLM-419766 2026-07-05T09:21:37Zchris··washington1996-03-01UHC-95770-57•••-••-3651890-886-8216—6603 Cedar Lane··CharlotteNC28218GRP-5847NULL··
ENRENR-1405692026-01-06T19:38:31ZALEXIS—OLSON2008-02-14UHC-58648-50•••-••-7530(341) 704-2802N/A9506 Palm DrGilbertAZ85231-9860··GRP-8310SELECT-EPO
100,000 rows, page 190 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.718Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty