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-4149502026-04-23T16:01:26ZTERESA—POWELL1949-06-17UHC-00378-09•••-••-0336(719) 616-7688··NULL2685 River RdSeattle·WA98111GRP-2585MEDICARE-ADV-A
CLMCLM-4152552026-05-17T02:31:37ZRALPH—PENA1990-35-10NULL—470-359-8893—154 Central AvenueJacksonvilleFL32215GRP-6150null
CLMCLM-4291762026-08-27T10:46:43ZVIRGINIAKRAMOSApr 27, 1989N/A—19145286030UNKNOWN1476 INDIAN SCHOOL RDSan DiegoCA92124GRP-9685OPTIONS-PPO
CLMCLM-4125822026-08-05T18:34:16ZRICHARD—SIMMONS1979-11-13UHC-95902-92—nullRICHARD.SIMMONS39@PROTON.ME7176 Market StHoustonTX77050GRP-6188SELECT-EPO
CLMCLM-4312502026-02-03T17:04:47ZBARBARA····COX1962-01-13-•••-••-0138—UNKNOWN1468 Hillcrest RoadColumbusOH-··GRP-3321··—
CLMCLM-4129602026-04-22T09:10:59ZScottUJordan1965-02-17NULL•••-••-2296·535.757.9210NULL2014 Pine DriveMiamiFlorida33190-MEDICARE-ADV-B
CLM CLM-4058692026-02-21T06:47:58ZRALPHRWILLIAMSON1987-07-26UHC-12735-84--—1667 PALM DRScottsdaleaz85254·UNKNOWNnull
CLMCLM-4211132026-07-01T19:39:21ZERIC—CASTILLO01/03/41UHC-84548-13•••-••-9419—N/AN/Anull-nullGRP-7501MEDICARE-ADV-A
CLM CLM-4041492026-09-14T02:21:45ZALBERT—PARK1990-08-25uhc-69736-83NULL··N/A—1473 Hillcrest RoadChandlerAZ85212—NAVIGATE-HMO
CLMCLM-4080002026-05-28T04:09:29ZJean···Watkins1990-03-21UHC-72810-50—408-941-9471NULL5101 MOUNTAIN VIEW DRSeattleWA98153NULLN/A
CLMCLM-4291932026-04-06T03:57:00ZDAVID—MSON1997-04-19UHC-37883-73NULL——8973 Cedar LnSeattleWashington98181——
CLMCLM-430934 2026-04-01T15:05:40ZDeborah····HughesJan 10, 1956—UNKNOWN+1 868 992 9527—7923 LAKE VIEW RDSan Antonio··TX78224-2282·NULL—
CLMCLM-4281612026-10-06T04:58:06ZShirley—Vasquez1954-09-09—•••-••-8903UNKNOWN··4637 Mesa DrPlanoTexas75041GRP-7475N/A
CLMCLM-4062032026-05-17T00:58:01ZNicole··—Sndyer1949-01-09UHC-92703-71•••-••-8321-··N/A1353 Elm StColumbusOH43206GRP-3969OPTIONS-PPO
CLMCLM-4309702026-02-05T18:40:24ZSHARON—WEBB1974-10-26UHC-86487-27N/A2222108—6290 Cedar LaneDenverCO80269··GRP-6418OPTIONS-PPO
CLMCLM-4321702026-07-31T20:48:29ZseanH·thopmson2006-05-03UHC-89280-09NULL(885) 731-7749—NULL-——GRP-8508OPTIONS-PPO
CLMCLM-4097552026-10-01T04:49:10ZBRENDA—TURNER19830803UHC-44384-04•••-••-2219393.890.8504—1252 Mountain View DrColumbusOH·43294GRP-8011null
CLMCLM-4247652026-09-06T05:22:32Zbobby—riley19600326UHC-22969-34—8222117549null—N/AUNKNOWN--SELECT-EPO
CLMCLM-4122222026-05-04T03:31:35ZPriyaRHenry··1997-12-11··UHC-78896-26··•••-••-1319NULL-··6340 Mountain View DriveGilbertAZ··85239··—null
CLMCLM-4018622026-10-05T16:07:00ZEmily—Warren1996-07-11null•••-••-19566696330066N/A8997 Maple AvenueMesaAZ85260····—
CLMCLM-4164052026-01-28T02:45:51ZDANIELLE—ROSS1997-05-10··uhc-36430-99··•••-••-7802N/AUNKNOWN6832 Main StreetAUSTINTX78728-4287GRP-8070OPTIONS-PPO
CLMCLM-4226382026-07-27T14:03:07Zpatricia··—green1963-04-09·-•••-••-52562755881880UNKNOWN4819 HIGHLAND AVENUEChandlerAZ85219GRP-2906UNKNOWN
CLM CLM-4171812026-08-11T16:20:16ZSantiago, Melissa——19920310··UHC-16590-48———1606 Washington StreetDenverCO80259—N/A
CLMCLM-4283812026-07-19T07:53:54ZJUAN··MARSHALL10/26/1938N/A•••-••-7692—NULL4144 Maple AvenueGILBERTAZ85284GRP-4061·NULL
CLMCLM-4182132026-02-04T20:53:40ZHenry—Contreras1985-03-16UHC-88378-45-NULLnullUNKNOWNNULL··N/A—GRP-8808··NULL
CLMCLM-4111192026-09-22T19:22:08ZJessca—Evans1974-08-13—•••-••-0034·5406006053jessica.evans@aol.com2157 River RoadDallastx75242GRP-5812—
CLMCLM-4265022026-02-19T00:06:51ZJesseIDelgado1956-12-12UHC-02668-55•••-••-80345422848—null-—UNKNOWNnullMEDICARE-ADV-A
CLMCLM-4277772026-02-05T03:36:31ZBilly—Romero09/22/1992UHC-51311-12N/A451-312-9900UNKNOWN6253 CHURCH STREETMESAAZ85294—-
CLMCLM-4147962026-02-25T09:05:06ZJulia—Weber1984-11-10-•••-••-6795841-241-2678—-·null—nullGRP-6737MEDICARE-ADV-B
CLMCLM-4284872026-03-08T05:56:32ZRANDY—MEYER1955-09-16UHC-67823-81•••-••-9949362-951-9984-7951 Valley View DrNASHVILLETennessee37248GRP-8945··-
CLMCLM-4264142026-05-16T01:52:34ZJULIE—ROJAS04/23/1950UHC-51780-16UNKNOWNnull—5396 Meadow Lane #484San DiegoCA92139NULLNULL
CLMCLM-4186162026-02-08T21:15:03ZnatalieLramos1987-04-27——2699171269—8649 BROADWAYSeattleWA98156GRP-5866—
CLMCLM-4181402026-02-20T20:31:22ZBennett—Henry06-01-1952·-null··—··—UNKNOWNUNKNOWNGRP-6482SELECT-EPO
CLMCLM-4286922026-03-18T14:12:25ZLUCIA—·RIOS4/2/1939UHC-92720-51—5694502—5436 Camelback RoadDenverCO80248nullMEDICARE-ADV-B
CLMCLM-4087132026-01-19T18:21:10Z·Carlos—LiJul 8, 1979UNKNOWN—(965) 479-6057UNKNOWN8294 GRAND AVEJacksonvilleFL32266UNKNOWN··NULL
CLMCLM-4103582026-08-20T01:39:57Z Riley, Ahmmed——2007-03-13UHC-08481-83--ahmed.riley87@yahoo.comNULL—····GRP-6391MEDICARE-ADV-B
CLMCLM-4219452026-04-15T07:01:22Z·Harod—·Green1967-04-09N/A•••-••-09824862209245—N/Anull—-—CORE-HMO
CLMCLM-4281492026-09-14T03:08:25Z·joseph—jimenez0701-39-53nullNULLUNKNOWNnull9058 Camelback RdTempeAZ·85244N/A·CHOICE-PLUS-PPO
CLMCLM-4190192026-05-16T11:03:54ZJOSHUA··E.TAYLOR22-02-1966——null-··1256 Bayshore DrMiamiFL33190-CORE-HMO
CLMCLM-4108102026-07-13T00:00:53ZNicoleN.Richardson20080922UHC-06257-82•••-••-45207257076485—N/AnullNULL—GRP-4475-
CLMCLM-4210932026-04-09T11:05:11ZSara—Gordon1947-05-25UHC-17238-13•••-••-0981null··—8339 Ocean AvenueMinneapolisMN55412GRP-3434OPTIONS-PPO
CLMCLM-4299552026-01-28T14:33:18ZAishaHKing07/14/1980UHC-01605-28•••-••-83174604334400··NULL·2857 LINCOLN WAY Apt 7ChandlerAZ85208GRP-4306—
CLMCLM-4046632026-02-01T12:19:21ZPayne, Roger——2005-04-06··UHC-87094-74NULL+1 228 669 9152NULL2210 RIDGE ROADCHANDLER··AZ85210GRP-9634CORE-HMO
CLMCLM-4280082026-05-01T16:36:51ZSophiaE··Johnston·19700528····——nullnull—-—GRP-3188—
CLMCLM-4190932026-05-04T03:11:45ZGilbert, VyncentS—2005-03-11UHC-99716-09•••-••-079914174329160-5120 Cedar LnSAN DIEGOCA···92158UNKNOWN—
CLMCLM-4233652026-08-01T05:48:30ZHANNAH—YANG19601112UHC3820590•••-••-9775+1 862 856 3844··—-null—GRP-8436N/A
CLMCLM-4289452026-03-07T07:59:55ZPamela—Baker1947-03-10——17973204641PAMELA.BAKER@OUTLOOK.COM8610 Baseline RoadDallasTX·75212—NULL
CLM CLM-4236502026-09-08T17:13:38ZMASON—VASQUEZ1952-12-01····—6404326N/A7154 MAPLE AVENUELos AngelesCalifornia90097-MEDICARE-ADV-A
CLMCLM-4325062026-04-01T13:40:31ZLaura—Torres1972-04-11·NULL—N/ANULL3253 Willow CtColumbusOH43286N/A·SELECT-EPO
CLMCLM-4142842026-09-14T09:47:33ZPaul—Nguyen·08-03-1996UHC-31246-56UNKNOWN6246308667·UNKNOWN5411 Bayshore DriveMesaAZ85203GRP-0912MEDICARE-ADV-B
32,829 rows, page 135 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.314Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty