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-4299772026-03-03T11:24:36ZJacob····Jordan09/08/1958-•••-••-5760NULLnull5985 LAKE VIEW ROADMiamiFL·33131GRP-3068-
CLMCLM-4177582026-02-04T03:51:50ZRIOS—ZACHARY1949-06-20UHC-47072-78N/A(698) 218-4977UNKNOWN9062 LINCOLN WAYSacramentoCA95887GRP-7232··NAVIGATE-HMO
CLMCLM-4320692026-10-12T00:40:36Z·SHIRLEY—BOYD1972-08-14··UHC-95505-65•••-••-6664N/AN/A3550 Ridge RdHoustonTX77024GRP-7640UNKNOWN
CLM CLM-418767 2026-09-08T10:46:31ZSEAN····REYNOLDS1989-10-25UHC-33152-78—578-288-1671N/A7232 BROADWAYCharlotte··North Carolina··28298-9579UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4268632026-09-21T23:42:51ZEUGENE··—CRAWFORD05/05/1954··UHC6670690—9867989533N/A6267 Broadway #435ScottsdaleAZ85277GRP-1528··—
CLMCLM-4141182026-09-06T00:53:51ZDENNIS—SPENCER01-01-1979—•••-••-3777894-970-3973—4568 Church StMinneapolisMN—GRP-9564—
CLMCLM-4314342026-10-03T14:05:04Zsusan—welch1983-01-10UHC-59072-43UNKNOWN+1 963 815 1044—6930 Cedar Lane Apt 40MINNEAPOLISMN55464null··—
CLMCLM-4171712026-10-09T03:41:12ZGraham, Joe——08-01-1951—····NULL——·N/AN/AN/AGRP-4681MEDICARE-ADV-A
CLMCLM-4145532026-02-16T10:37:14Zgrace—stone1991-10-07UHC-67144-84•••-••-7803-NULL8990 Elm StreetSAN ANTONIOTX78248UNKNOWNUNKNOWN
CLMCLM-4085992026-06-19T02:27:27Zamber—weber11/8/1989null•••-••-56593217642833NULL——null—GRP-3602SELECT-EPO
CLMCLM-4104862026-01-16T07:49:19ZCarrolyn··Price2005-12-07—•••-••-1869·630-299-1698—8651 RIDGE ROADAtlantaGA30391-4636GRP-0374CORE-HMO··
CLMCLM-4127672026-04-03T09:03:41ZSusan—Cunningham1972-05-03UHC-54309-49•••-••-2841NULL---NULLnullGRP-6205MEDICARE-ADV-B
CLMCLM-4097572026-02-02T21:18:42ZLee, Aaron——1997-12-14··null(599) 659-9303UNKNOWN9253 SPRING STTucsonArizona85748—SELECT-EPO
CLMCLM-4036382026-03-13T13:56:08ZNicole—Wood05/07/2002·null•••-••-6217(527) 623-7566UNKNOWN3460 SAGE CTSan AntonioTX78286GRP-8377null
CLMCLM-4060142026-10-01T21:53:47ZDonald—Luna1955-01-09UHC-18639-83—268-557-2026·-8713 Main StSCOTTSDALEAZ85205··null—
CLMCLM-4009002026-04-29T02:03:52ZGARY—VALDEZ1976-01-06—•••-••-08393934751100null3151 Ocean AveMesaAZ—-—
CLMCLM-4293632026-03-28T15:32:55ZKENNETHS.RAYJul 14, 1965UHC-87282-25NULL-—9330 Cedar LnOrlando··FL32826···OPTIONS-PPO
CLMCLM-4303402026-04-29T15:48:26ZLauren—West1986-04-30UHC-19655-86-(970) 912-2698NULL—UNKNOWN—····GRP-9244MEDICARE-ADV-A
CLMCLM-4096392026-05-06T09:56:36ZBryanLGonzalez1963-07-25—•••-••-2594890-875-7716-5607 Desert Sky BoulevardPhoenixAZ85041GRP-6286N/A
CLMCLM-4167052026-07-31T15:09:04ZLOGAN—WILSON1998-01-09UHC-97610-18-(881) 444-0387—·2659 OCEAN AVEOrlandoFlorida····GRP-0725CORE-HMO
CLMCLM-4186052026-02-28T23:49:37ZCynthia—Gray1986-06-08UHC-12777-98N/A4514132650····7290 Washington StreetJacksonvilleFLN/AGRP-8709NAVIGATE-HMO
CLMCLM-4124302026-09-03T10:01:02ZWILLIE—HANSEN1941-12-16·UHC4183657•••-••-5653·(338) 623-9076nullnull———N/ANAVIGATE-HMO
CLMCLM-4137822026-04-14T13:13:13ZLogan—Wang03/04/2001··UHC-72381-10····—N/AUNKNOWN········NULL··UNKNOWNMEDICARE-ADV-B
CLMCLM-431995 2026-04-01T03:12:35ZKyle—Bishop05-01-1940UHC-06507-66•••-••-9151——····N/AN/A—GRP-0579NULL
CLMCLM-4201972026-03-31T20:50:58ZMaria—PettersonDec 26, 1961UHC-50763-19——MARIA.PETERSON55@GMAIL.COM·UNKNOWNNULLUNKNOWN—GRP-7211SELECT-EPO
CLMCLM-4011262026-06-21T20:15:30ZJORDANB.WELLCH2001-11-13UHC-43144-83····-—2704 Maple AvenueDenverCO80226-7399—CORE-HMO
CLMCLM-4183532026-01-18T13:17:09ZBobby—Wright1995-04-03UHC-74847-84NULL484-655-6424UNKNOWN8097 Central AvenueEden PrairieMN55323-—
CLMCLM-4319942026-09-09T08:40:49ZSarahJLong1993-01-20UHC-42321-42··—315.314.3425—6140 Camelback Road #151HoustonTX77063—null
CLMCLM-4074282026-04-22T19:58:03ZKENNETH—CHAVEZ1988-06-19null•••-••-40672329062057—8598 ELM STHoustonTX·77079GRP-3277—
CLMCLM-4148212026-01-18T17:12:18ZSalazar, Jack····—1994-00-71UHC-24125-50N/A-nullnull——····nullN/A
CLMCLM-4042972026-08-09T15:07:31Z———3/12/1965—•••-••-67136817966665olivia.carroll15@hotmail.com9269 Grand AvenueHOUSTONTexas77086··GRP-6193—
CLMCLM-4205642026-08-28T00:02:49ZVINCENT··GUTIEERREZ1950-01-08—•••-••-553618202806153N/A5152 Washington StreetOrlandoFL32829UNKNOWNNULL
CLMCLM-4144152026-06-28T06:27:58ZLAWRENCE—GARZA1959-12-26UHC-96175-05null8732472729—4747 Palm DriveMinneapolisMN·55423nullNULL
CLMCLM-4126142026-09-01T23:09:06ZDiane—Reed09/05/95UHC-16399-94null··574.254.4094-—·-—NULLGRP-3321NULL
CLMCLM-4257792026-05-01T04:59:28ZMARK—LONGAug 26, 1976UHC-50062-61•••-••-2521(315) 542-0342mark.long@aol.com365 Camelback Road #468SEATTLE·Washington98171NULLOPTIONS-PPO
CLMCLM-4038542026-02-23T07:16:38ZTorres, Margaret··——1995-06-22UHC-34210-05•••-••-9787——1549 Ridge RdJACKSONVILLEFL32292-4726GRP-7073··MEDICARE-ADV-B
CLMCLM-4018792026-09-05T03:10:27ZPatricia—Wood06/24/57nullUNKNOWNnullN/A2526 Meadow LaneJacksonvilleFL32260-NULL
CLMCLM-4326822026-08-19T18:21:39Z·DOUGLAS—BERRY1969-10-11UHC-83888-39—N/AN/A————·GRP-4165MEDICARE-ADV-A
CLMCLM-4151772026-01-13T09:39:29ZPETER—ALEXANDER2/21/1956—•••-••-2104+1 665 459 1094N/A··4354 Spring StreetScottsdale··AZ85259GRP-0242MEDICARE-ADV-B··
CLMCLM-4268952026-01-03T17:49:49Zisabella—mendoza27-11-1953UHC-26500-93•••-••-1162·(671) 809-9197N/A·4776 Lake View RoadAustin··TX78715GRP-0283··N/A
CLMCLM-4286682026-04-12T00:03:01ZVINCENT—JORDAN1980-03-11——-vincent.jordan28@aol.com—null—NULLGRP-9809UNKNOWN
CLMCLM-4025022026-06-28T22:02:19ZLAUREN···NUNEZ1976-04-15UHC-81063-83nullNULLNULL8700 Oak StreetSacramentoCA·95864GRP-3138—
CLMCLM-4242812026-02-18T09:06:16ZADAM—TAYLOR11/06/58UHC-10122-04UNKNOWNN/A··null5074 OCEAN AVENUEScottsdaleAZ85252GRP-3622UNKNOWN
CLMCLM-4128652026-06-16T14:28:14Zamber—riley1998-12-12UHC-46144-77N/A····amber.riley@gmail.com3250 Forest AveJACKSONVILLE·FL32236·GRP-7884SELECT-EPO
CLMCLM-4276692026-01-11T17:14:39ZJONATAHN—FLORES1972-09-19UHC-29582-45•••-••-1623(843) 452-4663N/A9441 Canyon RdEDEN PRAIRIEMN55360·GRP-2702NAVIGATE-HMO
CLMCLM-4250372026-04-29T06:06:30ZWILLIE—SIMMONS·1960-04-04UHC-03082-45··UNKNOWN—-3985 Willow CtSacramentoCA95837GRP-8795MEDICARE-ADV-B
CLMCLM-4224862026-01-28T06:27:25Z StephenYWeber1945-09-02UHC-21855-17null(606) 706-0381—4201 HIGHLAND AVENUEGlendaleaz85316N/AMEDICARE-ADV-A
CLM CLM-4077532026-10-12T03:19:50ZWheeler, Kayla——1938-11-09UHC-62250-44•••-••-3945N/A··5670 Valley View DrLAS VEGASNV89169N/A—
CLMCLM-4256882026-07-08T05:58:52ZGloria—Gilbert1990-12-28UHC-67983-70•••-••-7981—NULL478 Sage CourtPhoenixAZ·85015GRP-8974MEDICARE-ADV-A
CLMCLM-4266682026-08-12T17:15:33ZAna—Lee22-12-1945—UNKNOWN·594.959.2135null·8520 Washington StFRESNOCA93791NULL-··
32,829 rows, page 17 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:34.779Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty