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
ENRENR-1131042026-02-14T18:01:31ZBEVERLY—CRAWWFORD2006-09-16NULL•••-••-3106·(529) 896-1910UNKNOWN8793 VALLEY VIEW DRJacksonvilleFL32200GRP-0800CORE-HMO
CLMCLM-4124082026-04-25T21:46:50ZShirley··Hoawrd3/21/1995UHC-42640-50··3086782307····9430 Lincoln WayCHARLOTTENC28274··SELECT-EPO
ENRENR-1052522026-06-18T13:57:05ZHENRYRMILLS07/24/1943··UHC-00734-23•••-••-1401(572) 337-2649N/A4169 CHURCH STREETTempeAZ85222GRP-9043NAVIGATE-HMO
CLMCLM-4001472026-05-18T00:29:18ZCarlos—McCooy1998-06-19··•••-••-4525N/Anull—N/AN/AnullNULL-
ENRENR-1011992026-05-25T00:45:52ZAngela·JGardner1939-02-11·UHC-38497-83•••-••-3144—angela.gardner@icloud.com1589 JEFFERSON AVEPlanoTX75016GRP-8839OPTIONS-PPO
CLMCLM-4325952026-03-26T16:50:30Zemily—hamilton1958-04-24UHC-45306-29··—+1 792 778 4735—1869 Apache Boulevard #528San AntonioTX78278—NAVIGATE-HMO
ENRENR-1216972026-01-13T05:53:17ZSTEVEN—JORDAN··1952-07-11UHC-75588-91•••-••-6945NULLsteven.jordan6@outlook.com1330 BAYSHORE DRIVEMiamiFL33177GRP-2107CHOICE-PLUS-PPO
ENRENR-1105212026-02-16T21:16:30Z CHARLESB·BURTON1975-07-25··UHC-47128-17•••-••-2710256-278-5250charles.burton12@aol.com8927 Spring Street··CHANDLERAZ85234··GRP-2740MEDICARE-ADV-A
PRVPRV-228592026-02-16T04:22:51ZPriya——4/22/1949UNKNOWN··null+1 575 538 8631··priya.roberts31@hotmail.com7499 MARKET STREETLas VegasNevada·89101—N/A
ENRENR-1366982026-01-29T06:50:16ZmadisonF·armstrong11/26/1938UHC-15551-67•••-••-68224154165390madison.armstrong77@proton.meNULL--—GRP-8479CHOICE-PLUS-PPO
TPATPA-544022026-04-21T13:37:02ZEmma—Medina1946-10-22—•••-••-86817182319918N/A···N/ANULL—GRP-6610N/A
CLMCLM-4322512026-06-26T00:25:06ZCATHERINE—ROMERO1952-02-09NULLnull(944) 537-9019-9615 Camelback RoadTempeAZ85263UNKNOWNMEDICARE-ADV-B
CLMCLM-4228612026-08-06T11:41:17ZDIANA—SANTIAGO··02-12-1990—•••-••-64742425485707null7726 Oak StTempeAZ85202GRP-2721N/A
PRVPRV-267692026-02-21T08:37:29ZBetty—Gardner1960-44-20UHC-30425-67•••-••-0744282.309.8523BETTY.GARDNER42@YAHOO.COM7139 Lake View RdFresnoCA93763-NULL
CLM CLM-4169552026-01-06T12:17:43ZJANYCE—CARPENTER1984-04-20—·null786-777-5858·janice.carpenter@aol.com2154 Hillcrest Rd·JacksonvilleFL32213GRP-3112CHOICE-PLUS-PPO
CLMCLM-4162412026-07-24T01:40:16ZJerry—Andrews1953-01-18UHC-76255-49NULL-······3655 Camelback RdTucsonAZ85792GRP-3293OPTIONS-PPO
ENRENR-1147622026-01-12T10:58:20Zcarlos—spencer1952-05-26UHC-03040-35—(572) 281-9371CARLOS.SPENCER@GMAIL.COM1250 SAGE CTMinneapolisMinnesota·55429GRP-4688MEDICARE-ADV-B
ENRENR-1412162026-08-22T19:02:59Z Edwards, MarkE—19561011UHC-45206-33•••-••-10897097737311·mark.edwards47@aol.com7708 Highland AvenueEden Prairie··Minnesota55339-9719GRP-7170MEDICARE-ADV-A
PRVPRV-232832026-09-29T19:13:32ZSusanNHoward1994-01-09·nullN/A·3035682945susan.howard@aol.com9163 Willow CourtPlanoTX75089NULLUNKNOWN··
PRVPRV-219872026-04-19T13:22:48ZWillis, Aaron——1938-05-01UHC-70017-39-·6162576NULL8138 RIDGE ROADLos AngelesCA90021—·UNKNOWN
ENRENR-1417432026-02-09T13:16:55ZdianaJ.salazar02/17/01UHC-69415-54•••-••-3556937.557.4820—9622 Desert Sky BlvdSacramentoCA95884GRP-4074MEDICARE-ADV-B
ENRENR-1307682026-02-20T02:53:15ZCATHERINE—KELLEYOct 15, 2004UHC-76862-04•••-••-5739(387) 657-2925catherine.kelley@icloud.com2734 Pine DrJACKSONVILLE··FL32205GRP-5030··NAVIGATE-HMO··
TPATPA-54618 2026-07-18T07:08:06Zfrank——04/08/83N/AN/A··UNKNOWN····8890 LINCOLN WAYChandlerAZ85223N/A—
ENRENR-1146512026-10-07T16:48:58ZCatherineKJensenOct 25, 1947UHC-06420-48—5464331855catherine.jensen38@gmail.com4835 GRAND AVENUETucsonAZ85735GRP-9704MEDICARE-ADV-A
TPATPA-641612026-05-07T04:01:52ZIsabella—Dominguez2001-11-14··—NULLNULLNULL3224 Union StreetOrlandoFL32850—NULL
ENRENR-1424752026-08-01T04:27:45ZJEREMY—MENDEZ··09/14/1987·UHC-21632-60•••-••-8589666.979.5351UNKNOWN9855 Sage CtTampaFlorida33660GRP-5723··OPTIONS-PPO
TPATPA-623512026-05-31T17:28:57ZCHRISTINE—YOUNG04-10-1978UHC-29927-75UNKNOWN-christine.young@aol.com6594 Sunset BlvdOrlandoFL32870—N/A
CLMCLM-4178672026-03-05T17:42:39ZSeanNHicks19710122UHC-17934-68null··——NULL---GRP-6074—
ENRENR-1267552026-10-01T21:14:20ZEvelyn··—Ramos9189-05-05UHC-70497-07•••-••-556316395603325··evelyn.ramos21@yahoo.com8644 Elm StreetPlanoTXNULLGRP-4998CORE-HMO
ENRENR-1197662026-04-09T04:28:20Z Arjun—Rojas19960822UHC-54131-59•••-••-4280476-399-2693UNKNOWN6172 Market StNashvilleTennessee37286GRP-4453NAVIGATE-HMO
ENRENR-1056942026-04-28T20:05:33Z·Andrea—Scott···Nov 13, 1942UHC-49963-79•••-••-3958(549) 420-8731—5272 Maple AveChandlerAZ·85271GRP-4836OPTIONS-PPO
ENRENR-1364982026-07-06T02:57:34ZANTHONY—MYERS1978-05-08UHC-74006-37•••-••-8298·+1 342 240 5515anthony.myers@gmail.com4764 Sunset Boulevard #930Eden PrairieMN55334GRP-4018NAVIGATE-HMO
CLMCLM-4006932026-09-03T02:15:00ZROBERT—·NCIHOLS10/24/07UHC-85970-41NULL6913974850N/A5023 Cedar LnSeattleWA98131nullN/A
CLMCLM-4148272026-01-10T13:33:48ZCHRISTINA—ORTEGA07/03/1971·UHC-06273-61•••-••-5031——2874 River RoadTUCSONAZ85765UNKNOWNNULL
CLMCLM-4206382026-05-29T05:13:16Z ———1994-10-23·UHC-58138-74•••-••-6327null—-NULLNULL—GRP-6963null
ENR ENR-100728 2026-07-03T07:20:53ZMADISONFCOOK1960-01-25·UHC-96515-99—4014081478madison.cook59@yahoo.com8386 Spring St·TucsonArizona85738GRP-3453CHOICE-PLUS-PPO
PRV PRV-275702026-04-16T11:49:48ZKATHLEEN—DAY1966-11-21UHC-04206-33null4146753098-·3932 Meadow LnTampaFL33660—null
ENRENR-1246092026-10-06T06:40:01ZCAROLXWALKER1946-02-09UHC-06553-34—(946) 248-9514··NULL8826 CANYON RDSacramentoCA95891-9704··GRP-9830SELECT-EPO
ENRENR-1370662026-07-02T21:11:13ZcatheirneTtaylor1942-11-26UHC-40952-61•••-••-0043·(961) 533-3401null7794 PARK PLACELas VegasNevada89146GRP-8235··CORE-HMO
PRVPRV-282342026-01-02T17:57:24Zcheryl—richards1997-05-27UHC-37478-59·N/A·435-571-5397N/AN/AnullUNKNOWN··N/A——
ENRENR-1074262026-01-15T10:32:44ZRAMOND··PPATEL12/18/1947UHC-94437-25•••-••-5174627.989.5240raymond.patel@yahoo.com5334 Meadow Ln··DenverCO····GRP-0809SELECT-EPO
ENR ENR-1178892026-05-05T15:27:02ZJames—RihcardsonJan 12, 1980UHC-23684-06•••-••-2718(486) 414-7668james.richardson@yahoo.com9452 Mesa DrOrlandoFL32871GRP-7022CHOICE-PLUS-PPO
ENRENR-1358412026-06-01T09:08:51ZSARAHFFREEMAN2008-03-23UHC-43778-26•••-••-5732874-367-5533sarah.freeman@hotmail.com7830 HILLCREST RDTempeAZ85206GRP-2423MEDICARE-ADV-B
ENRENR-1343662026-04-17T03:29:36Z Russell J.—Holmes07/10/1969UHC-68851-64•••-••-9575+1 411 385 8348russell.holmes41@gmail.com6297 Sage Ct #452··AtlantaGA30312GRP-8967CHOICE-PLUS-PPO
ENRENR-1215912026-02-06T13:15:14ZLAURAABLAKK1958-12-07UHC-92939-08·N/A(370) 200-6820laura.black27@hotmail.com3594 Washington StreetHoustonTX77092·GRP-8089NAVIGATE-HMO
CLMCLM-4305002026-09-13T16:28:31ZMelissa—Lewis1999-01-05UHC-02738-68•••-••-1899677.201.0880N/A5700 Apache BoulevardLas VegasNV89125GRP-9133—
TPATPA-563272026-07-24T08:18:03Zluis—riley06/19/71NULL··•••-••-6227—NULL8644 Apache BoulevardLos AngelesCA·N/A·N/AOPTIONS-PPO
PRVPRV-260352026-05-25T16:53:12ZMelissa—Ramos2002-06-10UNKNOWN—+1 876 376 9108melissa.ramos@aol.com7751 Bayshore DriveChandler·AZ85233-5736UNKNOWN··-
ENRENR-131339 2026-05-24T21:21:11ZRALPH—HOFFMAN1983-12-26UHC-55886-66•••-••-02345636661849ralph.hoffman@aol.com··962 INDIAN SCHOOL RDSeattleWA98107-0955GRP-6503NAVIGATE-HMO
CLMCLM-4224482026-06-05T03:01:40Z JEERRY—MORRISON2001-04-26—•••-••-9501(576) 798-6753NULL4585 Ridge RdSacramentoCalifornia95859GRP-2375CHOICE-PLUS-PPO
100,000 rows, page 257 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:37.753Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty