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-4244362026-08-05T22:12:09ZBRADLEY—MORIS1956-11-20UHC-07576-73—UNKNOWN—4566 SPRING STREETTUCSONAZ85761—NULL
TPATPA-586912026-04-15T03:56:23ZCharles—Padilla1948-10-24N/A•••-••-0953——8669 Highland AveTempeAZ—GRP-1498NAVIGATE-HMO
ENRENR-114712 2026-09-18T03:24:24ZJOHNSGOMEZ03/19/58UHC-49320-75•••-••-0000+1 535 463 0642—·5201 PARK PLOrlandoFL—·GRP-1033MEDICARE-ADV-A
CLMCLM-4052942026-06-09T17:24:56ZCamilaTSnyder1993-06-09UHC-17020-16—(419) 634-1764null3515 Willow CtMiamiFlorida33192GRP-4228MEDICARE-ADV-A
CLMCLM-4111752026-02-23T12:33:13ZBetty—Wheeler15-10-2002null•••-••-4613nullBETTY.WHEELER@ICLOUD.COM·2733 Church StreetCharlotteNC28288GRP-6246null
PRVPRV-285032026-04-19T18:23:05ZHiroshiOHowell1963-09-13—null6724067669hiroshi.howell@gmail.com——————
ENRENR-1275142026-07-11T19:52:19ZGabrielWTorres·1962-04-24UHC-05549-07•••-••-1323792.746.9559GABRIEL.TORRES@PROTON.ME2356 DESERT SKY BOULEVARD··NashvilleTN-GRP-0360medicare-adv-a
TPATPA-543732026-08-18T19:24:56ZPAMELA—·HICKS1990-09-04UHC-20829-55•••-••-2561—NULL6514 Mountain View DrPlanoTX75056—N/A
CLMCLM-4117662026-03-29T00:07:24ZJeffrey—Vazquez2007-06-12——-—2458 Lincoln WayHOUSTONTX77061UNKNOWN—
ENRENR-1383602026-03-29T03:36:01ZKEN—BARNES1982-10-20UHC-22269-87··•••-••-7315(252) 789-9354NULL737 OAK STChandler··az85240GRP-5419MEDICARE-ADV-A
CLMCLM-4063412026-09-24T13:24:03Zfrank—guzman·2006-10-09UHC-66444-28—null—·1500 SPRING STREETFresnoCA··93723——
ENRENR-1282752026-06-16T03:29:21ZbrianQhunt1994-05-23UHC-00949-45•••-••-6466466-472-1685brian.hunt9@gmail.com1019 Harbor BoulevardAustinTX78716GRP-8692MEDICARE-ADV-A
TPATPA-603472026-06-24T16:12:10ZAlan—Simmons··1995-04-25UNKNOWNNULL(414) 236-1332N/A··4788 Indian School RdGilbertAZ85260GRP-7414··—
TPATPA-524102026-01-19T13:19:01ZROGER··—PORTER10-03-1992UHC6116762NULL345-727-6244roger.porter@gmail.com5095 Ridge RdChandlerAZ85256null··—
ENRENR-1238532026-01-29T03:18:53ZVincent—Thomas1939-06-11·UHC-72529-98•••-••-1008899-379-7926vincent.thomas4@yahoo.com1569 ELM STREET··Las VegasNV89177GRP-5745··SELECT-EPO
ENRENR-1304252026-09-06T16:01:53Z·emma—jacobs1996-10-14UHC-65539-03•••-••-1630+1 596 970 0598UNKNOWN3329 LAKE VIEW ROADDenverCO80249GRP-1021MEDICARE-ADV-A
ENRENR-1315672026-01-16T10:42:54ZLaura—·Patterson2006-10-22··UHC-50752-94•••-••-59889648179466laura.patterson64@icloud.com—nullN/A-GRP-8368NAVIGATE-HMO
ENRENR-1087462026-07-21T19:39:27Zmarianna···simmons1954-11-18UHC-37203-81—846-272-1761MARIANA.SIMMONS@HOTMAIL.COM5200 Desert Sky Blvd #406TEMPEAZ85279GRP-1792CHOICE-PLUS-PPO
ENRENR-1186132026-02-03T23:46:49ZOrtiz, Kathryn··—1976-06-15UHC-01209-57•••-••-7079802-307-2830kathryn.ortiz66@proton.me2638 INDIAN SCHOOL RD··AustinTX78777GRP-2492CORE-HMO
CLM CLM-4198002026-09-08T12:36:51ZDIANE—·REID1954-02-03··UNKNOWN4824190082NULL2365 Sage CtHoustonTX77045GRP-7325—
PRVPRV-242312026-01-05T23:12:58ZAisha—Ryan03/11/2006UHC-58675-91—9812238695UNKNOWNN/AN/A-NULLNULL-
ENRENR-1257232026-07-17T01:38:12ZTerryYBanks1947-12-03·UHC-30407-95•••-••-0231813-939-7603terry.banks@aol.com1760 Highland AveOrlandoFL32830-4696·GRP-9680SELECT-EPO
CLMCLM-4093462026-01-30T20:25:02Z·TIMOTHYXWEBER2004-08-09uhc-38193-02-8485910817null2356 Meadow LaneMINNEAPOLIS·MN-GRP-7225NULL
ENRENR-1147202026-05-28T13:57:46ZCHRISTOPHERKMILLER1980-09-02UHC-58051-99—·8089600520christopher.miller@yahoo.com5483 Bayshore DriveSAN ANTONIOTX78210GRP-4712OPTIONS-PPO
CLMCLM-4279252026-04-12T15:55:02Zsamuel—daniels1987-03-17UHC-09665-29—N/A—4305 HIGHLAND AVENUEMesa··AZ85290UNKNOWN—
ENRENR-1174422026-07-27T13:32:37ZORTEGAT.BRANDON1961-08-08UHC-07280-86•••-••-12059533484577brandon.ortega@aol.com4951 RIVER ROADSeattleWA98107GRP-9965OPTIONS-PPO
CLMCLM-4174182026-02-18T02:17:25ZSeanUCarpenter1954-10-05NULLnullnull-N/A-UNKNOWNNULLGRP-5165SELECT-EPO
CLMCLM-4221832026-09-24T16:09:48ZLewis, Marcus··——1981-05-06UHC-53639-04•••-••-4452393-982-7389null··2066 Main Street··ATLANTA·GA30343GRP-0933OPTIONS-PPO
ENRENR-1198882026-08-18T08:22:26ZDYLANPCARPENTER19970904UHC-57619-60•••-••-57828777707UNKNOWN2472 Ridge Rd·MinneapolisMN55452GRP-0217CHOICE-PLUS-PPO
ENRENR-1381222026-08-18T00:00:39ZStephanieN.Ruiz1960-09-07UHC-02243-45•••-••-7341+1 524 870 0134-7665 Mesa DriveLOS ANGELES··CA90093GRP-8839SELECT-EPO
CLMCLM-4072232026-03-15T07:07:37ZGlria—Rogers1984-03-18UHC4532947-———UNKNOWNnull····GRP-2907SELECT-EPO
TPATPA-59168 2026-04-21T16:49:15ZJONATHAN—SANHEZ·1941-08-06—•••-••-5591null·jonathan.sanchez68@aol.com6808 Lake View RoadTucsonArizona85788GRP-2167MEDICARE-ADV-B
ENRENR-104080 2026-02-27T22:22:23ZFATIMAA.JONES··1965-05-13UHC-49631-46N/A9498251916fatima.jones13@aol.com8055 Harbor BlvdSeattleWashington98167GRP-7206CORE-HMO
ENRENR-135557 2026-04-25T03:20:16ZJEREMYBHOWELL1981-03-25UHC-26033-66•••-••-4291(424) 513-5375-6008 Sage CtMinneapolisMN55474GRP-1208MEDICARE-ADV-B
TPATPA-556992026-01-14T22:17:11ZSandra—·Ngyen·1962-09-03—•••-••-9585·N/AN/A7065 SUNSET BLVDColumbusOH43220--
ENRENR-1172012026-07-06T18:07:37ZSofia—Lewis1938-03-27UHC-91831-67•••-••-5611361-586-1706—3032 Valley View DrMesaAZ85261··GRP-5963CORE-HMO
ENRENR-1298382026-01-10T18:23:33ZBetty—·Santiago1938-02-07UHC-84720-46null(976) 528-0152—6786 Elm StreetColumbusOH43213-9153GRP-7200··MEDICARE-ADV-B··
TPATPA-562202026-09-05T11:43:30Z·CHRISTIANU··HUGHES03/18/1943-—607-472-8764—9665 Willow CourtPhoenixAZ85077GRP-6016N/A
ENRENR-1083512026-10-10T08:34:33ZCamila··DMurphy19830106UHC-75358-97•••-••-3744(574) 219-1506camila.murphy@proton.me3039 Pine DriveGlendale·AZ85303-8092GRP-5926CHOICE-PLUS-PPO
CLMCLM-4269622026-07-26T01:38:39ZAna—Pyane8/3/1942UHC7110634—384-771-3900null-UNKNOWN·null·nullGRP-3361-
CLMCLM-4148382026-10-12T06:26:32ZLAWRENCETOWENSUNKNOWN··N/A-—lawrence.owens@outlook.com2445 GRAND AVENUEScottsdaleAZ85205GRP-9927N/A
CLMCLM-4185332026-01-15T12:59:06ZKIMBERLY—PIERCE1978-12-17UHC-02314-68-·NULL····8849 Valley View DrColumbusOH43253GRP-0198CHOICE-PLUS-PPO
CLMCLM-4135162026-09-27T06:01:45Z Elizabeth—Perez05/21/1978··UHC-65690-96—(793) 643-4049—7103 Pine DrDallasTX75278GRP-2089NAVIGATE-HMO
CLMCLM-4051392026-08-20T12:07:06Zraymond—schmidt1954-07-01UHC-32279-47——UNKNOWN8835 VALLEY VIEW DRJacksonvilleFL32261GRP-3485MEDICARE-ADV-B
CLMCLM-4039002026-05-16T12:32:32Z George—MaldonadoJun 28, 2003UHC-54438-55-—GEORGE.MALDONADO21@AOL.COM8555 PALM DRIVETampaFL33677GRP-4486—
ENRENR-1390712026-09-03T13:31:50ZGarza, Grace····—11/10/2002UHC-70601-88•••-••-27449006582811··-7828 Maple Ave Apt 40ChandlerAZ85281GRP-7839CHOICE-PLUS-PPO
CLMCLM-4190422026-08-17T12:28:15ZKAREN···RIVERA1984-05-22UHC-62284-61NULL643-959-5537-9144 Ridge RoadFresnoca93779GRP-4200-
ENRENR-1425532026-05-29T15:47:19ZMichelle·Z.Alvarez2007-03-11UHC-56884-74•••-••-57569882735027michelle.alvarez@aol.com1030 Oak StreetAustinTX78755GRP-4130MEDICARE-ADV-B
ENRENR-1329942026-04-01T03:59:19ZMARIANA—COOPER1973-01-21UHC-47049-46•••-••-1216(439) 832-7261mariana.cooper@aol.com3039 LAKE VIEW ROADAtlantaGA30302GRP-7106OPTIONS-PPO
ENRENR-1353732026-04-23T14:15:02ZHANNAH—GILBERT·May 15, 1994UHC-61909-96•••-••-0200UNKNOWNhannah.gilbert@aol.com1717 PARK PLColumbusOH··43218GRP-5686OPTIONS-PPO
100,000 rows, page 167 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.707Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty