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-1284182026-06-05T11:11:08ZDIANE··—WASHINGTON9/26/1980UHC-61110-34•••-••-51036663162469DIANE.WASHINGTON77@YAHOO.COM··6865 Desert Sky BlvdMinneapolisMN55462GRP-4502··SELECT-EPO
ENRENR-1135002026-02-20T07:14:17Z·DebraEMejia20041027··UHC-43299-12•••-••-1439(467) 465-9001debra.mejia40@hotmail.com212 SAGE CTDALLASTX—GRP-4247SELECT-EPO
ENR ENR-1186712026-05-27T07:49:39ZMichelleWRivera06/02/1989UHC-89576-64—+1 322 573 7826N/A6134 Hillcrest RdTampaFlorida·33667-7462GRP-0715CHOICE-PLUS-PPO
ENRENR-1032692026-10-09T14:39:08ZRussell—Walker1991-03-18UHC-74532-97•••-••-2366(437) 286-5571russell.walker@aol.com3949 Main StORLANDOFL·32835GRP-1845CHOICE-PLUS-PPO
ENRENR-142779 2026-06-03T18:12:28ZALAN—RIVERA2/27/1953UHC7730166-(701) 234-9690alan.rivera@proton.me838 Highland AvenueEden PrairieMN55311GRP-6109NAVIGATE-HMO
ENRENR-1321142026-07-24T15:25:08ZdennyVruiz1988-12-22UHC-75844-12•••-••-7030430.476.0934··dennis.ruiz@yahoo.com2378 Valley View DriveDallasTexas··75268GRP-7713MEDICARE-ADV-A
ENR ENR-1389592026-09-25T09:59:15ZGABRIELRHOWELL1943-02-05UHC-87332-44•••-••-6060(586) 667-6679—2866 HARBOR BLVDSeattleWA98157GRP-1260NAVIGATE-HMO
ENRENR-1030142026-05-22T02:25:59ZRalph—Woods·26-07-1967UHC-78850-61null-ralph.woods@yahoo.com6887 Spring StTAMPAFL33671GRP-9120MEDICARE-ADV-B
ENRENR-1348792026-08-25T19:49:47ZCHRISTIANU.DAVIS1991-01-06UHC-84270-65•••-••-799216013827625null684 Camelback RoadColumbusOhio43235GRP-1490options-ppo
ENRENR-1304282026-02-14T15:15:44ZSCOTTIHUGHES19970124UHC-27255-93•••-••-7701377-366-9542··scott.hughes@icloud.com2208 RIVER RDOrlandoFL32840GRP-6910CHOICE-PLUS-PPO
ENRENR-1086552026-08-25T02:41:57Z JosephRHoward1968-04-25UHC-87595-03•••-••-85932702253222joseph.howard33@gmail.com3549 Palm DrFresnoCA93771GRP-6236CHOICE-PLUS-PPO
ENRENR-1147462026-02-03T21:07:27ZAbigailGWashingtonFeb 27, 2000·UHC-06319-96•••-••-5922(814) 580-9904abigail.washington99@gmail.com7125 Lincoln Way Apt 15Fresno···CA93738GRP-7041MEDICARE-ADV-A
ENRENR-1354952026-05-04T12:06:14ZAmendaG··Singh03-10-1947UHC-34285-94•••-••-19153987867358amanda.singh@aol.com2132 Baseline RoadDallasTX—GRP-1751MEDICARE-ADV-A
ENRENR-1264132026-05-18T12:57:54ZJOYCE··Y.GARZA1970-06-04UHC-40324-56··•••-••-8453(203) 756-8101joyce.garza@icloud.com4699 OCEAN AVEJACKSONVILLEFL32257GRP-2340CHOICE-PLUS-PPO
ENRENR-1254642026-01-13T06:23:40ZVirginiaHHarper19800207UHC-83325-61•••-••-4882(788) 689-4045-1549 Mountain View DriveEden PrairieMN55316··GRP-8936CHOICE-PLUS-PPO
ENR ENR-1128462026-07-29T14:40:31ZDeborah S.—Berry19400116UHC-77773-42•••-••-090115867850565deborah.berry7@aol.com2880 PINE DRGilbertAZ·85257GRP-0861OPTIONS-PPO
ENRENR-1028102026-02-23T15:47:06ZAndrea—Yang20-04-1984UHC-63361-31•••-••-1577(352) 931-5628andrea.yang@gmail.com4579 Harbor Boulevard·FresnoCA93749GRP-2263MEDICARE-ADV-B··
ENRENR-1428012026-05-13T05:27:20ZGeorgeY.Ramos·1962-03-15UHC-92611-30•••-••-9934—GEORGE.RAMOS79@ICLOUD.COM2114 Willow Court Apt 7··SeattleWashington98113GRP-3644CHOICE-PLUS-PPO
ENRENR-1067732026-09-13T10:25:51ZFranklin, George——6/9/1964UHC-98768-47•••-••-7913(587) 368-4956-4658 INDIAN SCHOOL RDSan DiegoCA92133GRP-2296OPTIONS-PPO
ENRENR-1347902026-03-22T18:46:54Z KellyGRobinsonJul 19, 1981··UHC-76289-79•••-••-6136924-505-8985—7506 Cedar LnOrlandoFL32883-7556GRP-9015CORE-HMO
ENRENR-1111602026-05-16T13:12:47ZChristopherMAustin·2007-02-02UHC1477179•••-••-95872012677317christopher.austin79@proton.me·3240 Mountain View DriveColumbusOH43235GRP-7901SELECT-EPO
ENRENR-1099772026-02-04T06:47:36ZChristinaIPerez1944-11-01UNKNOWN•••-••-8840+1 945 305 3626christina.perez32@proton.me4757 Ridge Road Apt 5·GlendaleArizona85331·GRP-0532MEDICARE-ADV-A
ENRENR-1383532026-06-23T05:48:36ZSoofiaJ.Alvarez10-01-1970··UHC-12565-68N/A409-716-0451sofia.alvarez@aol.com3305 MESA DRIVEORLANDOFLNULL·GRP-9609CHOICE-PLUS-PPO
ENRENR-1328222026-08-18T11:35:25ZSAMANTHA—LAWREENCE04/12/1940UHC-39266-73•••-••-4090null—7120 Washington StreetTucsonAZ85751GRP-0112NAVIGATE-HMO
ENRENR-1311292026-03-06T23:38:41ZParker, FrankS—1984-07-23UHC-46530-32•••-••-3946—frank.parker@proton.me8240 Lincoln WayChandlerAZ85229GRP-4262··navigate-hmo
ENRENR-1161672026-05-04T04:29:34ZNoah—Valdez··1989-04-25UHC-97692-50—(523) 780-7013NULL2810 CAMELBACK RD·TUCSONAZ85708··GRP-7449··CHOICE-PLUS-PPO
ENRENR-1354072026-04-13T12:23:35ZMadisonBDavis1981-03-04UHC-94252-24•••-••-6070—null5612 Ocean AvenueAustinTX78767GRP-6042MEDICARE-ADV-A
ENRENR-1042002026-01-16T05:48:34ZROY—GREEN19551015UHC-60747-64•••-••-1792·2328719993ROY.GREEN@HOTMAIL.COM8357 Palm DrHoustonTX77031GRP-9545CORE-HMO
ENRENR-1338032026-04-22T23:38:38ZAlexis—Mitchell2/6/1973UHC-90457-58•••-••-2956+1 433 711 5977··alexis.mitchell@icloud.com1919 Park PlaceJacksonvilleFL32209GRP-3369MEDICARE-ADV-B
ENRENR-1319802026-07-07T00:38:08ZRalphKCollins1989-01-03UHC-46526-44•••-••-2423925.730.7915ralph.collins86@proton.me1999 Ocean AvenueColumbusOhio43240GRP-5266·NAVIGATE-HMO
ENRENR-1258242026-01-09T14:37:44ZROBERT—REES··UNKNOWNUHC-55341-74•••-••-4024366-315-2536—100 CANYON ROADSeattleWA·98100GRP-6177CORE-HMO
ENR ENR-1107822026-10-03T23:32:50ZamyRthompson2002-07-04UHC-07707-05··—amy.thompson13@proton.me·1010 Apache BoulevardDALLASTX75241GRP-6896MEDICARE-ADV-A
ENRENR-1323452026-02-22T06:03:05ZLriW.Marshall1995-10-20UHC-14620-73•••-••-43654537437511lori.marshall@gmail.com3879 PARK PLACEATLANTA··GA30399GRP-5939MEDICARE-ADV-A
ENRENR-1391632026-10-17T00:31:36ZBeverly—Jackson1998-09-09NULLN/A···4599324131BEVERLY.JACKSON@HOTMAIL.COM4804 Main StreetCharlotteNorth Carolina··UNKNOWNGRP-0922OPTIONS-PPO
ENRENR-1384722026-06-11T07:09:56ZJose—Day2004-10-04UHC6567801—4162887—3940 Desert Sky BoulevardPlanoTX··75035GRP-9817NAVIGATE-HMO
ENRENR-1336902026-04-04T03:33:52ZWashington, Danielle——2001-10-06UHC4111313—·3923151900—8837 Harbor BlvdLOS ANGELESCA90065··GRP-6013OPTIONS-PPO
ENRENR-1174892026-01-10T00:18:41ZJames·ZPowell1994-05-14UHC-76763-51•••-••-4880·556.245.9713—127 Main StSEATTLEWA98131GRP-1766SELECT-EPO
ENRENR-1135332026-06-23T19:44:57ZDanielDAlvarez1943-05-25UHC-57632-09•••-••-8435UNKNOWN—6848 Grand Avenue·Austin·TX78790GRP-8954CORE-HMO
ENRENR-1023322026-02-25T05:06:14ZRussell—WatkinsAug 22, 1990UHC-79036-19•••-••-4554664-618-4895russell.watkins@aol.com8736 BAYSHORE DRIVELas Vegas··NV89104GRP-7160MEDICARE-ADV-B
ENRENR-1043952026-09-12T05:40:54Z·Green, Debra——20031126UHC-24356-58•••-••-4531—null4701 Washington StChandlerAZ85205GRP-6360·MEDICARE-ADV-A
ENRENR-1106832026-07-04T19:22:55ZHarvey, Zachary——08/10/2004UHC-58981-28•••-••-7000842-610-7239zachary.harvey31@yahoo.com8928 APACHE BOULEVARDTEMPEAZ85239GRP-8584CHOICE-PLUS-PPO··
ENRENR-1307152026-05-09T07:17:02ZSilva, OmarE.—1962-06-26UHC-10513-43•••-••-4272·3564993674omar.silva@gmail.com4924 Mountain View DrSeattleWA98179GRP-2070MEDICARE-ADV-B
ENRENR-1302402026-04-05T12:44:57ZARJUN··LUCAS02/04/78···UHC-66384-38•••-••-9321664-352-4113UNKNOWN5563 HILLCREST RDHoustonTXN/AGRP-1589CHOICE-PLUS-PPO
ENRENR-1308522026-06-12T17:05:15Zjessica—elliott20050704UHC-51147-59•••-••-2699798-982-4634jessica.elliott@gmail.com2452 Maple AveTempeAZ85284·GRP-4217NAVIGATE-HMO
ENRENR-1422062026-10-01T14:01:50ZELIZABETHP.OWENS··1949-09-17-•••-••-6419(854) 871-1123null·163 Oak StreetHoustonTX··77026GRP-8882OPTIONS-PPO
ENRENR-1032712026-01-19T16:18:56ZMaldonado, BruceW—4/15/1975UHC-52868-26•••-••-96135343997606bruce.maldonado82@icloud.com9375 Union StTucsonAZ85738··GRP-5113navigate-hmo
ENRENR-1333912026-05-23T23:57:22ZSantiago, CynthiaH—Mar 9, 2006UHC-06856-30··•••-••-14299067084CYNTHIA.SANTIAGO40@YAHOO.COM5327 MAPLE AVENUELAS VEGASNevada89111GRP-0476··CHOICE-PLUS-PPO
ENR ENR-1003142026-01-23T05:12:57ZLisa—Morgan2001-02-04UHC-63545-45——-·1074 Lake View RoadSEATTLEWA98157GRP-6397MEDICARE-ADV-A
ENRENR-1021692026-04-12T06:01:50ZBeverly·LMcDonald19831012UHC-63479-17•••-••-5720619.988.4275BEVERLY.MCDONALD55@OUTLOOK.COM1805 Canyon RdFresnoCA93785GRP-2443MEDICARE-ADV-B
ENRENR-1341372026-07-15T22:25:16ZVIGRINIAW.STONE22-02-1968UHC-66168-77•••-••-3120UNKNOWN—329 Spring Street·AustinTexas78792GRP-3017··MEDICARE-ADV-A
43,101 rows, page 38 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:34.798Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty