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-1388242026-06-18T02:52:53ZarjunHweber1964-02-13UHC-19405-15—2299551082-3172 MESA DRIVE·EDEN PRAIRIEMN55363·GRP-4462CHOICE-PLUS-PPO
ENRENR-1332502026-07-25T12:30:37ZKELLY—ROSS1945-11-25UHC-13220-97•••-••-24295655189190kelly.ross@yahoo.com4065 Palm Dr·SAN ANTONIOTexas78223GRP-5690MEDICARE-ADV-A
ENRENR-1216602026-09-05T22:59:34ZRyanK.Lee·10/11/1954UHC-63291-28•••-••-0877+1 739 959 7825ryan.lee@aol.com990 SAGE CT··GlendaleAZ85397GRP-8856OPTIONS-PPO
ENRENR-1141982026-04-11T21:11:13Z·SamanthaB.Santos10/22/1946UHC-62857-33•••-••-29253303238374SAMANTHA.SANTOS@YAHOO.COM9217 MARKET STREETMiamiFL33125GRP-2923MEDICARE-ADV-B
ENR ENR-1099102026-04-26T10:17:15ZSchultz, Juan——1980-11-04UHC-53321-36•••-••-94099287367635UNKNOWN8127 Grand Ave #743Eden PrairieMN55324GRP-9017CORE-HMO
ENRENR-1076642026-06-24T10:25:59ZHIROSHIYPRICE·1975-01-23UHC-21169-37•••-••-16814393906066HIROSHI.PRICE8@GMAIL.COM702 Main St Apt 31San DiegoCalifornia92166GRP-6591OPTIONS-PPO
ENRENR-1137782026-03-12T20:31:09Zbruce·Dwarren1976-02-16UHC-08735-97•••-••-0639261-728-5690·N/A5201 Union StreetChandlerAZ85254GRP-7026MEDICARE-ADV-A
ENRENR-133882 2026-05-08T13:51:00ZmariaGrojes1943-08-21UHC-01066-43•••-••-4606(524) 556-1709·maria.rojas@outlook.com5968 MOUNTAIN VIEW DRNASHVILLETN—GRP-5150MEDICARE-ADV-A
ENRENR-136873 2026-03-30T08:34:48ZMeganZMaqruez1990-06-14·UHC-86538-02•••-••-6515(796) 467-3988megan.marquez@gmail.com4790 Washington Street #163MesaAZ85238GRP-0899medicare-adv-a
ENRENR-1373122026-04-29T16:00:41ZTeresa—Spencer1995-05-10··UHC2368243•••-••-2505496-673-6664TERESA.SPENCER@ICLOUD.COM5215 Grand AveSan DiegoCA92120GRP-0606··MEDICARE-ADV-A
ENRENR-1294032026-07-03T08:10:15ZROYPMYERS1975-12-25UHC-50530-26•••-••-5139568.219.3408NULL4237 DESERT SKY BLVDColumbusOH—GRP-3724··SELECT-EPO
ENRENR-1244052026-04-02T05:20:48ZAlvarado, AngelaJ.—·19570809·UHC-25514-99····561.413.1212—2119 Church StChandlerArizona85297GRP-4063MEDICARE-ADV-B
ENRENR-1025412026-05-18T22:12:01ZJustin—Myers19720315UHC-69978-94•••-••-4051282-764-4427justin.myers53@aol.com·1634 APACHE BLVDSan DiegoCA92189GRP-7670MEDICARE-ADV-B
ENRENR-1265952026-04-27T16:52:27Zmichael—sanders·11/01/1990UHC5974951•••-••-2539+1 815 895 9564·michael.sanders@gmail.com8657 Mesa DrScottsdaleAZ85200GRP-6732CORE-HMO
ENRENR-1261192026-08-14T04:15:07ZSandraPRios1991-06-06UHC-53803-79•••-••-8909(572) 461-4710·N/A6026 Hillcrest RdPlanoTX75052GRP-2598CHOICE-PLUS-PPO··
ENRENR-1251592026-05-30T12:08:38ZSTEPHANIES.MENDEZMar 8, 1999UHC-97306-21•••-••-7099856-397-1851·UNKNOWN1212 Hillcrest RoadSan Diego·CA92151GRP-3689CHOICE-PLUS-PPO
ENRENR-1011942026-01-02T08:09:38ZBarbara—Ryan··1964-05-01UHC-96763-42-3232403800—6299 Sunset Boulevard Apt 25·San DiegoCA92148-0983GRP-3195MEDICARE-ADV-B
ENRENR-1051132026-08-27T20:21:44ZBRIAN····AGUILAR1967-01-81UHC-26234-51•••-••-2326386-731-8919BRIAN.AGUILAR@OUTLOOK.COM8816 Cedar LaneMiamiFL33176··GRP-4640CHOICE-PLUS-PPO
ENRENR-1198022026-08-07T01:45:29ZKelley, DanielleF—01/07/03UHC-50091-64•••-••-9088904-248-9215DANIELLE.KELLEY15@AOL.COM3285 Forest AvenueFresnoCA93715GRP-6344NAVIGATE-HMO
ENRENR-1367222026-02-02T02:49:29ZSARAH—PENA09/08/77UHC-07755-17•••-••-1938(873) 424-2794sarah.pena45@hotmail.com5705 BroadwayJacksonvilleFL32214··GRP-2450CORE-HMO
ENRENR-1141412026-05-12T12:10:07ZCharlotte—LittleAug 5, 1977UHC-17946-91•••-••-2813(942) 666-1784charlotte.little30@hotmail.com2244 Canyon RdDENVERCO80213··GRP-5358NAVIGATE-HMO
ENRENR-1267492026-04-29T02:01:07ZDAVIDRYANG1947-05-10UHC-30445-94•••-••-6669(388) 472-1360david.yang@hotmail.com··1680 Jefferson Ave··NashvilleTN37270GRP-4497MEDICARE-ADV-A
ENRENR-1305172026-05-27T16:47:06ZGloria—Hart12/23/2008uhc-42892-41•••-••-6091(278) 413-4002GLORIA.HART@YAHOO.COM—UNKNOWN—N/AGRP-6439MEDICARE-ADV-A
ENRENR-1138602026-04-29T17:31:06ZChristine—Gonzales19430507UHC-81084-47•••-••-3387—christine.gonzales56@hotmail.com1128 Valley View DrMiamifl—GRP-1573CORE-HMO
ENRENR-1313812026-08-03T22:26:15ZGuzman, DonnaL—11/14/47UHC-71147-44•••-••-12485687496165donna.guzman68@gmail.com5998 PINE DRIVEDenver··Colorado·80219GRP-3102CORE-HMO
ENRENR-1339272026-04-30T13:50:32ZMeganD·LeJan 18, 1994UHC-47871-36•••-••-05268174742925MEGAN.LE13@AOL.COM2768 Lake View RoadSCOTTSDALEAZ85247GRP-6243SELECT-EPO
ENRENR-1062852026-07-09T08:19:14Z ·Barbara—Aguilar1/10/1982UHC-00204-81•••-••-8012524-688-5921barbara.aguilar@hotmail.com·628 Sunset BoulevardATLANTA··GA30300GRP-6897core-hmo
ENRENR-1153552026-06-17T01:27:14ZRACHELJRIVERA1985-11-07uhc-18771-42•••-••-3888+1 687 994 0000··RACHEL.RIVERA@OUTLOOK.COM9013 MAPLE AVENUEDALLAS·tx·75202GRP-0922··navigate-hmo
ENRENR-1148092026-02-24T21:36:26ZSAMUELT.REYES1940-02-05UHC-82409-02•••-••-2245+1 825 693 9401—445 Mesa DrCharlotteNC·28256GRP-7962OPTIONS-PPO
ENRENR-1136072026-06-17T13:33:18ZHaroldG·Collins1967-01-25UNKNOWNUNKNOWN·9801724NULL6463 RIDGE RD·GilbertAZ85206GRP-9329NAVIGATE-HMO
ENRENR-1198592026-01-20T07:18:03Z Jordan—Ellis2040-09-04UHC-92342-99•••-••-9016407-298-7303jordan.ellis54@outlook.com9877 Mesa DriveHoustonTexas77026GRP-5205MEDICARE-ADV-A
ENR ENR-1190082026-06-20T10:10:35ZVincentF.Holmes1948-03-13UHC-50225-88•••-••-7240(764) 674-6103vincent.holmes@proton.me8436 Spring Street Apt 26MesaAZUNKNOWN·GRP-3388CHOICE-PLUS-PPO
ENRENR-1388352026-02-09T23:13:25ZEUGENE··—CRAWFORD1951-11-09··UHC-64523-80•••-••-7388+1 834 550 4125eugene.crawford@icloud.com1638 Oak StreetAtlantaGA30313-9665GRP-5708NAVIGATE-HMO
ENRENR-1092712026-03-16T11:29:26ZEMMAL··HARRISON19660310UHC-63140-98•••-••-6157890-411-5652emma.harrison@aol.com344 Grand AveTampaFLNULLGRP-8918SELECT-EPO
ENRENR-1064372026-08-27T13:16:46ZALBERTI.COLE1961-08-04UHC-86647-09•••-••-8298607-737-6007albert.cole@proton.me7143 Mesa DrDenverCO80254GRP-7811SELECT-EPO
ENRENR-1128142026-05-27T17:41:43ZGary—Lawrence1950-10-22UHC-23442-92•••-••-7685396.870.7884gary.lawrence83@hotmail.com4256 Sage CourtAustinTX78727GRP-9652MEDICARE-ADV-A
ENRENR-1134272026-09-30T04:06:21ZJulia—Wong19-10-1994··UHC-71698-20··—(555) 309-0844julia.wong@hotmail.com8868 MAIN STREET·SeattleWA98108GRP-2071MEDICARE-ADV-A
ENRENR-1360072026-03-16T07:06:24Z JacobQMitchell1981-05-21UHC-54026-38•••-••-57822866075193jacob.mitchell@gmail.com··9611 Bayshore DrHoustonTX77028GRP-6589NAVIGATE-HMO
ENRENR-1324402026-02-07T20:56:40ZedwardC.burns1942-10-25UHC-43222-81•••-••-7016552.622.3025edward.burns71@yahoo.com3245 DESERT SKY BOULEVARDCharlotteNC28200GRP-9942NAVIGATE-HMO
ENRENR-1378682026-03-29T09:17:19Z TERESAP··RAMOSN/AUHC-65278-62-+1 762 798 3861null5696 Sunset BlvdLas VegasNV89186·GRP-6836NAVIGATE-HMO
ENRENR-1111112026-03-27T02:38:33ZMichael—AlvaradoJun 25, 1981UHC-14405-57N/ANULL··UNKNOWN3038 BASELINE RD #899HoustonTXnullGRP-1323CORE-HMO
ENRENR-1260272026-08-13T08:32:59ZChristine—Washington1996-03-01··UHC-95770-57•••-••-3651+1 890 886 8216CHRISTINE.WASHINGTON@ICLOUD.COM4971 Main StSeattleWA98194GRP-5847MEDICARE-ADV-A
ENRENR-1151122026-10-10T14:53:50ZBailey, LuciaO—Aug 26, 1938UHC-99380-89•••-••-0351(659) 963-5095·UNKNOWN5146 MEADOW LANEPlanoTX75054GRP-4492MEDICARE-ADV-B
ENRENR-1312302026-04-09T00:27:35ZTIMOTHY—HENDERSON1988-08-21UHC-44178-50•••-••-75859316965497··UNKNOWN1051 APACHE BLVD·PhoenixAZ85014GRP-9970NAVIGATE-HMO
ENRENR-1359462026-05-19T23:58:02ZRachel···Y.Li1938-12-01UHC-49940-99•••-••-673216579301489—4340 Sunset BoulevardAUSTINTX78782GRP-3451OPTIONS-PPO
ENRENR-1427772026-03-04T09:17:06ZAustin—HughesOct 6, 2000··UHC-15363-44•••-••-33754455878753austin.hughes99@icloud.com576 Highland AvenueTampaFL—GRP-7645·MEDICARE-ADV-B
ENRENR-1271352026-09-29T18:06:34ZCharlesUColeman1983-03-17UHC-53295-26NULL8957258319-4396 Canyon RdNashvilleTN37250GRP-9065··MEDICARE-ADV-B
ENRENR-1272752026-01-26T04:28:14ZHernandez, WalterE—2001-11-13UHC-05632-94•••-••-99973059925929—2225 RIDGE RDNashvilleTNnullGRP-0193OPTIONS-PPO
ENRENR-1011262026-09-05T01:15:28ZRYANX.··KELLY1969-12-07uhc-98387-34•••-••-9121221-623-2833ryan.kelly@icloud.com9059 Maple AveAustinTX78780·GRP-6959MEDICARE-ADV-B
ENR ENR-1010122026-03-30T08:45:03Zpriya—collyns1938-07-18UHC-14575-37•••-••-4208217-371-3753UNKNOWN··2440 Sage CourtHoustonTX77014GRP-2220CORE-HMO
43,101 rows, page 205 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:40.345Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty