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-4246872026-02-22T12:58:47Ztresa··—johnson1944-11-06——2097641862teresa.johnson27@icloud.com6582 Ocean AveSEATTLEWashington98152GRP-1683null··
CLMCLM-4290952026-01-12T23:12:08ZDYLAN—WUODS1997-10-14UHC-99767-50····——7062 Indian School RdColumbusOH43253—N/A
CLMCLM-4269752026-07-01T07:04:59ZKevin—Griffin1961-02-19UHC-12460-87•••-••-0506N/AnullNULL········nullGRP-7774-
CLMCLM-4194942026-05-15T23:11:00ZJENNIFER··—FIZHER23-11-1993UHC-26712-13NULL(439) 788-9024-3366 Palm DrJacksonvilleFL32292GRP-8279OPTIONS-PPO
CLMCLM-4004922026-03-09T22:59:24ZRoy··—Butler19751216UHC-98340-50•••-••-5187····UNKNOWN9411 Desert Sky BlvdGlendaleArizona··85310-0942—SELECT-EPO··
CLM CLM-4086862026-02-25T14:24:04ZEvelyn—Ramos1970-12-02—N/ANULL—330 Baseline RdOrlandoFL32832GRP-7522··N/A
CLMCLM-4201172026-05-20T10:41:49ZJose····Mejia1978-12-13UHC-36493-03•••-••-7498—jose.mejia@icloud.com4197 INDIAN SCHOOL RDFRESNOCA93711GRP-1847··null
CLMCLM-4309422026-02-17T11:15:43ZMichelle—Bowman1971-10-24UHC-64949-34•••-••-37493967406707UNKNOWN7317 Oak StreetTAMPAFL33639GRP-4449SELECT-EPO
CLMCLM-4015002026-08-03T07:35:20ZJUDY—NGUYEN1972-11-15·UHC3409390•••-••-6181-—5497 MAIN STColumbusOH43277-NULL
CLMCLM-4165232026-02-09T07:52:06ZvalentinaG.garrett19421117UHC-09961-92———·8627 Willow CourtSan DiegoCA92139-3252GRP-2479OPTIONS-PPO
CLMCLM-4223492026-08-18T11:01:57ZBetty—Dunn1953-10-28UHC-03470-30•••-••-0132—N/A··1582 Bayshore Dr·AustinTX78702GRP-8933N/A
CLMCLM-4209132026-07-06T07:15:18ZFranklin, Richard——····-•••-••-4400——NULL·N/A—UNKNOWNGRP-6885-
CLMCLM-416274 2026-08-18T09:07:50ZSANTIAGO—JENSEN1992-05-26UHC-40660-07··NULL—UNKNOWNN/A—-—GRP-6666·UNKNOWN
CLMCLM-4172142026-03-09T21:01:34ZJack—Campbell1968-03-16UHC-15180-41—(304) 326-0715null1440 GRAND AVELAS VEGASNV89133GRP-1631SELECT-EPO
CLMCLM-4289252026-04-15T09:58:13ZKimberlyT.Bell2003-09-01UHC-86763-22•••-••-2084(597) 903-3704null3424 CENTRAL AVENUE·TempeAZ—GRP-6745MEDICARE-ADV-A
CLMCLM-4024082026-09-07T15:32:01Z JustinJBrooks—UHC4114438•••-••-4927·N/AUNKNOWNUNKNOWNN/AnullN/AGRP-0334MEDICARE-ADV-A
CLMCLM-422441 2026-09-13T05:37:21ZEmma··SilvaJun 11, 1977UHC-22819-36N/ANULL-6272 CHURCH STREETPLANO·TX75038GRP-8265UNKNOWN
CLMCLM-4142862026-02-02T14:24:38ZWatson, Megan—··1975-04-10UHC-62910-31null··——257 Pine DrMiamiFL·33164UNKNOWNnull
CLMCLM-4122152026-09-10T22:10:13ZJoan—MontgomeryJun 7, 2006—•••-••-6819+1 710 901 5776N/A2668 Park Pl·GlendaleAZ85327GRP-7954—
CLMCLM-4169152026-10-13T14:20:14Z Joe—HarveyFeb 27, 1996UHC-44826-03•••-••-8855+1 508 389 8079UNKNOWN8728 Indian School RoadColumbusOH··43296-5034GRP-5450—
CLMCLM-4292812026-08-31T01:28:49ZLORI—·LARSON1949-02-19—-(845) 717-4188NULL195 Cedar LnGilbertAZ85274N/ANAVIGATE-HMO
CLMCLM-417702 2026-07-27T23:30:38ZELIZABETH—STEPHENS1968-07-05··-UNKNOWN671-626-2536N/A5950 Elm StMesaAZ85282··GRP-3390MEDICARE-ADV-B
CLMCLM-4252182026-03-05T14:38:02ZMartha—Hernandez1984-01-07UHC-57008-52nullNULLUNKNOWNN/AN/A—-N/AMEDICARE-ADV-A
CLMCLM-4017432026-06-02T02:36:05ZLINDA—HARPER1977-11-26UHC-73028-18UNKNOWNnullnull7545 Lake View RdHouston··TX77012GRP-5693CHOICE-PLUS-PPO
CLMCLM-4129742026-07-16T03:11:46ZBobby····Rojas1984-02-27UHC-80225-05UNKNOWN790.829.5407NULLUNKNOWN··N/AN/A—GRP-6142MEDICARE-ADV-B
CLMCLM-4277252026-08-19T16:45:28Z AlbertCDelgado08/14/39null•••-••-0115-NULLN/A—NULL·-—UNKNOWN
CLMCLM-4262932026-02-02T09:33:48ZDANECCOX1947-05-26UHC-99365-35··null700.347.1417··—4429 Harbor Boulevard··PhoenixAZ85031·GRP-6817null
CLMCLM-4267382026-02-08T02:42:27ZCamila—Kim19411218—•••-••-8310(612) 274-0058NULL9411 SUNSET BLVDColumbusOH43266GRP-9478··NAVIGATE-HMO
CLM CLM-4316942026-01-27T12:35:51ZMartha—Riley1972-05-20UHC-50441-12N/A982-690-1636N/A3498 Union StLos AngelesCA—N/AOPTIONS-PPO
CLMCLM-4293132026-03-03T12:33:28ZJoseph····Hanson··12/05/1999····UNKNOWN····UNKNOWN3879 Mountain View DriveAtlantaGeorgia30389GRP-2903—
CLMCLM-4204942026-02-14T13:22:33ZKennethRHunter08/15/1975UHC-91822-44—UNKNOWNNULL6735 Broadway Apt 5··MiamiFL33130GRP-3779MEDICARE-ADV-B
CLMCLM-4083432026-09-02T14:53:58ZGloria—Le28-08-1940UHC2629193•••-••-7556·N/AUNKNOWNnullNULL—N/AGRP-9468N/A··
CLMCLM-4078152026-08-14T09:38:07ZMendez, Dinae··—1937-12-13UHC-02276-61UNKNOWNUNKNOWN—6371 Grand AvenueLas VegasNV89191-4502N/Anull
CLMCLM-4052452026-07-06T15:34:24ZHernandez, Keith——11/21/1998··uhc-09533-29•••-••-3044UNKNOWN··—1394 APACHE BLVDScottsdaleAZ85239GRP-1319NAVIGATE-HMO
CLM CLM-4218252026-01-30T06:29:14ZJeffey—Green1958-05-12·UHC-73338-83—6722446085jeffrey.green@outlook.com6830 CHURCH STREETColumbusOH43229GRP-5877··—
CLMCLM-4302082026-08-15T23:33:52ZPaulRCarpenter·1896-02-12UHC-05394-16—789.962.9940NULL3274 DESERT SKY BOULEVARDPlanoTX75044GRP-9975MEDICARE-ADV-A··
CLMCLM-4166672026-04-16T19:59:04ZMatthew—CruzNULLUHC-91463-54—UNKNOWNmatthew.cruz96@proton.me7979 Pine DrEDEN PRAIRIEMN55374GRP-5530····
CLMCLM-4138042026-05-27T16:16:21ZHenry··Johnson19820524——UNKNOWN—8640 WILLOW COURTTucsonAZ··85757GRP-6519N/A
CLMCLM-4213032026-02-01T23:06:49ZCHRIS—FERGUSON20030916NULL•••-••-9415773.531.1242UNKNOWN··541 Sage CtFresnoCA93728GRP-4825NULL
CLMCLM-4220272026-06-10T22:11:39ZCynthia—Jenkins1996-07-15N/A··UNKNOWN——3297 Ridge RdSan AntonioTX78254GRP-4706NAVIGATE-HMO··
CLMCLM-4181622026-06-13T10:25:39ZDOROTHY—BAILEY1964-04-04UNKNOWN—2396766157dorothy.bailey@aol.com9406 CHURCH STPlanoTX75011GRP-4667SELECT-EPO
CLMCLM-4262352026-04-08T02:02:33ZAmanda—Castillo1973-04-21null-(567) 337-4819null-null-N/AGRP-9205UNKNOWN
CLMCLM-4023282026-04-20T16:02:14ZAnnBPerez··1999-12-05UHC-41690-17•••-••-4617N/AN/A·352 Elm StDENVER··CO80229GRP-4509CHOICE-PLUS-PPO
CLMCLM-4018492026-03-23T13:01:51ZJacob—Holmes1993-04-12null•••-••-1501UNKNOWNnull·9299 Apache BoulevardAustinTX78764GRP-0237null
CLMCLM-4303032026-06-09T00:24:05ZPerez, Deborah—··1964-05-16UHC-48065-64-—·nullnull····—UNKNOWN—SELECT-EPO
CLMCLM-4055442026-03-25T11:07:56Z williamSrose12/13/61UHC-42141-56•••-••-5946(895) 310-2756null4362 Ocean AveFresno··CA93762-8702··—
CLMCLM-410277 2026-01-04T22:52:00ZMartha—Wood1995-08-28UHC-81219-28N/AnullnullnullNULL-·--—
CLMCLM-4172802026-06-07T19:55:05ZRUTHLPADILLA5/2/1941UHC-57379-78•••-••-4371+1 629 540 6102—6925 Willow Ct·MinneapolisMN55489GRP-2541·CORE-HMO
CLMCLM-4165952026-04-26T20:26:29ZJames—Rojas10/27/46UHC-49912-59—+1 314 826 0850—·7984 Camelback RdNashvilleTN37206N/ACHOICE-PLUS-PPO
CLMCLM-4029102026-08-06T03:13:28ZJerryBMurray··1986-02-06UHC-55351-47•••-••-0957null—7532 Cedar LnNashvilleTN37277GRP-1291N/A
32,829 rows, page 96 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:37.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty