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-4182412026-03-22T16:51:47ZVINCENT—SILVA1964-12-23UHC-21678-20——null1724 Valley View Drive #352MiamiFL33182GRP-7723MEDICARE-ADV-A
CLMCLM-4070012026-07-24T15:27:15ZSAMANTHAJ.ROMERO12/10/1995—•••-••-6372+1 427 243 8422UNKNOWN3469 Mountain View DrScottsdaleAZ85292GRP-5296—
CLMCLM-4212082026-05-15T09:25:55ZJeremy—Sullivan1981-10-18UHC-15896-37UNKNOWN(523) 917-6767-5808 Camelback RoadColumbusOH43237GRP-3701N/A
CLMCLM-4014932026-09-10T07:31:54ZMorris, Bruce——1948-12-27N/Anull(216) 865-4803bruce.morris4@outlook.com1843 Market StSan Antonio·TX78261GRP-5184—
CLMCLM-4258002026-06-11T21:28:39ZScott—Ward2005-02-15nullnull·UNKNOWNnull6132 MESA DR #570SacramentoCA95877GRP-3172—
CLMCLM-4035112026-02-04T13:43:20Z·Ronald—Alvarado1971-70-17UHC-24064-83•••-••-2602nullUNKNOWN431 Lake View RdMESAAZ85294—CHOICE-PLUS-PPO
CLMCLM-4310842026-01-06T13:19:11ZGoerge—Jones2006-12-09·UHC-24975-70•••-••-5648NULLNULL··3287 LINCOLN WAY Apt 28ATLANTAGA30333GRP-6180··
CLMCLM-4305012026-09-23T14:18:34ZJOSE—HARRISDec 9, 1971N/A—(853) 855-9511UNKNOWN6732 UNION STFresnoCA93762-NULL
CLMCLM-4216172026-03-13T22:22:53ZVICTORIA—FIELDS08/20/43-——·UNKNOWN4522 MESA DRIVEMinneapolisMN55473nullSELECT-EPO
CLMCLM-4145362026-06-22T01:33:17ZSOFIAZANDERSON1984-01-21NULLN/A-NULL·1902 LINCOLN WAY·HOUSTONTX77037GRP-7319—
CLMCLM-4282582026-03-16T06:16:11ZJohn—Hernandez1992-02-23UHC-72048-32•••-••-5377-UNKNOWN3109 SAGE COURTJacksonville··FL32282GRP-0413MEDICARE-ADV-A
CLMCLM-4168472026-08-15T22:43:32ZDEBRA—ELLIOTT1978-03-13UHC-39687-17—445-229-2900——N/AN/A--NULL
CLMCLM-4241902026-04-07T08:20:28ZbryanA.welch1951-12-16UHC-90499-68—NULL—-NULLNULL·UNKNOWN-N/A
CLMCLM-4128682026-05-02T22:35:27ZJohnson, Nancy——1956-00-83UHC-08685-37N/A—UNKNOWN7906 BroadwayTUCSONAZ·85789—NULL
CLM CLM-402964 2026-06-19T09:41:39ZRyan··WBennett1983-12-04UNKNOWNnull910-742-6296N/A1282 RIDGE RD··Seattle··WA·98139N/ACORE-HMO
CLMCLM-4064762026-02-15T04:49:28ZHiroshi··Nunez1976-12-20uhc-91613-92———nullNULLN/A—GRP-3528N/A
CLMCLM-4146882026-06-25T16:21:03ZEUGENE—BAKERSep 16, 1971UHC-10971-56•••-••-1726——1833 Meadow Ln··MesaAZ85291—OPTIONS-PPO
CLMCLM-4141742026-07-16T00:04:12ZHenry—·Foster24-02-1990-•••-••-7663(291) 926-7600-4824 MOUNTAIN VIEW DRDallasTX75285GRP-8069null··
CLMCLM-4151612026-09-16T10:45:11ZSusan··—Nelson1962-09-22N/A··———2924 MOUNTAIN VIEW DRIVEMinneapolisMN55448GRP-6885··MEDICARE-ADV-A
CLMCLM-4007532026-02-16T08:02:52Zchristina—peters1943-10-27UNKNOWN—N/AN/A474 Canyon RoadMesaAZ85275-3245GRP-8499MEDICARE-ADV-A
CLMCLM-421352 2026-01-02T05:05:52ZClark, Elijah——1966-03-23UHC-01209-61•••-••-5760+1 291 699 8180··—3071 OAK STChandlerAZ·85295GRP-6039UNKNOWN
CLMCLM-4116932026-09-04T21:02:15ZSANTIAGOXTHOMPSONSep 8, 1966UHC-18101-93•••-••-5423NULL··N/A3178 CANYON RDEden PrairieMN·55339GRP-9062—
CLMCLM-4187302026-08-06T00:44:36ZEgene—Nunez01/28/69—•••-••-5559NULLUNKNOWN2385 Mesa DrSacramentoCA95807GRP-7684MEDICARE-ADV-A··
CLM CLM-4092162026-08-07T13:06:52ZDay, Kyyle——18-05-1971UHC-43152-51•••-••-202913544884725N/A1724 JEFFERSON AVENUESan DiegoCA··92188UNKNOWNnull
CLMCLM-4184622026-04-05T16:50:43ZJustinXSchultz1985-08-09UHC-07089-67——·NULL1094 Union StSan DiegoCalifornia92105-CHOICE-PLUS-PPO
CLMCLM-4052522026-06-08T10:03:44ZDylan—Hill1963-01-21UHC-19089-37—12656423198—N/AN/A--NULLNULL
CLMCLM-4121132026-06-01T07:14:49ZChristopher—Jenkins1982-09-18UHC-46541-04•••-••-4718N/ANULL9681 Forest AvenueDallasTX—GRP-0743NAVIGATE-HMO
CLMCLM-4303712026-04-09T20:35:49ZLinda—Burton19560125uhc-39412-86•••-••-4233--6114 Apache Boulevard··AUSTINTexas78720GRP-1118OPTIONS-PPO
CLMCLM-4196072026-05-18T14:37:34Z Isabella—Wood··1988-12-17UHC-09077-92—N/A·N/A7613 Willow Ct Apt 5Denverco80218——
CLMCLM-4025192026-01-23T21:46:23ZEthanK.Estrada1966-04-28UHC-68529-89UNKNOWN——5007 APACHE BLVDChandlerAZ85229NULL—
CLMCLM-4042522026-04-04T15:29:00ZWilliamUSimpson1979-05-20UHC-38745-57··•••-••-41009326871675NULL4262 MOUNTAIN VIEW DRMiamiFL33116GRP-1020—
CLMCLM-4120942026-10-11T18:54:51ZNoahO.··ColemannullUHC-80842-13NULLNULL—3319 MAPLE AVENUECharlotteNC28269-··CORE-HMO
CLMCLM-4131002026-02-15T12:31:04ZSofia—Lewis1938-03-27UHC-91831-67•••-••-5611(361) 586-1706-3032 Valley View DrMesaAZ85261GRP-5963CORE-HMO
CLMCLM-4320582026-02-10T19:26:32ZGonzalez, RandyM—·1951-05-02UNKNOWN—+1 746 647 8219—7743 Meadow Ln Apt 22DenverCO80213UNKNOWN····
CLMCLM-4234202026-01-18T08:13:20ZJensen, JoyceF—9/21/1953-··——NULL——NULLN/AN/A-
CLMCLM-4154402026-03-22T03:51:18ZOwens, Jackie——23-08-1994UHC-62366-83•••-••-9364UNKNOWN-2104 Mountain View Drive·GilbertArizona85242··UNKNOWNNAVIGATE-HMO
CLMCLM-4288382026-01-14T21:03:57ZSandraB.Stewart1955-07-25—N/A——7198 Harbor BoulevardSEATTLEWA98140—NAVIGATE-HMO
CLMCLM-4094182026-08-04T06:08:38ZAnan—Hicks2000-07-28UHC-76951-41——·N/A4474 Valley View Drive Apt 24MinneapolisMN55404GRP-8812N/A··
CLMCLM-4284972026-02-25T03:51:10Z·WALTER—KNIGHT7/25/2002null——-··7563 Ocean AveFresnoCA93785··——
CLMCLM-4300152026-06-08T12:27:47ZTIMOTHY—GILBERT1986-03-10nullnull3695012841-7975 Camelback RoadNashvilleTN37228-8857GRP-1079null
CLMCLM-4084012026-07-27T07:57:50ZAlbert—Nunez1981-12-24UHC-51651-67—UNKNOWN····1681 Union St #641JACKSONVILLEFL32228GRP-0755UNKNOWN
CLMCLM-4130652026-04-04T15:51:53ZJackZ·Watson1988-08-25——278-987-2748UNKNOWN-NULLN/A—GRP-2900-
CLMCLM-4068372026-08-16T15:59:03ZMARILYN—·PETERS2008-04-10UHC-57980-91—(770) 414-9392—9318 Elm StPlanoTX75046GRP-0829SELECT-EPO
CLMCLM-4074662026-08-07T23:00:41Zbarbara—bell2/17/1995—•••-••-7503983-898-5372—6067 Apache Blvd··SAN DIEGOCA92101GRP-3905MEDICARE-ADV-B
CLMCLM-4274922026-08-02T23:26:57ZKyle—Salazar1941-01-26UHC-29672-58•••-••-7234UNKNOWN—4948 OCEAN AVENUETucsonAZ85726GRP-2626MEDICARE-ADV-A
CLMCLM-4171512026-06-11T08:50:35ZMARIAT··HANSEN1977-08-11UHC-09268-60null447-764-5750UNKNOWN7203 CENTRAL AVENUELos Angelesca·-—SELECT-EPO
CLMCLM-4191482026-03-28T18:28:45ZMorrs, Laura——1955-05-12UHC1812211UNKNOWN—UNKNOWN6637 WASHINGTON STSan Antonio··TX78233GRP-3359SELECT-EPO
CLMCLM-4181032026-04-21T08:25:27ZRYAN—ROSE1962-12-20UHC-27369-05—N/A-6663 Highland AveHoustonTX77093GRP-3890MEDICARE-ADV-A
CLMCLM-4290642026-06-06T00:22:44ZMARGARET—STEWARTApr 20, 1978—UNKNOWNNULLUNKNOWNnull·nullNULL-GRP-9064MEDICARE-ADV-A
CLMCLM-4180022026-07-11T09:59:56ZJordan—Perry1955-11-17UHC-77617-54•••-••-5501620-952-9652null6145 Sunset BlvdPhoenixAZ85072GRP-9601MEDICARE-ADV-B
32,829 rows, page 197 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.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty