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-1423802026-09-23T02:59:27ZalexanderWadams06/04/1944UHC-12301-91—347-507-6915—3714 Church StreetTempeAZUNKNOWNGRP-4625SELECT-EPO
ENRENR-1250622026-02-23T04:59:08ZMarcus—Rodriguez07-09-1995UHC-13361-97•••-••-6204(220) 569-3909marcus.rodriguez69@outlook.com439 Desert Sky Boulevard··DallasTXUNKNOWNGRP-0802CHOICE-PLUS-PPO
ENRENR-1259422026-06-12T17:16:58ZZachary·QSpencer1957-04-06UHC-58137-86•••-••-7094+1 654 742 3396zachary.spencer55@icloud.com552 Palm DriveScottsdaleAZ··85228-6279GRP-3653CHOICE-PLUS-PPO
ENRENR-1070892026-08-10T23:31:25ZLawrenceZCarlson1938-11-03·UHC-48613-78NULL950.254.6879LAWRENCE.CARLSON4@YAHOO.COM9221 Willow CtHoustonTX77075GRP-7598·MEDICARE-ADV-A
ENRENR-1404382026-01-29T07:33:11ZCarolAJordan1990-67-15UHC-04959-09•••-••-1837(243) 616-2008carol.jordan27@outlook.com4129 LINCOLN WAY #700EDEN PRAIRIEmn55358GRP-2307MEDICARE-ADV-A
ENRENR-1365212026-10-04T23:53:44ZGloriaV.Hall1972-10-11UHC-36250-98—284-659-0758-7812 Grand AveTUCSONAZ85707-5307·GRP-5998CHOICE-PLUS-PPO
ENRENR-1405232026-01-31T14:44:02ZJOEZCASTILLO07/01/04uhc-32471-33NULL(206) 847-6160joe.castillo61@aol.com3407 Lincoln WaySeattleWA98139GRP-7011NAVIGATE-HMO
ENRENR-1357802026-03-16T06:06:48ZLOGANRVARGAS1965-06-07UHC-17983-86•••-••-3769+1 811 928 7403logan.vargas7@proton.me2581 River RoadLAS VEGASNV89139GRP-7640SELECT-EPO
ENRENR-1170792026-08-01T21:39:49ZJUNA—GUERRERO1963-05-04UHC-70320-01•••-••-995319588018924··juan.guerrero@outlook.com7648 BroadwayAtlantaGA30300GRP-5227NAVIGATE-HMO
ENRENR-121393 2026-08-06T22:26:55ZronaldQ.brown02/24/64UHC-81582-22•••-••-68485384752ronald.brown2@gmail.com758 Elm StMesa·AZ85204GRP-6994CHOICE-PLUS-PPO
ENRENR-1078852026-04-07T13:47:50ZGeorge, Abigail——07/19/1993UHC4884118•••-••-99518823971842abigail.george@outlook.com5368 LINCOLN WAYMesaAZ··UNKNOWNGRP-9925MEDICARE-ADV-A
ENR ENR-1153442026-05-05T22:50:07ZMARTTHAJRAMIREZ··05/05/1997·UHC2722735•••-••-1223·5322579····9690 VALLEY VIEW DRIVELos AngelesCA90091GRP-8144·options-ppo
ENRENR-1055692026-03-16T08:48:35ZSOFIA—·ARMSTRONGApr 25, 1996UHC-52578-65•••-••-09532446040330SOFIA.ARMSTRONG@YAHOO.COM4885 Palm DrFresnoCA93773GRP-2028CHOICE-PLUS-PPO
ENRENR-1217122026-10-11T10:55:48Z·CHUCK—GRIFFIN1970-05-26UHC-14601-23•••-••-5504(616) 321-0233charles.griffin@gmail.com9665 Maple AvenueMesa···AZ85251·GRP-1743CHOICE-PLUS-PPO··
ENRENR-1305962026-04-22T02:14:04ZCAROLYNJ.MARTIN03/17/86UHC-41069-52•••-••-3078(428) 279-0462carolyn.martin98@gmail.com5919 Church StreetPlanoTX75008GRP-1893NAVIGATE-HMO
ENRENR-1195962026-03-14T16:33:38ZMason—Lucas1969-06-01UHC-82569-27•••-••-8721·438-556-8143MASON.LUCAS@GMAIL.COM2967 Mesa DrChandler··AZ85200GRP-6868CORE-HMO
ENRENR-1301642026-08-08T11:54:14ZCarroll, Frances—··1989-03-06UHC-86577-10•••-••-3763(306) 772-1538frances.carroll71@aol.com9203 Ridge RdJACKSONVILLEFL32203GRP-9976··MEDICARE-ADV-B
ENR ENR-104103 2026-07-20T17:36:52ZMATTHEW—REED1950-11-22UHC-00225-74•••-••-25718593481938matthew.reed75@gmail.com8868 SAGE CTMESA·AZ85228GRP-0802core-hmo
ENRENR-1203772026-01-26T03:20:17ZJames—Reid1946-05-05UHC-71500-43N/A685-425-1293NULL2593 Mesa DriveAtlantaGA30340GRP-3715SELECT-EPO
ENRENR-1211862026-02-11T06:11:22ZNathan—Burns06/09/1951UHC-99082-25•••-••-6313+1 673 526 6944UNKNOWN9807 Mesa DrAustinTX78779··GRP-8506NAVIGATE-HMO
ENRENR-114865 2026-05-21T22:21:54ZFox, JudithM.—1948-03-11UHC8158893•••-••-1635(424) 633-0248—3009 MOUNTAIN VIEW DRMinneapolisMNNULLGRP-2494SELECT-EPO
ENRENR-1095982026-01-06T17:03:10ZVIRGINIAWWEBER19730404UHC-10635-06•••-••-6321(400) 594-7005VIRGINIA.WEBER1@HOTMAIL.COM2954 Oak StColumbusOH43204··GRP-2307OPTIONS-PPO
ENRENR-1024812026-08-09T06:36:46ZTeresaYHarvey1995-07-24UHC3022234•••-••-01453347836443-4064 PALM DRMesaAZ··85261GRP-1194NAVIGATE-HMO
ENRENR-1216652026-02-03T18:44:56ZAdamZKelly1996-05-07UHC-34206-78•••-••-67813575530441ADAM.KELLY34@YAHOO.COM4990 Highland AvenueJACKSONVILLEFL32283GRP-6858··CORE-HMO
ENRENR-1134502026-01-21T21:37:03ZDOROTHY—RAMIREZDec 11, 1997··UHC-73553-48—7519306736—4510 Valley View DrivePlanoTX75090··GRP-7048MEDICARE-ADV-B
ENRENR-1402072026-07-29T04:37:36ZJESE—HANSON19-05-1956UHC-23601-51•••-••-2938+1 701 475 1587jesse.hanson33@yahoo.com712 Spring StNashvilleTN37211-2463GRP-3052CORE-HMO
ENR ENR-1429492026-07-23T03:02:21ZELIJAH—WOOD1990-06-06UHC-36510-96null7923404379elijah.wood@hotmail.com2449 MEADOW LNPLANOTX75045GRP-9992SELECT-EPO
ENR ENR-1221442026-08-02T12:38:00Z·terryIrichardson07/04/84··UHC-96410-44•••-••-4834+1 506 802 1794terry.richardson49@proton.me6145 Park PlSan AntonioTX78286GRP-7595SELECT-EPO
ENRENR-1129632026-01-22T17:34:23ZJoeQ.Hernandez1984-01-42UHC-15476-72N/A··744-837-0918—795 MAPLE AVETempeArizona85295GRP-5607MEDICARE-ADV-B
ENRENR-1250062026-08-28T05:17:01ZJORDAN—GARY3/9/1977UHC-50033-62•••-••-7750216-331-1280GARY.JORDAN44@OUTLOOK.COM1759 BroadwayAUSTINTX—GRP-0973CHOICE-PLUS-PPO
ENR ENR-1218452026-05-31T21:50:55ZChristopherR—1963-03-15UHC-54205-35•••-••-7042-CHRISTOPHER.BRYANT@AOL.COM5048 INDIAN SCHOOL ROADLas VegasnvNULLGRP-6463SELECT-EPO
ENRENR-1033142026-07-04T00:52:58ZHANNAH—DIAZ1969-05-20UHC-27797-11•••-••-2832(446) 362-2283HANNAH.DIAZ7@GMAIL.COM1836 Elm StSACRAMENTOCA95822GRP-2314SELECT-EPO
ENRENR-1113302026-10-04T04:59:30Zgeorge—patterson1983-02-09UHC-34242-48•••-••-7572608-512-5623george.patterson40@hotmail.com5376 Central Avenue #493San AntonioTX78205-9599·GRP-4975OPTIONS-PPO
ENRENR-1394172026-09-17T15:15:49ZRoger—WetsonJan 8, 1991··UHC-16160-47··•••-••-6256(396) 921-4940—7742 Oak Street·NashvilleTN—GRP-8995·NAVIGATE-HMO
ENRENR-1246482026-05-13T03:31:31ZMcCoy, Amanda——·2002-05-06UHC-05467-15•••-••-6917UNKNOWNamanda.mccoy@hotmail.com9338 JEFFERSON AVENUECHANDLERAZ85243GRP-6893MEDICARE-ADV-A
ENRENR-1056582026-03-05T10:12:24ZVega, JoshuaE.····1996-03-27UHC-02385-47•••-••-12943669159001JOSHUA.VEGA@OUTLOOK.COM2246 Mesa DriveDallasTX75209GRP-1710CHOICE-PLUS-PPO
ENRENR-1408022026-09-10T22:58:19Z AARONXVARGAS1963-06-02UHC-28405-72•••-••-3003(484) 334-2474aaron.vargas41@proton.me9066 Cedar LnSacramentoCalifornia95865GRP-3079OPTIONS-PPO
ENRENR-1239332026-01-16T21:54:34ZcynthiaX.nunez27-03-2003UHC-93498-15•••-••-91653886703819cynthia.nunez38@icloud.com4663 Palm DriveGILBERTAZ85285GRP-7809MEDICARE-ADV-A
ENRENR-1372362026-01-16T10:51:31ZROGERFLAWRENCE1952-07-20UHC-45394-19•••-••-7656617.500.7470roger.lawrence83@gmail.com8047 Mountain View DrHOUSTONTX77035GRP-6506·NAVIGATE-HMO
ENR ENR-1041432026-09-13T18:49:46ZJoshuaE.Riley··1997-02-23UHC-75515-17•••-••-5029NULLjoshua.riley78@icloud.com8159 Church StHoustonTX77043GRP-3417MEDICARE-ADV-A
ENRENR-1211542026-01-13T09:39:02ZLauren—·Pena10-01-1974UHC8225091null5544028023lauren.pena83@gmail.com5096 Hillcrest RdDallasTX-GRP-9839MEDICARE-ADV-A
ENRENR-1262332026-04-28T19:22:52ZFatima··PWilliams1997-02-20UHC-81189-01•••-••-869415845144627fatima.williams31@aol.com6965 Sunset BlvdDALLASTexas75297GRP-9771OPTIONS-PPO
ENRENR-1275792026-03-21T06:54:18ZHEATHERN.LEE1947-01-24UHC-72496-83—(209) 256-8575heather.lee4@gmail.com4065 Camelback Rd·OrlandoFL32835GRP-7927SELECT-EPO
ENRENR-1395562026-07-27T21:46:15ZYUKI—YANG1977-09-21UHC-26988-86•••-••-65353709198884YUKI.YANG70@HOTMAIL.COM7745 BroadwaySan DiegoCA92191-0487GRP-2408··OPTIONS-PPO··
ENRENR-1023722026-04-26T03:55:05ZJONATHANORIVERA1992-08-01UHC-64480-79•••-••-4950(345) 914-5090··NULL728 Central AvenueChandlerAZ85268GRP-2985CORE-HMO
ENRENR-1055662026-01-28T10:00:59ZAUSTIN—WILLIAMSON·05/28/1994UHC-58117-31•••-••-64713649752513AUSTIN.WILLIAMSON@HOTMAIL.COM6313 BAYSHORE DRIVE·TempeAZ85292-2154·GRP-1156SELECT-EPO··
ENRENR-1350302026-07-15T20:58:13ZEmma··—Rios2004-03-22UHC-29326-42•••-••-1138NULL—124 Ridge RoadSan DiegoCA92177GRP-3967CORE-HMO
ENRENR-1074492026-04-10T03:31:21Z·DIEGOEJOHNSTON1956-02-16UHC-82913-21··•••-••-9754568.830.3800diego.johnston5@yahoo.com4385 Highland AvenueSacramento··CA··95852GRP-9352medicare-adv-a
ENRENR-1166972026-06-10T10:35:09ZDonald—StephensApr 2, 1972UHC-75807-90•••-••-8794361-503-6600UNKNOWN4324 MARKET STREETSeattleWA—GRP-6786OPTIONS-PPO
ENRENR-1065732026-07-19T02:19:54ZLOGANGWATSON5/14/1995UHC-87359-27•••-••-6386674-609-9640logan.watson57@outlook.com··1020 Bayshore DriveORLANDOFL32859GRP-5562NAVIGATE-HMO
43,101 rows, page 287 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.445Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty