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-4145132026-09-01T21:30:58ZJonathan—Sullivan09-06-1969UHC-02849-76•••-••-31586668885855N/A2307 Forest AvenueCharlotteNC28259-0373nullN/A
CLMCLM-4174982026-04-02T03:25:38ZEMILY—WILLIAMS1946-02-18—•••-••-0277—null9305 Cedar LnAtlantaGA30305—-
CLMCLM-4239682026-03-08T21:40:22ZJONATHAN—DOMINGUEZSep 8, 1990UNKNOWNNULL(450) 235-0403UNKNOWN2989 Lincoln WaySCOTTSDALE·AZ85253-1155GRP-5805N/A
CLMCLM-4172322026-10-06T05:16:54ZMARIANA····TAYLORApr 2, 2005UHC-39730-46—(203) 677-9596UNKNOWN4501 Spring StreetOrlandoFL32876GRP-4431—
CLMCLM-4225352026-04-29T20:14:22ZWatkins, Steven——1956-06-02UHC-18796-43UNKNOWNnull··—5142 Broadway #231Mesaaz85224GRP-9669SELECT-EPO
CLMCLM-4048582026-02-11T09:30:08Z·Arthur—Harris02/13/84N/ANULL18566058465arthur.harris70@outlook.com6027 Church StScottsdale·AZ85262GRP-6816—
CLMCLM-4090052026-02-14T22:59:19ZJacqueline—Williams···1947-08-08UHC-10689-03—(887) 281-0914UNKNOWN7124 CAMELBACK ROADTUCSONAZ85756GRP-0741·MEDICARE-ADV-B
CLMCLM-4065322026-07-19T17:19:22ZAlbert—Banks1998-02-12·UHC-93683-76•••-••-4071UNKNOWNUNKNOWN-null—··GRP-0583—
CLMCLM-4263362026-07-09T23:58:23Z·JANET—·EAVNS1955-07-18UHC-24100-32•••-••-029119832490350·null9834 Palm Drive··MINNEAPOLISMN55476-CORE-HMO
CLMCLM-4271102026-03-07T22:41:16Zisabella—barnes1995-09-02N/A•••-••-0494223-657-8131isabella.barnes@proton.me5646 Elm StFresnoCAUNKNOWN—NULL
CLMCLM-4301532026-01-27T17:11:01ZDIANE—CARTER19730622UHC-52209-86•••-••-4375379-917-9824—663 Main StSan DiegoCA92173nullMEDICARE-ADV-A
CLM CLM-4317712026-10-10T07:54:55ZKyle··NOlievr··1974-12-19UHC-64045-01N/A—N/A16 MESA DRIVEMinneapolisMN55428·GRP-9480NAVIGATE-HMO
CLMCLM-4059932026-07-23T10:22:14Zlauren—taylor1984-08-28—N/A(924) 410-3628null8577 Indian School RdJacksonvilleFL32252GRP-8519OPTIONS-PPO
CLM CLM-4219222026-08-19T02:36:58Z Theresa—Henry1991-12-11UNKNOWN•••-••-2400UNKNOWN··—8184 Meadow Ln Apt 13San DiegoCA92175-1448nullnull
CLM CLM-4031422026-08-15T14:04:33ZArthurHRice2001-04-24UHC-69841-73NULL(356) 905-4601arthur.rice69@aol.com·4593 Highland AveNashvilleTN37279UNKNOWNMEDICARE-ADV-B
CLMCLM-4207302026-06-10T07:34:38ZHICKS—KELLYNov 3, 1958UHC-46966-74····——2724 Apache BoulevardNashvilleTN37285GRP-5940MEDICARE-ADV-A
CLMCLM-4283442026-07-31T11:47:07Z·Yuki—Willis·1985-12-25UHC-15526-71·null····—N/Anullnull—GRP-0506NAVIGATE-HMO
CLMCLM-4128522026-09-21T09:49:56ZJudith—Vasquez1995-12-01NULL•••-••-68023592911890-3739 Lake View RdAustintx78717GRP-6095—
CLMCLM-4196582026-05-15T23:54:55ZKimberly····Henderson1980-20-01UHC-76058-16•••-••-792414509111685—5226 Desert Sky BlvdAUSTINTexas78772GRP-1968null
CLMCLM-4222282026-03-03T13:11:19ZGeraldN··Hicks1938-04-05—•••-••-2705—N/A8131 MAIN STCHARLOTTENC···28238—NULL
CLMCLM-4224792026-04-16T21:32:55ZDorothy—Wood1949-05-01null-475-330-6546dorothy.wood@gmail.com7288 Mesa DriveJacksonvilleFL32293GRP-3319medicare-adv-b
CLMCLM-4293952026-08-31T12:12:39ZALEXIS—PRICE1997-10-10UHC-53316-85-·2034729259-300 BAYSHORE DRIVE #703AtlantaGA·30358GRP-7828NAVIGATE-HMO
CLMCLM-4142802026-07-31T06:19:19Z Linda—Torres1956-04-10——6054037364—6643 Mountain View DrScottsdaleAZ·85208-0665GRP-6930MEDICARE-ADV-B
CLMCLM-4128672026-02-22T07:31:50ZJUDITH—DUNN1974-06-08UHC-01652-57··null—-NULL—N/A—nullUNKNOWN
CLMCLM-4124062026-05-17T02:25:19ZPena, Olivia——1962-11-01UHC-64907-39•••-••-9857(499) 402-2698-NULL——UNKNOWNGRP-8168NAVIGATE-HMO
CLMCLM-4174362026-06-03T03:12:37ZAngela—Sullivan1962-09-80UHC-92117-15NULL+1 824 923 2096angela.sullivan72@proton.me173 Indian School RdMinneapolisMN55402N/AMEDICARE-ADV-B
CLMCLM-4208562026-07-18T20:33:44ZDennisMHansen1940-05-06··UHC-38793-05UNKNOWN——-UNKNOWN-··NULLUNKNOWNnull
CLMCLM-409259 2026-03-17T09:38:16ZSHIRLEY—DOMINGUEZ1944-12-02UHC-22993-45-531-314-8066UNKNOWN5904 Hillcrest RoadTampaFL33619—-
CLMCLM-4048172026-10-17T13:38:14ZAngelaGGordon1989-03-20UHC-91021-02-—N/A4781 Pine DrMiamiFL33108GRP-3758CHOICE-PLUS-PPO
CLMCLM-4307632026-10-18T09:15:50ZZachary—Baker1952-04-10UHC-62292-08•••-••-6809(958) 503-5297null··9465 Grand AveEden PrairieMN·55345GRP-5121NAVIGATE-HMO
CLMCLM-4160882026-03-31T23:33:57ZMatthew—Stevens1964-03-01-NULLUNKNOWN-——UNKNOWNN/AnullCORE-HMO
CLM CLM-401060 2026-10-02T20:30:02ZCHARLES··—HUNTER19890608UHC-17944-90•••-••-60275238736858—5023 ELM STREETTempeAZ85267GRP-3530NAVIGATE-HMO
CLMCLM-4082712026-05-28T13:44:57ZMATTHEWI··HAMILTON1992-09-05UHC-62583-91UNKNOWNNULL—6539 Highland Ave·Planotx75036GRP-6318null
CLMCLM-4221982026-10-11T09:28:42ZJudyB.Gilbert1994-02-24UHC-05548-84•••-••-3965—UNKNOWNUNKNOWN·NULLUNKNOWNnullGRP-2063CORE-HMO
CLMCLM-4080132026-02-06T01:07:04ZRachel—Romaro1978-10-03—NULL——3385 Hillcrest RdJacksonvilleFL32284null··—
CLMCLM-4071802026-01-09T23:17:35ZDiane—Alvarez1998-06-11N/A•••-••-2618358-552-0249—7578 Central AvenuePlanoTX75055UNKNOWN—
CLMCLM-4287742026-04-24T19:20:07ZMichael—Duncan0204-05-22——null-1692 CENTRAL AVECharlotteNC28285GRP-9089MEDICARE-ADV-A
CLMCLM-4253522026-05-11T12:24:20ZCarl—Hunt1952-07-25—•••-••-8846+1 347 303 5200-8099 Spring StreetSan AntonioTX78203GRP-9837—
CLMCLM-4081642026-02-18T17:45:06ZPHILIP—BLACK02/06/55UHC-68692-47NULL-UNKNOWN1873 Forest AvenueHoustonTX—GRP-8027·SELECT-EPO
CLMCLM-4113812026-07-04T11:57:43ZJudy—Miller·1994-05-09—N/AUNKNOWNN/A9313 River RdTampaFlorida33660GRP-0825—
CLMCLM-4053912026-01-09T11:58:01ZANDREWCBURKE1/28/1989UNKNOWN•••-••-3451—-UNKNOWN-N/ANULLGRP-8743MEDICARE-ADV-A
CLMCLM-4130752026-08-25T00:04:17ZSOFIAAWONG1978-03-15···UHC-38789-39•••-••-8939420-781-5854-2750 Spring StMiami·FL33138-8566N/A··NULL
CLMCLM-4087652026-06-24T03:36:07Zlinda—wang1951-03-02UHC-62194-36•••-••-9308-LINDA.WANG@GMAIL.COM·-———GRP-1498-
CLMCLM-4036652026-07-29T12:57:55ZMICHELLE—PERKINS12/16/1962UHC7220733•••-••-4913UNKNOWN—7224 Lake View RoadTampaFL33672-4322—CHOICE-PLUS-PPO
CLMCLM-4178912026-06-28T07:35:35ZMithcell, Charles——2008-12-26UHC-47452-54··—+1 894 241 9102-—NULLN/A—GRP-2965—
CLMCLM-4190842026-06-22T17:27:08Zscott—tran1976-08-06UHC-47745-73—·+1 869 699 5329null1201 Palm DrHOUSTON··TX77031NULLCORE-HMO
CLMCLM-4046732026-10-11T18:30:41ZAdam··Freeman1954-12-10UHC-15081-88NULLUNKNOWN—3183 BAYSHORE DRCharlotteNC28266GRP-5498CHOICE-PLUS-PPO
CLMCLM-4121752026-02-25T11:30:21Z SEAN—FULLER1986-08-24UNKNOWN•••-••-0956—UNKNOWN8628 SPRING STREETCharlotteNC··28200GRP-6051NAVIGATE-HMO
CLMCLM-4075332026-08-28T19:52:55Z·lauraVbryant1986-06-09UHC-42238-04N/A(791) 932-1075nullnullN/A—NULLGRP-0420NAVIGATE-HMO
CLMCLM-4116492026-05-04T07:15:25ZCYNTHIA—BAKER5/26/1940UHC-09215-77•••-••-0053——2238 Grand Avenue #807NashvilleTN37263GRP-4738··CHOICE-PLUS-PPO
32,829 rows, page 202 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.421Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty