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-4326032026-02-14T23:44:39ZMaria—Perry1959-07-07··•••-••-1153890.442.3563N/A7211 Lake View RoadScottsdaleAZ85256GRP-8410·choice-plus-ppo
CLMCLM-4101092026-05-10T18:02:38Z Judy·V.Alvarez2003-12-15UHC-56445-15•••-••-2396——-UNKNOWN—--NAVIGATE-HMO
CLMCLM-4199482026-06-03T19:49:56ZArmstrongDBradley1947-12-15UHC-69711-57•••-••-1702(495) 881-8317—7778 Willow CourtEDEN PRAIRIEMN55331GRP-6187MEDICARE-ADV-B
CLMCLM-4307372026-03-11T14:16:03ZHansen, Dorothy····—1951-06-26UHC-58649-64NULL—null5235 Willow CourtGilbertAZ85243-UNKNOWN
CLMCLM-4113262026-09-25T00:37:12ZCheryl—Andrews1971-11-24·UHC-98602-23-(525) 762-6241NULL5022 CAMELBACK RDATLANTAGA30369GRP-8155··—
CLMCLM-4271482026-07-08T00:15:13ZMichaelYCastillo19931010UHC-96541-82—·nullnull3184 Bayshore DriveDallasTX75234GRP-8887NULL
CLMCLM-4084522026-02-16T15:13:04ZChristine—Porter·9/25/1989UHC-92458-92—(205) 590-4854-426 Valley View DriveAustinTX78752nullNAVIGATE-HMO
CLMCLM-4251442026-07-13T16:33:33ZCHRISTINE—LE1993-01-19UHC-95754-24N/A··—4272 Market StreetHoustonTX77072GRP-1710MEDICARE-ADV-A
CLMCLM-4235762026-06-08T00:01:15ZPeter—Hernandez···02/20/1986UHC-11079-43•••-••-9194UNKNOWNN/A7574 BASELINE RD #842GILBERTAZ85204-3306-null
CLMCLM-417091 2026-01-02T07:33:25ZTHOMPSON—MASON12-11-1973··UHC-69452-86—NULL—3206 Willow CourtTUCSONAZ85745GRP-1486NAVIGATE-HMO
CLMCLM-4324332026-04-18T09:26:40ZYuki—Dominguez28-05-1975uhc-43448-72—+1 701 923 5765null6273 Bayshore DrCharlotteNC·28262GRP-1984MEDICARE-ADV-A
CLMCLM-4180422026-08-13T07:08:43Z·John—Burns1947-09-05UHC-60801-54-3045836899—4859 CEDAR LNChandlerAZ85217GRP-7325null
CLMCLM-4261932026-06-13T04:25:13ZSTEVE—MEYAR1960-04-21—•••-••-1081529.622.6259—9395 Sage CourtJacksonvilleFL32285—····
CLMCLM-4255572026-04-20T13:00:57ZKally····Wallace05-09-2001·NULL•••-••-6359NULLN/A9436 Oak St·ScottsdaleAZ85287GRP-0327—
CLMCLM-4085272026-04-03T22:57:42Z·cheryl····griffinJun 3, 1971·UHC-95521-19NULL5197996313··9790 Grand AveFresnoCalifornia93705GRP-5912··NULL
CLMCLM-4120682026-04-17T02:09:51ZruthGdunn20021222UHC-79382-41—NULL·-—NULL—UNKNOWNGRP-7753null
CLMCLM-4188372026-08-28T17:49:31Zroy—martinez19541203UHC-35367-39•••-••-7534(523) 300-3240null··985 Union StGlendaleAZ85377UNKNOWNOPTIONS-PPO
CLM CLM-4034412026-01-19T22:49:18ZMei—Mitchell1976-02-19null•••-••-6811(612) 516-3897·MEI.MITCHELL@OUTLOOK.COM3051 Camelback RdSEATTLEWA··nullGRP-9307UNKNOWN
CLMCLM-4235492026-02-27T13:39:43ZPaul··Gilbert03/18/1976UHC-92318-12NULLNULLNULL3615 Apache BlvdOrlando··Florida·32890GRP-2970SELECT-EPO
CLMCLM-4135772026-03-21T17:17:45ZPHILIP—LAWSON2008-12-27nullnull+1 680 668 5736philip.lawson86@gmail.com8364 Main StreetDallasTX75217GRP-9850-
CLMCLM-4019022026-05-16T21:36:54Z·TerryB.Ruiz19730225UHC-41911-95UNKNOWN··+1 740 698 5487UNKNOWN1220 Camelback RdLos AngelesCA90053GRP-6470CHOICE-PLUS-PPO
CLMCLM-4068192026-10-13T22:52:33ZDRIS—SIMMONS1952-07-04UHC-64986-08———3635 Mountain View DrScottsdaleAZ85252-5719—OPTIONS-PPO
CLMCLM-4028722026-07-13T16:54:11Zdouglas·Yhenderson1973-03-09UHC-73129-84··6752727486NULL··5324 Central AveDenverco80279GRP-8114null
CLMCLM-4277942026-06-16T03:25:32Z ALICE—AUSTIN08/28/1992UHC-95346-51—(796) 764-7772—8627 Harbor BoulevardPhoenixAZ85003-6926GRP-8014NAVIGATE-HMO
CLMCLM-4107742026-06-24T03:22:46Zrachel—guzman1992-09-27UHC-66039-53•••-••-1402UNKNOWNNULL——N/A—N/AOPTIONS-PPO
CLMCLM-4032262026-02-20T22:07:39ZRichardson, YukiM—·1982-02-08null-614.433.0688null2434 Forest Ave··Eden PrairieMN··UNKNOWNGRP-0444SELECT-EPO
CLMCLM-4303382026-09-17T07:19:16ZSAMUELHGRAY1970-08-06UHC-28025-58•••-••-697412142236265-··5075 Meadow LnScottsdale··AZ··—·NULLNAVIGATE-HMO
CLMCLM-4201912026-04-06T00:51:38ZWEI··MILLER1949-03-27UHC7783187-16977770510null967 Canyon RdTEMPEArizona85223GRP-6579—
CLMCLM-4196152026-09-01T23:35:09ZLAWRENCEPHARVEY1948-01-13N/A—325-229-2733LAWRENCE.HARVEY59@YAHOO.COM455 CANYON ROADLos AngelesCA90051GRP-8907NAVIGATE-HMO
CLMCLM-4143642026-01-24T19:01:45ZBARBARA—OLIVERJul 15, 1976UHC-71536-77UNKNOWN(451) 266-6444null2343 Sunset BlvdAustinTX78778GRP-0891MEDICARE-ADV-A
CLMCLM-4180772026-07-29T00:22:04ZAna—MorganN/A··UHC-89767-67—9302634432—8899 BroadwayScottsdaleAZ··85296GRP-7550null
CLM CLM-4094972026-01-27T20:36:25ZRebecca··Campbell05/09/1953null—UNKNOWNrebecca.campbell@hotmail.com5109 Indian School RoadDALLASTX75253-UNKNOWN
CLMCLM-4063382026-05-28T23:45:59ZGuzman, Frank··—10/09/06·UHC-66444-28NULLnullnull1500 Spring StFresnoCalifornia93723GRP-6059core-hmo
CLMCLM-4212312026-04-29T12:33:27ZCATHERINE—ANDERSON2086-19-86uhc-68010-04·UNKNOWNUNKNOWN——-—····—null
CLMCLM-4038952026-10-03T07:47:53ZTurner, Dylan——1981-03-05UHC-51775-76•••-••-8821N/A····UNKNOWN-UNKNOWN—·GRP-1939UNKNOWN
CLM CLM-4255912026-10-01T02:51:20ZHAROLD····PETERSON19631209uhc-37208-63N/A··564-272-1322null——NULLUNKNOWNGRP-5438N/A
CLMCLM-4061832026-09-16T04:15:00ZDIANE····GARRETT··2001-11-06UHC-57834-07—·(488) 966-3372—-NULLnull····GRP-4381·CORE-HMO
CLMCLM-4284912026-03-13T21:18:41ZRUSSELLXRACHEL22-04-1991NULL•••-••-8338851.786.9926-··—····—NULLGRP-5525MEDICARE-ADV-B
CLMCLM-4315982026-02-19T08:18:21ZBEVERLYQSCHULTZ07/09/81UHC-83728-87•••-••-8403—beverly.schultz@icloud.com627 Highland AveDallasTX75261-6623—MEDICARE-ADV-A
CLMCLM-4326572026-09-06T16:13:06ZSean—Peters2001-10-05—•••-••-97373404158757—4637 Sage CourtHoustonTX77053NULLnull
CLMCLM-4071072026-06-09T13:10:31ZMariaLCollins1938-11-13UHC-92321-89•••-••-5689—-9590 Central AveMesaAZ85261GRP-8831NULL
CLMCLM-4152282026-04-07T13:27:14ZCarlosU··Henderson1938-09-10··null—-3916 Washington StreetPlanoTX75093N/ACHOICE-PLUS-PPO
CLMCLM-4193252026-02-26T09:29:51ZCHERYLM.GARCIA·19891119—NULL4237356103-210 Mesa DrOrlandoFL32829GRP-4173N/A
CLMCLM-4049622026-01-06T23:23:12ZGary—Hughes1947-06-17—•••-••-0392(514) 535-8130—N/A-NULL-NULLNAVIGATE-HMO
CLMCLM-4157992026-02-21T08:45:31ZAlan—Ramos9199-04-02NULL——UNKNOWN3586 BAYSHORE DRIVECHANDLERAZ85255GRP-6176OPTIONS-PPO
CLMCLM-4311862026-02-12T14:09:51ZEvelyn—Herrera07/16/51UHC-76171-21•••-••-2624—-5146 Baseline RdJACKSONVILLEFL-GRP-4000UNKNOWN
CLMCLM-4247722026-08-06T06:27:50ZAndrea—Carlosn07/16/1970NULL—-—9848 Hillcrest RoadSan DiegoCA92180—-
CLMCLM-4086512026-02-26T22:04:05ZWilliamson, Katherine——1999-08-27UNKNOWN··NULL290-877-6161NULL6785 Sunset BoulevardTUCSONAZ85760N/ACHOICE-PLUS-PPO
CLMCLM-4216382026-09-06T23:07:59ZWillie—Wang12/05/97UHC-59116-79—NULLN/A4236 Washington St·EDEN PRAIRIEMN·55390-2314·····null
CLMCLM-4228812026-07-13T00:52:18ZJon····Kellly1985-10-27—•••-••-9269-—5606 Washington StPHOENIXAZ85082nullSELECT-EPO
32,829 rows, page 124 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:38.494Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty