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-1122632026-10-08T20:58:35ZMarkBDavisJun 10, 1962UHC-18118-85•••-••-6289·NULLmark.davis@proton.me1403 Pine DriveMesaAZ85248GRP-8177OPTIONS-PPO··
ENRENR-1175572026-06-29T04:55:34ZOLIVIA—ROBERTSON·1950-11-13UHC-92375-65•••-••-165315592256717·olivia.robertson@gmail.com·4970 Grand AvenueHouston··TX77091GRP-4388OPTIONS-PPO
CLMCLM-4013892026-04-03T17:14:57Zscott—evans1939-08-08UHC-99603-38—751.741.7209null9001 Union StNashvilleTN37274GRP-5512OPTIONS-PPO
ENR ENR-1327282026-01-02T22:50:52Zbrittany—alvaredo19910917UHC-89357-17•••-••-1492597-582-6766—7794 BASELINE ROAD #601Phoenixaz85044GRP-8578SELECT-EPO
ENRENR-137148 2026-02-28T05:12:01ZAHSLEY—JIMEENEZ1917-12-23UHC-92358-67··•••-••-107519584953788NULL7437 Forest AveJacksonvilleFL-GRP-2256CHOICE-PLUS-PPO
CLMCLM-4221892026-04-22T08:19:33ZRaymond—RobinsonApr 12, 1942N/A•••-••-6417893-556-7214—1979 Union StreetAtlantaga30370GRP-8902CHOICE-PLUS-PPO
ENRENR-1202762026-01-29T00:16:57ZDeborahA.LewisNov 25, 1993UHC-89079-11•••-••-89807155689372DEBORAH.LEWIS@GMAIL.COM3727 WILLOW CTCharlotteNC·28205GRP-1276MEDICARE-ADV-A
PRVPRV-219112026-09-04T06:53:03Zjesse—pierce19600211nullN/A(443) 909-3185NULL8153 BroadwayLas Vegas··NV89190——
ENRENR-1101832026-01-14T16:30:38ZChristina—Young19460115UHC-65599-85NULL453-354-4179N/A1509 Maple AveDENVERCO—GRP-9362MEDICARE-ADV-A
ENRENR-1047652026-06-29T16:23:46ZMoreno, Daniel——1998-12-25UHC-23626-94•••-••-74046303292198daniel.moreno@proton.me5133 BroadwayEDEN PRAIRIEMN55358-4303··GRP-9227SELECT-EPO
CLMCLM-4308132026-09-18T02:56:11Z andrea—harrisonJun 22, 1956N/A•••-••-9115-NULL1180 MEADOW LANEPHOENIXAZ85054··GRP-6490UNKNOWN
ENRENR-1156982026-09-20T15:46:32ZKAYLAXWHEELER1959-05-28UHC-93146-81N/A(731) 551-4621kayla.wheeler@proton.me3581 Palm DrGlendaleAZ85361GRP-6211··CHOICE-PLUS-PPO
CLMCLM-4046722026-07-30T18:38:59ZJacobAElliott1986-05-14UHC-71005-90—NULLJACOB.ELLIOTT@HOTMAIL.COM8435 Camelback RoadSacramentoCA95809GRP-2297—
ENRENR-116767 2026-06-04T03:00:47ZTurner, EthanU····7/21/1979UHC-63512-82•••-••-564414725798708UNKNOWN3909 Central AvenueSeattlewa··98119GRP-1641CORE-HMO
TPATPA-517512026-02-01T14:54:57ZMCHAEL—MARSHALL1971-09-20NULL•••-••-0745385-742-0765UNKNOWN5910 Main Street··DenverCO80250UNKNOWN—
ENRENR-1266282026-05-22T12:27:54Z·Joe—Moreno1979-11-20UHC-55158-75•••-••-5735465-750-0539joe.moreno48@hotmail.com8522 Main StreetAustinTX78796GRP-6023MEDICARE-ADV-A
CLM CLM-432616 2026-04-21T05:48:46ZLewis, Ann——1960-10-11UHC-05814-43•••-••-8644nullann.lewis@icloud.com7741 Mesa Dr Apt 10TampaFL33681-6198nullCORE-HMO
ENRENR-1032172026-05-17T13:26:30Z·AUSTINCHOLMES1976-02-25··UHC-67964-27•••-••-2124(389) 932-1696AUSTIN.HOLMES33@ICLOUD.COM1540 BASELINE RDCharlotteNC28262GRP-8758CORE-HMO
CLMCLM-4045132026-05-16T14:32:02ZBRYAN··—FREEMAN1951-11-21—-786.686.2770NULL7670 Valley View Drive Apt 6PlanoTX75079—null
PRVPRV-246182026-05-26T07:38:39Zbeverly··—hunter11/15/1996UHC-61579-57··nullNULL·BEVERLY.HUNTER48@YAHOO.COM121 DESERT SKY BLVDPlanoTX75041—OPTIONS-PPO
CLMCLM-4111722026-07-10T12:29:50Zjuan—dixonApr 10, 1982UNKNOWN··—juan.dixon51@outlook.com··7198 Church StreetAtlantaGA30367GRP-3373—
ENRENR-1282042026-01-09T01:04:51ZJulie—Hoffman03/12/40UHC-83320-02•••-••-0561+1 647 658 4349julie.hoffman@gmail.com5665 PARK PLACEEden PrairieMN55392-2264GRP-3205CORE-HMO
PRVPRV-254112026-02-24T12:05:59ZBrue—·Olson6/21/1938—NULL(486) 453-9108BRUCE.OLSON@ICLOUD.COM—nullN/A—N/AOPTIONS-PPO··
TPATPA-560652026-01-01T12:31:59ZSCOTTH.HAMILTON1944-01-26UNKNOWN•••-••-553616845883514-234 BroadwayOrlandofl··NULLUNKNOWN
ENRENR-1391892026-09-21T04:30:31ZsandraSrios2006-03-11UHC-43703-75··•••-••-9449708-607-4594SANDRA.RIOS86@YAHOO.COM8800 Pine Dr Apt 32SACRAMENTOCA95874GRP-2521·OPTIONS-PPO
ENRENR-1350012026-04-19T22:54:52ZReyas, MatthewD—1955-11-13UHC-49750-83•••-••-6043—matthew.reyes12@gmail.com8544 Central Avenue Apt 16AustinTX78742GRP-6206CHOICE-PLUS-PPO
PRVPRV-261112026-10-01T21:52:40Z—E—2000-05-06UHC-64732-99—767-942-6234null7447 Central AvenueMiamiFL33171N/AUNKNOWN
CLMCLM-4160212026-03-06T21:15:19Zmark—hartJan 20, 1986-•••-••-21338049933833N/A··9124 PARK PL··AtlantaGA·30313GRP-1431MEDICARE-ADV-A
ENRENR-1127562026-10-03T10:46:23ZEugene—Coleman01/20/86UHC-30788-02•••-••-8944818-864-5196eugene.coleman21@hotmail.com9066 Ocean AvenueAustinTX78748GRP-9985SELECT-EPO
CLMCLM-4316102026-09-22T01:36:30ZHeather—Cruz1979-04-21UHC-18089-98UNKNOWN··12159256455NULL····nullNULLnullUNKNOWN·NAVIGATE-HMO
CLMCLM-4068212026-02-04T00:53:35ZMelissa··—Fox1979-01-22UHC-13839-35•••-••-2705(484) 873-6745·-2330 Ridge RoadFresnoCalifornia93744GRP-2739null
ENRENR-1422602026-08-23T14:11:01ZJOAN·ZPARKER1960-01-22UHC-42430-01N/A723-269-3417joan.parker@aol.com··6988 LAKE VIEW ROADLos AngelesCA90038GRP-0849·OPTIONS-PPO
ENRENR-1083352026-09-12T09:54:33ZWhite, Michael——02-01-2003UHC-58953-75-567-922-9266michael.white@outlook.com6143 Union St Apt 16DenverCO80267GRP-5369CHOICE-PLUS-PPO
CLM CLM-4281572026-03-13T11:17:03ZGERALDMGARZA·1945-04-09UHC-07051-35··N/ANULL·UNKNOWN3829 Main StreetDenverCO80234—N/A
CLMCLM-4254302026-09-17T16:45:02ZWilson, Denise—··1987-11-14UHC-05747-60•••-••-7403—-UNKNOWNnull—null··—
CLMCLM-4318112026-07-23T08:01:17ZJuan—Carlson19730823uhc-78684-93UNKNOWNUNKNOWNN/AUNKNOWNNULLNULLN/AGRP-9378—
TPATPA-628942026-03-21T17:06:59ZISABELLA—FOX1977-01-22··—N/A··(415) 955-1595null9600 Highland AvenueColumbusOH43286-—
ENRENR-1406042026-07-23T16:46:22ZEric—Padilla1974-08-07UHC-33676-04•••-••-98023236727547··ERIC.PADILLA76@YAHOO.COM8843 Jefferson AveSan DiegoCA92130··GRP-1014··CHOICE-PLUS-PPO
TPA TPA-591092026-10-01T10:00:19Zbryan—graham04-09-1999——null-301 Baseline RdDenverco80251UNKNOWNUNKNOWN
ENRENR-1248152026-01-20T07:57:40ZAMANDA—KING07/04/1986UHC-82173-56•••-••-8244329-923-0443amanda.king@outlook.com829 Willow CourtTempeAZ·85288GRP-5659·SELECT-EPO
ENRENR-1137872026-08-10T10:08:17ZJulieXCox1948-06-25UHC-21280-53•••-••-7573341-838-6041julie.cox67@icloud.com4661 Market Street··AUSTINTX78737GRP-7764SELECT-EPO
ENRENR-1209862026-02-03T05:37:07ZLuciaQHawkins2008-01-14UHC-18251-37•••-••-5658+1 434 537 3950LUCIA.HAWKINS@OUTLOOK.COM6889 OCEAN AVENUETempeAZ85218GRP-2486MEDICARE-ADV-B··
CLMCLM-4290212026-05-18T01:05:48ZNancy—Martin··7/28/1947UHC6635074•••-••-6866—N/A··7326 HIGHLAND AVETempeAZ85243GRP-9879—
TPATPA-525982026-10-15T17:04:28Zalan—carr1966-03-01—--NULL7594 Sage CtGlendale··AZ85373N/Anull
ENRENR-1146882026-10-09T13:30:05ZMarilyn—Aguilar19810701·UHC9881807•••-••-6258(338) 750-2877·marilyn.aguilar68@aol.com1980 Ocean AvenueMIAMIFL33119GRP-4257NAVIGATE-HMO
CLMCLM-4058352026-01-24T19:51:33ZHIROSHIYPRICE23-01-1975UHC-21169-37··NULLNULLnull—N/A——-··UNKNOWN
CLMCLM-4203172026-06-19T17:31:29ZBlack, Lori——07/21/53UHC-24306-35—408-953-3436N/A·4320 RIVER RDFRESNOCA93743··GRP-0549N/A
ENRENR-1253452026-03-04T07:35:05ZHannahKLane1981-02-02UHC-85848-94•••-••-5445(984) 549-7613HANNAH.LANE2@PROTON.ME4374 Grand AvenueJacksonvilleFL32203GRP-3205NAVIGATE-HMO
CLMCLM-4205952026-08-30T15:51:33ZEVELYN··—MORRISON13-09-1986-•••-••-5114null—1846 Maple AvenueTampaFlorida33635GRP-9678null
TPATPA-620322026-05-26T22:54:50ZOrtega, ChristineW.—19690922··N/A—nullchristine.ortega7@aol.com·3529 MARKET STSan DiegoCA92177-3393GRP-3842OPTIONS-PPO
100,000 rows, page 170 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.708Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty