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-1008552026-08-07T22:20:31Z·RUSSELL—COX9/22/1996UHC-24189-14•••-••-2081-null4322 Market StJacksonvilleFL·32256GRP-0862CHOICE-PLUS-PPO
ENRENR-1199642026-06-13T01:31:34ZEUGENE—DEAN·1980-11-04UHC-92457-43•••-••-1734703-404-3731eugene.dean70@aol.com1663 Forest AvenueSacramentoCA95876GRP-5569MEDICARE-ADV-A
CLMCLM-4249742026-07-25T05:00:22ZTEERESA—BISHOP1961-04-10UHC-34907-30NULL6129120926NULL314 Church St #391TampaFL33601GRP-6012OPTIONS-PPO
TPATPA-582802026-01-19T01:23:13ZAnn—Garrett1977-01-19-UNKNOWN(486) 570-0176N/A6583 Oak Street #765HOUSTONTX77084-6656—·N/A
CLMCLM-4093542026-03-05T09:45:44ZMegan··Lee01/08/2001UHC-95660-41•••-••-9708(951) 644-2188—153 Bayshore DriveSacramentoCA95845GRP-9569MEDICARE-ADV-B
TPATPA-556022026-10-09T00:16:31ZMitchell, MateoY—09/13/1983NULLUNKNOWN291-708-0633————NULLGRP-2111—
ENRENR-1285232026-05-10T00:39:13ZkathrynCgriffin17-03-1964UHC-14344-06•••-••-30423524304520KATHRYN.GRIFFIN20@AOL.COM323 Jefferson AveChandlerAZ85298GRP-9306MEDICARE-ADV-A
TPATPA-570552026-09-04T09:27:15ZNOAHYHUGHES1954-12-24-•••-••-3288UNKNOWNUNKNOWN7724 Bayshore DrTempeAZ85246-3991nullCHOICE-PLUS-PPO
ENRENR-1412292026-10-07T17:50:05ZPRIYA—SANTOS1994-05-09UHC-17238-16—481.832.1581······686 Canyon RoadTampaFL33615GRP-8156OPTIONS-PPO
ENRENR-1072192026-03-30T00:34:36ZMEINWATKINS19860413UHC6259773•••-••-8117861-374-6117mei.watkins@yahoo.com2223 APACHE BLVDCHANDLERAZ-GRP-6331MEDICARE-ADV-A
TPA TPA-50147 2026-05-09T06:13:50ZJOEX·HUDSON1988-08-22-——-22 Grand AvenueScottsdale··AZ85213-··null
CLMCLM-4134552026-02-28T02:13:43Zhannha—ferguson11-12-1991UHC-39726-66•••-••-27145204389894hannah.ferguson@outlook.com3085 JEFFERSON AVENUEEden PrairieMN55306GRP-2310NAVIGATE-HMO
TPATPA-537922026-06-09T07:05:11ZLoriFDominguez2000-09-04—NULL—····NULL··—-NULLGRP-8624NULL
ENRENR-1270302026-09-21T08:36:28Z·Thompson, Juan·P—1991-10-12UHC-06717-95-703-219-7718juan.thompson7@gmail.com161 Ridge RdTampaFL33640GRP-9308SELECT-EPO
ENRENR-1162502026-09-30T14:36:16ZKarenLPena—UHC-22275-28•••-••-4071·+1 325 497 8420KAREN.PENA@OUTLOOK.COM1941 Harbor BlvdCharlotteNC28298-1994GRP-7694MEDICARE-ADV-B
CLMCLM-4311562026-03-13T16:44:30ZHelen—Munoz··23-08-1999—•••-••-4443·(650) 570-0591null7417 Forest AveSan DiegoCA92146GRP-1505-
ENRENR-1405922026-02-01T21:11:02ZWilliams, Benjamin——1947-06-24UHC-98822-50•••-••-4009·265.395.6142benjamin.williams81@outlook.com6053 Broadway·TUCSONArizona85739GRP-5785NAVIGATE-HMO
TPATPA-574482026-04-11T19:59:15ZJerry··Hughes26-05-1983null•••-••-5123-·JERRY.HUGHES90@YAHOO.COM1707 Hillcrest RoadSEATTLEWA98147-4864GRP-5996-
ENRENR-1206522026-04-11T14:38:58ZROY—HAALL2003-09-04UHC-75280-72•••-••-2350245-269-5122—2202 FOREST AVEHoustonTX77019GRP-7842··CORE-HMO
CLMCLM-4215612026-08-10T14:30:54Z·Billy—Williams·4/7/1950UHC-03915-92—·2515010182NULL6354 Baseline RdHoustonTexas77045GRP-9531null
ENRENR-1027832026-10-17T01:35:34ZBryanWFerguson06/05/1993··UHC-95807-84•••-••-6414(550) 383-3956··UNKNOWN5364 Church StDenver···CO·80279GRP-9238MEDICARE-ADV-A
PRV PRV-239682026-08-16T03:55:20ZStephanieS.Castillo1999-07-09··null··null·3576652033stephanie.castillo@proton.me6638 GRAND AVEHoustonTX—UNKNOWNSELECT-EPO
ENRENR-1232962026-02-20T00:27:46ZRYAN—CHEN1963-04-11UHC-69720-39•••-••-62788739516905··ryan.chen51@yahoo.com4269 MAPLE AVESan DiegoCA92151-4421GRP-2466CORE-HMO
TPATPA-590852026-03-08T20:25:22Zstephanie—armstrong01/24/94nullUNKNOWN—N/A-—UNKNOWN—-MEDICARE-ADV-A
CLM CLM-406762 2026-09-18T03:17:49ZJordan··KBarnes25-05-1982UHC-12682-64N/A12848833622jordan.barnes91@aol.com5047 WASHINGTON STPlanoTX75082GRP-4049MEDICARE-ADV-A
CLMCLM-4023532026-05-14T10:29:33ZRalph—Woods07/26/1967—UNKNOWN—N/A6887 Spring StreetTampaFlorida33671—MEDICARE-ADV-B··
ENRENR-1087162026-02-13T09:56:44ZLittle, John——1968-05-02UHC-51193-40•••-••-9989(452) 865-8516john.little@aol.com1768 Maple AvenueGILBERTAZ85254GRP-1747MEDICARE-ADV-B
ENRENR-1216482026-07-28T05:56:02ZMendez, Charles——1954-12-01UHC-04583-03•••-••-4812322-924-9570charles.mendez@yahoo.com··1701 River RoadAustinTX78767GRP-1125··NAVIGATE-HMO
ENRENR-1096102026-01-21T10:27:34ZDouglas··James··1943-06-02··UHC-64300-08——-8274 Ocean AveTempeAZ··85235GRP-3231NAVIGATE-HMO··
CLMCLM-4125472026-02-03T18:54:53ZRachelD.·Coleman1949-10-19UHC-34040-77N/A13024390138RACHEL.COLEMAN@YAHOO.COM935 Meadow LnAtlantaGA30376GRP-3693OPTIONS-PPO
TPATPA-53978 2026-07-30T21:55:49ZASHLEY—MARQUEZ1974-06-24——5198953939nullN/AN/AUNKNOWNNULLN/AUNKNOWN
ENRENR-1070282026-07-28T04:26:44ZElijah··A.Brooks·10/22/64UHC-25287-21•••-••-2488276-940-6433null·2640 Baseline Rd Apt 25OrlandoFL32829GRP-7041CHOICE-PLUS-PPO
CLMCLM-4208092026-01-19T09:06:37Z mariana—jackson1992-11-20UHC3693996•••-••-3344—N/A8346 PALM DRIVEAustinTX78738UNKNOWN-
PRVPRV-202362026-03-28T14:18:50ZPeters, Christina····—10/27/1943UHC-28826-82NULL3535380503UNKNOWNN/A··UNKNOWN—·UNKNOWNUNKNOWN-
CLMCLM-4200412026-02-17T05:44:14ZVirginia—Wilson··1999-05-18UHC8826797•••-••-8044——7763 Oak Street #570··San AntonioTX78268-2900GRP-8161—
CLMCLM-4036222026-07-19T20:28:27Zashley—vargas1998-11-05UHC-01359-34•••-••-0533——null——-GRP-7068—
ENRENR-1296222026-04-09T07:34:46ZEricQClrk27-12-1947··UHC-91237-25•••-••-86693856868830··ERIC.CLARK@YAHOO.COM7672 MARKET STTEMPEAZ85278GRP-9113MEDICARE-ADV-A
ENRENR-1192682026-01-01T10:56:51ZDoris—Adams1940-11-18UHC-18964-47•••-••-0537(941) 555-0683·doris.adams46@aol.com117 MESA DRIVESan AntonioTX78236GRP-5132NAVIGATE-HMO
PRVPRV-285052026-06-16T13:41:35ZJUDY··PATTERSON··03/07/1998—•••-••-96452455673822N/A7921 Church StreetAustinTX78767—null
ENRENR-1115722026-07-29T07:38:58ZVINCENT·RSHAW1984-04-27····•••-••-7552·17722673629·NULL3323 Church Street·Eden PrairieMN55394-3555GRP-0542NAVIGATE-HMO
ENRENR-1420692026-10-08T18:00:41ZNicholas—·Hill—UHC1981924—5237625924nicholas.hill@gmail.com7755 Canyon RdLos AngelesCA90089GRP-7266OPTIONS-PPO
ENRENR-1312792026-05-24T22:38:11ZAlbert—Garrett1982-08-01UHC-12932-13•••-••-6721953-302-0547null9517 Desert Sky BoulevardEDEN PRAIRIEMNN/AGRP-3549OPTIONS-PPO
PRVPRV-243962026-07-07T16:10:21Z·Jimmy—Gray·1952-01-18null··•••-••-2586282-327-5553N/A5047 UNION STREETCharlotteNC28266—null
TPATPA-568012026-03-15T06:45:37ZBill—·Wrighht1999-12-01—N/A·nullnull5224 APACHE BLVDFresnoCA93732——
CLMCLM-4190222026-02-11T15:43:20ZKatherine—Aguilar19510107··—N/ANULLUNKNOWN3243 Grand AveLas VegasNevada89104GRP-5384NAVIGATE-HMO
ENRENR-1124172026-10-15T19:48:02ZEVELYN—OWENS···19671017UHC-31790-37•••-••-1512747-820-4284EVELYN.OWENS60@AOL.COM9133 River RoadGilbertAZ85224GRP-7873CHOICE-PLUS-PPO
ENRENR-1278262026-07-01T21:57:08Z·Jeeremy····Sullivan1981-10-18UHC-15896-37•••-••-4123523.917.6767jeremy.sullivan@icloud.com5808 Camelback RdColumbusoh43237GRP-3701MEDICARE-ADV-A
ENRENR-1190002026-02-25T13:35:07ZRyan, AishaS—3/11/2006UHC-58675-91•••-••-95269812238695AISHA.RYAN10@GMAIL.COM7550 SPRING STGilbertAZ85220GRP-1294navigate-hmo
ENRENR-1051812026-07-21T14:47:43ZSantiagoS··Rogers1986-03-10UHC-55016-31•••-••-6022·5982147136santiago.rogers34@icloud.com9622 Ocean AvenueDenverCO··-GRP-8041··MEDICARE-ADV-B
ENRENR-1391582026-04-10T08:25:19ZNoah··—Tucker1993-06-02UHC-19864-11—6177491703noah.tucker@icloud.com2659 PARK PLACE Apt 3ColumbusOH43219GRP-9600CHOICE-PLUS-PPO
100,000 rows, page 243 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.745Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty