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
ENR ENR-1341682026-04-29T00:19:32ZEvelyn—Alvarado1979-10-24··UHC-61170-74•••-••-5487306-521-7185—6542 Mesa DriveSAN ANTONIOTX78232GRP-8057medicare-adv-a
ENRENR-1281112026-10-02T08:47:11ZSean—Ramirez1951-04-28UHC-87258-34•••-••-8608·2073760SEAN.RAMIREZ90@PROTON.ME··1056 Apache BlvdSan Diego··CA92140GRP-8159MEDICARE-ADV-B
ENRENR-1358472026-10-12T02:01:19ZRUTH—GARRETT20031009UHC-34655-43•••-••-80179529143682RUTH.GARRETT@YAHOO.COM3904 Baseline RoadOrlandoFL32882-4293GRP-4173SELECT-EPO
ENRENR-1317762026-07-20T07:55:09Zcarol—bryant11/22/1990UHC-19112-85•••-••-9162(862) 702-6676carol.bryant@aol.com5725 BASELINE ROADSEATTLEWA98103GRP-5707choice-plus-ppo
ENRENR-1253772026-01-05T15:42:29ZSHARONN—1953-02-19UHC7091857•••-••-0936+1 547 623 1979sharon.perry11@gmail.com5356 Spring Street Apt 37·DenverColorado··80211-8119GRP-6474NAVIGATE-HMO
ENRENR-106590 2026-02-05T13:41:19Z·jeremyK.stephens1976-06-25UHC-19456-06•••-••-6105+1 286 986 9925jeremy.stephens@aol.com20 RIVER ROADLas VegasNV89129GRP-1836medicare-adv-a
ENRENR-1286822026-10-18T09:37:11ZNaathan—Simmons1977-02-21UHC-51233-44null·16286187275·nathan.simmons40@gmail.com3821 MEADOW LANE··MesaAZ85212-0322··GRP-3670SELECT-EPO
ENRENR-1129292026-04-17T09:32:57Z·albert—williams1960-08-14UHC-50412-25•••-••-9792+1 660 267 5424N/A5057 Forest Avenue #799AustinTX78727GRP-2713CORE-HMO
ENRENR-1385342026-01-19T06:19:58ZNANCY—SIMS1976-06-23·UHC-57979-93UNKNOWN765-525-0239nancy.sims@aol.com9620 HILLCREST RDAtlanta·GA—GRP-0905MEDICARE-ADV-A
ENRENR-1049372026-06-19T08:44:24ZMARIA—CRUZ1949-10-22UHC-56006-43•••-••-6884·16458067548maria.cruz70@proton.me2124 Ridge RdSan DiegoCA92142GRP-6456navigate-hmo
ENRENR-1185322026-09-04T17:28:15ZKARENNWELCH1/5/1955UHC-51273-02•••-••-4058(556) 811-9896—5842 Washington StPlanoTX75096GRP-8116MEDICARE-ADV-A
ENRENR-1043612026-04-16T03:56:12ZKevinUPrice19630828UHC-73391-84NULL4383989370kevin.price@yahoo.com3988 MEADOW LANEMesaAZ85249GRP-2911CORE-HMO
ENRENR-1409772026-06-03T14:07:15ZGary····Montgomery1958-03-17··UHC-72195-70NULL(253) 230-2813··1820 Washington StreetOrlandoFlorida32856GRP-2475MEDICARE-ADV-A
ENRENR-1270762026-04-24T08:18:52Z·lindaBmcdonald1980-04-09UHC-70228-56•••-••-7783(655) 655-0558—·6056 Highland AvenueAtlantaGA30385GRP-7982NAVIGATE-HMO
ENRENR-1218152026-05-16T01:13:18ZLogan—Bailey2001-10-07UHC-62349-08•••-••-5570218-681-2804logan.bailey29@gmail.com2684 Grand Ave··JacksonvilleFlorida32209GRP-8027SELECT-EPO··
ENRENR-1051442026-06-21T13:20:02ZArnold, Margaret····—19520228UHC-25383-74•••-••-73878799180451UNKNOWNUNKNOWNNULLN/AN/AGRP-1084OPTIONS-PPO
ENRENR-1080432026-07-12T04:49:32ZWilliamsonO.Katherine·Sep 8, 1989UHC-94440-19•••-••-8974568-562-8539null842 RIVER ROADNashvilleTN37215GRP-4270OPTIONS-PPO
ENRENR-1231512026-05-09T13:53:45Z·KeithCSanders0801-39-99UHC-17016-66•••-••-2203null—6170 Willow CourtAtlantaga30342GRP-9886CHOICE-PLUS-PPO··
ENRENR-1159982026-03-13T10:13:21ZRoberts, SeanA—1959-07-19UHC-73892-44•••-••-9910216-481-0149sean.roberts@hotmail.com7042 Ocean AvenueEden PrairieMinnesota55305GRP-1570MEDICARE-ADV-B
ENRENR-1298042026-04-15T13:32:32ZBrendaW.Simmons10-10-1969UNKNOWN•••-••-32619604581012N/A··2504 HILLCREST RDSAN DIEGOCA92181GRP-6134SELECT-EPO
ENRENR-1314102026-10-06T10:27:34ZJerryGSilva1958-10-15UHC-57526-35•••-••-588119442196523—8957 CAMELBACK RDChandlerAZ85243GRP-1486MEDICARE-ADV-B
ENRENR-130413 2026-04-02T20:13:03ZDeniseTVargas1949-10-23·UHC-01600-93•••-••-6609614-673-0135denise.vargas@yahoo.com4158 Central AvenueNashvilleTN37205GRP-6359SELECT-EPO··
ENRENR-1011132026-07-28T05:02:48ZhelenXmunoz1983-02-20UHC-59265-33··•••-••-5763824-974-6784helen.munoz@gmail.com1197 LAKE VIEW RDLas VegasNV89195GRP-6312core-hmo
ENRENR-1330982026-05-28T03:48:02ZRoger—LeDec 14, 1987UHC-84334-48•••-••-9609·(434) 633-3773roger.le63@yahoo.com9800 Cedar LnAustinTX78739-8793GRP-2144CHOICE-PLUS-PPO
ENRENR-1097312026-07-31T11:24:47ZMATTHEWXVALDEZ06/14/2002uhc-71925-83•••-••-2073—MATTHEW.VALDEZ@HOTMAIL.COM—NULL—-GRP-8572MEDICARE-ADV-B
ENRENR-1248052026-05-02T12:00:12Zcharles S—ramos1960-11-01UHC-32017-70-··677.423.9370charles.ramos86@aol.com5609 Camelback RdGlendaleAZ85309GRP-2582NAVIGATE-HMO··
ENRENR-1164882026-03-26T12:38:55ZLAWRENCE—HANSON2005-07-01·UHC-58414-02•••-••-9220+1 975 289 8872—1402 Indian School Rd #373·DenverCO80211GRP-7077SELECT-EPO
ENRENR-1215482026-08-24T23:26:59ZJohnL··Anderson4/13/1967UHC-74807-02··NULL··518-857-8800—9872 Ocean Ave #161Phoenix··AZ85087··GRP-5270SELECT-EPO
ENRENR-1041652026-06-12T05:11:20ZADAMJCAMPELL20070714UHC-00506-50•••-••-72808265384459·ADAM.CAMPBELL@AOL.COM3378 PALM DRIVEHOUSTONTX77025GRP-9056CORE-HMO
ENRENR-1252572026-09-21T23:32:41Z·SofiaGMcCoy12/21/39UHC-59505-87•••-••-91832519864935sofia.mccoy32@gmail.com5584 Palm Drive··LOS ANGELESCA90095GRP-6491SELECT-EPO
ENRENR-1404402026-04-14T20:48:55ZKatherine—Wheeler06/17/82UHC-14259-82•••-••-5325(945) 917-1020··katherine.wheeler73@outlook.com5094 MAPLE AVENUELas VegasNV89196GRP-0210SELECT-EPO
ENRENR-1096472026-06-13T10:04:55Zjeremy······harvey1965-06-25UHC-56546-03•••-••-328413142825643jeremy.harvey@icloud.com3677 PINE DRHOUSTONTX·77046-4598GRP-9218SELECT-EPO
ENRENR-1181402026-08-26T20:54:48ZLiasILi1965-09-03UHC-94232-43•••-••-1449790.355.1978lisa.li7@icloud.com3545 Indian School RdGlendaleAZ85372GRP-5217MEDICARE-ADV-A
ENRENR-1271902026-04-13T20:33:33ZMary··GNunez··6/23/1967··UHC-30029-90•••-••-9705407-808-2756mary.nunez35@hotmail.comN/AN/A—nullGRP-2434MEDICARE-ADV-B
ENRENR-1158872026-07-04T14:20:01Z ANDREW P.—LEE1991-10-06UHC-17562-92··-2407658201andrew.lee47@proton.me9648 Grand Avenue···Eden PrairieMN55342·GRP-8410MEDICARE-ADV-A
ENRENR-1327142026-05-15T05:54:17ZHeatherDOliver1949-11-15UHC-22718-53null(766) 488-5497heather.oliver79@gmail.com8051 Ridge RoadMiamiFL—GRP-6218MEDICARE-ADV-A
ENRENR-1265762026-04-27T17:19:21ZDYLAN—VALDEZ1988-11-08UHC-75352-30•••-••-97396544063882UNKNOWN2540 Maple AveDallasTX75222GRP-7554CORE-HMO
ENRENR-1031992026-08-04T20:14:19ZLucia—Lawson2004-09-19UHC-05342-02•••-••-93906573704898lucia.lawson@proton.me2123 CANYON ROADTucsonAZ85749··GRP-3428·NAVIGATE-HMO
ENRENR-1332022026-04-08T12:15:39ZSandra—Knight1956-08-03UHC-03596-42•••-••-4317—sandra.knight@aol.com6368 WILLOW CT Apt 24Tucson·AZ85796GRP-4408SELECT-EPO
ENRENR-1078822026-05-11T21:07:06ZLuisKReynolds03-04-1946UHC-81820-65NULL(405) 264-5021luis.reynolds25@proton.me—NULL——GRP-3820SELECT-EPO
ENRENR-1014642026-01-19T20:55:16ZStephenTBurns01/19/1972UHC-47911-67•••-••-7359425-469-4421stephen.burns@proton.me6488 Spring St··DenverColorado80276-1151GRP-5716SELECT-EPO
ENRENR-1005182026-04-18T14:07:26ZDebraE.Jensen1953-08-27UHC-06981-22•••-••-21037820399debra.jensen@hotmail.com5451 DESERT SKY BOULEVARDColumbusOH43227GRP-5108NAVIGATE-HMO
ENRENR-1310362026-06-25T18:22:15Z Dorothy—Bennett··1/24/1975UHC-49307-33•••-••-96737264722063dorothy.bennett83@icloud.com6411 Hillcrest RoadLos AngelesCA90064GRP-3216MEDICARE-ADV-A
ENRENR-1015542026-09-13T02:36:43ZJerry—Spencer19720722UHC-16233-26N/A—null5552 Oak StreetTempeAZ85213-5195GRP-9367SELECT-EPO
ENRENR-1282562026-10-15T07:06:43ZGaryFRodryguez··2008-10-26UHC-38044-13•••-••-6836(656) 777-5399gary.rodriguez@yahoo.com3031 Bayshore DrTucsonAZnullGRP-8239SELECT-EPO
ENRENR-1274762026-03-31T15:42:42Z AndreaVPeters1962-05-26UHC-05108-52•••-••-0821(925) 427-9059andrea.peters@yahoo.com5022 Lake View RoadTampaFlorida33675GRP-4012CORE-HMO
ENRENR-1102452026-04-19T15:21:08ZELIJAHZFORD1980-04-11UHC-75215-40•••-••-2489-ELIJAH.FORD@HOTMAIL.COM5637 MOUNTAIN VIEW DRDallasTX75264GRP-8754MEDICARE-ADV-B
ENRENR-1387832026-04-15T13:31:12ZAndrew—Ford···1967-04-18UHC-20167-98•••-••-7912(255) 719-0087andrew.ford89@outlook.com4446 Bayshore DriveSCOTTSDALEAZ85266GRP-6857CHOICE-PLUS-PPO
ENRENR-1324722026-09-08T21:01:16ZSofiaT··Lucas12-04-1969UHC-89122-72•••-••-4505660-644-2234sofia.lucas@icloud.com9873 UNION STREETAUSTIN··tx78744GRP-9903CORE-HMO
ENRENR-1078382026-02-12T03:47:31ZCheryl—Torres1995-02-26UHC-19193-75•••-••-6603+1 897 512 9326cheryl.torres48@gmail.com···3902 BASELINE ROADGilbertAZ··-GRP-2976OPTIONS-PPO
43,101 rows, page 278 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:43.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty