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-503992026-02-06T04:19:29ZNICHOLASPCOLEMAN1945-09-10UNKNOWN—+1 554 556 8420—5342 ELM STREETDallasTX75272nullCHOICE-PLUS-PPO
ENRENR-1380802026-01-24T20:29:20ZBRITTANYA··CLARK1939-07-10··UHC-13013-67·N/A3792207980—4887 River RdSEATTLEWA98184GRP-4130choice-plus-ppo
CLMCLM-4327012026-09-23T10:17:49Zkatherine—silva1967-06-26··UHC6178952UNKNOWN—UNKNOWN1917 Palm DriveHoustonTexas·77040GRP-1684-
TPATPA-558712026-04-08T04:36:51ZPaul··—Patel1942-11-22UNKNOWNnull(671) 723-3707—8622 Bayshore DriveTUCSONAZnullUNKNOWNNULL
CLMCLM-4169312026-07-10T12:18:47ZNATHAN—GONZALES··20060218UHC-41893-36•••-••-46906422183948NULLUNKNOWN—N/Anull-CHOICE-PLUS-PPO
ENRENR-1331892026-04-03T01:20:50Zlogan—campbell1983-12-26UHC-12459-58··•••-••-02913486926379·logan.campbell98@icloud.com201 Central AveAtlanta·GA30336··GRP-0245CORE-HMO
CLMCLM-4042942026-04-04T22:56:15ZGray, Carlos——1941-08-12UHC-64484-73•••-••-6937728.631.5196—8227 Grand AvenueSan DiegoCA92146···MEDICARE-ADV-B
ENRENR-1180452026-02-10T08:20:02ZSaraT·Cruz1946-01-02···UHC-66353-35•••-••-9074(687) 287-8295—2076 Elm StreetScottsdaleAZ85274GRP-9343SELECT-EPO
CLMCLM-4086952026-01-08T12:49:51Z·AishaAAllen1979-02-22UNKNOWN—748-601-1768null··6345 MEADOW LANESCOTTSDALEArizona85262GRP-9141CHOICE-PLUS-PPO
PRVPRV-265462026-05-18T16:34:29ZLORI—ROBINSON1955-05-14UHC-28139-43—9885457599UNKNOWN1793 MOUNTAIN VIEW DRIVETAMPAFL33627nullMEDICARE-ADV-B
ENRENR-1234832026-08-13T17:02:23ZMichaelQSantiago03/19/82UHC-18032-12•••-••-7869247-294-4322michael.santiago89@hotmail.com6144 Indian School Road #650ATLANTAGA30313GRP-4560MEDICARE-ADV-B
CLMCLM-4001722026-09-02T04:24:33ZSeanV.Cook1984-03-16UHC-89407-02—3352703469N/A9409 Valley View DriveJacksonville··FL32210—UNKNOWN
ENRENR-1270402026-09-24T11:00:21ZRichards, Kevin·G—12/08/63UHC-68933-71•••-••-3662309-777-8767kevin.richards38@aol.com8866 Union StreetLos AngelesCA90044GRP-5208SELECT-EPO
ENRENR-1290462026-04-28T06:38:19Z Anderson, Matthew——1991-06-22UHC-25095-70•••-••-4010(955) 368-1219matthew.anderson45@aol.com1620 BroadwayTAMPAFL33697-1285GRP-3901MEDICARE-ADV-B
TPATPA-500332026-07-30T22:12:03ZTerry—Reid·1980-07-06-NULL—-3199 Highland AvenueGlendaleAZ85369—N/A
CLMCLM-4267182026-06-24T19:10:47Z thomas··—alexander1977-06-25UHC-06171-62null(532) 317-5285N/A—null-null—NULL
PRVPRV-256022026-08-04T04:20:45Zdorothy—hughes03/27/80··NULLNULL(764) 908-3664-7079 Main StreetAtlantaGA30332—null
PRVPRV-265992026-03-12T05:25:43ZDorothy—Richards1979-02-07—-(816) 383-5314—4171 SPRING STSCOTTSDALEAZ··85253—null
CLMCLM-4037102026-10-18T07:08:07Zketih···vazquez1965-05-23UHC-01356-46—12096682567NULL6164 Grand AvenueScottsdaleArizona85299—MEDICARE-ADV-B
ENR ENR-1423672026-01-30T02:56:26ZCHRISTOPHERY.JIMENEZ1997-02-09UHC-76682-92··-4459913882christopher.jimenez76@gmail.com4012 MOUNTAIN VIEW DRScottsdaleAZ85241GRP-3835MEDICARE-ADV-B
ENRENR-1260152026-04-18T14:45:58ZCoopar, Alan——17-10-2001UHC-35629-61•••-••-0784955.500.1573ALAN.COOPER@YAHOO.COM8530 CANYON ROADLas VegasNV89175GRP-4387SELECT-EPO
ENRENR-1422812026-06-10T04:52:39ZOrtiz, Justin——01/21/79UHC8575715•••-••-90982407956489JUSTIN.ORTIZ90@YAHOO.COM·6818 Ridge RdCharlotteNC··28209GRP-0753select-epo
TPATPA-635572026-01-03T00:01:55ZKatherien—Black··07/25/1997null•••-••-807512322677319—45 Palm Dr #211TucsonAZ85765·null—
CLMCLM-4090402026-06-20T13:16:32Zcatherine—butler27-04-1956NULL—(423) 954-9224—9460 Meadow LnPhoenixAZ85024GRP-9046SELECT-EPO
CLMCLM-4063702026-06-13T19:40:32Z CARLOS—·AUSTN1990-08-02—•••-••-1174NULLnull7112 MESA DRPhoenixAZ85026-0761NULLN/A
CLMCLM-4258242026-01-15T23:28:21ZKathryn—Williams15-08-1970—•••-••-8747null—605 Washington St··Eden PrairieMinnesota55370·GRP-6244-
TPATPA-500762026-03-09T06:59:42Zmason—williams7/17/1994—-—UNKNOWN6790 VALLEY VIEW DREden PrairieMN55389NULL—
ENRENR-1181772026-08-18T07:03:25ZJudith·PCooper11/05/87UHC-87105-36—688.730.1195JUDITH.COOPER@GMAIL.COM1575 Pine DrJacksonvilleFL32210GRP-7302MEDICARE-ADV-A
CLM CLM-4049612026-09-28T06:11:56ZAlvarez, Scott—·····05/08/1953uhc-73594-80UNKNOWN13902090365SCOTT.ALVAREZ@AOL.COM1011 Ocean AvenueDenverCO80221GRP-5167CHOICE-PLUS-PPO
TPATPA-57958 2026-03-29T04:28:26ZStephens, Maria··—Sep 24, 1962UNKNOWN-—N/A6297 Washington StreetPlanoTX75044-5849GRP-2380MEDICARE-ADV-A
PRVPRV-203452026-07-18T15:01:58ZBrooks, Gabriel——Jun 7, 2003UNKNOWN•••-••-41454819315738—682 PINE DRIVEPhoenixAZ85051—-
ENRENR-1015022026-06-27T19:50:32ZNatalie—Chavez1950-11-12UHC-93945-67•••-••-860714102128078NATALIE.CHAVEZ24@PROTON.ME2832 Jefferson AvenueAustinTX78789-5489GRP-7994MEDICARE-ADV-A
CLM CLM-4004242026-07-27T05:26:14Zrussell··U.rojas1997-01-15UHC-60967-93N/A(858) 942-3947-N/A—N/A—GRP-5571CORE-HMO
ENRENR-1157152026-06-22T08:47:59ZDEBORAHV.·GOMEZ1998-09-10UHC1390247•••-••-4965263-634-4023deborah.gomez@proton.me7563 Canyon RdAtlantaGA30397GRP-3315MEDICARE-ADV-A
CLMCLM-4145262026-08-21T11:56:51ZMariana—Evans1997-10-27—UNKNOWNUNKNOWN—9718 River RdNashvilleTN37251GRP-8533OPTIONS-PPO
ENRENR-1310582026-08-31T22:29:21ZJACQUELINE—WANG06/12/50UHC-56688-73•••-••-4987N/Ajacqueline.wang@aol.com3858 Park PlMiamiFL·33108GRP-7604MEDICARE-ADV-B
PRVPRV-257422026-05-07T18:17:27ZDanielleLLewis3/16/1943null•••-••-9282(727) 989-3239danielle.lewis8@gmail.com8665 Mountain View Dr #811PhoenixAZ85035—SELECT-EPO
ENR ENR-1063962026-08-11T13:06:14Z ·FRANK—RICHARDS20-06-1949UHC-87366-39•••-••-9031——7427 Union StChandleraz85261GRP-1344SELECT-EPO
TPA TPA-560042026-05-01T08:34:18ZWei··Cooper1980-10-26nullnull924-835-8912WEI.COOPER81@GMAIL.COM9846 WASHINGTON STColumbusOH43211NULLMEDICARE-ADV-B
ENRENR-1123742026-01-16T11:21:56ZIsabella··—Berry19450401UHC-10949-47•••-••-1932·686-392-8550—8659 Sage CourtTucsonArizona85722-0803GRP-0979MEDICARE-ADV-A
ENRENR-1249842026-03-14T04:29:53ZLogan—Luna1942-09-06UHC-90592-70•••-••-980118793092186logan.luna@aol.com8848 Cedar LnScottsdaleAZ85297GRP-6855MEDICARE-ADV-A
CLMCLM-4267432026-05-14T02:57:41Z·BRENDA—BUTLER·1947-12-28—•••-••-2771nullbrenda.butler@gmail.com·3051 Church StLos AngelesCA90027GRP-8076CHOICE-PLUS-PPO
ENRENR-1345152026-07-30T01:52:25ZOmarNWeaver2001-02-28UHC-71491-85•••-••-548217039799708omar.weaver63@outlook.com4595 SAGE COURTFRESNOCalifornia93782GRP-1335NAVIGATE-HMO
CLM CLM-404608 2026-04-01T02:49:17ZJudy—LongMay 20, 2001UHC-14892-64····803.712.9786null4143 Apache BoulevardGilbertAZ85272-5229··null—
ENRENR-1298562026-04-19T19:19:36ZTerry—Walsh1960-07-19UHC-43582-43•••-••-603218695095746terry.walsh@gmail.com1234 Desert Sky Blvd Apt 22Los AngelesCA90071-9802GRP-7206OPTIONS-PPO
ENRENR-1381482026-07-06T23:12:20ZEmilyURamirez1959-12-05UHC-37730-93•••-••-7837579-331-2324emily.ramirez@gmail.com2364 BroadwayTempeAZ85294GRP-9873CORE-HMO
CLMCLM-4023932026-04-01T04:03:01ZCARL—MORALESDec 15, 1979UHC-86655-79UNKNOWNN/Anull————GRP-7452N/A
CLMCLM-4016482026-01-05T07:53:11ZMariana—HillSep 18, 1943UHC-13011-56UNKNOWN——9584 Forest AveFresnoCA93735··GRP-2352NAVIGATE-HMO
ENRENR-1156742026-04-12T13:56:02ZjudyYmccooy1962-11-06UHC-96024-70•••-••-2178(442) 887-9655-975 SUNSET BLVDDallasTX75269GRP-0358OPTIONS-PPO
TPATPA-592932026-03-10T17:55:41ZAmber—Larson1493-12-22UHC-72250-82—3707204126N/A··9158 Washington StreetAtlantaGA30379UNKNOWN—
100,000 rows, page 196 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.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty