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
PRVPRV-225432026-01-27T17:17:17ZJenkins, Deborah——2002-05-05—•••-••-7434(588) 273-4313-8137 Central AveHoustonTX77004N/Anull
ENRENR-1319782026-07-28T20:09:40ZRACHEL·CLAWSON19420323UHC-27077-99—+1 204 826 5282rachel.lawson82@icloud.com8742 PINE DRHOUSTONTexas77087···GRP-1508CORE-HMO
ENRENR-1075772026-10-14T19:38:11ZEricW·Burns1991-06-28UHC-77346-74•••-••-3151(809) 794-1750eric.burns65@icloud.com5566 PINE DRIVETempeAZ85240··GRP-1266CORE-HMO
CLMCLM-4282792026-07-02T13:49:59Zemily—montgomery2004-03-03UHC-51886-82•••-••-6030977-955-3021··233 Oak StreetDENVERCO80292··-CHOICE-PLUS-PPO
TPATPA-521832026-03-16T18:40:33ZSaar—Padilla··1982-07-06N/A•••-••-8586·+1 956 871 1550N/A690 MAIN STREET·TampaFL33683··nullCHOICE-PLUS-PPO
TPATPA-607712026-02-08T20:19:25ZRalph—Ruiz1950-05-14··UNKNOWNnull(817) 960-5979null5738 Valley View Dr Apt 28MesaAZ85298··-MEDICARE-ADV-B
ENRENR-1202962026-07-12T20:50:23Z·MasonE.···Wagner1961-12-20UHC2571226•••-••-39157124809239mason.wagner23@outlook.com868 LINCOLN WAYNashville···Tennessee37238GRP-6171CORE-HMO
CLMCLM-4014322026-06-25T23:14:41ZPierce, Sophia—····1973-09-23UHC0450142nullnullUNKNOWN6744 Desert Sky BoulevardGlendaleAZ85382GRP-2870SELECT-EPO
CLMCLM-4133942026-03-25T14:23:41Z·ELLIOTT—TYLER01/14/54UHC-10283-58•••-••-7835619-258-7292null6868 Hillcrest RoadPlanoTX··75038GRP-8548UNKNOWN
ENRENR-112457 2026-08-02T03:38:46ZLaura—Dunn1976-02-22·UHC-44881-02•••-••-6800(616) 655-7095·LAURA.DUNN64@OUTLOOK.COM8838 Park PlaceMesaAZ85200GRP-9161medicare-adv-a
CLMCLM-4266502026-09-20T08:46:40ZIsabella—GeorgeDec 24, 1944UHC-40296-74·N/A—NULL—null··—UNKNOWNGRP-5671OPTIONS-PPO
TPA TPA-541062026-01-20T08:25:48ZJerry—Anderson12/25/2006N/A·N/A—·null5218 Lake View RdSan AntonioTX78227nullmedicare-adv-a
CLMCLM-4108312026-04-05T11:00:01ZSteven·NGreen2007-05-26UHC-83463-90—+1 916 633 9086·steven.green80@icloud.com17 Oak StPLANOTX75011GRP-8644··
ENRENR-1373132026-05-19T08:49:46ZCHARLES—LONG1974-11-18UHC-87647-93•••-••-2400276-452-4129charles.long@hotmail.com9162 HILLCREST ROADSan AntonioTX·78265·GRP-5015OPTIONS-PPO
TPATPA-564102026-09-04T04:31:38ZPAUL—COOPER1984-05-19——··N/A732 Camelback RoadSan AntonioTX78283GRP-2878SELECT-EPO
PRVPRV-211282026-05-14T23:59:48ZHawkins, Judy——1942-06-04UHC-30240-19······8484872847JUDY.HAWKINS91@ICLOUD.COM1144 Washington Street·HoustonTX77089UNKNOWN····
ENR ENR-1362282026-02-06T16:47:51ZHiroshiHDixon1970-12-01UHC-68326-88•••-••-5492+1 841 658 4235hiroshi.dixon@gmail.com2468 Lake View RoadTempe··AZ85276GRP-3137MEDICARE-ADV-A
CLMCLM-4149362026-05-30T22:55:06ZTYLER··—GRAY2005-10-24null—-N/A3159 HARBOR BLVD #564GlendaleAZ-GRP-0578N/A
PRVPRV-248262026-04-19T16:17:33ZPHILIP—MARSHALL1941-02-24N/A•••-••-822517685352956PHILIP.MARSHALL60@ICLOUD.COM··3565 Broadway··TUCSONAZ85734-6938··——
ENRENR-1289882026-04-25T16:33:24ZDonaldRPatel1989-03-28··UHC-14764-41•••-••-9843772-441-4294·donald.patel@proton.me·958 CEDAR LANEDenverCO80283GRP-9596OPTIONS-PPO
PRVPRV-286272026-08-28T23:32:20ZDay, RaymondJ—07/02/1984-··18372569229UNKNOWN8570 MAIN STREETMiamiFL33153-4219-N/A··
CLMCLM-4112762026-08-19T10:17:01Zfrank····lawrence·1979-09-09UHC-94025-69UNKNOWN—N/A8715 Grand AveAtlantaGA30364-2288GRP-5542MEDICARE-ADV-A
TPATPA-635612026-06-05T21:32:15ZSimmons, Virginia—··1960-12-20··N/Anull—virginia.simmons@gmail.com4459 Canyon RoadMinneapolisMN55407—CORE-HMO
CLMCLM-4162892026-03-29T09:54:15ZPhilip—Brown10-03-2003UHC-75306-06•••-••-2337(671) 740-0471—429 Mesa DrJACKSONVILLEFL32286N/AN/A
ENRENR-1391172026-05-24T19:45:51ZParker, Mark——1995-01-16UHC-03784-08•••-••-8802879-886-2295··mark.parker@gmail.com5873 Mountain View DrAtlantaGA30396-3931GRP-1587MEDICARE-ADV-B
ENRENR-1145262026-07-09T18:45:30ZWilliam—Pierce19910514UHC-21838-18•••-••-77657646365649william.pierce6@aol.com6580 Lincoln WaySan DiegoCA92112GRP-3001MEDICARE-ADV-A
ENRENR-1405252026-05-17T11:37:44ZWILLIESHOLMES1977-06-04UHC-22394-73··•••-••-9899714-832-0101—6486 PALM DRIVEPhoenixAZ85091GRP-9485CHOICE-PLUS-PPO
CLMCLM-4307622026-08-12T03:51:22ZZacharyQ.Baker1952-04-10NULL———9465 Grand AvenueEden PrairieMN55345N/ANAVIGATE-HMO
ENRENR-1091792026-07-29T22:04:27ZBRIANBHAWKINS19940727···UHC1414052—(707) 610-9197brian.hawkins@aol.com··6391 Mesa DriveHoustonTX77049GRP-4616CORE-HMO
CLM CLM-4091372026-01-31T20:29:33Zteresa—munoz10/02/1989UHC-84425-40•••-••-5442(806) 767-8348—3237 PALM DROrlandoFL··32890-7710GRP-4645CHOICE-PLUS-PPO
TPATPA-576152026-01-02T21:46:31ZNancy—Hughes1990-72-05UHC-92987-80UNKNOWN6757855487··NANCY.HUGHES@YAHOO.COM7424 CEDAR LANELas Vegasnv89131—OPTIONS-PPO
TPATPA-637642026-09-29T20:39:27ZSHIRLEY—LEE1955-01-13UHC-46809-42UNKNOWNnull—429 CAMELBACK RDChandleraz85230—UNKNOWN
ENRENR-1349902026-06-29T21:08:13Znicole·Ulee1974-01-26UHC-13335-65•••-••-2317395.547.1006·nicole.lee@gmail.com7184 Hillcrest RdDallasTX75269GRP-9210NAVIGATE-HMO
ENR ENR-1099292026-05-13T19:14:44ZRobertson, JackU—1970-12-17UHC-88651-91•••-••-6061613-960-5593—883 Ocean AveTucsonaz85755GRP-1685MEDICARE-ADV-B
CLMCLM-4262782026-04-08T08:29:05Z·Valdez, Nancy——2002-06-24—•••-••-5109-null3019 PARK PLACETUCSONAZ85734null··SELECT-EPO
ENRENR-1196332026-09-05T13:32:39ZEmma—Robertson2008-07-02UHC-58103-58•••-••-0286800-400-8331—5593 SPRING STGlendaleAZ85324GRP-9121CORE-HMO
ENRENR-1093182026-01-18T16:17:13ZLAAURA··SSTONE1984-10-19UHC-63188-72•••-••-2990UNKNOWNlaura.stone49@outlook.com7846 WILLOW COURTSeattleWashington98190GRP-8874SELECT-EPO
CLMCLM-429698 2026-01-29T10:47:47ZDouglas—Banks19830106UHC-51125-18—·NULLNULL1901 Mountain View DriveSacramentoCA95895GRP-2284null
TPATPA-518302026-02-25T20:01:09ZKevin··—·Bakeer2001-01-12-—896-687-1486NULL9150 CHURCH STREETJacksonvilleFL32225····null
CLMCLM-4007922026-03-13T21:46:39ZROY—FISHER1967-07-02UHC-91505-50•••-••-6868—-323 Baseline RdTAMPAFL33699-·CORE-HMO
CLMCLM-4185512026-03-12T19:38:07ZEric—Bailey··1989-07-10UHC-12608-31-6162170791—9184 Highland AveTAMPAFlorida33676—null
ENRENR-1389742026-02-10T23:45:40ZLawrence—Ramirez19930311UHC-95611-07•••-••-5273nulllawrence.ramirez78@yahoo.com1423 Cedar Ln Apt 23TucsonArizona85769GRP-3654OPTIONS-PPO
ENRENR-1230302026-02-20T11:39:45ZHANNAH—PEENA1992-02-17UHC2575376•••-••-7751311-975-4984HANNAH.PENA@HOTMAIL.COM6473 CAMELBACK ROADSCOTTSDALEAZ85265GRP-1263·MEDICARE-ADV-A
ENRENR-1239132026-05-03T02:00:10ZDIANE—BARNES1956-12-03UHC7869364•••-••-0323·5219240164DIANE.BARNES80@ICLOUD.COM3474 RIVER ROADDenverCO80282-4197GRP-4286CHOICE-PLUS-PPO
ENRENR-1028012026-05-19T12:33:32ZAMYF.WRIGHT1999-04-28UHC-27128-15··•••-••-6145(262) 739-1349··AMY.WRIGHT@GMAIL.COM9776 Union StSan DiegoCA·92126GRP-9015SELECT-EPO
ENRENR-1161852026-07-02T00:09:49ZCaterineEKim1984-09-28UHC-20559-64•••-••-3547845.841.8887catherine.kim26@icloud.com3360 Church StMesaAZ85213-3016GRP-4820CORE-HMO
ENRENR-1329122026-09-05T22:03:14ZJackson, Emma——·1905-11-25UHC-14402-88•••-••-8570(689) 717-9127—1433 JEFFERSON AVENashvilleTN37238-6315GRP-5266··MEDICARE-ADV-A
ENRENR-1277792026-10-12T16:19:26ZLoganGCarr19390414UHC-24445-30•••-••-4377——1730 Cedar LnLas VegasNevada89168GRP-6333OPTIONS-PPO
TPATPA-526762026-06-21T07:04:24ZDONALD—LUNA1955-01-09UNKNOWN—nullDONALD.LUNA@ICLOUD.COM8713 Main StScottsdaleAZ85205—null
CLMCLM-4076972026-08-11T02:42:12ZTERRYMWHITE1936-10-19UHC-08193-23NULL··475-233-2073··N/A—nullN/ANULLGRP-9740-
100,000 rows, page 187 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.716Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty