calcioshop.it
Apr 1, 2021
480,458
Records
1
Files
May 30, 2026
Added
Breach of CalcioShop, an Italian sports/football equipment e-commerce site. Contains order data exported from an Elasticsearch index, including customer names, email addresses, billing and shipping addresses, phone numbers, tax/fiscal codes (Italian codice fiscale), VAT numbers, payment methods, order totals, product details, and IP addresses. Data spans at least October 2019 through April 2021.
Data found in this dataset
EmailFirst nameLast nameAddressCityStateCountryskipphonezipssn
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
CalcioShop_BF__data__calcioshop_orders_april_2021.csv43 columns480,458 rows
File structure
Format: NDJSON
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| date | skip | high | EXCLUSION RULE: order timestamp/date, CRM metadata |
| firstname | firstName | high | key name 'firstname' matches firstName pattern; values are personal first names |
| s_phone | phone | high | key 's_phone' contains 'phone'; values are phone numbers in shipping context |
| vat_number | skip | high | VAT number is business/commercial identifier, not personal PII in same sense as SSN; used for business tax purposes |
| s_zipcode | zip | high | key 's_zipcode' with shipping prefix; values are postal codes (shipping context) |
| discount | skip | high | EXCLUSION RULE: financial amount |
| b_phone | phone | high | key 'b_phone' contains 'phone'; values are phone numbers in billing context; phone is still PII regardless of billing vs shipping |
| membership | skip | high | membership program name, non-PII metadata |
| b_city | skip | high | EXCLUSION RULE: BillingCity prefix 'b_' indicates billing address, which is business data |
| s_address | address1 | high | key 's_address' with shipping prefix; values are street addresses (mailing/shipping, not billing) |
| userid | skip | high | EXCLUSION RULE: user_id is internal ID, not username |
| b_address | skip | high | EXCLUSION RULE: BillingStreet/BillingAddress prefix 'b_' indicates billing address, which is business data, not mailing/shipping address |
| b_lastname | lastName | high | billing lastname; key prefix 'b_' indicates billing address field; maps to lastName for billing context |
| s_city | city | high | key 's_city' with shipping prefix; values are city names from shipping addresses |
| itemid | skip | high | product/item IDs, internal product identifiers |
| total | skip | high | EXCLUSION RULE: financial amount |
| categoryids | skip | high | product category IDs, internal product classification |
| s_state | state | high | key 's_state' with shipping prefix; values are Italian province codes (shipping context) |
| tax_number | ssn | high | key 'tax_number'; values match Italian codice fiscale format (16-char alphanumeric, e.g., LSCRRT96H16G113P); codice fiscale is equivalent to SSN in Italy |
| extra | skip | high | nested metadata including tracking IDs, IP addresses (non-PII), payment refs, shipping instructions; predominantly internal/transactional |
| b_firstname | firstName | high | billing firstname; key prefix 'b_' indicates billing address field; maps to firstName for billing context |
| s_firstname | firstName | high | shipping firstname; key prefix 's_' indicates shipping address field; values are personal first names |
| company | skip | high | EXCLUSION RULE: key contains 'Company'; business data |
| id | skip | high | EXCLUSION RULE: auto-increment internal ID |
| s_lastname | lastName | high | shipping lastname; key prefix 's_' indicates shipping address field; values are personal last names |
| high | key name 'email'; values contain @ symbol and are valid email addresses | ||
| payment_method | skip | high | payment type label (Contrassegno, PayPal, etc.), transactional metadata |
| b_country | skip | high | EXCLUSION RULE: Billing country is business data; 'b_' prefix indicates billing context |
| product | skip | high | product details (title, productid, productcode), transactional/catalog data |
| coupon | skip | high | promotional coupon code, non-PII transactional data |
| orderid | skip | high | order transaction ID, internal sequence number |
| shipping_cost | skip | high | EXCLUSION RULE: financial amount |
| membershipid | skip | high | membership subscription ID, internal identifier |
| payment_surcharge | skip | high | EXCLUSION RULE: financial charge amount |
| s_country | country | high | key 's_country' with shipping prefix; values are country codes (shipping context) |
| lastname | lastName | high | key name 'lastname' matches lastName pattern; values are personal last names |
| b_zipcode | skip | high | EXCLUSION RULE: BillingPostalCode prefix 'b_' indicates billing address, which is business data |
| shippingid | skip | high | shipping method ID, internal identifier |
| subtotal | skip | high | EXCLUSION RULE: financial amount |
| paymentid | skip | high | payment method ID, internal identifier |
| b_state | skip | high | EXCLUSION RULE: BillingState prefix 'b_' indicates billing address, which is business data |
| coupon_discount | skip | high | EXCLUSION RULE: financial discount amount |
| status | skip | high | order status code (B, C, E, F, I), transactional metadata |
Notes: CalcioShop e-commerce order database export. Mapping preserves PII in customer names, contact info, and shipping addresses. Italian tax numbers (codice fiscale) mapped to SSN equivalent. Billing addresses correctly excluded per rule. Email and phone retained as PII even in billing context. Shipping fields (s_*) mapped to mailing address; billing fields (b_*) skipped per EXCLUSION RULE for business address data.