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-4107002026-10-04T05:00:22ZBRANDONQ.·ARMSTRONG1959-11-13-NULLN/AN/A2641 Apache BoulevardDENVERCO—·GRP-1134NAVIGATE-HMO
CLMCLM-4266892026-02-14T00:29:14ZEric—FosterJul 26, 1953--N/ANULL4997 ELM STREETTempeAZ85241N/ANAVIGATE-HMO
CLMCLM-4150822026-09-08T12:28:39ZJordan—Ellis20040904uhc-92342-99•••-••-9016NULL—·9877 Mesa DrHoustonTX77026-6569NULL—
CLMCLM-4224702026-08-29T12:04:19ZRussell··Richards1980-02-25nullNULL-russell.richards61@aol.com·3926 Maple AvenueEden PrairieMN55367GRP-5710—
CLMCLM-4124932026-04-21T23:30:54Zyuki—morris·2003-08-09UHC-25204-23•••-••-3205348-477-1748UNKNOWN··7731 FOREST AVENUEColumbusOHN/AUNKNOWN—
CLMCLM-4020822026-02-10T03:09:29ZPETER—WALKER1986-04-18UHC-17729-51··•••-••-5652(309) 507-4509UNKNOWN5541 PALM DRIVEGlendale··AZ85386GRP-8113—
CLMCLM-4041312026-08-25T04:22:52ZTerry—Howell1982-12-09UHC-35174-23•••-••-9033—-9368 Desert Sky BlvdColumbusOH43226GRP-2276—
CLMCLM-4060782026-03-19T01:18:51Z·lisa····foster1995-08-24UHC-72634-68··——····1012 BroadwayHoustonTX77058GRP-2861··NULL
CLMCLM-4155652026-02-26T01:19:41ZFATIMA·GVASQUEZ08/13/81——8245020799—3158 Valley View DriveLos AngelesCA90094GRP-2944SELECT-EPO
CLMCLM-4258372026-01-21T03:32:57ZDonna····Silva1989-10-06UHC-90917-79--NULL··9374 Sage CtLas VegasNV89168··—CHOICE-PLUS-PPO
CLMCLM-4281422026-04-22T19:55:48ZVIRGINIA I—SCOTT2005-05-02UHC-38514-70•••-••-77579472393656VIRGINIA.SCOTT@YAHOO.COM9105 Hillcrest RoadSeattleWA-NULLMEDICARE-ADV-A
CLMCLM-4167942026-08-06T15:54:26ZMson—Garcia2005-05-04UHC-90864-72null777-434-9539MASON.GARCIA@AOL.COM——-null··UNKNOWN
CLM CLM-4070492026-05-01T18:04:48ZAnn—Jensen1970-07-14UHC-97263-25———6086 Union StreetLos AngelesCA90092—CORE-HMO
CLMCLM-4196082026-01-22T08:06:09ZISABELLA····WOOD1988-12-17UNKNOWN•••-••-549813243684154—N/A··—UNKNOWNGRP-7882MEDICARE-ADV-B
CLM CLM-4229492026-08-24T18:34:19ZBetty······Evans1998-04-26N/A-5924058N/AnullUNKNOWN··N/A—GRP-7514CHOICE-PLUS-PPO
CLMCLM-4258282026-07-23T01:30:02ZKtaherine—Cloeman1978-08-07UNKNOWNUNKNOWN—katherine.coleman91@outlook.com4579 Mesa DrNashvilleTennessee37290GRP-0658MEDICARE-ADV-A··
CLMCLM-4053152026-05-20T07:18:09Z·SAMUEL—·DIAZ1954-09-13UHC-54213-52•••-••-4625UNKNOWN··N/A1684 Oak StAtlantaGANULLGRP-4987OPTIONS-PPO
CLMCLM-4132852026-09-24T17:25:11ZJONATHAN·····PIERCESep 18, 1943UHC-45594-56•••-••-85512747158996—4558 Ocean Ave·CHANDLERAZ85237——
CLMCLM-4274562026-06-04T20:50:36Z·Daniels, Jack——1952-12-08····•••-••-18846764784172····6951 Church Street Apt 7AtlantaGA30313UNKNOWN··NAVIGATE-HMO
CLMCLM-4109122026-03-14T14:59:44Z Joseph—Watkins07/19/08·-UNKNOWN··null—8272 Sunset BlvdCHARLOTTENC28277··—MEDICARE-ADV-A
CLMCLM-4119472026-04-22T03:30:51Z·ELIJAH—WOOD1989-07-06UNKNOWNNULLN/A—null—UNKNOWN-·GRP-3674NULL
CLMCLM-4040562026-10-18T01:23:02Z·LAWRRENCE—ELLIS···1990-06-03UNKNOWN—N/ANULL2144 Washington StChandlerAZ85248·GRP-9427N/A
CLMCLM-4294692026-02-08T14:24:18Zmartha—west8/13/1951——6834713620null3664 PINE DRTempeAZ85218nullCHOICE-PLUS-PPO
CLMCLM-4260132026-03-30T05:06:42ZJustinIRojasJan 27, 1950UHC-93944-47•••-••-9057—nullN/A··—UNKNOWN—N/A-··
CLMCLM-4143592026-06-13T19:02:37ZCharles—Williams1944-10-03UHC-85281-63··•••-••-399719726436385—9734 Bayshore DrColumbusOH43279GRP-5317-
CLMCLM-4246132026-06-12T03:15:52ZJason—Wood1939-05-23UHC-11532-30-—N/A8758 OCEAN AVENUEEden PrairieMN55323GRP-9548SELECT-EPO
CLMCLM-4280752026-09-04T00:58:57ZKing, Christian——1952-07-18UHC-48234-46•••-••-4201UNKNOWN—5526 Sunset BoulevardTempeaz·85215GRP-1478—
CLMCLM-4151802026-10-05T00:08:28ZBradly—·Oliver1951-09-07uhc-67161-27•••-••-0633-—5188 Union St #888TampaFL33656NULL··—
CLMCLM-4317622026-05-10T19:12:37ZEspinoza, Rebecca——19541227UHC9195897•••-••-3574N/ANULL—NULLNULLN/AGRP-6325MEDICARE-ADV-A
CLMCLM-4054152026-01-11T02:55:23ZEric—Ortiz5/10/1941nullNULL-N/A8668 DESERT SKY BLVDMIAMIFL33121NULLCORE-HMO
CLMCLM-4175652026-06-29T01:00:19ZMARIANA—FREEMAN1968-12-20UHC-39956-01N/A8975461539UNKNOWN7185 Valley View DriveLas VegasNevada89109··GRP-1851N/A
CLMCLM-4173462026-07-19T15:34:25ZKelly—Morris1994-11-22·UHC-78551-07—-—6358 SAGE COURTOrlando··FL32856GRP-8848OPTIONS-PPO
CLMCLM-4227132026-07-03T05:38:01ZDaniels, Larry·····9189-04-04NULL-—null5621 MARKET STGlendaleAZ·85343GRP-8343—
CLMCLM-4010492026-02-08T02:54:12ZChristina—Singh1972-07-12··UHC-36281-66NULL——1049 Harbor BlvdTempe··ArizonaNULL——
CLMCLM-4002782026-01-04T18:12:05ZAmber—Soto2010-06-04N/A•••-••-8208N/A—1088 Hillcrest RdDENVERCO—GRP-4627N/A
CLMCLM-4243442026-09-20T02:25:22Zheather—vazquez14-05-1956UHC-60010-83•••-••-6293(687) 609-4958-·1445 CENTRAL AVEGlendale··AZ85399—SELECT-EPO··
CLMCLM-4043392026-05-21T07:42:35ZMadisonLArmstrong10/11/1973-··UNKNOWN—6205 Grand AvePlanoTX75071GRP-8620NULL
CLMCLM-4285722026-05-13T17:04:13ZKayla—Knight1977-10-25UHC-89655-06—NULL—8687 Bayshore DrSacramentoCA95827NULL·CHOICE-PLUS-PPO
CLMCLM-4226452026-02-11T04:13:14ZTim—Rios19740318UHC6827284NULL··UNKNOWNNULL8728 Sage Ct··MiamiFL33123GRP-0521····
CLMCLM-4305822026-07-18T12:21:58ZNancyOCarpenter19800607UHC-82726-77—nullN/A7629 OCEAN AVE #431DallasTX75246GRP-8129··—
CLMCLM-4110532026-07-07T19:27:35ZCollins, Bob··—·11-01-1952UHC-33675-90——ROBERT.COLLINS@OUTLOOK.COM626 Spring StSacramentoCA95859nullUNKNOWN
CLMCLM-4214112026-05-15T07:41:43ZPHILIP—RODRIGUEZ1939-08-18UHC-28391-78•••-••-3633(271) 779-1205N/A4856 Desert Sky Blvd Apt 18AtlantaGA·30334GRP-8466—
CLMCLM-4010842026-03-22T14:45:27ZThomas—West1961-12-16UHC-63916-28—UNKNOWNN/A-UNKNOWN—nullGRP-2599CORE-HMO
CLMCLM-4108082026-01-12T23:56:16ZNicoleNRichardson2008-09-22UHC-06257-82UNKNOWN725-707-6485—·2529 Canyon RoadHouston··TX77064GRP-4475MEDICARE-ADV-A
CLMCLM-4024492026-05-07T04:34:19ZBetsyVFreeman1945-09-03—•••-••-10106615399—3288 Valley View DriveDenverColorado··80200GRP-7881—
CLMCLM-4245432026-01-11T14:41:03ZJudyX.Walker1964-12-08—NULL617.575.5014N/A1921 Grand AveFresnoCA93728GRP-2954NAVIGATE-HMO
CLMCLM-4313092026-01-02T06:21:29ZKeith—Herrera1976-08-18—•••-••-1393563-624-9105N/A740 BroadwayLOS ANGELESCalifornia·90052-6078GRP-6454OPTIONS-PPO
CLMCLM-4078752026-03-23T21:59:07Z·Arnold, Mari——19860313UHC-85249-31•••-••-6371——UNKNOWNNULLUNKNOWN—nullNAVIGATE-HMO
CLMCLM-4088272026-09-09T22:11:39ZJUAN—ELLIS1996-07-02-—6793189275-·-——·NULLGRP-9939—
CLMCLM-4053202026-09-03T02:13:31ZAMY—WASHINGTON1964-07-27UHC-41659-76N/A-NULL8281 Mountain View DriveFresnoCA·93710-4353N/A—
32,829 rows, page 50 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.700Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty