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-4235592026-05-06T15:36:04ZDAVID—BROOKS06-05-1939—•••-••-3019——5972 Jefferson AvenueJacksonvilleFL32262GRP-1199·CHOICE-PLUS-PPO
CLMCLM-4174832026-03-10T17:03:02ZAMBER—ORTEGA23-12-1979·--NULLAMBER.ORTEGA62@GMAIL.COM8545 Indian School RdHoustonTX77009GRP-2249—
CLMCLM-4083632026-05-02T22:28:51ZALBERT—·HERRERA02/01/79UHC-78925-85•••-••-4996UNKNOWN-5972 Baseline Road··CharlotteNC28221GRP-6426MEDICARE-ADV-A
CLMCLM-4028192026-02-15T06:08:02ZDanielle—Perry1981-01-25UHC-15283-06•••-••-2817-N/A··372 Church StreetDenverCO80253GRP-6357OPTIONS-PPO
CLMCLM-4269732026-09-10T11:04:29ZKEVIN—GRIFFIN1961-02-19UHC-12460-87N/ANULLnull4476 Central Ave·MesaAZ85204GRP-7774MEDICARE-ADV-A
CLM CLM-4003232026-07-23T22:18:25ZGarrett, Peter——03/11/81NULL-3327854244—8443 Oak StreetFresnoCalifornia93783··GRP-7534OPTIONS-PPO
CLMCLM-4310472026-02-18T00:13:15ZBrittany··—Taylor1941-05-07UHC-11983-40··NULL(940) 329-9157-3835 Ridge RdTEMPEAZ85298GRP-8589-
CLMCLM-4211042026-03-11T23:00:11ZLAURA··WHITE1957-09-20UHC-39998-25—nulllaura.white@hotmail.com693 Lincoln WayHoustonTX77007-8469——
CLMCLM-4220902026-04-17T05:35:44ZVincentJ.Lewis01/22/1974UHC-03258-65•••-••-7937UNKNOWNnull··9102 Grand AveCharlotteNC28239NULL-
CLMCLM-4144312026-03-25T06:49:18ZJUSTIN—SNYDER·02/25/1941UNKNOWN··—UNKNOWN··—6092 Ocean AvenueScottsdaleAZ85205GRP-4887NULL
CLMCLM-4246972026-03-10T00:27:09Z·BARBARA—JACKSON1999-07-19N/A•••-••-2284(872) 429-8088—5187 MOUNTAIN VIEW DRIVESACRAMENTOCalifornia95842GRP-4956CHOICE-PLUS-PPO
CLMCLM-4207882026-08-24T21:02:09Z janice—parker1999-11-16UHC-98137-03•••-••-9986—UNKNOWN5557 Union StLas VegasNV—·GRP-8661OPTIONS-PPO
CLMCLM-4085182026-06-20T09:38:36ZFRANK—DIAZ1999-04-24UHC-16569-25•••-••-8504UNKNOWNN/A7982 Sage CourtColumbusOH43212GRP-6604—
CLMCLM-4119462026-05-10T00:47:33ZElijah—Wood1989-00-76UHC-50101-19•••-••-8404N/AN/A2755 Sage CourtGlendaleAZ—null—
CLMCLM-4201822026-02-28T13:00:46ZDIANALESTRADA1987-06-14UHC-43137-75•••-••-55237742854-———NULLGRP-1865—
CLMCLM-4302602026-08-20T04:56:24ZDiane··King08/01/57UHC-90667-34NULL-null··864 Church StFresnoCA93762GRP-4762SELECT-EPO
CLMCLM-4316282026-02-26T01:19:14ZDoris—·Carter1972-06-24UHC-01850-59—972-974-8519N/AUNKNOWN———UNKNOWNSELECT-EPO
CLMCLM-4001212026-02-25T04:23:48ZSofia—Lawsun09/07/63UHC6841531NULL··NULL—-·UNKNOWN-N/AGRP-7674null
CLMCLM-4258732026-03-30T20:30:49ZJudy—Rogers1984-01-17NULL•••-••-1065N/A—1643 BAYSHORE DRPlanoTX75048GRP-6566NULL
CLMCLM-4229952026-02-14T20:49:59Z·PATRICIA—MARSHALL··06/08/81··UHC-92316-19•••-••-88656124428236null·7133 Cedar Ln·HoustonTX77072·GRP-1390MEDICARE-ADV-A
CLMCLM-4033562026-07-02T05:46:59Zrachel—hart·1963-10-16UHC-02912-42nullnull··—8973 Indian School Road Apt 4HoustonTX77055null·CORE-HMO
CLMCLM-4322642026-05-24T05:54:01ZBRYAN—VARGAS01/19/91—•••-••-8150—-6311 Sunset Blvd·Las Vegasnv89101GRP-8767N/A
CLMCLM-4207412026-02-26T04:28:05ZBanks, Carl——19801120UHC-01367-28··•••-••-0491—NULL6504 MOUNTAIN VIEW DRIVEMinneapolisMN55467GRP-2108—
CLMCLM-4317902026-09-19T10:56:33Zdennis—hart06-01-1980UHC-45131-07—257-698-4525N/A8743 Maple Avenue·MesaAZ85254—NULL
CLMCLM-4007772026-06-20T02:17:50Z·MELISSA—ALEXANDER·1944-21-03uhc-11511-21··•••-••-8026—N/A8745 Ocean AveCHARLOTTENorth Carolina28210GRP-2708NAVIGATE-HMO
CLMCLM-4092872026-03-16T01:50:00Z JUAN—HOFFMAN05-10-2000—·N/Anull—2964 DESERT SKY BLVDDENVERCO80240GRP-3567—
CLMCLM-4082952026-01-25T12:07:57Zgrace—cox19-03-1962UHC-73907-70•••-••-334018353519760—N/Anull-····GRP-2201CORE-HMO
CLMCLM-4102002026-02-19T12:35:08ZBell, Danielle—····1959-12-08UNKNOWN•••-••-3275UNKNOWNUNKNOWN7586 Spring StreetOrlandoFL··32807GRP-2091—
CLMCLM-4172422026-04-29T14:42:47ZMARGARET—LITTLE·09/24/2008UHC-99842-43•••-••-271418434023832margaret.little@outlook.comN/A··UNKNOWNN/A—GRP-3098··NAVIGATE-HMO
CLMCLM-4255102026-02-22T19:22:39ZAaron—Watkins12/08/67UNKNOWNNULL8128553N/A7721 MAPLE AVESacramentoCAUNKNOWNGRP-5017—
CLMCLM-4097052026-07-04T17:16:53ZReid, Brian····—1972-04-13UHC-22030-18—279-212-0513UNKNOWN7920 Valley View Drive·ORLANDOFLNULLUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4228782026-03-13T09:28:35ZGabriel—Price··1959-11-11UHC-79021-88•••-••-5239·755.981.8132—9889 Washington Street·MINNEAPOLISMN55445-NAVIGATE-HMO
CLMCLM-4138652026-07-03T13:32:44ZOmarQ.Mason1987-04-02null•••-••-3323UNKNOWNN/A··8246 Union StreetMinneapolisMN55445-—
CLMCLM-4180102026-04-15T22:37:26ZWard—Carol10/01/1970-—872-435-8282—8776 Mesa Dr··HoustonTX77061GRP-3259SELECT-EPO
CLMCLM-424059 2026-04-22T22:47:35ZBlack, Kyle—···11/16/1992-NULL—-7088 Hillcrest Rd·SAN ANTONIOTexas78245-6824nullOPTIONS-PPO
CLMCLM-4198152026-01-10T23:10:26ZRICHARD—ELLIUTT03/28/65UHC-99835-59NULL···N/Arichard.elliott48@gmail.com5139 Ridge RdDALLASTX75223GRP-8846NULL
CLMCLM-4214892026-07-18T21:32:09ZPHILIP—SIMMONS·1967-10-13UHC-94170-33•••-••-2865(450) 497-3934-4893 Maple AveEden PrairieMN55379-1719GRP-2425choice-plus-ppo
CLMCLM-427336 2026-10-06T07:10:40ZKELLYOTUCKER1999-01-03·UHC-00488-72nullUNKNOWNnull4186 CENTRAL AVENUEChandlerAZ85219GRP-7727NAVIGATE-HMO
CLMCLM-4033772026-04-15T20:25:57ZVazquez, Roy——1941-01-06UHC-90646-48N/A(735) 623-3476—6604 CENTRAL AVENUE··AustinTX··78757GRP-3414UNKNOWN
CLM CLM-4202242026-02-10T06:46:33Z·Diego··Lawrence2005-03-13null—446.504.8557··NULL1001 Hillcrest RdTEMPEAZ85203UNKNOWN·OPTIONS-PPO
CLMCLM-4167782026-02-03T12:01:22ZLi, Adam——1/18/1945UHC-03793-43N/A-N/A51 Oak StreetHoustonTX77050-3521GRP-0546-
CLMCLM-4317252026-08-16T19:59:04ZAhmed—Sims19720707UHC-36382-81null-null7759 Harbor BoulevardDallasTX·75257GRP-4113MEDICARE-ADV-B
CLM CLM-4050072026-08-15T13:36:24ZBillyXMendez1959-05-15UHC-86409-59N/AN/ANULLUNKNOWNnull··nullGRP-8845···OPTIONS-PPO
CLMCLM-4135612026-03-17T05:26:21ZCheryl—WardOct 26, 1986UHC-46150-37··—N/A··1170 SPRING STREETNashvilleTN37258·GRP-7821CHOICE-PLUS-PPO
CLMCLM-4030192026-04-07T17:37:18ZNancyS.Vazquez··1967-08-27UHC-61543-39•••-••-8173null—4030 MAPLE AVE Apt 21ScottsdaleArizona85207-8971GRP-4602null
CLMCLM-4174972026-05-22T18:33:13ZTyler—Perry1976-09-27NULL—null—6993 PALM DRLos AngelesCA··90060-··
CLMCLM-4117692026-01-26T20:03:26ZALICE—PRICE19631013null···-·-4590 SUNSET BLVD··AtlantaGA30315GRP-7849-
CLMCLM-4310782026-08-27T16:17:04ZSharon—Lewis06/20/82UHC-19056-83•••-••-9090(903) 526-6511—7383 Central AveHoustontx77018N/ANAVIGATE-HMO
CLMCLM-4073442026-04-22T11:54:03Z·Douglas—James1943-06-02UNKNOWN•••-••-0937UNKNOWNUNKNOWN8274 Ocean AveTEMPE·AZ85235·GRP-3231MEDICARE-ADV-B
CLMCLM-4169462026-07-04T21:44:08Zralph—montgomery1512-91-92nullnull······N/A4474 SAGE COURT Apt 36MESAAZ85254—·NAVIGATE-HMO
32,829 rows, page 111 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.472Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty