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-1205852026-08-13T01:49:04ZTHERESADGREEN1949-11-06UHC-97725-62•••-••-3979(665) 518-6500theresa.green81@proton.me··3226 PARK PLSacramentoCA95885GRP-0897SELECT-EPO
ENRENR-1357672026-05-17T15:41:52ZMARCUSK··JENSEN11-07-1968UHC-67757-30N/A4988649885NULL·2794 Pine DrSan AntonioTX78242··GRP-2361OPTIONS-PPO
ENRENR-1379562026-06-07T01:43:00ZJessica—Reid1948-12-23UHC-60761-77•••-••-0646·(888) 764-2688jessica.reid63@icloud.com··8259 PARK PLACEJacksonvilleFL32287-8136GRP-5583OPTIONS-PPO
ENRENR-1355602026-02-21T04:18:59ZEDWARD—RODRIGUEZ1958-12-22UHC-77559-31•••-••-8729(209) 364-4560edward.rodriguez@gmail.com·6694 Bayshore Drive Apt 17JACKSONVILLEFL32210GRP-7643OPTIONS-PPO
ENRENR-1103362026-02-08T17:07:25ZGeraldV.Martinez·Oct 3, 1955UHC-27156-84•••-••-8264(598) 456-7185GERALD.MARTINEZ12@GMAIL.COM4734 Grand AvenueDALLASTX·75298GRP-5629MEDICARE-ADV-A
ENRENR-1410432026-03-16T09:39:42Z·KimberlyO.Hill19451218UHC-03341-58•••-••-7404770-748-2301kimberly.hill2@gmail.com1065 Camelback RoadSan AntonioTX·78264GRP-6582NAVIGATE-HMO
ENRENR-1186242026-05-14T01:52:48Z·KELLYTBROOKS19860821UHC-44730-34•••-••-9565537-501-4455kelly.brooks49@icloud.com8921 MOUNTAIN VIEW DRChandlerAZ85207GRP-5746OPTIONS-PPO
ENRENR-1182792026-03-30T03:59:13ZRyan··OHunt··03/21/1986uhc-48459-73•••-••-46465488772611-6165 Ridge RoadTEMPE···AZ85234GRP-6122CORE-HMO
ENRENR-1212492026-09-26T02:35:15ZLoganBRichardson19-04-1978··UHC-37659-40•••-••-0661+1 318 274 2384NULL5259 HIGHLAND AVEFRESNOCA93783GRP-2202·SELECT-EPO
ENRENR-1224422026-10-05T13:56:28ZChristina—Hamilton10/13/1958UHC-45758-40•••-••-6795297-545-2179UNKNOWN5486 Willow Court·MinneapolisMN·55484GRP-6072CORE-HMO
ENR ENR-1176132026-06-19T09:38:24ZOliver, Jeremy··Q—08/04/75UHC-40783-65•••-••-34625094458···jeremy.oliver@outlook.com6752 Palm DrChandlerAZ—GRP-4286NAVIGATE-HMO
ENR ENR-1241922026-03-08T10:34:47ZmatthewJsanders09-06-1980UHC-81713-56null8088326583matthew.sanders67@outlook.com2148 Baseline RoadAtlantaGA30320··GRP-2320CHOICE-PLUS-PPO
ENRENR-1064082026-06-06T20:15:59ZCarolyn—Lane27-12-1965UHC-35998-11•••-••-9315822-492-0257CAROLYN.LANE59@HOTMAIL.COM9646 MESA DRSacramentoCA-·GRP-6250OPTIONS-PPO
ENRENR-1287862026-02-03T19:54:02Z Albert—Diaz1944-07-06··UHC9473052•••-••-8785790-699-2008albert.diaz@hotmail.com3720 CHURCH STREETNashville··TN37298-6469GRP-4239MEDICARE-ADV-B
ENRENR-1165182026-08-22T07:48:33ZGerald T—Valdez1959-02-26·UHC-29944-62•••-••-1952(805) 234-5682GERALD.VALDEZ@HOTMAIL.COM··5759 Broadway···PlanoTX75029GRP-7940NAVIGATE-HMO
ENRENR-1158502026-08-01T01:46:36ZAmy—·Dunn10/02/46uhc-41815-99··•••-••-4429(846) 531-7929UNKNOWN2622 CAMELBACK RDCHANDLERAZ85282·GRP-9752SELECT-EPO
ENRENR-1238742026-05-18T03:00:21ZVALENTINAR.··OLSON1955-12-12UHC2956318-(494) 393-9026null5864 Highland AveHouston··Texas77048GRP-5247SELECT-EPO
ENRENR-1422912026-06-27T03:57:35ZCARL·QMCCOY0054-19-66UHC9101394-··+1 609 829 8021CARL.MCCOY@OUTLOOK.COM6685 Sunset BoulevardAustinTX78784GRP-2633CORE-HMO
ENRENR-1220832026-04-19T21:51:14ZMEI—COX10/14/1967··UHC-89027-61•••-••-95243287756083MEI.COX@GMAIL.COM6181 INDIAN SCHOOL RDSacramentoCA95806GRP-0700MEDICARE-ADV-A
ENR ENR-1242982026-06-25T18:25:18ZLoriGOwens2001-12-12UHC-02350-65•••-••-0726654-789-2071LORI.OWENS82@ICLOUD.COM5917 Ocean AveTampa·FL33669GRP-3109MEDICARE-ADV-A
ENR ENR-1078922026-07-19T07:14:17ZDeborah—Vasquez1956-12-13UHC-04821-42—+1 379 278 8435—6123 Highland AveSan DiegoCA92150-8882GRP-0434core-hmo··
ENRENR-1371872026-08-09T01:16:16ZJuliaTGutierrez1958-06-12UHC8562635•••-••-9087·-julia.gutierrez@yahoo.com2184 Washington StreetDallasTX75223GRP-6723MEDICARE-ADV-B
ENRENR-1180192026-03-14T05:53:08Z MichelleMSchultz1957-06-07UHC-25246-36•••-••-4300(860) 535-5818michelle.schultz@yahoo.com8375 Forest AveTempeAZ85215GRP-6282MEDICARE-ADV-B
ENRENR-1033492026-07-29T07:20:57ZemmaAperez··25-09-1997UHC-52568-47—(502) 214-4702emma.perez19@yahoo.com5635 Oak StreetGilbert··az85241GRP-1035··MEDICARE-ADV-A
ENRENR-1064872026-10-01T02:03:38ZBobbyI.Rodriguez1953-05-08UHC-68797-41•••-••-72863869332186··-2710 Lincoln WayFresnoCalifornia93791GRP-9060NAVIGATE-HMO
ENRENR-1225482026-03-06T10:09:49ZLawrence··UGrant19-01-1966UHC-64977-89··•••-••-2217·3008060546NULL3509 SUNSET BOULEVARDTempe·AZ85269GRP-6460OPTIONS-PPO
ENRENR-1392702026-04-11T23:10:20Z Dennis—Riley1940-11-02UHC-54348-02•••-••-29932233767424dennis.riley@icloud.com5149 Meadow LaneColumbusOH43226GRP-0112CORE-HMO
ENR ENR-1257442026-06-17T01:05:22ZJEREMYACHENAug 4, 1968UHC9890598•••-••-3909901-642-5683JEREMY.CHEN@HOTMAIL.COM6714 Grand AveGlendaleAZ85327GRP-0479MEDICARE-ADV-A··
ENRENR-1379462026-03-25T07:24:13Z·VincentK.Castillo·1979-05-52UHC-39871-55··•••-••-2703586-560-7373VINCENT.CASTILLO48@PROTON.ME858 BASELINE RDChandlerAZ85233GRP-6975MEDICARE-ADV-B
ENRENR-1158752026-04-23T06:18:32ZLarrySCarlson19680907UHC-21900-73•••-••-7442866-328-9047larry.carlson82@outlook.com9728 CAMELBACK ROADSan DiegoCA92144-3103GRP-3072MEDICARE-ADV-B
ENRENR-1195672026-05-30T16:46:38ZMartinez, TheresaS—2003-02-12UHC-45441-28•••-••-9915949-959-9770theresa.martinez79@outlook.com2399 Valley View DrNashvilleTN37283GRP-4801SELECT-EPO
ENRENR-1405522026-02-06T01:35:33Z Roger—Chavez·05/02/71UHC-06007-39•••-••-9828538-854-3540ROGER.CHAVEZ1@GMAIL.COM6965 BroadwayMiamiFlorida33159GRP-3805SELECT-EPO
ENRENR-1343162026-03-10T22:38:29ZCHERYL··PADILLA···1978-04-06UHC-20056-04•••-••-92616446686372·CHERYL.PADILLA86@GMAIL.COM9498 Forest AveTempe··AZ85260GRP-1159CHOICE-PLUS-PPO
ENRENR-131372 2026-02-11T09:48:51ZWalterX.Ray11/28/91UHC-99412-10•••-••-19698155760992walter.ray@icloud.com1070 Cedar LaneAustinTXN/AGRP-2268CORE-HMO
ENRENR-1329742026-08-26T06:23:16ZKimberlyXHarris1969-04-21UHC-91348-73•••-••-1282379-514-3964kimberly.harris14@outlook.com5289 Valley View Dr··San DiegoCA92102GRP-0592navigate-hmo
ENRENR-1366172026-09-26T04:38:43Z·BARBARA—ELLIOTT1941-02-08UHC-80311-77•••-••-3638936.791.1877barbara.elliott67@proton.me·6512 CANYON RDColumbusOH43251GRP-8937··SELECT-EPO
ENRENR-1054882026-02-05T09:42:47ZRichards, Jonathan——09/07/86UHC-51651-96•••-••-2420(691) 434-2207N/A4292 Camelback Rd·CharlotteNC28231-9504GRP-9420MEDICARE-ADV-A
ENRENR-1409922026-07-24T13:35:18ZseanZflores1975-04-12·UHC-22023-59—595-504-9187sean.flores@outlook.com8026 CAMELBACK RDMiamiFL33122GRP-3390NAVIGATE-HMO
ENRENR-1271972026-03-21T08:36:32ZEMMA—HUNT··2/17/1984UHC-70237-17UNKNOWN8986135660—·3835 Central AvenueMIAMIFL33161GRP-6490CHOICE-PLUS-PPO
ENRENR-129977 2026-04-16T03:34:45ZmarcusPnelson·1980-01-11UHC-84146-05•••-••-7752(373) 468-4156marcus.nelson41@proton.me5807 OCEAN AVEORLANDOFlorida32857GRP-7383NAVIGATE-HMO
ENRENR-1284422026-01-15T12:56:48ZJESSSEO.COX·15-04-1950UHC-66938-21•••-••-6827910.518.5320—2098 Church StFresnoCA93750GRP-4837SELECT-EPO
ENRENR-1386542026-09-01T16:58:54ZHarold—Barnes1995-04-05UHC-11839-77•••-••-6998872-520-8417harold.barnes56@aol.com683 HILLCREST RDJacksonvilleFL32299-1255GRP-5433NAVIGATE-HMO
ENRENR-1127842026-09-01T09:47:46ZSOFIA··—DEAN1988-09-15uhc-65371-02N/A—sofia.dean@outlook.com4411 MARKET STAtlantaGA30385GRP-7444··options-ppo
ENRENR-1165352026-01-24T20:32:22Z—N—1959-01-02··UHC-04096-41•••-••-7071806-719-8149douglas.nunez@outlook.com4598 Spring StreetDallasTX75262GRP-3068MEDICARE-ADV-B··
ENRENR-1251322026-06-13T23:34:43ZANTHONY—COLEMAN1905-11-28UHC-38948-17•••-••-2048—ANTHONY.COLEMAN@AOL.COM2779 Mountain View DrMinneapolisMN55421GRP-5249CHOICE-PLUS-PPO
ENRENR-1152932026-10-01T04:56:31ZAndrewCRamirez02/13/2005UHC-07301-34•••-••-1990—andrew.ramirez63@gmail.com6236 Hillcrest RoadCHARLOTTENCUNKNOWNGRP-0213NAVIGATE-HMO
ENRENR-1166282026-01-26T20:54:26ZEugene—Martin8/3/1959UHC-81837-40•••-••-5578+1 901 582 1768eugene.martin14@proton.me7056 Oak StDallastxNULLGRP-4078NAVIGATE-HMO
ENRENR-1276672026-07-23T03:44:01ZMadison—Adams19840118UHC-70742-05•••-••-4089—madison.adams@yahoo.com··5739 Oak St·GilbertAZ85258GRP-2155OPTIONS-PPO
ENRENR-1095412026-02-10T07:59:59ZLISA·J.BRYANT1997-02-06UHC-10875-81•••-••-8829+1 926 818 4628null5893 MEADOW LANE··Nashville··TN37224GRP-5652CORE-HMO
ENRENR-1227722026-01-13T08:58:41ZNANCYPHANZON1949-09-28UHC-79786-97•••-••-6452+1 679 503 4579nancy.hanson@outlook.com2085 Apache BlvdSAN ANTONIOTX78252GRP-4671··OPTIONS-PPO
43,101 rows, page 283 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.440Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty