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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4261762026-03-18T23:48:24Zjose—·jordanDec 6, 1947uhc-22708-92•••-••-7004N/A-2093 OAK ST #606DallasTX75201—NULL
CLMCLM-4133922026-06-07T04:50:08ZPaul—Li2002-09-16··UHC-71953-24UNKNOWN——1720 Market StSEATTLEWA98123GRP-9662—
CLMCLM-4314782026-01-12T21:47:43Z·RICHARD—CLARK10/3/1972UHC-54936-57•••-••-171217992782888··UNKNOWN569 Forest AvenueATLANTAGA30377GRP-8367··CHOICE-PLUS-PPO
CLMCLM-4137622026-08-31T02:10:42ZAisha—Bradley1973-12-24-N/A(354) 853-6255null8630 River RoadDENVERCO80211-7101GRP-3590select-epo
CLMCLM-4189342026-05-09T08:33:22ZChristine—Webb1979-03-15UHC-65802-97null839-611-8541christine.webb@icloud.com8114 Ridge Rd·Eden PrairieMinnesota55376··GRP-8571OPTIONS-PPO
CLMCLM-4097682026-09-10T20:43:48ZELIJAH—CLARK10/25/2002-—·nullUNKNOWN7887 MARKET STREETGilbertAZ85208GRP-5349··NULL
CLMCLM-4152892026-01-29T19:27:48ZWilliie—·Garza1962-10-04UHC-11602-33nullNULLNULL9375 Jefferson Avenue··San AntonioTX78259·N/A—
CLMCLM-426083 2026-07-30T18:30:13Z·DouglasR.Woods··01/07/1940UHC-42719-19N/A·372-323-3546·UNKNOWN2430 Elm St·ColumbusOH43293-2805GRP-8958UNKNOWN
CLMCLM-4079962026-06-13T07:44:06ZStephen—Herrera1949-10-11UHC-09183-29•••-••-8216(754) 280-9782—3354 Grand AveNashvilleTennessee37254GRP-2713—
CLMCLM-4147772026-10-18T21:02:52ZJACOB····CARR25-12-1995UHC-36540-95——jacob.carr14@aol.com473 GRAND AVENUESan AntonioTX··—GRP-2496—
CLMCLM-4175782026-02-23T16:46:19ZANGELAP.HAMILTON1960-09-08··UHC-96995-64•••-••-4444null·-1326 Valley View DriveHouston·TX77096GRP-3389SELECT-EPO
CLMCLM-4081102026-04-05T19:58:04ZKaren—Lewis06-01-1985UHC-88238-91—860.307.2484N/A4594 PALM DRIVEOrlandoFL32823GRP-7861N/A
CLMCLM-4287532026-10-01T14:44:41ZJOANTCOLEMAN2003-05-25·UHC-76680-53--joan.coleman@outlook.com6592 WILLOW CT Apt 33TampaFL33636—null
CLMCLM-4044572026-06-10T17:35:09ZbrittanyK.freeman15-04-1943UHC1336001•••-••-0566(720) 714-7632····199 Grand AveScottsdaleAZ85268N/AMEDICARE-ADV-B
CLMCLM-4278272026-03-10T00:21:09ZSantiago—Hawkins1965-05-25UHC-55074-11•••-••-9374(622) 626-1917·santiago.hawkins86@hotmail.com682 Washington StTAMPAFL33657UNKNOWN—
CLMCLM-4042692026-09-30T23:20:03ZKeith—VegaApr 11, 1956--—KEITH.VEGA@PROTON.ME5315 HARBOR BLVDPlanoTX75099-null
CLMCLM-4166372026-02-03T02:48:01ZCARLS—FORD·1973-06-22uhc-51499-08—(854) 479-6446UNKNOWN3488 Palm DriveTucson··AZ···85712GRP-9577NULL
CLM CLM-4210912026-03-17T10:51:45ZSARA—GORDON05/25/47UHC-17238-13•••-••-098117009316062UNKNOWN8339 Ocean AveMinneapolisMN55412·GRP-3434OPTIONS-PPO
CLMCLM-4156292026-01-21T09:05:20ZDunn, Hannah——1973-09-11UHC-05051-44null—hannah.dunn@gmail.com9272 Mountain View DrDallasTX75217GRP-5028medicare-adv-a
CLMCLM-4080532026-06-12T22:17:07ZTHOMASZ.KELLY6/15/1988-UNKNOWN807-599-4502N/A4316 Main StreetLOS ANGELESCA90063·NULL—
CLMCLM-4303042026-01-23T17:58:39ZmarianaT.gordon2002-12-27UHC-48651-30——N/A8499 BroadwayNashvilleTN37243-5941-NULL
CLMCLM-4127632026-02-07T06:13:05Z DEBRA—FIELDS1973-06-12UHC-12024-33UNKNOWN7015279901N/A1358 Pine DrPHOENIXAZ85093-CORE-HMO
CLMCLM-4004082026-04-30T17:35:12ZAaron··Harper2008-11-02N/A—2896341496null3658 Market St··ScottsdaleArizona85237—NAVIGATE-HMO
CLMCLM-4101612026-06-28T11:29:16ZCarpenter, Alexander··——7/15/1948UHC-30993-74NULLN/A—1607 Oak StreetOrlandoFL··32811-2068—SELECT-EPO
CLMCLM-4312752026-04-27T03:06:50ZPalmer, Jule——1948-07-04—N/A490-887-0856NULL2721 Palm DrChandlerAZ85293GRP-4306NULL
CLMCLM-4103472026-09-29T22:01:12ZDiana—Miills15-03-1941—NULL·(971) 519-3934diana.mills@yahoo.com··3531 MARKET STREETAustinTX78771GRP-8540NAVIGATE-HMO
CLMCLM-4010412026-08-14T04:39:34ZAna·EBarnes1955-12-26UHC-78790-02——N/A8964 Mesa DriveEden PrairieMN55357GRP-6361—
CLMCLM-4038912026-01-09T15:09:05ZMUNOZ—MARIA·1974-05-22UHC-02382-28•••-••-4157(635) 717-9000maria.munoz94@aol.com7712 CEDAR LN·TempeAZ85257nullUNKNOWN
CLM CLM-4236692026-10-03T15:32:20Z·Santiago—Prike1978-00-59—UNKNOWNN/A-8949 Mesa DriveHoustonTX-GRP-9890MEDICARE-ADV-A
CLMCLM-4066232026-06-27T06:19:03ZKathyGGraham2000-12-23·null•••-••-1494—NULL···8422 UNION STFRESNOCA93788GRP-4746NAVIGATE-HMO
CLMCLM-4197102026-09-09T18:31:27ZArnnold, Abigail——1943-01-12null•••-••-7270(718) 739-6828abigail.arnold@icloud.com—————MEDICARE-ADV-B
CLMCLM-4252672026-01-24T02:26:42ZDIANES.MOORE19401102UHC3347505•••-••-9520490-647-0638—3407 Desert Sky BoulevardChandlerAZ85296——
CLMCLM-4039412026-05-17T23:25:35ZElijah—Pena1997-09-16NULLN/Anull—5445 Canyon RoadSacramentoCA95885GRP-1515···-
CLMCLM-4183472026-04-08T07:29:21ZMadisonPWatsn·2001-01-27UHC-15705-43-(494) 542-9925··madison.watson@hotmail.com3991 PINE DRPhoenixAZ85037-5808·GRP-8038—
CLMCLM-4125792026-05-31T04:02:47ZShirley—Sanchez1948-12-12NULL•••-••-3596N/A-5839 Apache BoulevardFRESNOCANULLGRP-1948UNKNOWN
CLMCLM-4100962026-08-15T23:31:28Z GARY—RODRIGUEZ1952-11-10UNKNOWN•••-••-2785——1707 Mesa DriveChandler··AZ85288GRP-6473—
CLMCLM-4053802026-08-06T11:33:55ZAnthony—Banks1996-05-13—•••-••-7718(977) 463-4534—2531 JEFFERSON AVEFresnoCA93793GRP-4419MEDICARE-ADV-B
CLMCLM-4122272026-08-11T18:13:56ZRios, Megan——2008-01-21UNKNOWN•••-••-6761——NULL—N/AN/Anull-
CLMCLM-408061 2026-01-26T16:09:04ZBruce—Ward1939-10-03N/A•••-••-6932(751) 370-6054UNKNOWNUNKNOWN··N/ANULL···UNKNOWNGRP-6393MEDICARE-ADV-B
CLMCLM-4082582026-10-09T04:12:41ZWALTEER—WEBER·1988-01-16nullN/A-walter.weber2@aol.com3286 HILLCREST RDDALLASTexas75290GRP-7396·-
CLMCLM-4247222026-06-28T05:26:19Z·Daniel—GarciaN/A·UNKNOWN·UNKNOWNnull·-645 Union StOrlandoFL32805——
CLMCLM-4311572026-04-14T23:52:56ZCHRISTINA—GRIFFIN19411108UHC-88176-08-——7775 Oak StreetMinneapolisMN55405GRP-8582NULL
CLMCLM-4268242026-06-27T18:20:26Z PRIYA—·GARCIA1967-07-19--—-—NULLnull··N/AGRP-0784UNKNOWN
CLMCLM-4138102026-01-03T07:03:50ZOlivia—Gibson1954-01-28UHC-68618-14——····2702 BROADWAYEden PrairieMN55366—null
CLMCLM-401099 2026-01-12T00:02:38ZMARTHA—PADILLA1940-01-26UHC-51567-53-UNKNOWNN/A3228 RIVER ROAD Apt 22TempeAZ85202GRP-5041MEDICARE-ADV-B
CLMCLM-426877 2026-01-10T12:27:26ZALEXANDER—·ESTRADA02-12-2004UHC-81386-36—18435691803ALEXANDER.ESTRADA83@OUTLOOK.COM2506 INDIAN SCHOOL RDHoustonTX77036-7066GRP-9052MEDICARE-ADV-A
CLMCLM-4127652026-10-17T06:38:50Zsteven—cook1990-08-01—•••-••-3633nullUNKNOWN6710 MARKET STREETORLANDOFL—GRP-1131NAVIGATE-HMO
CLMCLM-4050342026-06-24T14:07:12ZEUGENE··—SANCHEZ1966-10-25UHC-25758-11NULLN/A—8157 FOREST AVEMINNEAPOLISMN55435—N/A
CLMCLM-4257132026-06-19T20:57:15ZRONALD··DMORALES1948-01-28UHC-99938-63—NULLRONALD.MORALES53@OUTLOOK.COMUNKNOWN——·-NULLOPTIONS-PPO
CLMCLM-4062792026-04-02T15:01:15ZJASON—MORALES··1947-11-11UHC-98668-81-+1 702 997 8960null——NULL··nullGRP-6225—
32,829 rows, page 186 of 657PreviousNext

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:40.627Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty