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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-122046 2026-07-13T07:33:13ZfatimaIbryant06/19/01UHC-81628-53—3768483094fatima.bryant28@outlook.com5830 Willow CtFresnoCA93700GRP-0473SELECT-EPO
ENRENR-1384462026-07-23T01:32:04ZADAMAMURRAY1965-11-04UHC-44804-05•••-••-4094·5147526-474 PINE DRIVEColumbusOH43242GRP-9925NAVIGATE-HMO
ENRENR-1384762026-05-11T19:58:40ZJANETB.··MYERS1976-03-26UHC-34234-73•••-••-11733436329039JANET.MYERS99@OUTLOOK.COM1433 Jefferson AveJacksonvilleFL··—GRP-7320SELECT-EPO
ENRENR-1228962026-08-28T07:45:11ZEVELYN·TJENSEN2005-05-28UHC7227872•••-••-4712·(561) 657-7951—9886 Sage CourtPHOENIXaz85052GRP-8113·OPTIONS-PPO
ENRENR-1328832026-09-09T00:08:18ZSimmons, AmandaA—1945-02-14UHC-72306-59•••-••-56292098525970amanda.simmons55@yahoo.com4107 Indian School RdSan DiegoCalifornia92111GRP-3947··MEDICARE-ADV-A
ENRENR-1222032026-04-01T01:35:48ZChavez, Michelle··—1992-04-26UHC-36979-40•••-••-2758—MICHELLE.CHAVEZ@PROTON.ME5832 Sunset BoulevardScottsdaleAZ85288-2461GRP-5925CORE-HMO
ENRENR-1404022026-07-30T09:29:37ZRoberts, Wayne——16-04-1976UHC-40291-13•••-••-6990(774) 876-9308UNKNOWN5652 Canyon RoadAustinTX··78724GRP-6965MEDICARE-ADV-A
ENRENR-1189012026-01-04T14:46:52ZDavid—Sullivan9183-02-03uhc-29415-94•••-••-2612871-515-3745·DAVID.SULLIVAN12@OUTLOOK.COM7143 Palm DrEden PrairieMN55343GRP-5545MEDICARE-ADV-B
ENRENR-1131862026-05-28T23:19:24ZSandraANunezNov 26, 1977UHC-69103-39•••-••-7074(652) 267-6685SANDRA.NUNEZ@OUTLOOK.COM5624 Church StAustinTX··78784GRP-6810MEDICARE-ADV-B
ENRENR-1243612026-01-12T12:06:49ZMason—Fowler1940-01-28UHC-02372-66•••-••-19164247934688UNKNOWN606 PALM DRIVE #377Glendale·AZ85310·GRP-1872MEDICARE-ADV-B··
ENRENR-1375432026-09-29T02:18:20ZHIROSHIJANDERSON19561213UHC-20940-17UNKNOWN667-787-8937—8110 Desert Sky BlvdNASHVILLETN37282GRP-4970MEDICARE-ADV-A
ENRENR-1212882026-02-07T09:39:29ZThomasCStephensJun 13, 1986UHC9313685•••-••-44528272320636thomas.stephens64@outlook.com4569 Jefferson AvenueCharlotteNC28218GRP-7913CHOICE-PLUS-PPO
ENRENR-104939 2026-05-09T22:29:58ZEsipnoza, Vincent——1980-10-11UHC-29654-36··•••-••-27677965684784VINCENT.ESPINOZA@AOL.COM3999 Church StLas Vegasnv89101GRP-9531NAVIGATE-HMO
ENRENR-1273962026-04-13T23:07:51ZEmma—Soto1957-10-07UHC-80867-23•••-••-579417385433932emma.soto25@hotmail.com3951 PARK PLCharlotteNC28233GRP-6668MEDICARE-ADV-A
ENRENR-1360302026-04-23T16:02:42ZLAUREN—HOWELL··Nov 11, 1955UHC-02859-87——NULL5487 Meadow LnSacramentoCA95899GRP-9068MEDICARE-ADV-A
ENR ENR-1241162026-02-01T01:29:19Z·ASHLEYMNELSON1996-12-25UHC-79695-84··•••-••-8766955-478-1769—417 WILLOW COURTSEATTLEWA98129-9927GRP-7899CHOICE-PLUS-PPO··
ENRENR-1406512026-02-20T11:27:41ZKelly—Chapman01/12/1970uhc-53409-78UNKNOWN·(319) 444-2943·KELLY.CHAPMAN@GMAIL.COM3677 APACHE BLVDTampaFlorida33634GRP-8730OPTIONS-PPO
ENRENR-1260562026-10-14T20:44:08ZPayne, AlexanderU—4/3/2007UHC-40615-86•••-••-00742942080306alexander.payne78@aol.com241 RIDGE ROADTEMPEArizona85223·GRP-6992SELECT-EPO
ENRENR-1320672026-09-28T00:56:22ZJessicaB.Cox1982-09-27uhc-61058-29•••-••-8443825-712-6253-4717 Forest AveHoustonTX77091GRP-2364SELECT-EPO
ENRENR-1374292026-09-07T18:08:49ZVictoria—Hart1976-07-08UHC-02304-58•••-••-2750(810) 273-8134victoria.hart28@hotmail.com·NULLNULL——GRP-3621MEDICARE-ADV-B
ENRENR-1255032026-08-12T01:09:24ZJEFFREYTHALL1945-02-06UHC-39370-03•••-••-8756UNKNOWNjeffrey.hall@aol.com857 Forest AveMesaAZ85253GRP-2097OPTIONS-PPO
ENRENR-1065722026-07-07T12:53:34ZMarcus·QWad03-05-1951UHC-01655-80•••-••-930518878421034-8789 Park PlPlanoTexas··75059GRP-4277CORE-HMO
ENRENR-1355882026-05-06T19:16:43ZJEFFREY—REID··1999-03-15UHC-36073-68•••-••-3899(615) 693-0640jeffrey.reid@icloud.com1420 LAKE VIEW ROADAUSTINTX78700GRP-3994MEDICARE-ADV-B
ENRENR-1423922026-04-16T02:10:51ZMills, Denise——Mar 24, 1982UHC-44700-43•••-••-76535672689715··DENISE.MILLS@YAHOO.COM1110 Grand AvenueAtlantaGA30389GRP-3763NAVIGATE-HMO
ENR ENR-1094532026-02-09T17:01:10ZSofia—Robertson08/16/56UHC-53644-18•••-••-5318(346) 931-0412sofia.robertson87@proton.me1515 MARKET STREETPLANOTX-·GRP-7476MEDICARE-ADV-A
ENRENR-1006652026-06-28T11:39:56ZKaren—Freeman19620305UHC-66327-96•••-••-8867266-304-3265karen.freeman@gmail.com1843 Willow CourtSACRAMENTOCA95848GRP-4674MEDICARE-ADV-B
ENR ENR-1217342026-01-29T12:00:34ZnoahKmills2/1/1984UHC-03923-92•••-••-3751UNKNOWNnoah.mills85@hotmail.com9545 River RoadNASHVILLETN-GRP-6666SELECT-EPO
ENRENR-1383312026-05-27T08:29:02ZMegan··Jordan1973-05-70·UHC-30587-33•••-••-2650(338) 858-8391··MEGAN.JORDAN59@GMAIL.COM2809 Valley View Drive·AtlantaGA30319GRP-0675SELECT-EPO
ENRENR-136555 2026-06-24T12:54:01ZJesseWSchultz1965-03-14UHC1761617··•••-••-5766(513) 370-7580jesse.schultz99@hotmail.com1125 Apache BoulevardDenverCO80298GRP-1759CHOICE-PLUS-PPO
ENRENR-1278942026-06-01T00:53:11ZDylan—Scott01/17/1939UHC-87615-04—(260) 735-2085dylan.scott82@gmail.com4556 Ridge RdMiamiFlorida··33148GRP-5122navigate-hmo
ENRENR-1372102026-06-25T04:24:18ZWillieNChen2000-01-20UHC-69403-78•••-••-52328618493672willie.chen85@icloud.com120 BASELINE ROADHoustonTX77083GRP-2036MEDICARE-ADV-B
ENRENR-1352102026-07-23T22:20:22Zcharlotte—dixon1981-07-20UHC-64837-59··•••-••-74136177349728charlotte.dixon@outlook.com——N/A-·GRP-5165CHOICE-PLUS-PPO
ENRENR-1407502026-01-18T15:55:53ZRonaldECasrto1957-12-04UHC3303468•••-••-8815333-892-7381NULL2904 BROADWAYPlanoTX75054GRP-3012NAVIGATE-HMO
ENRENR-1048222026-10-03T10:07:10ZKim, Jason——1986-12-17UHC-17134-05•••-••-2192347-755-3904jason.kim79@proton.me2789 River RdSacramentoCalifornia95857GRP-3421MEDICARE-ADV-A
ENRENR-1017132026-06-24T16:14:11ZFrankC.Bell1985-04-10UHC-76492-45—NULLfrank.bell52@yahoo.com4741 Sunset BlvdDENVERCO80269GRP-4092CHOICE-PLUS-PPO
ENRENR-1162082026-05-11T09:49:56ZMaria—Welch1987-11-20UHC-75073-16•••-••-3114619-345-5388MARIA.WELCH@PROTON.ME4879 Cedar LnTucsonAZ85714GRP-3564SELECT-EPO
ENRENR-1058312026-03-04T17:16:26Z ·Janice·JThompson1963-04-24UHC-71698-05•••-••-1411(418) 601-6180janice.thompson@yahoo.com3803 Desert Sky BoulevardOrlandoFLUNKNOWNGRP-9268OPTIONS-PPO
ENRENR-1178292026-02-11T13:25:57ZKenneth—Hanson1970-11-25UHC-09326-08•••-••-524718386211126kenneth.hanson3@outlook.com242 Lincoln Way··CharlotteNC28228·GRP-3088NAVIGATE-HMO
ENRENR-124040 2026-06-22T18:33:06ZThompson, BrendaT····1986-01-18UHC-36650-08•••-••-1590+1 315 730 3561-7461 Lincoln WaySeattleWA98165-2669GRP-7107CORE-HMO
ENRENR-1145792026-06-09T07:02:18ZJordanWMorles··19520811UHC1023784•••-••-0453615-341-0818jordan.morales@outlook.com9688 Forest AvenueAtlantaGA—GRP-3439SELECT-EPO
ENRENR-1341612026-02-06T00:41:52ZNATALIE—OBRIEN··1969-07-27UHC1017682•••-••-35545435550647natalie.obrien@icloud.com5256 Apache BoulevardPLANOTX75024GRP-9566NAVIGATE-HMO
ENRENR-1113502026-01-05T22:45:55ZmatthwO.dayApr 4, 1971UHC-65445-38•••-••-45772849282812matthew.day21@proton.me6402 Pine DriveCharlotteNC28210GRP-4562CORE-HMO
ENRENR-1268292026-06-29T04:08:27ZCharlesU.Fowelr2006-05-02UHC-37024-92-6576268161charles.fowler@gmail.com4648 CHURCH STTAMPAFL33657GRP-2551··CHOICE-PLUS-PPO
ENRENR-1113652026-04-14T04:52:11ZnatalieCdaniels20070211UHC-71846-20•••-••-8719(834) 510-7726natalie.daniels44@aol.com1686 RIDGE RDMinneapolisMN··55483·GRP-8202CORE-HMO
ENRENR-1240752026-03-12T22:38:04ZEmmaKTran1967-11-12UHC-03345-98•••-••-8798(449) 960-1696EMMA.TRAN@ICLOUD.COM3327 APACHE BOULEVARD··CHANDLERAZ85276GRP-9127NAVIGATE-HMO··
ENRENR-1138942026-08-18T17:12:59ZRandy—Daniels19450611··UHC-90910-84•••-••-2649388-216-3376UNKNOWN··4653 Highland Avenue Apt 27AustinTX78748··GRP-6633MEDICARE-ADV-A
ENRENR-1123642026-07-04T08:44:42ZStephenMFowler2001-09-27UHC-96013-13NULL-N/A9290 Forest AvenueChandlerAZ-GRP-6067SELECT-EPO
ENRENR-1382552026-07-05T06:45:00ZBRANDONI.GUZMAN19810204UHC-78043-58•••-••-538418832576802null··1353 Elm StreetSacramentoCA95867GRP-4263CORE-HMO
ENRENR-1097502026-06-29T21:40:09ZMei—Thomas25-07-1944UHC-23359-43NULL··(726) 485-1757·mei.thomas99@outlook.com4925 Lincoln WayCharlotteNC28225GRP-7760OPTIONS-PPO
ENRENR-1395602026-08-03T02:51:00ZIsablla··Crawford·1950-05-23uhc-64929-99•••-••-96934734618525ISABELLA.CRAWFORD34@OUTLOOK.COM2664 River RoadEDEN PRAIRIEMN55301GRP-5446NAVIGATE-HMO
43,101 rows, page 79 of 863PreviousNext

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