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-4166572026-04-25T12:17:19ZSimpson, Judith——1986-04-27—•••-••-3796—····2933 Pine DrTEMPEAZ85207GRP-4563MEDICARE-ADV-B
CLMCLM-4048562026-09-01T03:01:48ZBOBBYDROMERO2001-02-09UHC-25052-40•••-••-3310—null8742 PARK PLSEATTLEWA98154GRP-0273null··
CLMCLM-4142872026-03-01T20:48:17Zemily······schultz04/05/1965UHC-94615-23··-·820-276-0943emily.schultz45@proton.meUNKNOWNUNKNOWN——GRP-4197CORE-HMO
CLMCLM-4250322026-02-19T09:47:14ZBRYAN—HOLMES7/9/2001·UHC-32802-07•••-••-7992—·-—N/AN/A—GRP-2075MEDICARE-ADV-B
CLMCLM-4155732026-01-30T10:46:04ZDennis—Dominguez1966-12-28··UHC-79255-89-2938775————UNKNOWN—CORE-HMO
CLMCLM-4099622026-04-18T19:43:14ZEthan—Hill1944-05-11UHC-60191-91·null—null·3252 Main StAUSTINTexas78790GRP-0488N/A
CLMCLM-4307452026-01-06T11:25:28Z Ruth··B.Price··Mar 4, 1965UHC-95799-71-+1 730 505 7393ruth.price30@gmail.com1483 Maple AvenueMinneapolisMN55498—N/A
CLMCLM-4254662026-08-01T06:56:45ZMARIANA··—PATEL·1956-02-11UHC-03136-39•••-••-6296—mariana.patel@proton.me··2743 APACHE BOULEVARDGilbertAZ85230GRP-2048··-
CLMCLM-4029082026-10-05T22:33:17ZPETERKBROOKS9/18/1965NULL—·NULL····2138 Union StSeattleWA98164N/ANAVIGATE-HMO
CLMCLM-4246272026-03-24T19:07:41ZAnn—Ferguson28-06-1972UHC4686734•••-••-3557NULLNULL5384 Hillcrest Rd #706Columbus··oh43278··NULL
CLMCLM-4113282026-04-16T21:31:46ZBrittanyM.·Wilson19790102UHC-08584-56—NULLUNKNOWN-—N/A-GRP-2110—
CLMCLM-4210522026-05-01T12:59:58ZFrank··—Howard1984-09-13UHC-75968-98-N/A—4846 ELM ST·GlendaleArizonaNULLGRP-6467····
CLMCLM-4235122026-04-20T03:21:11Z·VINKENT—PERRY1968-01-10UHC-67325-82··null—····7903 Ocean AveMESAAZ·85217nullNAVIGATE-HMO
CLMCLM-4250492026-04-01T04:58:59ZJohnson, Mark——1989-09-14UHC-68075-73•••-••-9441····—3957 Willow CourtSCOTTSDALEAZ85265GRP-5056OPTIONS-PPO
CLMCLM-4181262026-07-22T10:21:35ZHelen—Marshall1965-06-04UHC-81480-61•••-••-5360938-486-8552——UNKNOWN—-GRP-2468CORE-HMO
CLM CLM-4057282026-04-12T20:28:26ZBRADLEY—CARROLL11-04-1978UHC-55821-47•••-••-423718897810735—9524 Palm Drive·Eden PrairieMN55384GRP-7390null
CLMCLM-4022712026-01-21T19:15:30ZKatherineY.··Marquez1976-01-17UHC-21181-70—(923) 639-0778null6413 Grand AvenueCOLUMBUSOH—GRP-3706NAVIGATE-HMO
CLMCLM-4165122026-04-13T10:26:12ZAnthony—Cox1949-08-20N/AUNKNOWNN/A·anthony.cox@hotmail.com7541 Maple Ave #100San AntonioTX78272GRP-7926—
CLMCLM-4182872026-09-08T07:21:31Znatalie—stewart15-01-1967—•••-••-7408801-396-8414—4853 Jefferson Avenue Apt 4MESAAZ85231GRP-3722—
CLMCLM-4148232026-02-22T03:17:37ZJohn··Salazar9194-07-01UHC-24125-50-554-968-0666NULLUNKNOWNN/AUNKNOWNNULLGRP-4010MEDICARE-ADV-B··
CLMCLM-4170442026-05-22T21:21:04ZThomas—Foster05/26/1999UHC-99921-94——null··369 OCEAN AVE···DenverCO80260GRP-6029NULL
CLMCLM-4005702026-01-21T13:10:11ZMaosn—Gonzalez12/23/1962UHC-48888-88·N/AN/A-7688 Valley View DriveMinneapolisMN55413GRP-6270—
CLMCLM-4104152026-08-02T07:13:53ZTheresa··Foster1965-09-06NULLNULLN/A—8878 Lincoln WaySan AntonioTX78209GRP-3916··
CLMCLM-4210162026-09-30T23:49:53ZRussell—Espinoza1980-02-28nullnull9436534566nullNULL-——-null
CLMCLM-4203472026-03-28T22:06:48Z ·Vega, Mateo——1939-06-18null—833.471.7898——NULL··——CORE-HMO··
CLMCLM-428177 2026-01-05T12:10:46ZJerry—Mendez6/22/1963·NULLnull—UNKNOWN5505 Canyon RoadLas VegasNV89199—·MEDICARE-ADV-B
CLMCLM-4035552026-02-10T17:07:14ZMARILYN—ELLIOTT2008-05-15UNKNOWNNULL(212) 878-3719MARILYN.ELLIOTT@ICLOUD.COM1704 UNION STREETAtlantaGA30342GRP-6960NULL
CLMCLM-412768 2026-01-08T13:23:51ZSUSAN—CUNNINGHAM1972-05-03UHC-54309-49•••-••-2841N/A··—1351 Baseline RdGilbertArizona85266GRP-6205MEDICARE-ADV-B
CLMCLM-4010722026-06-13T01:50:07Zchristian—marshall1949-12-23UHC-23971-08-——····UNKNOWN—-—OPTIONS-PPO
CLMCLM-4225182026-07-16T16:37:25ZAlice—Bishop12/09/1969—•••-••-5414675-350-9647—3124 MAIN STNASHVILLETN37225UNKNOWN···NULL
CLMCLM-4225362026-04-14T07:38:45ZMATEOTGOMEZOct 2, 1973UHC-94373-83•••-••-0423——607 Grand AveLAS VEGASNV89143GRP-3141MEDICARE-ADV-A
CLMCLM-4170772026-03-28T14:47:50ZBILLY—GRIFFIN1986-06-20UHC-51997-76•••-••-11979124540129—1134 Valley View DrHOUSTONTX··77016—null
CLMCLM-4292702026-07-04T02:08:03ZAmandaQDay2003-05-12····•••-••-9212—null··NULL—··GRP-5576UNKNOWN
CLMCLM-4107822026-09-09T12:29:07ZJUAN—·HART·1970-04-08UHC-11791-07··•••-••-9124(921) 351-3526·JUAN.HART@HOTMAIL.COM3203 MEADOW LNJACKSONVILLEFL32257——
CLMCLM-4074112026-04-19T03:04:24Z CAROLYN—JIMENEZ1947-10-28UHC-43087-38——N/A3589 Pine DrColumbusOH43242UNKNOWN—
CLMCLM-4085792026-01-02T16:04:22ZJoshua—HolmesApr 20, 1977UHC-28099-06•••-••-4569—NULL·-UNKNOWNNULLN/AGRP-9480NAVIGATE-HMO
CLMCLM-4077682026-01-29T16:25:07ZBlack, Glora—··1994-12-14null··UNKNOWN794-804-5970GLORIA.BLACK16@HOTMAIL.COMnull·nullN/AnullGRP-1834NAVIGATE-HMO
CLMCLM-4059542026-03-10T07:25:00ZEUGENE—CARLSONAug 18, 1993UHC-73643-65NULL4763169237···7646 Ridge RoadPhoenixAZ·85051UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4239552026-07-13T05:05:50ZTyer—Edwards1988-03-04UHC-69572-78null(842) 508-1422NULL8005 Church St #102Los AngelesCalifornia90056GRP-6863null
CLMCLM-4137972026-06-15T01:43:21ZMatthewHHall···1983-03-09—•••-••-2867——UNKNOWNnullNULLNULL—null··
CLMCLM-4197402026-09-05T19:29:08ZKATHRYN—DAY1982-11-24UHC-37330-92·UNKNOWN4948845985··6913 River RoadCharlotteNC28278·GRP-2857medicare-adv-b
CLMCLM-4268752026-02-10T20:17:35ZHENRY—WATSON··1/3/1964—null—N/A2496 Valley View DrCharlotteNC28279··GRP-3046··
CLMCLM-4227272026-03-21T00:55:16ZBenjamin—Fuller03/15/1964UHC-11971-67——UNKNOWN4702 Spring St·NASHVILLETN37237GRP-7658NULL
CLMCLM-4211452026-08-31T07:12:15ZTONY··WALSH1957-03-18UHC-21787-35--····7990 VALLEY VIEW DRIVE··SEATTLEWA98169——
CLMCLM-4162192026-05-08T18:15:31ZRogers, Kyle——1941-02-15UHC-43750-48•••-••-0703(577) 203-8067-—N/A·-—GRP-2942options-ppo
CLMCLM-4119032026-07-01T03:18:41ZElizabeth—Dominguez1974-03-10UHC-35965-93—676.627.4170UNKNOWN4119 CHURCH STREETCharlotteNC28251N/AOPTIONS-PPO
CLMCLM-4109042026-07-07T20:30:59ZCharles—Dunn1993-10-24UHC-26801-85-8153372CHARLES.DUNN@ICLOUD.COM4956 MEADOW LNColumbusOhio43288—OPTIONS-PPO
CLMCLM-4306562026-08-09T17:29:32ZValentina—White19581018—null·744-200-7947N/A7046 Hillcrest RdMINNEAPOLISMN55412NULLUNKNOWN
CLMCLM-4034292026-06-01T04:09:12ZCole, Aisha——1975-04-01·-····+1 459 341 6989-4922 Cedar LaneMINNEAPOLISMN55410GRP-5066·MEDICARE-ADV-A
CLMCLM-4176052026-10-11T13:20:32ZArthurT.Gibson25-09-1982UHC-31926-06•••-••-7626—UNKNOWN··UNKNOWN-UNKNOWN—NULLNAVIGATE-HMO
32,829 rows, page 67 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.722Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty