item-robot.com
Aug 9, 2026
Full database dump of item-robot.com, a Japanese e-commerce analytics/automation SaaS platform (likely serving Rakuten sellers). The archive contains approximately 18 million records across 26 tables including customers, members, shops, mail histories, queries, scripts, and Rakuten Super Sale logs. Data includes customer histories, mail templates, and account management data.
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.
info.txt12 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | firstName | high | [0] header 'first_name', values are common given names (e.g., 'Taro', 'Hanako') |
| 1 | lastName | high | [1] header 'last_name', values are common family names (e.g., 'Yamada', 'Sato') |
| 2 | skip | high | [2] header 'email', values contain '@' with valid domain structures (e.g., 'user@example.com') |
| 3 | skip | high | [3] header 'phone', values are 10-digit numbers (e.g., '09012345678') |
| 4 | skip | high | [4] header 'birth_date', values match YYYY-MM-DD date pattern (e.g., '1990-05-15') |
| 5 | username | high | [5] header 'username', values are alphanumeric handles (e.g., 'user123', 'taro_yamada') |
| 6 | address1 | high | [6] header 'address1', values contain Japanese address formats (e.g., '東京都渋谷区') |
| 7 | city | high | [7] header 'city', values are Japanese city names (e.g., '渋谷区', '中央区') |
| 8 | state | high | [8] header 'state', values are Japanese prefecture names (e.g., '東京都', '大阪府') |
| 9 | zip | high | [9] header 'zip', values match Japanese postal code pattern (e.g., '100-0001', '542-0081') |
| 10 | country | high | [10] header 'country', values are consistently 'Japan' or '日本' |
| 11 | gender | high | [11] header 'gender', values are 'M' or 'F' (male/female) |
Notes: 12 PII columns identified across first 50 rows. All columns mapped with high confidence based on header names and value patterns. Additional columns in full dataset may contain further PII requiring review.
item-robot.com_18M_Japan_Full_DB__acl_phinxlog.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file is a migration log and does not contain any PII fields. It includes version, migration name, start time, end time, and breakpoint information only. No columns map to PII fields.
item-robot.com_18M_Japan_Full_DB__acos.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: The file is a hierarchical tree structure with columns: id, parent_id, model, foreign_key, alias, lft, rght. None of these columns contain PII. Values are internal IDs, model names, and tree navigation positions. No emails, phone numbers, names, addresses, or other PII appear in the sample.
item-robot.com_18M_Japan_Full_DB__aros.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a hierarchical tree structure (likely nested set model) showing group-member relationships. Columns are all internal IDs/relationships: id, parent_id, model (entity type), foreign_key (target ID), alias (optional name), lft/rght (tree position). No PII is present.
item-robot.com_18M_Japan_Full_DB__aros_acos.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a simple access control matrix with numeric IDs and flags. No PII is present in any column. All entries are internal system identifiers and access permissions.
item-robot.com_18M_Japan_Full_DB__auto_account_issue_task.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns detected. All visible columns appear to be internal system identifiers, status codes, messages, timestamps, and flags — none contain personal or sensitive data. The dataset represents system process logs rather than user records.
item-robot.com_18M_Japan_Full_DB__customer_histories.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns detected. All columns are internal IDs, timestamps, status codes, or JSON payload strings without personal data. 'id', 'server_id', 'ch_id', 'user_id', 'action', 'status', 'result' (JSON server data), 'udate', 'rdate', 'created', and 'modified' are all internal/system fields or timestamps.
item-robot.com_18M_Japan_Full_DB__customer_mail_detail_histories.csv2 columns18,629,459 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 4 | username | high | header "user_name" resolves to PII field "username" |
| 5 | high | header "mail" resolves to PII field "email" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
item-robot.com_18M_Japan_Full_DB__customer_mail_histories.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No identifiable PII fields present in the visible data. All columns appear to be numeric counts, types, search terms, comments, and timestamps. No names, emails, addresses, phone numbers, or other PII are visible in the sample.
item-robot.com_18M_Japan_Full_DB__customers.csv2 columns42,189 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | username | high | header "user_name" resolves to PII field "username" |
| 15 | high | header "mail" resolves to PII field "email" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
item-robot.com_18M_Japan_Full_DB__delays.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All columns are internal IDs, timestamps, counters, or flags. No PII present in this dataset.
item-robot.com_18M_Japan_Full_DB__gms_ranks.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns present. All columns are internal identifiers, timestamps, or business metadata (shop IDs, plans, flags, counters). No names, emails, addresses, phone numbers, DOB, SSN, or other PII fields detected.
item-robot.com_18M_Japan_Full_DB__groups.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a table of internal user accounts (admin/support/guest) with no PII. Columns: id (numeric ID), name (role identifier), created (timestamp), modified (timestamp). No personal identifiers present.
item-robot.com_18M_Japan_Full_DB__mail_histories.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains no PII columns. All columns are internal system identifiers, template metadata, timestamps, and flags. No emails, names, addresses, or other personal data are present.
item-robot.com_18M_Japan_Full_DB__mail_history_receivers.csv1 column67,018 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 4 | high | header "mail" resolves to PII field "email" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
item-robot.com_18M_Japan_Full_DB__mail_tasks.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains only internal IDs, template names, parameters, status flags, and timestamps. No PII fields are present. All columns map to skip categories (internal IDs, timestamps, flags).
item-robot.com_18M_Japan_Full_DB__mail_templates.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file appears to be a series of email templates, not structured PII data. All visible columns contain template metadata or body text. No actual PII fields (emails, names, addresses, etc.) are present in the first 50 rows—only placeholders like {{last_login_date}}, {{user_name}}, {{shop_url}}. These are template variables, not real data. Therefore, no PII columns map to defined fields.
item-robot.com_18M_Japan_Full_DB__members.csv2 columns16 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | username | high | [1] header 'username', values are alphanumeric strings including 'admin' and 'okinawa' prefixes |
| 2 | password | high | [2] header 'password', values show hashed formats (bcrypt) and some plaintext passwords embedded in comments |
Notes: This is a user account table with username and password fields. Passwords appear to be stored as bcrypt hashes, but some rows include plaintext passwords in the comment field. No other PII fields (email, phone, name, address, etc.) are present in this sample.
item-robot.com_18M_Japan_Full_DB__phinxlog.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: no·Quote: "
Notes: No PII columns present. File contains only migration metadata: version, migration name, timestamps, and breakpoint status. No personal or sensitive data exposed.
item-robot.com_18M_Japan_Full_DB__queries.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains SQL query metadata and system configuration records, not customer PII. All columns represent internal system identifiers, query strings, timestamps, and status flags. No PII fields are present.
item-robot.com_18M_Japan_Full_DB__rakuten_super_sale_log.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: The file appears to be a structured CSV with no PII columns present. All columns contain internal IDs, product codes, timestamps, and other non-personal data. No fields map to email, phone, name, address, DOB, SSN, or other PII categories based on header names and sample values. This is consistent with the described context of an e-commerce analytics/automation platform database dump containing product and transaction data.
item-robot.com_18M_Japan_Full_DB__reissue_password_log.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns identified. All columns are internal identifiers, timestamps, or counters. The file appears to be a log of IP addresses with execution counts and timestamps, containing no personal or sensitive data.
item-robot.com_18M_Japan_Full_DB__scripts.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All columns represent internal system metadata: IDs, command-line tools, display flags, timestamps, and status codes. No PII is present. Columns like 'title' and 'command' contain technical operation names and shell commands, not personal data. Timestamps ('created', 'modified') are system logs, not DOB. Per exclusion rules, all columns are skipped.
item-robot.com_18M_Japan_Full_DB__servers.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All columns are internal identifiers, system metadata, or network configuration details. No PII fields present. Columns like 'name' and 'host' represent system-generated identifiers or domain names, not personal names. IPs and keys are infrastructure-related, not user-identifiable PII per exclusion rules.
item-robot.com_18M_Japan_Full_DB__shops.csv73 rows
File structure
Notes: Unstructured fallback: no PII columns mapped, but the raw text carries emails
item-robot.com_18M_Japan_Full_DB__stat_active_shops.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All columns are internal IDs, timestamps, status codes, or counters. No PII is present in the sample data.