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-425786 2026-07-07T10:31:44ZBradley, Danielle——19980218UNKNOWN·nullnull—670 Pine DriveDenverCO80201N/A—
CLMCLM-4275262026-03-10T04:24:03ZAnn—Silva1967-02-28nullUNKNOWN··439.714.7845—924 Desert Sky BoulevardSan DiegoCA92117-MEDICARE-ADV-A
CLMCLM-4198192026-03-30T23:23:47Z·Munoz, Arthur——1956-01-04UHC5514203•••-••-7752·N/ANULL4160 Sage CourtTAMPAFL33691GRP-6278NULL
CLM CLM-4040182026-07-20T13:27:49ZALEXANDER—CARTER1945-11-27··•••-••-4379(459) 260-6591··-··2760 Baseline Rd·Las VegasNV89172GRP-4172null
CLMCLM-4073612026-05-16T19:48:34ZROBERT··—PATELJan 8, 1998UHC-85449-55•••-••-97776004637069—N/A·UNKNOWN-—NULLSELECT-EPO
CLMCLM-4200782026-04-28T20:15:22ZMAIDSON—·FLORES0179-19-75··UHC-58663-08—NULL—4481 Mountain View DriveGILBERTAZ85252GRP-1651-
CLMCLM-4286572026-06-08T15:49:05ZAISHA····COX1948-11-27UHC-40748-27•••-••-2754(785) 759-3363—3223 Harbor BoulevardLas VegasNV89152-5350NULL·MEDICARE-ADV-B
CLMCLM-4060812026-02-06T11:49:41ZGeorgeRFernandezMar 23, 1959··NULL··818-996-0415—-—N/AnullGRP-7435··SELECT-EPO
CLMCLM-432547 2026-02-27T00:21:03ZJDUY—WELLS1989-06-18UHC-65896-08—NULL—5771 Indian School RoadSCOTTSDALE··AZ·85236GRP-6861—
CLMCLM-4306492026-02-07T01:56:04ZSharon—Davis05-09-1995-•••-••-9602+1 367 570 3349—8337 Canyon RdPlanoTX75066-2960GRP-5391NULL
CLMCLM-4304852026-06-01T20:53:56ZSarah—Sanchez9143-03-13··•••-••-4088—UNKNOWN—nullN/A——UNKNOWN
CLMCLM-4124232026-08-15T16:00:28ZKenneth—George1945-10-13··UHC-44938-15•••-••-1006UNKNOWN·NULL8887 Pine DrTUCSONAZ85749-4874GRP-5899N/A
CLMCLM-4055682026-07-22T01:30:03ZMASSON—GOMEZ1962-04-19uhc-14665-92•••-••-2558(795) 508-1423—3565 HILLCREST ROADGILBERTAZ85264-2538GRP-0166·CORE-HMO
CLMCLM-4296622026-10-02T01:15:32ZSHIRLEY—ROJAS02-01-1966UHC-61087-91•••-••-4385+1 706 506 9754—4695 INDIAN SCHOOL RDFresnoCalifornia93760GRP-9951N/A
CLMCLM-4223392026-01-27T18:51:10ZPAMELA—REYAS1992-12-03·UHC-99188-54—314-690-3524N/A··—NULLnullN/AGRP-8922—
CLMCLM-4154652026-10-17T18:07:55ZFRANKLIN—JUAN3/8/1963UHC-92188-10null·(442) 307-7818——nullNULL-GRP-7403null
CLMCLM-4013012026-09-15T06:02:40ZRandy—Robinson2005-09-19UHC-80582-02—N/AUNKNOWN2874 Harbor BlvdSan AntonioTX78201GRP-7110—
CLMCLM-4092242026-05-28T05:59:17ZValentina—Moore19790923UHC-89782-29UNKNOWN515-897-3724—6292 MEADOW LANEAustinTX78711··—-
CLMCLM-4315432026-01-21T10:19:52ZPatricia—ParkerJul 15, 1956—•••-••-3439·760-747-5927patricia.parker47@outlook.com·2919 Lake View RdTucsonAZ85743GRP-3659UNKNOWN
CLMCLM-4313982026-03-11T14:59:33ZJacqueline—Simmons1940-12-23·UHC-56685-38•••-••-8870—N/AN/Anull———N/A
CLMCLM-4011722026-05-18T19:37:00ZCARL—COOLE1943-08-19·UHC-70721-52nullN/A——null··N/AUNKNOWNGRP-9633null
CLMCLM-4288052026-05-15T22:18:04ZDouglas—Stewart3/7/1987UHC-98736-64-7734107976-4478 CEDAR LANE··DallasTexas75222GRP-6523MEDICARE-ADV-B
CLMCLM-4235792026-09-08T00:16:47Zpaul—lawson1960-71-26UHC-77158-43—833-807-7978—3409 Elm StTempeAZ85233UNKNOWN—
CLMCLM-4151572026-06-22T09:54:29ZMartha—Green9/8/1962-null(600) 675-1907··NULL6176 Harbor BoulevardDallasTX75258·GRP-8116-
CLM CLM-4176002026-09-29T16:59:30Z·Racchel—Maldonado1969-09-28··UNKNOWNnullUNKNOWNN/A9202 Main StAustinTX78720GRP-9208MEDICARE-ADV-B
CLMCLM-4208122026-03-17T18:34:59ZLauurenHJohnson23-02-1955UHC9736663•••-••-1389·····-8349 Harbor Blvd··MinneapolisMN55440GRP-2167··OPTIONS-PPO
CLMCLM-4091902026-05-29T22:04:40ZJerry—Rojas09/22/95UHC8577260—-—4528 MAPLE AVENUEMesaAZ··85293GRP-2774MEDICARE-ADV-B
CLMCLM-4325592026-05-08T03:22:58ZAMANDA··—BENNETT2004-01-08UHC-35446-77··•••-••-8286-NULL··6065 Union StCOLUMBUSOhio43251-1801GRP-7664—
CLMCLM-4225092026-09-05T23:05:43ZMarquez, Robert··——1950-08-05UHC-09983-43•••-••-8017+1 450 993 3499null590 Palm DrScottsdale··AZ85200··GRP-2960-
CLMCLM-4185242026-10-07T02:52:28ZWalter··THoffman1965-04-17UHC-83616-67—·(376) 333-7955—1445 Meadow LnTempe··AZ85232NULLNAVIGATE-HMO
CLMCLM-4181062026-02-26T22:20:19Z·melissa—padilla——N/A12992239486————UNKNOWNGRP-0217-
CLMCLM-4273852026-08-04T09:46:45ZDebbie—·Perry19410928UHC-90537-38—+1 481 608 5049—1929 Oak St·FresnoCA93777-5295·GRP-2049MEDICARE-ADV-A
CLMCLM-4231312026-04-22T17:53:45Zcharles—nelson·3/1/1939UHC-63194-22—918-505-7537—1880 Pine Dr Apt 4EDEN PRAIRIEMN55394····MEDICARE-ADV-B
CLMCLM-416943 2026-01-24T18:55:45ZDorothy—Padilla07-02-1976—null··—-3193 Lake View RdChandlerAZ85297··select-epo
CLMCLM-4300762026-09-22T06:46:25Z Betty—Anderson1953-07-18UHC-04639-90NULL3706853205N/A1802 Palm DriveCHARLOTTENC28285GRP-2532MEDICARE-ADV-B
CLMCLM-4182612026-07-11T03:53:44ZJonahtanHFerguson1981-06-09—•••-••-2516(430) 279-8328—4690 Forest AvenueGILBERT··Arizona85276GRP-6438NULL
CLMCLM-4231122026-06-30T16:53:59ZGloria—Dominguez··1971-02-23··-NULL14503073675·gloria.dominguez@hotmail.com-nullN/AN/A—MEDICARE-ADV-B
CLMCLM-414290 2026-08-27T11:28:12ZColeman, Valentina··B.··1984-04-09UHC-82461-63•••-••-14156408611472null·5143 Market StreetNASHVILLETennessee37207-8119GRP-2168-
CLMCLM-4243902026-09-06T03:59:22ZJACQUELINE—LEWIS1979-05-16UNKNOWN—779-900-6498N/A9882 Sage CtSan DiegoCA92163GRP-2675-··
CLMCLM-4320672026-08-17T06:25:11Zshirley—boyd1972-08-14··UHC-95505-65•••-••-6664+1 613 410 2978NULLN/ANULL——GRP-7640—
CLM CLM-4261042026-04-22T23:38:49ZJulia—George1938-04-01UHC-18914-10NULLNULL····6168 Market StreetTAMPAFL33673GRP-3730—
CLMCLM-4005242026-01-27T07:23:50ZAMANDA—RICE1982-08-02UHC-69443-51—655-535-7007UNKNOWN6243 Lake View RdMinneapolisMN55444GRP-1815CHOICE-PLUS-PPO
CLMCLM-4086542026-03-31T02:49:12ZDonald—Chavez03/06/1993UHC-23736-75NULL19114512278—·4398 Sage CtEden PrairieMN55382GRP-3888CHOICE-PLUS-PPO
CLMCLM-4301072026-06-28T18:48:17ZCarlosZ.Boyd1983-03-26—•••-••-5750-—7880 Apache BoulevardDenverCO80226·GRP-5949—
CLMCLM-4161032026-05-27T18:32:15ZEdward—Arnold12/22/1957-null(515) 418-2111··UNKNOWN··N/A-UNKNOWN—·MEDICARE-ADV-B
CLMCLM-4005292026-10-08T17:46:06ZHill, Dorothy——·1999-08-03UHC-52013-53•••-••-0702·270.768.8647—7095 ELM STREETORLANDO·FL32863-9975GRP-0711CHOICE-PLUS-PPO
CLMCLM-4167182026-08-18T12:25:07Z·Jerry—MontgomeryJan 26, 1973UHC-61947-38-(696) 984-7323-————GRP-4292NAVIGATE-HMO
CLMCLM-4059122026-06-11T16:33:35ZBecky—Robinson9/9/1980UHC-71751-18··•••-••-1503(242) 241-8592-3054 BroadwayDenverCO80206GRP-5079NAVIGATE-HMO
CLMCLM-4032072026-08-10T03:10:32ZBETTY—ALLEN12-09-1956—NULL965.963.5693—8596 BROADWAYTEMPEAZ85248-2596GRP-1271SELECT-EPO
CLM CLM-4009282026-03-15T09:18:14ZPriya—Chen1999-03-03UHC-87411-86•••-••-4709—-6678 RIDGE ROADNashvilleTN37262·GRP-5959MEDICARE-ADV-A
32,829 rows, page 89 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.761Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty