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-4066462026-07-27T18:18:44ZDeniseTKing19890610UHC-24696-32—N/AUNKNOWN1882 Forest AveMesaaz85234GRP-0647NULL
CLMCLM-4118142026-01-07T20:55:23ZTYLER—WARD1972-08-16NULL•••-••-4882(837) 876-8207··—·421 Church StreetMiamiFL33153-—
CLMCLM-4301852026-04-13T22:54:37ZRonald—Thomas1999-03-07·UHC-18112-04•••-••-0846+1 686 854 4321UNKNOWN700 GRAND AVENUELos AngelesCalifornia·90054—UNKNOWN
CLMCLM-4068642026-09-25T17:00:40ZAMANDA—HICKS09-10-1972—UNKNOWN(595) 886-4136null5918 Forest AvenueMinneapolisMN55439nullUNKNOWN
CLMCLM-4024762026-08-23T14:28:40ZKAREN—SIMPSON19-05-1987UHC-89737-33-873-702-2189—-NULLNULL····GRP-1508MEDICARE-ADV-A
CLMCLM-4042542026-04-03T20:16:27ZPAT—KNIGHT··1960-01-05—N/A5432461084null1062 Ridge RdSeattle··WA98195GRP-7773··-
CLMCLM-415362 2026-05-09T20:54:37ZRUTH—WEST1976-01-09UHC-47531-91•••-••-8406NULL—·8654 LAKE VIEW ROADGLENDALEaz85342NULLMEDICARE-ADV-B
CLM CLM-4299582026-03-17T01:32:22ZAshley—Edwards22-10-1970—··N/ANULL6246 River Road··San AntonioTX78245N/A—
CLMCLM-4309802026-04-14T07:41:41ZThomas, Karen——2005-11-05UHC-47494-97··•••-••-4760——6718 MESA DRIVEHoustonTexas77082GRP-7804NULL
CLMCLM-4260852026-05-25T02:31:40ZMARGARET—HILL1958-03-03N/A•••-••-3843—--null-UNKNOWN—MEDICARE-ADV-B
CLMCLM-4037262026-06-22T20:32:36ZKevin—Austin1995-06-19UHC-73758-62-—null8350 Camelback RdMinneapolisMN55400N/ACHOICE-PLUS-PPO
CLMCLM-426086 2026-05-14T08:47:16ZGary—Freeman1972-10-03UHC-26226-69··N/A—N/AnullUNKNOWNUNKNOWN—GRP-4566OPTIONS-PPO
CLMCLM-4075952026-05-21T20:35:27ZRACHEL—CUNNINGHAM1955-11-06UHC-55213-29-··-—N/A——UNKNOWNGRP-4316SELECT-EPO
CLMCLM-4073982026-10-09T07:03:00ZGEORGEMMORRISON1981-02-22null—601.634.1074NULLNULL—null····GRP-4549OPTIONS-PPO
CLMCLM-4292492026-09-24T18:10:42ZHaarold·YButler08/28/39UHC4809873null-—151 Valley View DrSeattlewa98145GRP-1721—
CLMCLM-4324502026-07-16T18:48:06ZCATHERINEG··HARRIS1994-08-16UHC-89494-51UNKNOWN—UNKNOWN—UNKNOWNUNKNOWN·UNKNOWNGRP-1686—
CLMCLM-4132162026-03-08T03:50:25ZALLBERT—MENDEZOct 21, 1972N/A—UNKNOWN—1232 Desert Sky BlvdHoustonTX77004—-
CLMCLM-416654 2026-04-02T15:00:14Zmadison—lee1972-03-08UHC-47329-24•••-••-8602—madison.lee84@yahoo.comN/A—UNKNOWN—nullCHOICE-PLUS-PPO··
CLMCLM-4260302026-08-28T03:44:11Zjustin F.—roggers··2001-12-10N/A•••-••-4610—justin.rogers@yahoo.com9050 Willow Ct Apt 17San DiegoCA92122—·CORE-HMO
CLMCLM-4185472026-04-03T20:16:33ZRUSSELLQ.POWELL10/22/1939UHC7337998•••-••-5979+1 654 672 2457—8283 Willow CtFRESNOCA93760·UNKNOWNN/A
CLMCLM-4148192026-01-27T17:15:26ZAMANDA—MARTINEZ19600803N/A—2975490507—·7043 Forest AveGLENDALEAZ85321GRP-4170OPTIONS-PPO
CLMCLM-4014842026-01-04T13:27:47ZBRYAN—MCDONALD1943-01-28UHC-55577-57—14758629058bryan.mcdonald20@yahoo.com5985 GRAND AVENUEAtlantaGA30348-CHOICE-PLUS-PPO
CLMCLM-4101782026-03-22T22:48:49ZHenry—McDonaldMay 19, 2007——-—2866 Grand AveOrlandoFL·32829GRP-9154—
CLMCLM-4202522026-07-16T01:04:07ZKEITHI.GORDON9/11/1965UHC-14722-66•••-••-9537·(393) 629-3122—9536 LAKE VIEW ROADDallasTX75240nullCORE-HMO
CLMCLM-4116152026-04-21T21:49:43ZPatrickDWalsh1998-03-25UHC-25721-65•••-••-1455220-399-8995—3356 Apache BlvdJacksonvilleflNULLGRP-5855CHOICE-PLUS-PPO
CLMCLM-4190832026-04-05T19:57:09ZTran, ScottH.—1976-08-06UHC-47745-73·UNKNOWNUNKNOWNnull—null·-·NULLGRP-5814NULL
CLMCLM-4303572026-08-19T05:13:34ZRYAN—MORGAN03/04/99··UHC-41447-09null2786929304-4448 CHURCH STREETChandlerAZ85232GRP-0118MEDICARE-ADV-A
CLMCLM-4264182026-05-28T19:03:11ZDOORTHY—WONG04/25/59uhc-61229-84•••-••-1039(742) 631-1683—null——nullGRP-1842UNKNOWN
CLMCLM-4188102026-02-06T12:49:11ZVazquez, Alice——·1939-02-06UHC-55168-96•••-••-2001—-9804 Indian School RoadSEATTLEWA98183GRP-7773SELECT-EPO
CLM CLM-4181312026-05-22T07:06:04ZEmma—Coko1960-02-23UHC-78970-78•••-••-1588NULLnull·2069 Willow Ct·HoustonTX77096GRP-9051—
CLMCLM-4004032026-09-24T16:34:00ZPatrickHFoster2001-08-21UHC-07454-34•••-••-64422723026646——·null—UNKNOWNNULL·UNKNOWN
CLMCLM-4003312026-04-11T14:05:01ZMarcus—Mendoza1995-05-19UHC-40562-16N/A703-980-0274—9058 MAPLE AVELos AngelesCA90037null··MEDICARE-ADV-A
CLMCLM-4010952026-05-18T22:12:35ZBailey, Daniel——19670212NULL-—UNKNOWN6151 DESERT SKY BOULEVARDMesaAZ85276GRP-0907·OPTIONS-PPO
CLMCLM-4279342026-07-25T22:16:38ZVALENTINA—PAYNE01/26/1974N/A•••-••-6118-NULL4929 Church St Apt 5Jacksonvillefl·32288N/Anull
CLMCLM-4019542026-05-19T16:23:24ZSarh··Grant··01/04/1999UHC-93690-53•••-••-8700354-323-3551null—-null—GRP-7053SELECT-EPO
CLMCLM-4187042026-06-22T05:53:44ZchristianA.estrada1992-03-02UHC-18584-05•••-••-2437nullNULL6869 BASELINE RDOrlandoFL·32847GRP-2830MEDICARE-ADV-B
CLMCLM-4256722026-08-17T09:38:09Z·Richardson, Paul——1950-06-90··UHC-64897-23—N/ANULL2787 PARK PLACE·TampaFL33669····UNKNOWN
CLMCLM-4161742026-10-10T18:35:40ZSamantha—Jenkins01/20/2007·UHC-20745-11N/A-—3267 Oak StOrlandoFloridaNULLGRP-5917NULL
CLMCLM-4175642026-10-13T19:27:32Z·JacobK.Fields1996-01-20UHC-76092-02•••-••-2237NULL——N/A—nullGRP-7677UNKNOWN
CLMCLM-4096342026-05-11T12:22:11ZSamuel····Hernandez1966-10-18UHC-55752-85··(348) 798-0865N/A7940 BroadwaySacramentoCA95831GRP-3032CORE-HMO
CLMCLM-4158612026-08-03T23:45:43ZJulie—·Fernandez1941-10-24—··—N/A6804 HARBOR BOULEVARDChandlerAZ····GRP-6753null
CLMCLM-4094272026-05-20T11:58:56ZNancy—Carr1992-05-05UHC-43731-30-—N/A8493 Oak StSeattleWA98158GRP-1082NAVIGATE-HMO··
CLMCLM-4044242026-03-07T21:01:13ZLORII.WHITE07-07-1992N/Anull14158799681—2314 Park PlGilbertAZ85203GRP-9101-
CLMCLM-4219562026-09-15T06:41:20ZAnaJ·Wilson11/12/2008UHC-64306-22•••-••-0034·N/AN/A4501 Union StSan Antonio··TX78286··—SELECT-EPO
CLMCLM-4160582026-04-11T15:08:12ZGrcae··—Burns1977-04-13UNKNOWNNULL·6253769N/A—N/AUNKNOWN—GRP-7066NAVIGATE-HMO
CLMCLM-4315792026-08-21T12:51:00ZRICHARD—MILLER1966-07-22·UHC-60998-16•••-••-06353298377603—1979 Hillcrest RoadMIAMIFL33154-6916UNKNOWNNAVIGATE-HMO
CLMCLM-4210082026-08-13T12:07:17ZMargaret—Deean20000607UHC-39451-79NULLnull··—UNKNOWNNULL··-—GRP-7660NULL
CLMCLM-4182762026-07-12T11:32:16ZKaren—Aguilar1960-01-06UHC8052802UNKNOWN7169186null·552 Hillcrest RdAtlantaGA30384GRP-7726CHOICE-PLUS-PPO
CLMCLM-4247692026-01-05T08:21:06ZCole, Sophia——19791003——NULLnull·5607 RIDGE ROAD Apt 7·AustinTX·78711GRP-9389CORE-HMO
CLMCLM-4240312026-01-27T19:04:17ZMegan—Kim2008-03-28UHC-45400-47—18206878393—UNKNOWNnull—UNKNOWNGRP-2497select-epo
32,829 rows, page 171 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.603Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty