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-4086572026-06-06T03:08:19ZGLORIA—CLARK21-04-1991UHC-39156-96•••-••-5506(947) 748-9153N/A-··UNKNOWN···UNKNOWNGRP-9483NULL
CLMCLM-4024832026-09-17T11:21:34Zsarah—black···2001-07-06UHC-21561-46•••-••-40559895902102null8146 Bayshore Dr··ChandlerAZ85243GRP-8092NAVIGATE-HMO
CLMCLM-4052082026-07-24T02:49:57ZDelgado, Charlotte——1981-08-19-null(943) 705-6172—8620 Baseline Road #835AtlantaGA30317nullOPTIONS-PPO
CLMCLM-4148632026-09-08T23:52:25ZGLORIADRAMIREZ2008-09-21—•••-••-9612(673) 566-9244—6554 Highland AvenueSeattle·Washington98133—N/A
CLMCLM-4323712026-08-03T06:26:05ZDEBORAH—MASON·Jun 5, 1984—•••-••-7064+1 317 251 0581-3508 DESERT SKY BLVDPlanoTX75081nullN/A
CLMCLM-4017372026-04-09T15:52:52Zjohn—gardner01/21/94UNKNOWNN/A(475) 549-1673UNKNOWNN/AUNKNOWN—N/AGRP-0927NAVIGATE-HMO
CLMCLM-4288472026-01-11T19:07:46Z KELLY—CONTRERAS2004-02-22—null9710356N/A6369 Maple AvenueEden Prairie·MN55346GRP-3939MEDICARE-ADV-B
CLMCLM-4024862026-05-21T09:32:27Z·BRITTANY····WRIGHT1946-05-25NULL•••-••-7380323-408-1265——··—UNKNOWNGRP-9236NULL
CLMCLM-4309122026-05-19T22:35:44ZJoseF.AlexanderJan 13, 1974UHC-74261-41•••-••-9763null··N/AUNKNOWNUNKNOWN—GRP-8952CORE-HMO
CLMCLM-4237912026-07-11T06:59:58ZcoxYsamantha1974-01-03UHC-42367-19•••-••-4003277-290-1430—7598 OAK STDallastx75291··GRP-1983N/A
CLMCLM-4206262026-05-08T22:39:19ZMARK—ESTRADASep 12, 1989·UHC-34804-58-8403991null3650 Apache BoulevardEden PrairieMN55394GRP-3476MEDICARE-ADV-B
CLMCLM-4179142026-05-16T02:02:23Zjudith—westJul 26, 1965UNKNOWNUNKNOWN-judith.west37@hotmail.com9842 BroadwayGilbertAZ85238-3538GRP-7381··CORE-HMO
CLM CLM-4301032026-01-03T13:51:11ZScottBHowell1997-12-18UHC0408062UNKNOWN—··——·nullnullGRP-6160—
CLMCLM-4279032026-04-24T04:42:48ZrebeccaYbennettApr 14, 1961UHC-24020-26NULLNULL—5489 Elm StreetTempeArizona85284—N/A
CLMCLM-4322922026-01-11T16:09:10Z·Nathan—Hernandez1961-20-12UHC-99827-06•••-••-5373NULL—7224 Cedar Ln #282ColumbusOH43227NULLUNKNOWN
CLMCLM-4171152026-06-10T14:58:24ZJulia—Morales19470725——N/Ajulia.morales@icloud.com8972 Central AvenueTucsonAZ85781—OPTIONS-PPO
CLMCLM-4099482026-09-12T16:30:54ZMARIANA—JONES2004-04-06—•••-••-3302+1 264 336 7260—4073 Union StreetTucsonAZ85753nullCHOICE-PLUS-PPO··
CLMCLM-4242732026-06-29T02:19:29ZMcDonald—Kathryn—UHC-36310-12—+1 841 403 9999N/A7145 Elm StPhoenixAZ85060N/ACORE-HMO
CLMCLM-4034482026-04-24T13:46:01ZMATEO—JOHNSON1986-09-05UHC-24566-34··—NULL—9534 SPRING ST··San DiegoCA92184-9280—N/A
CLMCLM-4106452026-04-29T22:50:47ZMateo··—Marshall19670102UHC-89509-52··•••-••-9703886-722-8530UNKNOWN1770 WILLOW CTDALLASTX75265-CORE-HMO
CLMCLM-4161002026-09-21T12:19:34ZYukiA.Marquez11/13/75UHC-38069-86•••-••-1961—NULL5165 Mountain View DrHOUSTONTX77077-5468··GRP-5470NAVIGATE-HMO
CLMCLM-4146752026-08-25T10:52:11ZSophia··—SandovalMay 26, 1964N/A-2657049567sophia.sandoval60@icloud.com5489 Jefferson AveSan DiegoCalifornia·92190GRP-3712CHOICE-PLUS-PPO
CLM CLM-4309042026-02-21T18:09:57ZDOUGLAS—ELLIS1981-09-08UHC-82981-54UNKNOWN(688) 943-4064N/A—N/AnullNULLGRP-4017medicare-adv-b
CLMCLM-4213782026-03-18T20:49:55ZDYLANLBOWMAN19840622-null(438) 697-6432—2383 Cedar Lane·JacksonvilleFL32237GRP-9635—
CLMCLM-4186562026-06-05T00:17:27Zgary—tucker2000-00-64UHC-38611-50——NULL5434 Desert Sky BlvdORLANDOFL32853N/A-
CLMCLM-4179532026-03-27T00:00:04ZROGER—BISHOPNov 1, 1975UHC-09109-88··•••-••-3051-roger.bishop@gmail.com5376 Bayshore DrLos Angeles···CA90063N/ANULL
CLMCLM-4264922026-05-13T23:55:20Zamanda—mcdonald1961-09-28UHC-80724-56—3074863789UNKNOWN6337 Apache Boulevard··MIAMIFL33178UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4176532026-08-09T17:01:29ZedwardHdominguez19720507UHC-99922-82—(833) 330-7288UNKNOWN7510 OAK STMesaAZ·85219NULLoptions-ppo
CLMCLM-4291122026-09-30T13:16:50ZNathan—Greene7/11/1999UHC-46806-74—3653209—UNKNOWN-nullN/ANULL—
CLMCLM-4230202026-05-06T19:19:34ZLuis··Gonzales1939-08-26UHC-00878-25NULL-—4733 Canyon RdAtlantaGA··30339GRP-7574MEDICARE-ADV-A
CLMCLM-4089982026-03-29T12:48:17ZMarthaF.Nunez08/07/1972UHC-26130-11NULL····3308 Maple AvenueNashvilleTN37246GRP-3541MEDICARE-ADV-B
CLMCLM-4042232026-07-16T22:57:13ZJONATHANF.WELLS4/19/1996UHC-50263-53•••-••-3593UNKNOWN—9341 Church StreetSeattleWA98160-MEDICARE-ADV-B
CLMCLM-4213222026-01-20T01:01:35ZChapman, Bobby——2004-02-20UHC-80403-78•••-••-8564418-872-0773··UNKNOWN·2613 Cedar Ln·AUSTINTX78739··—null
CLMCLM-4170682026-03-21T00:21:05ZSara—Wagner·1987-08-20UHC-73875-97•••-••-6745(382) 654-6186sara.wagner66@icloud.com7609 Sage CourtPLANOTX75025GRP-6989—
CLMCLM-4054212026-10-18T23:09:51ZSOPHIA—NUNEZ5/12/1963UHC-17485-17-477-392-5452—·9531 Cedar LaneAustinTX78766GRP-1185MEDICARE-ADV-B··
CLMCLM-4252642026-07-02T21:09:14ZOmarJMendez1980-09-18UHC-18365-70N/AN/A—6109 BroadwayPhoenixAZ85004GRP-6352NULL
CLMCLM-4271342026-07-30T22:32:09ZCarolyn—Sullivan06-02-1992UHC-26152-56—9034196631—695 INDIAN SCHOOL RD Apt 18TEMPE·Arizona85280GRP-9692MEDICARE-ADV-A
CLMCLM-4188402026-10-03T14:08:11ZJonathan—AguilarMay 10, 1951UHC-85529-50null-—2803 Palm DrSeattleWashington98184GRP-6611SELECT-EPO
CLMCLM-412256 2026-09-04T04:33:54ZJacob—Chen1968-10-20--(905) 624-5910·-8375 Camelback RoadEden Prairie·Minnesota55354··NULL—
CLMCLM-4200202026-10-09T00:00:30ZAngela—Lopez1994-07-26UHC-47375-08··•••-••-8146UNKNOWNnull7803 CANYON ROADHoustonTXN/AUNKNOWNN/A
CLMCLM-4279832026-02-23T13:28:08ZAbigail—Rios1979-05-26——-—·5815 BAYSHORE DRIVESan Antonio··TX78296GRP-8666SELECT-EPO
CLMCLM-4327002026-05-19T13:39:36ZRebecca—Salazar1944-09-24··—NULL-UNKNOWN5115 Grand AvenueGlendaleAZ85358—NULL
CLMCLM-4147362026-01-22T15:16:19ZHicks, Johnny——1949-02-26UHC0869371—4809016447UNKNOWN··582 Ocean AvenueAUSTINTX78737-null
CLMCLM-4316732026-03-29T09:44:32Z JACQUELINE—SINGH02/07/06-N/A579-610-3169N/A4215 CHURCH STTampaFL33693GRP-1812·choice-plus-ppo
CLMCLM-4051832026-03-15T03:20:08ZLisaDGilbert1950-09-21UHC-20142-82•••-••-8161(313) 268-5372——N/A—·UNKNOWNGRP-5644NULL··
CLM CLM-4310512026-10-16T13:17:37Zandrew··dean1946-06-15-N/AUNKNOWN-8626 RIDGE ROADScottsdaleAZ85225GRP-3916CHOICE-PLUS-PPO
CLM CLM-4008092026-09-23T21:57:11ZSooto, KathleenS—Oct 26, 1939··uhc-10461-05•••-••-0075(843) 970-4719kathleen.soto91@outlook.com7986 Oak St·San Antoniotx78293GRP-4307·NULL
CLMCLM-4037312026-04-30T22:59:57ZJessica—Alexander1939-07-15··•••-••-7390NULL··jessica.alexander76@icloud.com··3491 Pine DrAtlantaGA30323UNKNOWN—
CLMCLM-4284942026-05-06T01:16:32ZTyler—·Peters2001-11-01UHC3264322NULLnullN/A1544 Market StFresnoCA93738-N/A
CLMCLM-4317362026-07-29T03:17:25ZARTHUR—VALDEZ1996-08-18N/A•••-••-2638(429) 667-4000UNKNOWN··8255 Ocean AveColumbus··OH43201GRP-8591OPTIONS-PPO
32,829 rows, page 161 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.354Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty