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-4205892026-05-11T04:59:18ZEmma—Sanderrs1948-08-06UHC-54455-12•••-••-7756-emma.sanders@outlook.com6865 Sage CtNashvilleTN37297GRP-1150CHOICE-PLUS-PPO
CLMCLM-4031792026-02-05T10:52:47ZROY—RAY1946-07-24UHC-74378-53NULL—roy.ray@aol.com176 Central AvePHOENIXaz85055GRP-8588SELECT-EPO
CLMCLM-4114142026-09-05T20:28:14ZStewart, Vincent——1939-04-05——NULL—8497 VALLEY VIEW DRJacksonvilleFL··—GRP-5189CHOICE-PLUS-PPO
CLMCLM-4301152026-04-19T07:06:29ZGardner, Isabella——9/23/1997--743-845-2183-2017 SUNSET BLVDDALLASTX75208GRP-8335null··
CLM CLM-4066652026-09-03T03:34:33ZELIZABETH—HARRISON1965-09-25UHC-17943-36-423-555-0063nullNULLnullNULL—GRP-6450N/A
CLMCLM-4106762026-07-21T05:02:50ZGRACE—ROSS1985-12-22UHC-85981-15—(215) 274-7706NULL5740 Sunset BoulevardEden PrairieMN55308GRP-9022—
CLMCLM-4006512026-06-17T11:11:07ZARJUN—LUCAS——N/AUNKNOWN——NULL-—nullCHOICE-PLUS-PPO
CLMCLM-4235382026-03-16T07:14:45ZMarquez, KyleU—5/17/1961uhc-33743-82—(689) 891-6313—3116 Main StGlendaleAZ85367—NULL
CLMCLM-4180672026-05-23T18:48:18ZCollins, DouglasE····19411014UHC-00437-78———446 Baseline RoadTEMPEAZ85211GRP-9653—
CLMCLM-4271092026-10-07T08:41:31Zstephanie—gardnar1959-04-04··UHC-79152-88—-STEPHANIE.GARDNER@HOTMAIL.COMUNKNOWNnullnullnullGRP-5175MEDICARE-ADV-B
CLMCLM-4062832026-02-23T11:42:01ZEricQReed11/15/1967UHC-30938-27—N/ANULL6945 Ridge RoadAtlantaGAnullGRP-5594CORE-HMO
CLMCLM-4243172026-02-12T23:46:11ZEmily—Ortega1946-07-20—NULL942.578.5381UNKNOWN5771 Grand AvenueLas VegasNV89179-1971GRP-3289null
CLMCLM-4195522026-09-13T19:05:28Z William··PerrySep 14, 2005UHC-95896-51•••-••-0313—-·5842 Union StreetSan DiegoCA92161GRP-9407MEDICARE-ADV-B
CLM CLM-4176012026-06-02T22:46:39ZVargas, Arthur——1966-01-23UHC-94619-95—UNKNOWNN/A·null—NULL—N/A—
CLMCLM-4075042026-03-31T13:38:57Z·Julie—Lee1985-06-28UNKNOWN•••-••-70809624847955-7238 MAIN ST #929TucsonAZ——N/A
CLMCLM-4087142026-02-21T19:02:29ZGordon, Vincent····—1973-01-03NULL•••-••-8781—N/Anull—NULLUNKNOWN—medicare-adv-b
CLMCLM-4168882026-04-09T11:14:19ZHUGHES—JERRY1983-05-26UHC-35049-87•••-••-5123N/A—1707 Hillcrest RoadSeattleWA98147null··-
CLM CLM-4200352026-08-23T13:54:01ZBobby—Butler2008-11-09UHC-08110-05•••-••-5846-BOBBY.BUTLER@AOL.COM7923 Ridge Rd··FRESNO·CANULLGRP-5902SELECT-EPO
CLMCLM-4031012026-05-22T16:57:28ZRuth··Black11/09/62UHC-63053-46———3100 Washington StPlanoTX75023····MEDICARE-ADV-B
CLM CLM-4212172026-02-08T20:12:24Zrandy—carlson1948-01-28UNKNOWN•••-••-8110(311) 460-0537—9624 Baseline RoadDallasTX75207NULLN/A
CLMCLM-4012662026-10-07T15:38:38Z MARILYN—LONG1982-08-17null•••-••-7168469-651-5047-··4829 Oak Street·Atlantaga30357-N/A
CLMCLM-4312562026-08-25T14:22:00ZAndrew—Lopez2007-07-26-NULL5186699UNKNOWN6398 SPRING STREET Apt 26·ScottsdaleAZ85251GRP-1241MEDICARE-ADV-A··
CLMCLM-412031 2026-01-09T13:06:08ZLopez, Keith——1954-12-07UHC8581938null4926077912null—UNKNOWN——·GRP-1382OPTIONS-PPO
CLMCLM-4133152026-09-15T17:09:23Zpaul—garza02/09/96UHC-07864-19•••-••-7516NULL—-N/A—N/A—CHOICE-PLUS-PPO
CLMCLM-4160272026-08-27T14:50:43ZNguyen, Brenda··——19501010UHC-96686-39null——5028 Harbor BoulevardSan DiegoCalifornia92146··CORE-HMO
CLMCLM-4269182026-05-22T03:35:07ZCamilaERodriguez1945-09-18uhc-63430-90•••-••-66052476351402·null4784 Baseline RdPhoenixAZ85088·null·NULL
CLMCLM-4292722026-01-01T22:42:39ZDONNA—MOREENO3/17/1950UHC-42001-77•••-••-66952593735032donna.moreno38@icloud.com7910 Indian School RdGlendaleAZ85316—CHOICE-PLUS-PPO
CLMCLM-4036782026-10-13T20:56:06ZWilliamson, FrankP—13-10-1938··N/ANULL··5825 Forest Ave #233··Los AngelesCA90091GRP-9460OPTIONS-PPO
CLMCLM-4144972026-01-24T06:26:53Zphilip—vazquez6/27/1996UHC-46410-96null—UNKNOWN5436 Union StreetCOLUMBUSOH43262NULL—
CLMCLM-4266482026-05-12T17:38:51ZOlivia··G··Berry2/17/1949N/A—--5276 BroadwaySEATTLEWA98120·-—
CLMCLM-404838 2026-07-30T16:18:03ZELIZABETH—SIMMONS1938-07-15NULLnull+1 699 270 4178—6495 Harbor BlvdHoustonTexas77097-7121GRP-3992··
CLMCLM-4184972026-06-09T21:18:35ZMcDonald, IsabellaP—1967-08-02UHC-60298-72·N/A481-626-2445isabella.mcdonald35@aol.com7667 Pine Drive Apt 20ColumbusOH··43247GRP-8995NULL
CLMCLM-4207742026-05-09T04:52:49ZCarol—Jacobs2004-10-14··UHC-65981-16nullnull--N/A—NULLGRP-6695NULL··
CLMCLM-4282402026-03-23T21:25:40ZLuis—Torres1984-02-24·UHC-13129-49—978-383-5591UNKNOWN5075 River RdMIAMIFL33138—N/A
CLMCLM-4110122026-07-17T14:09:48ZGLORIA—GODON09/04/1952UHC-34684-56•••-••-735113825752341-9544 CAMELBACK ROADOrlandoFlorida32849GRP-2682CHOICE-PLUS-PPO
CLMCLM-4124522026-05-07T12:05:08ZBenjamin—·Robinson2006-11-02UHC-34560-42•••-••-8985+1 286 618 5207—5706 Church StScottsdaleAZ85295N/ANULL
CLMCLM-4103172026-01-03T14:50:53ZKimberlyH.Dixon·1998-09-20UHC-91029-41—14928315701-7851 Oak StreetScottsdaleAZ85254UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4215262026-03-26T13:18:29ZHelen··—Reid28-11-2005uhc-88997-72•••-••-3950(759) 740-1091—463 CEDAR LANE··MesaAZ85254-CORE-HMO
CLMCLM-4141052026-04-21T11:16:26ZISABELLA—LYNCH1998-01-28UNKNOWNnull—UNKNOWN—null·nullNULL··GRP-1014MEDICARE-ADV-B
CLMCLM-4095742026-07-06T00:02:38Z·HeatherTWelch04/06/1979-—(208) 201-9606—4656 Pine DrFresno··CA93790GRP-0795MEDICARE-ADV-B
CLMCLM-413257 2026-08-06T13:11:33Zjames—owens1980-03-02UHC4611034•••-••-0729NULL····6467 Camelback RoadPlanoTexas75086GRP-3418OPTIONS-PPO
CLMCLM-4103972026-08-08T05:47:42ZPhilipA··Wood1946-02-19··UHC-74863-07N/A8772941398UNKNOWN3849 Highland AveMESA·AZUNKNOWNUNKNOWNN/A··
CLMCLM-4250172026-02-12T00:32:37ZJulia—Wright15-05-1995UHC-22171-70———5217 Main StreetDallas··TX75241——
CLMCLM-4136922026-01-01T13:22:54ZDianeH.West··1996-07-02UHC-87387-07NULLNULL—9757 Ridge RoadCharlotteNC28285GRP-4511MEDICARE-ADV-A
CLMCLM-4055122026-05-19T04:21:00Zkathryn—lawson1941-09-02—•••-••-9284—N/A6143 Washington St·San AntonioTX78274GRP-9399NULL
CLMCLM-4154322026-07-04T22:54:47Zelizabeth—brown1971-01-24UHC-66461-69•••-••-1952·N/AN/A2433 Lincoln WayOrlandoFL32884GRP-5854NULL
CLMCLM-4029762026-03-18T23:16:30ZPhilip—Le1983-04-22UHC-39834-94•••-••-8011(753) 486-3035—3707 Union Street··JacksonvilleFL32202-6437null-
CLMCLM-4237952026-05-20T18:24:14ZSamantha—Reid·1977-02-22UHC-39955-17null6452977729N/A2709 HARBOR BOULEVARDOrlando··FL32874GRP-8276··—
CLMCLM-4327872026-01-17T12:51:51ZDEBORAH N—ROSE02/05/1955—•••-••-9086null—9124 BASELINE RDSan DiegoCalifornia92136GRP-3191MEDICARE-ADV-B··
CLMCLM-4068512026-08-12T15:35:43Z·DiegoHGonzales1982-30-26UHC-87150-98•••-••-2343——3904 Market StMinneapolisMN55408GRP-7605—
32,829 rows, page 76 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:37.737Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty