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-4118592026-08-06T22:22:40ZChristina—CarrollJul 10, 1990UHC-18251-33—+1 757 641 1917null4892 Indian School RoadScottsdaleAZ85284GRP-8525SELECT-EPO
CLMCLM-4065532026-05-02T16:42:21Zevelyn—green05/03/06UHC-78882-43•••-••-7779nullN/A-—N/AUNKNOWNGRP-4795NULL
CLMCLM-4021912026-03-22T07:38:38ZSTEPHENI··BURKE02/12/1948·UHC-69911-23—null—1851 Highland AvenueColumbus··OH43267GRP-7352SELECT-EPO
CLMCLM-4048042026-09-08T05:42:11ZKYLE—ROMERO1943-05-03——6286932860··—7259 LINCOLN WAYMinneapolisMN55484UNKNOWN·CHOICE-PLUS-PPO
CLMCLM-416010 2026-09-14T03:43:13ZAlexander—DanielsFeb 9, 2003UHC-29855-22null··488-413-7338NULL3995 Bayshore DrHoustonTX77000—MEDICARE-ADV-B
CLMCLM-4270302026-08-31T11:42:10ZChristopher—Perkins1990-02-26—•••-••-99055963222763—1551 SAGE CTAustinTX78752GRP-6198OPTIONS-PPO
CLMCLM-4017002026-02-28T05:11:51ZMateoKWarren19720218UHC-09427-02N/A6628564848—N/AUNKNOWN-—GRP-1288-
CLMCLM-4232472026-01-02T04:22:38ZSOPHIA—LAWRENCE1989-05-04UHC-54923-39—+1 254 428 0562NULL2752 Valley View DrCharlotte··NC28215··GRP-5553NULL
CLMCLM-4165792026-07-17T11:52:18Z·Deborah—Price1940-11-15UHC-27304-07———6605 HIGHLAND AVENUEPhoenixAZ85095GRP-8487·MEDICARE-ADV-B
CLM CLM-4156722026-06-27T13:12:52Zaaron—vazquez2003-11-22UHC-00207-30··•••-••-36668806165840N/A5948 APACHE BOULEVARDGilbertAZ85252GRP-7959··SELECT-EPO
CLMCLM-4149442026-01-20T17:37:25ZElizabeth—Stewart1943-05-13UHC9628354•••-••-1148+1 725 572 0680N/A4434 Elm St··San AntonioTX78229··—
CLMCLM-4152842026-03-25T05:10:31ZJUSTIN—PERKINS24-04-1960-•••-••-9026447-606-5628-4260 MARKET STREETFresno·CA93714··GRP-0350-
CLMCLM-4299532026-07-05T19:08:46Z·Terry—Cunninngham03/21/07UHC-10855-14—(292) 600-3396——NULLN/AnullUNKNOWNCORE-HMO
CLMCLM-4156272026-03-19T05:57:54Z BradleyXVazquez1989-07-07·UHC-39551-61—·13979479721—·1527 Cedar LnPLANOTX75044GRP-5644UNKNOWN
CLMCLM-4305982026-01-24T17:17:48ZNicholasFLee·19820225UHC-39448-14UNKNOWN—null—nullnullNULLnullNULL
CLMCLM-4240352026-02-08T19:27:30ZJohn····Moreno04/20/73UHC-62742-88•••-••-8941-—6704 Apache BoulevardSacramentoCalifornia95860GRP-2495MEDICARE-ADV-B
CLM CLM-4192202026-04-07T09:09:56ZAlice—Grdon1961-02-17·NULL•••-••-9091+1 220 672 1411UNKNOWN9363 LINCOLN WAYSeattleWA98122-OPTIONS-PPO
CLMCLM-4169762026-09-16T08:09:51ZContreras—Mark06/05/94nullUNKNOWNnullmark.contreras@hotmail.com7677 Indian School Road··SacramentoCA95831··nullCORE-HMO
CLMCLM-4056532026-05-03T23:26:02Z Raymond—Fowler··1957-06-20UHC-59398-88NULL3563054771UNKNOWN2428 Main StTampaFL33652GRP-0106-
CLMCLM-4052612026-03-01T06:30:04ZPamela—Griffin1942-08-10UHC-70075-68··4846451808null9620 Cedar LnFRESNOCA93700GRP-1407CHOICE-PLUS-PPO
CLMCLM-4066032026-06-21T12:31:10ZGARZA—RAAYMOND1963-07-27UHC-65800-71•••-••-8804nullN/A7988 Bayshore DriveJacksonvilleFL··32213GRP-5600-
CLMCLM-4090322026-03-23T18:08:27ZCatherine—Gordon1995-11-23UHC-95390-20•••-••-5693—catherine.gordon88@hotmail.com8861 RIVER RDAustinTexas78780N/ANAVIGATE-HMO
CLMCLM-4033742026-05-12T20:07:48ZHughes, Rachel——1969-06-06UHC-06997-78•••-••-0066NULL—3782 MEADOW LNGlendaleAZ85328-2671null··
CLMCLM-4102012026-05-17T04:50:55ZDANIELLE—BELL1959-12-08UHC-71115-60——N/A7586 Spring StreetOrlandoFL·32807GRP-2091NAVIGATE-HMO
CLMCLM-4280922026-09-13T05:18:42Zraymond—coxSep 9, 1974UHC5816635•••-••-1172—-748 UNION ST··TucsonAZ85754UNKNOWN·MEDICARE-ADV-A
CLMCLM-4018292026-02-03T22:29:23Zteresa—chavez1953-05-09UNKNOWN•••-••-7112436.212.4413··N/A1648 Valley View DrEden PrairieMN55343GRP-0551—
CLMCLM-4085502026-01-27T18:58:48Z Kenneth—Pena4/9/2007UHC1998186··——kenneth.pena@hotmail.com8856 Main StMesaAZ85271-OPTIONS-PPO
CLM CLM-4028942026-08-25T15:04:19Z Taylor, Beverly——Mar 12, 1996UHC-10404-50•••-••-3450(484) 248-7245NULL8531 Canyon RoadMesaAZ85240N/A····
CLMCLM-4231262026-05-28T07:15:57ZARTHUR V—ANDERSON··1982-06-09UHC-92354-94•••-••-8477—arthur.anderson60@proton.meNULLNULL-NULLGRP-7485SELECT-EPO
CLMCLM-4166712026-08-07T18:36:21Zpamela—sanders1960-06-02UHC-11818-05··•••-••-0946-null—---GRP-2117OPTIONS-PPO
CLM CLM-418134 2026-03-23T19:08:19ZTeresa—·Parker1970-03-07—•••-••-1806·nullUNKNOWN4695 Ocean AvenueGilbertAZ85235GRP-4182CORE-HMO
CLMCLM-421962 2026-02-17T02:28:20ZPorter, Nicole——1940-05-27UHC-79932-95———-—nullnullGRP-4990··N/A
CLMCLM-4282242026-07-08T02:08:59Z Karen····Fisehr9187-06-18UHC-80767-69——karen.fisher76@aol.com3938 CAMELBACK RDAustinTX78730NULLCHOICE-PLUS-PPO
CLMCLM-4041022026-02-16T04:20:54ZDot—Grifffin2003-01-10N/A•••-••-2272N/Adorothy.griffin18@icloud.com1772 Pine DrSan DiegoCA92157··GRP-6939MEDICARE-ADV-A
CLMCLM-4001782026-03-24T10:49:31ZARJUN—LOPEZ··24-09-2001UHC-28616-71•••-••-7114N/A····NULLNULL--GRP-2579null
CLMCLM-4097882026-06-02T04:33:40ZCheryl··—Welch··1938-01-06UHC-07157-28•••-••-7997—-6366 HILLCREST ROADMiamiFL33154NULL—
CLMCLM-4228132026-06-23T00:50:50ZNATALIE—FERGUSON1942-05-16-NULLnull-8350 Hillcrest RoadTempe·AZ85206——
CLMCLM-4238482026-06-29T10:43:51ZBRADLEY—DANIELS1938-07-26UHC-73036-62———9430 Lincoln WayLOS ANGELES·CA90046GRP-4309··N/A
CLMCLM-4104912026-09-06T18:58:30ZNathan—Hall1939-08-26UHC-65209-99•••-••-8291·346-611-5388—7748 Bayshore DrAustinTX78735—-
CLMCLM-4195072026-05-23T19:55:19ZRussell—Carpenter1986-01-13UHC-91659-25—14858168874null·7836 Camelback RoadPLANOTX75004GRP-4148null
CLMCLM-402195 2026-03-28T10:23:50ZSue—Morris1958-03-10UHC-02849-78—UNKNOWN·NULL6814 Baseline RdJACKSONVILLEFlorida32291-UNKNOWN
CLMCLM-425445 2026-03-18T20:57:29ZDAVIDSFERGUSONJul 23, 1982——-N/A2980 ELM STREET··FresnoCA93725GRP-6055MEDICARE-ADV-A
CLMCLM-4106222026-08-31T06:27:36ZRUSSELL—STONE15-01-2000--319-755-5816UNKNOWN582 RIDGE ROAD Apt 37NASHVILLETN37248GRP-5002MEDICARE-ADV-B
CLMCLM-4068172026-04-30T05:56:48ZJennifer—Turner1959-12-20UHC-61460-36•••-••-79282824236202NULL9073 Harbor BoulevardAustinTX78742UNKNOWNUNKNOWN
CLMCLM-4272012026-08-28T19:28:29Zwilliam—hansen2/21/1974UHC-24086-77•••-••-7828--201 RIVER ROADJacksonville··FL32247-5593GRP-3766N/A
CLMCLM-4062422026-09-02T05:20:02ZCMAILA—JIMENEZOct 2, 1975UHC7112392•••-••-3795—··9655 Meadow Lane #315PlanoTX75028UNKNOWNN/A
CLMCLM-4086642026-07-22T15:35:05Zmary··—george1953-01-20UHC-99908-37•••-••-3771····NULL—NULLNULL—GRP-5498UNKNOWN
CLMCLM-4305842026-10-06T15:43:41ZTheresaU··Johnson2004-05-10UNKNOWN•••-••-3551N/A····8060 DESERT SKY BLVD #308CharlotteNC·28254GRP-8062CORE-HMO
CLMCLM-4176702026-05-26T12:44:28ZARJUN—GRAHAM1969-03-08—•••-••-5884795-731-6728-null——N/AGRP-3458MEDICARE-ADV-B
CLMCLM-4092962026-07-25T10:29:41ZHamilton, StephanieB.—UNKNOWNUHC4036322•••-••-3187-N/A6214 Baseline RoadColumbusOH43244GRP-5747·N/A
32,829 rows, page 169 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.600Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty