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-1397762026-02-23T10:45:35ZMARTINEZ—ANDREA5/17/1941··UHC-02997-04•••-••-40529124249-5480 BASELINE RDLos AngelesCA90047GRP-4634OPTIONS-PPO
ENRENR-1021762026-08-17T18:49:25ZLi, Frank——1974-10-04··uhc-11541-03•••-••-7260(334) 618-9898frank.li@outlook.com7401 INDIAN SCHOOL RD·Jacksonville·Florida—GRP-5441MEDICARE-ADV-A··
ENRENR-1363302026-05-18T15:34:19ZLoriX.Hayes1962-11-15UHC-45787-52•••-••-5489(935) 811-6096LORI.HAYES@GMAIL.COM··4548 Lincoln WaySacramentoCA95840GRP-7795navigate-hmo
ENRENR-1104372026-07-21T17:23:35Zandrea—marshall1967-04-12UHC-19707-52UNKNOWN(838) 507-2948null1561 CEDAR LN··SacramentoCA··95814GRP-0599MEDICARE-ADV-B
ENRENR-1307512026-02-07T23:09:07ZRoss, Roy—····6/23/1976·UHC-03594-93•••-••-35294512661roy.ross25@gmail.com2156 Main StSacramentoCA··95896GRP-4815SELECT-EPO
CLMCLM-4319272026-02-26T17:47:18ZISABELLA—WHITE1963-09-10—N/AN/A··-9080 Canyon RoadTampaFL33636GRP-6986MEDICARE-ADV-A
CLMCLM-4080832026-10-01T16:49:09Z RANDY··WOOD5/19/1981-•••-••-1825(735) 752-0739NULL4592 Desert Sky BlvdGlendaleAZ85346GRP-4453-
ENRENR-1163632026-09-30T09:20:29ZAlexisVYang1997-10-17uhc-66903-75•••-••-9042(307) 379-5334alexis.yang7@gmail.com5797 ELM STREETScottsdaleaz85278GRP-0199MEDICARE-ADV-B
TPATPA-637612026-01-12T17:35:21ZPATRICK—RIOS··1957-01-19-•••-••-2706N/AUNKNOWN—UNKNOWNNULLnull-MEDICARE-ADV-A
CLMCLM-4056742026-04-10T16:47:58ZVincent—Schmidt20071217UHC-62293-18null8196918807—1891 CAMELBACK RDGilbertAZ85227N/ASELECT-EPO
CLMCLM-4158212026-04-29T20:57:45Z Jeremy—Duncan1969-05-17—UNKNOWN756-893-0325N/A6026 MAIN STFresnoCA93731GRP-0663··—
PRVPRV-225222026-08-15T12:25:52ZRalph—Fernandez··1991-09-20UHC-99815-83—null-8245 OCEAN AVEFresnoCA93769NULLCORE-HMO
TPATPA-532792026-04-27T08:55:19ZTyler—Fernandez1978-08-14—NULL6672376826N/A4638 Mountain View DriveLOS ANGELES··CA-NULL-
TPATPA-544442026-03-09T10:51:33Z William—Contreras4/8/2002··UNKNOWN•••-••-4890—WILLIAM.CONTRERAS@PROTON.ME3013 Grand AvenueSeattleWA—GRP-8277CHOICE-PLUS-PPO
CLM CLM-4295052026-10-12T10:50:29ZSanchez, Judith——1953-05-23··UHC-37863-85-757.391.2801judith.sanchez16@gmail.comnullnull··NULLnullGRP-1915SELECT-EPO
PRVPRV-234932026-10-16T19:17:23ZJULIACWELLS1952-11-04UHC-90402-32NULL19414955159UNKNOWNUNKNOWNNULLNULLnull—MEDICARE-ADV-A
TPATPA-521652026-10-17T18:19:36Zmark—·hernandez1962-02-06—NULL··5612488793MARK.HERNANDEZ84@YAHOO.COM2686 SUNSET BOULEVARDCharlotteNC28281nullMEDICARE-ADV-B
PRVPRV-215302026-05-01T13:58:42Z Camila—Snyder1993-06-09·UHC-17020-16-4196341764null3515 Willow CourtMiamiFL··33192—-
PRVPRV-214312026-04-23T17:32:28ZKathryn—Turner22-02-1952UHC-15096-04—·15217913689····—————N/A
ENRENR-1158842026-05-06T15:24:29ZlisaMsoto16-08-1980UHC-28518-82•••-••-6497(875) 544-4993UNKNOWN264 Elm StreetSacramentoCA··95876GRP-7817MEDICARE-ADV-A
ENRENR-1336282026-01-24T07:50:29ZVINCENT—HALL1957-06-06UHC-84712-81•••-••-1405(429) 537-7612vincent.hall@gmail.com2755 Mesa DrSeattleWA98136GRP-0136CHOICE-PLUS-PPO
CLMCLM-4153392026-05-30T20:16:21ZMARGARETN.FOSTER07/13/70nullnull+1 973 249 4998—7591 CEDAR LANEMINNEAPOLISMinnesota55418GRP-4417—
CLMCLM-4080452026-02-16T19:20:56ZRichard—Gonzalez1948-08-23UHC9548413—(281) 624-9712··—3331 CHURCH STEden PrairieMN55396-5444GRP-7482UNKNOWN
CLMCLM-4302542026-10-05T22:57:21ZBrooks, Shirley····—12/17/80UHC-51174-59N/A··N/ANULL9743 Sage CourtSan DiegoCA92119UNKNOWNUNKNOWN
CLMCLM-4199722026-03-29T03:20:50ZBobby—Murphy1992-04-03N/A--—4556 Ridge Road··HoustonTX77089-7887nullnull
ENRENR-1416552026-08-09T16:13:23ZMaryT·Willis1952-09-17uhc-05010-57•••-••-1558241.768.1188N/A7102 Cedar Ln Apt 30··Denver·CO80262GRP-6211MEDICARE-ADV-A··
CLMCLM-4013212026-05-21T22:49:46ZMaarilyn—Miller17-01-1955UHC4725457UNKNOWNUNKNOWNN/A6379 PINE DRIVESacramentoCA95808GRP-9014—
PRVPRV-204182026-03-05T07:17:42ZSARAW.GOMMEZ2002-04-12UHC-60271-38•••-••-60786536545230—5624 ELM STREETColumbusOH43298—N/A
TPATPA-560462026-01-06T15:22:33ZMelissa—Yang01-05-1968UHC-50658-16N/A(869) 434-6413—6901 HILLCREST RDPlanoTX75036··-—
TPATPA-560702026-04-26T04:41:12ZMartha—·Henderson·2000-08-23N/Anull(657) 963-8520—UNKNOWNUNKNOWNN/AUNKNOWN··GRP-2339NAVIGATE-HMO
CLMCLM-4029052026-01-02T21:10:59ZJnaice, Anderson——1981-10-10UHC-06664-40—N/ANULL——nullN/AGRP-5841—
TPATPA-606542026-09-12T05:18:32Z Aisha—·Harvey0201-29-79—•••-••-4763—null4208 MAIN STREETDallasTX75211UNKNOWNNAVIGATE-HMO
ENRENR-1427202026-04-10T20:12:28ZCarlos··—Ruiz1986-04-23UHC-41194-02•••-••-3075UNKNOWNcarlos.ruiz60@hotmail.com4033 MAPLE AVENUEGLENDALEAZ85316GRP-1656OPTIONS-PPO
ENRENR-1030232026-06-27T22:18:35Z·Cheryl—Henry14-07-2000UHC-35872-51•••-••-9174587-725-9033cheryl.henry52@proton.me9407 Oak StreetFresnoCalifornia93788GRP-7381MEDICARE-ADV-A
CLM CLM-4327112026-01-28T14:25:30ZJosephT.Payne1971-07-21UHC-40121-50•••-••-7261nullNULL8176 Hillcrest RdORLANDOFL32897—choice-plus-ppo
CLMCLM-4019232026-05-19T15:29:30ZTeresa—Harvey1995-07-24UHC-30222-34—(334) 783-6443N/A···4064 Palm DrMESAAZ85261GRP-1194NAVIGATE-HMO
ENR ENR-1348562026-08-18T16:53:27ZRALPH Q—KELLEY··1975-09-22UHC-28952-82•••-••-3584839-587-9904—·1320 PINE DRTempe·AZ85273GRP-7597CHOICE-PLUS-PPO
ENRENR-1379832026-10-05T01:19:25ZDebbie—Ortega1966-09-17UHC-05686-65•••-••-8399(507) 337-3848··deborah.ortega@icloud.com5164 Lincoln WayAtlantaGA30370-4594GRP-6466SELECT-EPO
ENRENR-1370752026-01-30T14:31:07ZRalphPWagner2001-06-05UHC-63442-26•••-••-91794884808342NULL1263 Spring Street··PlanoTexas75051GRP-7275MEDICARE-ADV-A
CLMCLM-425910 2026-03-11T03:10:12ZAISHA—·LOPEZ1971-03-03—-——N/A—UNKNOWNnullGRP-4702CORE-HMO
ENRENR-124483 2026-01-01T15:02:06ZRuth—Weber1940-05-24UHC-58634-65··•••-••-39526066165ruth.weber@hotmail.com9877 MARKET STREETGLENDALEAZ85334GRP-4319MEDICARE-ADV-A
ENRENR-1139202026-05-07T18:28:38ZBrian—·Alexander1991-10-08UHC-54534-29•••-••-8799--8475 Mesa Dr·NashvilleTN37277·GRP-6868SELECT-EPO
CLMCLM-4074712026-01-09T10:46:17ZEdward—MoranoNov 20, 1994UHC-32630-39null(480) 653-2070—1636 Lake View RdGilbert·AZ85233GRP-5746—
TPATPA-600502026-09-03T02:01:21ZDOUGLAS—MATTHEWS·1976-06-02—•••-••-5172(311) 913-3819UNKNOWN1722 Canyon RdTampaFL33601-—
TPATPA-555262026-06-08T04:20:48ZTHOMASH.·WEBBJul 3, 1966—•••-••-0748NULL··—5126 CEDAR LNScottsdaleAZ85220—null
ENRENR-1170102026-10-01T11:10:17ZCarlosE··Howell8/10/1978UHC-32155-72•••-••-50558724481261carlos.howell96@gmail.com5139 Palm Drive #965OrlandoFL32811GRP-6271·MEDICARE-ADV-B
ENRENR-122046 2026-07-13T07:33:13ZfatimaIbryant06/19/01UHC-81628-53—3768483094fatima.bryant28@outlook.com5830 Willow CtFresnoCA93700GRP-0473SELECT-EPO
CLMCLM-4136222026-08-13T00:45:21ZERIC·OSULLIVAN1963-09-08UHC-21997-61-·nullUNKNOWN209 Mountain View DrSacramentoCA··95859··—-
TPATPA-64395 2026-09-09T14:13:50ZJEREMY—GARDNER2007-05-17null•••-••-7592nullNULL7756 Mountain View DrATLANTAGA30307··UNKNOWNMEDICARE-ADV-B
ENRENR-1384462026-07-23T01:32:04ZADAMAMURRAY1965-11-04UHC-44804-05•••-••-4094·5147526-474 PINE DRIVEColumbusOH43242GRP-9925NAVIGATE-HMO
100,000 rows, page 179 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.713Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty