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-405066 2026-09-20T04:24:03ZDonna—TorresFeb 11, 1978—NULLN/A—N/A-··UNKNOWNnullGRP-2831MEDICARE-ADV-A
CLMCLM-4058712026-08-20T19:42:44ZRalph—Williamson1987-07-26NULL•••-••-7737480.530.0172N/ANULL-nullnullGRP-8397-
CLMCLM-4248492026-05-19T07:08:26ZJudith—Martinez1993-09-16UHC-48517-88null—-9374 Hillcrest RoadPHOENIXaz85043GRP-4866MEDICARE-ADV-A
CLMCLM-4172082026-01-17T10:01:58ZMARIA—RYAN1965-03-01UHC-53814-07null(289) 811-8492··8437 Lake View RdAtlantaga·30370—CHOICE-PLUS-PPO
CLMCLM-4077282026-07-19T17:59:45ZSteve—Park01/23/41UHC-23541-97•••-••-23795506739669NULL8298 Main StSACRAMENTOCA95845GRP-3582CORE-HMO
CLMCLM-4004952026-07-20T10:02:27ZJudith—Gonzales··4/21/1995·UHC-65932-60UNKNOWNUNKNOWNNULL··144 Canyon RoadSeattleWA98195-8616GRP-6932CHOICE-PLUS-PPO
CLMCLM-4056072026-01-16T23:38:18ZjoshTjohnston11/19/2000UHC-20659-99-(768) 588-3071—6768 JEFFERSON AVEEDEN PRAIRIEMN·55369GRP-9044SELECT-EPO
CLMCLM-4123032026-02-05T06:00:01ZWalter—Cunningham1943-01-05·UHC-39378-75•••-••-3276—-—UNKNOWNnullnull—null
CLMCLM-4253042026-06-06T18:52:13ZDOROTHYEWAGNER09/12/1938UHC-46359-62•••-••-4918(515) 316-5960····9333 Sage CourtScottsdaleAZ85293nullCHOICE-PLUS-PPO
CLMCLM-4297762026-05-02T11:38:36ZDanielleHStevens2/13/1944N/AN/ANULLUNKNOWN4873 OCEAN AVENUEChandlerAZ85215-4642GRP-9015N/A
CLMCLM-4036792026-06-18T08:21:34ZFrank—Williamson1938-10-13UNKNOWN—308-742-8282frank.williamson@outlook.com5825 Forest AveLOS ANGELESCAN/AGRP-9460NAVIGATE-HMO
CLMCLM-4098552026-06-15T08:27:47ZDenise—Stephens1995-08-16UHC9935016—+1 914 684 9485N/A-NULLNULL—·GRP-6908null
CLMCLM-4221882026-06-25T07:26:03ZMARILYN··—HOFFMAN19540112NULLnull-N/A—N/ANULLnullN/ACORE-HMO
CLMCLM-4103022026-07-20T07:41:30ZBrittany—Simpson05/18/92UHC-61931-71··•••-••-93606359934670NULL3674 Church StLas VegasNevada89106UNKNOWN··-
CLMCLM-4027352026-05-19T21:59:04ZJOSEPH—MURPHY19560111—•••-••-8883—NULLUNKNOWNNULL—NULLNULLnavigate-hmo
CLMCLM-4159452026-06-04T14:11:17ZJoseph—Sandoval19551211UHC-40500-84———1355 LINCOLN WAYLos AngelesCA90050GRP-0674—
CLMCLM-4195602026-09-20T14:24:41Z·Wayne—Harper1964-10-28UHC-30787-33•••-••-7155(989) 788-2734—7150 Spring StSacramentoCA95831GRP-6690NAVIGATE-HMO
CLMCLM-4147732026-08-04T06:49:16ZWILLIE—MCCOY1994-10-23—•••-••-30238759847359--NULL-—GRP-6624UNKNOWN
CLMCLM-4157952026-07-14T17:33:40ZCHARLES—WALKER1952-02-15N/A—(433) 589-8997charles.walker32@yahoo.com2543 Oak StreetOrlandoFL32828GRP-6625CHOICE-PLUS-PPO
CLMCLM-4077652026-05-25T11:04:50ZKimberly—Robinson2008-05-16—N/A885-255-9584··—1348 MOUNTAIN VIEW DRMinneapolis··MN55428—SELECT-EPO
CLMCLM-4153412026-10-15T03:08:15Zsofia—wilson2004-06-18UHC-06608-41-··UNKNOWN—3482 River RdSan Diego·CA92138·UNKNOWN—
CLMCLM-4084972026-01-16T02:29:49Z·judy—wells2007-04-08··-UNKNOWNN/A-7975 ELM STEDEN PRAIRIE··MN55372-0189GRP-7332null
CLMCLM-4055502026-03-07T19:56:21Zlawrence··—warren05/03/61UHC-31399-31··•••-••-8419—NULL7599 INDIAN SCHOOL ROADMiamiFL33150——
CLMCLM-4061922026-09-01T05:08:07ZFATIMA—PERKINS19920414UHC-00138-75•••-••-2860UNKNOWNNULL107 Central AveJACKSONVILLEFLN/AGRP-0830UNKNOWN
CLMCLM-4254762026-05-27T16:10:47Z Chen, Boby——2003-07-10··•••-••-1526808-297-0122—7936 Pine DriveSAN ANTONIOTX78210··GRP-6873MEDICARE-ADV-B
CLMCLM-4252832026-09-09T18:29:25ZCHRISTINA—GREEN11/10/69—•••-••-7673UNKNOWN—8203 Jefferson Ave··GLENDALEAZ85351GRP-8091navigate-hmo
CLM CLM-4138892026-10-12T12:19:05ZDeborah—Wang02-01-1948null——null8592 Baseline RoadNashvilleTN37289··——
CLMCLM-4185652026-07-04T21:23:39ZLawrence—Alvarado1956-02-11-····—NULLUNKNOWNnull—N/A—NULL
CLMCLM-4120672026-05-14T15:09:07ZRTH····DUNN··2002-12-22—•••-••-1720·+1 274 947 7649—1310 Apache BoulevardTAMPA·FL33623·GRP-7753CORE-HMO
CLMCLM-4110812026-04-23T23:05:55ZSandraYLuna1964-03-12UHC-78857-62•••-••-3690-UNKNOWN··9505 Oak StreetEDEN PRAIRIEMN···55386-null
CLMCLM-4261842026-06-23T19:10:38Z·JESSICABPIERCE1960-03-20null•••-••-3510nullN/A1226 JEFFERSON AVENUELOS ANGELESCA90020GRP-7668—
CLMCLM-4115732026-02-14T18:42:48ZJulie—Chen·10/26/1981UHC-35660-93•••-••-9319null—6058 Church St #796DallasTX75259··GRP-9645N/A
CLMCLM-4208972026-05-05T03:49:30ZAUSTIN··MARTINEZ19671023UHC-11479-37•••-••-4909UNKNOWNUNKNOWN3253 Baseline RoadTempeAZ85224GRP-6860NAVIGATE-HMO
CLMCLM-4122352026-03-18T18:44:55Zyuki—boyd1993-05-18UHC-66893-48NULL(643) 602-6611··NULLnull—nullnullGRP-9662MEDICARE-ADV-A
CLMCLM-4189182026-04-22T18:23:29ZSOPHIA—DEAN1942-10-01UHC-13490-98—5362665784—1036 River RoadChandlerAZ85242··GRP-9862CHOICE-PLUS-PPO
CLMCLM-4241852026-09-10T11:01:19ZCheryl—Gray23-06-1950—•••-••-6512(236) 824-4049·UNKNOWN——NULL—GRP-2077—
CLMCLM-4249252026-02-12T23:47:21ZDorisTFord1958-02-28N/A—·19162660020UNKNOWN1242 Lake View RoadScottsdaleAZNULLGRP-2427··MEDICARE-ADV-B
CLMCLM-4263352026-02-08T08:17:24ZBrandonDWhite08/23/57UHC-47774-61•••-••-2790559-890-1807—1017 BroadwayMinneapolisMN55457—-··
CLMCLM-4250842026-06-14T08:52:20Z Peter—Smith13-03-1974UHC-20983-31—NULL··NULL1657 HIGHLAND AVEFresnoca93778GRP-7270—
CLMCLM-4153582026-05-12T05:53:36Z·BobbyM.Gilbert2/7/1980UNKNOWN•••-••-959416962108566bobby.gilbert55@outlook.com8460 Indian School RdSan Diego·CA92160GRP-2636OPTIONS-PPO
CLMCLM-4199132026-09-13T17:43:17ZCynthia—Jimenez1989-07-14NULLnull—null7864 Market StreetCOLUMBUS··OH43222-7437—OPTIONS-PPO
CLMCLM-4032062026-01-29T00:59:27ZJAKOBGWONG1982-10-02N/A—3693430—1191 Camelback Road Apt 17··MESAAZ85210GRP-7783medicare-adv-b
CLMCLM-4097952026-02-27T17:20:00Z JACQUELINE—·WEBB1940-04-10UHC-60029-17-—NULL9796 Washington StColumbus·OH43259—SELECT-EPO
CLMCLM-4277162026-07-18T05:22:10ZDAVID—GRIFFIN7/13/1958UHC-59486-30•••-••-11352899222—9704 Forest AveScottsdaleAZ85264·GRP-8582—
CLMCLM-4288012026-02-23T06:24:38ZEdward—Simpson09/14/1974UHC-96293-11·N/A2796159432·NULL8389 VALLEY VIEW DRSCOTTSDALEAZ85203GRP-0110UNKNOWN
CLMCLM-4249162026-05-20T14:13:38ZDEBRARKNIGHT1991-04-27UHC4261707•••-••-5793UNKNOWNNULL··—-null—GRP-3633NAVIGATE-HMO
CLMCLM-4096172026-05-15T08:42:47ZAlbert·P.Hayes··1944-07-03UNKNOWN—nullnull7339 Hillcrest Rd Apt 9PlanoTexas75091·GRP-6652UNKNOWN
CLMCLM-4024362026-07-08T10:27:39Z Perkins, Denise··—Nov 25, 1971UHC-55403-36NULL—UNKNOWN5125 OAK STREET·Glendaleaz85309GRP-3354NULL
CLM CLM-4253432026-02-02T23:34:15ZLAWRENCE···GUTIERREZ1960-06-19—-—N/AUNKNOWNN/ANULLnullGRP-3372·SELECT-EPO
CLMCLM-4069392026-04-21T15:21:41ZDAVID—PALMER09/23/1997UHC-50880-94—null··—2285 UNION STSan DiegoCA92189··GRP-2985NULL
32,829 rows, page 143 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.325Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty