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-4276642026-03-13T02:01:56ZAlexis—Bennett1968-06-04UHC-65598-14•••-••-65489674333853NULL8577 BroadwaySACRAMENTOCA95882N/AOPTIONS-PPO
CLMCLM-4326672026-01-16T22:30:33ZBENJAMIN—OLSONFeb 25, 1977UHC-43567-80NULL-NULL··3921 Lincoln WayJACKSONVILLEFL32278GRP-3028—
CLMCLM-4064772026-03-13T06:24:02ZCarlos—Walsh1986-04-23UHC-10139-71null567.880.5850UNKNOWN1398 River Rd··FRESNOCA93741UNKNOWNSELECT-EPO
CLMCLM-4234352026-01-28T02:29:21ZBETTY—GONZALEZ1961-05-12UHC-67685-44N/AnullN/A··8432 Canyon RdPlanoTX75027GRP-4426—
CLMCLM-4213402026-06-18T17:59:02ZHEATHER—GUZMAN05-02-1982UHC-72023-79····—NULL2294 Mesa DriveMesaAZ85212GRP-2687MEDICARE-ADV-A
CLMCLM-4176042026-05-30T05:16:48ZArthur—Gibson9/25/1982UHC-31926-06N/A2933056159arthur.gibson98@aol.com—UNKNOWNNULLnullGRP-1746NAVIGATE-HMO
CLM CLM-4181422026-01-22T09:44:29ZOrtega, Alexis——1967-10-25UNKNOWN•••-••-9617(572) 947-8817null·8143 Palm DriveSan Diego··CA92152GRP-1742NULL
CLMCLM-4071332026-03-26T02:56:55ZSofiaC··Thomas··20010506NULL—N/A—4069 River RoadMesaAZ85254-2084UNKNOWNSELECT-EPO
CLMCLM-4247182026-01-25T00:42:40Z·Paul—GordonMay 19, 1954——6838472125—9470 Camelback RoadMiamiFlorida33165-2855GRP-0510OPTIONS-PPO
CLMCLM-418102 2026-03-09T16:33:18ZBRANDON····FISHRE1948-11-15UHC-96270-11—N/A··NULL2689 Lake View RdTucsonAZ85762—null
CLMCLM-4074382026-10-16T14:03:54ZChristopherX.Adams1956-06-26··UHC8879467•••-••-3937-NULL·4764 SPRING STREETAtlantaGA30333·N/AMEDICARE-ADV-B
CLMCLM-4145822026-08-02T19:17:46ZAngela—Munoz1945-02-25—•••-••-3420N/A-UNKNOWN—null——CHOICE-PLUS-PPO
CLMCLM-4297582026-03-06T23:40:03ZBetty—Henderson9179-05-25N/A•••-••-0967(763) 781-6917null··5407 Willow CourtFresnoCA93724N/Acore-hmo
CLMCLM-4135122026-05-13T15:06:28ZMARY—JACOBS19830607nullNULL9477326548—4376 Elm StSan AntonioTX78234·GRP-3048NULL
CLMCLM-405589 2026-09-05T14:17:43Z·Omar—Richardson··1941-06-13UHC-14844-78•••-••-93217725403106OMAR.RICHARDSON42@AOL.COM8804 Baseline Rd·ChandlerAZ85250GRP-3982—
CLMCLM-4294112026-09-25T20:07:33ZRAYMONDJ.DAY··07/02/84—•••-••-97278372569229—8570 Main StMiamiFLNULL··GRP-5920CHOICE-PLUS-PPO
CLM CLM-4293042026-03-03T01:59:39Z·Kimberly—Boyd1994-11-10NULL·NULLNULLNULL5470 Central Ave Apt 34FresnoCA93751N/AN/A
CLMCLM-4151442026-02-06T18:08:22ZpatriciaM.robertson1997-07-11UHC-21505-88•••-••-9376——5703 RIVER RDJACKSONVILLEFL32257NULLCORE-HMO
CLMCLM-4005722026-08-14T03:51:01ZBRITTANY··—LITLE1995-12-18UHC-26464-29—17459504827—·198 ELM STREETColumbusOH43228—MEDICARE-ADV-B
CLMCLM-4294512026-01-25T22:52:00ZMason—Hawkins1943-07-07UHC-57852-17•••-••-7128—null6154 Palm Drive #459TempeArizona85238—·NAVIGATE-HMO
CLMCLM-4218242026-04-29T15:12:24ZJEFFREY—GREEN05/12/58UHC-73338-83NULL···-UNKNOWN6830 CHURCH STREETCOLUMBUSoh43229GRP-5877·NULL
CLMCLM-4081772026-06-04T18:52:51Zjoyce—montgomery··2004-11-13NULLNULL881-371-9477—N/A—·UNKNOWN—GRP-3406—
CLMCLM-4066852026-07-29T10:36:00ZVirginia—Hoffman19470920UHC-79617-30null—NULLN/Anull———MEDICARE-ADV-B
CLMCLM-4101272026-07-23T16:14:32ZWtason—Bruce1956-10-01··UHC-58660-37null959-651-5503UNKNOWNnull-UNKNOWN—-OPTIONS-PPO
CLMCLM-4199102026-01-09T11:25:41ZJudyVWillis1997-06-11nullN/A897-256-2951N/A1681 Highland AvenueNashvilletn37215GRP-8059NAVIGATE-HMO··
CLMCLM-4019512026-08-05T02:37:19ZJUSTIN··—COOPER1943-04-08UHC-19536-68—833.326.6042justin.cooper56@aol.com8956 Baseline Rd·FRESNOCA93724GRP-2805CORE-HMO
CLMCLM-4306352026-04-22T11:18:07ZFRANCES··BURKE04/23/00UHC-81574-06•••-••-7954(766) 743-5344null2627 Desert Sky Blvd #492Mesa·AZ85270GRP-3386CHOICE-PLUS-PPO
CLMCLM-4231762026-03-10T21:09:39ZLucas, Kelly——19471215··UHC-15635-05UNKNOWNN/ANULL6413 Meadow LnSeattleWashington98118GRP-0972—
CLMCLM-4173672026-03-15T22:24:07ZJOYCE—MEDINA18-09-1943UNKNOWN—767-683-3062NULL-—N/ANULLGRP-5286CORE-HMO
CLMCLM-4238222026-10-05T23:22:40ZLARRY—REED11-03-1939null•••-••-7109-N/A4127 Camelback RdMiamiFL··33162nullUNKNOWN
CLMCLM-4254172026-03-16T09:06:54Zsamantha—palmer2008-02-16NULLN/A—-523 Lake View RdLos Angeles·CAN/AGRP-4623MEDICARE-ADV-A
CLMCLM-4287952026-02-08T04:45:06ZJONATHAN—SNYDER19670307UHC-98421-67•••-••-4675NULL—2709 Desert Sky BlvdEden Prairie··MN55343GRP-1920NULL
CLMCLM-4014702026-04-12T08:24:00ZJERRY—PIERCE2004-02-27—NULLUNKNOWN—3308 BASELINE RDPHOENIXArizona85020GRP-3862MEDICARE-ADV-B
CLMCLM-4305492026-06-23T07:59:37ZRachel—Griffin·03/14/97UHC-52956-07•••-••-9792N/A—8748 Hillcrest RoadATLANTAGA30390··UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4120622026-05-08T22:21:44ZSchuultz, Emily——1940-12-09nullUNKNOWN-—8124 Park PlaceDenverCONULLGRP-1436null
CLMCLM-4135632026-04-14T08:43:00ZSOPIHA—ROBERTS1977-02-18UHC-64051-25•••-••-3058UNKNOWN—6874 Canyon RoadMiamiFL33123—CORE-HMO
CLMCLM-4241162026-07-22T00:37:05Z frank—lawrence06/14/92UNKNOWN•••-••-5200234-412-2544UNKNOWN4496 River RoadTucsonAZ85735GRP-4511··CORE-HMO··
CLMCLM-4045862026-07-03T01:53:04ZPriyaOWarren19580619UHC-43262-29•••-••-4169····—7010 Bayshore DrTampaFL33653GRP-2297—
CLMCLM-4081732026-01-15T18:34:23ZKENNETH—KELLLY19660627UHC-11325-94—4895881399··null6640 INDIAN SCHOOL RD #198TUCSONAZ85722GRP-3199CHOICE-PLUS-PPO
CLMCLM-4045892026-01-24T01:44:00Z LawrenceCRay2003-02-01·NULL•••-••-3446····NULL2388 Oak StHOUSTONTX77047—NAVIGATE-HMO
CLMCLM-4125532026-08-05T17:29:59Z·Wayne—Roas02/06/1965N/A•••-••-0148—N/A5328 PINE DRIVEFresnoca93773GRP-5655null
CLM CLM-4087072026-06-09T01:09:59Zemily—martin2000-10-02UHC-21382-50UNKNOWNUNKNOWNN/A7853 Valley View DrTUCSONAZ85746GRP-3736UNKNOWN
CLMCLM-4026122026-07-18T16:52:24ZAdam—Long2008-70-05—•••-••-1437214-603-1253··NULL217 Valley View DrPLANOTX75043GRP-3413-
CLMCLM-4093162026-03-03T01:59:09ZJulieB.Reynolds·2003-09-10UHC-23496-10•••-••-0103(976) 979-2090UNKNOWNN/A····-·UNKNOWNGRP-4940null
CLMCLM-402582 2026-08-21T14:02:53ZPhilipS··Crawford19640816—•••-••-9098305.720.7867UNKNOWN9494 Maple Ave··Los AngelesCA—N/A—
CLMCLM-4166242026-07-16T07:30:26ZVargas, Dennis——16-05-1944-•••-••-1536(722) 599-1475-··5789 Elm St #203GilbertAZ85297-7504GRP-2941CHOICE-PLUS-PPO
CLMCLM-4134992026-05-15T02:49:32ZMARILYN—LONG1948-06-28UHC-02319-99—NULL····4006 BroadwayEden Prairie··MN55374GRP-2117CORE-HMO
CLMCLM-4156992026-01-25T23:19:20ZJudy—Burns1980-12-09——9148205—3367 MAPLE AVE Apt 35··SeattleWA98109GRP-1473—
CLMCLM-4132682026-01-13T16:56:20ZAisha—Garrett··06/27/1972UHC-15941-54•••-••-1704(364) 266-7966nullnull··-·nullN/A—MEDICARE-ADV-A
CLMCLM-4158672026-07-08T13:00:49ZGEORGE—BENNETT1984-02-09null--null4299 Mountain View Dr··OrlandoFL32817GRP-0456NAVIGATE-HMO
32,829 rows, page 196 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.644Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty