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-401075 2026-09-02T19:12:33ZJANET—SANCHEZ2007-08-22UHC-19523-28··—····N/AN/ANULLUNKNOWN———
CLMCLM-4093422026-10-09T01:51:24ZFatima··—Coleman1981-12-02UHC-25318-23UNKNOWN-—·4474 Sunset BoulevardLos AngelesCA90061-7557GRP-6649N/A
CLMCLM-4222322026-03-10T11:11:43ZHiroshi—Schultz1978-07-23null•••-••-17359873904263—2330 Palm DrPhoenixAZ85079GRP-0570NULL··
CLMCLM-4034812026-06-29T06:43:18ZHIROSHI—·WOOD1960-10-20—•••-••-3802N/A—8320 RIVER ROADEden PrairieMNnullGRP-5947OPTIONS-PPO··
CLMCLM-4095322026-06-05T17:25:49ZNency—Salazar19810305UHC-90313-65•••-••-06148346663805—4822 Sunset Boulevard #686··ColumbusOH43220GRP-6388CHOICE-PLUS-PPO
CLMCLM-4327012026-09-23T10:17:49Zkatherine—silva1967-06-26··UHC6178952UNKNOWN—UNKNOWN1917 Palm DriveHoustonTexas·77040GRP-1684-
CLMCLM-4169312026-07-10T12:18:47ZNATHAN—GONZALES··20060218UHC-41893-36•••-••-46906422183948NULLUNKNOWN—N/Anull-CHOICE-PLUS-PPO
CLMCLM-4042942026-04-04T22:56:15ZGray, Carlos——1941-08-12UHC-64484-73•••-••-6937728.631.5196—8227 Grand AvenueSan DiegoCA92146···MEDICARE-ADV-B
CLMCLM-4086952026-01-08T12:49:51Z·AishaAAllen1979-02-22UNKNOWN—748-601-1768null··6345 MEADOW LANESCOTTSDALEArizona85262GRP-9141CHOICE-PLUS-PPO
CLMCLM-4001722026-09-02T04:24:33ZSeanV.Cook1984-03-16UHC-89407-02—3352703469N/A9409 Valley View DriveJacksonville··FL32210—UNKNOWN
CLMCLM-4267182026-06-24T19:10:47Z thomas··—alexander1977-06-25UHC-06171-62null(532) 317-5285N/A—null-null—NULL
CLMCLM-4037102026-10-18T07:08:07Zketih···vazquez1965-05-23UHC-01356-46—12096682567NULL6164 Grand AvenueScottsdaleArizona85299—MEDICARE-ADV-B
CLMCLM-4090402026-06-20T13:16:32Zcatherine—butler27-04-1956NULL—(423) 954-9224—9460 Meadow LnPhoenixAZ85024GRP-9046SELECT-EPO
CLMCLM-4063702026-06-13T19:40:32Z CARLOS—·AUSTN1990-08-02—•••-••-1174NULLnull7112 MESA DRPhoenixAZ85026-0761NULLN/A
CLMCLM-4258242026-01-15T23:28:21ZKathryn—Williams15-08-1970—•••-••-8747null—605 Washington St··Eden PrairieMinnesota55370·GRP-6244-
CLM CLM-4049612026-09-28T06:11:56ZAlvarez, Scott—·····05/08/1953uhc-73594-80UNKNOWN13902090365SCOTT.ALVAREZ@AOL.COM1011 Ocean AvenueDenverCO80221GRP-5167CHOICE-PLUS-PPO
CLM CLM-4004242026-07-27T05:26:14Zrussell··U.rojas1997-01-15UHC-60967-93N/A(858) 942-3947-N/A—N/A—GRP-5571CORE-HMO
CLMCLM-4145262026-08-21T11:56:51ZMariana—Evans1997-10-27—UNKNOWNUNKNOWN—9718 River RdNashvilleTN37251GRP-8533OPTIONS-PPO
CLMCLM-4267432026-05-14T02:57:41Z·BRENDA—BUTLER·1947-12-28—•••-••-2771nullbrenda.butler@gmail.com·3051 Church StLos AngelesCA90027GRP-8076CHOICE-PLUS-PPO
CLM CLM-404608 2026-04-01T02:49:17ZJudy—LongMay 20, 2001UHC-14892-64····803.712.9786null4143 Apache BoulevardGilbertAZ85272-5229··null—
CLMCLM-4023932026-04-01T04:03:01ZCARL—MORALESDec 15, 1979UHC-86655-79UNKNOWNN/Anull————GRP-7452N/A
CLMCLM-4016482026-01-05T07:53:11ZMariana—HillSep 18, 1943UHC-13011-56UNKNOWN——9584 Forest AveFresnoCA93735··GRP-2352NAVIGATE-HMO
CLMCLM-4121092026-06-24T21:12:56ZNunez, Mrailyn—··Aug 16, 1974N/AN/A(489) 716-4544marilyn.nunez64@gmail.com··4466 BroadwayJacksonvilleFL32235·-—
CLMCLM-4275792026-08-31T18:12:01ZKatherine—Palmer1982-02-11UHC-33792-42·-13537404409NULL4419 CAMELBACK ROADPlanoTX75047GRP-2288NAVIGATE-HMO
CLMCLM-4315932026-04-17T06:00:54ZYUKI—PAKR2004-04-23UHC-60795-85•••-••-4651--6274 CAMELBACK ROADTampaFL33696·GRP-1341NAVIGATE-HMO
CLMCLM-4119612026-01-01T01:59:08ZAUSTIN····MYERS··25-05-1949·UHC-38620-73—NULL··—UNKNOWN·UNKNOWNnull—N/AUNKNOWN
CLMCLM-4217592026-02-20T22:50:15ZIsabella—·Kennedy1951-08-10N/AN/A405-236-6527-2989 RIDGE ROADChandler··AZ85217-9042GRP-9841NULL
CLMCLM-4061762026-05-07T08:33:05ZDENNY··—DAVIS1995-02-16UHC-45986-39—nulldennis.davis16@aol.com1031 Jefferson AveTUCSONAZ—GRP-1625—
CLMCLM-4209912026-08-07T10:27:49Zgregory—contrerasOct 4, 1990UHC-39315-75•••-••-17258263552504null5978 MESA DRIVE #834Tampafl33630·GRP-0233NULL
CLMCLM-4168852026-09-17T18:41:08ZAisha—Garcia1990-44-27UHC-35298-45NULL(257) 601-1674N/A6404 Union StreetSacramentoCalifornia95876·GRP-6218SELECT-EPO
CLMCLM-4144592026-10-03T08:20:32ZNoah····Garrett1984-06-17UHC-99638-91UNKNOWN17952268932noah.garrett@yahoo.com3201 Sunset Blvd··Charlotte··NC28246GRP-9539N/A
CLMCLM-4079452026-09-30T21:09:41ZWillie——2000-12-12··UHC-06567-10UNKNOWN2608228641—9015 River RoadMinneapolisMNN/AGRP-3486null
CLMCLM-4146052026-08-17T15:48:51ZMarilyn—Hansen19621120————659 BroadwayJACKSONVILLEFL32295GRP-7959CHOICE-PLUS-PPO
CLMCLM-4033972026-08-14T21:04:32ZJEREMY—MUNOZ1981-41-28UHC-92193-29—(921) 860-2035UNKNOWN1606 CHURCH STEden Prairie··MN55314GRP-0994CORE-HMO
CLMCLM-4152142026-09-08T18:52:33ZDOUGLAS—HUNT04-02-1965UHC-18462-40•••-••-8890+1 600 231 6071—··---GRP-2608—
CLMCLM-4309292026-03-20T12:47:40ZJason··—Meyer2002-12-20UHC-71924-51•••-••-1639——412 Canyon RoadLos AngelesCA90053-8732-N/A
CLMCLM-4162102026-03-30T09:11:07ZBarbara—Harris1995-02-21UHC9021348·UNKNOWN260-583-4906NULL5369 Bayshore DrGILBERTAZ85294-CORE-HMO
CLMCLM-4027802026-06-06T09:37:51ZJohnston····Carol1943-08-12N/A•••-••-4645nullnull130 Elm StreetSeattleWA·98143·UNKNOWN·MEDICARE-ADV-A
CLM CLM-4006082026-09-20T05:55:47ZKenneth—Dunn1950-03-15N/A——····345 Harbor Boulevard #650AtlantaGA30390-2400GRP-4581·MEDICARE-ADV-A
CLMCLM-4084722026-09-23T05:38:43ZTHOMAS—BRYANT04/05/2004—•••-••-84139252341938thomas.bryant@outlook.com7941 DESERT SKY BOULEVARDTampaFL··33659GRP-6321—
CLMCLM-4244492026-10-03T06:47:28Zamy—simpson··1940-12-05UNKNOWN•••-••-5915UNKNOWN—7977 Bayshore Dr··Jacksonville··FL32260GRP-7858MEDICARE-ADV-A
CLMCLM-4195962026-05-19T16:13:49ZEMMA—·RODRIGUEZ2006-11-25—·NULL—·UNKNOWN894 RIVER RDPHOENIXAZ-UNKNOWN—
CLMCLM-4231892026-01-21T22:10:20ZArmstrong, Jesse——Apr 3, 1941UHC-52920-63•••-••-68258637155511jesse.armstrong5@proton.me2778 Elm StMIAMIFL33109NULLnull
CLMCLM-4126172026-07-31T08:21:00ZDiego—Marquez1993-02-10··-null—·8702 Valley View Drive Apt 34ColumbusOH43264GRP-8014CORE-HMO
CLMCLM-4192292026-03-03T02:04:43ZVINCENT—REYES23-10-2006·NULL—UNKNOWN··NULL8555 PARK PLACEPlanoTX75016GRP-7587OPTIONS-PPO
CLMCLM-4018512026-03-18T22:20:23ZJacob—HolmesnullN/A•••-••-1501N/A—9299 Apache BoulevardAustinTX78764GRP-0237MEDICARE-ADV-A
CLMCLM-4182902026-01-22T13:58:10ZLAURA—·CHAVEZ2006-02-02—•••-••-4664(832) 590-5377N/A1179 Lake View RdDenverCO·80251null·OPTIONS-PPO
CLMCLM-4128732026-02-21T18:49:22ZsharonVray2002-08-08UHC-31560-49•••-••-8513(404) 542-3475—nullN/A-—NULLNAVIGATE-HMO
CLMCLM-4034932026-03-21T06:53:00Z·Maria—Burns03/19/78UNKNOWNUNKNOWN4253271MARIA.BURNS91@ICLOUD.COMNULL--NULLGRP-8401—
CLMCLM-4114352026-02-05T08:12:39ZAndrew—Edwards1957-06-19UHC-43496-82UNKNOWN4692488295null6231 Bayshore DriveGLENDALEAZ·nullNULLOPTIONS-PPO
32,829 rows, page 64 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:36.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty