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
CLM CLM-406849 2026-04-22T00:38:00ZMason, Abigail··—07/27/03UHC-12071-84•••-••-9370262-742-3699·NULLUNKNOWN-———·N/A
CLMCLM-4018812026-04-23T21:14:32ZPatriciaGWood1957-06-24—•••-••-5230(238) 707-6524—2526 MEADOW LANEJacksonvilleFL32260NULL-
CLMCLM-4088922026-04-27T00:59:49ZCarr, Jean W——1969-06-27UHC-65157-91—·N/Anull901 Central AvenueLos AngelesCA90095GRP-3423MEDICARE-ADV-A
CLM CLM-4133662026-06-11T20:35:08ZTeresa——20020228UHC-70614-27•••-••-5560UNKNOWN—421 Camelback RoadFRESNO··CA93710GRP-3409SELECT-EPO
CLMCLM-4027642026-05-10T23:13:29ZFRANK—RAMIREZ··10/18/47UHC-29023-35•••-••-0382828-523-7923N/A3119 Camelback RdTampaFL33645GRP-0471null
CLMCLM-4254952026-06-13T15:59:30ZCHRISTOPHER····GRAHAM1969-02-07UHC-23280-13•••-••-08287066617598-5309 RIDGE RDGilbertAZ85293-6539GRP-5801N/A
CLMCLM-4281462026-02-21T02:28:30ZMei—Tran1998-11-01-•••-••-3038——9864 Hillcrest RdColumbusOH43263GRP-3803MEDICARE-ADV-B
CLMCLM-4147952026-02-09T08:12:09ZPamelaKBtler1995-11-10NULL•••-••-62739757403631N/A8619 Spring StMIAMIFL33198-6833GRP-4497null
CLMCLM-4052822026-02-06T00:03:42ZKEVIN—LARSON1956-05-10UHC-37006-89-641.592.2785UNKNOWN4449 CEDAR LANEAtlantaGA30302GRP-8346CHOICE-PLUS-PPO
CLMCLM-419260 2026-03-18T04:27:26ZSteve—Grant25-05-1948null-——2957 Desert Sky Blvd Apt 30Las Vegas··Nevada89117GRP-5834—
CLMCLM-4140292026-05-11T20:46:24ZISABELLA—LYNCH2/25/1992UHC-62621-69•••-••-34132575135798isabella.lynch@icloud.com··2274 CANYON ROADTempeAZ85236GRP-7095CORE-HMO
CLMCLM-4119392026-05-30T05:02:26Z·Ramirez, Keith——1954-06-19UHC-39559-25•••-••-9004-—339 BroadwayTUCSONArizona85705GRP-3066NULL
CLMCLM-4189192026-07-21T21:31:06ZMELISSA··HARVEY··1985-06-21-——-194 Cedar LnHoustonTX77058-7014GRP-7767—
CLMCLM-4072502026-06-13T22:54:44ZDIANAICOOPER1991-04-11UHC-73584-46NULL—UNKNOWN5607 Willow CourtHoustonTX77007GRP-4683···CHOICE-PLUS-PPO
CLMCLM-4232222026-05-07T17:29:44ZWilliam—Knight2/10/1940UHC-41179-03NULL(353) 587-9695UNKNOWN·267 GRAND AVENUELos AngelesCA—·UNKNOWNUNKNOWN
CLMCLM-4216202026-01-21T08:53:03ZTerresa··OChavez1955-12-19N/A··(897) 285-7938teresa.chavez86@yahoo.com8567 Church St Apt 40Houston··TX77019GRP-9637CHOICE-PLUS-PPO
CLMCLM-4276062026-05-07T10:04:17ZFRANCESV.··CAMMPBELL9/16/1992UHC-98486-22•••-••-8032——94 WASHINGTON STREETAustinTX78717GRP-0138UNKNOWN
CLMCLM-4036722026-09-22T19:56:09ZCARL··—HILL1995-10-06UHC-13848-92•••-••-39507799725256N/A2200 Bayshore DrivePhoenixAZ85010GRP-8464—
CLMCLM-4123652026-06-23T19:28:52ZSteven—Mason1965-11-06UNKNOWN·UNKNOWNUNKNOWN—-nullN/A-NULLSELECT-EPO
CLMCLM-4188732026-07-08T05:31:46Z·Joseph—WebbJan 15, 2008-•••-••-8242UNKNOWNUNKNOWNN/Anull—NULLGRP-0298CORE-HMO
CLMCLM-4143522026-08-17T11:42:21ZRebeccaB.··Lewis19670326UHC-04909-22··•••-••-8923(805) 932-7399rebecca.lewis@outlook.com6545 MAPLE AVENUENashvilleTN37215GRP-3385··-
CLMCLM-4044342026-06-21T02:51:40ZSCOTT····MORENOOct 6, 1984UHC-00221-37—UNKNOWNscott.moreno@yahoo.com3320 CEDAR LNDALLASTX75245nullNAVIGATE-HMO
CLMCLM-4225232026-05-12T21:51:58ZMargaret—Griffin1947-10-20UHC-40806-56-NULLmargaret.griffin@aol.com——N/A—UNKNOWNUNKNOWN
CLMCLM-4297652026-07-07T17:36:15ZRaplh—Cox0401-19-43UHC-70393-90N/Anull—2393 Sage Ct Apt 21CharlotteNorth Carolina28240-CHOICE-PLUS-PPO
CLMCLM-4083312026-02-14T06:40:58ZWilson, Rebekca——1982-12-21N/A•••-••-6740·8263080261-3284 Valley View DrSan AntonioTX78289GRP-4354null
CLMCLM-4027232026-08-05T16:29:36ZJones, Gerald——1951-11-21NULL•••-••-4951——5976 Harbor BlvdAtlanta··ga30337·GRP-3988··
CLMCLM-4302392026-06-17T17:21:59Z·JOAN·PMEYER··1992-11-20UHC-56059-70•••-••-2060UNKNOWN··483 Desert Sky BoulevardCharlotteNC·28211GRP-7849SELECT-EPO
CLMCLM-4254032026-08-03T00:42:14ZPAUL—COLE03/25/1987UHC-19182-68•••-••-7259390-291-9357nullUNKNOWN—nullUNKNOWN—CHOICE-PLUS-PPO
CLMCLM-4039702026-03-21T23:38:08Z KENNETH—TUCKER12-04-1947UNKNOWN——NULL1345 Meadow LnGilbert···AZ85250NULL··NAVIGATE-HMO
CLMCLM-4068902026-07-24T13:39:02ZPRIYA—COOK1956-08-04··—•••-••-0412+1 859 390 1606—8550 CEDAR LNEden PrairieMN55326GRP-2513—
CLM CLM-4222972026-09-24T11:00:29ZJacob—Herrera1943-08-15—•••-••-2901+1 925 537 3957··UNKNOWN3774 Palm DrPlanoTX75062GRP-2003NAVIGATE-HMO
CLMCLM-401757 2026-08-15T23:20:38ZJessica—Cox1948-09-02UHC-21132-77··•••-••-8836—NULL9143 Cedar Ln Apt 9GlendaleAZ85312·GRP-2798-
CLMCLM-4177152026-01-11T03:51:14ZBrendaHSantiago··1/10/1995UHC0974104UNKNOWN·5637327961N/A7882 Washington StGLENDALEAZ85377··—NAVIGATE-HMO
CLMCLM-4121262026-01-30T17:36:34ZFatima Y—Roertson··02-11-1941—•••-••-7126——UNKNOWN—··-GRP-5903NAVIGATE-HMO
CLMCLM-4179342026-09-30T06:06:39ZJULIE—MYERS1971-06-16UHC-98913-91N/A652.514.0597—2119 Apache BlvdFRESNOCA93706GRP-8920··—
CLMCLM-4149312026-07-24T23:09:49ZABBY—PHILLIPS1964-04-10··UHC-38548-43UNKNOWNN/Anull·6592 Baseline RdSan AntonioTexas78211GRP-4827CHOICE-PLUS-PPO
CLMCLM-4154222026-04-14T04:26:37Z BRITTANYG.LONG1978-06-02UHC-81737-68—UNKNOWNnull6125 Forest AvenueTempeaz85245null··NAVIGATE-HMO
CLMCLM-4043212026-04-24T22:44:26ZGERALD—ROBERTSON07/13/2008UHC-67430-52•••-••-27326175138326UNKNOWNUNKNOWNUNKNOWNNULL-N/ACORE-HMO
CLMCLM-4237252026-01-30T17:47:13ZMadison—Garza11/4/2005UHC-78183-73-+1 473 701 3433-··——N/AGRP-4198CHOICE-PLUS-PPO
CLMCLM-4005932026-04-06T08:37:20Z·DANIEL—BURTON20-04-1962UHC-24083-79•••-••-1417—-8924 Canyon Road Apt 18PHOENIXArizona·85021UNKNOWN—
CLMCLM-4089022026-03-01T02:59:35ZcynthiaDwebb1975-05-27UHC-82281-99NULL(428) 553-9650null—-NULL—GRP-6034-
CLMCLM-4200942026-06-18T10:07:02ZJANET····HARRIS19981006UHC-03351-82··null444-618-6400NULL1529 Highland AveTempeAZ85248-N/A
CLMCLM-4069372026-06-21T21:23:26ZROBRT—TUCKER2004-07-14UHC-10873-92—null··robert.tucker@proton.me2275 Sunset BoulevardTempeAZ85284GRP-2764CORE-HMO
CLMCLM-4292342026-08-28T22:13:23Z·Natalie—BennettJul 6, 1981NULL·NULLN/AUNKNOWN2327 Palm Dr Apt 34NashvilleTN37258—MEDICARE-ADV-B
CLMCLM-4253372026-03-14T01:44:29ZThomas····Matthews·2002-08-28UHC5846691•••-••-5888—N/A8141 MOUNTAIN VIEW DR··MiamiFL33161GRP-6530UNKNOWN··
CLMCLM-4216732026-02-18T12:22:22ZScott—Henderson24-01-1988·UHC-26275-22——scott.henderson67@proton.me430 Mountain View Drive·PhoenixAZ85002UNKNOWNOPTIONS-PPO
CLMCLM-4203692026-08-02T01:58:58ZAlbert—Morano11-07-1998UHC-64022-98•••-••-7169nullnull—N/AN/ANULLGRP-2838MEDICARE-ADV-A
CLMCLM-4318822026-02-07T10:30:14Z SINGH—VICTORIA1941-04-18··UHC-82237-08•••-••-1797··UNKNOWN3955 Grand Avenue Apt 8ChandlerAZ85255—null
CLMCLM-408969 2026-08-03T06:08:29ZMeganF.Bradley1967-01-09-•••-••-54674679452····251 GRAND AVE··FRESNOCA93769GRP-7818—
CLMCLM-432125 2026-01-27T14:00:45ZEthan—Reyes·12/13/39UHC-75336-04-(338) 641-0619N/ANULLUNKNOWN—null—CHOICE-PLUS-PPO
32,829 rows, page 133 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.308Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty