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-4077862026-10-11T22:05:08ZScott—CooperFeb 8, 2008UHC5770565NULLNULL—9015 Church StreetGLENDALEAZ85352GRP-6753CHOICE-PLUS-PPO
CLMCLM-4084822026-03-05T15:26:39ZRICHARD—OLIVER1966-04-09UHC-53963-27UNKNOWN(303) 858-6680—4100 Valley View DriveCharlotteNC28285GRP-5317MEDICARE-ADV-B
CLMCLM-4222112026-04-19T09:56:10ZVINCENT——Aug 6, 1986—null601-975-9013··6852 UNION ST··PhoenixAZ85097-—
CLMCLM-4187992026-09-15T21:26:46Zmadison—vazquez1994-10-09UHC-54474-87•••-••-6767null·N/A9099 Mesa DriveMINNEAPOLISMN55480GRP-7374null
CLMCLM-4276152026-09-04T04:21:34Zmatthew—walker1971-05-21N/A-—-8815 Harbor BoulevardMINNEAPOLIS·MN55477GRP-0822—
CLMCLM-4069162026-03-22T22:51:35Zgerald—davis7/13/1959UHC-68736-64·null——7154 PINE DRTempeAZ85215GRP-6670NULL
CLMCLM-4216562026-08-11T18:14:56ZJIM—MALDONADO1954-08-19UHC-48927-65•••-••-9415N/AJAMES.MALDONADO37@ICLOUD.COM9382 Mountain View DrMesaAZ85272GRP-9467MEDICARE-ADV-B
CLMCLM-4113222026-10-09T08:33:08ZMoore, SeanK—1955-11-21·UHC-28439-67•••-••-4922NULLsean.moore@hotmail.com———-UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4218632026-06-05T14:12:39ZWalterHBrooks09-10-1951NULL—7557640-N/ANULL·null·-null—
CLMCLM-428309 2026-04-27T06:10:14ZKayla—Rose1996-12-24UHC-21029-04-—UNKNOWN2286 Lake View RdNashville·TN37272—NAVIGATE-HMO
CLMCLM-4036262026-03-14T05:55:49ZEDWARD—PORTER1999-07-28UHC-26683-20•••-••-4890—edward.porter69@gmail.com··226 BroadwayHoustonTX77018-0145GRP-6337—
CLMCLM-4271002026-04-05T22:41:49ZTimothy·····Wang1948-06-10-•••-••-8882642-887-7182—9121 Willow CtHoustonTX77031··GRP-2796MEDICARE-ADV-B
CLMCLM-4018302026-06-02T15:12:05ZTeresa—Chavez5/9/1953UHC-36535-42•••-••-7112—··1648 Valley View DrEden Prairie·mn55343GRP-0551MEDICARE-ADV-A
CLMCLM-4118832026-08-07T16:20:14ZVargas—·Donald28-12-1975UHC-89979-69•••-••-64779384110399UNKNOWN—-N/A—UNKNOWN·SELECT-EPO
CLMCLM-4170832026-04-27T12:25:37ZTHERESA—SULLIVAN1977-09-18null•••-••-040413569640579THERESA.SULLIVAN6@OUTLOOK.COM—NULLUNKNOWNNULLUNKNOWN—
CLMCLM-4224662026-02-04T17:27:35ZBrown, Joshua——01/13/1941UHC-44263-86-8452489238joshua.brown@yahoo.com··NULLNULLNULLNULLOPTIONS-PPO··
CLMCLM-4267862026-04-08T17:01:59ZAngela—Ellis1949-03-02—UNKNOWN—angela.ellis@outlook.com2733 Baseline RoadTampaFL33690null—
CLMCLM-4072632026-03-21T00:21:51ZThomas—Tran1978-11-08—•••-••-2132208.596.8364NULL5079 Camelback RoadPlanoTX75081—SELECT-EPO
CLMCLM-4223382026-04-24T03:16:36ZarthurZbowman1951-12-08UHC-96737-18——NULL—NULL—nullGRP-6507—
CLMCLM-413326 2026-09-21T01:58:44ZLisa—Chapman13-10-1947nullN/AUNKNOWNLISA.CHAPMAN@GMAIL.COM9436 Ocean AveDallasTX75214—CHOICE-PLUS-PPO
CLMCLM-4274782026-04-27T22:44:21Z Juia—Walsh1940-03-02UHC-38236-77N/AN/ANULL4421 PARK PLFresnoCA··93798—null
CLMCLM-4261822026-05-18T23:07:52Zkevn··L.tckerJun 9, 1951··-NULLkevin.tucker@proton.me1128 Harbor BoulevardColumbusOhio43242UNKNOWNCORE-HMO
CLMCLM-4034322026-02-17T10:43:26Z RachelWMaldonaod1940-03-05UHC-51088-81•••-••-1858NULLnull1474 RIDGE ROADSACRAMENTOCA-GRP-5554-
CLMCLM-4308292026-07-20T19:35:52Z Noah····Black1994-02-07UHC-57024-95•••-••-4003·18732861223N/A1296 Willow CourtChandlerAZ85228NULLNAVIGATE-HMO
CLM CLM-4229092026-03-23T17:53:35ZBRADLEY—·RODRIGUEZ1956-08-20UHC-54839-19—UNKNOWN-··—UNKNOWNNULL·UNKNOWNNULLCHOICE-PLUS-PPO
CLMCLM-4316832026-03-13T04:34:59ZFrances—Yang14-08-1969UHC-53107-97NULL--—NULLnull—GRP-8629null
CLMCLM-4205312026-10-02T22:48:13ZLuis—Patterson1974-11-01NULLnullN/A——····nullNULLGRP-3399SELECT-EPO
CLMCLM-4321262026-05-18T00:09:39ZRaymond—Richardson··01/13/87-•••-••-7664UNKNOWN-5745 PINE DRGilbertAZ85231GRP-2848—
CLMCLM-4258622026-09-20T07:22:56Znatalie—reid10/19/1987UHC-17980-94—(870) 811-1811UNKNOWNnull—UNKNOWN—GRP-2145—
CLMCLM-4274442026-08-13T16:55:22ZBOBBYF.SANDERS1990-04-10UHC-87099-72•••-••-7417—-3447 LINCOLN WAYOrlandoFL32853GRP-0891SELECT-EPO
CLMCLM-4199392026-01-26T00:54:39ZDiaz, Mateo··—1952-06-25UHC-92907-25—-N/A2968 Apache BlvdHoustonTXUNKNOWN·NULL—
CLMCLM-4206812026-06-07T20:19:06ZBilly—Ramirez04/15/1964UHC-43295-81•••-••-6323NULL—773 Union StCharlotteNC28213·GRP-7635CORE-HMO
CLMCLM-4239722026-03-22T05:28:47ZIsabella—Edwards09/23/1948UNKNOWNN/A—-2003 Washington StTucsonAZ85704-2959nullOPTIONS-PPO
CLMCLM-4302102026-02-17T14:11:55ZALAN—GILBERT1965-01-14null··—N/Anull7071 Union StreetCOLUMBUS··OH43298··GRP-0285·CHOICE-PLUS-PPO
CLMCLM-4162352026-08-10T20:29:36Z gloria—harper19430601UHC-02195-39null—·N/A5253 RIVER RDPlanoTX75089GRP-7609SELECT-EPO
CLMCLM-4025622026-03-24T21:06:16ZBlack, Melissa——1988-07-05N/A•••-••-8065(882) 943-3229—2435 Meadow Ln Apt 16Eden PrairieMN55353—-
CLMCLM-4062642026-07-13T18:46:22ZBryan—Valez1964-07-24UNKNOWNN/A··——5054 Lake View Road·MesaAZ85254N/ACHOICE-PLUS-PPO
CLMCLM-4282952026-08-30T23:44:02ZANA····OBRIEN1941-06-20··•••-••-53213205222007null1628 PARK PLACEScottsdaleAZ85277GRP-5675SELECT-EPO
CLMCLM-4116542026-02-22T02:25:56Z———1980-08-17UHC-69832-38-——2735 BAYSHORE DRIVEMesaAZ85279—CORE-HMO
CLMCLM-4200402026-03-31T03:46:00ZKayla—Cole1978-01-06UHC9652384--kayla.cole@icloud.com1075 Sunset BlvdSan AntonioTexas78248GRP-8278CORE-HMO
CLMCLM-4290822026-10-10T16:11:01Zlawrence—andrews09/22/72-N/A····null5488 Spring StEden PrairieMN55320··—
CLMCLM-4310822026-05-29T21:28:51ZOrtega—Bryan1959-02-07UHC6384887N/A—·NULL6900 Union StSan AntonioTX··78226GRP-3648OPTIONS-PPO
CLMCLM-405688 2026-07-23T09:33:35ZEugene—ContrerasAug 5, 1987UHC-38123-34··UNKNOWNUNKNOWN·N/A2194 Valley View DrGilbertAZ85222nullMEDICARE-ADV-B
CLMCLM-4275852026-03-23T00:13:03ZWilliam—Mitchell1996-10-02UHC-36292-35UNKNOWN··—8631 Ridge Rd··PhoenixAZ·NULLGRP-8053—
CLMCLM-423108 2026-05-09T22:23:07ZRAYMOND—COLLINS1971-03-26N/ANULL+1 353 490 1244—6254 Forest AvenueSeattleWA98140GRP-7630MEDICARE-ADV-A
CLMCLM-4040112026-01-27T16:57:09ZMEI—HOFFMAN1993-10-01UHC-87074-86N/A4266159236···-3347 River RdMiamiFL33193GRP-1695-
CLMCLM-4055302026-07-02T23:27:59ZDenise—Dunn1950-45-11UNKNOWN··(379) 719-7048··denise.dunn@gmail.com5263 Sunset BlvdTempeAZ85239GRP-4923CHOICE-PLUS-PPO
CLMCLM-4326942026-06-22T10:31:24ZMelissa—Perez8/4/1938UHC-17175-25•••-••-7149N/AUNKNOWN--UNKNOWNnull-NAVIGATE-HMO
CLMCLM-4057652026-06-22T05:37:35ZPETER··MENDOZA08/05/1959··UHC-10519-63NULLN/AUNKNOWN4978 Valley View DriveAUSTINTX78766NULLnull
CLMCLM-4146482026-03-19T03:19:25ZPHILIP—SHAW—UHC-81336-84—949-223-5526—5551 Willow Court Apt 26NashvilleTN37243GRP-6627—
32,829 rows, page 104 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:38.462Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty