emoticibo.com
Apr 25, 2023
Full WordPress database dump from emoticibo.com, an Italian lifestyle/food blog run by Gloria Brolatti. The breach contains the complete WordPress MySQL database including user accounts, hashed passwords, login activity, failed login logs, comments with author emails and IPs, subscriber lists, posts, and SEO metadata. The site used All In One WP Security plugin. Data spans from approximately 2015 to 2023.
Data found in this dataset
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
emoticibo__emotiwp_aiowps_failed_logins.csv3 columns5,008 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | username | high | [2] column 'user_login' contains usernames like 'emotiadmin', 'gloria', 'admin', 'wadminw', 'wwwadmin', 'studiodentisticosanpaolo' |
| 3 | username | high | [3] column 'failed_login_date' is a timestamp and should be skipped per rules. However, the column index mapping must reflect the actual PII columns present. Since this is a timestamp, it is skipped. |
| 4 | ip_address | high | [4] column 'login_attempt_ip' contains IPv4 addresses |
Notes: This is a log table from WordPress security plugin tracking failed login attempts. Contains usernames and IP addresses. No emails, names, or other PII are present in this sample. The 'failed_login_date' column is a timestamp and is skipped per rules. The 'user_id' column is an internal numeric ID and is skipped.
emoticibo__emotiwp_aiowps_login_activity.csv1 column135 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | username | high | [2] header 'user_login', values are alphanumeric usernames like 'emotiadmin' and 'gloria' |
Notes: 50 rows shown, only column 2 (user_login) contains PII (username). All other columns are internal IDs, timestamps, IPs, or empty fields which must be skipped per rules.
emoticibo__emotiwp_aiowps_login_lockdown.csv2 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | user_login | high | [2] header 'user_login', values match usernames |
| 123 | user_login | high | [123] user_id 2 maps to 'gloria' username, values match |
Notes: Only two relevant columns with PII: user_login (username). Other columns (id, user_id, lockdown_date, etc.) are internal IDs, timestamps, or flags and should be skipped per rules. No emails, passwords, or other PII fields detected in this sample.
emoticibo__emotiwp_commentmeta.csv197 rows
File structure
Notes: Unstructured fallback: no PII columns mapped, but the raw text carries emails
emoticibo__emotiwp_comments.csv1 column168 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | high | unlabeled column — sampled values parse as email addresses |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
emoticibo__emotiwp_ngg_gallery.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a WordPress gallery metadata dump, not user PII. Columns contain gallery IDs, slugs, paths, titles, descriptions, and author IDs. No actual personal information (emails, names, etc.) is exposed in these fields. The 'author' column is a numeric user ID referencing WordPress users elsewhere in the database, which would need to be cross-referenced with wp_users/wp_usermeta tables for PII. This file alone contains no mappable PII fields.
emoticibo__emotiwp_ngg_pictures.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All columns are internal identifiers, filenames, timestamps, or serialized metadata. No PII fields are present in this dataset.
emoticibo__emotiwp_options.csv5 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 6 | skip | high | [6] value 'websupport@link107.com' matches email pattern, column name 'admin_email' suggests email address |
| 15 | skip | high | [15] value 'login@example.com' matches email pattern, column name 'mailserver_login' suggests email address |
| 16 | password | high | [16] value 'password' is a literal password, column name 'mailserver_pass' suggests password |
| 7708 | skip | high | [7708] value 'info@emoticibo.com' matches email pattern, column name 'smtp_user' suggests email address |
| 7709 | password | high | [7709] value 'E!moti-2015' is likely a password, column name 'smtp_pass' suggests password |
Notes: CSV file contains WordPress database options. Identified email addresses in admin_email, mailserver_login, smtp_user columns and passwords in mailserver_pass and smtp_pass columns. Other columns contain non-PII data such as site settings, plugin options, and timestamps.
emoticibo__emotiwp_postmeta.csv132 rows
File structure
Notes: Unstructured fallback: no PII columns mapped, but the raw text carries emails
emoticibo__emotiwp_posts.csv1 column33 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 4 | emailText | high | free-text column with embedded emails (7/96 cells, 7% density) |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
emoticibo__emotiwp_slim_events.csv0 rows
File structure
Notes: This is a structured CSV file containing click event logs from the emoticibo WordPress database. The columns represent event metadata (event_id, type, description, notes, position, id, dt). No PII fields are present in this dataset - it only contains event identifiers, click positions, and timestamps. The data appears to track user interactions with page elements (titles, IDs) and coordinates.
emoticibo__emotiwp_slim_stats.csv3 columns122,380 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | username | high | [3] header 'username', values are usernames |
| 4 | skip | high | [4] header 'email', contains typical email addresses |
| 27 | username | medium | [27] header 'author', values match known usernames from column 3 |
Notes: 33 total columns, 3 contain PII: username (columns 3 and 27), email (column 4). All other columns are internal IDs, timestamps, technical metadata, or browser/fingerprint data — none contain personal PII. The file is a WordPress security log and user tracking table from the emoticibo.com breach.
emoticibo__emotiwp_subscribe_reloaded_subscribers.csv1 column70 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | high | header "subscriber_email" resolves to PII field "email" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
emoticibo__emotiwp_term_relationships.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: no·Quote: "
Notes: This is a pure taxonomy mapping table with three numeric columns: object_id, term_taxonomy_id, and term_order. No PII fields present. All columns are internal identifiers for WordPress term relationships and contain no personal data.
emoticibo__emotiwp_term_taxonomy.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains taxonomy/term data (categories, tags, navigation menus) from a WordPress database. No personal identifiable information (PII) is present. Columns represent internal taxonomy identifiers, term relationships, and counts — all internal metadata. No emails, names, addresses, or other PII fields are included.
emoticibo__emotiwp_terms.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a taxonomy/terms table from a WordPress database dump. It contains category/tag names and slugs, no PII fields. All columns represent internal taxonomy identifiers and labels, which are not personally identifiable information.
emoticibo__emotiwp_usermeta.csv5 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | firstName | high | [2] header 'first_name', values are common given names |
| 3 | lastName | high | [3] header 'last_name', values are common surnames |
| 10 | username | high | [10] meta_key 'emotiwp_capabilities' contains serialized data with user capability keys, indicating a WordPress user account |
| 56 | username | high | [56] meta_key 'wpseo_title' contains WordPress SEO metadata, indicating a user-related entry |
| 78 | password | high | [78] meta_key 'emotiwp_yoast_notifications' contains serialized data with a 'user_pass' field showing a hashed password |
Notes: Only PII columns from the first 50 rows are included. The file is a WordPress user metadata dump with hashed passwords and user capabilities. Columns containing internal WordPress metadata, timestamps, and plugin settings are excluded as non-PII per the rules.
emoticibo__emotiwp_users.csv5 columns2 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | username | high | [1] column 'user_login' contains usernames: 'emotiadmin', 'gloria' |
| 3 | password | high | [3] column 'user_pass' contains hashed passwords using WordPress $P$ format |
| 4 | username | high | [4] column 'user_nicename' contains URL-friendly usernames: 'emotiadmin', 'gloria' |
| 5 | skip | high | [5] column 'user_email' contains valid email addresses: 'alessio.burigana@link107.com', 'gloriabro@gmail.com' |
| 9 | fullName | high | [9] column 'display_name' contains displayed names: 'Emoticibo', 'Gloria Brolatti' |
Notes: WordPress user table dump with 10 columns. PII includes usernames (user_login), hashed passwords (user_pass), nicenames (user_nicename), emails (user_email), and display names (display_name). Other columns are internal WordPress IDs, registration timestamps, and status flags — these are skipped per rules.
emoticibo__emotiwp_yoast_indexable.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns detected. All columns are internal IDs, URLs, metadata, timestamps, SEO settings, or flags. No email, phone, name, address, or other personal data appears in the sample.
emoticibo__emotiwp_yoast_indexable_hierarchy.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: no·Quote: "
Notes: The file contains only internal hierarchical IDs (indexable_id, ancestor_id, depth, blog_id). These are numeric identifiers used for tree structure navigation and do not contain any personal or sensitive information. No PII fields present.
emoticibo__emotiwp_yoast_primary_term.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a taxonomy table (term relationships) with no PII. Columns are internal IDs (id, post_id, term_id), taxonomy name, and timestamps. No PII fields present.
emoticibo__emotiwp_yoast_seo_links.csv12 rows
File structure
Notes: Unstructured fallback: no PII columns mapped, but the raw text carries emails
emoticibo__emotiwp_yoast_seo_meta.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains only internal WordPress object identifiers and link counters. No PII fields present. Columns: object_id (internal post/page ID), internal_link_count, incoming_link_count. All values are numeric counters.