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-4211512026-05-26T11:36:32ZScott—Rogersnull—UNKNOWNnull-1722 CANYON ROAD··Fresnoca93769GRP-6614CHOICE-PLUS-PPO
CLMCLM-4148702026-01-02T18:30:47ZDot—Hudson1988-11-08-•••-••-2244null—3077 Meadow LaneMINNEAPOLISMN55437GRP-3996—
CLMCLM-4022332026-06-06T00:44:28ZStephanie—HarveyMar 5, 1990UHC-11287-52null+1 758 318 4520stephanie.harvey@gmail.com·6362 Union StreetEDEN PRAIRIEMN55338-0190GRP-5140SELECT-EPO
CLMCLM-4296002026-03-27T14:46:10ZEugeneORiley1974-08-10UHC-89913-50•••-••-9951—null8621 Baseline RoadDALLASTX75259nullOPTIONS-PPO
CLM CLM-4069442026-08-15T02:47:13Zdiane—·gibson1978-01-07UHC-53548-25-728-921-3628-8641 Highland AveAUSTINTexas78720nullCORE-HMO
CLMCLM-4074932026-02-08T05:10:39ZMateo—Pierce1985-05-01UHC-17328-37UNKNOWN·-—7217 LINCOLN WAYLos AngelesCA90012—OPTIONS-PPO
CLMCLM-4167512026-07-17T04:58:48ZHicks—Omar19930628-·null968.202.3886—··UNKNOWNnull-GRP-6450CHOICE-PLUS-PPO··
CLM CLM-4006902026-05-02T18:27:09Z·CharlotteEBryantSep 22, 1993UHC-51096-97•••-••-5259858.820.0512charlotte.bryant@outlook.com4266 UNION ST #802DenverCO80230NULLMEDICARE-ADV-B
CLMCLM-4118532026-03-01T18:26:05ZchristineA.ortiz1975-01-27UHC-56393-98•••-••-9178915-877-8332NULL———NULLnullCHOICE-PLUS-PPO
CLMCLM-4056562026-04-11T14:07:32ZVICTORIA····EVANS1994-03-26··UHC-19050-62•••-••-62802118074133null9661 Forest AvenueHoustonTX77068NULLNAVIGATE-HMO
CLMCLM-4313392026-05-06T10:22:54ZGary—Guzman8/12/1992UHC-54150-26——NULL7150 BROADWAY·TempeAZ85237-·MEDICARE-ADV-A
CLMCLM-4123932026-02-02T01:33:18ZSTEPHANIE—CHAEVZ1967-06-19UHC-51901-51N/A—NULL1655 Indian School RoadPhoenixAZ85056··GRP-9159NULL
CLMCLM-4166162026-06-08T17:07:06ZHELEN—RAMOS04/23/1993UHC-01503-78null····—5362 Grand AvenueSACRAMENTOCA95836GRP-1542MEDICARE-ADV-B
CLMCLM-4318132026-03-07T13:04:31ZALEXIS····MCCOY02-03-1984-•••-••-2643(627) 705-0590—4642 FOREST AVELas Vegasnv··89104GRP-0551·CHOICE-PLUS-PPO
CLMCLM-4057192026-02-17T05:34:46ZMARY—SCHMIDT05/21/77···UHC-12590-72•••-••-2274386.660.1828—6452 HARBOR BLVDMiamiFL-N/AOPTIONS-PPO
CLMCLM-410381 2026-06-15T09:14:11ZROGER—MCDONALD11-07-1944UHC-13355-77•••-••-3474(305) 363-8748·roger.mcdonald3@yahoo.comNULL—N/A—nullNAVIGATE-HMO··
CLMCLM-4082702026-07-04T01:47:18ZDavid—OBrien1975-10-06UHC-16998-15N/A—david.obrien24@hotmail.com3213 Market StreetMinneapolisMN55428GRP-9935—
CLMCLM-4309532026-10-01T18:43:39Z Valdez, Randy——2/15/1956UHC-86863-81•••-••-9394—N/A1385 OCEAN AVECOLUMBUSOH43289-4162··—UNKNOWN
CLMCLM-4246092026-03-20T06:56:34ZSAMUELYBISHOP1973-11-16UHC-34213-31•••-••-9005null—5173 Desert Sky BlvdGilbertAZ··85207-8852——
CLMCLM-4237542026-03-07T16:00:30ZSANTIAGO—WELCH2005-05-16UHC-58279-63UNKNOWN(324) 483-9393···N/A1935 MAPLE AVE #245NashvilleTN·37219NULL-
CLMCLM-4078012026-03-01T16:11:49ZEric—Lane1952-02-50—•••-••-6211535-668-4609·ERIC.LANE39@HOTMAIL.COM9899 CENTRAL AVE··TampaFL33630GRP-0640OPTIONS-PPO
CLMCLM-4296752026-01-16T21:48:52ZRACHEL—BAKER10/24/2006—N/A—N/A4703 Ocean Ave #457Tucson··AZ85707GRP-1941N/A
CLMCLM-4110692026-10-02T18:56:07ZBEVERLYS·RYAN1961-02-18UHC-70614-01•••-••-9387+1 497 728 8681-7221 Apache BoulevardFresnoCalifornia93734nullUNKNOWN
CLMCLM-4054182026-08-27T20:49:37ZCarroll, RogerE—1972-03-04N/A·null—··8894 Pine DrPlanoTX75047nullCORE-HMO
CLMCLM-4138922026-07-17T03:00:58ZAISHA—MOORE23-04-1967-•••-••-4777nullaisha.moore44@yahoo.com1722 Market StChandlerAZ···85204N/AUNKNOWN
CLM CLM-4058702026-02-21T06:47:58ZRALPHRWILLIAMSON1987-07-26UHC-12735-84--—1667 PALM DRScottsdaleaz85254·UNKNOWNnull
CLMCLM-4188192026-06-14T02:03:45Z ·Martinez, Beverly——1985-09-20UHC-52759-66NULLnullnull127 Valley View DrivePhoenixAZ85045·GRP-6121N/A
CLM CLM-4180502026-06-29T12:14:53ZSamanthaX.Olson1980-08-18UHC-70649-18NULLNULL—UNKNOWN--N/A···GRP-6248—
CLMCLM-4214852026-08-08T02:58:56ZNOAHSTORRES1979-09-16UHC-06965-04—UNKNOWNN/A2460 GRAND AVENUEEDEN PRAIRIEMN55325GRP-7319CORE-HMO
CLMCLM-4181222026-07-26T12:01:37ZDONALD—SULLIVAN02/12/1972UHC-55880-26NULL817-424-8036NULL··9412 Main StFresnoCA93709GRP-6802N/A
CLMCLM-4097672026-10-01T13:11:50ZGloria····Snyder1959-11-08UHC-20521-89—nullNULL8929 Mountain View Drive Apt 13FresnoCA·93788GRP-3796MEDICARE-ADV-B
CLMCLM-4244532026-09-16T22:57:49ZAUSTIN—ROSE·19440618—•••-••-4871+1 823 577 5049·NULL4041 FOREST AVEPlanoTX75007GRP-4679medicare-adv-b
CLMCLM-4084472026-05-26T22:12:13ZJoshuaTWalsh19880825UHC-33244-92•••-••-9658(383) 478-6648-3529 Union StreetEden PrairieMN55349-4874GRP-5668MEDICARE-ADV-A
CLMCLM-4004862026-05-02T18:56:27ZEVELYN—NGUYENAug 18, 1967UHC-91671-60—-N/A2887 Lincoln WayAtlantaGA·30386GRP-4783—
CLMCLM-4274192026-05-06T12:19:30ZPAUL—DUNCAN·1991-03-19UHC-18036-19•••-••-7674(794) 695-9553UNKNOWN7625 Sage CtMESAAZ85201-5755··NULLOPTIONS-PPO
CLMCLM-4274152026-03-08T16:58:40ZKAREN—FOWLER23-05-1990UHC-09454-42•••-••-7205429-839-8474N/A1888 FOREST AVENUETampaFL33646GRP-8864MEDICARE-ADV-B
CLMCLM-4030042026-05-30T17:19:17Zethan—alexander1973-07-04UHC-55550-61•••-••-1856—UNKNOWN4421 BASELINE ROADGlendaleAZ·85387—NULL
CLMCLM-4310362026-02-21T04:25:40ZEmily—Ford1977-10-26···null•••-••-4683UNKNOWNemily.ford@icloud.com1597 Meadow LaneChandlerAZ85223······MEDICARE-ADV-A
CLMCLM-4129622026-05-01T16:31:47ZBRYAN—ALVAREZ1955-06-09UHC-34162-31null9589694496N/A5263 Canyon RdEDEN PRAIRIEMN—null—
CLMCLM-4092432026-07-09T04:20:48ZHannahNOliver1951-07-08UHC-60027-75•••-••-1382——·926 Oak StScottsdaleAZ85270GRP-3558UNKNOWN
CLMCLM-4254672026-02-09T07:08:12ZMariana··—Patel1956-02-11UHC-03136-39··•••-••-62966109251583mariana.patel@proton.me2743 Apache BoulevardGilbertAZ—GRP-2048OPTIONS-PPO
CLMCLM-4095502026-06-30T23:40:25ZMateo—Aguilar··Jul 14, 1998UHC-24591-16—-null9152 Elm StreetDallasTX75284GRP-5525··CHOICE-PLUS-PPO
CLMCLM-430966 2026-07-02T07:45:53Zdiana—richards1941-10-18UHC-14537-49•••-••-5067483-795-3026NULL2214 CAMELBACK RDDALLASTexas75231N/Anull
CLM CLM-4322592026-05-17T19:48:16ZARTHUR—TURNER1996-10-25UHC-79544-73·NULL——3704 Mountain View DrGilbert···AZ85271-0383GRP-5727OPTIONS-PPO
CLMCLM-4068072026-09-28T08:46:47ZPATRICIA—HART14-05-1974UHC-97214-71•••-••-1869—PATRICIA.HART@GMAIL.COM6473 Jefferson AvenuePhoenixAZ85018-2643GRP-9259·OPTIONS-PPO
CLMCLM-4187502026-02-12T00:13:17ZSammuel—Chavez1956-10-25null•••-••-3624nullnull-null·UNKNOWN··GRP-1839OPTIONS-PPO
CLMCLM-4176422026-01-29T16:45:44Zisabella—dunn1993-02-10·UHC-01958-35-2977500268UNKNOWN2684 Mesa DriveChandlerAZ·85251N/A—
CLMCLM-4313072026-05-20T04:35:04Z·Amber—Mills07-04-1988UHC-83923-02•••-••-69564644549085NULL6809 River RdSan DiegoCAN/AGRP-0181MEDICARE-ADV-B
CLMCLM-405553 2026-03-03T00:25:55ZHeather—AusinOct 11, 1990·UHC-98318-39-UNKNOWNUNKNOWN6047 Lincoln WayAUSTINTX78774GRP-3524··
CLMCLM-4042852026-09-27T02:54:00Zhelen—mccoy1999-07-23NULL—(375) 952-2691-858 Market StreetTampa··FL33663GRP-1536—
32,829 rows, page 155 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.345Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty