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-4089772026-07-07T12:25:11ZBOBBY—GRAY1998-12-27nullnullUNKNOWN—UNKNOWNNULL—N/A··GRP-5988OPTIONS-PPO
CLMCLM-4237442026-09-24T20:56:21ZJORDN—RICE09/13/65—•••-••-3876892-682-8107null8671 Forest AveSacramentoCA95866GRP-2804SELECT-EPO
CLMCLM-4307462026-08-10T12:46:56ZMARIA—SCHMIDT04/28/57UHC-24260-23N/A·9489914605null8387 WILLOW COURTCOLUMBUSOH43200GRP-0549—
CLMCLM-4326242026-08-27T08:53:04ZAlice··Gibson1966-05-04N/ANULL——·4012 ELM STEden PrairieMN55318GRP-4000MEDICARE-ADV-A
CLMCLM-4282662026-10-12T12:44:22ZLaura··—Thommas1940-04-21UHC-63477-40•••-••-1006——2534 Central Avenue #407ColumbusOhio·43227GRP-1130NULL
CLMCLM-4307052026-03-08T10:09:43ZAhmedACooper1942-03-08UHC9193631——N/A8482 VALLEY VIEW DRLos AngelesCA90028··—SELECT-EPO
CLMCLM-4136962026-05-09T16:45:00ZStephanie—Castillo1999-07-09UHC-57276-27•••-••-6825NULL··6638 GRAND AVENUEHOUSTONTX77035GRP-3595select-epo
CLMCLM-4279882026-07-15T02:46:54ZSharon—Gilbert2003-05-14N/A•••-••-6542·6864851713—nullUNKNOWN—UNKNOWNGRP-5610—
CLMCLM-4087972026-06-29T11:56:19ZEstrada, John··—1998-09-14—•••-••-8666UNKNOWNnull—N/A··N/ANULLGRP-8836UNKNOWN
CLMCLM-4079662026-01-31T13:25:51ZRyan—Howall1982-04-25UHC-91148-66•••-••-4068(672) 548-0855-4377 FOREST AVEMiamiFlorida33176—CHOICE-PLUS-PPO
CLMCLM-4188502026-08-18T18:01:40Z Dorothy—Garrett1941-08-11UHC-53784-33—·NULL—6322 Ridge RdScottsdaleAZ85267GRP-4038OPTIONS-PPO
CLMCLM-4123552026-10-08T22:51:44Zdeborah—gilbertMay 12, 1966UHC-22494-09—N/A—5353 Church St #186MinneapolisMN55412nullNULL
CLMCLM-4145332026-03-12T17:23:16ZPATRICIA—WANG8/14/1950-—9345370419—N/A····-··-—
CLMCLM-4132022026-05-02T12:31:37ZJACQUELINE····LITTLE·12/24/1987UHC-07892-65-UNKNOWNNULL8051 Camelback RoadEden PrairieMN55303GRP-1164null
CLMCLM-4226092026-04-12T00:44:23ZMason, Mateo—··19801210UHC2522724•••-••-5939·6164781290—8867 Forest AveMiamiFL33154GRP-4341—
CLMCLM-423349 2026-10-14T20:44:26ZGeraldTRuiz1989-02-10UHC-14467-45NULL234-648-1263gerald.ruiz97@aol.com8019 CANYON RDColumbusOH43251GRP-1659NAVIGATE-HMO
CLMCLM-4036822026-04-26T09:08:49ZseanUwatkins6/1/2006UHC-29684-80•••-••-21672899082366——-———NULL
CLM CLM-4107112026-05-06T01:55:31Z evellyn—williams2008-09-27UHC-96663-83NULL(360) 435-3854null8149 BAYSHORE DRTempeAZ85270GRP-2594—
CLMCLM-4240942026-06-23T10:09:36ZNICOLE··—GONZALEZ04/24/1959UHC-37073-66··•••-••-9025——1921 Union StreetLas VegasNV89106-3339··GRP-5866··
CLMCLM-4134702026-05-04T04:50:44ZAnan—Carr11/13/1972N/A•••-••-1836451-318-7275-7558 CENTRAL AVENUEPhoenixAZ85025GRP-8974—
CLMCLM-4157872026-05-13T14:04:08ZGriffin, RandyG—1940-09-26UHC-66717-41•••-••-8111null—3473 PINE DRIVESeattleWA98129UNKNOWNnull
CLMCLM-4029672026-03-14T03:25:33ZJohn—Young28-02-1955·UHC-87848-29•••-••-59816735201642··—4204 Ridge Rd·COLUMBUSOH43204GRP-6165—
CLMCLM-4008532026-01-07T09:43:01Z·Nicholas—Colemna09/10/45·UHC-80494-31UNKNOWNN/AN/A441 Washington StCHANDLERArizona85294NULLMEDICARE-ADV-B
CLMCLM-4054122026-01-11T05:37:50ZHannahGGarrett1993-01-09UHC3217642•••-••-80876057650156—478 SUNSET BOULEVARDMINNEAPOLISMNNULLUNKNOWNnavigate-hmo
CLMCLM-4157912026-01-19T23:16:28ZMichelle—SchultzMay 14, 1971UHC-74086-57•••-••-6608—NULL4881 Lincoln WaySCOTTSDALEAZ85245-1212NULLNULL
CLMCLM-4285882026-09-02T05:19:14ZANA····CARR1981-08-17NULL-(589) 837-3919N/A3689 Pine DriveLos AngelesCA90074NULLN/A
CLMCLM-4183402026-01-27T04:06:26ZDoulgas—Gomez1989-08-20UHC-25187-47•••-••-4667689-979-6529—1670 OCEAN AVESan AntonioTX78242UNKNOWNnull
CLMCLM-423122 2026-05-26T04:22:22ZKelly—Jones04-12-2006UHC-56875-75•••-••-9907281-617-9399—5026 Meadow LnMesaAZ85207GRP-0607··NULL
CLMCLM-4123812026-06-05T09:14:50Zdonald—willis1976-01-09—N/A—UNKNOWN···6554 Lake View RoadMesaAZ85222—SELECT-EPO
CLMCLM-4237812026-07-08T02:02:46Z Christopher·H.Reynolds1963-02-17null•••-••-6553——1652 MAPLE AVEORLANDOFL32861NULL—
CLMCLM-411041 2026-02-27T06:10:41ZCharlotte··IPayne01/13/05-—NULL—2382 GRAND AVEGlendaleArizona85354·NULLN/A··
CLMCLM-4031452026-08-28T11:53:15ZJoshua—FergusonAug 6, 1965—•••-••-0110865-713-1489N/A3919 Ocean AvenueLOS ANGELESCA90059-CORE-HMO
CLMCLM-4140172026-08-15T22:51:41ZMariana—Santiaago2008-11-22UHC-36282-56•••-••-8803NULLMARIANA.SANTIAGO@PROTON.ME4386 Jefferson AvenueTucsonaz85737··NULLUNKNOWN
CLMCLM-4186932026-07-29T21:44:41ZMarthaNWarren1954-11-19UHC-61710-65UNKNOWN7967153651—3383 LAKE VIEW RDScottsdaleAZ85239GRP-0565SELECT-EPO
CLMCLM-4146602026-06-14T19:13:31ZSANDRA··TAYLOR2006-11-26UHC-73410-51UNKNOWN—NULL····UNKNOWNnullNULL··—·-
CLMCLM-4296772026-04-15T13:49:27ZMADISON·U.FRANKLIN01/16/75··UHC-89354-81•••-••-07852728366963—6733 Oak StreetTUCSONAZ85711GRP-5925-
CLMCLM-4006222026-06-30T10:06:09ZDIANE—HART2008-02-04UHC-90073-96•••-••-9341—UNKNOWN7848 RIDGE ROADMiamiFL33159GRP-0700-
CLMCLM-4146992026-03-24T05:07:41ZVINCENTN.AUSTIN1943-10-28-•••-••-9805NULLnullNULLnull—NULL-CHOICE-PLUS-PPO··
CLMCLM-4177392026-03-10T04:05:53ZJACOB—FERGUSONJan 7, 1950··UHC-83068-74nullNULL—null-N/A—GRP-6088CHOICE-PLUS-PPO
CLMCLM-4036362026-03-24T19:27:11ZAMYQ.CAARLSON1948-11-09UHC6326292•••-••-5181927.476.4991··-4691 RIVER RD·FresnoCA93780GRP-9631NAVIGATE-HMO
CLMCLM-4023992026-10-17T16:20:13ZBETH—·JIMENEZ1945-05-25UHC-65211-83··—UNKNOWN··N/A8362 HILLCREST ROAD #155ColumbusOHN/A—·CORE-HMO
CLMCLM-4112782026-07-31T12:37:54ZFrank—Lawrence·1979-09-09UHC-94025-69null-frank.lawrence15@icloud.com8715 Grand AveATLANTAGA·30364-2410GRP-5542N/A
CLMCLM-4062722026-07-11T10:14:48ZRoyH.Boyd··2008-01-18··UHC8622201•••-••-1088—N/A2678 Camelback RoadCharlotteNC28233GRP-0834CORE-HMO
CLMCLM-4265582026-07-05T19:13:05ZRuthBSpencer··12-07-2002UHC-50944-63—UNKNOWNRUTH.SPENCER61@GMAIL.COM1966 Main StTempe··AZ85241GRP-0911OPTIONS-PPO
CLM CLM-4277492026-04-06T17:13:15ZJudith—Brown1948-05-01UHC-78195-69N/AUNKNOWN—4374 Pine DrFresnoCA93704··GRP-3146null
CLMCLM-4023412026-04-13T15:01:02ZSimmons—Aisha·Apr 21, 1944··•••-••-8175-—774 Lincoln WayPhoenixAZ85014GRP-9597··
CLMCLM-4207982026-05-04T02:02:29ZJack······Kelley··5/5/1960—•••-••-2973—JACK.KELLEY@HOTMAIL.COM6336 SPRING STREETAustinTX78736GRP-5499SELECT-EPO
CLMCLM-4292142026-01-29T04:57:08Zchristine—vega1995-04-02UHC-51289-46•••-••-12149273422—3340 Willow CtAtlantaGA30342GRP-8142··
CLMCLM-4290512026-01-24T10:13:08Z·William—Hall1975-07-16—N/AN/A··-1847 Pine DriveSCOTTSDALEAZ85272-0766GRP-1968—
CLM CLM-4299422026-01-29T07:37:36ZPatrick—Sanders·06-09-2005UHC-58486-46N/A358-354-0598patrick.sanders83@outlook.com4835 APACHE BOULEVARDSan Diego··California92193·-null
32,829 rows, page 204 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:43.424Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty