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-4125272026-01-03T20:29:10ZJonatthan—Parker1952-09-07UHC-53297-26•••-••-5012(646) 649-8212NULL8769 Lincoln WaySeattleWA98174·nullMEDICARE-ADV-B
CLMCLM-4033002026-02-13T04:17:31ZDANIEL····SANTIAGO1998-07-24UHC5603499—-··—UNKNOWNnull··N/AGRP-7099CHOICE-PLUS-PPO
CLMCLM-4114922026-02-10T10:36:14ZGERALD—MARQUEZ05/27/43-—N/A-7247 Valley View DrTempeAZUNKNOWNGRP-3492··NAVIGATE-HMO
CLMCLM-4250752026-06-15T01:07:00ZELIJJAH—WILLIAMS·1959-10-23UHC-93427-23———6333 HARBOR BLVDSeattleWA98178GRP-1912N/A
CLMCLM-407978 2026-06-15T22:59:50ZEDWARDX.CUNNINGHAM1941-03-16UHC-34122-98null16177554470-2332 BroadwayDallasTexas75240-0040GRP-3866NAVIGATE-HMO
CLMCLM-423194 2026-05-21T12:01:02ZBety—Watson1943-11-22UNKNOWN—14205068403N/A5306 Highland Avenue·AtlantaGA30361GRP-5885N/A
CLMCLM-4004042026-07-15T16:51:46ZJOSH—WILLIS1945-04-07UHC-25334-79··—NULL6663 Oak StreetSACRAMENTOCA95835GRP-2531CHOICE-PLUS-PPO
CLMCLM-4316652026-09-27T09:31:25ZNATALIE····BENNETT11/25/1992UHC-71271-45UNKNOWNNULLUNKNOWN517 RIVER RDHoustonTX77063GRP-9067SELECT-EPO
CLMCLM-4017562026-01-13T19:26:04ZJUAN—KENNEDY··1961-01-06—UNKNOWN17173878753N/AN/A-null·UNKNOWN—-
CLMCLM-4242902026-03-27T10:30:33ZPatterson, MarthaY.—1991-05-22—-+1 952 390 5351NULL7089 River RoadTempeAZ85239-1659GRP-0653—
CLMCLM-4062222026-07-18T00:02:10ZBOWMAN—EMMA19430708N/A—+1 729 415 8304null554 HILLCREST RDTempeAZ85208·GRP-1010N/A
CLMCLM-4170262026-08-01T09:45:21ZGERALD—HAMILTON1986-10-02NULL—UNKNOWNnull6006 SPRING STSan AntonioTX··78237-0358GRP-2513SELECT-EPO
CLMCLM-4186062026-02-09T05:01:59Z Cynthia—Gay1986-06-08UHC-12777-98null——7290 WASHINGTON STJacksonvilleFL32214—NAVIGATE-HMO
CLMCLM-4100322026-03-27T08:44:04ZAMBAR—HAMILTON·1974-09-16UHC-67162-01null+1 872 227 7065—6618 Maple AveSan DiegoCA92172-—
CLMCLM-4097322026-09-26T15:41:56Zrachel—brooks1990-09-18nullUNKNOWN—UNKNOWNUNKNOWNnull··-UNKNOWNGRP-9957UNKNOWN
CLMCLM-4290442026-09-10T07:45:56ZRaymond—Mason19970109UHC-02558-95•••-••-0461·4969159365—2597 Mountain View DrAustintxN/AGRP-7595··OPTIONS-PPO
CLMCLM-4217942026-06-16T05:12:41ZIsabella—Santos1985-12-02uhc-21801-43-8149226535—7088 Market StreetTempeAZ··85211GRP-3180SELECT-EPO
CLMCLM-4227722026-07-08T11:58:52ZGREGORY—LE1939-12-05-•••-••-0236nullNULL——N/AN/AGRP-0662OPTIONS-PPO
CLMCLM-4292832026-08-03T12:25:57ZBRITTANY··J·RICHARDSON1952-12-02··UHC-80551-30NULL—brittany.richardson@proton.me4734 Baseline RoadPlanoTX·75079·GRP-1357CORE-HMO
CLMCLM-428710 2026-03-02T06:16:00ZBetty—Rodriguez2008-01-02UHC-69967-28—(828) 457-5874BETTY.RODRIGUEZ@PROTON.ME1339 SPRING STPlanoTX75083UNKNOWN-
CLMCLM-4248212026-01-04T08:58:05ZWhite—Carol10-06-2000UHC-08380-65•••-••-99618906933858NULL8205 River RdColumbusOhio43262····NULL
CLMCLM-4078612026-10-08T04:25:44ZMarilyn—Hunt··25-04-2000N/A•••-••-38514334049923-9005 Ridge RoadGlendaleArizona85391N/A-
CLMCLM-4238242026-08-26T10:41:59ZMASON—·ROBERTSON1991-12-22uhc-22924-14·--UNKNOWN6341 CANYON RDDenverCO80249GRP-6817·CORE-HMO
CLMCLM-4310172026-07-16T04:10:14ZBenjamin—Jones1988-02-11UHC-75457-98UNKNOWN7936477754—5630 Baseline RdPlanoTX75019GRP-5352null
CLMCLM-4110672026-05-29T10:42:46Z Willie—Ross··2004-05-19UHC-03147-99•••-••-26833717869260—····—UNKNOWNnullGRP-5445-
CLMCLM-4235362026-08-09T20:06:50ZMegan—Jimenez18-04-1951UHC-30141-52•••-••-4351-megan.jimenez3@gmail.com1592 Camelback RdSacramentoCA95827UNKNOWN—
CLMCLM-4080422026-04-25T13:48:27ZHeather··AHernandezMar 19, 1977—•••-••-0693N/A··NULL9822 Park PlSeattleWA98183GRP-5898UNKNOWN
CLMCLM-4139222026-06-01T01:18:50ZMartha—Boyd1982-10-10——N/AUNKNOWN6625 Maple AvenueSan DiegoCA92157NULLNAVIGATE-HMO
CLMCLM-4319852026-03-13T06:09:56Z Greene, Matthew——1950-01-01UHC-91766-10•••-••-1185-——········NULLNULLSELECT-EPO
CLMCLM-4121242026-08-28T14:49:35ZJeffrey—Gonzalez1980-02-24··—N/Anull—4581 Meadow Lane·AUSTINTXN/A-—
CLMCLM-4323352026-04-23T09:01:36ZJONATHANO.SCHULTZ06/08/1945—•••-••-3626—-3118 Pine DrCharlotteNC28298-1760GRP-9061MEDICARE-ADV-B
CLMCLM-4043502026-07-20T13:49:12ZKathy—Cruz1967-10-10-—808.432.9601—9570 Church StSan DiegoCA92175GRP-0933MEDICARE-ADV-B
CLMCLM-4172822026-03-14T15:05:08Z James, Mateo··I.—01/13/2008UHC-62158-56•••-••-8226635-500-4806—·4536 CANYON RDOrlandoFL32863GRP-9480MEDICARE-ADV-A
CLMCLM-4093532026-07-17T10:50:46ZJANET—COLE1950-04-16UHC-14286-74•••-••-8569——·9793 Desert Sky BoulevardScottsdale··AZ85282GRP-5303··SELECT-EPO
CLMCLM-4158452026-04-16T10:54:24Z·Kayla—Simmons1946-05-05·-null(477) 904-8063NULL5269 RIDGE ROADGilbertAZ85223GRP-3699NAVIGATE-HMO
CLMCLM-4129002026-09-18T22:47:18ZKyle··—Hart1969-11-21UHC-31482-61•••-••-92277474765791—N/A··UNKNOWNN/AGRP-8424SELECT-EPO
CLMCLM-4215402026-07-26T21:26:39ZFrances—Ruiz16-03-1994UHC-53327-52•••-••-0010-·NULL9212 MAIN STATLANTAGeorgia30353GRP-6383·MEDICARE-ADV-B
CLMCLM-4292922026-08-14T07:22:13Zpadilla—ann2008-10-04·UHC-67047-34-N/ANULL6081 LAKE VIEW RD Apt 17MinneapolisMN55439GRP-6587null
CLMCLM-4046662026-01-25T21:36:37ZRonald—Dean1982-08-11-•••-••-28649859695463UNKNOWNnull—-—GRP-6309select-epo
CLMCLM-4055422026-10-05T00:17:10ZALEXIS—JOHNSON··11-05-1980uhc-95918-59—+1 506 421 1424N/A6585 Church StDallasTX·75230GRP-3657NULL
CLMCLM-4211062026-02-04T00:00:31ZStephen··U.Elliott··12/09/1993N/A—7068913399—209 Maple AvenueColumbusoh43232N/A—
CLMCLM-4128272026-05-21T01:37:05ZScottDDavis1967-05-22UHC-23684-09•••-••-3717——1816 Ocean AvenueOrlandoFL32863N/AMEDICARE-ADV-A
CLMCLM-4145642026-08-20T21:42:49ZGabrielY.Garza01/11/1957UHC-15449-71—5595212859null5766 BASELINE RDCharlotteNorth Carolina28292GRP-0405NULL
CLM CLM-4262582026-07-02T03:10:06Z·Watson, Ashley——12/22/1960NULL—8858091ashley.watson61@yahoo.com4523 Maple AvenuePhoenixAZ85064····OPTIONS-PPO
CLMCLM-4014852026-09-28T23:46:39ZNatalie—Simpson1940-11-11··—•••-••-3894494-709-0529NULL4332 Maple AvenueJacksonvilleFL32207-3469····-
CLMCLM-4044402026-04-25T17:23:13ZGregory—Ward1/22/1981UHC-42600-61•••-••-0852422-714-3570gregory.ward@icloud.com··886 Bayshore DriveMiamiFL33159GRP-3364CORE-HMO
CLMCLM-4090952026-06-05T10:09:07ZemmaD.carter02/15/1943UHC-30598-22—NULLEMMA.CARTER@YAHOO.COM2898 CHURCH STREET·AUSTINTX78758GRP-4936MEDICARE-ADV-A
CLMCLM-4315752026-05-04T14:05:37ZCatherine—Wright1952-12-03UHC-46069-48•••-••-6025(369) 304-7991catherine.wright5@gmail.com4260 LAKE VIEW ROAD··JacksonvilleFL32256-4434GRP-4594····
CLMCLM-4000712026-09-14T06:07:36ZAMEBR—WELLS1979-06-25UHC-31236-97·····266-595-0799N/A··4421 OCEAN AVETAMPAFL33680—N/A
CLMCLM-4260902026-04-07T13:09:19ZEVELYN—ALVARADO1979-10-24uhc-61170-74N/A3065217185—null-··—NULL—MEDICARE-ADV-A
32,829 rows, page 127 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.498Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty