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-4065952026-08-17T07:09:34ZHiroshiZLewis1954-09-13UHC-02077-12——·N/Anull———GRP-1169—
CLMCLM-4177332026-10-17T14:22:03ZWAYNE—GARZA1990-11-24UHC-17167-67——UNKNOWN—N/A—N/AGRP-1066null
CLMCLM-4262372026-09-29T07:55:50ZBRUCE—MOORENov 19, 1964UNKNOWN-UNKNOWN—1620 WILLOW COURTMesaAZ85236GRP-7190NULL
CLMCLM-4008952026-06-20T06:31:15ZEthanS.Hudson1939-04-27UHC-61046-67null-UNKNOWN-—-nullGRP-2180··OPTIONS-PPO
CLMCLM-4319652026-06-26T14:15:11ZEric··HYoung09/14/49null-385-230-0313NULL·NULLUNKNOWN-—GRP-7659null
CLMCLM-4026002026-05-09T23:01:54ZMikhelle—Medina2006-03-15UHC-20779-23•••-••-7670NULLMICHELLE.MEDINA97@HOTMAIL.COM2223 Spring StreetAustinTX78785GRP-2931N/A
CLMCLM-4304072026-03-18T02:57:12ZDeniseUStevens19701116UHC-98801-28•••-••-6284466.556.5436—7600 Mountain View DrHoustonTX77053-·medicare-adv-b
CLMCLM-4277792026-05-03T01:01:11ZDaniels—Abigail18-05-1969·UHC-73907-78•••-••-1113UNKNOWNabigail.daniels@aol.com-—····—GRP-7073—
CLMCLM-4114872026-04-08T23:25:12ZCarlson, Vincent——1953-01-24UHC-79092-72•••-••-7252——5373 Forest AvenueJACKSONVILLEflN/AUNKNOWN—
CLM CLM-4161992026-06-13T21:08:28ZAnthonyHRodriguez2002-10-08UHC8351159NULL687-240-0960anthony.rodriguez61@yahoo.com1004 Palm DrMinneapolisMN55457GRP-5457—
CLMCLM-4090972026-04-16T15:53:49ZJOAN—CHAVEZ02/14/2006uhc-73132-10•••-••-9354(576) 969-5537··—7276 Spring StreetEDEN PRAIRIEMN55340GRP-0989NULL
CLMCLM-4311802026-04-26T09:04:33ZCarolynIGeorge01-04-1960-NULL-··—3008 Meadow LaneDallas···TX75228GRP-9842CORE-HMO
CLMCLM-4166202026-01-19T14:21:54ZBailey, Wayne——2007-07-10UHC-22905-01null(707) 729-0054··8816 Forest AvePhoenixAZ85017—NULL
CLMCLM-4323152026-05-14T23:51:42ZGregory—Hart1960-19-22UHC-92794-69•••-••-8105—-859 Palm DrChandlerAZ85286GRP-4766OPTIONS-PPO
CLMCLM-4226742026-07-08T04:30:33ZKAATHRYN—WHEELER1982-04-19UNKNOWN—NULL··1776 Baseline RoadLAS VEGASNV89146GRP-6069N/A
CLM CLM-413636 2026-07-24T12:05:11ZTERESA—WALSH1949-10-07UHC1492454•••-••-3131858-657-1916N/ANULL———GRP-1653MEDICARE-ADV-A
CLMCLM-4043082026-06-21T05:17:03ZJerry—Perez1941-01-27UHC-73871-63—710.929.9262JERRY.PEREZ@AOL.COM—··NULL····—NULL··
CLMCLM-4070452026-06-30T01:45:38Zjoseph—peters1973-09-07UHC-30404-02N/A-null6481 BROADWAYNashvilleTN37274GRP-8174OPTIONS-PPO
CLMCLM-4081362026-05-05T23:51:33ZjosephKscottAug 21, 1975UHC-72343-79—UNKNOWN—7502 Desert Sky BlvdAustinTX78761GRP-1972····
CLMCLM-4216792026-08-08T18:04:29ZYukki—Gonzales1983-06-23——-yuki.gonzales80@icloud.com7979 PINE DRCharlotteNorth Carolina28244—MEDICARE-ADV-A
CLMCLM-4274612026-01-22T13:01:00ZGrace····Thompson1957-11-22UNKNOWN•••-••-4990(866) 984-6590GRACE.THOMPSON87@PROTON.ME—··-—-N/A
CLMCLM-4069302026-06-30T20:36:47ZREBECCA—HARRISONNov 28, 1997··•••-••-7297982-642-4169-—····—NULLGRP-5632SELECT-EPO
CLMCLM-4048072026-08-26T21:26:09ZCruz, Philip——1950-04-31UHC-16685-19—(811) 333-8351null7326 BroadwayAtlantaGA30313—null
CLMCLM-4322982026-04-23T15:35:24ZDANIELXPENAJan 8, 1971UHC-54987-16UNKNOWN+1 547 894 6677—9716 Maple AveHoustonTX77037——
CLMCLM-4056112026-08-01T10:43:05ZLane, MarianaL····1972-09-10N/Anullnull—3982 Cedar LnDenverCO80254NULLNULL
CLMCLM-4224132026-08-13T09:44:32ZWei—Luna··1989-10-07UHC-19490-35•••-••-013717327094122-··——null--N/A··
CLMCLM-4269772026-04-28T00:17:35ZPeter·UVegaApr 6, 2002UHC-80214-61•••-••-4843(792) 591-1289-3312 Ridge RdFresnoCA93788GRP-0926MEDICARE-ADV-A··
CLMCLM-4138062026-04-02T04:50:24ZWillie··Robinson08/05/67UNKNOWNNULLNULLnull5548 VALLEY VIEW DRIVEJACKSONVILLEFL32295-0973UNKNOWN-··
CLMCLM-4158562026-06-09T08:53:34Ztyler··—snyder8/19/1964-N/Anull—6743 Lake View RdEden PrairieMN55316-1924—NAVIGATE-HMO
CLMCLM-4125052026-09-18T16:54:30ZDONNA—RIVERA1975-08-12UHC-91295-74N/AnullNULL8277 Camelback RdTEMPEAZ··85237GRP-5780SELECT-EPO
CLMCLM-4239492026-05-09T13:22:39ZRaymond—Woods··12-04-1996null•••-••-6821+1 253 489 7061null2178 WASHINGTON STREETMinneapolisMN55497GRP-4998CHOICE-PLUS-PPO
CLMCLM-4077232026-09-24T23:51:47ZRaymond—Banks2004-07-09UHC-53680-51•••-••-47798823434683—2102 Central AveDenverCO——NAVIGATE-HMO
CLMCLM-4301382026-07-07T19:18:48Zronald—butler1971-70-18··UHC2344992•••-••-4521839.470.8174—6971 Lake View RoadLas VegasNevada89162GRP-2699N/A
CLMCLM-4030222026-04-18T09:37:55ZKeith—·Wood1941-02-22——16685826424NULL8529 HILLCREST RDFresno·CA93767GRP-5630null
CLMCLM-4305162026-03-26T02:49:46ZSara··—Hicks··2001-12-23UHC-24394-15null·(474) 579-5639SARA.HICKS54@AOL.COM2890 Mountain View DriveSacramentoca··95867——
CLMCLM-4090622026-07-09T21:55:21ZStephens, Willie——1957-11-02UHC-37196-32•••-••-8315-NULL·UNKNOWNN/A—-UNKNOWNMEDICARE-ADV-A
CLMCLM-4232062026-10-03T22:40:02ZWillie—Munoz1960-01-08UHC-92535-52-6597207005UNKNOWN—····——GRP-0789NULL
CLMCLM-4086582026-04-26T02:25:37ZPRIYA—WILLIAMSON1981-05-23NULLN/A-··N/A1331 Ocean AveSeattleWA98159nullnull
CLMCLM-4177772026-01-05T01:37:11ZHenry—Hudson1962-05-17—•••-••-5636399.531.9723UNKNOWN3276 Camelback RoadGlendaleAZ85374-4060GRP-2840CHOICE-PLUS-PPO
CLMCLM-4111492026-02-12T03:30:04ZBurns, Noah······2000-03-03UNKNOWN····(503) 580-0367—7504 BROADWAYTampaFLUNKNOWN——
CLMCLM-4219002026-08-22T09:03:29ZPrice, Alexis—····09/09/1958-•••-••-3091903-494-0566nullNULLNULL-··GRP-3123—
CLMCLM-4124552026-01-10T01:12:36ZREBECCAH.KENNEDY··1938-05-08··UHC-25249-09NULLNULL—2598 Church StJacksonvillefl32236—OPTIONS-PPO
CLMCLM-4253542026-10-08T19:14:32ZMASON—EDWARDS1998-08-27-····7264066114NULL4767 Apache BlvdSan DiegoCA··92146UNKNOWNNULL
CLMCLM-4046982026-01-13T15:38:07ZStephens, BrendaL—Mar 2, 2000NULLN/A(876) 219-6814——UNKNOWN—nullGRP-6378NAVIGATE-HMO
CLMCLM-4299482026-07-18T03:08:05ZFrances—Hansen1958-11-10—•••-••-2992(744) 286-4153null8848 Lincoln WaySan DiegoCA92179NULL—
CLMCLM-4099222026-09-05T12:01:38ZLisa—·Porter·1961-07-05UHC-43480-38—15394275875—5821 Bayshore DriveSeattle··WA98178GRP-0233—
CLMCLM-4075912026-04-07T08:05:30ZBetsy—Kelley·1992-10-21—•••-••-7803UNKNOWNnull7342 LINCOLN WAYCharlotteNC28277-—
CLMCLM-4144812026-05-03T23:12:00ZBruce—Weaver··1955-03-27UHC-97693-66—·(764) 766-9997-7058 Sage CtTucsonAZ85731GRP-4808·CORE-HMO
CLMCLM-4140882026-01-31T20:03:09ZTyler—Adams1959-02-25UNKNOWN•••-••-9697——2455 Lake View RoadMesaAZ·85244-CHOICE-PLUS-PPO
CLMCLM-4092972026-04-26T17:13:51ZAnn—Castro··07-07-1951····•••-••-4744·N/ANULL3733 WASHINGTON STLas VegasNV·89114GRP-5256null
32,829 rows, page 60 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:36.714Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty