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-4106202026-02-20T23:46:06ZPaul—Burke1956-05-24-—+1 940 535 5052N/A7574 Apache BlvdEDEN PRAIRIEMN55389GRP-6210NULL
CLMCLM-4249172026-03-03T14:35:48Zjack—padillaSep 12, 1944—•••-••-7575331-448-1495—2861 MOUNTAIN VIEW DRIVESan AntonioTXN/AGRP-8929NAVIGATE-HMO
CLM CLM-4291742026-02-16T12:37:11ZKAYLA·XHARRISON1980-10-19UNKNOWN——····3922 Desert Sky BoulevardLos AngelesCA90073GRP-0789CORE-HMO
CLMCLM-4215002026-05-11T05:32:15ZWilliamLKim2003-05-19UHC-42424-16-null—9073 Cedar LnMesaAZ·85227NULL-
CLMCLM-4127552026-06-28T13:23:57ZPRIYAPSPENCER2007-01-27UHC-46670-64NULLN/A—252 APACHE BLVDHOUSTONTX77015nullselect-epo
CLM CLM-4133032026-10-06T10:21:17ZTeresa—Ford08/17/07—•••-••-4737N/ANULL9494 Market StGilbertAZ85259——
CLMCLM-4163922026-01-17T13:48:47Zeric—schmidt1944-11-23UHC-94650-89•••-••-6795nullUNKNOWN2124 Forest AveSacramento·California95829GRP-9328null
CLMCLM-4181112026-01-05T14:19:06ZBetty—Valdez2006-06-04UHC-98999-61—nullN/A6270 Oak StMinneapolis·MN55462NULL—
CLMCLM-4121702026-01-26T07:46:57ZYoung, Elizabeth——·1979-01-13·UHC-34103-14N/AUNKNOWNnull6703 Sage Court·MiamiFL33133GRP-9661—
CLMCLM-4138382026-02-27T08:23:07ZDylan—Rivera1988-12-22UHC-21374-40•••-••-696413528639705·N/A2045 Meadow LaneGLENDALEAZnullGRP-4645CORE-HMO
CLMCLM-4164032026-06-02T12:34:18Z Harold—Rojas·1991-60-25UHC-16881-88•••-••-24257236364—4310 Ridge RdFresnoCalifornia93794GRP-4368N/A
CLM CLM-412996 2026-02-18T17:40:33ZBryan··—Soto10/28/1986UHC-66405-44NULLUNKNOWN—nullN/A—-··GRP-8292NAVIGATE-HMO
CLMCLM-4309142026-05-07T04:19:26ZJustin—Le22-05-1977null•••-••-22464799229662null1662 Market Street·PHOENIXAZ85049—NAVIGATE-HMO
CLM CLM-4109702026-05-10T06:13:27ZBryan—Reynolds1958-08-23UHC-54408-06•••-••-7244—NULL1616 DESERT SKY BOULEVARDGlendaleArizona··85376nullSELECT-EPO
CLMCLM-4059462026-05-22T13:12:07ZCarr, Harold——9178-01-16UHC-73917-09—(292) 620-1081UNKNOWN7475 PINE DRDenverCO···80247-7974—N/A
CLMCLM-4219862026-05-11T07:18:06ZKATHLEN—HARRISON1984-09-15UNKNOWN•••-••-6736UNKNOWN-··9299 VALLEY VIEW DRIVESan Antoniotx78231-OPTIONS-PPO
CLMCLM-4039632026-04-02T17:26:48ZMichaelF.Reynolds18-01-1966UHC-84802-78——-9598 Mesa Dr Apt 31Plano··TX75013-MEDICARE-ADV-A
CLMCLM-4115112026-09-27T22:10:51Z JudithR.Castillo1984-08-12UHC1783726•••-••-1940(431) 652-8624UNKNOWN5562 Pine DrTucsonAZ85793GRP-8952SELECT-EPO
CLMCLM-411513 2026-03-01T05:08:33ZJUDITH—CASTILLO12-08-1984UHC-17837-26UNKNOWN4316528624UNKNOWN5562 PINE DRIVETucsonAZ85793—N/A
CLMCLM-4071312026-01-07T04:08:31ZBRADLEY—WEAVER1986-04-15NULL—593-663-3482BRADLEY.WEAVER65@ICLOUD.COM·6249 RIDGE RDJacksonvilleFL32279UNKNOWNNAVIGATE-HMO
CLMCLM-4126632026-10-11T12:51:46ZKathleen—Wright·May 25, 1949·UHC-81490-13•••-••-9952(285) 237-9084NULLnull——NULLnullMEDICARE-ADV-B
CLMCLM-4242912026-07-19T02:55:39ZMartha—Patterson1991-05-22·UHC-85609-56N/A·NULL·martha.patterson16@gmail.com7089 River RoadTempeAZ85239UNKNOWNOPTIONS-PPO
CLMCLM-4138982026-02-12T04:11:41ZMason····Vasquez27-05-1967null•••-••-2924——3053 CENTRAL AVELos AngelesCA90066GRP-7013navigate-hmo
CLMCLM-4215412026-04-07T10:07:33ZFrances—Ruiz1994-03-16——UNKNOWNNULL9212 Main St·AtlantaGA30353GRP-6383MEDICARE-ADV-B
CLMCLM-427751 2026-02-27T13:03:25ZMelissa—Simmons10/05/1993—·UNKNOWN·null-·3474 SAGE CT #190AtlantaGA30381GRP-2388—
CLMCLM-4122172026-08-25T04:14:09ZNoah—Welch1978-12-12UHC-89604-28N/AN/ANOAH.WELCH@HOTMAIL.COM4394 Pine DrDenverco80245GRP-3807null
CLMCLM-4011672026-06-20T10:14:46ZNATALIE—CHAVEZ11/12/1950UHC-93945-67NULL—····2832 Jefferson AvenueAustinTX78789···medicare-adv-a
CLMCLM-4308552026-02-25T16:05:46Zrussell····brooks1971-11-18—•••-••-3527nullUNKNOWN2424 CENTRAL AVELas VegasNV89132GRP-0767····
CLMCLM-4232832026-10-16T13:23:22ZElijah—Medina19501018-•••-••-4607+1 375 272 6270—7269 Mesa DrDenverCO80298-4841GRP-4994CORE-HMO
CLMCLM-4217242026-05-19T22:58:45Zjanice—walsh·1970-01-22N/A•••-••-4876738-741-8338—6840 Cedar LaneAtlantaGA30339GRP-2853MEDICARE-ADV-B
CLMCLM-4090902026-06-16T04:36:05ZJose—Espinoza19970814-N/A—jose.espinoza6@hotmail.com8225 Market StSEATTLEWashington98129··GRP-3119··SELECT-EPO
CLMCLM-4040292026-08-05T04:19:51ZMartha—Bell21-09-1965UHC-05322-98——-1624 Palm DrMesaAZ85222GRP-2089SELECT-EPO··
CLMCLM-4117442026-04-16T04:17:18ZASHLEYU·PERRY19870207UHC7555209•••-••-9792-UNKNOWN3205 RIDGE ROADAtlantaGA30359—OPTIONS-PPO
CLMCLM-4183762026-04-19T03:02:07ZJeffrey··D.Bryant1955-12-05····-(969) 766-8740null356 Camelback RdSacramentoCA95823GRP-2735NAVIGATE-HMO
CLMCLM-4263452026-09-30T17:49:09ZOMAR—WEAVER2/28/2002UHC-71491-85··N/A17039799708null4595 Sage CourtFresnoCalifornia93782GRP-1335—
CLMCLM-422287 2026-07-02T14:33:41ZMARTHA—PARKER09/26/91····UNKNOWN—null·236 Market StGlendaleaz85347null—
CLMCLM-4279372026-03-20T17:01:20ZAmber—Guerrero05/07/1956UNKNOWN•••-••-156017755403052amber.guerrero41@outlook.com··5676 Jefferson AvePHOENIXAZ··85053GRP-2717—
CLMCLM-4070032026-10-16T16:07:27ZGRACE—LAWRENCE28-02-1990UHC-55097-42-UNKNOWN—5929 Central AvenueGlendaleArizona—·GRP-8063SELECT-EPO
CLMCLM-4220592026-08-25T00:11:55ZHAROLD—CLARK8/23/1959·UHC-35350-52•••-••-74369417323829harold.clark57@yahoo.com803 UNION STDallas·TX75200NULLMEDICARE-ADV-A
CLM CLM-4196352026-04-06T14:30:18Z·Nicole—Carlson10/20/41UHC-64211-07•••-••-3917349.886.9262NULL8802 PINE DRIVETampaFL33663——
CLMCLM-4222762026-01-11T02:30:08ZJanet·····Morgan1968-04-24UHC-17766-52•••-••-3601UNKNOWNN/A2596 Sunset Boulevard Apt 39ChandlerAZ85228GRP-6584··medicare-adv-b
CLMCLM-4281452026-03-19T08:08:03ZMei··TranNov 1, 1998UHC-37090-48•••-••-3038(499) 785-3600NULL9864 Hillcrest RdColumbusOH43263··MEDICARE-ADV-B
CLM CLM-4274522026-09-30T23:31:16ZKathryn—·Hart1947-01-10—•••-••-299714636167714null1306 Pine Dr··Atlanta·GA30303—null··
CLM CLM-4005262026-07-07T05:42:57ZNichols, GeorgeI—1992-08-10··UHC-59529-24——NULLN/ANULLN/Anull—SELECT-EPO
CLMCLM-4293792026-08-07T14:40:48ZMorgan—Denny1955-03-02——N/A—7311 Washington St #540GlendaleArizona85386GRP-3982NULL
CLMCLM-4031032026-02-10T05:23:52ZBrandon—Wagner1960-12-16UHC-41934-48NULL+1 282 857 7953nullNULL-—····GRP-7822—
CLMCLM-4042802026-09-15T03:19:24ZAisha—Fowler1946-04-20UHC-20279-26—NULLUNKNOWNnull——N/A—OPTIONS-PPO
CLMCLM-4198652026-07-06T03:35:54ZMarquez, Samuel—··1995-12-04UHC-23159-56—null··null927 Church StreetPhoenixAZ85093GRP-7035—
CLMCLM-4183082026-04-08T15:47:12ZETHAN—·KENNEDYSep 8, 1960UNKNOWNN/A(674) 752-0478-3654 WASHINGTON STREET Apt 26TampaFL··33609GRP-1893—
CLMCLM-4241532026-04-26T17:13:27ZAshley—Danyels19471111UHC-43740-11—793-962-6425N/A727 BASELINE RD··NashvilleTN37280GRP-5409NULL
32,829 rows, page 212 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:43.436Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty