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-4160412026-09-08T03:25:16ZKathrynAHayes·1971-09-11—•••-••-0079—kathryn.hayes@yahoo.com9284 CEDAR LNJacksonvilleFL32261GRP-3991NAVIGATE-HMO
CLMCLM-4308992026-07-25T02:25:46ZRichardson—Grace1979-11-01UHC-05731-22—N/ANULL489 Ocean AveScottsdaleArizona—GRP-9776-
CLMCLM-4307582026-09-08T01:09:44ZRichard—Rodriguez12/14/46UHC-95527-04•••-••-7256null-nullN/A—-null··—
CLMCLM-4258322026-06-22T12:19:57ZANNAHWILLIAMS1985-11-05N/AN/A340-810-8516UNKNOWN2622 Lincoln WaySACRAMENTOCA95860GRP-9421N/A
CLMCLM-4218002026-05-15T21:35:16Z———1967-12-18UHC6021377•••-••-265017359902102-··1681 River Road #342ScottsdaleAZ·85221UNKNOWNMEDICARE-ADV-A
CLMCLM-4113032026-04-23T14:39:08ZMaria—Mejia1992-10-18UHC-27081-15—17812477325maria.mejia@outlook.comNULL-——GRP-6490NAVIGATE-HMO
CLMCLM-4119782026-03-08T09:51:08ZGabriel—Reynolds1939-04-23UHC-02655-16—8529219991-·3079 Valley View DrLas VegasNV89138GRP-5716···NAVIGATE-HMO
CLMCLM-4266752026-03-04T22:24:48ZDylan—Jensen·1941-11-28UHC-72072-71·N/A·null—·1814 BROADWAYColumbusOH43256N/A·CHOICE-PLUS-PPO
CLMCLM-4135142026-09-05T05:36:49Z·BRIAN—MEYRS1996-02-11——277.577.4358—9050 Mesa DriveTempeAZ85221·UNKNOWNN/A
CLMCLM-4124002026-05-20T11:16:27Zcatherine—tucker1967-02-09UHC-26599-42··-··UNKNOWNCATHERINE.TUCKER94@HOTMAIL.COM7520 Ridge RdAustinTX78746GRP-5224null
CLMCLM-4236212026-03-31T10:54:34ZBobby—Cole10-06-1989UHC-51664-05•••-••-3286(807) 624-9165null231 Desert Sky BoulevardColumbusOH—GRP-1845MEDICARE-ADV-A
CLMCLM-4027172026-01-18T12:01:03Zwayne—lwrence1941-10-10N/A•••-••-62624959315140··—6617 Hillcrest Road Apt 15ChandlerAZ85228-—
CLMCLM-4003152026-09-17T16:44:18ZKeith—Collins1956-11-21UHC-13066-46—+1 736 343 8173—·9739 Market StNASHVILLETN37208GRP-0666··CHOICE-PLUS-PPO
CLMCLM-4134662026-01-22T07:20:45ZMarkLGutierrez1973-08-10UNKNOWN•••-••-5596NULL—9527 Mesa Drive·LOS ANGELESCA90069—-
CLMCLM-4148032026-10-17T18:59:36ZBradley—Weber10/6/1989null—+1 529 355 8930···-7366 River RdPhoenixAZ85010GRP-3822MEDICARE-ADV-B
CLMCLM-4019672026-09-09T16:43:23ZNathan—Carpenter1959-06-26UHC-33486-31null778-838-6260-3681 Meadow LnScottsdaleArizona85218—MEDICARE-ADV-A
CLM CLM-4005822026-01-16T07:14:37ZJOSECPETERSON2007-07-18···UHC-04323-58•••-••-5743-—6822 Baseline RdMesaAZ85247GRP-9365UNKNOWN
CLMCLM-4223842026-01-16T07:10:07ZGonzales, Teresa——·04/21/42UHC-97031-33UNKNOWN2152347945N/A7497 Park PlAustinTX78716GRP-2000SELECT-EPO··
CLMCLM-4124622026-05-06T06:11:02ZSamuel—·Wong11/23/47UHC-13804-81nullUNKNOWN-3726 Hillcrest Road Apt 14FRESNOCA·93740NULLMEDICARE-ADV-A
CLMCLM-4272682026-05-07T16:36:18ZKyle—Myers··1982-10-21N/AN/A-UNKNOWN2974 Ridge RoadMESAAZ85211-0366GRP-3512UNKNOWN
CLMCLM-4324912026-05-26T13:35:11ZROGER—MARTINEZ19900315UHC-40330-54—5044255946NULL6998 Cedar Lane #605PhoenixAZ·85049-SELECT-EPO
CLMCLM-4156742026-01-03T11:29:47ZJacquline—Berry1961-10-07NULL—NULLNULL351 Forest AveLas VegasNV89114GRP-1836NAVIGATE-HMO
CLMCLM-4121102026-08-08T07:41:43ZJack—Scott08/22/1949UNKNOWN•••-••-9758(633) 307-8231null6031 Elm StreetLas VegasNV89167GRP-4092CORE-HMO
CLMCLM-4235662026-04-26T10:42:05ZLynch, Albeert—··1960-04-25UHC-64593-13•••-••-7295343-887-1475NULL1108 Maple AvenueSeattleWA··98143GRP-8548··UNKNOWN
CLMCLM-4277602026-06-30T17:34:14ZKimberly—Vega1977-08-09UNKNOWN•••-••-2487N/ANULL914 CAMELBACK ROADGLENDALEAZ85367-MEDICARE-ADV-B
CLMCLM-4271082026-03-11T19:58:28ZJanet—Fernandez14-04-1989UHC-09025-60•••-••-9511882.954.3390—··—UNKNOWNUNKNOWNGRP-6232CORE-HMO
CLMCLM-4321992026-01-19T00:50:34ZMARY—MASONMay 25, 1942UHC-32557-02N/AN/A—3145 Main StreetFresnoCA93784GRP-1608CHOICE-PLUS-PPO
CLMCLM-4093052026-09-10T09:30:28ZloriV.ellis2005-08-15UHC-21885-66UNKNOWN——·5821 Union StreetOrlando·Florida32879·NULL—
CLMCLM-4292882026-02-09T02:39:21ZDEBRA—KENNEDY·1964-01-18UHC-17931-97•••-••-4071336.735.4783NULLN/A————null
CLMCLM-4171342026-06-23T19:38:08ZAmandaITaylor16-10-1996UHC-20184-77•••-••-5760(643) 359-2311N/A9588 Ocean AvenueSeattleWA—GRP-5786—
CLMCLM-4242212026-04-24T01:13:29Z·Lucia—Baker2008-04-25·UHC0079082·null—lucia.baker@proton.meN/AUNKNOWN··N/AUNKNOWN··—
CLMCLM-4016092026-10-02T08:12:22Zbrittany—contreras1961-08-02UHC-96678-57UNKNOWN—null4487 Pine DriveNASHVILLETN37283GRP-6777NAVIGATE-HMO
CLMCLM-4115642026-07-08T04:17:01ZThomas—Dean08-06-1982UHC-65674-50—(964) 235-4029—8694 Ocean AveMiamifl··33163GRP-1526null
CLMCLM-4101372026-06-25T14:26:08ZROGER—RAY1977-08-03UHC-43599-50·-+1 787 500 8643N/A4127 Apache BlvdMesaAZ85214GRP-9426UNKNOWN
CLMCLM-4256182026-01-14T15:10:53ZWhite, Philip——1992-10-23·UHC-56598-37—NULL··—208 Washington St··GilbertArizona85280GRP-9289··
CLMCLM-4277082026-09-01T11:13:46ZGrace—Johnston2/14/2008UHC-06724-33NULL——5768 Jefferson AveFresnoCA93759UNKNOWNCORE-HMO
CLMCLM-4326212026-04-20T12:53:55ZWALTERT.RIOS1956-10-13UHC-18644-99-—UNKNOWN3523 BROADWAYChandlerAZNULL—OPTIONS-PPO··
CLMCLM-4128762026-07-24T01:32:54ZJudy—Ortega··10/9/1964UHC-01762-01N/A··931.343.0829NULL····NULLnullN/AN/ANAVIGATE-HMO
CLMCLM-4281162026-06-23T06:43:43Zpriya—lopez04/09/47NULL•••-••-2663(207) 656-6795—6000 Harbor BlvdCHANDLERAZ-GRP-4231—
CLMCLM-4134982026-09-03T15:26:46ZMARILYN—LONG1948-06-28·UHC-02319-99———4006 BroadwayEden PrairieMinnesota55374GRP-2117—
CLMCLM-4140012026-06-16T13:25:24ZOrtega, Kathryn——1944-08-18UHC-71038-15null881.993.4947-7208 UNION STREETPlanoTX75025GRP-4846MEDICARE-ADV-B
CLMCLM-4213142026-08-19T04:15:25Z emma—hayes11/22/1947UHC-08659-93··•••-••-7482—NULL7363 CEDAR LANE #368CharlotteNC28215GRP-8584-
CLMCLM-4003912026-10-15T01:20:27ZETHAN—LEWIS1947-02-25null•••-••-58727949937556-null—NULLN/AGRP-3257CORE-HMO
CLMCLM-4306702026-02-17T08:25:07ZDIANEZCARROLL1989-06-18UHC-47139-83•••-••-6302——N/A-—N/AGRP-5903CHOICE-PLUS-PPO
CLMCLM-4057142026-01-21T00:49:47ZDENNIS—GRANT··1943-04-27··UHC-94532-67—(211) 712-1932··3986 Maple AveLos AngelesCA·90053—N/A
CLMCLM-4223322026-04-21T06:49:14ZDeborahBHill1941-10-28UHC-93002-46—402.227.3661-3555 Main StTUCSONAZ85726GRP-7157null
CLMCLM-4169582026-04-19T01:57:46ZSharon—Little2004-07-03UHC0451499•••-••-3846·(893) 452-7665NULL8702 PINE DRIVEHoustonTXNULLGRP-9647—
CLMCLM-4095912026-09-19T19:56:18ZOLIVIA—THOMAS1966-01-14UHC-31622-35•••-••-3562N/ANULL9328 Sage Ct··PLANOTX75006-4085·GRP-1775OPTIONS-PPO
CLMCLM-4096732026-08-05T00:21:52ZKevyn—Willis1965-03-08UHC-37185-19N/A··(334) 982-0388———N/A-——
CLMCLM-4233952026-07-17T03:19:58ZGrace—Davis1944-10-19null•••-••-6466N/A-UNKNOWN—nullN/A·GRP-0207SELECT-EPO
32,829 rows, page 207 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:43.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty