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
TPATPA-600242026-04-25T02:38:04ZWLLIAM—KELLY2007-10-22UHC-90416-44—·NULLNULLnullUNKNOWNnullN/Anull-
CLMCLM-409774 2026-01-01T02:58:28Zmarcus···scott10/26/66UHC-10294-58—UNKNOWNN/AN/A——N/AUNKNOWN—
PRVPRV-235082026-07-17T13:36:00ZJack—Soctt··8/22/1949UHC-60017-55-633-307-8231—6031 Elm Street #686Las VegasNevada89167N/A··—
ENRENR-1390052026-08-07T21:19:15ZevelynY·carter·01-05-2002UHC-89393-16•••-••-8616226-967-2774EVELYN.CARTER@AOL.COM5968 Spring StTampaFL33647GRP-8843CORE-HMO
CLMCLM-4045012026-09-03T16:18:05Zkatherine—payne11/11/1948··UHC-49443-83-nullnull5085 Hillcrest RdAustinTX··78727GRP-8717SELECT-EPO
ENRENR-1024642026-06-29T01:39:35ZKYLE··PHILLIPS1975-06-05UHC-18502-69•••-••-7494—KYLE.PHILLIPS83@GMAIL.COM8886 BROADWAYDallasTX75204GRP-8041NAVIGATE-HMO
PRVPRV-278952026-02-20T03:30:49ZJoeG·BishopOct 4, 1967UHC-26419-88•••-••-6896(625) 825-9436joe.bishop@hotmail.com3979 Elm Street Apt 38GilbertAZ85264-null
ENRENR-1252372026-09-05T18:59:32Zruth·Fburns1955-02-45UHC-98377-59•••-••-7541676-246-3980ruth.burns51@outlook.com8130 BroadwayAustinTX78745GRP-9134CORE-HMO
CLMCLM-4192132026-03-24T04:30:16ZgarySpatterson·2000-03-08UHC-74046-14•••-••-5812(790) 234-2108—704 Apache BoulevardTempeAZ85257GRP-4737OPTIONS-PPO
TPATPA-57013 2026-03-19T18:15:32ZBRENDA—NELSON1946-06-04···UNKNOWN-4913346N/A1315 Market StGilbertAZ85222nullN/A
ENRENR-1161282026-01-02T01:50:56ZPamelaMKing··16-11-1943UHC-00018-87•••-••-5731(417) 435-8882··pamela.king60@proton.me8136 VALLEY VIEW DRAustinTexas78781GRP-0870MEDICARE-ADV-B
CLMCLM-4289882026-04-12T13:40:07ZWalter—·Payne1960-04-08NULL—UNKNOWN—4196 Main StPhoenixAZ85012·GRP-2938CORE-HMO
CLMCLM-4126492026-07-24T22:52:44ZJANETJYOUNG2450-19-76UNKNOWN•••-••-9282——3328 Oak StreetNashvilleTN37280GRP-9298NAVIGATE-HMO
PRVPRV-206512026-03-12T18:35:36ZNoah····Morris1981-10-14N/AUNKNOWN(239) 466-2279·noah.morris68@icloud.com6769 Park PlaceGlendaleArizona85301NULLnull
CLMCLM-4115932026-01-27T00:16:16ZWebb, Kimberly——10/11/01UHC-74710-86··•••-••-9226(723) 896-2839N/A1437 Grand Avenue·NashvilleTennessee37292—·N/A
PRVPRV-254132026-06-27T02:09:47ZWarren, Christine——1963-10-03—•••-••-8806802-667-9446—9742 SUNSET BLVDDallasTX75248-··-
TPATPA-521062026-07-06T10:45:09ZLAUREN—JAMES19650405UHC-45123-42—nullnull9798 Main StTucsonAZ85732UNKNOWN—
TPATPA-625592026-08-05T01:24:21Z Sara··—Murray1944-05-25—•••-••-7785——9636 Spring StreetColumbusOH43241··NULL—
CLMCLM-4130762026-05-13T01:41:37Z Arthur—Rios1946-09-08UHC-81700-16null··7056318299arthur.rios58@proton.me8960 Baseline RdSan DiegoCA92132GRP-8981·OPTIONS-PPO
ENRENR-1247692026-08-18T13:20:10ZGarrett, MarylynP.—1941-06-07UHC-31011-55•••-••-0914239.561.1866marilyn.garrett95@proton.me2901 Cedar LnSan Diegoca92177GRP-4622MEDICARE-ADV-B
CLMCLM-4297252026-06-25T06:06:31ZDENISE—BURNSFeb 12, 1987UHC-01051-87•••-••-8828-denise.burns@gmail.com501 GRAND AVEMESAAZ85299GRP-7041—
CLMCLM-4195102026-02-17T02:46:37ZAngelaG.Flores1985-04-07··N/AUNKNOWNUNKNOWN9795 Washington St #636Los AngelesCA90021··GRP-2027NULL
ENRENR-1424412026-01-08T22:43:07ZCheryl—OBrien8/14/1938UHC-58364-11•••-••-2112(748) 935-6743—7836 Union Street··ChandlerAZ85253GRP-1182CORE-HMO
ENRENR-1115622026-09-12T14:21:13ZVictoriaEAguilar1993-11-21UHC-67176-68•••-••-507314104842187victoria.aguilar@gmail.com3290 CENTRAL AVENashvilleTennessee37266GRP-9882CHOICE-PLUS-PPO
ENRENR-1232532026-02-06T05:38:48ZEdwardH.Dominguez1972-05-07··UHC-99922-82•••-••-61358333307288EDWARD.DOMINGUEZ@ICLOUD.COM7510 Oak StMesaAZ85219··GRP-5675··OPTIONS-PPO
CLMCLM-4052142026-10-05T00:13:24ZBARBARA—HOWARD2002-07-14UHC-62387-23•••-••-5401210-262-0539·NULL6324 Mountain View Dr Apt 6JacksonvilleFL·32235—null
TPATPA-627342026-09-17T14:15:31ZROGER—ROSSDec 27, 2000—·-NULL—5420 VALLEY VIEW DRIVE··San AntonioTXNULL—·null
CLMCLM-4248422026-07-05T02:05:08ZJOHN—BLL1957-01-01UHC-95187-29N/A··—null8461 Union StreetLos AngelesCA90040-9079UNKNOWN—
ENRENR-115702 2026-10-01T18:51:16Zdonna—soto2000-01-26UHC-41437-45··•••-••-487913445121176donna.soto70@gmail.com4954 Union StreetMesaAZ85259GRP-5761MEDICARE-ADV-B
ENRENR-1312742026-05-26T17:56:38ZMariaQJenkins20060401UHC-85849-89•••-••-2841(711) 827-6384maria.jenkins84@hotmail.com2486 MOUNTAIN VIEW DRIVE··JacksonvilleFL32232-2543GRP-8594CORE-HMO
CLMCLM-4123982026-10-02T14:43:49ZGilbert, Scott——12-05-1940——12482628548UNKNOWN1979 Pine DrHoustonTX77078—CHOICE-PLUS-PPO
CLMCLM-4111762026-05-12T14:02:38ZBetty—Wheeeler15-10-2002UHC-47951-04NULL··-null2733 CHURCH STCHARLOTTENorth Carolina28288GRP-6246-
PRVPRV-281772026-09-30T09:35:41ZRandyRVazquez1960-06-15UHC-86837-23-636-577-8967null9686 LAKE VIEW ROAD·AustinTX78792-—
TPATPA-623782026-07-31T13:34:07ZSOPHIA—WILSON04-08-1977··—•••-••-1405+1 613 829 1128NULL242 Main StreetChandleraz85202UNKNOWNNULL
PRVPRV-209462026-03-17T08:24:01ZDavidFGarcia2008-01-09UHC-62582-34NULL(263) 565-3685—6698 MESA DRSan DiegoCA92147—UNKNOWN
ENRENR-1142772026-03-16T03:12:25ZYUKI—GONZALES2002-03-20UHC4938815•••-••-2725940-501-4228yuki.gonzales29@yahoo.com4234 Spring StScottsdaleAZ85285GRP-5158CORE-HMO··
ENRENR-1108092026-01-19T15:32:30Z·Torres, Theresa——3/18/1990UHC-55258-87•••-••-53403989496320—4431 Highland Ave··San AntonioTX78202GRP-8404CORE-HMO
CLMCLM-4061802026-01-28T18:34:27ZSandraTLucas2007-12-14··UHC-39711-12•••-••-6419(537) 405-1445SANDRA.LUCAS56@YAHOO.COM··5385 River RdDenverCO··80249··GRP-5920UNKNOWN
ENRENR-1198742026-07-26T10:56:37Zabigail··—berry2007-12-02·UHC-88221-68•••-••-0237·+1 802 221 1369abigail.berry49@hotmail.com··1668 HARBOR BLVDColumbusOH··43227··GRP-9781OPTIONS-PPO
PRVPRV-230762026-06-19T21:44:05Z·Amanda··Foster1974-01-09UHC-46520-48N/A(728) 719-7021null395 WASHINGTON STSan DiegoCA·92199NULLnull
TPATPA-501382026-06-21T14:49:34ZLaura—Henderson1939-09-02UHC-08977-16N/A568-430-3972UNKNOWN6222 UNION STREET··TAMPAFL····GRP-2687··SELECT-EPO
TPATPA-542822026-03-29T18:36:55ZLauren—CampbellAug 7, 1955N/A———6268 Main StTUCSON·AZ85718-0981··OPTIONS-PPO
CLMCLM-4255812026-09-13T13:26:20ZDouglas—Gutierrez2005-03-01——614-763-7752····25 BROADWAYPlanoTX75095——
CLMCLM-4043742026-02-18T13:08:19Z·Betty—Soto12/6/1974uhc-59887-21•••-••-4151nullbetty.soto@proton.me8097 BAYSHORE DRMiamiFL33158GRP-2412UNKNOWN
ENRENR-120392 2026-03-02T07:32:18Zjacob··—medina1940-11-12UHC-52242-33•••-••-2950NULLjacob.medina@aol.com898 Jefferson AveGlendaleAZ85382GRP-2486OPTIONS-PPO
ENRENR-1223762026-06-20T21:56:56ZJoshua—Crawford1976-11-22UHC-22291-10•••-••-30252445474690joshua.crawford@hotmail.com3815 Lincoln WayTampafl33691GRP-3218OPTIONS-PPO
CLMCLM-4094442026-06-29T20:53:09ZETHAN—ALVAREZ··Dec 4, 1955UHC-95573-58--N/A349 MOUNTAIN VIEW DRNashvilleTN37269UNKNOWNOPTIONS-PPO
CLMCLM-4107582026-10-14T20:55:12ZCHRISTINA—RAMOS1963-02-12UHC-50875-92-UNKNOWN·UNKNOWN7083 Grand AvenueSeattleWA98178·GRP-8615OPTIONS-PPO
ENRENR-142378 2026-07-06T13:25:28ZGRACE—WEST1963-01-26UHC-87340-82•••-••-75275803776038·grace.west90@icloud.com2648 Union StreetSEATTLEWA98160-1919GRP-7138CORE-HMO
CLMCLM-429819 2026-04-26T09:56:29Zdonald—chapman8/9/2003UHC-60622-70•••-••-5532·4353948718donald.chapman@proton.me-null——GRP-1216MEDICARE-ADV-A
100,000 rows, page 117 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.684Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty