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-1002532026-01-14T07:34:53ZCHRISTOPHER—STEVENS1949-06-27UHC-34040-26•••-••-30187467742832christopher.stevens80@yahoo.com1811 LINCOLN WAYLAS VEGASNevada89118GRP-7446CHOICE-PLUS-PPO
CLMCLM-4140122026-03-10T00:55:38ZGloria—JenkinsDec 21, 1951UHC-11177-62-N/A—6842 MOUNTAIN VIEW DRIVESeattleWA98138GRP-1232-
CLMCLM-4238662026-05-05T08:13:26ZJERRY····HUNTER1998-11-13UHC-02293-76•••-••-6790UNKNOWNnullUNKNOWNNULLNULL··GRP-0904—
CLMCLM-4130832026-09-25T11:36:51ZHIROSHI—ROGERSAug 7, 1986UHC-98848-91—474.610.7880NULL·3858 BASELINE RDMIAMIFL-—OPTIONS-PPO
CLMCLM-4078672026-02-08T04:55:01ZPark, Angela——2004-01-02UHC-74100-67··•••-••-9110427-729-2616UNKNOWN2773 River RoadCOLUMBUSOhio—GRP-8683··UNKNOWN
ENRENR-1115772026-04-15T08:43:12Zkaren·F.jackson22-05-1947UHC-05379-68•••-••-9519(854) 337-9329karen.jackson71@hotmail.com1428 JEFFERSON AVELOS ANGELESCalifornia90023-3544GRP-7146SELECT-EPO
CLMCLM-4252112026-03-31T10:25:00ZANDREAQ.HUDON0221-29-60UHC-74064-92•••-••-7856——2166 Lake View Road··Los AngelesCA90067GRP-9769·CHOICE-PLUS-PPO
TPATPA-51630 2026-04-08T03:39:55ZJennifer—Perez1498-07-18-UNKNOWN·null—6039 GRAND AVETucsonAZ85749GRP-8406null
TPATPA-503672026-01-30T00:56:02ZSofia—Chavez12/23/1996-—481-667-2397—3709 SUNSET BLVDLos AngelesCA90067N/AUNKNOWN
CLMCLM-4304742026-01-27T16:32:22ZHannah—MorrisonNULLUHC-56979-48•••-••-6510—N/A3111 Grand AveAUSTINTX78728GRP-6416—
ENRENR-1012792026-10-14T01:02:54ZSEAN—HUNTER01/18/44UHC-33259-01-6185124174sean.hunter52@icloud.com5604 PINE DRIVEAustinTexas78795GRP-0900··OPTIONS-PPO
PRVPRV-271002026-04-03T23:46:35Zterry—davis1976-05-26UHC-12131-13—+1 340 313 5479UNKNOWN7984 River RdGlendaleAZ85332N/ANULL
ENRENR-1370042026-03-11T20:41:20ZJACQUELINEMJACKSON1952-07-07··UHC-10320-15•••-••-9318655-337-3931jacqueline.jackson18@yahoo.com593 SUNSET BLVD Apt 34JacksonvilleFlorida32219GRP-2867OPTIONS-PPO
CLMCLM-4218362026-04-08T15:37:13Z sandraGfranklin07-06-2007nullN/A(551) 494-1927NULL8987 Palm DriveJacksonvilleFL32257UNKNOWNSELECT-EPO
CLM CLM-4147642026-08-24T02:53:04ZBenjamin—Thompson1992-01-19UHC-12484-48-——6338 BroadwayLos AngelesCA90045GRP-2682UNKNOWN
TPATPA-624792026-09-23T07:13:02ZWelch, Austin——23-04-1963-NULL--278 Palm DrGilbertAZ85277GRP-7966NULL
CLMCLM-4225642026-04-11T20:40:39ZDylan—Reid1943-12-05UHC-30535-48•••-••-7085——2056 Mesa DrPlanoTX75058UNKNOWNMEDICARE-ADV-B
TPATPA-546772026-03-27T05:07:29ZAMANDA—FOSTER1974-01-09—UNKNOWNnullN/A395 Washington StSan DiegoCalifornia92199-null
TPATPA-63145 2026-01-02T22:28:01ZERICABURKEJun 20, 1976UNKNOWN—UNKNOWN—5360 Valley View DrSan DiegoCA92194—-
TPATPA-57540 2026-06-01T13:14:33Z·Omar—Gardner1953-09-05NULLNULL——2622 SUNSET BOULEVARDNASHVILLETN37271GRP-9648CHOICE-PLUS-PPO
CLM CLM-4188582026-05-06T15:36:40Z Kyle··OBryant1976-09-16UHC-45658-55—582-435-9988-······null-null—CHOICE-PLUS-PPO
ENRENR-1224272026-07-24T12:56:37ZWallace, EmilyE—05/22/97UHC-54030-64•••-••-04095119659260EMILY.WALLACE@HOTMAIL.COM189 Palm DriveScottsdaleAZ85283GRP-2251MEDICARE-ADV-B
ENRENR-1173162026-01-13T23:28:04ZLarry—Young·07/10/1982UHC-19073-60•••-••-0513(216) 902-9696LARRY.YOUNG@GMAIL.COM2510 HIGHLAND AVE··Nashville··TN37270··GRP-9479CORE-HMO··
TPATPA-577042026-01-03T23:09:43ZChristopher—Ellis1986-04-05UHC-61611-07•••-••-8219·NULLN/A3925 BroadwaySan DiegoCalifornia92178GRP-7465··N/A
ENRENR-1390532026-10-13T12:05:18ZDavid··—Webb05/23/1962UHC-26994-62•••-••-68777983502david.webb@yahoo.com602 Hillcrest Road·TempeAZ·85213GRP-4143CORE-HMO
PRV PRV-242982026-06-28T08:54:23ZWatkins, Jacob··——1948-01-23UNKNOWN•••-••-47439825231742-1221 Church Street··FresnoCANULLNULLN/A
CLMCLM-4206012026-07-01T03:23:11Znicholas··—·clark11/09/1963UHC-59054-98•••-••-4791-—7847 Highland AvenueSan DiegoCA92198——
ENRENR-1363982026-03-08T08:47:16ZSharonEBanks1948-11-10··UHC-10080-74•••-••-27745275171570—1075 Indian School RoadCharlotteNorth Carolina28208··GRP-6009OPTIONS-PPO
TPATPA-596452026-07-25T15:02:02ZGeorge—Crawford1968-03-12null··———2808 Oak StPhoenixAZ85032nullNULL
ENRENR-1215642026-04-27T16:45:58ZNancy··Sandoval19831103UHC9593967•••-••-9737955-826-0487NANCY.SANDOVAL83@YAHOO.COM·2398 Desert Sky BlvdSCOTTSDALEAZ85284-4445GRP-7658SELECT-EPO
ENRENR-1277652026-02-24T18:15:06ZRANDY—ALVARADO2000-02-01UHC-90506-58•••-••-7318·(693) 392-1305NULL5022 Sunset BlvdOrlandoFL32830GRP-6414medicare-adv-a
ENRENR-1429862026-07-07T16:59:39ZJeremyWFuller9143-08-22UHC-03594-99•••-••-59429746892458—1341 MARKET STREET··MiamiFL33176GRP-1161CHOICE-PLUS-PPO
ENRENR-1195242026-01-19T20:17:19ZELIJAHYFERGUSON19650827UHC-23904-16•••-••-5029(828) 815-9443ELIJAH.FERGUSON@PROTON.ME1718 River RdFresnoCA93792GRP-4025NAVIGATE-HMO
ENRENR-1033132026-01-31T06:40:42ZNicholasCDominguez1943-05-08UHC-92617-68•••-••-4696972-733-3142nicholas.dominguez12@proton.me6743 BASELINE RD Apt 12HoustonTX77071GRP-9394CORE-HMO··
TPATPA-558582026-01-26T14:56:27ZDiego—Guerrero03/05/43UNKNOWNN/Anull—4725 Willow CtSAN DIEGOCA92183GRP-6083NULL
TPATPA-568572026-08-07T14:27:42ZCharles—Matthews12-05-1952-—-charles.matthews89@icloud.com8323 Market StLos AngelesCA90080null·CHOICE-PLUS-PPO
CLMCLM-4184222026-06-29T15:27:58ZJOSEPH··—VARGAS1967-03-08-•••-••-93857969068393—8941 BASELINE ROADTEMPEAZ85247··GRP-0797medicare-adv-a
ENRENR-1235352026-08-07T07:59:52ZJustinPTran19410307UHC-17587-12•••-••-7555499.459.2312justin.tran@gmail.com3195 MARKET STREET #222··MesaAZ85232··GRP-4984SELECT-EPO··
ENRENR-1062312026-07-04T20:24:03ZMADISONXFREEMAN1960-11-28UHC-37196-07null(544) 933-1530N/A9182 Willow Court Apt 18SeattleWA98191GRP-3228SELECT-EPO
ENRENR-1340932026-05-14T03:28:35ZBilly—Roberts12/26/1987UHC-41667-60null444.343.5571billy.roberts27@yahoo.com8297 Willow CourtLos Angelesca90022·GRP-3206MEDICARE-ADV-A
TPATPA-629632026-05-19T03:38:29ZVALENTINA—STEVENS1943-01-26—NULLN/A··8592 Mountain View DriveHoustonTX77011null-
ENRENR-1072952026-10-17T16:42:03ZMASON D—RYAN1990-04-02····-(506) 524-8906MASON.RYAN10@ICLOUD.COM5688 PINE DRChandlerAZ85297GRP-1923SELECT-EPO
TPATPA-530132026-06-26T06:22:37ZJASON—ROBERTSON1/11/1950UNKNOWN-(350) 784-6631—4486 BASELINE ROADDALLASTX75223--
CLMCLM-4179402026-05-03T06:06:36ZJanice··Greene08/15/1986UHC-32981-06—--3408 Spring StSacramentoCA95829GRP-8995—
TPATPA-521242026-06-04T17:07:51ZKyle—Cruz1970-07-28—•••-••-4170(742) 732-6030UNKNOWN4360 BROADWAYGlendaleAZ85354-3885GRP-6561UNKNOWN
ENRENR-1230512026-04-05T22:34:50ZRomero, Zachary——1992-04-13UHC-18836-74N/A7353258273—283 Camelback RoadEden PrairieMN55327-4371GRP-4277MEDICARE-ADV-B
CLMCLM-4255362026-02-24T22:22:28ZBEVERLYK.CUNNINGHAM··1961-03-23··•••-••-9626(431) 714-6211—5678 Meadow LaneMiamiFL33173GRP-2211CORE-HMO
ENRENR-1178842026-08-26T15:20:26ZCOOPERP.WEI1981-10-26UHC-59412-04•••-••-72469248358912·wei.cooper81@gmail.com9846 Washington StColumbusOH43211GRP-9787MEDICARE-ADV-B
CLMCLM-4147582026-06-04T08:03:55Z·Alice—Marquez1978-07-81UHC-69942-61•••-••-2598—UNKNOWN···664 Oak StJacksonville·FL32229N/ACORE-HMO
ENRENR-1373202026-03-14T19:43:08Zdaniel—simmons03/21/1983UHC-22539-64•••-••-75016042485851—3758 HARBOR BLVDChandlerAZ85264GRP-5173navigate-hmo··
100,000 rows, page 47 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:34.777Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty