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-4236702026-02-16T19:54:04ZSharonU.·Romero02-11-2008N/AUNKNOWN(467) 226-9397—nullUNKNOWNN/AnullGRP-4457··NULL
CLMCLM-4075432026-01-25T08:56:43ZMaria—Cooer19630222··UHC-53767-89—null-··7528 DESERT SKY BLVDMiamiFL33160·N/ACORE-HMO
CLMCLM-4210602026-02-24T03:38:18ZDEBORAH—SANDOVAL·2004-03-12UHC-24249-17null+1 515 734 2770NULL6170 Sage CtSeattleWA98191GRP-2473··null
CLMCLM-4037712026-09-15T22:35:10ZRUTH—RICHARDSON15-12-1955UHC-95017-79null-—8875 Indian School RdColumbusOH43290—null
CLMCLM-4265172026-08-11T18:37:20ZJOHN—PAYNE12/01/1947UHC-58602-12-+1 416 528 5691UNKNOWN4417 Hillcrest RdAtlantaGeorgia·30363GRP-4978-
CLMCLM-4019722026-02-21T04:33:55ZWalter—Palmer1979-12-15··null•••-••-9816799-749-6707—3447 Ridge RoadTempeAZ85235GRP-7726MEDICARE-ADV-A
CLMCLM-4018242026-08-27T12:02:31ZJANET—JOHNSON1980-02-22—N/A6088504484··UNKNOWN4171 LINCOLN WAYLos AngelesCA·90036—·CORE-HMO
CLMCLM-420693 2026-02-20T10:08:03ZJuanFGonzales23-09-1984-•••-••-97469347659980null6894 Ocean AvenueSan Diego··CA92174GRP-1403··null
CLMCLM-4269912026-05-18T08:39:08ZMartha—Jenkins1/15/1987N/A•••-••-3312·(294) 476-9082UNKNOWN8650 Apache BoulevardSACRAMENTOCANULLGRP-5107CORE-HMO
CLMCLM-4007472026-06-16T02:07:35ZShirley—Williamson4/25/1962UNKNOWN•••-••-3787UNKNOWNUNKNOWN·4586 CHURCH STREETTampaFL33619GRP-1353—
CLMCLM-426479 2026-09-25T18:37:24ZBryan—Matthews1988-07-28UHC-23750-61UNKNOWN-—UNKNOWN——N/A—·-
CLMCLM-4212302026-01-20T16:38:33ZNathan····Nelson1980-02-19UHC-05465-76-nullUNKNOWN2023 Park PlTampaFL··33608GRP-1931NULL
CLMCLM-4010012026-01-25T10:40:17ZDIANA—STEVENS11/16/1981UHC-59010-76•••-••-7011(785) 844-3304—7736 Valley View DrNashvilleTN··37249——
CLMCLM-4251972026-06-23T07:26:13ZOlivia—StevensMar 27, 1956UHC-96381-35··N/A4127724309····6766 Indian School Rd··SEATTLEWA··98105GRP-7898null
CLMCLM-4247492026-08-31T16:53:25ZRebecca·LPalmer18-01-1961UHC8484207•••-••-0644(584) 395-0447—5599 MARKET STLas VegasNV89143-OPTIONS-PPO
CLMCLM-4070062026-10-18T07:14:33ZEMILY—SILVA22-12-1976UHC-43687-71—(722) 942-0514—4265 UNION STLos AngelesCA90067··GRP-9182—
CLMCLM-4327802026-09-23T17:18:08ZBRIAN—VAZQUEZ9/26/1956··UHC-89900-10———6606 Oak St Apt 23AUSTIN·TX·NULLUNKNOWNUNKNOWN
CLMCLM-4072542026-09-26T14:46:24ZRobert—Garrett·1963-04-16-null—NULL6221 CANYON RDMESAAZ85219GRP-5693OPTIONS-PPO
CLMCLM-4121052026-03-31T04:28:55ZhannahA.lawrence04/21/1956N/A•••-••-2287447-937-0295—1116 Desert Sky BoulevardMesaAZ85294UNKNOWN—
CLMCLM-4132212026-04-13T23:50:18ZJANICE—WEBER16-01-1972-—290-462-5917UNKNOWN4750 GRAND AVENUETucsonArizona85715-7015GRP-1473SELECT-EPO
CLMCLM-4077772026-03-01T07:43:31Z STEVENNJONES1987-01-21UHC-14206-13•••-••-4072N/ANULL8824 Main Street·Tempe·Arizona85261GRP-6723MEDICARE-ADV-B
CLMCLM-4085482026-04-04T15:01:23ZSusanL.Ross·1982-07-18UHC-33226-10——·-4013 Oak StSacramentoCA95894GRP-4965NULL
CLMCLM-4308412026-10-16T11:11:36ZJerryTBanks20-09-1945UHC-69891-94•••-••-93596254404110UNKNOWN··249 Oak StColumbusOH43202GRP-1362MEDICARE-ADV-B
CLMCLM-4179842026-05-28T12:02:58Z ChristineCDelgado20-08-1941N/A•••-••-1043420-912-5213··6732 Elm StreetJacksonvilleFL32237-—
CLMCLM-4139272026-06-23T19:13:49ZSEAN—TUCKER1984-10-08UNKNOWN—9617208—4906 Sage CourtGilbert·AZ85263GRP-7811—
CLMCLM-4187942026-04-19T16:04:57Zdon—burtno19730210··UHC-51875-33•••-••-5247—UNKNOWN8911 SUNSET BOULEVARD·HoustonTX77089—-
CLM CLM-4221692026-06-16T09:39:55ZSANDRA—ALEXANDER1950-04-13UHC-52523-43UNKNOWN7763019396—8420 FOREST AVEFresnoCAnull—N/A
CLMCLM-4064302026-06-23T06:41:26ZLogan·KNichols1955-08-13NULL•••-••-619016572476632—201 Willow CtGlendaleAZ85383—CHOICE-PLUS-PPO
CLMCLM-4165772026-02-27T15:31:51ZOMAR—CASTRO··1938-12-18UHC-52606-73•••-••-6972(542) 906-7973N/A6204 Forest AveGilbertAZ85286—NAVIGATE-HMO
CLM CLM-4180322026-07-09T11:32:12ZJluieM.·Salazar1945-11-07··UHC-75947-68····456-825-3507julie.salazar@hotmail.com··7977 FOREST AVESacramentoCAUNKNOWNGRP-3876null
CLMCLM-4227512026-07-31T10:20:11ZSusanUGreene1945-08-23UHC-10018-12N/ANULLUNKNOWNnullNULL——GRP-5029··MEDICARE-ADV-A
CLMCLM-4255402026-08-08T09:37:47ZJason—Rose1967-10-22UHC-44955-22•••-••-6922··-4069 PINE DRIVEMesaAZ85230GRP-4386-
CLMCLM-4230412026-05-11T21:11:49ZRandy—Reid1997-10-25UHC0240136NULL—randy.reid22@hotmail.com6483 Highland Avenue Apt 9AustinTX78720··GRP-2193CHOICE-PLUS-PPO
CLMCLM-4292852026-06-07T00:18:16Zsamantha····watkins1991-09-24null•••-••-70882036662020—935 Cedar Ln Apt 39ColumbusOH43276GRP-2627MEDICARE-ADV-B
CLMCLM-4275832026-01-02T15:45:45ZWilliamJ··Mitchell1996-10-02UNKNOWN—2137689779NULL1180 UNION STREETChandlerAZ·85283GRP-8053—
CLMCLM-4087772026-03-14T15:08:39ZGary—Jimenez·1976-03-26UHC2998691•••-••-18386408089960null4951 JEFFERSON AVE Apt 10TampaFlorida33639nullCHOICE-PLUS-PPO
CLMCLM-4273082026-07-29T16:15:08ZPATRICIA—ADAMS04-01-1963UHC-55595-27··nullN/AUNKNOWNUNKNOWNUNKNOWNN/AN/A-··
CLMCLM-4029692026-03-01T23:08:23ZRandyN.Nunez1979-06-01UHC-77425-69N/A3379394445——————OPTIONS-PPO
CLMCLM-401606 2026-10-15T20:06:22ZSimmons, Martha········09-02-2002UNKNOWNNULL——1191 Park Place #792AtlantaGA30306··nullMEDICARE-ADV-B
CLMCLM-4185972026-04-14T16:06:11ZJESSICANADAMS1961-07-22UHC-97802-47•••-••-7366436-955-0598N/A·1007 OAK STREETColumbusOHnullGRP-6200null
CLMCLM-4235022026-02-24T00:48:37Z·David—Montomery08/16/1974N/A•••-••-0867-····N/ANULL—····-OPTIONS-PPO
CLMCLM-4153782026-07-07T07:52:38ZKYLE—KENNEDY2000-01-04··UHC-54040-20•••-••-8043—··——-NULLGRP-9337OPTIONS-PPO
CLMCLM-4134342026-04-04T04:39:19ZAndrew—Bell1964-08-20uhc-15391-25··—NULL-5494 Union StSAN ANTONIOTexas·78287GRP-8784··UNKNOWN
CLMCLM-4189102026-05-08T23:35:57ZRonald·····Ray1980-08-21UHC-88813-34-N/A-1776 Park PlaceHOUSTONTexas77001GRP-8876—
CLMCLM-4316202026-10-11T18:10:41ZEVELYNF.VARGAS06/15/1995UHC-61305-53—N/A—8105 Church StGlendaleAZ85347GRP-9192··CHOICE-PLUS-PPO
CLMCLM-4157492026-03-09T07:33:16ZBRIAN—REED··1964-12-08··UHC-65423-74UNKNOWN701-501-8114—586 Ocean AvenueDALLASTX75209GRP-4462-
CLMCLM-4105192026-08-03T07:29:34ZMartin, Diego——2007-10-15UHC-39798-52NULL··16817532472diego.martin47@proton.me—null—-····—
CLMCLM-4251172026-10-09T17:12:06ZHIOSHI—COOK1950-12-24UHC-54565-77····-UNKNOWN895 Mountain View DrChandlerAZ85254null—
CLMCLM-4249992026-07-01T13:50:04Zglooria—contreras1961-05-03UHC-42648-27NULL—UNKNOWN3733 VALLEY VIEW DRSeattleWA98156GRP-6533N/A
CLM CLM-423055 2026-06-17T13:09:30Zteresa—chavez19801208UHC-91472-66UNKNOWN—N/A-UNKNOWN—N/AGRP-8053··
32,829 rows, page 110 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:38.470Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty