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-4290872026-06-01T15:32:43ZTHOMAS··ISNYDER1999-07-18UHC-50742-28•••-••-027615149856368-2100 BASELINE ROAD··Las Vegasnv89116GRP-1890UNKNOWN
CLMCLM-4316872026-04-03T05:48:05ZANDREWQMARSHALL04/17/82··UHC9534043•••-••-7407·(744) 308-6912—6828 MEADOW LANE··San DiegoCA92120GRP-5809NULL
CLMCLM-4029792026-05-17T13:52:40ZMason—Santos1964-03-21UHC-10432-64——mason.santos97@proton.me·NULL—NULLUNKNOWNGRP-1369-
CLMCLM-4141992026-03-13T15:12:54ZMARI—LARSON5/7/1943—•••-••-6173201.447.5982null3626 Union StSEATTLEWA98192·GRP-9002—
CLMCLM-4036062026-02-23T15:02:24ZWatson, EmmaC—1991-08-15UHC-67915-09NULL5699816603·null1108 Elm StSACRAMENTOCA95854null—
CLMCLM-430341 2026-05-31T18:05:14ZRaymond—CarlsonSep 18, 1975nullN/A8945942038RAYMOND.CARLSON@PROTON.ME2186 BASELINE RD·AtlantaGA30342GRP-2044N/A··
CLMCLM-4053442026-06-10T22:48:48ZMATEOY.ARMSTRONG1990-09-02-—(233) 289-6184null6290 Grand AveColumbusOH··43257GRP-1140CHOICE-PLUS-PPO
CLMCLM-4054232026-03-22T03:53:18ZElijah—CoxJun 28, 1986UHC-15378-08•••-••-7586708-755-0164null5551 Main StJacksonvilleFL32237GRP-6667—
CLMCLM-4274332026-05-06T13:41:26Zmaria—muonz1966-03-01-—5747756207UNKNOWN—··—N/AGRP-5135NULL
CLMCLM-4037842026-03-31T17:35:36Z Heather—WalshOct 11, 1942UHC-45163-98•••-••-1610921-302-2278heather.walsh@hotmail.com6927 Oak StEDEN PRAIRIEMN55365GRP-8956SELECT-EPO
CLMCLM-4019342026-08-05T02:48:09Z·Albert—Miller02/09/40UHC-57977-59•••-••-2444NULLalbert.miller@icloud.com·5580 Hillcrest RdOrlandoFlorida32870-null
CLMCLM-4323812026-08-20T13:51:14ZDebra·GStevens1953-05-19——NULLnull1289 Lincoln Way··DenverCO·80211—UNKNOWN
CLMCLM-4260762026-04-26T09:18:27ZDOROTHY—PETERSON10/04/47UHC-20813-41•••-••-16497307123177····1631 Camelback RoadPhoenixaz85062GRP-4015CHOICE-PLUS-PPO
CLMCLM-4104032026-08-04T16:22:03Zmichael—willis19830307N/AUNKNOWN9113124229··null6056 Lake View Road #511Las VegasNV89157GRP-9182·NAVIGATE-HMO
CLMCLM-4235552026-08-15T02:19:42ZAaron—Hill1960-12-03UHC-02426-84•••-••-989819666371768N/A4751 Mesa DrDallasTX75213-MEDICARE-ADV-B
CLMCLM-4022392026-01-01T02:25:57Z Marilyn—Rojas19651115——(813) 408-4128—7257 LAKE VIEW ROADSCOTTSDALEAZ85260··UNKNOWN
CLMCLM-4280712026-07-10T23:41:03ZJanice—Hamilton·1977-02-23N/AN/A396-672-0156—6541 Cedar LnLas VegasNV89137GRP-1984UNKNOWN
CLMCLM-4098132026-05-06T19:53:07ZNATHAN—MORGAN··1969-04-07UHC-41203-84UNKNOWNnull———null—-—
CLMCLM-4313112026-05-13T06:41:29ZARJUND·MILLER27-04-1981UHC-66412-84•••-••-2221N/AN/A··810 Spring StPhoenixArizona85040GRP-3258UNKNOWN
CLMCLM-4236992026-03-22T01:39:15ZPriya—Fernandez1961-09-06UHC-54311-92•••-••-4617(223) 249-4186——····-—UNKNOWNMEDICARE-ADV-B
CLMCLM-4115682026-05-24T15:18:16ZSantiago··LMiller1951-02-23UHC-98037-76•••-••-73929432530574—963 MOUNTAIN VIEW DRSacramentoCA95893GRP-5273CORE-HMO
CLMCLM-4141192026-08-11T16:43:12Zjoseph—greene1966-11-03UHC-02610-23—810-409-0778NULL2364 PALM DRIVE Apt 10TempeAZ85298nullCORE-HMO
CLMCLM-4094012026-04-19T14:32:59ZARJUN—SULLVAN1967-11-02UHC-69356-13—7098308941—5726 BROADWAYJacksonvilleFL32202GRP-9442—
CLMCLM-4113152026-03-23T17:26:14ZJUDY—RIVERA1960-05-09UHC-37285-52—+1 837 641 8707N/A6789 Main StCHARLOTTENC··28209UNKNOWNSELECT-EPO
CLMCLM-4268782026-01-03T19:43:52ZAHMED—WILLIS11-08-2007·UNKNOWNN/A19683589025null-NULLUNKNOWNN/AGRP-1460UNKNOWN
CLMCLM-4241882026-09-20T12:36:40ZJanicePSchultz1982-07-06null—+1 662 987 2284-···7254 Forest AvenueCharlottenc28231GRP-1047—
CLMCLM-4144722026-03-05T12:52:34ZSimmons····David08/06/59UHC-48775-80•••-••-1300+1 615 211 7638—1491 Lake View RdFresnoCalifornia93713GRP-6434NAVIGATE-HMO
CLMCLM-4209592026-07-18T10:43:43ZCAMILAOREYES1981-06-18UHC-66882-65null····camila.reyes@outlook.com488 Grand AveLos AngelesCAN/AGRP-7765SELECT-EPO
CLMCLM-4124542026-07-09T20:08:28ZJosephI.Ward04/24/1957UHC-28293-97•••-••-1419NULL—6443 Bayshore DriveGlendaleAZ85367—MEDICARE-ADV-A
CLMCLM-4294902026-07-30T14:44:59ZGloria—Lopez12/10/42UHC-27080-04nullNULLN/AN/A——UNKNOWNGRP-9543-··
CLM CLM-4200042026-03-10T04:22:26ZANGELA—SIMS2005-08-22···UHC-18156-01null——null—nullNULLGRP-9303····
CLMCLM-4238912026-09-18T16:53:21ZCarol—Medina1925-02-19UHC-40323-59N/A6590593null3644 Mesa DrSan DiegoCA92102——
CLMCLM-4032762026-03-01T23:04:59ZBETTY—WEST2001-09-13UHC-62994-95•••-••-1265728-822-6476··7361 JEFFERSON AVENUEChandlerAZ85278GRP-1203···null
CLMCLM-4221432026-05-13T20:47:15ZJoan—Edwards1956-07-06—NULL(491) 761-6897null4205 Union StDallasTX75293·GRP-2620·NULL
CLMCLM-410534 2026-10-16T19:15:25ZGary—Simpson1987-01-09NULL•••-••-4789—N/A963 MEADOW LANENashvilleTN37238GRP-2326—
CLMCLM-4266712026-01-30T22:22:04ZBlaack, Sean··—··04/23/2000UHC-29465-84NULLN/A—N/A-N/ANULLNULL·MEDICARE-ADV-B
CLMCLM-4317102026-01-23T23:34:10ZANDREA—MATTHEWS26-04-1974UHC-26184-74nullN/AUNKNOWN—nullnull—GRP-9817··NULL
CLMCLM-4123592026-02-15T05:31:57Zcharles—soto10/08/1980·UHC2697503null—··833 JEFFERSON AVENUEEden PrairieMN55352·GRP-4512—
CLMCLM-4052212026-03-02T13:40:31ZNATHAN—DIXON1966-02-20UHC-50338-25•••-••-1232UNKNOWN··nathan.dixon67@gmail.com4708 Indian School RdHOUSTONTX··77070··GRP-3099-
CLMCLM-4015392026-10-13T18:44:02Z Jeffrey—Silva1978-08-05NULLN/A······4836 Pine Dr Apt 11Glendale·AZ85399GRP-4194·UNKNOWN
CLMCLM-4226702026-03-27T21:33:03ZNoahZ.Sanchez1989-10-24uhc-62379-68•••-••-6715(632) 479-8982··noah.sanchez53@outlook.com—UNKNOWN—N/A-MEDICARE-ADV-A
CLMCLM-4026632026-03-08T23:04:56ZYUKI—HERRERA1996-01-20UHC-52366-24N/A—N/A301 ELM STREETSan DiegoCA·92148-2689GRP-6922·null
CLMCLM-4213072026-03-18T15:48:41ZNATALIE··C.·CONTRERAS1994-03-21UHC-72727-37•••-••-15512346694032—2007 Highland AveLas Vegas·nv89196—CHOICE-PLUS-PPO
CLMCLM-4202512026-06-07T06:41:32Zthomas—berry08/14/94UHC-80771-70•••-••-7259··UNKNOWNUNKNOWN-N/AN/AGRP-8951UNKNOWN
CLMCLM-4202642026-04-03T06:07:23ZCHRISTOPHERTRIOS08/03/1956-•••-••-41822368808539-N/A—NULL··-—N/A
CLMCLM-4278152026-03-06T13:34:09ZWilliam—Walsh1952-05-27UHC-61186-88—(904) 540-8996nullN/A····—NULLUNKNOWNOPTIONS-PPO
CLMCLM-410332 2026-07-23T23:17:33ZRyan—·Howard1982-12-13··——(691) 441-8373N/A6856 Oak StreetJacksonvilleFL32262GRP-3678N/A
CLMCLM-4251212026-09-02T03:36:48ZKaren—Oliver1961-01-25····null——·532 Lincoln Way·HoustonTX77049N/A····
CLMCLM-4023002026-09-23T11:22:02ZFatimaLCarlson1980-12-19··UHC-32664-63--—nullNULL—nullGRP-8557—
CLMCLM-4271282026-09-04T01:49:23ZPhilip—Harris1963-02-18UHC-05604-54•••-••-88332819879162N/A7717 Valley View DriveCHANDLER·AZ85207-MEDICARE-ADV-A
32,829 rows, page 176 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.611Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty