latimes.com
Disclosed Sep 9, 2026
MySQL database dump from eedition.latimes.com containing user account data for the LA Times e-edition platform. Includes first names, last names, usernames, plaintext passwords, email addresses, IP ranges, and account settings. The AUTO_INCREMENT value suggests approximately 117,560 user records.
Data found in this dataset
Search this dataset
Team members search this dataset here and through the API. Access is by invitation from your team admin, or by request.
Source files
Expand any file to inspect its column headers and the field each maps to.
latimes_users.txt16 columns104,463 rows
File structure
| Source column | Mapped field | Confidence |
|---|---|---|
| 0 | skip | high |
| USER_ID is auto-increment primary key, internal ID | ||
| 1 | skip | high |
| PARENT_ID is internal foreign key reference | ||
| 2 | firstName | high |
| column named FIRST_NAME, values are personal first names | ||
| 3 | lastName | high |
| column named LAST_NAME, values are personal last names | ||
| 4 | username | high |
| column named AUTH_ID, values are human-generated login identifiers (smartinez, RReeder@newsstand.com, latimestest01, etc.) | ||
| 5 | skip | high |
| ALIVE is account status flag, non-PII | ||
| 6 | skip | high |
| IP_RANGES contains internal network configuration, not personal PII | ||
| 7 | password | high |
| column named PASSWORD, values appear to be plaintext passwords | ||
| 8 | skip | high |
| DISPLAY_THUMBNAILS is boolean user preference setting | ||
| 9 | skip | high |
| SHOW_ALL_ISSUES is boolean user preference setting | ||
| 10 | skip | high |
| OPEN_ISSUE is boolean user preference setting | ||
| 11 | high | |
| column named EMAIL_ADDRESS, values contain @ symbol and email domains | ||
| 12 | skip | high |
| SAW_PLUGIN is boolean user preference setting | ||
| 13 | skip | high |
| EMAIL_NOTIFY is boolean notification preference | ||
| 14 | skip | high |
| LANGUAGE is locale setting (en, etc.), non-PII | ||
| 15 | country | high |
| column named COUNTRY, values are country codes (US) | ||
Notes: MySQL dump from LA Times e-edition platform. Contains approximately 117,560 user records with plaintext passwords exposed. Critical PII fields: email addresses, plaintext passwords, personal names, and usernames. Some AUTH_ID values are email addresses serving as alternate authentication method.