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-4265652026-09-09T11:42:53ZALAN—HOLMEES1965-06-28·UNKNOWN-(598) 250-9524-4324 Baseline RdMesaAZ85275—null
TPATPA-585462026-08-28T12:41:54ZjeremyH.gomez1972-08-09null•••-••-3917UNKNOWNUNKNOWN5315 MESA DRMinneapolis··MN55462GRP-1718OPTIONS-PPO
CLMCLM-4077542026-07-01T10:45:41ZALBERT—ORTIZ21-11-1973-•••-••-0807——5853 Union StPhoenixAZ85051··—
CLMCLM-4019772026-10-13T06:56:51ZCHARLES R.—JACKSON···09/05/47nullUNKNOWN·363-323-1835CHARLES.JACKSON@YAHOO.COM—N/ANULLUNKNOWNGRP-1524UNKNOWN
ENR ENR-1237152026-10-16T05:35:57ZJulie—Salazar1945-11-07UHC-75947-68•••-••-6054(456) 825-3507julie.salazar@hotmail.com7977 Forest AvenueSacramentoCA95807GRP-3876MEDICARE-ADV-A··
ENR ENR-1275642026-07-05T05:53:40ZBarnes, Deborah····—03/09/95UHC-31108-31•••-••-1651(553) 411-2107·DEBORAH.BARNES@YAHOO.COM8022 Hillcrest Road·MinneapolisMN55460GRP-5479CORE-HMO
PRVPRV-244922026-03-07T15:14:55Z·Aaron—Estrada1994-05-27UHC-74678-88N/A—NULL433 HILLCREST ROAD #854San Diego··CA92122NULL-
TPATPA-595532026-05-08T09:07:38ZALAN—BRADLEY··1971-09-10—•••-••-3172449-517-0482N/A5458 Oak StreetTampaFL33633-null
ENRENR-1374232026-07-01T12:44:01ZDiego—Fissher8/4/1960UHC-25301-98•••-••-06063823714663diego.fisher76@gmail.com872 JEFFERSON AVENUEColumbusOhio43295GRP-8133MEDICARE-ADV-B··
ENRENR-1329562026-03-16T02:11:58ZArthurZWaallaceJul 10, 1961UHC-29082-43•••-••-09356658667099null4639 Lake View RdTucsonArizona··85766··GRP-7422OPTIONS-PPO
CLMCLM-4200072026-10-05T16:48:20ZDixon, Patricia——1980-05-05-—nullUNKNOWN4078 Elm StreetCharlotteNC28210——
CLMCLM-4298612026-03-09T00:13:59Zsara—murphy01-07-1953UHC-72812-48··null15945430014····8753 Palm DrPlanoTexas75082GRP-4645SELECT-EPO
ENRENR-1189222026-08-12T18:23:00ZRussell··Snyder19850505UHC-96661-27•••-••-0741N/A··russell.snyder@hotmail.com5414 Maple AvenueDenverCO80264GRP-1324MEDICARE-ADV-B
CLMCLM-423263 2026-06-18T22:40:55ZraymondIsnyder1975-01-06UHC-68621-79N/A+1 707 531 8291-2895 Park PlaceDenverCO80280GRP-6802N/A
ENRENR-1046072026-01-26T01:02:27Z MEGAN—DAVIS·1994-06-27UHC-00007-16•••-••-4557(909) 642-7424·megan.davis77@aol.com4311 Church StAtlantaGA30320GRP-6769MEDICARE-ADV-B
CLMCLM-4161842026-06-11T16:13:51ZDavidVDavis1948-04-05UHC-44621-94•••-••-9710N/Adavid.davis27@gmail.com—NULL—N/A—-
ENRENR-1160272026-09-21T19:51:59ZNANCY—BURTON1983-05-02UHC-12094-80•••-••-9636(735) 773-7778NULL3984 LAKE VIEW ROADScottsdaleArizona85221GRP-5559·CHOICE-PLUS-PPO
ENRENR-1108962026-01-05T01:19:29Z PAMELA—HICKS1951-06-04UHC-52905-09N/A·(516) 457-2256N/A5492 HIGHLAND AVESeattleWA98198GRP-1938CHOICE-PLUS-PPO
TPATPA-623762026-04-15T10:32:27ZKENQHAMILTON1985-10-18uhc-66672-48•••-••-5712——4095 LAKE VIEW RDSacramentoCA95883GRP-6545N/A
CLMCLM-4139652026-07-23T02:45:52Z·Nguyen, David····—01/25/1945UHC-96172-78NULLnullNULL·7133 Camelback RdAustin·TX78740GRP-9820··CHOICE-PLUS-PPO
CLMCLM-4150452026-04-28T07:28:25ZCarolyn—Bennett1962-07-28—····(339) 432-2127-4016 Baseline RdJacksonvilleFlorida32221GRP-8744·CHOICE-PLUS-PPO
CLMCLM-4297452026-08-27T19:48:07ZJerry—Freeman01/28/1959UHC-67528-45UNKNOWN887-558-6339N/A6752 Lincoln WayGlendaleAZ85358—··
CLMCLM-4060022026-05-13T00:36:38ZKATHERINEB.·NUNEZ21-04-1961UHC-09963-36•••-••-3574·6555648154-——-—GRP-1290NAVIGATE-HMO
CLMCLM-417529 2026-02-25T21:34:20ZJeffrey—Singh2008-01-28UHC-30073-49UNKNOWNUNKNOWNUNKNOWN3844 Cedar LnLas VegasNV89168GRP-3182—
TPATPA-592582026-07-26T23:12:03ZBRITTANY—·KING1947-10-03-•••-••-8916NULLN/A5343 Indian School RdHouston·TX77094NULLMEDICARE-ADV-B··
CLMCLM-4227962026-04-03T06:31:42Z SHIRLEY—HUNTER03/17/58·UHC-87251-20NULL834-466-2722—4214 Spring StreetSan Diego··California92173nullN/A
CLMCLM-4315092026-02-06T05:42:47ZLISA—·CASTROJan 19, 1991·UHC-96067-72•••-••-6860——4502 Lake View Road Apt 29San DiegoCA92118GRP-1625CHOICE-PLUS-PPO
ENRENR-1006722026-04-10T10:49:21ZCARRL····ALVARADOSep 23, 1938UHC-22730-30•••-••-6204441-580-5614carl.alvarado@outlook.com2830 Maple AvenueSACRAMENTOCA95803GRP-1559OPTIONS-PPO
ENRENR-1078142026-01-04T04:25:32ZKEITH··Z.WILLIS06/07/46UHC-74143-65•••-••-2258278-841-5730NULL8299 Willow CtSAN DIEGOCA92187GRP-8137OPTIONS-PPO
TPATPA-630262026-01-08T12:25:50ZKYLE—RICHARDSUN01/01/76—•••-••-0150902-323-4080kyle.richardson@gmail.com-NULL-—GRP-1159null··
TPATPA-510072026-08-11T12:04:43ZAustin—Yang07/18/1983UHC-35695-44N/A8615822064AUSTIN.YANG@OUTLOOK.COM-———GRP-7817CORE-HMO
CLMCLM-4082422026-03-17T09:29:18ZDoris—·Dunn04/22/90N/A•••-••-1521null—6561 Valley View DrSCOTTSDALEAZ85289GRP-7604·OPTIONS-PPO
ENRENR-1050902026-09-06T01:30:47ZNatlaieQDunn1966-06-23UHC-17711-10•••-••-4795285.230.9296NATALIE.DUNN@GMAIL.COM4281 MESA DRLos AngelesCA90018GRP-0773MEDICARE-ADV-B
ENRENR-1226912026-07-19T08:25:56ZlawrenceZ.alexander1942-01-01UHC-22677-64•••-••-7172271.450.7162lawrence.alexander@outlook.com3342 CAMELBACK RDFresnoCA-GRP-6896select-epo
ENRENR-1047062026-07-26T07:32:35ZJACKM.KNIGHT10/20/55UHC-49193-58-(986) 868-5310jack.knight93@icloud.com252 SAGE COURTNashvilleTN37219GRP-1377MEDICARE-ADV-B
ENRENR-1183502026-05-28T04:49:06ZkeihtArios1962-08-24UHC-36163-12•••-••-1898804-752-6055keith.rios@outlook.com7688 Indian School RdSeattleWashington98151GRP-2841OPTIONS-PPO
ENRENR-1047102026-04-14T06:51:21Z MargaretYWalsh1939-12-26UHC-27596-24•••-••-2490475.466.5535-7355 SAGE COURTDenverCO80233GRP-6740CHOICE-PLUS-PPO
CLMCLM-4297472026-03-27T12:00:44ZlaurenMfranklin12/22/1954-•••-••-0774····nullnullnullnullUNKNOWNGRP-4369MEDICARE-ADV-A
CLMCLM-4201862026-07-01T05:58:57ZBRENDA—CLARK1987-12-05··UHC-60924-40UNKNOWN··null4157 Cedar Ln Apt 14OrlandoFL32810GRP-1870null
CLMCLM-4183542026-06-12T13:30:52ZLAWRENCE—·KENNETH1965-08-19UHC-46680-27•••-••-1502NULL—9367 GRAND AVESeattleWA98160—CHOICE-PLUS-PPO
ENRENR-1095592026-07-26T02:09:47ZSara—Mitchell2007-05-01UHC-43055-25•••-••-0167-—9648 Oak StreetTAMPAFL33636GRP-1574CHOICE-PLUS-PPO
CLMCLM-4227042026-02-26T10:36:36ZCunningham, Virginia——1956-10-16UHC-75540-38··•••-••-0416(351) 681-3664—2093 Bayshore Dr Apt 26CHARLOTTENC·28297GRP-1189SELECT-EPO
ENRENR-1358652026-02-13T16:26:43Z·Brittany—Henry2006-05-01UHC-69980-47•••-••-6158260-949-7641BRITTANY.HENRY5@PROTON.ME677 HIGHLAND AVE·AtlantaGA30387GRP-8904NAVIGATE-HMO
ENRENR-1061082026-08-11T08:12:26ZVirgniiaDPetersonNov 12, 2002UHC-94049-07··•••-••-8933775-325-1232null···4940 Lincoln WayOrlandoFL32888GRP-4395CORE-HMO
ENRENR-1163552026-01-05T21:11:01Zkimmberly··Nwheeler1943-01-21·UHC-50501-82•••-••-9246NULLkimberly.wheeler92@outlook.com8793 Mesa DriveDallas·TX75241·GRP-5589CORE-HMO
TPATPA-642652026-02-11T07:54:13ZTyler—Daniels1980-04-06—-9152512··tyler.daniels@outlook.com1390 Hillcrest RdLas VegasNV·89104NULLSELECT-EPO
ENRENR-1279322026-06-28T09:23:46ZJORDANN.CARROLL1963-04-26UHC-34809-76•••-••-58328036358972·JORDAN.CARROLL@ICLOUD.COM7063 Sage CtTucsonAZ85714GRP-5945MEDICARE-ADV-A
TPATPA-614922026-08-16T04:03:11ZDEBRA—·MARSHALL2003-04-13··null——N/A5514 Canyon RoadSeattleWA98135GRP-6577NULL
CLMCLM-4231492026-03-29T04:32:46Z MEAGN—THOMPSON2007-01-06··UHC0853497N/A745-377-7462—9786 UNION STREETOrlandoFL32896—CORE-HMO
ENRENR-1155922026-10-18T00:17:09Z vincent—jones1975-09-01UHC-15101-05•••-••-6738null··vincent.jones70@outlook.com3540 Jefferson Avenue Apt 25NashvilleTN37295GRP-7893NAVIGATE-HMO
100,000 rows, page 175 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.711Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty