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-1078782026-09-25T11:40:41ZAMBER—VAZQUEZ19731018UHC-91224-37•••-••-9747(424) 826-1496-207 APACHE BLVD·NASHVILLETN··37212GRP-8533SELECT-EPO
ENR ENR-1114432026-07-29T12:56:50ZFreeman, HannahK—01/10/1989UHC-41971-97•••-••-0991+1 795 980 1389hannah.freeman39@icloud.com1191 PALM DROrlandoFLN/AGRP-8852CHOICE-PLUS-PPO
ENRENR-1158402026-02-10T21:16:57ZREBECCA—GREEE5/5/2006UHC-66153-41•••-••-6047nullN/A3070 Palm DriveTampafl33694GRP-7708navigate-hmo
ENRENR-1177622026-10-08T17:16:57ZJANETHVALDEZ04/01/1943··UHC-35323-58•••-••-36395244779931janet.valdez32@icloud.com7016 Ridge RdChandlerAZ85226GRP-3245SELECT-EPO
ENRENR-1305302026-07-07T04:55:44ZGeraldTRuizFeb 10, 1989UHC-14467-45•••-••-2432234-648-1263gerald.ruiz97@aol.com8019 Canyon RoadColumbusOH43251GRP-1659NAVIGATE-HMO
ENRENR-1164922026-06-11T01:40:31ZGutierrez, JasonE.—1971-06-19UHC2653302··•••-••-9220(371) 418-7582JASON.GUTIERREZ47@AOL.COM4563 Mesa DriveGlendaleAZ85302GRP-4271SELECT-EPO
ENRENR-1082152026-04-04T01:07:08ZEugene··PFreeman14-02-1938—•••-••-83532019155824EUGENE.FREEMAN35@YAHOO.COM8811 Sage CourtSCOTTSDALEAZN/AGRP-8496medicare-adv-a
CLMCLM-4180962026-04-03T12:21:46Z victoria—peterson·2004-03-17UHC-99908-60—+1 367 390 2205—5416 Sunset BlvdGilbertAZ85228GRP-0530null
ENRENR-1172342026-06-28T08:18:35ZVictoria—Fowler1982-06-02··UHC-96248-91•••-••-9377+1 923 994 0169·UNKNOWN4796 Hillcrest RdSACRAMENTOCA95879·GRP-7183CHOICE-PLUS-PPO
ENRENR-1310742026-01-18T12:00:16ZBRYYANK.HANSEN1939-12-13UHC-23945-12•••-••-1477NULLBRYAN.HANSEN37@GMAIL.COM161 FOREST AVENUEMinneapolisMN55478GRP-8470SELECT-EPO
TPATPA-598802026-03-30T10:00:07Zlori—porterFeb 14, 1946UHC-02218-88•••-••-42772658648981null8225 Grand AvenuePlanoTX75062nullSELECT-EPO··
TPATPA-544952026-05-17T23:28:49ZMICHAEL—EVANS2006-09-04-UNKNOWNUNKNOWNN/A·2201 Elm StreetNashvilleTennessee37245GRP-6224N/A
CLMCLM-4000192026-09-13T22:05:05Z Henry, AustinZ—2008-03-02UHC-53911-82—710-406-9848-NULLNULL·NULL——CHOICE-PLUS-PPO
TPATPA-621032026-10-03T14:56:07Z·Jeremy—Daniels05/05/1986UHC-66664-57UNKNOWNNULL—1579 Palm DriveSACRAMENTOca95830··UNKNOWN-
CLMCLM-4316142026-09-28T07:00:20ZSEAN—HAMILTON··1939-06-15N/A•••-••-0402N/A—·4965 Palm DriveSEATTLEwa98113-6363GRP-6024OPTIONS-PPO
CLMCLM-400713 2026-03-15T22:21:53ZMATTHEW··HAYES1993-02-07UHC-78677-80-4649219132NULL5670 River RoadDenver··CO80220GRP-0673NAVIGATE-HMO
ENRENR-1137252026-03-14T06:01:46ZNATHANSSANCHEZ13-11-1949uhc-34921-74•••-••-83289796243503nathan.sanchez@proton.me4029 Pine DrHoustonTX77093GRP-7865MEDICARE-ADV-A
ENRENR-1193262026-02-17T11:28:38ZEVELYN—BURNS17-10-1991UHC-64453-70null4719453EVELYN.BURNS@AOL.COM4461 Spring StreetTampaFL33671GRP-1619options-ppo
PRVPRV-204782026-06-30T06:15:38ZSANTIAGOXFORD1994-12-11UHC-19531-20N/A8246440751NULL179 Apache BlvdTucsonAZ85720UNKNOWNNULL
ENRENR-1265312026-08-09T05:38:36ZBobbyKVasquez1987-08-27UHC-39236-47•••-••-2409null··bobby.vasquez49@gmail.com776 Sunset BoulevardAtlantaGA30347GRP-6211NAVIGATE-HMO
CLMCLM-4261282026-03-11T06:06:36ZJOSEPH—HAYES1967-08-14UNKNOWN·NULLUNKNOWN——NULL—-GRP-5200medicare-adv-b
CLMCLM-4319192026-08-09T02:31:13ZAnn—Perez19930811UHC-58834-40—null—2559 Baseline Rd #496··PHOENIXAZ85046GRP-6900CORE-HMO··
ENRENR-1271362026-08-25T09:25:42ZTeresa—Meyer1943-03-14UHC-07697-73N/A3503589022TERESA.MEYER46@HOTMAIL.COM2292 Canyon RoadLos Angelesca··90013GRP-7888MEDICARE-ADV-A
ENRENR-1075352026-06-08T07:58:44ZRANDY—FRANKLIN1939-02-21UHC-11089-40•••-••-7051+1 691 924 4328randy.franklin@yahoo.com8402 Canyon RoadScottsdaleAZ85246-6286GRP-3776NAVIGATE-HMO
CLMCLM-4014592026-09-22T18:49:29Z·ALBERT—CASTRO1982-05-10UHC-91693-71•••-••-6153390.344.3809—3576 Desert Sky BoulevardSacramento··CA··95809nullMEDICARE-ADV-A
CLMCLM-4003322026-01-29T00:14:15ZTerry—Edwards··1951-05-18N/AN/A—N/A1429 DESERT SKY BLVDMiamiFL33169GRP-4954CHOICE-PLUS-PPO
ENRENR-1287092026-05-10T03:01:34ZKEVINOVALDEZ6/2/1944UHC-74950-66•••-••-8025-kevin.valdez99@proton.me2357 MOUNTAIN VIEW DRIVEJACKSONVILLEFlorida32232GRP-1790CORE-HMO
CLMCLM-4008072026-02-17T07:02:56ZDebra—Simmons20050627UHC-13215-75•••-••-4833(244) 332-7255·NULL———UNKNOWNGRP-4287—
CLMCLM-4005652026-05-20T03:19:54Z JANICE—KELLEY1960-05-25—•••-••-4854——5743 Pine DrLOS ANGELESCA90036—MEDICARE-ADV-B
ENRENR-1331612026-07-27T04:35:35ZKAYLAGSOTO1986-07-27·UHC-21614-94null8602595856kayla.soto@icloud.com·3156 MAIN STREETPhoenixAZ85079GRP-1730MEDICARE-ADV-B
CLMCLM-4110612026-03-07T03:20:04ZPRIYAP.RIVERA01/18/91UHC-73259-41—·+1 631 676 8422priya.rivera@icloud.com7262 Ocean AvenueOrlando·FL32880··GRP-9587MEDICARE-ADV-B
ENRENR-1330522026-05-06T13:32:11Z JACOB—JAMES··1992-08-23UHC-95959-82•••-••-7342(206) 373-0657jacob.james@proton.me757 Spring St·SEATTLEWashington98199GRP-8444···MEDICARE-ADV-B
ENRENR-1105912026-01-16T03:18:24ZJerryMSandoval1950-03-17UHC-94166-85•••-••-0567N/ANULL1736 CENTRAL AVEAustinTX·78705GRP-5547·SELECT-EPO
TPATPA-548992026-05-09T20:47:26ZRussell—AndrewsN/ANULL··N/A·-N/A2725 Pine DriveChandlerAZnullN/A—
TPATPA-579352026-04-04T00:17:42ZHudson, Debra——1999-06-22—null—NULL8828 Union Street Apt 14Atlanta··GA30327GRP-7969·OPTIONS-PPO
PRVPRV-205532026-02-21T05:10:59ZWarren, Emily——1996-07-11UHC-27010-24N/A-emily.warren@proton.me2811 CENTRAL AVEAustinTX78730UNKNOWNOPTIONS-PPO
CLMCLM-4138002026-02-06T19:31:53ZAngela—Mitchell1938-07-05UHC9696757•••-••-2109—angela.mitchell95@icloud.com2710 Valley View DrSan DiegoCA92105—MEDICARE-ADV-A
ENRENR-1285212026-03-27T03:59:23Z·AndrewB.··Hunt2008-11-21UHC-90052-31•••-••-8289756-952-5173·andrew.hunt@gmail.com7960 Meadow LnMesaAZ85209GRP-6691NAVIGATE-HMO
ENRENR-1163592026-03-18T03:26:11ZMATEOOTUCKER·1953-05-13UHC-12070-86•••-••-3830348-510-1636MATEO.TUCKER74@ICLOUD.COM278 Spring StreetAtlantaGA30396GRP-4192MEDICARE-ADV-A
PRVPRV-264982026-07-17T07:53:27Z———1956-12-06UHC-73484-68•••-••-18212032903503—6838 Maple AveDallasTX75299-null
CLMCLM-4283242026-09-24T17:35:35ZAngela—Johnston1938-09-11UHC-84082-76•••-••-7272UNKNOWNangela.johnston76@icloud.com-N/A—-GRP-3671N/A
ENRENR-1210542026-05-23T09:03:08Z YukiJKelley6/27/2007uhc-53122-07•••-••-8767·8748814105-4912 HARBOR BLVDColumbusOH43279GRP-9218NAVIGATE-HMO
CLMCLM-4300622026-02-26T14:59:57ZPTRICK—HAYES1989-06-27UHC-62613-40•••-••-12329055286223—·N/AN/A——GRP-9143—
ENRENR-1295162026-08-17T18:24:34ZKEVINYMARSHALL·04/04/1997UHC-22454-97•••-••-2768(771) 469-0933KEVIN.MARSHALL@HOTMAIL.COM8744 LAKE VIEW ROADGilbertArizona85259-2357GRP-4208SELECT-EPO
ENRENR-1123512026-09-12T04:43:33ZANNAS.CARLSON1992-01-24UHC-22854-38•••-••-17826602947481anna.carlson@outlook.com2529 Sunset BlvdGilbertAZ85252GRP-2034MEDICARE-ADV-B
CLMCLM-4030532026-09-02T05:20:02ZRichard—WrightJul 20, 1965UNKNOWNUNKNOWN826-519-4705N/A7463 Mesa DrAustinTX78731UNKNOWNNULL
CLMCLM-4033272026-07-24T12:18:40ZJEAN—KELLY20031120UHC-50100-19NULL5893437985—--nullNULLGRP-6155MEDICARE-ADV-B
ENRENR-1229052026-02-12T00:36:40Z·lawrence—russell1981-02-16UHC-68841-12•••-••-4930·(662) 319-4772·UNKNOWN7206 VALLEY VIEW DRIVE··Miamifl33112-5137GRP-5228MEDICARE-ADV-B
ENRENR-1045342026-02-23T22:21:33ZAna··BPeters3/16/1979UHC-03564-03•••-••-9574+1 870 450 6530—6986 Desert Sky BlvdAustinTX78716GRP-4927OPTIONS-PPO
ENRENR-103278 2026-03-23T19:50:38ZJason—Garza2003-03-24UHC-11309-94•••-••-8942-···jason.garza@outlook.com9491 HIGHLAND AVENUEGlendaleAZ85395GRP-5466NAVIGATE-HMO
100,000 rows, page 256 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