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-4036512026-09-23T23:00:09ZEVELYN—RAY1914-10-09UHC-12550-93—231-329-0812evelyn.ray@proton.me1967 Camelback Road Apt 33Eden PrairieMinnesota55330GRP-1586-
CLMCLM-4227172026-09-26T22:28:34ZPamela··Hayes1964-02-25UHC-52829-16NULLUNKNOWNUNKNOWN2372 Elm Street··SAN DIEGOCA92174GRP-0211CHOICE-PLUS-PPO
CLMCLM-4272172026-09-15T11:48:27Zamanda—peters12/05/71N/A•••-••-2614nullNULL4865 Willow CtPhoenixAZ85031—CHOICE-PLUS-PPO
CLMCLM-4297662026-08-08T08:31:01ZKathryn—Fields8/22/1981UNKNOWN•••-••-4494847-840-2736-7747 Park PlacePlanoTX75014null—
CLMCLM-4268912026-09-11T12:35:36ZNATHAN—SANCHEZ1961-05-19UHC-99030-18N/A····--—NULLnullGRP-1330OPTIONS-PPO
CLM CLM-4271682026-02-14T09:56:39ZDoris—Pierce1947-07-28NULL•••-••-2335+1 663 853 8637·DORIS.PIERCE90@GMAIL.COM9815 PALM DRIVEAtlanta··Georgia30396GRP-9641—
CLM CLM-4195012026-09-13T21:20:32Z·LoganGJohnstonApr 10, 1982UHC-39291-39-——4558 Willow CtDenverColorado·80253——
CLMCLM-4254122026-03-27T03:44:30ZVirginia—RobiinsonDec 27, 1960UHC-28567-27null7412496134-8730 WILLOW CTPhoenix··AZ85088N/ACORE-HMO
CLMCLM-4155692026-01-01T05:21:36ZTimothy—·Brown1962-05-07UHC-81996-24N/A—N/A2918 HIGHLAND AVE #420CHARLOTTENorth Carolina28209GRP-2900N/A
CLMCLM-402860 2026-02-06T20:28:32ZRandy—AutsinOct 15, 2002UHC-90305-60····-—2466 PALM DRLAS VEGASNV89182—N/A
CLMCLM-4303782026-01-16T21:35:17Zbrenda····parker19591224UHC-50412-36——····6506 Elm StAustintx·78775GRP-7767-
CLMCLM-4292462026-05-03T13:33:14ZSTEPHANIE—THOMAS1975-08-01-N/A731-201-2011—4840 Elm StreetEden PrairieMN55390GRP-0844·OPTIONS-PPO
CLMCLM-4230772026-05-12T23:19:05Zroger—powell1993-07-07UHC-24883-81-N/A—7669 Lincoln WayEden PrairieMN55350GRP-0284null
CLMCLM-4108822026-04-16T01:08:35ZABIGAIL—GRAY1998-07-12UHC-91906-99NULLN/AUNKNOWN3479 MARKET STREET Apt 28NashvilleTN37292GRP-6996··—
CLMCLM-4221302026-03-31T00:05:53ZSamuel—Martinez··1993-04-08UHC-56424-34···nullnullsamuel.martinez91@proton.me8593 JEFFERSON AVEEDEN PRAIRIEMN55338GRP-1429NULL
CLMCLM-4111662026-08-27T17:07:29ZMorrison, JoseB—·1962-08-14UHC-74741-25•••-••-7863+1 624 231 2131-3629 Park PlaceTUCSONAZ85771GRP-0115UNKNOWN
CLMCLM-4157432026-10-06T22:58:37Zcharlotte—chavez2001-08-05UHC-16131-08N/A-—UNKNOWN-N/ANULLN/AUNKNOWN
CLMCLM-4068892026-07-24T13:39:02ZPRIYA—COOK1956-08-04··—•••-••-0412+1 859 390 1606—8550 CEDAR LNEden PrairieMN55326GRP-2513—
CLMCLM-4025092026-07-02T21:48:57ZOlivia—Vasquez01/14/39-null——8259 Ocean AvenueLAS VEGASNV89156-—
CLMCLM-4168782026-02-23T10:39:03ZJake—Little1974-07-12UHC-14867-13NULL—NULL2649 INDIAN SCHOOL RD·HOUSTONTX77023-7430N/AUNKNOWN
CLMCLM-4074772026-03-18T12:03:20ZSARA—REYES1971-04-01—•••-••-7202——7738 OCEAN AVECharlottenc28224····null
CLMCLM-4150512026-02-22T02:01:27Z KATE—JACOBS1996-08-05UHC-26509-84UNKNOWN—katherine.jacobs15@gmail.com2059 Main StreetScottsdaleAZ·85221··CHOICE-PLUS-PPO
CLMCLM-4086792026-07-07T15:10:32ZJanice·K.Burton1956-04-03UHC-20074-87•••-••-8240226-510-9137UNKNOWN5988 Baseline RoadSeattleWA—GRP-6856·CHOICE-PLUS-PPO
CLMCLM-4169822026-01-02T23:00:39ZDoris—Garrett2002-02-22UHC-97274-60•••-••-7022794-966-9473———··-··GRP-5653·CORE-HMO
CLMCLM-4007992026-03-23T07:31:03Z LAURA—SULLIVAN1974-11-11UHC-42409-28N/A—-1021 Highland Avenue·AtlantaGA30378GRP-0680—
CLM CLM-4260872026-02-26T15:24:01ZGARY—FREEMAN03-10-1972UHC-26226-69•••-••-9954nullN/A8770 Maple AveGlendaleAZ·85338GRP-4566NULL
CLMCLM-4079092026-05-18T21:16:14ZMICHELLE—LEE02/03/1952——12468883201—NULLnull—N/A·GRP-9051CHOICE-PLUS-PPO
CLMCLM-4272702026-01-08T01:03:08Zkyle—myersOct 21, 1982UHC-86503-69-(811) 735-4532NULL2974 Ridge RdMesa·AZ85211GRP-3512NULL
CLMCLM-4144192026-09-14T16:14:49ZTheresaEHudson1960-01-24UHC-74120-88UNKNOWNNULL——N/AUNKNOWNUNKNOWNN/ANULL
CLMCLM-4078202026-03-19T05:15:52ZHunt, Russell——19610913UHC-20464-99—null·N/A6588 Highland AveTampa··FL33604GRP-2112CHOICE-PLUS-PPO
CLMCLM-4132502026-02-27T15:44:53ZSUSAN—ADAMS09/01/1992UHC-39910-13UNKNOWN·UNKNOWNUNKNOWN8014 Valley View DriveMinneapolis·MN55410NULLOPTIONS-PPO
CLMCLM-4200052026-04-10T12:59:12ZSims, Angela—····08/22/05null—NULLN/A—-··null·nullUNKNOWN·CHOICE-PLUS-PPO
CLMCLM-4180692026-06-24T23:44:45ZHIROSHIT.ORTEGA1992-05-26UHC-13898-70•••-••-5737570-803-9620—·3773 Palm DriveDallas··TX··75266—·null
CLMCLM-4209112026-06-03T21:22:17ZChrisopherLCastro2005-02-27UHC-53454-40N/A3014325148-1841 Maple AvenueLas VegasNV——NAVIGATE-HMO
CLMCLM-4277812026-01-13T09:08:25ZRobert—Bryant1972-12-14—•••-••-9027958-423-7385··UNKNOWN··nullnullnullGRP-3056UNKNOWN
CLMCLM-4206642026-05-31T07:50:51ZThomas—Scott1970-07-24UNKNOWN-713-474-7562—2385 Park PlaceEden PrairieMinnesota55374GRP-7552CORE-HMO
CLMCLM-4101712026-05-29T09:13:33ZLauren—Gutierrez01/04/89—·N/A+1 854 588 2955N/A9548 BROADWAYOrlandoFlorida32831····—
CLMCLM-4291532026-10-06T03:12:31ZANNA—·WALLACE1940-10-14UHC-03491-04—null—2854 Sage CtGLENDALEArizona85304GRP-9920····
CLMCLM-4102702026-09-22T08:50:25ZREBECCA—ELLIOTT1951-07-04N/AUNKNOWN—··1001 Lincoln WayColumbusOH43213GRP-9596UNKNOWN
CLMCLM-4021712026-03-20T00:53:27ZKathryn—Stone1968-08-16UHC-92523-76UNKNOWN·nullNULL4756 Pine DriveSeattleWA98131nullCHOICE-PLUS-PPO
CLMCLM-4191052026-01-06T13:30:45ZReid—Gregory1943-07-18NULL·UNKNOWN(676) 884-3380null2914 Maple AvenueAtlantaGA30399GRP-7587SELECT-EPO
CLMCLM-4101222026-06-17T11:30:11ZabigailN.hicks8/17/1970··UHC-60211-80NULL·(760) 333-7570UNKNOWN·5753 Union StreetMiamiFL33105·GRP-1170—
CLMCLM-4015792026-09-25T05:41:27ZLisa——24-01-1947UNKNOWN•••-••-7750(203) 253-7680N/A1205 Apache BlvdMinneapolisMN55427GRP-9572-
CLMCLM-4313712026-05-17T17:28:58ZWilliam—Collins1973-01-09UHC-41025-03—null-N/A—····UNKNOWNGRP-5135MEDICARE-ADV-A
CLMCLM-4234652026-09-19T19:04:11ZAMBER····WILLISnullnull····8049432313—9561 Mountain View DrSacramentoCA95848GRP-1948N/A
CLMCLM-4199942026-08-19T05:55:52ZDbraHColeman1972-03-28UHC-55489-25•••-••-9215·-—6947 Ocean AveTempeAZ85277-0531··null—
CLMCLM-4282732026-07-20T18:20:42Zcheryl—yang03-02-2003UHC-63563-16——····nullN/AnullN/A——
CLMCLM-432171 2026-04-27T16:32:49ZCarter, Betty——1951-10-06UHC-07539-83•••-••-1012(574) 481-8192N/A5996 BroadwayTucsonAZ·85712GRP-9415CORE-HMO
CLMCLM-4094192026-09-21T16:00:11ZROBERTBEDWARDS20040711-··(286) 616-3981N/A3734 Desert Sky BlvdAustin·TX78732GRP-1359·NAVIGATE-HMO
CLMCLM-4065062026-09-21T02:39:06ZGEORGE··GREENE1953-01-17··UHC-46228-14NULL-NULLN/AnullNULLnullGRP-2094SELECT-EPO
32,829 rows, page 154 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.343Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty