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-4103932026-03-24T11:21:46ZLUCIAMSIMPSON2000-07-06UHC9112871N/A304-569-0763—7597 Ocean AvenueAtlantaGA30376GRP-6942CORE-HMO
CLMCLM-4165922026-06-20T07:03:05ZSharonV.Rose1953-12-02N/ANULL—-253 BroadwayEden PrairieMN55392GRP-3079NAVIGATE-HMO
CLM CLM-4033702026-04-14T12:44:19ZFranklin, Jerry——02-12-1983··UHC0373438NULL——4905 Mountain View DrColumbusOhio43202--
CLMCLM-4181802026-02-03T08:56:00ZGregory··—Perez1948-09-26UHC-88894-40N/AnullUNKNOWN3026 Valley View Dr·CHARLOTTENC28285-2328UNKNOWNOPTIONS-PPO··
CLMCLM-4052832026-10-15T10:00:28ZLAURA—DAVIS07/10/1997N/A—N/A—1357 MAPLE AVENUELos AngelesCA90079GRP-9236N/A
CLMCLM-4125932026-03-07T19:12:25ZWeeler, Jordan——1976-05-20NULLUNKNOWN+1 374 674 7342NULL7792 Sage CourtDALLASTX75247-UNKNOWN
CLMCLM-4121602026-04-19T07:25:07ZRice, Ben··——20011122·UHC-00900-40•••-••-0403(874) 526-5526BENJAMIN.RICE@OUTLOOK.COM5390 BASELINE RDLOS ANGELES··CA·90059GRP-6332···null
CLMCLM-4178152026-08-28T11:33:24ZKarnH··Bishop10/24/1939UHC-65250-19•••-••-9207N/A·-—UNKNOWNNULLnull··GRP-6079NAVIGATE-HMO
CLMCLM-4123232026-01-04T15:30:39ZCharlotte—Lawson1952-02-25—•••-••-5951·836-201-0634null—NULL—-GRP-7214UNKNOWN
CLMCLM-4200022026-08-30T13:41:36Z·christina—butler1945-03-13UHC-65441-35•••-••-7895UNKNOWN—5040 LINCOLN WAYTampaFL33644··GRP-1735··MEDICARE-ADV-B
CLMCLM-4094092026-07-20T14:38:46Zlarry—bradley1943-04-15-··482-461-2325-4938 Pine DrGilbertAZ85233-0946GRP-8695OPTIONS-PPO
CLMCLM-4130182026-08-10T11:43:48Z·JUAN—GUERRERO1963-05-04UHC-70320-01UNKNOWN9588018924juan.guerrero@outlook.com7648 BROADWAYAtlantaGA-GRP-5227NAVIGATE-HMO
CLMCLM-4319382026-07-03T18:59:27ZNATALIE—NGUYEN1999-08-14UHC-95171-02•••-••-8721302-711-7996····391 WILLOW CTNashvilleTennessee37267GRP-8333CHOICE-PLUS-PPO
CLMCLM-4107222026-09-11T00:24:52ZRalph—Buurns1962-07-13·UHC-48557-35—12276157714—679 Palm Drive·JacksonvilleFL32214GRP-1368SELECT-EPO
CLMCLM-4293882026-10-14T00:13:46ZWILLIAM—HARRIS·1968-04-04·UHC-03532-97•••-••-4662nullnull9249 Jefferson AvenueNashvilleTN··37261-null
CLMCLM-4094742026-03-16T11:20:31ZDouglas··—Robinson1974-11-27UHC-58278-39—15426819497·douglas.robinson65@proton.me9031 APACHE BLVDNashville·TN37242UNKNOWNMEDICARE-ADV-B
CLMCLM-4225162026-03-26T11:06:51ZThereas—Franklin1944-11-18UHC-24902-41UNKNOWN·UNKNOWNnull7509 WILLOW COURTSeattlewa98149—NAVIGATE-HMO
CLMCLM-4163112026-06-03T17:47:49ZWalter—Phillips1998-10-01NULLnullnull—3291 Broadway #341FresnoCA93755—-
CLMCLM-4244332026-02-05T13:52:47ZSAM—NGUYEN1983-07-13NULL··•••-••-5070UNKNOWN····6389 PALM DRIVETucson··AZ85773-··-
CLMCLM-4076822026-08-05T02:54:51ZMEGANZ.CARR1926-08-16UHC-74416-41null885-660-8089UNKNOWN·2579 MEADOW LN·Los AngelesCA-—CHOICE-PLUS-PPO
CLMCLM-4166912026-02-10T05:34:54ZBrian—·Morales07/09/1956UHC-33115-57•••-••-4810+1 957 251 1042—2056 Lincoln WayColumbusoh43288-UNKNOWN
CLMCLM-4180842026-08-21T17:49:32ZNOAHZ.VAZQUEZ2006-04-27-—4896088769·NULL—UNKNOWN—-GRP-3847NAVIGATE-HMO
CLMCLM-4048292026-02-28T00:34:18ZLAUREN—·JAMES1965-04-05UHC-45123-42NULL—null9798 MAIN STREETTucsonAZ85732GRP-4312····
CLMCLM-4088532026-05-12T06:49:59ZMartha—Rogers22-10-1985UHC-41752-65—NULLnull3839 Jefferson AvenueDenverCO80272GRP-1407·MEDICARE-ADV-B
CLMCLM-4099592026-05-04T21:29:37ZTaylor, Kyle——2006-05-28UHC-63974-95··N/A—KYLE.TAYLOR73@AOL.COM8390 Market StTampaFL·33671GRP-1573MEDICARE-ADV-B
CLMCLM-4320072026-08-31T18:03:28ZDiane—Carr2005-08-14N/A•••-••-3860—N/A2848 Lake View RoadSeattleWA98102N/AMEDICARE-ADV-B
CLMCLM-4262872026-05-07T23:16:07ZShirleyUCrawford·1962-08-09UHC2334984•••-••-9135····UNKNOWN9043 Jefferson AvenueDenverCO80207nullMEDICARE-ADV-B
CLM CLM-4212132026-07-04T02:24:23ZGerald··Rios1976-03-19null····NULL—3000 Maple AvenueSAN ANTONIOtx78252··GRP-3747··OPTIONS-PPO
CLMCLM-4172652026-09-29T14:03:57ZAlexaander, Jack——04/20/71·UHC-89498-08—723.740.4966jack.alexander4@icloud.comN/A-—NULLGRP-2177SELECT-EPO
CLMCLM-4003432026-09-03T06:06:10ZCheryl—Howard1946-08-24UHC-29543-47•••-••-0920431.836.6154—5314 APACHE BLVDLas VegasNV89176GRP-4566CHOICE-PLUS-PPO
CLMCLM-4273372026-07-25T05:06:43ZKELLY—TUCKER1999-01-03UHC-00488-72•••-••-0369-null··4186 Central AvenueChandlerArizona85219GRP-7727NAVIGATE-HMO
CLMCLM-4018552026-05-09T19:28:30ZEdward—Dnun1967-07-08—•••-••-1917—edward.dunn19@icloud.com442 BROADWAYSCOTTSDALEAZ85299GRP-1890UNKNOWN
CLMCLM-4085592026-07-04T00:56:04ZCynthia—Chen··20080308UHC-28065-94UNKNOWN+1 430 976 2568NULL7374 Lake View Rd··CharlotteNC—GRP-3838UNKNOWN··
CLM CLM-4056222026-05-10T15:18:26ZTIMOTHY—GARZA1495-08-01·UHC-77050-03—-—2981 Union StreetColumbusOH43274·UNKNOWNmedicare-adv-a
CLMCLM-4073672026-02-18T08:55:11Zedward—yang1964-08-08UHC-16015-60—(777) 934-0483—4624 LINCOLN WAYJacksonvilleFL··32232GRP-3020OPTIONS-PPO
CLMCLM-4088002026-05-10T04:06:23ZEmma—·DunnNov 22, 1972uhc-28577-51•••-••-6731+1 609 556 4294-7042 BroadwayChandlerAZ85249GRP-3812—
CLMCLM-4121202026-08-02T05:23:39ZVirginiaH.Morrison1981-02-21-N/A817.580.4783—7046 Valley View DriveLas VegasNV89169GRP-0809SELECT-EPO
CLMCLM-400656 2026-07-13T09:40:59ZPAUL—JIMENEZ1977-10-17UHC-80721-02····UNKNOWN—1194 Pine Dr··TempeArizona85257GRP-5898N/A
CLMCLM-4110222026-02-19T05:52:06ZGLORIA—·WALSH1990-11-03··UNKNOWN··—null73 Elm StreetAustin··TX78750UNKNOWNNAVIGATE-HMO
CLMCLM-4298622026-10-05T20:42:15ZSara—MurphyJul 1, 1953UNKNOWNUNKNOWN——8753 Palm DrPlanoTX75082-6555GRP-4645select-epo
CLMCLM-4323432026-09-03T05:05:55ZETHAN—MEJIA3/7/1972null•••-••-9592559-250-7804—5630 Church StTempeAZ85292-2967GRP-4875MEDICARE-ADV-B
CLMCLM-4007222026-04-11T19:35:29ZCarolyyn—Sanders··Dec 5, 1990UNKNOWN•••-••-33826767404860—NULLnull—nullGRP-3971NULL··
CLMCLM-4061772026-09-10T04:06:38Zamanda—robertson1964-07-04UHC-15760-50—·6689975161—3885 Mountain View DrFRESNOCA93769GRP-3804UNKNOWN
CLMCLM-4163962026-06-28T00:24:27ZJohn—Anderson9167-04-13UHC-74807-02··•••-••-3110—NULL9872 Ocean AvenuePhoenixAZ85087GRP-5270SELECT-EPO
CLMCLM-4153702026-04-21T04:06:34ZMichelle—Gutierrez1979-03-25—•••-••-9415—UNKNOWN7289 LINCOLN WAYJacksonville··FL32273GRP-8321—
CLMCLM-4008232026-05-17T10:13:10ZCharles C····Nelson1977-04-20··UHC-36461-88N/A(499) 541-2528-1217 Church StOrlandofl32845GRP-7674—
CLMCLM-4161062026-10-05T05:47:40ZRaymnd—Duncan06/13/1986UHC-84562-95NULL2309328749NULL———-GRP-5757—
CLMCLM-4097812026-05-30T08:34:41ZJOSHUAMDIAZ01/17/83UHC-62814-55null-—nullN/A————
CLMCLM-4102762026-01-12T16:44:21ZMARTHA—WOOD1990-58-28N/A•••-••-7738····—7640 Spring StSCOTTSDALEAZ85290GRP-7962-
CLMCLM-4178072026-07-14T14:04:34ZGregory—Smith··19800827UHC-84719-85·NULL(284) 320-1062··9597 SAGE CT #467CharlotteNC28267—SELECT-EPO
32,829 rows, page 126 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:38.496Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty