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
PRVPRV-201592026-01-12T04:45:29ZDebraXBishop··1939-08-24UHC-47053-48—421-483-1954UNKNOWN6338 Grand Ave #441OrlandoFL··32862N/ANULL
ENRENR-1102772026-10-16T14:21:24ZJudyXLittle2002-04-17UHC6135344•••-••-1696(363) 943-2651null1140 CEDAR LNCOLUMBUSOH··GRP-7019CHOICE-PLUS-PPO
CLMCLM-4194932026-09-06T10:02:24ZBrittany—Turnre1962-11-15UHC-11003-49•••-••-3233nullnull2023 PINE DRIVEJacksonvilleFLN/A····null
ENRENR-1009682026-06-17T01:19:25ZDennisPHarris1972-01-02UHC-62668-30•••-••-1188924-568-2766dennis.harris@yahoo.com4701 Sage CtMESAAZ85271GRP-5453··SELECT-EPO
CLMCLM-4251902026-08-18T06:44:26ZEvelynN.Rice19671020UHC-62137-52•••-••-81677614620886NULL456 Palm Drive Apt 31San AntonioTX78293GRP-6959CHOICE-PLUS-PPO
ENRENR-1175232026-01-22T08:27:01ZClark, Kelly··N—1954-10-03UHC-47071-64•••-••-73274859274070kelly.clark@proton.me9516 Market StreetGlendaleAZ85374-3104GRP-7547MEDICARE-ADV-A
ENRENR-1387822026-07-23T00:39:28ZBruce—Alexander25-07-1988UHC-66040-77•••-••-5582nullbruce.alexander@proton.me7801 Apache Blvd··ScottsdaleAZ85275GRP-8479CORE-HMO
ENRENR-1229472026-07-21T16:54:16ZJEAN—RICHARDS1953-01-11UHC-20790-42N/A(872) 957-7133jean.richards96@hotmail.com5491 Indian School RoadMinneapolisMN55400GRP-5079MEDICARE-ADV-B
TPATPA-583052026-10-09T10:11:57ZHelen··—Green1928-02-24N/AN/A+1 402 545 7613NULL3097 MAPLE AVENUESeattleWashington98186NULLN/A
CLMCLM-432045 2026-05-03T11:22:55ZNicole····Arnold1954-06-26UHC-07442-46—937-557-1813——null———SELECT-EPO
CLMCLM-4099872026-09-04T02:32:32ZNicole—Hayes1939-04-16·UHC-32516-68NULL+1 717 872 0107UNKNOWN695 Apache BoulevardPlanoTX··——MEDICARE-ADV-B
PRVPRV-262642026-03-04T20:32:20ZAMANDA—HALL2005-05-01——(478) 243-2432UNKNOWN9017 CHURCH STMesaAZ··85215—N/A
ENRENR-1150902026-04-23T18:31:51ZGabrielN.·Jensen17-06-1992UHC-05339-10•••-••-881018583217076gabriel.jensen@aol.com·7912 Union StChandlerAZ85239··GRP-0748NAVIGATE-HMO
PRVPRV-271252026-03-08T11:03:17ZTIMOTHHYSALEXANDER1962-08-04——(821) 406-3545—4556 Desert Sky BoulevardFresnoCA93724N/A—
CLMCLM-4258722026-05-22T10:18:53ZAUSTINVEVANS1974-06-26UHC-08309-61—NULL-6408 CAMELBACK RD #987·HoustonTX77068GRP-4068—
CLMCLM-4055932026-01-20T20:43:27ZCATHERINE—MORRISON2008-01-27—-——4880 OCEAN AVECharlotteNC··null-·CORE-HMO
CLMCLM-4117632026-03-12T22:05:43ZISABELLA—MONTGOMERY8/20/2007UHC-13566-87-·(474) 618-4857UNKNOWN2219 UNION STJacksonvilleFL32263······MEDICARE-ADV-B
ENRENR-1200302026-09-06T07:49:17ZSteven—Banks1955-12-09UHC-00252-61•••-••-3587332.608.3247STEVEN.BANKS@YAHOO.COM·190 Ridge RdGilbertAZ85286GRP-8670NAVIGATE-HMO
PRVPRV-258622026-06-22T23:22:20ZJudy—SchmidtFeb 5, 2002--16373923645null4339 Park Pl Apt 12TempeArizona85233-0763NULLnull
CLMCLM-4217112026-02-25T03:54:26ZLAUURA—ELLIS10/28/1991——(261) 265-4691··laura.ellis@aol.com———nullGRP-3756N/A
PRVPRV-225212026-10-02T14:06:41ZAlanOHowell·1999-05-27——(798) 251-0452—8558 VALLEY VIEW DRIVETucsonArizona85736nullUNKNOWN
CLMCLM-4132762026-10-17T15:26:10ZJonathan··Wang1939-08-09UHC-79770-03•••-••-6748UNKNOWN-4103 Mountain View DrOrlando···FL32857GRP-7596OPTIONS-PPO··
CLMCLM-4117092026-08-05T07:16:43ZAnthony—Carr9172-04-27-•••-••-5133581-462-9705NULL8920 SAGE CTMESA·AZ85273—CHOICE-PLUS-PPO
PRVPRV-205432026-08-04T18:16:36Zteresa—chavez1953-05-09UHC3653542—+1 436 212 4413TERESA.CHAVEZ@AOL.COM1648 Valley View DriveEden PrairieMN55343NULL··null
ENRENR-1230772026-01-10T08:27:37ZRussell—Garcia1989-02-11UHC-64553-99-7436920228russell.garcia@yahoo.com4408 River RdMiamiFL33188GRP-0916MEDICARE-ADV-B
ENRENR-1054972026-03-26T04:52:41ZKyleJWang2003-09-16UHC-46109-50•••-••-5418(403) 756-4755kyle.wang32@gmail.com5399 CANYON ROADTempeAZ85275GRP-3975CHOICE-PLUS-PPO
TPATPA-52083 2026-04-23T11:47:07ZCruz, Helen——1988-11-02—•••-••-66252427366336HELEN.CRUZ64@HOTMAIL.COM756 CENTRAL AVE·ORLANDOFL····NULL—
CLMCLM-4004512026-09-29T18:22:33ZChavez, MargaretK.—·19510319UHC-92419-11—8756610430··—5663 SPRING ST·Minneapolismn55457··GRP-0692—
ENRENR-1067392026-10-12T08:46:07ZRichard—Silva2000-07-04uhc-08142-79•••-••-0900—NULL·1302 Meadow Ln Apt 32San DiegoCA92143GRP-4988medicare-adv-b
ENRENR-1394612026-09-08T22:14:48ZHAROLD—WATKINS1962-09-01UHC-53948-51•••-••-3293(854) 581-8765—9214 Lake View RdSan DiegoCA92105-3364GRP-3831CORE-HMO
ENRENR-1346302026-03-31T13:08:14Zmaria—knight1963-04-14UHC-32949-76•••-••-23858124909486maria.knight@aol.com151 Ridge RdColumbus··oh43233GRP-1307MEDICARE-ADV-A
CLM CLM-4250252026-09-18T06:36:57ZJason—Willis1938-04-20UHC-58129-66NULL-—NULLnullNULLNULLGRP-3859—
CLMCLM-4176442026-04-05T11:49:33Zdiana—bailey1999-10-21UNKNOWNUNKNOWN894-581-9690—·nullUNKNOWNNULLnull—MEDICARE-ADV-B
TPATPA-537182026-09-15T07:06:28ZAllen, YukiM—2003-05-22—•••-••-9828--8029 GRAND AVESACRAMENTOCA95803null—
CLMCLM-4174772026-05-08T08:05:03ZJOSE—REID1952-12-20·N/A•••-••-1332——NULL—N/A-GRP-3748·N/A
PRVPRV-284192026-07-31T10:04:09ZpatriciaS.davis01/17/02··N/A614-605-2699—5868 OAK STPlanoTX75095N/A—
TPATPA-612362026-06-14T17:29:39Zamy—shaw1958-10-24—NULL(710) 502-0648—9177 Maple AveScottsdaleAZ85200GRP-6269OPTIONS-PPO
CLMCLM-4212242026-07-14T05:11:59ZLogan—Howard20041026—N/AN/ANULL3883 Bayshore DriveAustinTX78745-7426GRP-4178NULL··
CLMCLM-401464 2026-09-05T02:12:39ZLAWRENCE····TUCKER··12/11/83——N/A—1664 Valley View Dr Apt 37PlanoTX75024GRP-8344-
TPATPA-600402026-09-08T17:18:33Zlsa—willis1974-09-05——2577582UNKNOWN1426 Park PlaceTUCSONAZ85720—NULL
ENRENR-1195372026-02-15T23:57:29ZDONUGONZALES2006-10-09UHC-12549-84•••-••-3715UNKNOWNdonald.gonzales26@gmail.com179 FOREST AVEJacksonvilleFL······GRP-3461·OPTIONS-PPO
ENRENR-1327382026-09-06T12:52:19ZLynch, Judith——1961-08-17UHC-81000-44··•••-••-2192+1 945 625 3043JUDITH.LYNCH@OUTLOOK.COM2473 PALM DRAtlantaGA30344GRP-1343CHOICE-PLUS-PPO
PRVPRV-218872026-02-28T18:02:58ZSOPHIAHMRQUEZ01-09-1986UHC-21684-62—-sophia.marquez@yahoo.com6786 MEADOW LNFresnoCA93755-—
TPATPA-581782026-10-10T22:41:58ZCamila—Howell08/02/93NULL—(212) 246-8677·-882 Harbor BlvdPHOENIXAZ85036——
ENRENR-1114712026-03-27T07:10:15Zevelyn—nguyen2006-09-24UHC7104685•••-••-2749714-846-6990NULL4117 DESERT SKY BOULEVARDSan DiegoCA92192GRP-3978NAVIGATE-HMO
CLMCLM-4305892026-05-30T12:05:15Z·Brittany—Homles1989-02-22UHC-82722-34-UNKNOWNNULL1374 APACHE BLVD··ColumbusOH43266nullMEDICARE-ADV-A
CLMCLM-4075942026-04-28T22:37:16ZBETTYX··TUCKER1958-07-15null•••-••-0197(829) 945-2131betty.tucker@gmail.com3595 Central AvenueTUCSONAZ—GRP-2276NAVIGATE-HMO
TPATPA-513332026-06-21T22:13:20ZThomas····Harpr19630811-··•••-••-5223841.930.1504—1758 Elm StreetJacksonvilleFL32212—CHOICE-PLUS-PPO
ENRENR-1078932026-05-31T12:46:06ZPeterXSpencer5/3/1970UHC-64808-33•••-••-9749(303) 224-4683peter.spencer73@aol.com5103 Jefferson Ave··MinneapolisMN55448GRP-3689CHOICE-PLUS-PPO
ENRENR-1095882026-09-11T13:09:31ZJordan—Harris1951-12-25UHC-98759-35•••-••-31792596461176null1233 FOREST AVENUELas Vegasnv89120GRP-4869CHOICE-PLUS-PPO
100,000 rows, page 150 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.699Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty