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-1022912026-09-29T20:07:10ZOMAR··ZCRUZ22-12-1940·UHC-43088-14•••-••-4296·NULLN/A6656 Desert Sky BoulevardFRESNOCalifornia93740GRP-5317CHOICE-PLUS-PPO
ENRENR-1043082026-06-15T18:08:04ZCarlson, Madison L——1311-20-06··UHC-83035-31-926-353-7422madison.carlson28@gmail.com789 Willow CourtDenverCO80287-5393GRP-4102CHOICE-PLUS-PPO
ENRENR-1155272026-07-09T23:39:48ZLuis·H·Munoz1963-10-07UHC-84496-65•••-••-3482568-311-3536N/A8503 Oak StreetAtlantaGA30354-1663GRP-9827OPTIONS-PPO
ENRENR-1376702026-07-19T15:37:27ZFrances—Spencer1992-07-12UHC7156741•••-••-46334759978054frances.spencer@icloud.com1557 Spring StSAN DIEGO·CA92173··GRP-0253OPTIONS-PPO
ENRENR-1114262026-03-05T05:50:24ZterryZaustin1950-11-15UHC-94531-66null8574219838TERRY.AUSTIN99@PROTON.ME3745 PARK PLACE #465GLENDALEAZ·85389GRP-6042MEDICARE-ADV-A
ENRENR-1173632026-02-16T22:32:06ZARJUNCCRUZ2002-01-18UHC-63818-91•••-••-6631761-478-0340arjun.cruz@hotmail.com2954 PALM DREden Prairiemn55315GRP-7980SELECT-EPO
ENRENR-1137172026-01-28T16:17:59ZMARGARETL··OWENS··1976-07-02UHC-56821-54•••-••-7933(866) 353-9190UNKNOWN549 Oak StreetTampaFL33638·GRP-5350MEDICARE-ADV-B
ENRENR-1104542026-06-12T09:12:50ZCHRISTINEFHAWKINS19600302UHC-65939-84•••-••-4974—N/A5849 Harbor BoulevardSan AntonioTX78254GRP-6941CORE-HMO
ENRENR-1306392026-03-03T19:54:58ZValentina—·Freeman1967-01-26UHC6421141•••-••-8501(684) 472-1103valentina.freeman66@gmail.com5602 Harbor BlvdLas VegasNV89139GRP-9767NAVIGATE-HMO
ENRENR-1222492026-04-14T17:31:26ZNatalieOShwa1966-08-15UHC-04451-66•••-••-0843(239) 601-4239NATALIE.SHAW@PROTON.ME491 Palm DrSACRAMENTO··CA95819GRP-7134MEDICARE-ADV-A
ENRENR-1173042026-08-30T10:01:24ZNATHAN—FERNANDEZ1993-03-22NULL•••-••-5277591.992.3960nathan.fernandez23@proton.me5278 River RdJacksonvilleFlorida··32247GRP-9436SELECT-EPO
ENRENR-1250752026-02-13T20:16:40ZGerald—Little11/14/1996uhc-94042-51•••-••-66886915941652GERALD.LITTLE@OUTLOOK.COM3476 OCEAN AVENUEColumbusOhio43297-8500GRP-1598NAVIGATE-HMO
ENRENR-1170892026-10-13T21:27:44Zdot··H··bowman1944-05-01UHC-44242-68—2958774800dorothy.bowman22@gmail.com4394 Canyon Rd··GILBERT··AZ85292GRP-9860SELECT-EPO
ENRENR-1049762026-05-13T20:26:44ZSusanBKim·1987-02-04UHC-90882-73•••-••-9200+1 938 572 3040SUSAN.KIM@GMAIL.COM9058 Camelback RdMinneapolisMN—GRP-6264··MEDICARE-ADV-A
ENRENR-1372782026-02-27T22:33:52ZCamilaXHill06/27/67UHC-12011-96•••-••-5524(404) 341-5428camila.hill@yahoo.com8268 Broadway··Los AngelesCA90079GRP-2825··MEDICARE-ADV-A
ENRENR-1196022026-02-02T02:27:20ZMADISON—WHEELER1971-01-22UHC-77320-73•••-••-9354(549) 630-3576—1054 Market StFresnoCA93735GRP-8073MEDICARE-ADV-A
ENRENR-1375362026-02-25T18:23:42Z·MARKA.YOUNG5/20/1967UHC-00268-39——MARK.YOUNG60@ICLOUD.COM··1847 Spring StChandlerAZ··85272-6558GRP-9727CHOICE-PLUS-PPO
ENRENR-128338 2026-06-04T13:15:29ZGloria—Bowman—UHC-41813-21-774-466-9248N/A9766 Grand Avenue Apt 37Los AngelesCANULLGRP-6629CHOICE-PLUS-PPO
ENRENR-1047902026-04-01T05:50:18ZAmberXTucker19730810UHC-54636-28•••-••-36157297232396amber.tucker@icloud.com5701 Lake View Road··MinneapolisMN55470GRP-2850OPTIONS-PPO
ENRENR-1327182026-08-01T00:17:37ZJOSE—PERRY1978-04-04UHC-95995-28•••-••-83768776823698NULL9815 Union StPlano··TX75040GRP-9288·CHOICE-PLUS-PPO
ENRENR-1015082026-08-31T17:45:16ZKaran—Baker06/10/51·UHC-03116-01•••-••-0415478.419.3990karen.baker55@aol.com3263 HILLCREST ROADJacksonvilleFL32238GRP-2439·NAVIGATE-HMO
ENRENR-1405142026-09-26T16:00:22ZDeborah—Chapman1963-03-02UHC-33000-87•••-••-3204942-779-4730deborah.chapman41@icloud.com8478 Lincoln WayChandler··AZ85283GRP-0269CHOICE-PLUS-PPO··
ENRENR-1126062026-02-11T21:35:56ZJessica—Bennett02-05-1991UHC-98542-11•••-••-2361——5439 Camelback Rd··DenverColorado80206GRP-1083SELECT-EPO··
ENRENR-1080222026-07-19T18:08:09ZAndrewWHart15-05-1971UHC-05381-28—440-461-8873·ANDREW.HART52@YAHOO.COM8837 PINE DRIVECHANDLERAZ85238GRP-3048SELECT-EPO
ENRENR-1045422026-01-18T17:14:26ZJOHNYCONTRERAS1980-02-28UHC-95942-06··•••-••-0293391.654.5189JOHN.CONTRERAS82@GMAIL.COM·2831 BASELINE RDMiamiFL33140GRP-7833CHOICE-PLUS-PPO
ENRENR-1214302026-09-18T01:20:34ZJORDANOGEORGE1964-11-12UHC-02604-57•••-••-98809548084442jordan.george61@icloud.com384 Union StreetDenverCO80230-6375·GRP-5073·MEDICARE-ADV-B
ENRENR-1060642026-04-12T14:37:18ZSharon—Cunningham9/24/1945UHC-72535-93•••-••-8079273-496-7284sharon.cunningham@aol.com5534 Camelback RdTUCSONAZ85723GRP-5457OPTIONS-PPO
ENRENR-1381582026-07-31T11:10:38ZShirley····Romero1979-11-11UHC-08052-78•••-••-20102028023745SHIRLEY.ROMERO75@ICLOUD.COM3313 Bayshore DrSeattleWA98136GRP-6423CORE-HMO
ENRENR-1162542026-10-14T03:27:09ZHENRYW.NGUYEN1979-04-14·UHC-68744-54•••-••-49824273006444henry.nguyen@outlook.com5257 Market StPlanoTX75027GRP-5876··CHOICE-PLUS-PPO
ENRENR-1040652026-02-25T15:16:27ZJUDITH—PENA08/25/39UHC-47584-45•••-••-9211(561) 510-5268JUDITH.PENA@OUTLOOK.COM1931 BASELINE ROADDenverCO80265GRP-4982OPTIONS-PPO
ENRENR-1229162026-10-01T20:28:56ZHELEN—WALLACE2006-03-25UHC-46407-62•••-••-25548436749helen.wallace30@gmail.com8344 MOUNTAIN VIEW DRIVEPhoenixArizona··85029GRP-9702SELECT-EPO
ENRENR-1281892026-04-13T04:17:24ZReid, HelenM.—2005-11-28UHC-88997-72··•••-••-39507597401091null463 Cedar LaneMesaAZ85254-6886GRP-4472CORE-HMO
ENRENR-1255442026-05-18T10:48:42ZSophia—Moreno··1979-04-16UHC-86788-83•••-••-72869439019688sophia.moreno57@aol.com7487 Ridge RdTucsonAZ85721GRP-1938MEDICARE-ADV-A
ENRENR-1176212026-09-09T21:35:36ZStephanieN··Henry1986-08-02UHC-38840-31•••-••-02076568008160-1435 Meadow LnJACKSONVILLEFL32236GRP-4984NAVIGATE-HMO
ENRENR-1118812026-06-27T02:36:26ZSTEPHENOCARLSON09-05-1953UHC-58376-55•••-••-3434774-217-5670stephen.carlson3@hotmail.com655 CENTRAL AVENUEAustinTX78703GRP-4941··CORE-HMO
ENRENR-1118932026-07-03T20:07:09ZBETTY··FIELDSAug 24, 2006NULL•••-••-4070547-873-8985betty.fields@hotmail.com2940 Cedar LnScottsdaleArizona85273GRP-8918··MEDICARE-ADV-B
ENRENR-1373062026-02-27T08:31:52Z·Shirley·YGordon1105-19-45UHC-16318-59•••-••-9816355-573-8550shirley.gordon@icloud.com734 Park PlaceLOS ANGELESca90082GRP-0524CHOICE-PLUS-PPO
ENRENR-123527 2026-08-01T05:10:09ZVirginiaSHarrisApr 23, 1944UHC-58262-17•••-••-9740+1 869 460 9340virginia.harris34@gmail.com1341 Harbor BlvdSeattleWA98144GRP-5858CORE-HMO
ENRENR-1234962026-04-20T12:04:50ZBRYAN—SANDOVAL1971-04-14UHC-04047-70•••-••-01473945181348null1005 BAYSHORE DRSEATTLEWashington98195GRP-8454MEDICARE-ADV-B
ENRENR-1428792026-05-17T16:02:06ZStephens—Emily1940-08-13UHC-19912-27NULL··8006667095emily.stephens@icloud.com··7973 Mesa DrScottsdaleAZ85204GRP-2024SELECT-EPO
ENRENR-1326102026-02-24T10:23:12ZKevin··J··Wallace1941-08-01UHC-23571-56•••-••-02732128780265kevin.wallace90@icloud.com1250 DESERT SKY BLVDHOUSTONTexas77022GRP-2676SELECT-EPO
ENRENR-1147152026-09-26T17:20:04ZReynolds, Brian—··1959-05-10UHC-65257-02•••-••-3218327-534-6123brian.reynolds57@yahoo.com3126 Grand AvenueMIAMI·FL33132GRP-8057MEDICARE-ADV-B
ENRENR-1421212026-03-06T11:44:55ZDennisQFerguson09/28/54UHC-37454-80•••-••-3328——3009 Desert Sky BlvdEden PrairieMinnesota··55396GRP-7439MEDICARE-ADV-B··
ENRENR-1113752026-06-07T05:18:27ZTHERESA—MUNOZ-UHC-11208-80•••-••-5212+1 878 957 3749THERESA.MUNOZ38@HOTMAIL.COM5154 Harbor Boulevard·TampaFL33671GRP-4811SELECT-EPO
ENRENR-1416012026-08-21T20:40:30ZMADISON—LUCAS12/23/2007UHC-08732-03•••-••-1948685-677-0979madison.lucas16@gmail.com9850 BASELINE ROADAustinTX78796GRP-2230SELECT-EPO
ENRENR-1396832026-06-25T23:36:52ZKathleen—Gonzalez1969-08-15UHC-63009-45•••-••-7390-KATHLEEN.GONZALEZ@YAHOO.COM3746 ELM STLos AngelesCA90034GRP-2314SELECT-EPO
ENRENR-1299912026-08-17T14:20:35ZDonD.Marquez1997-02-09UHC-15493-92•••-••-3246982.697.2447NULL8380 DESERT SKY BOULEVARD Apt 30ORLANDO··Florida··32808-1910GRP-1023SELECT-EPO
ENRENR-1057372026-06-23T02:49:36ZStephen—Vargas1991-11-11UHC-56822-75null(484) 572-6934stephen.vargas@aol.com4580 Central AveScottsdaleAZ85280·GRP-7644CORE-HMO
ENRENR-1041802026-08-03T11:27:57ZScottV.Gardner1948-09-22UHC-69159-68•••-••-5755(445) 213-0985SCOTT.GARDNER@HOTMAIL.COM975 Cedar LaneAtlantaGA30380GRP-7270medicare-adv-b
ENR ENR-1032262026-01-23T11:39:32Z·Melissa—Fullre9/12/1986UHC-18904-06•••-••-9387UNKNOWNNULL9543 Cedar LaneHoustonTX77051GRP-0335MEDICARE-ADV-B
43,101 rows, page 37 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.797Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty