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-4064242026-01-13T14:12:17ZElijah, Lawrence——10/13/60uhc-97485-21null12782758135null7475 CEDAR LANEPhoenixAZ85091GRP-9378NAVIGATE-HMO
CLMCLM-4029252026-09-23T16:04:13ZLOGAN—BRADLEY1919-02-14··UHC-10378-53NULL(833) 728-9041—4382 JEFFERSON AVEPlanoTX75086NULLNAVIGATE-HMO
CLMCLM-4133732026-10-17T17:22:27Z·Gonzales, Logan Y.··—1986-07-13UHC-19729-25NULL613-358-0109-6025 River RoadORLANDOFL32899GRP-9814CORE-HMO
CLMCLM-4288442026-03-11T10:44:02ZHARRISON—HENRY1986-07-18·UHC-33101-68——henry.harrison44@yahoo.com7019 Washington StreetChandlerAZ85234GRP-4601··MEDICARE-ADV-B
CLMCLM-4098402026-09-12T19:14:32ZvictoriaPmitchell5/8/1982·UHC-89946-94·null14719235847··null4460 Mountain View Dr··NashvilleTN37207GRP-0196SELECT-EPO
CLMCLM-4295462026-08-13T10:16:17ZJACOBCCOLEMAN·1952-08-26UNKNOWNNULL262-341-4306NULL7965 PALM DRIVE #931JacksonvilleFL32268GRP-5908CHOICE-PLUS-PPO
CLMCLM-4039432026-09-22T07:49:24ZHeather··C·Fuller10/26/1938··UHC-24859-05UNKNOWN(894) 672-2041—1004 BAYSHORE DRIVEMesaaz85204··GRP-4700—
CLMCLM-4122842026-03-18T23:03:24ZKATHLEEN—BRYANT08/19/93UHC-97131-90··•••-••-39375482378126NULLN/ANULL—UNKNOWNGRP-1342MEDICARE-ADV-B
CLMCLM-4081582026-07-29T15:56:09ZKyle—Jackson19900801UHC3994784•••-••-7690228.651.6130null8941 CHURCH STScottsdaleAZ··85234GRP-1410MEDICARE-ADV-B
CLMCLM-4264832026-02-28T13:11:11ZWilliamson, JenniferZ—1977-01-02uhc-04711-37—(940) 414-4531—5587 Apache BoulevardDenverCO80290GRP-0260N/A
CLMCLM-4294812026-02-11T04:33:01ZDENISE—OBRIEN··1947-05-13·UHC-16406-79•••-••-6674-NULL9137 INDIAN SCHOOL ROADNashvilleTNUNKNOWNN/A—
CLMCLM-4092662026-06-02T13:43:49Z Edward—Bishop··1986-11-16··UHC-10043-12•••-••-9858(309) 984-3614edward.bishop88@gmail.com8152 Lincoln WayChandlerAZ··85231GRP-2646NAVIGATE-HMO
CLMCLM-4063642026-09-23T14:17:26ZJordanK·Richards1964-04-15-—5290762N/A4417 Market St·CHARLOTTENC28204GRP-9918OPTIONS-PPO
CLMCLM-4269202026-03-27T06:49:38ZOmar····Li19520627-——null2889 Central Ave·MesaAZ85299nullCORE-HMO··
CLMCLM-4068122026-09-13T07:51:36ZLewis, Vincent—··02/13/1977UHC5990389····7694508550NULL7484 Bayshore DrGlendaleAZ-GRP-1771—
CLMCLM-4177422026-09-30T12:02:41ZBRYAN—SIMMONS1947-11-10-··•••-••-2548nullbryan.simmons2@proton.me67 Bayshore DrAtlantaGA30364—NULL
CLMCLM-4200132026-04-15T05:51:31Z·Terry—Burns19710912UHC1791164—9912831UNKNOWN8343 MAIN STTampaFL···33601--
CLMCLM-4210732026-04-24T05:50:17ZRICHARDWLUCAS5/16/1962UHC-76193-77N/A948-963-2123UNKNOWN2788 Mesa DrTampaFL33651GRP-9272··-
CLMCLM-432816 2026-01-23T14:29:18Z·JANET····RYAN1975-11-19uhc-91920-53•••-••-2822—UNKNOWN——nullnull··—MEDICARE-ADV-B
CLMCLM-4246552026-10-10T05:12:05Zomar—harvey10/05/2008UHC-08537-63··(233) 836-6897-——--GRP-3269·CORE-HMO
CLM CLM-408210 2026-05-05T15:53:46Zjanet—aguilar05/27/06UHC-14912-04•••-••-76506043631534null8578 Ridge Road··San Antonio···TX78203-2721UNKNOWN—
CLMCLM-4090872026-07-03T23:14:33ZKeith—Marquez10/10/1955UHC-58160-46•••-••-3940—·KEITH.MARQUEZ39@PROTON.ME7217 Spring St··SeattleWA98195UNKNOWN—
CLMCLM-4010162026-08-22T04:26:14ZJANET····GIBSON1966-08-04-—·NULL-8053 Mesa DriveJacksonvilleFL32262GRP-2761CORE-HMO
CLMCLM-4043452026-04-30T11:23:50ZAMY—HANSON10/3/1938UHC-42412-56null+1 479 356 6270—8796 BAYSHORE DRIVEColumbusOH43240·N/ANULL
CLMCLM-4309762026-09-03T14:27:04ZPHILIP—DAY1599-06-01·uhc-67344-68•••-••-773018455978616····6435 SAGE CTPlanoTX75021UNKNOWN—
CLMCLM-4300002026-07-10T02:04:08ZJACK··PIERCE1996-01-01UHC-70363-83·······-—NULL-——MEDICARE-ADV-A··
CLMCLM-4081972026-01-18T02:25:05ZLuna—BrendanullUHC-89078-96null—N/A1396 Palm DrTampafl33693-3497GRP-9527N/A
CLMCLM-423134 2026-03-23T06:51:46ZBruce—Jackson··1956-10-19UHC-34324-18UNKNOWN····—8460 Oak St·JacksonvilleFL32261GRP-2844NAVIGATE-HMO
CLMCLM-4320912026-06-13T12:32:53ZCarol—Le02-07-1989null•••-••-7391N/Anull4332 Grand AveSacramentoCA95846GRP-1999MEDICARE-ADV-A
CLMCLM-4097122026-04-21T18:36:36Z·Elijah—Parker01-01-1980UHC-21161-41•••-••-4645NULLNULL—nullNULLUNKNOWNGRP-3154N/A
CLMCLM-4126602026-06-24T07:53:48ZGeorge—Vasquez··20081114UHC-45591-16•••-••-7357UNKNOWN····-—-NULLMEDICARE-ADV-B
CLMCLM-4124502026-07-03T20:37:50ZKevinP.Lewis1972-06-28-—UNKNOWNUNKNOWN8730 Sage CourtSan DiegoCA92157GRP-6646—
CLMCLM-4290662026-08-31T06:13:16Z·Justin—Ruiz06/17/1971UHC-43319-05—8298808287—4303 Grand AvenueLas Vegas··NV89134——
CLMCLM-4005162026-06-14T13:28:21ZLaura—Eans2000-08-09-UNKNOWN6808085973UNKNOWN7706 Valley View DriveAUSTINTX78788nullnull
CLMCLM-430014 2026-09-19T00:12:48ZDianeERuiz05/15/48UHC-80079-74null—N/A6629 Spring StreetSeattleWA98155GRP-4103CHOICE-PLUS-PPO
CLMCLM-4196202026-05-07T00:48:46ZRay, Debra——06/16/70UHC-95973-52•••-••-600217129549165··—9349 MEADOW LN #709San DiegoCalifornia92106GRP-0439UNKNOWN
CLMCLM-4156572026-08-23T06:58:31ZjackAgarza1965-12-27N/AUNKNOWN-null5373 Apache BlvdTempeAZ85203GRP-1125·UNKNOWN
CLMCLM-4030712026-04-26T14:31:14ZWest, Diego····—1962-07-26UHC-45695-22nullUNKNOWNUNKNOWN··3822 Baseline RdDallasTexas75235GRP-5435-
CLMCLM-4164482026-05-08T12:57:28Ztimothy··Qbradley·1995-04-24·UHC-04907-10UNKNOWNNULLNULL6465 Palm DrTAMPAFL33672—N/A
CLMCLM-4007322026-05-22T18:39:25ZGerald—McDonald·1968-02-01UHC-64585-32N/AnullUNKNOWN4413 Maple AveFresnoCA93789-5149—····
CLMCLM-4255132026-09-12T13:46:35ZWALTER—MORRIS19450818UHC-18011-83N/A752.855.2367N/A9310 Forest AveLas VegasNV89124GRP-0345—
CLMCLM-4325282026-03-14T21:37:32Z AMBER—SALAZAR19950604UHC-48415-05nullNULL-5289 JEFFERSON AVE Apt 30AtlantaGA30368——
CLMCLM-4230632026-05-02T03:10:35ZBeverly—·Valdez19891024N/A•••-••-7566—N/Anullnull··null-··GRP-1962CORE-HMO
CLMCLM-425716 2026-09-07T23:35:09ZTeresaH.Fisher04/26/59UHC-20504-81•••-••-8579—UNKNOWNUNKNOWN—-NULLN/A·NULL
CLMCLM-4004932026-09-04T21:34:41ZAmanda·GMarshall1941-03-22··UHC-26457-27•••-••-5944—··————GRP-1427OPTIONS-PPO
CLMCLM-4252922026-10-10T15:38:56ZPatrick—Parker01-09-1986UHC-14708-32UNKNOWN14863249088UNKNOWN5982 Bayshore DrTempeAZ85211-5699GRP-9749CORE-HMO
CLMCLM-4108012026-04-02T10:15:15ZrussellRrodriguez1970-08-16UHC-07390-28•••-••-6515NULL———NULL—GRP-5422NULL
CLMCLM-4065552026-01-21T00:24:28ZCharles—Ramirez07/08/1979·UHC-36541-43NULL362-465-9394—4626 SAGE COURTSacramentoCA95816GRP-4616NAVIGATE-HMO
CLMCLM-419343 2026-01-14T19:24:22ZJermey—·Gomez1972-08-09UHC-62554-77•••-••-3917607-644-1297UNKNOWN5315 Mesa Drive··MINNEAPOLISMN··55462GRP-1718—
CLMCLM-4292042026-07-15T18:07:35ZBRIANRLITTLE25-11-2007UNKNOWN—2717446N/A-NULL··——-null··
32,829 rows, page 174 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.607Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty