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-415534 2026-05-05T22:56:25ZDunn, Kathryn····—2003-01-17UHC-91234-39•••-••-2054758-932-5966NULL6922 Park PlaceDenverCO80261UNKNOWN-
CLMCLM-4105952026-08-18T16:12:00Z BETTY—HUNTER09/07/89UHC-84042-08•••-••-6910(875) 630-2387BETTY.HUNTER89@HOTMAIL.COMnull·UNKNOWN—NULLGRP-7165null
CLMCLM-4281522026-08-15T03:44:52ZYang, Gloria——Feb 3, 1940UHC-03625-33NULL-UNKNOWN9382 INDIAN SCHOOL ROADOrlandoFL32871GRP-9955OPTIONS-PPO··
CLMCLM-4048152026-09-17T14:01:24ZBobby—Rivera7028-19-78UHC-50386-34•••-••-2218——6527 WASHINGTON STREETScottsdale·AZ85236GRP-9532—
CLMCLM-4266512026-01-05T00:20:46ZJoseph····Flores1958-02-10··UHC7064004-(251) 501-9194··—UNKNOWN—N/A—GRP-3511UNKNOWN
CLMCLM-4130712026-09-10T08:08:46ZRoy·P·Munoz20061215-NULL+1 418 522 8008NULL6002 Highland AvePhoenixAZ85083GRP-7958-
CLMCLM-4194582026-08-26T05:03:09ZDIEGO—RAMIREZFeb 21, 1975UHC5724541•••-••-48123237590591UNKNOWN5394 GRAND AVEJacksonvilleFL32247··—N/A
CLMCLM-4100242026-07-14T15:24:16ZChristian—Bowman2007-09-01UHC-31624-32UNKNOWN(555) 876-7508null9778 WILLOW CTLAS VEGASNV89171—OPTIONS-PPO
CLMCLM-4146022026-10-11T02:20:15Zsharon—guzman1994-07-20—•••-••-6360UNKNOWN-··——N/AN/AGRP-3627NULL
CLMCLM-4263692026-10-17T02:14:43ZABIGAIL—CARR··15-10-2000—-511-991-3782-2810 Baseline RoadOrlandoFL32805GRP-0881navigate-hmo
CLMCLM-4322972026-05-07T07:47:08ZSara—Wood—UHC6895487·····7834411944N/A3466 Oak StreetAustinTX78722UNKNOWNnull
CLMCLM-4035742026-04-11T11:26:06ZSANDRA·NHARPER·-UHC-48277-68•••-••-3918801-246-6003—7685 Jefferson AvenueDenver··Colorado·UNKNOWN—··
CLMCLM-4117682026-08-25T15:45:37ZALICE—PRICE10/13/1963null•••-••-2627null—4590 Sunset BlvdAtlantaGA30315GRP-7849medicare-adv-b··
CLMCLM-4072722026-10-03T00:00:20ZStevens, Theresa····—·1954-10-25UHC-14306-89NULL—-9388 Church StEden PrairieMN55377nullOPTIONS-PPO
CLMCLM-4015032026-04-20T06:39:39ZKIMBERLYAMILLER2002-12-17UHC-03074-28··•••-••-3038(597) 732-7599null3861 Ridge RdSacramentoCA95833GRP-7300UNKNOWN
CLMCLM-4234792026-02-01T19:35:26ZBRADLYE····CASTILLO1952-01-27·UHC4751377-null—-—nullN/AGRP-2385MEDICARE-ADV-B
CLMCLM-4111072026-04-11T18:08:57ZCarolDThumas1955-07-27UHC-25221-32•••-••-1105518-470-9440—621 APACHE BOULEVARD Apt 36San DiegoCA92113GRP-2235SELECT-EPO
CLMCLM-4120862026-02-07T11:44:21ZDiego—McDonald3/16/1953UHC-23070-17•••-••-5246(965) 263-9388—2991 Ocean AvenueColumbusOhio43274GRP-3089····
CLMCLM-4257282026-07-22T17:43:40ZWillie—Richardson19741111UHC-00108-35•••-••-9060N/AUNKNOWN——UNKNOWN—-UNKNOWN
CLMCLM-407221 2026-08-09T07:59:18ZBobby—Rose··Jun 22, 2003UHC-53186-56N/A(573) 639-6353bobby.rose@yahoo.com3038 Indian School RoadSeattleWashington98146GRP-2620CORE-HMO
CLMCLM-4220562026-07-18T06:55:28ZEric—Davis2/16/1981·UHC-06409-80•••-••-5779206-416-3928NULL9238 MARKET ST #108·PlanoTX·75090GRP-4665select-epo
CLMCLM-4106652026-05-19T11:43:53ZLAWRENCED.CUNNINGHAMJul 17, 1998-•••-••-6324+1 238 608 1454———··—-UNKNOWN
CLMCLM-4185012026-10-03T20:22:41ZKEITH N.—SIMPSON··2007-11-19UHC-20710-22—UNKNOWN—6732 Church StreetFresnoCA·93776GRP-9873—
CLMCLM-4098782026-08-04T07:22:05ZRUTH—OWNES··19880127UHC3828221•••-••-5615NULLUNKNOWN8039 Washington StreetHoustonTX77015GRP-4372OPTIONS-PPO
CLMCLM-427578 2026-02-01T09:54:54ZDANE—ORTEGA13-07-2003—UNKNOWNN/ANULL913 VALLEY VIEW DRIVEChandlerAZ85233GRP-9324N/A
CLMCLM-4026312026-04-26T01:42:24ZKayla—Hart1966-12-18UHC-59228-60•••-••-9127UNKNOWNUNKNOWNUNKNOWN——-GRP-0395navigate-hmo
CLMCLM-4140042026-04-27T21:23:07ZBerry, Samuel··——1941-01-06UHC-82531-52•••-••-5912—SAMUEL.BERRY44@GMAIL.COM9512 INDIAN SCHOOL RDTampaFL33657—-
CLMCLM-4266372026-09-29T21:49:05ZJESSEPMORENOnullUHC-10876-97N/A(753) 673-0803NULL·NULL-——GRP-7709—
CLMCLM-4046232026-04-20T20:45:23ZTERESA—MENDEZ6/26/1987UHC-99599-84•••-••-473018074200818—4688 Willow Court #540·Chandleraz85258GRP-3178OPTIONS-PPO
CLMCLM-4146172026-03-10T18:02:51ZAlexander···Vasquez19510923—UNKNOWN———····——GRP-4398null
CLM CLM-4276782026-07-08T11:05:39ZSalazar, Ann——Oct 10, 1960UNKNOWNnull—UNKNOWN288 Hillcrest RdPlanoTX·75089—CHOICE-PLUS-PPO
CLMCLM-4314402026-08-19T06:02:19ZJanetISoto1941-09-11UHC-72859-55•••-••-9092211-617-6229UNKNOWN5224 Apache BlvdGilbertAZ85203GRP-2155MEDICARE-ADV-A
CLMCLM-4255862026-03-28T04:48:52ZBetty—Griffin1981-06-15UHC-94146-50NULL(735) 892-9307··3605 WASHINGTON STREETHoustonTX77096GRP-1110—
CLMCLM-4103522026-01-19T18:30:37ZSophia—Riley1997-09-13——16092529332—6447 Union StGilbertAZ85206GRP-6138MEDICARE-ADV-A
CLMCLM-4018702026-01-18T11:51:39ZAlbert··—Rogers21-11-1965UHC0701145null696-400-7555··4423 Lincoln WayScottsdaleAZ85275nullSELECT-EPO
CLM CLM-4005912026-05-02T00:47:17ZLARRY—RICHARDSON1/8/1992UHC-30947-57—(401) 820-2269——null-·-·GRP-5555MEDICARE-ADV-A
CLMCLM-4271202026-05-04T15:27:05ZLISA—GRAHAM08/06/56UHC-69384-55•••-••-0340N/A—6089 APACHE BLVDEden PrairieMinnesota55377GRP-5150NULL
CLMCLM-4262362026-07-20T18:38:17ZAmanda—Castillo1973-04-21UHC-19670-66—5673374819··null8441 Jefferson AveSan AntonioTX78295-4182-··CHOICE-PLUS-PPO
CLMCLM-4216322026-08-30T19:21:12ZWilliam—Burton1962-03-18N/A—(746) 598-8596william.burton35@icloud.com4536 HARBOR BOULEVARDHoustonTX77070GRP-6968CHOICE-PLUS-PPO
CLMCLM-4166512026-01-31T08:43:13ZEmily—Diaz1962-04-24·UHC-27713-43•••-••-9444null—NULLnull-N/AUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4169222026-06-01T14:34:42ZAnthony—Garcia·2008-06-19UHC-44396-53null639.663.6939NULL1099 Baseline Road··DenverCONULLGRP-9493MEDICARE-ADV-B
CLMCLM-4026962026-08-13T02:14:56ZANTHONY—MARTIN23-10-1982——N/Anull2343 Oak StreetPhoenixAZ··—GRP-3074MEDICARE-ADV-A
CLMCLM-407257 2026-07-01T21:03:52ZSUSANC.ESTRADA05/10/58UHC-65247-52•••-••-6060835-609-4075—1971 Highland AveSeattle·WA98119GRP-2504NAVIGATE-HMO
CLMCLM-4319482026-10-14T15:27:20ZKimberly—Ferguson2005-00-96UHC-50163-50•••-••-4593+1 272 934 3576··-9024 MESA DRIVEScottsdaleAZ85247—options-ppo
CLMCLM-4229512026-08-05T04:27:59Zbradley—·bryant12/16/1990UHC-99924-03NULL——3422 LAKE VIEW RDAtlantaGeorgia·30370UNKNOWNMEDICARE-ADV-B
CLMCLM-4307532026-06-01T16:06:16ZWayne—Roberts1976-04-16UHC-40291-13—-UNKNOWN5652 Canyon RdAustinTX78724GRP-6965MEDICARE-ADV-A
CLMCLM-4309882026-07-08T00:56:01Zadam··—sandoval10/27/1953NULLN/A·617.336.3432—1308 Pine DrSan DiegoCA92195UNKNOWNUNKNOWN
CLM CLM-4284722026-03-20T12:45:24ZTerry—Howard02/09/38UHC-55912-89•••-••-0357(349) 982-2887-4948 Washington StJacksonvilleFL32251-4802—UNKNOWN
CLMCLM-4105542026-09-29T19:32:46ZJOE···GREEN16-10-1980UHC-41373-96•••-••-7897NULL-3650 Union Street··FRESNOca93785·GRP-6472-··
CLMCLM-4239502026-10-16T11:16:23ZRAYMOND—·WOODS1996-04-12UHC-91976-08-N/A——null—nullN/ANULL
32,829 rows, page 179 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.616Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty