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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4275552026-01-25T15:50:27ZKymberly—Wood10/3/1984—•••-••-6862UNKNOWNnull6099 Cedar LaneTucsonAZ85708-6673GRP-3677NULL
CLMCLM-4147552026-07-10T21:08:32ZsandraSsimmons··1967-02-27null•••-••-3796508.229.1918-469 ELM STSeattleWA98181GRP-6629NAVIGATE-HMO
CLMCLM-4258712026-09-29T05:34:51ZEthan··Contreras1974-12-03UHC-16890-61···9493395462N/AUNKNOWN—UNKNOWN—UNKNOWN—
CLMCLM-428345 2026-05-17T22:40:49Zyuki—willis1985-12-25··UHC-15526-71··•••-••-3738·--5308 MEADOW LANEMIAMIFL33177-2077GRP-0506··—
ENR ENR-1010652026-08-05T13:53:07ZERICJKIM08/06/83UHC-91798-83•••-••-5090222-783-8251-9672 BroadwayTampaFL33649··GRP-4729OPTIONS-PPO
CLMCLM-4233812026-09-24T15:25:10ZLAURRAVALVARADO1967-03-02UHC-14487-86•••-••-58634777190704—8940 Church StreetHoustonTX77084GRP-1293UNKNOWN
ENRENR-1022122026-10-02T15:45:56ZKYLLEQ.WANG1939-09-22UHC-43409-27•••-••-2103(260) 617-2007kyle.wang@icloud.com··5461 Indian School RoadFresnoCA93741-6115GRP-9093medicare-adv-b
CLMCLM-4022362026-05-27T19:52:19ZDenise—Lewis1966-09-27UHC-57967-56•••-••-6500—·null427 VALLEY VIEW DRIVELos AngelesCA90097NULLMEDICARE-ADV-A
CLM CLM-4072302026-05-30T21:15:13ZDavidBWelch1949-12-20UHC-36888-34•••-••-6046632.852.1600··null5546 CAMELBACK ROADAtlantaGA30331—UNKNOWN
CLMCLM-4158952026-09-29T21:26:37ZVIRGINIIA—MEJIA1986-09-13UHC-32892-06—212.871.7470—6665 Lake View RoadAustinTX78706GRP-6352SELECT-EPO
ENR ENR-1245212026-02-04T16:04:41ZNATALIEO.HOFFMANnullUHC-91848-90•••-••-4702858-564-2442natalie.hoffman72@outlook.com4436 Highland AvenueMesaAZ85217GRP-4643CHOICE-PLUS-PPO
CLMCLM-4142922026-05-08T02:24:44ZRobertson··—Kevin1939-09-25UHC-47428-12NULL(488) 722-4349null3764 Sage CourtEden Prairiemn55337—OPTIONS-PPO
CLMCLM-4300952026-10-05T04:52:47ZNelson, JeanO—1987-09-12UHC-20738-64nullUNKNOWN··5776 Ridge RoadCHARLOTTE·North Carolina28236GRP-3021UNKNOWN
ENR ENR-1392862026-06-09T05:06:47ZJesseJ·Jones1967-07-15UHC-26577-70•••-••-0227(363) 363-4581jesse.jones16@hotmail.com9066 UNION ST Apt 31TampaFL33627GRP-9719NAVIGATE-HMO··
ENRENR-134777 2026-08-08T01:01:29ZAlbert—Delgado11/16/77UHC-28781-56•••-••-39032699420467·albert.delgado@outlook.com6306 SAGE CTLas VegasNV89115GRP-5153··OPTIONS-PPO
ENRENR-1311892026-06-11T22:50:01ZWAYNEMWARD02-01-1981UHC-83240-76•••-••-4959605-419-9098NULL9586 BASELINE RDSEATTLEWA98156·GRP-1592·options-ppo
ENRENR-1332302026-08-07T20:40:19ZKellyFHerrera01/10/1953UHC-57765-55•••-••-1193407-477-1215kelly.herrera56@icloud.com7200 Market StSCOTTSDALEArizona85274GRP-9327··OPTIONS-PPO··
ENRENR-1243102026-05-28T13:06:11ZJoshuaC··Hicks1938-10-10UHC-89302-30•••-••-0274·(545) 867-6089joshua.hicks@outlook.com4961 Harbor BlvdOrlandoFlorida··32882GRP-4898OPTIONS-PPO
PRVPRV-292492026-06-04T07:20:23Z Douglas—Cruz·1961-04-01——(281) 793-9656N/A9571 Baseline Rd·COLUMBUSoh43278NULLNULL
CLMCLM-4062822026-04-14T23:23:10Z·EricQReed·1967-11-15-•••-••-4973258-795-6415-6945 Ridge RdAtlantaga30358GRP-5594—
CLMCLM-4110962026-05-23T03:58:34ZBRITTANY—STEPHENS1/14/1945N/A•••-••-98019795777865—3384 OAK STREETColumbusOH43201GRP-5867·-
CLMCLM-4091632026-09-14T08:08:38ZNicole—Carter·1978-02-06UNKNOWNNULL—UNKNOWN··5698 GRAND AVENUEHouston··TX77048null—
ENRENR-1277562026-10-02T09:41:32ZARTHURTPARKER1971-03-13UHC-20503-28•••-••-3783(920) 760-8700ARTHUR.PARKER85@ICLOUD.COM680 Park PlaceChandlerArizona85241GRP-5991SELECT-EPO
CLMCLM-4107052026-04-24T09:46:54ZJacob—Johnston1989-01-28NULL··•••-••-45126762152256-8303 Park PlPlanoTX75027GRP-6298MEDICARE-ADV-B
ENRENR-1163252026-05-09T07:13:00ZAndrewK··Foster1955-10-12UHC-85895-32•••-••-6521·16394265330andrew.foster@gmail.com6503 Cedar LaneLas VegasNV89173GRP-9418MEDICARE-ADV-B
TPATPA-591902026-02-07T20:17:00ZMichelleR.Carpenter1960-07-18null—(654) 511-1132UNKNOWN8637 Ocean Ave··CHANDLER·AZ85278null-
TPATPA-588912026-07-16T09:24:16ZweiB.miller1949-03-27UNKNOWN•••-••-8601UNKNOWNN/A3062 CAMELBACK ROADPhoenixAZ85010GRP-6579CORE-HMO
PRVPRV-270392026-03-30T02:54:34Z·ANNA—CARPENTER7/20/1976UNKNOWNUNKNOWN12977720124ANNA.CARPENTER12@ICLOUD.COM7255 Ridge RdPhoenixArizona85098N/Anull
ENRENR-1414752026-09-15T12:39:13ZAshleyN.Carpenter1967-01-15UHC-08657-94—·9056009029ashley.carpenter@hotmail.com3832 Ocean AveDenverCO80255GRP-1888CORE-HMO··
PRVPRV-226542026-06-07T11:32:59ZJoan·····Mills1957-12-16UHC-84014-04•••-••-5950N/AUNKNOWN1972 Hillcrest Rd Apt 14ScottsdaleAZ85214-—
TPATPA-582832026-02-16T13:42:03ZStephen—Alexander1977-05-25—•••-••-0669916.563.6371null1435 INDIAN SCHOOL ROAD·Austin·TX78701N/A··
ENRENR-1269082026-07-29T02:15:48ZAaronQAndrews1995-07-06UHC-11785-20··•••-••-2013(532) 260-9100-4074 CENTRAL AVENUECharlotteNC28269GRP-8567CHOICE-PLUS-PPO
ENR ENR-1117292026-05-23T04:17:48Z MarianaD.Reynolds1962-01-23UHC-70487-07•••-••-1410296-561-6287mariana.reynolds@yahoo.com5259 Palm DrivePhoenixAZ85038GRP-2613CORE-HMO
PRVPRV-279232026-05-16T03:39:41ZJacob—Alvarado·1953-02-16—•••-••-1227+1 752 752 2087jacob.alvarado@yahoo.com8878 Ocean AvenueNashvilleTN37269—NULL
CLMCLM-4284572026-02-11T17:40:24ZJuditth—Castillo1969-12-01-NULL·(245) 550-5351JUDITH.CASTILLO@GMAIL.COM7486 MAIN STNashvilleTN37235·-MEDICARE-ADV-B··
CLMCLM-4177482026-08-18T15:39:27ZJose——05/02/79UHC-23800-23•••-••-47847915452789null1716 Ridge RdNashvilleTN37283GRP-7917—
CLMCLM-4201472026-02-10T02:34:08ZSUE—YANG01/13/2000—null—null3414 CHURCH STJacksonvilleFL32295GRP-6365NULL
ENRENR-1066842026-04-19T10:00:45ZJacobs, Nathan··—19460704UHC-34860-04··•••-••-5357939-504-9935··nathan.jacobs@aol.com3405 Pine Dr #130··SeattleWA98114GRP-4570SELECT-EPO··
CLMCLM-4324022026-07-22T23:33:56ZPETER—MARSHALL··1968-10-23-•••-••-3508(341) 741-2237—6560 Camelback RdTAMPAFL·33646UNKNOWN—
ENRENR-1179092026-02-21T12:24:13ZVIRGINIA··—EVANS1957-07-28uhc-47098-36———6614 ELM STScottsdaleAZ85284GRP-2393SELECT-EPO
CLMCLM-4178392026-04-28T07:11:57ZNATHAN—PRKER06/24/1951UHC1177961N/A··null2088 Desert Sky BoulevardChandlerAZ··85288NULLUNKNOWN
CLMCLM-4116082026-07-28T03:28:44ZWeaver, Lawrence······Feb 4, 1964UHC-26133-98•••-••-54729292120024—3519 Church St Apt 15TempeAZ85219—·MEDICARE-ADV-B
CLMCLM-4253862026-05-10T07:02:02ZBryan—Stevens1978-01-24UHC-54097-15•••-••-19555073447355NULL—-UNKNOWNUNKNOWNGRP-2849N/A
CLMCLM-4174922026-02-07T12:42:05ZAlice—Bryant1967-08-03UHC-87888-26-3116580398null7231 Palm DrChandlerAZ85265GRP-8488··—
CLMCLM-4159852026-04-17T04:19:49ZYuki··Porter1995-02-05UHC-93362-68NULL-—8028 Mesa Dr·FresnoCA—GRP-3009—
ENRENR-1033152026-06-11T11:38:12ZJennifer··COliver6/16/1972UHC-34799-44•••-••-4926(660) 692-0658jennifer.oliver9@outlook.com9553 HIGHLAND AVENUESeattle···WA98153··GRP-8813OPTIONS-PPO
ENRENR-1150842026-02-09T16:19:51Zsteven—crawford1991-02-06UHC-53196-63•••-••-14454945908668steven.crawford@outlook.com8433 Market StreetLOS ANGELESCA90029GRP-6764OPTIONS-PPO
ENRENR-1331252026-01-02T18:34:18ZGeraldR.·Russell1951-07-01UHC9563260•••-••-6106(925) 203-0479gerald.russell23@outlook.com6855 MAPLE AVETUCSONAZ-GRP-3387CORE-HMO
ENRENR-1359212026-04-23T17:30:42ZDiane—Cole1946-01-26UHC-54127-33•••-••-0986502-510-4781DIANE.COLE23@OUTLOOK.COM5258 Church StCharlotteNC28291GRP-9983OPTIONS-PPO
ENR ENR-1378242026-05-15T17:40:49Zjanice—garrett1959-02-15UHC9314289•••-••-7800+1 352 450 7434JANICE.GARRETT79@YAHOO.COM2391 RIVER RDPLANOTX75045GRP-7483MEDICARE-ADV-B
100,000 rows, page 142 of 2,000PreviousNext

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.696Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty