boat-lifestyle.com

Mar 5, 2024

7,550,000

Records

153

Files

May 30, 2026

Added

In March 2024, Indian consumer electronics brand boAt Lifestyle suffered a data breach affecting approximately 7.5 million customers. The data was exfiltrated from their Shopify Plus store and includes customer email addresses, full names, phone numbers, physical addresses, order history, and purchase amounts. The breach was carried out by a threat actor known as @ShopifyGUY and published on BreachForums.

Data found in this dataset

EmailFirst nameLast nameAddressCityStateCountryaddress2phonezipskipfullName

Source files

Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.

BoAtLifestyleIndia__Info.txt

10 columns0 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
addresses.address2	address2	high	Nested 'address2' in addresses array contains address supplements
addresses.address1	address1	high	Nested 'address1' in addresses array contains street addresses
phone	phone	high	'phone' field contains phone numbers (+918953613727, null values)
last_name	lastName	high	'last_name' field contains family names (Kumar, Pal)
addresses.zip	zip	high	Nested 'zip' field contains postal codes (210201, 201206)
addresses.city	city	high	Nested 'city' contains city names (Banda, Ghaziabad)
addresses.country	country	high	Nested 'country' field contains country name (India)
first_name	firstName	high	'first_name' field contains given names (Vishnu, Krishna)
email	email	high	Top-level 'email' field contains email addresses ([email protected], [email protected])
addresses.province	state	high	Nested 'province' field contains state/province (Uttar Pradesh)

Notes: JSON format with nested customer records from boAt Lifestyle Shopify Plus store breach. Each customer record contains email, name, phone, and nested addresses array. All PII fields identified from breach context (emails, names, phones, addresses). Non-PII fields (id, created_at, updated_at, orders_count, state, total_spent, last_order_id, verified_email, tax_exempt, tags, currency, multipass_identifier, email_marketing_consent, sms_marketing_consent, admin_graphql_api_id) automatically treated as skip.

BoAtLifestyleIndia__data__shop.json

0 rows

File structure

Notes: NOT DATA — This is a README/metadata file. It contains shop configuration and administrative details about the boAt Lifestyle Shopify store (shop ID, domain, timezone settings, plan information, feature flags), not customer PII records. While it includes the shop owner name ('Vibhor Jain') and shop email, this is business metadata, not a customer data export. There are no structured customer records with PII. This file describes the breach context/source, not the actual breached customer data. No importable customer PII columns.

BoAtLifestyleIndia__data__shopify_customers_partial_10_20240303200908.json

15 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Located in addresses array, contains postal codes
country	country	high	Located in addresses array, contains country names
address2	address2	high	Located in addresses array, contains secondary address information
city	city	high	Located in addresses array, contains city names
address1	address1	high	Located in addresses array, contains street addresses
last_name	lastName	high	Consistently contains last names across records (some null/empty)
province_code	skip	high	Province code (e.g., 'UP') is metadata, not a distinct PII field
country_code	skip	high	Country code (e.g., 'IN') is metadata, not a distinct PII field
province	state	high	Located in addresses array, contains province/state names (e.g., 'Uttar Pradesh')
phone	phone	high	Top-level phone field with phone numbers in international format
name	skip	high	Redundant with first_name and last_name fields already mapped
country_name	skip	high	Redundant with country field already mapped
company	skip	high	Company field is business metadata, not personal PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Top-level email field present in all records, matches breach context of customer emails from Shopify store

Notes: Data structure is Shopify customer export format. Address information is nested in 'addresses' array and 'default_address' object. The 'name' field in address objects duplicates first_name/last_name. Record 3 demonstrates full name stored in first_name with last_name null. Phone field can be null at top level but present in address objects. No SSN, DOB, password, username, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_10_20240304203617.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested within addresses array; contains postal/ZIP codes
country	country	high	Nested within addresses array; contains country name (India)
province	state	high	Nested within addresses array; contains Indian state names (Haryana, Maharashtra, etc.)
phone	phone	high	Contains phone numbers in international format (e.g., +919656183946); null values present
address2	address2	high	Nested within addresses array; contains secondary/detailed address information
city	city	high	Nested within addresses array; contains city names
address1	address1	high	Nested within addresses array; contains primary street address lines
last_name	lastName	high	Contains last names; null values present but field is clearly for last names
first_name	firstName	high	Contains first names; null values present but field is clearly for first names
email	email	high	Consistently contains email addresses across all records

Notes: Data structure is Shopify customer export format. Address information is nested within 'addresses' array; each address object contains the mapped PII fields. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'total_spent', 'currency', 'verified_email', 'tax_exempt', 'tags', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are non-PII metadata and skipped. The 'name' field within address objects is a derived/denormalized field (concatenation of first_name and last_name) and not separately mapped. No DOB, SSN, password, username, gender, suffix, or middle name fields present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_11_20240303202442.json

13 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in addresses array objects
country	country	high	Country names in addresses array objects
address2	address2	high	Secondary address field in addresses array objects
city	city	high	City names consistently populated in addresses
address1	address1	high	Primary street address in addresses array objects
last_name	lastName	high	Customer last names present in most records
province_code	skip	high	State abbreviation code; redundant with province/state data
country_code	skip	high	ISO country code; metadata only
province	state	high	Province field in addresses array maps to state PII field
phone	phone	high	Phone numbers in E.164 format and regional formats
state	state	medium	Province/state field (note: 'state' at root level refers to account state; use 'province' from addresses for state data)
first_name	firstName	high	Customer first names consistently populated
email	email	high	Direct email addresses present in all records

Notes: This is a Shopify customer export from the boAt Lifestyle breach (March 2024). Root-level 'state' field indicates account status (enabled/disabled), not geographic state — do NOT map to PII. Geographic state/province data resides in the 'addresses' array objects. Phone numbers appear both at root level and within address objects. Name data sometimes appears as separate first_name/last_name fields, and also as 'name' field within addresses. All PII fields identified align with breach context: emails, full names, phone numbers, and complete physical addresses.

BoAtLifestyleIndia__data__shopify_customers_partial_11_20240304205620.json

19 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within address objects
total_spent	skip	high	Transaction metadata; not PII
country	country	high	Country field within address objects
addresses	skip	high	Nested array structure; address components mapped individually below
address2	address2	high	Street address line 2 within address objects
city	city	high	City field within address objects
address1	address1	high	Street address line 1 within address objects
last_name	lastName	high	Top-level last name field consistently populated
created_at	skip	high	Timestamp; not PII
verified_email	skip	high	Boolean flag; not PII
orders_count	skip	high	Metadata; not PII
province	state	high	Province/state field within address objects (India uses 'province')
updated_at	skip	high	Timestamp; not PII
phone	phone	high	Phone field at top level (often null, but present in structure)
name	skip	high	Derived concatenation of first/last name in nested objects; already captured separately
id	skip	high	Customer/record ID; not PII
state	skip	high	Account state (enabled/disabled); not PII
first_name	firstName	high	Top-level first name field consistently populated
email	email	high	Direct email addresses present in all records

Notes: This is a Shopify customer export from the boAt Lifestyle breach. Address data is nested within 'addresses' array and 'default_address' object; both contain identical address component keys (address1, address2, city, province, zip, country). The 'province' field maps to 'state' PII type. The top-level 'phone' field is frequently null; phone numbers are reliably present in the nested address objects. The 'name' field in nested objects is a redundant concatenation of first_name and last_name. Fields like 'company', 'verified_email', 'tax_exempt', 'tags', 'currency', 'orders_count', and metadata fields are classified as skip.

BoAtLifestyleIndia__data__shopify_customers_partial_12_20240303204008.json

35 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested address objects
note	skip	high	Account notes, not core PII
last_order_name	skip	high	Order reference, not PII
city	city	high	City field in both top-level and nested address objects
created_at	skip	high	Account creation timestamp, not PII
multipass_identifier	skip	high	Internal system identifier, not PII
province_code	skip	high	State/province abbreviation code - administrative field, not core PII
default_address	skip	high	Duplicate/reference to address object already mapped
province	state	high	Province/state field in nested address objects
updated_at	skip	high	Account modification timestamp, not PII
country_name	skip	high	Redundant with country field
currency	skip	high	Transaction metadata, not PII
company	skip	high	Business entity, not personal PII
id	skip	high	Internal customer identifier, not PII
state	skip	high	Account status field, not PII
first_name	firstName	high	Top-level first_name field with given names
email	email	high	Top-level email field containing email addresses
zip	zip	high	Postal code field in both top-level and nested address objects
total_spent	skip	high	Transaction metadata, not PII
last_order_id	skip	high	Order reference, not PII
address2	address2	high	Secondary address field in both top-level and nested address objects
tax_exempt	skip	high	Account attribute, not PII
address1	address1	high	Street address in both top-level and nested address objects
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Top-level last_name field with surnames
verified_email	skip	high	Account verification status, not PII
tags	skip	high	Administrative metadata, not PII
country_code	skip	high	Country ISO code - administrative field, not core PII
orders_count	skip	high	Transaction metadata, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field with international phone numbers
admin_graphql_api_id	skip	high	Internal API identifier, not PII
name	skip	high	Derived/composite field (already captured by first_name/last_name)
tax_exemptions	skip	high	Account attribute array, not PII
customer_id	skip	high	Internal reference identifier, not PII

Notes: Shopify customer export from boAt Lifestyle breach. Structure includes top-level customer fields and nested 'addresses' array containing address objects. All PII fields are at top-level or within addresses array. Note: first_name sometimes contains honorifics (e.g., 'Dr RAMPUKAR pd') but no separate 'title' field exists, so these are stored as part of firstName. The phone field contains international format numbers; nested phone in addresses contains local format. All mapped fields represent actual customer PII from the breach context.

BoAtLifestyleIndia__data__shopify_customers_partial_12_20240304211542.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field from addresses array
note	skip	high	Internal note field
addresses	skip	high	Array container; individual fields within mapped separately
last_order_name	skip	high	Order reference metadata
city	city	high	City field from addresses array
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Shopify internal identifier
province_code	skip	high	State code abbreviation, metadata
default	skip	high	Boolean flag for default address
default_address	skip	high	Duplicate of addresses array; address data mapped from nested fields
province	state	high	Province/state field from addresses array
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Duplicate country field, metadata
currency	skip	high	Currency metadata
company	skip	high	Company/business name, not personal PII
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state/status, not address state
first_name	firstName	high	Explicit first name field
email	email	high	Standard email field containing customer email addresses
zip	zip	high	Postal code field from addresses array
total_spent	skip	high	Transaction metadata
last_order_id	skip	high	Transaction metadata
address2	address2	high	Secondary address line from addresses array
tax_exempt	skip	high	Tax status metadata
address1	address1	high	Primary address line from addresses array
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Explicit last name field
verified_email	skip	high	Boolean metadata
tags	skip	high	Internal categorization
orders_count	skip	high	Transaction metadata
country_code	skip	high	Country code abbreviation, metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Top-level phone field (appears null in most records, but present in schema)
admin_graphql_api_id	skip	high	Shopify internal API identifier
name	skip	high	Concatenated full name; use separate first_name and last_name fields
tax_exemptions	skip	high	Tax metadata array
customer_id	skip	high	Internal identifier

Notes: Data structure is Shopify customer export format. Address data appears in nested 'addresses' array and duplicated in 'default_address' object; mapped PII fields from the nested structure. The top-level 'phone' field is typically null; actual phone numbers appear in the 'addresses' array nested phone field. Note: In some records, last_name contains placeholder values like '.' indicating incomplete data entry.

BoAtLifestyleIndia__data__shopify_customers_partial_13_20240303205537.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses and default_address objects
country	country	high	Country field in nested addresses and default_address objects
phone	phone	high	Explicit phone field with international format (+91 country code)
address2	address2	high	Secondary address field in nested addresses and default_address objects
city	city	high	City field in nested addresses and default_address objects
address1	address1	high	Street address field in nested addresses and default_address objects
last_name	lastName	high	Explicit last_name field; contains family names (null in many records)
state	state	medium	Province/state field in nested addresses as 'province'; note: top-level 'state' field refers to account status, not geographic state
first_name	firstName	high	Explicit first_name field; contains given names
email	email	high	Explicit email field containing valid email addresses

Notes: Shopify customer export format. Name data is primarily in first_name field; last_name is often null with full name embedded in first_name. Address data is nested within 'addresses' array and 'default_address' object. No passwords, SSNs, DOB, gender, username, or suffix fields present in provided records. The 'state' field at top level indicates account status (enabled/disabled), not geographic location.

BoAtLifestyleIndia__data__shopify_customers_partial_13_20240304213518.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code found in address objects
country	country	high	Country name consistently 'India' in address objects
province	state	high	Indian state/province information (West Bengal, Jharkhand, Bihar, etc.); maps to state field
phone	phone	high	Top-level phone field (typically null in main record but present in address objects); phone numbers found in address.phone
address2	address2	high	Secondary address line found in address objects (apartment, suite, etc.)
city	city	high	City name consistently found in address objects
address1	address1	high	Street address found in address objects; contains primary street/building information
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Consistently contains email addresses across all records

Notes: Data is from Shopify Plus store with nested address objects. PII fields are present at both top level (email, first_name, last_name) and within the addresses array. The 'province' field contains Indian state names and maps to the 'state' PII field. Phone numbers are primarily found within address objects rather than at the top level. No passwords, SSNs, DOBs, usernames, gender, or suffix fields present in provided records. The 'name' field at both levels is a concatenation of first and last names and could be skipped as firstName/lastName are separately available.

BoAtLifestyleIndia__data__shopify_customers_partial_14_20240303211106.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array
country	country	high	Country field in addresses array
province	state	high	Province/state field in addresses array
phone	phone	high	Direct phone field at customer level
address2	address2	high	Secondary address line in addresses array
city	city	high	City field in addresses array
address1	address1	high	Primary street address in addresses array
name	fullName	high	Combined full name field in addresses array (e.g., 'Abhishor Rai')
last_name	lastName	high	Direct last name field
first_name	firstName	high	Direct first name field
email	email	high	Direct email field containing customer email addresses

Notes: This is a Shopify customer export from the boAt Lifestyle breach. Data structure contains customer-level fields (email, first_name, last_name, phone) and nested addresses array with detailed address information. The 'name' field in addresses is a concatenated fullName. The 'province' field represents state/region in Indian context. No SSN, DOB, password, username, gender, suffix, or middle name fields detected in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_14_20240304215431.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array
country	country	high	Country field within addresses array
province	state	high	Province field maps to state; Indian states are administrative divisions equivalent to US states
phone	phone	high	Phone field at customer root level (though often null); phone also appears in addresses
address2	address2	high	Secondary address field within addresses array (apartment, suite, etc.)
city	city	high	City field within addresses array
address1	address1	high	Street address field within addresses array
last_name	lastName	high	Explicitly named last_name field containing family names
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Clearly labeled email field containing valid email addresses

Notes: This is a Shopify customer export from the boAt Lifestyle 2024 breach. Address data is nested within an 'addresses' array; each address object contains first_name, last_name, phone, address1, address2, city, province (state), zip, and country. The 'province' field should be mapped to 'state'. Date of birth, SSN, password, username, gender, and name suffix fields are not present in these records. The 'name' field (e.g., 'Stone don') is a concatenation of first and last names and should not be separately mapped.

BoAtLifestyleIndia__data__shopify_customers_partial_15_20240303212650.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes from nested addresses array
country	country	high	Country names from nested addresses array
province	state	high	State/province information from nested addresses array
phone	phone	high	Phone numbers in E.164 format and plain format
address2	address2	high	Secondary address field from nested addresses array
city	city	high	City names from nested addresses array
address1	address1	high	Primary street address from nested addresses array
last_name	lastName	high	Last names present in majority of records
first_name	firstName	high	First names consistently populated
email	email	high	Email addresses present in all records

Notes: Shopify customer data structure. Address details are nested within 'addresses' array and 'default_address' object. The 'province' field maps to state. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state' (account state), 'total_spent', 'verified_email', 'tax_exempt', 'tags', 'currency', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are not PII and should be skipped. No DOB, SSN, password, username, gender, or suffix fields are present in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_15_20240304221434.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/ZIP codes (411060, 401501)
country	country	high	Country field (India)
province	state	high	State/province names (Maharashtra); 'province' is the Shopify term for state
phone	phone	high	Contains phone numbers in international format (+919739051825) and local format (9762953500)
address2	address2	high	Secondary address field within addresses array (e.g., 'Wadachiwadi Road')
city	city	high	City names (Pune, Mumbai)
address1	address1	high	Primary street address field within addresses array
last_name	lastName	high	Contains family names (Goyal, Routray, kumar)
first_name	firstName	high	Contains given names (Sanjeev, Debasis, aravind)
email	email	high	Consistently contains email addresses across all records

Notes: This is a Shopify customer export from the boAt Lifestyle breach. The 'addresses' field is a nested array containing address objects with their own first_name, last_name, address1, address2, city, province, zip, phone, and country fields. The province field maps to 'state' PII type. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state' (account state), 'total_spent', 'verified_email', 'tax_exempt', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are not PII mappings. The 'name' field within addresses is a composite/redundant representation and could map to 'fullName' if needed, but first_name + last_name is the primary decomposed mapping.

BoAtLifestyleIndia__data__shopify_customers_partial_16_20240303214155.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array objects
country	country	high	Country field (India) within addresses array objects
country_code	skip	high	ISO country code; metadata rather than PII field
province	state	high	State/province field (Maharashtra, etc.) within addresses array objects
phone	phone	high	Phone field with international format phone numbers (e.g., +917895621488, 9415999265)
address2	address2	high	Secondary address field within addresses array objects
city	city	high	City/municipality field within addresses array objects
address1	address1	high	Primary street address field within addresses array objects
last_name	lastName	high	Consistently contains surnames or family names; some records show UUIDs (obfuscated data)
province_code	skip	high	State code abbreviation; metadata rather than PII field
first_name	firstName	high	Consistently contains first names or given names; some records show UUIDs (obfuscated data)
email	email	high	Direct email field with valid email addresses present in all records

Notes: Shopify Plus customer export structure. Phone numbers found at top level and within address objects. Address data nested within 'addresses' array and 'default_address' object. Some records contain obfuscated/UUID values for first_name and last_name rather than real names. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state', 'verified_email', 'tax_exempt', 'tags', 'currency', 'email_marketing_consent', 'sms_marketing_consent', 'admin_graphql_api_id', and 'company' are transactional metadata or system fields, not mapped to PII categories.

BoAtLifestyleIndia__data__shopify_customers_partial_16_20240304223337.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field nested in addresses array
total_spent	skip	high	Transaction metadata, not PII
country	country	high	Country field nested in addresses array
address2	address2	high	Secondary address field nested in addresses array
city	city	high	City field nested in addresses array
address1	address1	high	Primary street address field nested in addresses array
last_name	lastName	high	Explicitly named last_name field
created_at	skip	high	Timestamp metadata, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO state/province code, not PII
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Metadata, not PII
province	state	high	State/province field nested in addresses array
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	high	Phone field at customer level (though mostly null, appears in addresses)
name	fullName	high	Combined full name field nested in addresses array
id	skip	high	System identifier, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is Shopify customer export with nested addresses array. Phone numbers appear primarily in the addresses sub-objects rather than at top level. The 'name' field in addresses combines first and last names into fullName. All records are from India (country: 'India'). No SSN, DOB, password, username, gender, or suffix fields present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_17_20240303215748.json

7 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
phone	phone	high	Contains phone numbers in E.164 format (e.g., '+919795977003')
address2	address2	high	In addresses array objects; contains secondary address info or empty
city	city	high	In addresses array objects; contains city names (e.g., 'Rewari')
address1	address1	high	In addresses array objects; contains street addresses (e.g., 'VPO MAJRA GURDAS')
last_name	lastName	medium	Field present but predominantly null in first 50 records; address objects contain last_name values
first_name	firstName	high	Contains first names; note that some records have full names in this field (e.g., 'Tauheed ahmad', 'Gopika Manoj', 'KHEMLAL RAJAK', 'Manish Kumar')
email	email	high	Consistently contains email addresses across all records

Notes: Shopify customer export format. Names often appear as full names in 'first_name' field with 'last_name' null. Address data is nested within 'addresses' array. No DOB, SSN, password, username, gender, or suffix fields detected in provided records. Country context is India (INR currency, +91 phone prefix). Last record appears truncated.

BoAtLifestyleIndia__data__shopify_customers_partial_17_20240304225350.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses object
total_spent	skip	high	Transaction history, not PII
country	country	high	Country field in nested addresses object
address2	address2	high	Secondary/supplementary address field in nested addresses object
city	city	high	City name in nested addresses object
tax_exempt	skip	high	Tax status flag, not PII
address1	address1	high	Primary street address field in nested addresses object
last_name	lastName	high	Consistently contains last names across all records
created_at	skip	high	Timestamp metadata, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	State abbreviation code, not a distinct PII field
country_code	skip	high	ISO country code, not a distinct PII field
orders_count	skip	high	Transaction count, not PII
province	state	high	Province/state field in nested addresses object (Indian states like Uttar Pradesh, Karnataka)
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	high	Contains phone numbers in E.164 format and local formats
currency	skip	high	Transaction currency, not PII
id	skip	high	Internal customer ID, not personal information
state	skip	high	Account state (enabled/disabled), not address state
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is Shopify customer export from boAt Lifestyle breach (March 2024). Address information is nested within 'addresses' array and 'default_address' object; keys map consistently across both nested locations. The 'province' field represents Indian states and should map to 'state'. No DOB, SSN, password, username, gender, middleName, or fullName fields present in sample. The 'name' field in nested objects is a concatenated fullName but redundant with separate first_name/last_name fields.

BoAtLifestyleIndia__data__shopify_customers_partial_18_20240303221412.json

17 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Purchase amount - transactional data, not PII
addresses[].address1	address1	high	Primary street address field within nested address objects
addresses[].name	fullName	high	Full name field within address objects, combines first and last names
addresses[].address2	address2	high	Secondary address/apartment details within nested address objects
last_name	lastName	high	Consistently contains last names across all records (null when not available)
created_at	skip	high	Timestamp - metadata, not PII
addresses[].country	country	high	Country name present in address objects
orders_count	skip	high	Order count - transactional data, not PII
addresses[].province	state	high	State/province field within address objects
updated_at	skip	high	Timestamp - metadata, not PII
phone	phone	high	Contains phone numbers in E.164 format and plain format
addresses[].city	city	high	City name consistently present in address objects
id	skip	high	Customer ID - internal identifier, not PII
state	skip	high	Account state (enabled/disabled) - metadata, not PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Clearly labeled email field containing valid email addresses
addresses[].zip	zip	high	Postal code consistently present in address objects

Notes: Data structure is from Shopify Plus with nested address objects. The 'addresses' field is an array; mapping uses array notation. Phone numbers appear both at top level and within address objects. Full names are reconstructed from first_name/last_name or available in the 'name' field within addresses. Some records have incomplete data (null values for phone or last_name). Default address is also available but uses same field mappings as addresses array.

BoAtLifestyleIndia__data__shopify_customers_partial_18_20240304231424.json

48 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
addresses.phone	phone	high	Phone number within address object
note	skip	high	Internal notes, not PII
last_order_name	skip	high	Order reference, not PII
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Internal identifier, not PII
addresses.company	skip	high	Company field (empty in records shown)
addresses.country_name	skip	high	Country name (redundant with country field)
addresses.address2	address2	high	Secondary address line (apartment, suite, etc.)
addresses.address1	address1	high	Primary street address line
updated_at	skip	high	Timestamp metadata
currency	skip	high	Currency preference, not PII
addresses.country	country	high	Country name field
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state/status, not PII
first_name	firstName	high	Top-level first_name field contains given names
default_address.phone	phone	high	Phone in default address
email	email	high	Top-level email field contains email addresses matching breach context
addresses.province	state	high	State/province field in address (Indian states like Gujarat, Maharashtra)
default_address.address1	address1	high	Primary address in default address object
default_address.country	country	high	Country in default address
total_spent	skip	high	Purchase amount, not PII
addresses.province_code	skip	high	State code (metadata), not PII
default_address.zip	zip	high	Postal code in default address
addresses.last_name	lastName	high	Last name within nested address objects
default_address.address2	address2	high	Secondary address in default address object
last_order_id	skip	high	Order reference, not PII
tax_exempt	skip	high	Tax status, not PII
email_marketing_consent	skip	high	Consent preference, not PII
addresses.customer_id	skip	high	Internal customer ID, not PII
last_name	lastName	high	Top-level last_name field contains family names
addresses.country_code	skip	high	Country code (metadata), not PII
addresses.city	city	high	City name in address
verified_email	skip	high	Email verification flag, not PII
default_address.city	city	high	City in default address
tags	skip	high	Metadata tags, not PII
default_address.last_name	lastName	high	Last name in default address
orders_count	skip	high	Order history count, not PII
sms_marketing_consent	skip	high	Consent preference, not PII
addresses.id	skip	high	Internal address ID, not PII
phone	phone	high	Top-level phone field (currently null in visible records, but present in schema)
default_address.province	state	high	State/province in default address
addresses.name	fullName	high	Full name concatenated in address object
admin_graphql_api_id	skip	high	API identifier, not PII
addresses.first_name	firstName	high	First name within nested address objects
addresses.default	skip	high	Default address flag, not PII
addresses.zip	zip	high	Postal code field
tax_exemptions	skip	high	Tax metadata, not PII
default_address.first_name	firstName	high	First name in default address

Notes: Shopify Plus customer data export structure. Phone numbers appear both at top level (null in shown records) and nested within addresses. Full names available via concatenation of first_name + last_name or via the 'name' field in addresses. State field uses full province names (Gujarat, Maharashtra) rather than abbreviations. All PII fields are present per breach context: email, names, phone numbers, and physical addresses.

BoAtLifestyleIndia__data__shopify_customers_partial_19_20240303223030.json

25 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country name from nested addresses object (India)
city	city	high	City from nested addresses object
created_at	skip	high	Timestamp metadata
province_code	skip	high	State/province code abbreviation, not a distinct PII field
province	state	high	Province/state name from nested addresses object (e.g., Telangana, Maharashtra)
updated_at	skip	high	Timestamp metadata
currency	skip	high	Account setting
company	skip	high	Business metadata, not personal identifier
id	skip	high	Customer ID, internal identifier
state	skip	high	Account state (enabled/disabled), not location
first_name	firstName	high	Shopify standard field for customer first name
email	email	high	Standard email field containing customer email addresses
zip	zip	high	Postal/zip code from nested addresses object
total_spent	skip	high	Purchase history metadata
address2	address2	high	Street address line 2 from nested addresses object, typically null
tax_exempt	skip	high	Account setting flag
address1	address1	high	Street address line 1 from nested addresses object
last_name	lastName	high	Shopify standard field for customer last name
verified_email	skip	high	Boolean flag
tags	skip	high	Metadata tags
country_code	skip	high	ISO country code abbreviation, not a distinct PII field
orders_count	skip	high	Order count metadata
phone	phone	high	Customer phone numbers, sometimes null
admin_graphql_api_id	skip	high	API identifier
name	skip	medium	Redundant with first_name and last_name; present in nested addresses

Notes: This is a Shopify customer export from the boAt Lifestyle breach (March 2024). Address information is nested within an 'addresses' array, with a 'default_address' object repeating the primary address. The 'province' field contains full province/state names. Phone numbers are present at both top-level and within address records. The 'last_name' field sometimes contains only punctuation (e.g., '.') indicating incomplete data entry. No SSN, DOB, password, username, gender, or middle name fields are present in this dataset.

BoAtLifestyleIndia__data__shopify_customers_partial_19_20240304233414.json

17 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses objects
country	country	high	Country field in addresses objects
address2	address2	high	Secondary address line in addresses objects
city	city	high	City field in addresses objects
address1	address1	high	Primary street address line in addresses objects
last_name	lastName	high	Explicitly named last_name field
created_at	skip	high	Timestamp metadata
province_code	skip	high	ISO state code, not a PII field
country_code	skip	high	ISO country code, not a PII field
province	state	high	Province/state field in addresses objects (Indian states like Bihar, Tamil Nadu)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Top-level phone field, though null in many records; phone data present in addresses
name	skip	medium	Redundant with first_name/last_name combination; appears in addresses as computed field
company	skip	high	Company name, not a standard PII field
id	skip	high	Internal database identifier
first_name	firstName	high	Explicitly named first_name field
email	email	high	Top-level email field contains valid email addresses

Notes: Shopify customer export from boAt Lifestyle breach. Customer data spread across top-level fields (email, first_name, last_name, phone) and nested addresses array. Phone numbers consistently present in addresses objects even when top-level phone is null. Province field maps to state (Indian state abbreviations). No sensitive fields like SSN, DOB, password, or username present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_1_20240303175605.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses array; postal code field
country	country	high	Nested in addresses array; country field
province	state	high	Nested in addresses array; state/province field (Indian states like Gujarat)
phone	phone	high	Explicit phone field containing phone numbers with country codes
address2	address2	high	Nested in addresses array; secondary address field (null in records)
city	city	high	Nested in addresses array; city field
address1	address1	high	Nested in addresses array; street address field
last_name	lastName	high	Explicit last_name field containing family names (nullable in some records)
first_name	firstName	high	Explicit first_name field containing given names
email	email	high	Explicit email field containing valid email addresses

Notes: Shopify customer data structure. Address data nested within 'addresses' array and 'default_address' object. No passwords, SSNs, DOB, gender, or suffix fields present in records. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'verified_email', 'state' (account state), 'tags', 'currency', 'tax_exempt', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are metadata/operational fields mapped to skip.

BoAtLifestyleIndia__data__shopify_customers_partial_1_20240304173349.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field from nested addresses objects
country	country	high	Country field from nested addresses objects
province	state	high	Province/state field from nested addresses objects
phone	phone	high	Top-level phone field (null in most records but present in schema)
address2	address2	high	Street address line 2 from nested addresses objects
city	city	high	City field from nested addresses objects
address1	address1	high	Street address line 1 from nested addresses objects
last_name	lastName	high	Explicitly named last_name field
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing valid email addresses

Notes: Phone numbers are nested within the 'addresses' array objects rather than at the top level. The 'name' field (e.g., 'Arjit khanna') represents fullName but is redundant given first_name and last_name are available. Fields like 'id', 'created_at', 'orders_count', 'total_spent', 'state', 'verified_email', 'tags', 'currency', 'country_code', 'province_code', and 'default_address' are metadata/transactional fields and not PII field mappings. The 'country_name' field is skipped as it duplicates the 'country' field.

BoAtLifestyleIndia__data__shopify_customers_partial_20_20240303224618.json

18 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field nested in addresses array
total_spent	skip	high	Financial metadata
country	country	high	Country field nested in addresses array
address2	address2	high	Secondary address line nested in addresses array
city	city	high	City field nested in addresses array
address1	address1	high	Primary address line nested in addresses array
last_name	lastName	high	Explicit last name field
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Boolean flag
tags	skip	high	Internal classification tags
orders_count	skip	high	Order count metadata
province	state	high	Province/state field nested in addresses array (Indian states like Chhattisgarh, Gujarat)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone field at customer root level; also appears in addresses
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (enabled/disabled), not PII
first_name	firstName	high	Explicit first name field
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is Shopify customer export. Phone numbers appear both at root level and nested within address objects. Address data is nested in 'addresses' array and 'default_address' object; both contain the same PII fields. The 'province' field maps to 'state' PII category. Records show consistent Shopify schema with optional fields (some null values present). No password, SSN, username, DOB, gender, or suffix fields are present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_20_20240304235324.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in address objects
country	country	high	Country field in address objects
province	state	high	State/province field in address objects
phone	phone	high	Phone numbers at customer level (when present)
city	city	high	City field in address objects
address2	address2	high	Secondary address line in address objects
address1	address1	high	Primary street address in address objects
last_name	lastName	high	Customer last names consistently populated
first_name	firstName	high	Customer first names consistently populated
email	email	high	Direct email addresses present in all records

Notes: Data structure is nested with customer-level fields (email, phone, first_name, last_name) and address objects containing full address details. The 'addresses' array can contain multiple address entries per customer. No SSN, password, username, DOB, gender, middleName, or suffix fields are present in the provided records. The 'phone' field appears at both customer level and within address objects. The 'name' field in address objects is a composite/fullName but not mapped as it's redundant with first_name + last_name.

BoAtLifestyleIndia__data__shopify_customers_partial_21_20240303230150.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Nested in addresses objects, contains country names
note	skip	high	Internal notes, not PII
addresses	skip	high	Container array; constituent fields already mapped at nested level
last_order_name	skip	high	Order reference, not PII
city	city	high	Nested in addresses objects, contains city names
created_at	skip	high	Timestamp metadata, not PII
multipass_identifier	skip	high	System identifier, not PII
province_code	skip	high	State abbreviation metadata, not PII
default	skip	high	Address flag indicator, not PII
default_address	skip	high	Nested object; constituent fields (address1, city, etc.) already mapped
province	state	high	Nested in addresses objects, contains state/province names (e.g., 'West Bengal')
updated_at	skip	high	Timestamp metadata, not PII
country_name	skip	high	Country name duplicate, not PII
currency	skip	high	Transaction setting, not PII
company	skip	high	Optional business field, not PII
id	skip	high	System identifier, not PII
state	skip	high	Account status field, not PII
first_name	firstName	high	Top-level first_name field contains given names
email	email	high	Top-level email field contains valid email addresses
zip	zip	high	Nested in addresses objects, contains postal codes
total_spent	skip	high	Purchase history metric, not PII
last_order_id	skip	high	Order identifier, not PII
address2	address2	high	Nested in addresses objects, contains secondary address information
tax_exempt	skip	high	Account status, not PII
address1	address1	high	Nested in addresses objects, contains primary street address
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Top-level last_name field contains family names
verified_email	skip	high	Verification flag, not PII
tags	skip	high	Internal classification, not PII
orders_count	skip	high	Order history metric, not PII
country_code	skip	high	Country code metadata, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field contains phone numbers with country codes
admin_graphql_api_id	skip	high	API identifier, not PII
name	skip	high	Derived full name field at address level; firstName/lastName already mapped separately
tax_exemptions	skip	high	Account setting, not PII
customer_id	skip	high	System identifier, not PII

Notes: Shopify customer export from boAt Lifestyle breach. PII fields appear at both top level (email, first_name, last_name, phone) and nested within address objects. The 'name' field at address level is redundant with firstName/lastName decomposition. No dob, ssn, password, username, gender, suffix, or middleName fields present in sample. Country field consistently shows 'India' across records.

BoAtLifestyleIndia__data__shopify_customers_partial_21_20240305001226.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses
total_spent	skip	high	Transaction metadata; not PII
country	country	high	Country field in nested addresses; values like 'India'
address2	address2	high	Secondary address field in nested addresses
city	city	high	City field in nested addresses
address1	address1	high	Street address field in nested addresses; confirmed by breach context
last_name	lastName	high	Explicit last name field; consistent across all records
created_at	skip	high	Timestamp; not PII
verified_email	skip	high	Boolean flag; not PII
province_code	skip	high	State abbreviation code; covered by province field
orders_count	skip	high	Account metadata; not PII
country_code	skip	high	Country code abbreviation; covered by country field
province	state	high	State/province field in nested addresses; India uses provinces/states
updated_at	skip	high	Timestamp; not PII
phone	phone	high	Phone field at top level (though null in many records); also present in nested addresses
name	skip	high	Redundant full name derived from first_name + last_name; already mapped separately
id	skip	high	Internal Shopify customer ID; not PII
state	skip	high	Account status field; not PII
first_name	firstName	high	Explicit first name field; consistent across all records
email	email	high	Direct email field at top level; confirmed by breach context

Notes: Data structure is from Shopify Plus platform. Phone field exists at top level but is null for many records; phone is consistently present in nested 'addresses' objects. Customer names and addresses are nested within an 'addresses' array. The 'province' field maps to 'state' as India uses state designations. No password, SSN, DOB, gender, username, or suffix fields detected in provided records. No honorific titles or name suffixes present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_22_20240303231720.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip codes in nested addresses objects
country	country	high	Country name in nested addresses objects
province	state	high	Province/state information in nested addresses objects
phone	phone	high	Contains phone numbers in E.164 format (+91...) or local format
address2	address2	high	Secondary address field in nested addresses objects (appears null in samples)
city	city	high	City names in nested addresses objects
address1	address1	high	Street address field in nested addresses objects
last_name	lastName	high	Contains last names where available
first_name	firstName	high	Contains first names; occasionally contains full name or email as fallback data
email	email	high	Consistently contains email addresses across all records

Notes: Data structure is Shopify customer export format. Name fields are at top level (first_name, last_name) and repeated within nested 'addresses' array. Address data is nested under 'addresses' array and 'default_address' object. Phone number format varies (E.164 with +91 country code vs. local 10-digit). Some records have data quality issues (e.g., email used as first_name in record 4). The 'province' field maps to state; 'country' appears in both full name and country_code formats. No sensitive fields like SSN, DOB, password, or username are present in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_22_20240305003121.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in address objects
total_spent	skip	high	Order history metadata
country	country	high	Country field in address objects
address2	address2	high	Secondary address line from address objects
city	city	high	City field in address objects
address1	address1	high	Primary street address from address objects
last_name	lastName	high	Shopify customer last name field
created_at	skip	high	System timestamp
verified_email	skip	high	Boolean flag
province_code	skip	high	State abbreviation code
orders_count	skip	high	Order metadata
country_code	skip	high	Country code abbreviation
province	state	high	Province/state field in address objects (Indian states)
updated_at	skip	high	System timestamp
phone	phone	high	Phone numbers in customer record and address objects
country_name	country	medium	Duplicate country information as text
currency	skip	high	Currency indicator
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state flag (disabled/enabled)
first_name	firstName	high	Shopify customer first name field
email	email	high	Direct email addresses present in all records

Notes: Shopify Plus customer export from boAt Lifestyle breach. Customer names often incomplete or placeholder ('not entered', '.'). Phone numbers occasionally in address object rather than top-level phone field. Multiple address records per customer handled at nested level. All PII fields at customer level and default_address level identified.

BoAtLifestyleIndia__data__shopify_customers_partial_23_20240303233248.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from nested addresses array object
country	country	high	Country name (e.g., 'India') from nested addresses array object
country_code	skip	high	ISO country code; redundant with country field
province	state	high	State/province abbreviation (e.g., 'Haryana', 'HR') from nested addresses array object
phone	phone	high	Phone numbers in international format (e.g., +919923241114); null when not provided
address2	address2	high	Secondary address line (e.g., 'Administrative Block') from nested addresses array object
city	city	high	City name from nested addresses array object
address1	address1	high	Primary street address from nested addresses array object
last_name	lastName	high	Contains last names when present; null in some records
province_code	skip	high	State province code abbreviation; redundant with province field
first_name	firstName	high	Contains first names; sometimes includes full name when last_name is null
email	email	high	Standard email field present in all records with valid email addresses

Notes: Addresses are nested within an 'addresses' array object. Extract address fields from the first element of the addresses array or from default_address object when present. The 'first_name' field sometimes contains full names when 'last_name' is null (e.g., 'Khandu kale', 'Suraj Tomar'). Phone field is frequently null. All metadata fields (id, created_at, updated_at, orders_count, state, total_spent, etc.) are mapped to skip as they are transactional/operational data, not PII.

BoAtLifestyleIndia__data__shopify_customers_partial_23_20240305005141.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses array; contains postal codes (632006, 503001)
country	country	high	Nested in addresses array; contains country names (India)
province	state	high	Nested in addresses array; contains state/province names (Tamil Nadu, Telangana)
phone	phone	high	Top-level phone field with international format (e.g., +919087685310)
address2	address2	high	Nested in addresses array; contains secondary address info (e.g., 'Kalinjur')
city	city	high	Nested in addresses array; contains city names (VELLORE, NIZAMABAD)
address1	address1	high	Nested in addresses array; contains primary street address (e.g., 'No 22,gandhi street')
last_name	lastName	high	Consistently contains family names (kanniyappan, Bahwares, sahu, Kapoor)
first_name	firstName	high	Consistently contains given names (ganesh, Mohammed, lukesh, Tej)
email	email	high	Top-level email field with standard email format (e.g., [email protected])

Notes: This is a Shopify customer export from the boAt Lifestyle breach. The data structure includes top-level customer fields and nested address arrays. Phone numbers appear both at top level and within address objects. The 'name' field within addresses is a redundant fullName concatenation and was not mapped separately. No SSN, password, username, DOB, middleName, gender, or suffix fields are present in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_24_20240303234821.json

19 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in nested address objects
total_spent	skip	high	Transaction amount metadata
country	country	high	Country field in nested address objects (India)
address2	address2	high	Secondary address field (locality/neighborhood) in nested address objects
city	city	high	City name in nested address objects
address1	address1	high	Primary street address in nested address objects
last_name	lastName	high	Explicitly labeled last_name in customer records
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Boolean flag metadata
tags	skip	high	Internal tagging/categorization
orders_count	skip	high	Transaction metadata
province	state	high	Province/state field in nested address objects (Indian states like Tamil Nadu)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone numbers at customer level, formatted as +91XXXXXXXXXX
currency	skip	high	Transaction currency metadata
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status flag, not address state
first_name	firstName	high	Explicitly labeled first_name in customer records
email	email	high	Consistent email addresses across all records

Notes: This is a Shopify Plus customer export from the boAt Lifestyle March 2024 breach. Addresses are nested within a top-level 'addresses' array and also duplicated in a 'default_address' object. The 'province' field maps to state; 'province_code' is skip. Phone numbers appear both at customer level and within address objects (may differ). The 'name' field in address objects is a concatenation of first_name and last_name and should be skipped in favor of component fields.

BoAtLifestyleIndia__data__shopify_customers_partial_24_20240305011129.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in standard format
total_spent	skip	high	Purchase history, not PII field type
country	country	high	Country field present (India)
address2	address2	high	Secondary address line in nested addresses array
city	city	high	City consistently present in address objects
address1	address1	high	Primary address line in nested addresses array
last_name	lastName	high	Last names consistently populated across records
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO province code, not a PII field type
country_code	skip	high	ISO country code, not a PII field type
orders_count	skip	high	Metadata, not PII
province	state	high	Indian province/state names (Chhattisgarh, Uttar Pradesh, etc.)
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone field at top level (null in shown records but structured for phone data)
name	skip	high	Concatenated full name field; firstName/lastName already mapped separately
company	skip	high	Company name, not in available PII fields
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (enabled/disabled), not PII
first_name	firstName	high	First names consistently populated across records
email	email	high	Direct email addresses present in all records

Notes: Shopify customer export structure. Phone numbers appear at both top level (null in sample) and within nested address objects. Nested 'addresses' array contains multiple address records per customer; all address subfields map consistently. Province field contains full state names; province_code contains ISO codes. Records show some customers with multiple addresses and different names per address (e.g., record 3 has 'Mayank' and 'Hritik' variants). Country and country_code both present; country_code is metadata only.

BoAtLifestyleIndia__data__shopify_customers_partial_25_20240304000354.json

7 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
phone	phone	high	Contains phone numbers in E.164 format (e.g., +916294933075)
address2	address2	high	Secondary address field within nested addresses array
city	city	high	City field within nested addresses array
address1	address1	high	Street address field within nested addresses array
last_name	lastName	medium	Contains surnames when populated; frequently null in records
first_name	firstName	high	Contains given names; some records have full names concatenated in this field
email	email	high	Standard email field containing valid email addresses

Notes: Breach context confirmed: boAt Lifestyle Shopify Plus store data. Address data is nested within the 'addresses' array objects. Most records show first_name containing either single first names or full names, with last_name frequently null. Phone numbers consistently use +91 country code (India). No password, SSN, DOB, username, or other sensitive credential fields present in sample. No honorific prefixes or generational suffixes observed. Fields like 'id', 'created_at', 'updated_at', 'state', 'orders_count', 'total_spent', 'verified_email', 'currency', 'email_marketing_consent', 'sms_marketing_consent' are metadata/administrative and mapped to skip.

BoAtLifestyleIndia__data__shopify_customers_partial_25_20240305013154.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field from addresses array
note	skip	high	Internal notes, not PII
last_order_name	skip	high	Order reference, not PII
city	city	high	City field from addresses array
created_at	skip	high	Metadata timestamp, not PII
multipass_identifier	skip	high	Internal identifier, not PII
province_code	skip	high	Abbreviation code, not PII
default	skip	high	Boolean flag for default address, not PII
default_address	skip	high	Duplicate address object (already mapped in addresses array)
province	state	high	Province/state field from addresses array (Indian context uses province nomenclature)
updated_at	skip	high	Metadata timestamp, not PII
country_name	skip	high	Duplicate country info, not PII
currency	skip	high	Transaction metadata, not PII
company	skip	high	Null in samples, business metadata if present
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (disabled/invited), not PII
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing valid email addresses
zip	zip	high	Postal code field from addresses array
total_spent	skip	high	Transaction data, not PII
last_order_id	skip	high	Transaction metadata, not PII
address2	address2	high	Secondary address field from addresses array
tax_exempt	skip	high	Account setting, not PII
address1	address1	high	Street address field from addresses array
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Explicitly named last_name field
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Internal categorization, not PII
orders_count	skip	high	Transaction metadata, not PII
country_code	skip	high	Abbreviation code, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field (null in most records but present in schema)
admin_graphql_api_id	skip	high	System identifier, not PII
name	fullName	high	Full name field in addresses array combining first and last names
tax_exemptions	skip	high	Account setting, not PII
customer_id	skip	high	Internal identifier, not PII

Notes: Shopify customer export structure. Phone numbers appear both at top-level (usually null) and within the addresses array objects. When mapping nested address data, extract phone from the address object. The 'name' field in addresses is a concatenation of first_name and last_name. Breach contains 7.5M customer records with email, full names, phone, and physical addresses.

BoAtLifestyleIndia__data__shopify_customers_partial_26_20240304001932.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested within addresses array, contains postal codes (110093, 852201)
country	country	high	Nested within addresses array, contains country names (India)
province	state	high	Nested within addresses array, contains state/province information (Delhi, Bihar)
phone	phone	high	Top-level phone field with phone number values (+919199842789, null entries)
address2	address2	high	Nested within addresses array, contains secondary address information or apartment/locality details
city	city	high	Nested within addresses array, contains city names (New Delhi, SAHARSA)
address1	address1	high	Nested within addresses array, contains primary street addresses
last_name	lastName	high	Explicitly named last_name field containing surnames (Ankush, Mittal, Kumar, or null)
first_name	firstName	high	Explicitly named first_name field containing given names (Ankush, Gulshan Kumar)
email	email	high	Top-level email field with standard email format ([email protected], [email protected])

Notes: This is a Shopify customer export from boAt Lifestyle breach. The data structure includes a top-level customer record with nested 'addresses' array containing multiple address objects. Fields like 'province_code', 'country_code', 'country_name', 'name', 'company', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'verified_email', 'tax_exempt', 'tags', 'state' (account state), 'currency', and marketing consent data are not mapped as they are either metadata, non-PII, or administrative fields. The 'name' field within address objects is a concatenation of first_name and last_name and is not separately mapped.

BoAtLifestyleIndia__data__shopify_customers_partial_26_20240305015127.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested address objects
total_spent	skip	high	Transaction metadata, not PII
country	country	high	Country name field in nested address objects
address2	address2	high	Secondary address line in nested address objects
city	city	high	City field in nested address objects
address1	address1	high	Primary address line in nested address objects
last_name	lastName	high	Explicitly labeled last_name field
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO state/province code, not a distinct PII field
country_code	skip	high	ISO country code, not a distinct PII field
orders_count	skip	high	Transaction metadata, not PII
province	state	high	Province/state field in nested address objects
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone number field at customer root level
name	skip	high	Redundant with first_name + last_name combination
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status flag, not PII
first_name	firstName	high	Explicitly labeled first_name field
email	email	high	Direct email field containing valid email addresses

Notes: Data structure is Shopify customer export with nested address objects. The 'addresses' array contains multiple address records with identical PII field mappings. Customer-level 'phone' field maps to phone PII. Nested address objects contain complete address information (address1, address2, city, province/state, zip, country). No DOB, SSN, password, username, gender, suffix, or middle name fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_27_20240304003549.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses objects
country	country	high	Country field in nested addresses objects
province	state	high	Province/state field in nested addresses objects (Indian administrative divisions)
phone	phone	high	Top-level phone field (though often null, populated in addresses)
address2	address2	high	Secondary address line in nested addresses objects
city	city	high	City field in nested addresses objects
address1	address1	high	Primary address line in nested addresses objects
name	fullName	high	Full name field in nested addresses objects (combines first and last names)
last_name	lastName	high	Top-level last_name field; also appears in addresses
first_name	firstName	high	Top-level first_name field; also appears in addresses
email	email	high	Top-level email field contains email addresses

Notes: This is a Shopify customer export from boAt Lifestyle's March 2024 breach. Customer names and phone numbers primarily appear in nested 'addresses' array objects rather than at the top level. The 'first_name' and 'last_name' fields at the top level are often null, with actual name data in addresses[].first_name and addresses[].name (fullName). Phone numbers similarly appear in addresses[].phone. The 'province' field maps to state. No PII fields for password, username, ssn, dob, gender, middleName, or suffix were identified in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_27_20240305021148.json

39 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in addresses objects
note	skip	high	Internal notes field
addresses	skip	high	Container object (nested fields mapped separately)
last_order_name	skip	high	Order reference
city	city	high	City field in addresses objects
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	System identifier
province_code	skip	high	State code abbreviation
default	skip	high	Address preference flag
default_address	skip	high	Container object (nested fields mapped separately)
province	state	high	Province/state field in addresses objects
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Duplicate country field
currency	skip	high	Transaction currency
company	skip	high	Company name (not standard PII field)
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state flag (enabled/disabled), not address state
first_name	firstName	high	Explicitly labeled first_name field
email	email	high	Explicitly labeled email field containing email addresses
zip	zip	high	Postal code field in addresses objects
total_spent	skip	high	Transaction amount
consent_updated_at	skip	high	Timestamp metadata
last_order_id	skip	high	Order ID metadata
address2	address2	high	Secondary address field in addresses objects
tax_exempt	skip	high	Account flag
address1	address1	high	Street address field in addresses objects
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Explicitly labeled last_name field
verified_email	skip	high	Boolean flag
tags	skip	high	Metadata tags
orders_count	skip	high	Transaction metadata
country_code	skip	high	Country code abbreviation
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Explicitly labeled phone field at customer root level
admin_graphql_api_id	skip	high	System API identifier
name	skip	high	Pre-concatenated name (use first_name/last_name instead)
tax_exemptions	skip	high	Metadata array
customer_id	skip	high	Internal customer ID
opt_in_level	skip	high	Consent preference

Notes: Shopify customer export from boAt Lifestyle breach. Phone number appears in two locations: at root level (typically null) and nested within address objects (populated). Map nested address.phone to phone field. The 'province' field contains Indian state names and should map to state. All records follow consistent Shopify Plus export schema.

BoAtLifestyleIndia__data__shopify_customers_partial_28_20240304005220.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses objects
total_spent	skip	high	Transaction metadata
country	country	high	Country name field (all 'India' in these records)
address2	address2	high	Secondary address field (apartment, building, etc.) in nested addresses objects
city	city	high	City names consistently present in addresses objects
address1	address1	high	Primary street address field found in nested addresses objects
last_name	lastName	high	Consistently contains last names across records (though some null)
created_at	skip	high	Metadata timestamp
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO state/province code, not PII mapping needed
tags	skip	high	Internal tagging system
country_code	skip	high	ISO country code, not PII mapping needed
orders_count	skip	high	Transaction metadata, not PII
province	state	high	Province/state field in addresses objects (e.g., 'Delhi', 'Uttarakhand')
updated_at	skip	high	Metadata timestamp
phone	phone	high	Top-level phone field with phone numbers in E.164 format or local format
id	skip	high	Internal database identifier, not PII
state	skip	high	Account state (enabled/disabled), not PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Standard email field present in all records with valid email addresses

Notes: Shopify customer data from boAt Lifestyle breach (March 2024). Phone numbers appear both at top level and nested within addresses objects with consistent formatting. Address data is nested within 'addresses' array and 'default_address' object. The 'name' field within address objects appears to be a concatenated fullName but is redundant given separate first_name/last_name fields. No SSN, DOB, password, username, gender, or suffix fields are present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_28_20240305023133.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in nested address objects
country	country	high	Country field in nested address objects
province	state	high	State/province field in nested address objects (Delhi, Rajasthan, Haryana)
phone	phone	high	Top-level phone field; also appears in nested address objects
address2	address2	high	Secondary address line in nested address objects
city	city	high	City names in nested address objects (Delhi NCR, AJMER, SONIPAT)
address1	address1	high	Primary address line in nested address objects
name	skip	high	Redundant composite field derived from first_name and last_name already mapped
last_name	lastName	high	Consistently contains last names (Gupta, Singh, chouhan, Deswal)
first_name	firstName	high	Consistently contains first names (Deepa, Payal, Rahul, Ashish)
email	email	high	Top-level email field present in all records with standard email format

Notes: Data structure is Shopify customer export with nested address objects. Top-level phone field is null in all shown records; phone data appears only in nested addresses array and default_address object. The 'name' field in addresses is a redundant composite already captured by first_name and last_name mappings. No PII fields for dob, ssn, password, username, middleName, gender, or suffix are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_29_20240304011229.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array objects
country	country	high	Country field within addresses array objects
country_code	skip	high	ISO country code, not a PII field mapping
province	state	high	Province/state field within addresses array objects (Indian states like Delhi, Chandigarh)
phone	phone	high	Phone numbers in international format (+91 country code for India)
address2	address2	high	Secondary address field within addresses array objects
city	city	high	City field within addresses array objects
address1	address1	high	Street address field within addresses array objects
last_name	lastName	high	Top-level last name field present in all records
province_code	skip	high	ISO province code, not a PII field mapping
first_name	firstName	high	Top-level first name field present in all records
email	email	high	Consistent email addresses across all records matching breach context

Notes: Shopify Plus customer export structure. PII fields located at top level (email, first_name, last_name, phone) and nested within addresses array (address1, address2, city, province, zip, country). The 'name' field within addresses is a concatenated fullName but first_name/last_name are preferred as separate fields. No SSN, DOB, username, password, gender, suffix, or middleName fields present in sample. The province field maps to state PII category.

BoAtLifestyleIndia__data__shopify_customers_partial_29_20240305025104.json

28 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested addresses array
city	city	high	City field in nested addresses array
created_at	skip	high	Timestamp metadata
province_code	skip	high	Abbreviated state code
default	skip	high	Default address flag
province	state	high	State/province field in nested addresses array (Shopify uses 'province' for state)
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Country name redundant with country field
currency	skip	high	Currency metadata
company	skip	high	Business/company field, not personal PII
id	skip	high	Internal system ID, not PII
state	skip	high	Account status field, not address state
first_name	firstName	high	Explicit first name field
email	email	high	Explicit email field containing customer email addresses
zip	zip	high	Postal code field in nested addresses array
total_spent	skip	high	Order history/transaction data
address2	address2	high	Secondary address line in nested addresses array
tax_exempt	skip	high	Tax status flag
address1	address1	high	Primary address line in nested addresses array
email_marketing_consent	skip	high	Consent/preference data
last_name	lastName	high	Explicit last name field
verified_email	skip	high	Verification status flag
tags	skip	high	Merchant tags/labels
orders_count	skip	high	Order count metadata
country_code	skip	high	ISO country code
sms_marketing_consent	skip	high	Consent/preference data
phone	phone	high	Phone field at root level (though mostly null in sample, populated in address objects)
name	fullName	high	Full name field present in nested addresses array

Notes: Data structure follows Shopify customer schema. Address information is nested within 'addresses' array and 'default_address' object. The 'province' field represents state/region. Phone field at root level is mostly null; phone data is present in nested address objects. Full name concatenation available in 'name' field within addresses. No DOB, SSN, username, password, gender, or middle name fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_2_20240303180902.json

4 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
last_name	lastName	medium	Contains surname/family name when populated (e.g., 'Reddy'); mostly null in sample
first_name	fullName	medium	Contains full names (e.g., 'Dhananjay Singh Markam', 'MEHER NAIDU', 'Atul Ahir', 'G Lakshmi Narayana') when last_name is null; when last_name is populated, first_name contains given name(s)
phone	phone	high	Contains phone numbers in Indian format (e.g., '+918738975268', '+919399158875')
email	email	high	Consistently contains valid email addresses across all records

Notes: This is Shopify customer export data. The 'first_name' field requires context-dependent mapping: when 'last_name' is null, treat 'first_name' as fullName; when 'last_name' is populated, treat 'first_name' as firstName. The 'addresses' array is present but empty in all 50 records shown. Fields 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'total_spent', 'verified_email', 'tax_exempt', 'tags', and 'admin_graphql_api_id' are non-PII metadata and should be skipped. No DOB, SSN, password, username, address, city, state, zip, country, gender, or suffix data present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_2_20240304175421.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested within addresses and default_address objects; contains postal codes (342306, 380007, 422103)
country	country	high	Nested within addresses and default_address objects; contains country name (India) and country_code (IN)
province	state	high	Nested within addresses and default_address objects; contains Indian state names (Rajasthan, Gujarat, Maharashtra)
phone	phone	high	Top-level phone field; when null, phone numbers are found in nested addresses.phone (9660221091, 7878435353, 9730332846)
address2	address2	high	Nested within addresses and default_address objects; secondary address line (all null in sample)
city	city	high	Nested within addresses and default_address objects; contains city names (Jodhpur, Ahmedabad, NASHIK)
address1	address1	high	Nested within addresses and default_address objects; contains street addresses (vaishnav colony beenj wariya jodhpur, etc.)
last_name	lastName	high	Top-level last_name field contains family names (Das, Parekh, Dholi)
first_name	firstName	high	Top-level first_name field contains given names (Kishan, Krushnakant, Ravi)
email	email	high	Top-level email field contains email addresses ([email protected], [email protected], etc.)

Notes: Data structure has customer info at top level and nested address objects. The 'phone' field at top level is consistently null; actual phone numbers are found only within the nested 'addresses' and 'default_address' objects. The 'province' field maps to state. Fields like 'id', 'created_at', 'orders_count', 'total_spent', 'currency', 'state' (account state), 'verified_email', 'tax_exempt', 'tags', 'name' (full name concatenation), 'company', 'province_code', 'country_code', 'country_name', 'default', and various consent/administrative fields are not PII field mappings. No SSN, DOB, password, username, gender, middle name, or suffix data present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_30_20240304013129.json

34 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested address objects
note	skip	high	Internal notes field
last_order_name	skip	high	Order reference number
city	city	high	City names in nested address objects
created_at	skip	high	Metadata timestamp
multipass_identifier	skip	high	Internal Shopify identifier
province_code	skip	high	State code abbreviation
default	skip	high	Boolean flag for default address
province	state	high	Indian state/province names in nested address objects
updated_at	skip	high	Metadata timestamp
country_name	skip	high	Duplicate country field
currency	skip	high	Currency code
company	skip	high	Business entity (null in samples)
id	skip	high	Internal database identifier, not PII
state	skip	high	Account status flag ('disabled'), not geographic state
first_name	firstName	high	Customer first names consistently populated
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal codes in nested address objects
total_spent	skip	high	Transaction amount metadata
last_order_id	skip	high	Order identifier
address2	address2	high	Secondary address field in nested address objects (null in provided samples)
tax_exempt	skip	high	Boolean flag
address1	address1	high	Street addresses in nested address objects
email_marketing_consent	skip	high	Consent metadata object
last_name	lastName	high	Customer last names consistently populated
verified_email	skip	high	Boolean flag
tags	skip	high	Internal categorization
orders_count	skip	high	Transaction metadata
country_code	skip	high	Country code abbreviation
sms_marketing_consent	skip	high	Consent metadata object
phone	phone	medium	Phone field at top level is null in provided records, but phone data exists in nested addresses
admin_graphql_api_id	skip	high	Internal API identifier
name	skip	high	Composite full name (firstName + lastName already mapped separately)
tax_exemptions	skip	high	Tax status array

Notes: Data structure contains nested 'addresses' array with address details. Phone number appears in nested address objects rather than top-level phone field. The 'state' field at top level refers to account status ('disabled'), not geographic location; actual state/province data is in nested addresses. Shopify Plus customer export format with addresses array containing full address information per customer.

BoAtLifestyleIndia__data__shopify_customers_partial_30_20240305031038.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array
country	country	high	Country field in addresses array
province	state	high	State/province field in addresses array
phone	phone	high	Phone field at customer level (though mostly null, populated in address records)
address2	address2	high	Secondary address field in addresses array
city	city	high	City field in addresses array
address1	address1	high	Street address field in addresses array
last_name	lastName	high	Explicit last name field
first_name	firstName	high	Explicit first name field
email	email	high	Direct email field present in all records

Notes: Data structure is Shopify customer export format. Address information (address1, address2, city, province, zip, country, phone) is nested within 'addresses' array and 'default_address' object. Phone number appears at both customer level (usually null) and within address records (populated). The 'name' field in addresses is a concatenation of first_name and last_name. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state' (account status), 'verified_email', 'tax_exempt', and 'admin_graphql_api_id' are operational/metadata and mapped to 'skip'. Email marketing consent information is present but mapped to 'skip' as it is not PII classification field.

BoAtLifestyleIndia__data__shopify_customers_partial_31_20240304014801.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array objects
country	country	high	Country field (India) in addresses array objects
province	state	high	Indian states/provinces (Uttarakhand, etc.) map to state field
phone	phone	high	Phone field with international format (+91 country codes)
address2	address2	high	Secondary address line in addresses array objects
city	city	high	City field in addresses array objects
address1	address1	high	Primary address line in addresses array objects
last_name	lastName	high	Explicitly labeled last_name field
first_name	firstName	high	Explicitly labeled first_name field
email	email	high	Standard email field containing valid email addresses

Notes: Shopify customer data structure from boat Lifestyle breach. The 'addresses' field is an array containing nested address objects with full address components. 'province' and 'province_code' represent Indian states and map to the 'state' field. 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state' (account state), 'verified_email', 'currency', 'tags', 'email_marketing_consent', 'sms_marketing_consent', 'admin_graphql_api_id', and 'default_address' are metadata/operational fields and map to 'skip'. No SSN, DOB, password, username, gender, middleName, suffix, or honorific prefix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_31_20240305033018.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in address objects
country	country	high	Country field in address objects
province	state	high	Province/state field in address objects (Indian states like Uttar Pradesh, Maharashtra)
phone	phone	high	Top-level phone field (mostly null); phone data present in address objects
address2	address2	high	Secondary address field in address objects
city	city	high	City field in address objects
address1	address1	high	Street address field in address objects
name	fullName	high	Full name field in address objects (concatenated first and last name)
last_name	lastName	high	Explicitly labeled last_name field containing surnames
first_name	firstName	high	Explicitly labeled first_name field containing given names
email	email	high	Consistently contains email addresses across all records

Notes: Data is from nested address objects within customer records. Phone numbers appear both at top-level (mostly null) and within address objects. The 'name' field in address objects contains full names (e.g., 'Raj Pal Singh'). Province field maps to state (Indian context). No SSN, DOB, password, username, gender, or suffix fields present in sample. Country is consistently 'India' with country_code 'IN'.

BoAtLifestyleIndia__data__shopify_customers_partial_32_20240304020416.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country names from nested addresses array (all 'India' in sample)
note	skip	high	Internal notes field
addresses	skip	high	Container array; individual fields within are mapped separately
last_order_name	skip	high	Transaction reference
city	city	high	City names from nested addresses array
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Shopify internal identifier
province_code	skip	high	ISO province code, not PII field type
default	skip	high	Boolean flag for default address
default_address	skip	high	Container object; individual fields within are mapped separately
province	state	high	Province/state names (e.g., 'Bihar', 'Uttar Pradesh') from nested addresses array
updated_at	skip	high	Timestamp metadata
currency	skip	high	Metadata
company	skip	high	Business entity, not personal PII
id	skip	high	Internal customer ID, not PII field type
state	skip	high	Account state (enabled/disabled), not address state
first_name	firstName	high	Contains first names; some records show full first name (e.g., 'Prakash Mili', 'Sudhir Kumar')
email	email	high	Consistently populated email addresses across all records
zip	zip	high	Postal codes from nested addresses array
total_spent	skip	high	Financial metadata
last_order_id	skip	high	Transaction metadata
address2	address2	high	Secondary address line from nested addresses array (often empty/null)
tax_exempt	skip	high	Boolean flag metadata
address1	address1	high	Primary street address from nested addresses array
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Contains last names or null; paired with first_name for full name
verified_email	skip	high	Boolean flag metadata
tags	skip	high	Internal categorization
country_code	skip	high	ISO country code, not PII field type
orders_count	skip	high	Transaction metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Phone numbers in international format (e.g., '+919678572468') or numeric (e.g., '9608111197')
admin_graphql_api_id	skip	high	Shopify internal API identifier
name	skip	medium	Denormalized full name from address; use first_name + last_name instead
tax_exemptions	skip	high	Empty metadata array
customer_id	skip	high	Internal identifier

Notes: Shopify customer export from boAt Lifestyle breach (March 2024). Address data nested within 'addresses' array and duplicated in 'default_address' object. Field 'province' maps to state/province. Phone numbers in addresses array may differ from top-level phone field. Some records have null values for first_name, last_name, phone, or address data. The 'state' field at top level refers to account state (enabled/disabled), not geographic location—do not confuse with address province.

BoAtLifestyleIndia__data__shopify_customers_partial_32_20240305034919.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses array - postal code (e.g., '382870', '641114')
country	country	high	Nested in addresses array - country field (e.g., 'India')
province	state	high	Nested in addresses array - state/province field (e.g., 'Gujarat', 'Tamil Nadu')
phone	phone	medium	Top-level phone field, mostly null but structure present for phone numbers
address2	address2	high	Nested in addresses array - secondary address field (e.g., 'balyomadh')
city	city	high	Nested in addresses array - city field (e.g., 'Vijapur(Mehsana)', 'COIMBATORE')
address1	address1	high	Nested in addresses array - primary street address (e.g., '54,Shree krusanagar Society vijapur')
last_name	lastName	high	Top-level last_name field with surnames (patel, Singh)
phone (nested)	phone	high	Nested in addresses array - phone number within address objects (e.g., '99136 22426', '7710694495')
first_name	firstName	high	Top-level first_name field with given names (kalp, Joshwin, Abhishek)
email	email	high	Top-level email field containing email addresses like [email protected]

Notes: Data structure is Shopify customer export format. Top-level contains customer summary; nested 'addresses' array contains detailed address records with address-specific phone numbers. The 'province' field maps to state. The 'country_code' and 'country_name' are informational but 'country' contains the full name. No password, ssn, dob, username, gender, or suffix fields present in provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_33_20240304022148.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes within nested addresses objects (e.g., '413512', '413518')
country	country	high	Country names within nested addresses objects (e.g., 'India')
province	state	high	State/province field within nested addresses objects (e.g., 'Maharashtra')
phone	phone	high	Phone numbers in E.164 format with country code (e.g., +917084479949)
address2	address2	high	Secondary address line within nested addresses objects (e.g., 'Near Junior shahu college Basweshwar chowk')
city	city	high	City names within nested addresses objects (e.g., 'LATUR', 'Latur')
address1	address1	high	Primary street address within nested addresses objects (e.g., 'Swami vivekanand hostel Basweshwar chowk latur')
last_name	lastName	high	Contains surnames or null when name is in first_name field (e.g., 'Javle')
first_name	firstName	high	Contains first names or full names in first position (e.g., 'Harsh', 'Mohammad Javed Ali', 'Ayush')
email	email	high	Standard email field with valid email addresses (e.g., [email protected])

Notes: Shopify customer data structure. Address data is nested within 'addresses' array and 'default_address' object. Names sometimes combined in first_name field with last_name as null. Phone numbers include country code prefix. No password, username, SSN, DOB, gender, or suffix fields present in provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_33_20240305040913.json

39 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
note	skip	high	Internal notes field
addresses[].address1	address1	high	Primary street address in nested addresses array
addresses[].address2	address2	high	Secondary address field in nested addresses array
addresses[].phone	phone	high	Phone number at address level
created_at	skip	high	Timestamp metadata
province_code	skip	high	State abbreviation code metadata
addresses[].first_name	firstName	high	First name within address objects
default	skip	high	Boolean flag for default address
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Redundant country name field
currency	skip	high	Currency code metadata
company	skip	high	Company name (optional, not core PII for consumer records)
id	skip	high	Customer ID - non-PII identifier
state	skip	high	Account status, not geographic state
first_name	firstName	high	Customer first names consistently present
default_address.phone	phone	high	Phone number in default address
email	email	high	Direct email addresses present in all records
default_address.address1	address1	high	Primary street address in default address
default_address.country	country	high	Country in default address
total_spent	skip	high	Transaction amount metadata
default_address.zip	zip	high	Postal code in default address
default_address.address2	address2	high	Secondary address in default address
tax_exempt	skip	high	Boolean flag metadata
last_name	lastName	high	Customer last names consistently present
verified_email	skip	high	Boolean flag metadata
addresses[].country	country	high	Country in nested addresses array
default_address.city	city	high	City in default address
tags	skip	high	Customer tags/labels
default_address.last_name	lastName	high	Last name in default address object
orders_count	skip	high	Transaction count metadata
country_code	skip	high	Country code metadata
addresses[].province	state	high	State/province in nested addresses array
phone	phone	high	Phone numbers at customer level (when present)
default_address.province	state	high	State/province in default address
name	skip	high	Denormalized full name (prefer separate first/last)
addresses[].city	city	high	City in nested addresses array
addresses[].last_name	lastName	high	Last name within address objects
default_address.first_name	firstName	high	First name in default address object
addresses[].zip	zip	high	Postal code in nested addresses array

Notes: Shopify customer export structure with nested address objects. Phone numbers appear at both customer and address levels. The 'addresses' array is nested; extraction should flatten or preserve hierarchy depending on target schema. All PII fields identified per breach context (emails, names, phones, addresses). Records include optional fields like 'phone' at customer level (often null) with redundant data in nested structures.

BoAtLifestyleIndia__data__shopify_customers_partial_34_20240304023835.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested address objects
note	skip	high	Administrative notes; not PII
addresses	skip	high	Container object; individual fields mapped separately
last_order_name	skip	high	Order reference; not PII
city	city	high	City field in nested address objects
created_at	skip	high	Timestamp metadata; not PII
multipass_identifier	skip	high	Shopify internal identifier; not PII
province_code	skip	high	State code abbreviation; redundant with province
default	skip	high	Boolean flag for default address; not PII
default_address	skip	high	Container object; individual fields mapped separately
province	state	high	State/province field in nested address objects; maps to state PII field
updated_at	skip	high	Timestamp metadata; not PII
country_name	skip	high	Country name (duplicate); redundant with country field
currency	skip	high	Currency code; not PII
company	skip	high	Business entity; not consumer PII
id	skip	high	Internal database/customer ID; not PII
state	skip	high	Account state (enabled/disabled); not PII
first_name	firstName	high	Consistently populated customer first names
email	email	high	Top-level email field present in all records; verified by breach context
zip	zip	high	Postal code in nested address objects
total_spent	skip	high	Transactional data; not PII
last_order_id	skip	high	Order metadata; not PII
address2	address2	high	Secondary address line (apt/suite) in nested address objects
tax_exempt	skip	high	Tax status flag; not PII
address1	address1	high	Primary street address in nested address objects
email_marketing_consent	skip	high	Consent metadata; not PII
last_name	lastName	high	Consistently populated customer last names
verified_email	skip	high	Boolean flag; not PII
tags	skip	high	Categorical metadata; not PII
orders_count	skip	high	Transactional metadata; not PII
country_code	skip	high	Country code abbreviation; redundant with country
sms_marketing_consent	skip	high	Consent metadata; not PII
phone	phone	high	Top-level phone field; also appears in nested address objects
admin_graphql_api_id	skip	high	Shopify API identifier; not PII
name	skip	medium	Derived fullName in nested objects; firstName/lastName already captured separately
tax_exemptions	skip	high	Tax metadata; not PII
customer_id	skip	high	Internal reference ID; not PII

Notes: Shopify customer export from boAt Lifestyle breach (March 2024). Phone numbers appear in both top-level and nested address objects. Address data is nested within 'addresses' array and 'default_address' object. Province field contains state names (e.g., 'Maharashtra', 'Delhi', 'Rajasthan'). No SSN, DOB, password, username, gender, suffix, middleName, or honorific title fields present in sample. The 'name' field in address objects is a concatenation of first_name + last_name and is redundant.

BoAtLifestyleIndia__data__shopify_customers_partial_34_20240305042843.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses array, contains postal codes (e.g., 201301, 560107)
province	state	high	Nested in addresses array, contains state/province names (e.g., Uttar Pradesh, Karnataka)
phone	phone	medium	Field labeled 'phone' at top level is consistently null; however, 'phone' field appears in addresses nested objects with actual phone values (e.g., 6395921070)
address2	address2	high	Nested in addresses array, secondary address field (consistently null in sample)
city	city	high	Nested in addresses array, contains city names (e.g., GAUTAM BUDDHA NAGAR, BANGALORE)
address1	address1	high	Nested in addresses array, contains street addresses (e.g., 'Third floor, castleton outsource ltd, D5, logix infotech park, noida sector 59')
country_name	country	high	Nested in addresses array, contains country name (India for all records in sample)
last_name	lastName	high	Explicitly labeled 'last_name' field containing surnames (e.g., kumar, Gupta, Islam)
first_name	firstName	high	Explicitly labeled 'first_name' field containing given names (e.g., Nishant, Prashant, Faruk)
email	email	high	Explicitly labeled 'email' field containing email addresses (e.g., [email protected])

Notes: This is a Shopify customer export from the boAt Lifestyle March 2024 breach. Phone numbers appear only within the nested 'addresses' array objects, not at the top level. The 'name' field in addresses is a concatenation of first_name and last_name and should not be separately mapped. Fields 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'verified_email', 'tax_exempt', 'tags', 'currency', and other metadata fields should be mapped to 'skip'. The 'province' field maps to 'state'. No DOB, SSN, password, username, gender, middle name, or suffix fields are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_35_20240304025524.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (470002, 388001)
country	country	high	Country name (India)
province	state	high	State/province field (Madhya Pradesh, Gujarat)
phone	phone	high	Phone numbers in international format (+919098667232)
address2	address2	high	Secondary address line (nested in addresses array)
city	city	high	City names (Sagar, ANAND)
address1	address1	high	Primary street address (nested in addresses array and default_address)
last_name	lastName	high	Contains last names (Patel, etc.) or null when full name in first_name
first_name	firstName	high	Contains first names (Vijendra Ahirwar, Zaid Abdullah, Ankit)
email	email	high	Standard email field containing email addresses like [email protected]

Notes: Data structure is Shopify customer export from boAt Lifestyle breach. Names sometimes appear combined in first_name field (e.g., 'Vijendra Ahirwar' as first_name with null last_name). Address data is nested within 'addresses' array and duplicated in 'default_address' object. Phone numbers stored with country code (+91 for India). No SSN, DOB, password, username, gender, or suffix fields present in sample. No honorific prefixes or generational suffixes observed.

BoAtLifestyleIndia__data__shopify_customers_partial_35_20240305044627.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip code found in nested address objects
country	country	high	Country field in nested address objects
province	state	high	Geographic state/province found in nested address objects (e.g., 'Uttar Pradesh', 'Maharashtra')
phone	phone	high	Phone field at top level, though often null; phone data found in nested address objects
address2	address2	high	Secondary address line found in nested address objects
city	city	high	City field in nested address objects
address1	address1	high	Primary street address found in nested address objects
name	skip	medium	Redundant composite field (first_name + last_name already mapped separately); present in nested address objects
last_name	lastName	high	Explicitly named last_name field containing family names
state	skip	high	Top-level 'state' field contains account status (enabled/disabled), not geographic state; geographic state data in 'province' field
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field consistently populated with valid email addresses across all records

Notes: Data structure is Shopify customer export format. Top-level phone field is frequently null; actual phone numbers are found in nested 'addresses' array objects. Geographic location data (state, city, zip, country) is nested within address objects rather than at top level. The 'state' field at top level refers to account status, not geographic state. All nested address fields should be extracted with same mapping logic as top-level equivalents when present. Breach context confirms this is boAt Lifestyle 2024 Shopify customer data.

BoAtLifestyleIndia__data__shopify_customers_partial_36_20240304031216.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field from nested address objects
country	country	high	Country name field from nested address objects
province	state	high	Province/state field from nested address objects
phone	phone	high	Phone numbers in E.164 format and standard format
address2	address2	high	Secondary address line (apartment, building, etc.) from nested address objects
city	city	high	City field from nested address objects
address1	address1	high	Primary street address field from nested address objects
last_name	lastName	high	Explicitly named last_name field containing surnames
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field with valid email addresses

Notes: Shopify customer export structure. Address data nested within 'addresses' array and 'default_address' object; extract from either location. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'total_spent', 'verified_email', 'tags', 'currency', 'country_code', 'province_code', 'company', 'default', 'admin_graphql_api_id', and 'email_marketing_consent' are not PII fields and should be skipped. No DOB, SSN, password, username, middleName, fullName, gender, or suffix data present in provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_36_20240305050446.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in addresses array
note	skip	high	Administrative notes, not PII
addresses	skip	high	Container object; individual fields mapped separately
last_order_name	skip	high	Order number, not PII
city	city	high	City field in addresses array
created_at	skip	high	Timestamp, not PII
multipass_identifier	skip	high	Shopify identifier, not PII
province_code	skip	high	ISO state code, not PII mapping needed
default	skip	high	Boolean flag for default address, not PII
default_address	skip	high	Container object; individual fields already mapped
province	state	high	Province/state field (Indian states like Delhi, Jharkhand, Tamil Nadu)
updated_at	skip	high	Timestamp, not PII
currency	skip	high	Currency code, not PII
company	skip	high	Company name, not personal PII
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (enabled/disabled), not PII
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field containing valid email addresses
zip	zip	high	Postal code field in addresses array
total_spent	skip	high	Purchase history, not PII
last_order_id	skip	high	Transaction ID, not PII
address2	address2	high	Secondary address line (apartment, suite, etc.)
tax_exempt	skip	high	Tax status, not PII
address1	address1	high	Primary street address field in addresses array
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Explicitly named last_name field containing family names
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Merchant tags, not PII
country_code	skip	high	ISO country code (IN), not PII mapping needed
orders_count	skip	high	Order count, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Phone field at customer level containing phone numbers
admin_graphql_api_id	skip	high	API identifier, not PII
name	skip	high	Full name string (redundant with first_name + last_name already mapped)
tax_exemptions	skip	high	Array of tax exemptions, not PII
customer_id	skip	high	Internal ID, not PII

Notes: This is a Shopify Plus customer export from the boAt Lifestyle breach (March 2024). The structure includes nested address objects with duplicate information. Fields like 'name' (full name string) are redundant with separately mapped first_name/last_name fields and should be skipped to avoid duplication. All addresses have consistent field naming (address1, address2, city, province/state, zip, country). The 'province' field maps to 'state' as it contains Indian state names. No SSN, DOB, username, password, gender, middleName, or suffix fields are present in the dataset.

BoAtLifestyleIndia__data__shopify_customers_partial_37_20240304032911.json

13 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field (122001, 110092)
country	country	high	Country field (India)
address2	address2	high	Secondary address field (nested in addresses array and default_address)
city	city	high	City name field (GURGAON, EAST DELHI)
address1	address1	high	Primary street address field (nested in addresses array and default_address)
last_name	lastName	high	Consistently contains last names (KHAN, KUMAR, Chauhan)
province_code	skip	high	ISO state code (HR, DL) - administrative field, not PII mapping needed
country_code	skip	high	ISO country code (IN) - administrative field, not PII mapping needed
province	state	high	State/province field (Haryana, Delhi)
phone	phone	high	Contains phone numbers in international format (+919034476907) and local format (78772 40272)
name	fullName	high	Full name field in addresses (SOHIL KHAN, SANJAY KUMAR)
first_name	firstName	high	Consistently contains first names (Himanshu, SOHIL, SANJAY, Rinkal)
email	email	high	Standard email field containing email addresses like [email protected]

Notes: Data structure shows Shopify customer export with nested address objects. Address data appears both at root level (addresses array) and in default_address object. Phone field at root level can be null, but phone is reliably present in address objects. Province field represents Indian states. No SSN, DOB, password, username, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_37_20240305052646.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested within addresses objects; postal code
country	country	high	Nested within addresses objects; country name
province	state	high	Nested within addresses objects; Indian state/province (maps to state field)
phone	phone	high	Top-level phone field (null in most records shown, but present in nested addresses)
address2	address2	high	Nested within addresses objects; secondary address information
city	city	high	Nested within addresses objects; city name
address1	address1	high	Nested within addresses objects; primary street address
name	fullName	medium	Nested within addresses objects; contains concatenated full name
last_name	lastName	high	Top-level last_name field with customer last names
first_name	firstName	high	Top-level first_name field with customer first names
email	email	high	Top-level email field containing standard email addresses

Notes: Data structure is a Shopify customer export with nested address objects. Phone numbers appear both at top level (null) and nested within address objects. The 'name' field in addresses is a concatenated full name (firstName + lastName). The 'province' field represents Indian states and maps to the state PII field. The 'country_code' field (e.g., 'IN') and 'province_code' field are administrative identifiers and mapped to skip. Fields like 'id', 'customer_id', 'created_at', 'orders_count', 'state' (enabled/disabled), 'total_spent', and email marketing consent metadata are not PII and mapped to skip.

BoAtLifestyleIndia__data__shopify_customers_partial_38_20240304034627.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country name (nested in addresses array)
note	skip	high	Internal notes - not PII
last_order_name	skip	high	Transaction reference - not PII
city	city	high	City name (nested in addresses array)
created_at	skip	high	Timestamp - not PII
multipass_identifier	skip	high	System identifier - not PII
province_code	skip	high	State code abbreviation - covered by province field
default	skip	high	Boolean flag - not PII
default_address	skip	high	Pointer field - actual address data in addresses array
province	state	high	State/province field (nested in addresses array)
updated_at	skip	high	Timestamp - not PII
country_name	skip	high	Duplicate of country field
currency	skip	high	Currency code - not PII
company	skip	high	Company name - not personal PII per standard definitions
id	skip	high	Customer ID - system identifier, not PII
state	skip	high	Account state - not PII
first_name	firstName	high	Customer first name field
email	email	high	Standard email field containing customer email addresses
zip	zip	high	Postal code (nested in addresses array)
total_spent	skip	high	Financial transaction data - not PII
last_order_id	skip	high	Transaction ID - not PII
address2	address2	high	Secondary address line (nested in addresses array)
tax_exempt	skip	high	Account flag - not PII
address1	address1	high	Primary street address (nested in addresses array)
email_marketing_consent	skip	high	Consent data - not PII
last_name	lastName	high	Customer last name field
verified_email	skip	high	Boolean flag - not PII
tags	skip	high	Internal tags - not PII
orders_count	skip	high	Transactional data - not PII
country_code	skip	high	Country code - covered by country field
sms_marketing_consent	skip	high	Consent data - not PII
phone	phone	high	Customer phone number field at top level
admin_graphql_api_id	skip	high	System identifier - not PII
name	skip	high	Concatenated full name - covered by separate first_name/last_name fields
tax_exemptions	skip	high	Account settings - not PII
customer_id	skip	high	System identifier - not PII

Notes: Shopify Plus store export format. Address fields are nested within 'addresses' array objects and 'default_address' object. Phone number appears both at top level (may be null) and nested in address objects. The 'first_name' field sometimes contains full names (e.g., 'MAYURI RAJENDRA'), but separate firstName/lastName mapping applied consistently. All system identifiers, timestamps, transactional data, and consent flags mapped to 'skip'.

BoAtLifestyleIndia__data__shopify_customers_partial_38_20240305054353.json

34 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field from addresses array
note	skip	high	Internal notes
addresses	skip	high	Container array; extract individual fields instead
last_order_name	skip	high	Transaction reference
city	city	high	City field from addresses array
created_at	skip	high	Metadata timestamp, not PII
multipass_identifier	skip	high	Internal identifier
province_code	skip	high	ISO province code, not PII field type
default_address	skip	high	Container object; extract individual fields instead
province	state	high	Province/state field from addresses array
updated_at	skip	high	Metadata timestamp, not PII
company	skip	high	Company name, not in available PII field types
currency	skip	high	Metadata
id	skip	high	Internal system ID, not PII
state	skip	high	Account state (enabled/disabled), not address state
first_name	firstName	high	Explicitly named first_name field with given names
email	email	high	Standard email field containing valid email addresses
zip	zip	high	Postal code field from addresses array
total_spent	skip	high	Financial metadata
last_order_id	skip	high	Transaction ID
address2	address2	high	Secondary address line from addresses array
tax_exempt	skip	high	Boolean flag
address1	address1	high	Primary address line from addresses array
email_marketing_consent	skip	high	Consent metadata object
last_name	lastName	high	Explicitly named last_name field with surnames
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Internal classification tags
country_code	skip	high	ISO country code, not PII field type
orders_count	skip	high	Transactional metadata
sms_marketing_consent	skip	high	Consent metadata object
phone	phone	high	Phone field at top level (though mostly null, when populated contains phone numbers)
admin_graphql_api_id	skip	high	Internal API identifier
name	skip	medium	Concatenated name field; firstName and lastName already captured separately
tax_exemptions	skip	high	Metadata array

Notes: Data structure is Shopify customer export with nested address objects. Phone numbers appear in addresses array rather than top-level phone field (which is mostly null). The 'name' field at addresses level is a concatenation of first_name and last_name, so it is redundant. Country_code values like 'IN' and province_code values like 'MH' are ISO standard codes, not PII. The 'state' field at top level indicates account status (enabled/disabled), distinct from geographic state/province which is 'province'.

BoAtLifestyleIndia__data__shopify_customers_partial_39_20240304040406.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes within nested address objects
country	country	high	Country field in nested address objects
province	state	high	State/province names (Odisha, Kerala, etc.) within nested address objects
phone	phone	high	Phone numbers in international format (+91...) and local format
address2	address2	high	Secondary address field within nested address objects
city	city	high	City names within nested address objects
address1	address1	high	Primary street address within nested address objects
last_name	lastName	high	Explicitly labeled last names
first_name	firstName	high	Explicitly labeled first names
email	email	high	Explicit email addresses present in all records

Notes: Data structure is Shopify customer export format. Address information is nested within 'addresses' array and 'default_address' object. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state', 'verified_email', 'tax_exempt', 'currency', 'tags', and consent-related fields are operational/metadata and do not map to PII field types. The 'name' field in nested address objects is a concatenation of first_name and last_name. Indian phone numbers are identified; some have country code prefix (+91), others are local format only.

BoAtLifestyleIndia__data__shopify_customers_partial_39_20240305060059.json

38 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested address objects
note	skip	high	Administrative notes
addresses	skip	high	Container array; individual fields mapped separately
last_order_name	skip	high	Transaction reference
city	city	high	City field in nested address objects
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Internal authentication token
province_code	skip	high	Abbreviation of province, metadata
default	skip	high	Boolean flag for address preference
default_address	skip	high	Container object; individual fields mapped separately
province	state	high	Province/state field in nested address objects (Indian states)
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Duplicate country representation
currency	skip	high	Configuration metadata
company	skip	high	Not a standard PII field type
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status, not geographic state
first_name	firstName	high	Explicit first name field present in all records
email	email	high	Standard email field containing valid email addresses
zip	zip	high	Postal code field in nested address objects
total_spent	skip	high	Transaction data
consent_updated_at	skip	high	Timestamp metadata
last_order_id	skip	high	Transaction metadata
address2	address2	high	Secondary address line in nested address objects; often empty
tax_exempt	skip	high	Account configuration flag
address1	address1	high	Primary street address in nested address objects
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Explicit last name field present in all records
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Categorical metadata
orders_count	skip	high	Transaction metadata
country_code	skip	high	Country code metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Phone field at customer level; null in most top-level records but populated in nested address objects
admin_graphql_api_id	skip	high	Internal API identifier
tax_exemptions	skip	high	Configuration array
customer_id	skip	high	Internal identifier
opt_in_level	skip	high	Consent configuration

Notes: Shopify customer export format. Phone numbers appear primarily in nested address objects rather than top-level customer records. The 'name' field in address objects is a concatenation of first_name and last_name (not mapped separately as it's derived). All PII fields are present at either customer level or nested address level. Province field contains Indian state names (Uttar Pradesh, Rajasthan, Karnataka, etc.). Country is consistently 'India' for all visible records.

BoAtLifestyleIndia__data__shopify_customers_partial_3_20240303182251.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/ZIP codes present in addresses array objects
country	country	high	Country field present in addresses array objects (e.g., 'India')
province	state	high	Province field maps to state; contains state/province names like 'Andhra Pradesh'
phone	phone	high	Phone numbers present in root level and nested in address objects
address2	address2	high	Secondary address line found in addresses array objects
city	city	high	City names present in addresses array objects
address1	address1	high	Street address found in addresses array objects
last_name	lastName	high	Explicitly labeled last_name field; null when full name is in first_name
first_name	firstName	high	Consistently contains first names; sometimes contains full name when last_name is null
email	email	high	Explicit email field present in all records with valid email addresses

Notes: This is a Shopify customer export from boAt Lifestyle breach (March 2024). PII is nested within 'addresses' array for address-related fields. The 'first_name' field sometimes contains the full name when 'last_name' is null. No SSN, DOB, passwords, usernames, gender, or generational suffixes detected in provided records. Root-level 'phone' is typically null; phone numbers are found in the nested address objects.

BoAtLifestyleIndia__data__shopify_customers_partial_3_20240304181502.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses array, contains postal codes
total_spent	skip	high	Transaction/spending metadata, not PII
country	country	high	Nested in addresses array, contains country names
address2	address2	high	Nested in addresses array, secondary address field
city	city	high	Nested in addresses array, contains city names
address1	address1	high	Nested in addresses array, contains street addresses
last_name	lastName	high	Top-level last_name field contains family names
created_at	skip	high	Timestamp metadata, not PII
province_code	skip	high	State/province code metadata, not PII
orders_count	skip	high	Transaction metadata, not PII
country_code	skip	high	Country code metadata, not PII
province	state	high	Nested in addresses array, contains state/province names (Indian states)
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	high	Top-level phone field (though mostly null in top-level, populated in address objects)
name	fullName	high	Nested in addresses array, contains concatenated full names
currency	skip	high	Transaction metadata, not PII
id	skip	high	Customer/record identifier, not PII
state	skip	high	Account status field (enabled/disabled), not PII
first_name	firstName	high	Top-level first_name field contains given names
email	email	high	Top-level email field contains valid email addresses

Notes: This is a Shopify customer data export from the boAt Lifestyle breach. PII fields are present at both top-level (email, first_name, last_name, phone) and nested within the addresses array. The 'name' field in addresses is a concatenation of first_name and last_name. The 'province' field maps to state. Phone numbers appear primarily in address objects rather than top-level phone field. All records are from India (country_code: 'IN'). Non-PII fields like order history, account status, timestamps, and transaction amounts have been marked as skip.

BoAtLifestyleIndia__data__shopify_customers_partial_40_20240304042149.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (302001, 462036, 560066)
country	country	high	Country name (India)
province	state	high	Province/state names (Rajasthan, Madhya Pradesh, Karnataka) - maps to state field
phone	phone	high	Top-level phone field (null in these records but present in schema)
address2	address2	high	Secondary address field within addresses array (null in these records)
city	city	high	City names (JAIPUR, BHOPAL, BANGALORE)
address1	address1	high	Primary street address within addresses array (e.g., 'A-2837 bhindo ka rasta indira bazar')
name	fullName	high	Full name field within addresses array combining first and last names
last_name	lastName	high	Contains last names (Samariya, Singh)
first_name	firstName	high	Contains first names (Monika, Dinesh Kumar, Devaraj)
email	email	high	Directly contains email addresses like [email protected]

Notes: Data structure is nested with customer-level fields at root (email, first_name, last_name, phone) and detailed address information in the 'addresses' array. Phone numbers appear in the addresses array but null at root level in these 50 records. The 'province' field contains full state names and should be mapped to 'state'. The nested 'name' field in addresses contains the full name. No DOB, SSN, password, username, gender, or suffix fields are present in the data.

BoAtLifestyleIndia__data__shopify_customers_partial_40_20240305061841.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip codes in nested address objects
country	country	high	Country names in nested address objects
province	state	high	State/province information in nested address objects
phone	phone	high	Contains phone numbers at customer level; also appears in nested address objects
address2	address2	high	Secondary address line in nested address objects
city	city	high	City names in nested address objects
address1	address1	high	Primary address line in nested address objects
name	fullName	high	Full name field present in nested address objects (e.g., 'Kratos Saini', 'Mohd Iftekhar Sayyed')
last_name	lastName	high	Contains last names of customers
first_name	firstName	high	Contains first names of customers
email	email	high	Consistently contains email addresses across all records

Notes: Shopify customer export structure. PII fields appear at both top-level (email, first_name, last_name, phone) and nested within 'addresses' array and 'default_address' object. The 'name' field in address objects contains the full name. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'total_spent', 'verified_email', 'tags', 'currency', 'tax_exempt', and 'admin_graphql_api_id' are metadata/operational fields mapped to 'skip'. Null values for phone at top level suggest phone is primarily in address objects. Province_code and country_code are standardized codes, not primary PII fields.

BoAtLifestyleIndia__data__shopify_customers_partial_41_20240304043857.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field with Indian PIN codes
country	country	high	Country field consistently showing 'India'
province	state	high	Province field containing Indian states (Uttar Pradesh, Karnataka, Delhi)
phone	phone	high	Phone field with Indian phone numbers in +91 format and standard digits
address2	address2	high	Secondary address field (apartment, suite, etc.) - mostly null in sample
city	city	high	City field containing location names (GHAZIABAD, BANGALORE, etc.)
address1	address1	high	Primary street address field nested in addresses array and default_address
last_name	lastName	high	Explicitly named last_name field containing family names
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field containing valid email addresses

Notes: This is a Shopify customer export from the boAt Lifestyle breach. The data structure uses nested address objects (addresses array and default_address). Key observations: (1) 'province' maps to state/province; (2) phone numbers appear both at top level and within address objects; (3) Some records have null phone numbers at top level but phone data in addresses; (4) first_name sometimes contains full name (e.g., 'Silvia Michell'), requiring data quality review; (5) No SSN, DOB, password, username, gender, or suffix fields present in sample; (6) country_code and country_name are present but mapped to skip as they're ISO codes/redundant; (7) province_code present but mapped to skip (ISO code, redundant with province); (8) All records are from India; (9) Records contain Shopify-specific metadata (id, created_at, updated_at, orders_count, etc.) mapped to skip.

BoAtLifestyleIndia__data__shopify_customers_partial_41_20240305063629.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array
country	country	high	Country field within addresses array (country_code and country_name also available)
province	state	high	Province/state field within addresses array (province_code also available)
phone	phone	high	Phone field present at top level (though mostly null in sample)
address2	address2	high	Secondary address field within addresses array
city	city	high	City field within addresses array
address1	address1	high	Street address field within addresses array (though mostly empty in sample)
last_name	lastName	high	Consistently contains family names (Sharma, gurav, Chaubhare, Kalal, Maddisetty)
first_name	firstName	high	Consistently contains given names (Tanu, Bhagyashree, Nikhil, Saivara, Harish)
email	email	high	Standard email field containing valid email addresses

Notes: This is Shopify customer data from boAt Lifestyle breach (March 2024). Data is nested with customer-level fields and an 'addresses' array containing address objects. Most address fields in the provided sample are empty strings or null. The 'name' field within address objects is a composite fullName and should not be mapped separately. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'verified_email', 'tags', 'currency', 'admin_graphql_api_id' are metadata/operational and should map to 'skip'. No SSN, DOB, password, username, gender, middleName, or suffix fields are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_42_20240304045624.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested address objects (e.g., 413501, 733202)
total_spent	skip	high	Financial metadata, not PII field category
country	country	high	Country field in nested address objects (India)
address2	address2	high	Secondary address field in nested address objects (mostly null)
city	city	high	City field in nested address objects
address1	address1	high	Primary street address field in nested address objects
last_name	lastName	high	Explicitly named last_name field containing family names
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Account tags/labels, not PII
orders_count	skip	high	Order statistics, not PII
province	state	high	Province/state field in nested address objects (e.g., Maharashtra, West Bengal)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone field with international format phone numbers (e.g., +919597299634)
admin_graphql_api_id	skip	high	System API identifier
currency	skip	high	Currency preference, not PII
id	skip	high	System identifier, not PII
state	skip	high	Account status flag, not PII
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field present in all records with valid email addresses

Notes: This is a Shopify customer dataset from the boAt Lifestyle breach. Address data is nested within 'addresses' array and 'default_address' object. The 'province' field maps to 'state'. The 'country' field is present and should be mapped to 'country'. No DOB, SSN, password, username, gender, middle name, or suffix fields are present in the sample data.

BoAtLifestyleIndia__data__shopify_customers_partial_42_20240305065511.json

31 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in address objects
note	skip	high	Internal notes
last_order_name	skip	high	Order reference
city	city	high	City field in address objects
created_at	skip	high	Timestamp, not PII
multipass_identifier	skip	high	Platform identifier
province_code	skip	high	State code abbreviation, not PII
default	skip	high	Boolean flag
province	state	high	Province/state field in address objects (Indian states)
updated_at	skip	high	Timestamp, not PII
currency	skip	high	Account preference
company	skip	high	Business name, not personal PII
id	skip	high	Internal system identifier
state	skip	high	Account status, not PII
first_name	firstName	high	Explicitly labeled first_name field
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal code field in address objects
total_spent	skip	high	Transaction metadata
last_order_id	skip	high	Order metadata
address2	address2	high	Secondary address line in address objects
tax_exempt	skip	high	Account flag
address1	address1	high	Primary address line in address objects
last_name	lastName	high	Explicitly labeled last_name field
verified_email	skip	high	Boolean flag
tags	skip	high	Internal categorization
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Account metadata
phone	phone	high	Phone number field at customer level; also present in address objects
admin_graphql_api_id	skip	high	Platform API identifier
name	fullName	high	Combined first and last name in address objects
customer_id	skip	high	Internal reference

Notes: This is a Shopify customer export from the boAt Lifestyle breach. Customer data is at the top level with nested address objects. Phone numbers appear both at customer level (often null) and within address objects. The 'name' field in address objects is a concatenation of first_name and last_name. Province field contains full state names (e.g., 'Maharashtra', 'Gujarat'), not codes. All records are from India (country: 'India'). No SSN, DOB, gender, username, password, middleName, or suffix fields detected in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_43_20240304051337.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from nested addresses objects
country	country	high	Country field from nested addresses objects
province	state	high	State/province field from nested addresses objects
phone	phone	high	Top-level phone field with customer phone numbers
address2	address2	high	Street address line 2 (apartment/unit) from nested addresses objects
city	city	high	City name from nested addresses objects
address1	address1	high	Street address line 1 from nested addresses objects
name	fullName	high	Full name concatenation in nested addresses objects (e.g., 'Rathish G')
last_name	lastName	high	Contains family names of customers
first_name	firstName	high	Contains given names of customers
email	email	high	Standard email field containing customer email addresses

Notes: Data structure is Shopify customer export format. Phone appears both at top level (sometimes null) and within nested addresses array. Address data is nested within 'addresses' array and 'default_address' object. The 'name' field within address objects contains the full name (firstName + lastName concatenated). Fields like 'id', 'created_at', 'orders_count', 'total_spent', 'state', 'verified_email', 'tags', etc. are metadata/operational fields and mapped to 'skip'. All records contain Indian customer data with INR currency and India as country_code.

BoAtLifestyleIndia__data__shopify_customers_partial_43_20240305071358.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from addresses array
country	country	high	Country from addresses array
province	state	high	State/province from addresses array
phone	phone	high	Top-level phone field (null in most records shown, but present in schema)
address2	address2	high	Street address line 2 from addresses array
city	city	high	City from addresses array
address1	address1	high	Street address line 1 from addresses array
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email addresses present in all records

Notes: This is a Shopify customer data export. PII fields are present both at the top level (email, first_name, last_name, phone) and nested within the addresses array. The nested address structure repeats in both 'addresses' array and 'default_address' object. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state' (account state), 'verified_email', 'tags', 'currency', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are non-PII metadata and should be mapped to 'skip'. The 'name' field in addresses is a concatenation of first and last names and could be mapped to 'fullName', but firstName/lastName extraction is already present.

BoAtLifestyleIndia__data__shopify_customers_partial_44_20240304053059.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from addresses nested object
country	country	high	Country from addresses nested object
province	state	high	State/province from addresses nested object
phone	phone	high	Explicit phone field at customer level
address2	address2	high	Street address line 2 from addresses nested object
city	city	high	City from addresses nested object
address1	address1	high	Street address line 1 from addresses nested object
last_name	lastName	high	Explicit last name field
first_name	firstName	high	Explicit first name field
email	email	high	Explicit email field containing valid email addresses

Notes: Shopify customer export from boAt Lifestyle breach. Address data is nested within 'addresses' array and 'default_address' object. Fields like 'province' map to state, 'country_code' and 'country_name' available but country name used. Phone appears both at top level and nested in address records. No DOB, SSN, password, username, gender, or suffix data present in sample. 'name' field combines first_name + last_name but redundant to individual fields.

BoAtLifestyleIndia__data__shopify_customers_partial_44_20240305073215.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code nested in addresses array objects
total_spent	skip	high	Transaction history
country	country	high	Country field nested in addresses array objects
address2	address2	high	Secondary address line nested in addresses array objects
city	city	high	City field nested in addresses array objects
address1	address1	high	Primary address line nested in addresses array objects
last_name	lastName	high	Consistently contains last names across all records
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Email verification status flag
province_code	skip	high	State/province code is a standardized code, not PII itself
tags	skip	high	Internal categorization tags
country_code	skip	high	Country code is a standardized code, not PII itself
orders_count	skip	high	Order history metadata
province	state	high	Province/state field nested in addresses array objects
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone field at customer level; often null but present in schema
name	skip	high	Concatenated full name; firstName/lastName provide complete data separately
currency	skip	high	Preference metadata
company	skip	high	Optional business field, not core PII
id	skip	high	Internal system identifier, not PII
state	skip	high	Account state (enabled/disabled), not address state
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email addresses present in all records

Notes: Data structure uses nested addresses array. Phone numbers found both at customer root level and within address objects. The 'province' field within addresses maps to state. All core PII fields identified match the boAt Lifestyle breach context (email, names, phone, addresses). Note that 'phone' at root customer level is often null; actual phone data appears in the addresses array objects.

BoAtLifestyleIndia__data__shopify_customers_partial_45_20240304054742.json

25 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field present (India for all records)
city	city	high	City names in nested addresses object
created_at	skip	high	Timestamp metadata; not PII
province_code	skip	high	State abbreviation code; administrative metadata, not PII
default	skip	high	Boolean flag for default address; not PII
province	state	high	Indian states (Delhi, Maharashtra, etc.) in nested addresses object
updated_at	skip	high	Timestamp metadata; not PII
currency	skip	high	Currency code; not PII
company	skip	high	Company field; not personal PII
id	skip	high	Internal customer ID; administrative identifier, not PII
state	skip	high	Account status field (enabled/disabled); not PII
first_name	firstName	high	Customer first names consistently populated
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal codes (6-digit Indian PIN codes)
total_spent	skip	high	Transaction amount; financial history not requested
address2	address2	high	Street address line 2 from nested addresses object (mostly null)
tax_exempt	skip	high	Boolean flag; not PII
address1	address1	high	Street address line 1 from nested addresses object
last_name	lastName	high	Customer last names consistently populated
verified_email	skip	high	Boolean flag; not PII
tags	skip	high	Internal categorization; not PII
country_code	skip	high	ISO country code; administrative metadata, not PII
orders_count	skip	high	Transaction metric; not PII
phone	phone	high	Phone numbers with country code (+91 India prefix)
name	skip	high	Redundant full name concatenation; firstName + lastName already captured separately

Notes: Shopify Plus customer data from boAt Lifestyle breach (March 2024). Records contain nested 'addresses' array with address details; mapping extracts from this structure. Last names sometimes contain only '.' (data quality issue). Phone numbers include +91 country code prefix. All records appear to be Indian customers. No SSN, DOB, password, username, gender, or suffix fields present in dataset. 'name' field is concatenated firstName + lastName; not separately mapped as it duplicates individual name fields.

BoAtLifestyleIndia__data__shopify_customers_partial_45_20240305075036.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array
country	country	high	Country field in addresses array
province	state	high	Province/state field in addresses array
phone	phone	high	Top-level phone field (null in most records but present)
address2	address2	high	Street address line 2 in addresses array
city	city	high	City field in addresses array
address1	address1	high	Street address line 1 in addresses array
name	fullName	high	Full name concatenation field in addresses array (e.g., 'Anish badgujar')
last_name	lastName	high	Explicitly named last_name field
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is Shopify Plus customer export. Top-level phone field is present but null in all 50 records examined; phone data is consistently found in the addresses array objects. The 'name' field in addresses contains the full name (firstName + lastName). No passwords, SSNs, DOBs, usernames, genders, suffixes, or middle names detected in sample. Breach context confirms customer PII exfiltration including emails, full names, phone numbers, and physical addresses.

BoAtLifestyleIndia__data__shopify_customers_partial_46_20240304060346.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from nested addresses objects
country	country	high	Country name from nested addresses objects; consistently 'India'
country_code	skip	high	ISO country code; derived/redundant data
province	state	high	State/province name from nested addresses objects (e.g., 'Andhra Pradesh', 'Karnataka')
phone	phone	high	Contains phone numbers in international format (+91 country code for India)
address2	address2	high	Secondary address line from nested addresses objects; typically null
city	city	high	City name from nested addresses objects
address1	address1	high	Primary street address line from nested addresses objects
last_name	lastName	high	Standard last name field; nullable in some records
province_code	skip	high	ISO state/province code; derived/redundant data
first_name	firstName	high	Consistently contains first names; note that some records have full names in this field (e.g., 'Gautam Gupta')
email	email	high	Standard email field with valid email addresses across all records

Notes: This is a Shopify customer data export. Address information is nested within 'addresses' array and 'default_address' object. The 'first_name' field sometimes contains full names (record 3: 'Gautam Gupta'), indicating potential data quality issues in the source system. Fields like 'id', 'created_at', 'orders_count', 'total_spent', 'verified_email', 'email_marketing_consent', and 'sms_marketing_consent' are transactional/metadata and mapped to 'skip'. No SSN, DOB, username, password, gender, middle name, or suffix fields are present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_46_20240305080927.json

34 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Nested in addresses array; country name
note	skip	high	Admin notes; not PII
last_order_name	skip	high	Order reference; not PII
city	city	high	Nested in addresses array; city name
created_at	skip	high	Timestamp; not PII
multipass_identifier	skip	high	System identifier; not PII
province_code	skip	high	State abbreviation; not PII
default	skip	high	Boolean flag for default address; not PII
province	state	high	Nested in addresses array; province/state name
updated_at	skip	high	Timestamp; not PII
country_name	skip	high	Duplicate of country field; not PII
currency	skip	high	Currency code; not PII
company	skip	high	Company name in address; not typically classified as PII in this context
id	skip	high	Customer ID; not PII
state	skip	high	Account state (enabled/disabled); not PII
first_name	firstName	high	Top-level field containing given names
email	email	high	Top-level field containing email addresses
zip	zip	high	Nested in addresses array; postal code
total_spent	skip	high	Transaction data; not PII
last_order_id	skip	high	Order reference; not PII
address2	address2	high	Nested in addresses array; secondary address field
tax_exempt	skip	high	Boolean flag; not PII
address1	address1	high	Nested in addresses array; primary street address
email_marketing_consent	skip	high	Preference metadata; not PII
last_name	lastName	high	Top-level field containing family names
verified_email	skip	high	Boolean flag; not PII
tags	skip	high	Internal tags; not PII
orders_count	skip	high	Metadata; not PII
country_code	skip	high	Country code; not PII
sms_marketing_consent	skip	high	Preference metadata; not PII
phone	phone	high	Top-level field containing phone numbers (though often null, populated in some records)
admin_graphql_api_id	skip	high	API identifier; not PII
name	skip	high	Concatenated name in address objects; redundant with first_name and last_name
tax_exemptions	skip	high	Tax status; not PII

Notes: Shopify customer export from boAt Lifestyle breach (March 2024). Names appear in both top-level (first_name, last_name) and nested address objects (same fields within addresses array). Phone numbers present in nested address objects. Province field contains full state names (e.g., 'Maharashtra'). Country consistently 'India'. No middle names, DOB, SSN, passwords, usernames, gender, or suffix fields present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_47_20240304062015.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field (found in addresses array)
note	skip	high	Internal notes
addresses	skip	high	Container array; individual fields within are mapped
last_order_name	skip	high	Transaction metadata
city	city	high	City field (found in addresses array)
created_at	skip	high	Metadata timestamp
multipass_identifier	skip	high	Internal identifier
province_code	skip	high	State abbreviation code; redundant with province
default	skip	high	Boolean flag for default address
default_address	skip	high	Container object; individual fields within are mapped
province	state	high	Province/state field (found in addresses array)
updated_at	skip	high	Metadata timestamp
country_name	skip	high	Redundant country field; country already mapped
currency	skip	high	Transactional metadata
company	skip	high	Company name, not personal PII
id	skip	high	Internal identifier, not PII
state	skip	high	Account status, not address state
first_name	firstName	high	Explicitly labeled first_name field
email	email	high	Standard email field containing email addresses
zip	zip	high	Postal code field (found in addresses array)
total_spent	skip	high	Transaction data
last_order_id	skip	high	Transaction metadata
address2	address2	high	Secondary address field (found in addresses array)
tax_exempt	skip	high	Tax status flag
address1	address1	high	Street address field (found in addresses array)
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Explicitly labeled last_name field
verified_email	skip	high	Boolean flag
tags	skip	high	Internal categorization
country_code	skip	high	Country code abbreviation; redundant with country
orders_count	skip	high	Transaction metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	medium	Phone field at customer level is null in all samples; actual phone data found in addresses array
admin_graphql_api_id	skip	high	Internal API identifier
name	skip	high	Concatenated name field; first_name and last_name already mapped separately
tax_exemptions	skip	high	Tax metadata array

Notes: Shopify customer export from boAt Lifestyle breach. Phone and address data are nested within the 'addresses' array (and 'default_address' object). The top-level 'phone' field is consistently null; actual phone numbers are in addresses[].phone. All records are India-based (country: 'India'). The 'name' field contains concatenated first and last names and should not be used as it duplicates first_name/last_name fields.

BoAtLifestyleIndia__data__shopify_customers_partial_47_20240305082822.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip code in address objects
total_spent	skip	high	Financial transaction total
country	country	high	Country field (all India in this dataset)
address2	address2	high	Nested in addresses array, secondary address line
city	city	high	City name in address objects
tax_exempt	skip	high	Tax status flag
address1	address1	high	Nested in addresses array, primary street address
last_name	lastName	high	Explicitly named last_name field containing surnames
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Email verification boolean flag
tags	skip	high	Customer tags/labels
orders_count	skip	high	Order history metric
province	state	high	Province/state field (Indian states like Kerala, Telangana, Andhra Pradesh)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Top-level phone field (null in most records but present in schema)
currency	skip	high	Currency code
id	skip	high	Customer ID - system identifier, not PII
state	skip	high	Account status flag (enabled/disabled)
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is from Shopify Plus e-commerce platform. Phone numbers appear in nested addresses array rather than top-level phone field (which is null). Address information is duplicated across 'addresses' array, 'default_address' object, and nested address objects within records. The 'name' field in address objects is fullName (combined first_name + last_name). province_code and country_code are abbreviations; use province for full state name. No SSN, DOB, password, username, gender, or suffix data present in breach records.

BoAtLifestyleIndia__data__shopify_customers_partial_48_20240304063906.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field with Indian PIN codes (e.g., 244001, 221401)
country	country	high	Country field contains country name (India) and country_code (IN)
province	state	high	Province field maps to state; contains Indian state names (e.g., Uttar Pradesh)
phone	phone	high	Contains phone numbers in E.164 format (e.g., +917983132032) and local formats
address2	address2	high	Secondary address field nested in addresses array; typically null or empty
city	city	high	City names present in addresses array (e.g., MORADABAD, INDORE)
address1	address1	high	Street address field nested in addresses array; primary address line
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Standard email field present in all records with valid email addresses

Notes: Shopify customer data structure from boAt Lifestyle breach. Phone field appears at top level and nested within addresses. Use top-level phone for customer phone; nested phone in addresses for address-specific phone. Province field contains Indian state abbreviations (province_code) and full names (province). No PII fields found for: dob, middleName, ssn, password, username, gender, suffix. The 'name' field in addresses is redundant (fullName concatenation) and not necessary to map separately.

BoAtLifestyleIndia__data__shopify_customers_partial_48_20240305084716.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field
total_spent	skip	high	Transaction amount
country	country	high	Country field
address2	address2	high	Secondary address field (apartment, suite, etc.)
city	city	high	City field in addresses
address1	address1	high	Primary street address field in addresses array
last_name	lastName	high	Explicit last name field
created_at	skip	high	Metadata timestamp
verified_email	skip	high	Account verification flag
province_code	skip	high	State code abbreviation, not PII
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Transaction history count
province	state	high	Province/state field (Indian states like Punjab, Tamil Nadu, Chandigarh)
updated_at	skip	high	Metadata timestamp
phone	phone	high	Phone field at customer level (though often null, present in nested addresses)
name	skip	high	Duplicate of firstName + lastName already mapped separately
company	skip	high	Business name, optional and not PII category
id	skip	high	Internal database identifier, not PII
state	skip	high	Account status (enabled/disabled)
first_name	firstName	high	Explicit first name field
email	email	high	Direct email field containing valid email addresses

Notes: Shopify customer export from boAt Lifestyle breach. Phone numbers appear only in nested address objects, not at root customer level. The 'province' field maps to state (Indian states used). Names are split into first_name/last_name. Address data is nested within 'addresses' array with multiple address records per customer. Country is consistently 'India' in breach data.

BoAtLifestyleIndia__data__shopify_customers_partial_49_20240304065844.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code within addresses array
total_spent	skip	high	Transaction metadata, not PII
country	country	high	Country field within addresses array
address2	address2	high	Street address line 2 within addresses array
city	city	high	City field within addresses array
address1	address1	high	Street address line 1 within addresses array
last_name	lastName	high	Explicitly named last_name field
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO state code, not PII
orders_count	skip	high	Transaction metadata, not PII
country_code	skip	high	ISO country code, not PII
default	skip	high	Boolean flag for address preference
province	state	high	Province maps to state; Indian states like Tamil Nadu, Madhya Pradesh
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone field at customer root level (though often null, populated in addresses)
name	fullName	high	Combined full name field within addresses array
currency	skip	high	Transaction metadata, not PII
company	skip	high	Business entity, not personal PII
id	skip	high	System identifier, not PII
state	skip	high	Account state (disabled), not PII
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing valid email addresses

Notes: Shopify customer export from boAt Lifestyle 2024 breach. Address data is nested within 'addresses' array (and duplicated in 'default_address'). Phone numbers appear both at root level (often null) and within address objects (populated). The 'province' field contains Indian state names and should map to 'state'. The 'name' field within address objects contains the full name. No SSN, DOB, password, username, gender, suffix, middleName, or dob fields are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_49_20240305090621.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in nested addresses objects
total_spent	skip	high	Purchase amount, not standard PII field
country	country	high	Country field in nested addresses objects
address2	address2	high	Secondary address field in nested addresses objects
city	city	high	City field in nested addresses objects
address1	address1	high	Primary street address in nested addresses objects
last_name	lastName	high	Last names consistently present
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO province code, not a PII field type
country_code	skip	high	ISO country code, not a PII field type
orders_count	skip	high	Order metric, not PII
province	state	high	Province/state field in nested addresses objects
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone field at top level (mostly null, but present in structure)
name	skip	high	Concatenated name in nested addresses, covered by first_name/last_name
id	skip	high	Customer ID identifier, not PII
state	skip	high	Account state (enabled/disabled), not address state
first_name	firstName	high	First names consistently present
email	email	high	Direct email addresses present in all records

Notes: Data structure is a Shopify Plus customer export with nested address objects. Phone number appears at top level but is typically null; active phone data is in nested addresses array. The 'province' field maps to US/generic 'state' field. Country is consistently 'India' in sample. All records contain email, first_name, last_name as core PII. Address data is nested within 'addresses' array and 'default_address' object.

BoAtLifestyleIndia__data__shopify_customers_partial_4_20240303183718.json

4 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
last_name	lastName	high	Last name field present; predominantly null in sample, but included for completeness as per Shopify schema
first_name	firstName	high	First names consistently populated; some records contain full names in this field (e.g., 'Sagar Kumar', 'Harpreet Singh Madhok')
phone	phone	high	Phone numbers in international format (e.g., '+919557915261'), clearly identifiable
email	email	high	Email addresses present in all records, clearly identifiable by key name and format

Notes: The breach context indicates customer data from boAt Lifestyle's Shopify Plus store. The sample records show: (1) `first_name` frequently contains full names rather than split first/last names, likely due to customer data entry patterns; (2) `last_name` is consistently null across the sample; (3) `addresses` array is present but empty in all 50 records sampled—address data may exist in related nested objects or separate records not shown; (4) No DOB, SSN, password, username, gender, suffix, country, or other PII fields are present in the provided records; (5) Metadata fields (id, created_at, updated_at, orders_count, state, currency, etc.) and marketing consent objects are not mapped to PII fields.

BoAtLifestyleIndia__data__shopify_customers_partial_4_20240304183442.json

26 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
city	city	high	Nested in addresses/default_address objects; city names
created_at	skip	high	Timestamp; not PII
province_code	skip	high	State abbreviation code; redundant with province/state field
province	state	high	Nested in addresses/default_address objects; Indian state names (e.g., 'West Bengal', 'Uttar Pradesh')
updated_at	skip	high	Timestamp; not PII
country_name	country	high	Nested in addresses/default_address objects; country name ('India')
currency	skip	high	Currency code; not PII
company	skip	high	Company name; not personal PII per breach context
id	skip	high	Internal customer ID; not PII
state	skip	high	Account state (enabled/disabled); not PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Top-level email field contains valid email addresses
zip	zip	high	Nested in addresses/default_address objects; postal codes
total_spent	skip	high	Financial summary; not PII
last_order_id	skip	high	Order ID; not PII
address2	address2	high	Nested in addresses/default_address objects; secondary address line
tax_exempt	skip	high	Boolean flag; not PII
address1	address1	high	Nested in addresses/default_address objects; primary street address
last_name	lastName	high	Consistently contains last names across all records
verified_email	skip	high	Boolean flag; not PII
tags	skip	high	Metadata tags; not PII
country_code	skip	high	Country code abbreviation; redundant with country_name field
orders_count	skip	high	Metadata; not PII
phone	phone	high	Top-level phone field contains phone numbers in E.164 format and local format
admin_graphql_api_id	skip	high	API identifier; not PII
name	skip	high	Derived full name (concatenation of first_name and last_name); use separate firstName/lastName fields instead

Notes: Data structure is nested with customer-level fields and an 'addresses' array containing address objects. The 'default_address' object duplicates the primary address. Phone numbers appear at both customer level and address level. Names are stored separately as first_name/last_name rather than fullName. No passwords, SSNs, DOBs, usernames, middle names, genders, or suffixes detected in provided records. All location data indicates India as country.

BoAtLifestyleIndia__data__shopify_customers_partial_50_20240304071850.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in addresses array
total_spent	skip	high	Financial metadata
country	country	high	Country field present in addresses array
address2	address2	medium	Secondary address lines (apartment, building details) in addresses array
city	city	high	City/town names in addresses array
address1	address1	high	Street addresses within nested addresses array
last_name	lastName	high	Consistently contains family names
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag
province_code	skip	high	Abbreviated code, not PII
tags	skip	high	Administrative notes
orders_count	skip	high	Transactional metadata
country_code	skip	high	Abbreviated code, not PII
province	state	high	State/province names (Maharashtra, Tamil Nadu, Andhra Pradesh)
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone numbers in E.164 format and local format
country_name	skip	high	Duplicate country information
currency	skip	high	Metadata
company	skip	high	Business name, not personal PII
id	skip	high	System identifier, not PII
state	skip	high	Account status field, not address state
first_name	firstName	high	Consistently contains given names
email	email	high	Direct email addresses present in all records

Notes: Data structure is Shopify customer export from boAt Lifestyle breach. Customer PII is nested within 'addresses' array (default_address and addresses fields). The 'province' field maps to US 'state' concept. Phone numbers appear both at customer level and address level. All records from India (country: 'India'). No SSN, DOB, password, username, gender, or name suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_50_20240305092555.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (388450, 485001)
country	country	high	Country field (India)
province	state	high	State/province names (Gujarat, Madhya Pradesh) - using province field for state PII mapping
phone	phone	high	Contains phone numbers in E.164 format (+916353666694) and standard format (7000760996)
address2	address2	high	Secondary address field (often null or empty string)
city	city	high	City names (ANAND, Petlad, Satna)
address1	address1	high	Primary street address field (15,Limdisheri, near mahadev temple Petlad., Jeevan jyoti colony lane no.4)
name	fullName	high	Full name within nested address objects (Mrugasha Soni, Yas Tharwani)
last_name	lastName	high	Contains last names (Bhujade, Soni, Tharwani, paste)
first_name	firstName	high	Contains first names (Krutika, Mrugasha, Yas, vishal)
email	email	high	Standard email field containing email addresses like [email protected]

Notes: This is Shopify customer data from the boAt Lifestyle 2024 breach. The structure includes nested address objects with repeating PII fields. The 'province' field maps to 'state'. Customer records contain email, name, phone, and complete address information. No password, username, SSN, DOB, gender, suffix, or title fields are present in the sample provided.

BoAtLifestyleIndia__data__shopify_customers_partial_51_20240304073809.json

34 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested addresses objects
note	skip	high	Merchant notes, not PII
last_order_name	skip	high	Order reference, not PII
city	city	high	City field in nested addresses objects
created_at	skip	high	Timestamp, not PII
multipass_identifier	skip	high	Internal identifier, not PII
province_code	skip	high	State abbreviation code, not a PII field type
default	skip	high	Boolean flag for default address, not PII
province	state	high	State/province field in nested addresses objects
updated_at	skip	high	Timestamp, not PII
currency	skip	high	Currency code, not PII
company	skip	high	Business name, not individual PII
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status (disabled), not PII
first_name	firstName	high	Explicit first name field
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal code field in nested addresses objects
total_spent	skip	high	Transaction amount, not PII
last_order_id	skip	high	Order reference, not PII
address2	address2	high	Secondary address line in nested addresses objects
tax_exempt	skip	high	Tax status flag, not PII
address1	address1	high	Primary street address in nested addresses objects
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Explicit last name field
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Merchant tags, not PII
country_code	skip	high	ISO country code, not a PII field type
orders_count	skip	high	Behavioral data, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Phone number field at customer level (null in top-level but present in addresses)
admin_graphql_api_id	skip	high	Internal API reference, not PII
name	skip	high	Derived field (concatenation of first_name and last_name); redundant with separate firstName/lastName fields
tax_exemptions	skip	high	Tax compliance data, not PII
customer_id	skip	high	Internal identifier, not PII

Notes: Data structure is Shopify customer export format with nested 'addresses' array. Address PII fields (phone, address1, address2, city, province, zip, country) are located within the 'addresses' array objects and 'default_address' object. Top-level 'phone' field is consistently null; phone data appears only in nested address objects. The 'name' field is a concatenated version of first_name and last_name and should be parsed from separate fields instead.

BoAtLifestyleIndia__data__shopify_customers_partial_51_20240305094446.json

26 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country names within address objects
addresses	skip	high	Array container (address fields mapped individually)
city	city	high	City names within address objects
created_at	skip	high	Timestamp metadata
province_code	skip	high	State abbreviation code
default_address	skip	high	Array container (address fields mapped individually)
province	state	high	State/province information within address objects
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Redundant country identifier
currency	skip	high	Transaction currency code
company	skip	high	Company name within address (not personal PII)
id	skip	high	Internal Shopify customer ID, not PII
state	skip	high	Account status (enabled/disabled), not geographic state
first_name	firstName	high	Customer first names consistently present
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal codes within address objects
total_spent	skip	high	Financial transaction metadata
address2	address2	high	Secondary address line within address objects
address1	address1	high	Primary street address within address objects
last_name	lastName	high	Customer last names consistently present
verified_email	skip	high	Account verification flag
tags	skip	high	Marketing/internal categorization tags
orders_count	skip	high	Transaction/account metadata
country_code	skip	high	ISO country code
phone	phone	high	Phone numbers at top level (when present) and within address objects
name	skip	high	Denormalized full name (firstName/lastName already captured)

Notes: Shopify customer data export from boAt Lifestyle breach (March 2024). Address data is nested within 'addresses' array and 'default_address' object; individual fields within these objects should be extracted and mapped to corresponding PII fields. The 'phone' field appears both at top level (often null) and within address objects. Fields like 'id', 'created_at', 'state' (account status), and various metadata have been marked 'skip' as they are not personally identifiable information.

BoAtLifestyleIndia__data__shopify_customers_partial_52_20240304075753.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code found in nested addresses objects
country	country	high	Country name in nested addresses objects
province	state	high	Indian state/province name in nested addresses objects
phone	phone	high	Top-level phone field present in customer records
address2	address2	high	Secondary address line found in nested addresses objects
city	city	high	City name found in nested addresses objects
address1	address1	high	Primary street address found in nested addresses objects
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Directly labeled email field containing valid email addresses

Notes: Data is nested within 'addresses' array (both in 'addresses' and 'default_address' objects). Phone numbers appear both at top level (often null) and within address objects. The 'province' field maps to US state field as it contains Indian states. No SSN, DOB, password, username, gender, or suffix fields present in sample. The 'name' field in addresses is fullName equivalent but firstName/lastName are preferred when separate. This is Shopify customer export format from the boAt Lifestyle breach.

BoAtLifestyleIndia__data__shopify_customers_partial_52_20240305100327.json

34 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
note	skip	high	Internal notes, not PII
addresses	skip	high	Nested object containing address subfields; individual address components mapped separately
last_order_name	skip	high	Order reference, not PII
addresses[].address1	address1	high	Primary address line
addresses[].name	fullName	high	Complete name concatenated in address objects
addresses[].address2	address2	high	Secondary address line (apartment, suite, etc.)
addresses[].phone	phone	high	Phone number within address objects
created_at	skip	high	Timestamp, not PII
multipass_identifier	skip	high	Shopify system identifier, not PII
addresses[].first_name	firstName	high	First name within address objects
default_address	skip	high	Nested object; individual fields already mapped
updated_at	skip	high	Timestamp, not PII
currency	skip	high	Currency code, not PII
id	skip	high	Customer ID, not PII
state	skip	high	Account state (disabled/active), not PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Top-level email field contains valid email addresses
total_spent	skip	high	Transaction data, not PII
last_order_id	skip	high	Order ID, not PII
tax_exempt	skip	high	Tax status, not PII
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Consistently contains last names across all records
verified_email	skip	high	Email verification status, not PII
addresses[].country	country	high	Country name
tags	skip	high	Customer tags/metadata, not PII
orders_count	skip	high	Metadata, not PII
addresses[].province	state	high	State/province name (Indian states)
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field (null in most top-level records but present in schema)
admin_graphql_api_id	skip	high	Shopify system identifier, not PII
tax_exemptions	skip	high	Tax configuration, not PII
addresses[].city	city	high	City name
addresses[].last_name	lastName	high	Last name within address objects
addresses[].zip	zip	high	Postal code

Notes: Shopify customer export from boAt Lifestyle breach. Address data is nested within 'addresses' array and 'default_address' object. Phone field exists at top level but is typically null; actual phone numbers are found in address objects. The 'province' field maps to state (Indian states like Karnataka, Andhra Pradesh). Country is consistently 'India' across visible records. No DOB, SSN, password, username, gender, middleName, or suffix fields present in this dataset.

BoAtLifestyleIndia__data__shopify_customers_partial_53_20240304081705.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country name from addresses nested object
note	skip	high	Admin notes
addresses	skip	high	Container object; individual fields mapped separately
last_order_name	skip	high	Transactional reference
city	city	high	City name from addresses nested object
created_at	skip	high	Metadata timestamp
multipass_identifier	skip	high	Shopify system identifier
province_code	skip	high	State code abbreviation, derived from province
default	skip	high	Address flag metadata
default_address	skip	high	Container object; individual fields mapped separately
province	state	high	State/province from addresses nested object (Shopify terminology)
updated_at	skip	high	Metadata timestamp
country_name	skip	high	Duplicate of country field
currency	skip	high	Account setting
company	skip	high	Business metadata, not personal PII
id	skip	high	System identifier, not PII
state	skip	high	Account state flag, not geographic state
first_name	firstName	high	Explicit first name field
email	email	high	Standard email field containing valid email addresses
zip	zip	high	Postal code from addresses nested object
total_spent	skip	high	Transactional data
last_order_id	skip	high	Transactional metadata
address2	address2	high	Secondary address line from addresses nested object
tax_exempt	skip	high	Account flag
address1	address1	high	Primary address line from addresses nested object
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Explicit last name field
verified_email	skip	high	Metadata flag
tags	skip	high	Metadata tags
orders_count	skip	high	Transactional metadata
country_code	skip	high	Country code abbreviation, derived from country
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Phone numbers in E.164 format and local formats
admin_graphql_api_id	skip	high	System identifier
name	skip	high	Derived concatenation of first_name and last_name; individual fields already mapped
tax_exemptions	skip	high	Account metadata
customer_id	skip	high	System identifier

Notes: Data structure is Shopify customer export with nested addresses array. PII fields appear both at top-level (email, first_name, last_name, phone) and within nested address objects. All address-related fields (address1, address2, city, province, zip, country, phone) should be extracted from the addresses array. The 'province' field maps to 'state' per PII taxonomy. No DOB, SSN, password, username, gender, suffix, or middleName fields present in records. The 'name' field is a concatenated derivative and should not be mapped separately. Breach context confirms this is Shopify Plus customer data from boAt Lifestyle March 2024 breach.

BoAtLifestyleIndia__data__shopify_customers_partial_53_20240305102329.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses objects
country	country	high	Country field in nested addresses objects
province	state	high	Province/state field in nested addresses objects
phone	phone	high	Phone field at top level (null in first records but present in structure)
address2	address2	high	Secondary address/apartment/unit in nested addresses objects
city	city	high	City field in nested addresses objects
address1	address1	high	Primary street address in nested addresses objects
last_name	lastName	high	Explicit last name field
first_name	firstName	high	Explicit first name field
email	email	high	Explicit email field with standard email format values

Notes: Data structure is from Shopify Plus store. Top-level phone field exists but is null in sample records; phone data is present in nested 'addresses' array objects. The 'name' field in addresses is a concatenation of first_name and last_name (fullName equivalent) but should use separate firstName/lastName mappings. No PII fields detected for: dob, middleName, ssn, password, username, gender, suffix. The 'province_code' and 'country_code' are standardized codes; 'country_name' is redundant with 'country'.

BoAtLifestyleIndia__data__shopify_customers_partial_54_20240304083647.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in nested address objects
total_spent	skip	high	Transaction metadata, not PII
country	country	high	Country name in nested address objects
address2	address2	high	Secondary address line in nested address objects
city	city	high	City name in nested address objects
address1	address1	high	Primary street address in nested address objects
last_name	lastName	high	Family name field consistently populated
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	System flag, not PII
province_code	skip	high	ISO state code, not PII
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Transaction metadata, not PII
province	state	high	State/province field in nested address objects
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Phone number at customer level (though often null, present in nested addresses)
name	fullName	high	Concatenated first and last name in nested address objects
company	skip	high	Business entity, not personal PII
id	skip	high	Internal customer ID, not PII
first_name	firstName	high	Given name field consistently populated
email	email	high	Direct email address field present in all records

Notes: Data from Shopify Plus customer records. Phone numbers appear primarily in nested 'addresses' array rather than at top level. The 'name' field in address objects represents fullName (concatenated first_name and last_name). All records are from India (country: 'India'). No SSN, DOB, password, username, gender, or suffix fields detected in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_54_20240305104257.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip code within address objects
total_spent	skip	high	Transaction data - not PII
country	country	high	Country field within address objects
addresses	skip	high	Array structure; address components should be mapped individually from address objects
address2	address2	high	Within address objects: secondary address line (apartment, suite, etc.)
city	city	high	City/municipality within address objects
address1	address1	high	Within address objects: primary street address line
email_marketing_consent	skip	high	Consent preferences - not PII
last_name	lastName	high	Top-level last_name field consistently contains family names
created_at	skip	high	Timestamp - not PII
verified_email	skip	high	Boolean flag - not PII
orders_count	skip	high	Behavioral data - not PII
province	state	high	Indian state/province field within address objects
updated_at	skip	high	Timestamp - not PII
phone	phone	high	Top-level phone field (though mostly null in sample, field is present for phone numbers)
name	fullName	high	Within address objects: concatenated full name (first + last)
currency	skip	high	Account preference - not PII
id	skip	high	Customer/record ID - not PII
state	skip	high	Account state (disabled/active) - not PII
first_name	firstName	high	Top-level first_name field consistently contains given names
email	email	high	Direct email field containing valid email addresses

Notes: This is a Shopify customer export from the boAt Lifestyle breach (March 2024). Address data is nested within the 'addresses' array and 'default_address' object. The 'phone' field at top level is mostly null; actual phone numbers are found within nested address objects. The 'province' and 'province_code' fields in addresses refer to Indian states. The 'name' field in addresses appears to be a pre-concatenated fullName combining first_name and last_name. No password, SSN, DOB, gender, username, or sensitive credential fields are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_55_20240304085615.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested address objects
country	country	high	Country field in nested address objects
province	state	high	Province field maps to state PII field (Indian states like Uttar Pradesh, Rajasthan)
phone	phone	high	Phone field at top level (mostly null); phone numbers found in nested address objects
address2	address2	high	Secondary address field in nested address objects (mostly empty)
city	city	high	City field in nested address objects
address1	address1	high	Street address field in nested address objects
last_name	lastName	high	Explicit last name field at top level
first_name	firstName	high	Explicit first name field at top level
email	email	high	Standard email field containing valid email addresses

Notes: Data structure is Shopify customer export. Top-level 'phone' is typically null; actual phone numbers are stored in nested 'addresses' array objects. Names appear in multiple locations (top-level and in nested address objects). No SSN, password, username, DOB, gender, or suffix fields present in sample. Country is consistently 'India'. Province values are full state names; province_code contains abbreviations.

BoAtLifestyleIndia__data__shopify_customers_partial_55_20240305110240.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in address objects
note	skip	high	Internal notes
addresses	skip	high	Nested array object containing address subfields; address components extracted separately
last_order_name	skip	high	Transaction reference
city	city	high	City field in nested address objects
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Technical identifier
province_code	skip	high	State code abbreviation; state already captured
default	skip	high	Address flag, not PII
default_address	skip	high	Duplicate of addresses array; address data extracted from nested objects
province	state	high	Province/state field in nested address objects
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Duplicate of country field
currency	skip	high	Currency metadata
company	skip	high	Business name, not individual PII
id	skip	high	Customer/record ID, not PII
state	skip	high	Account status, not PII
first_name	firstName	high	First names consistently populated across records
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal code in nested address objects
total_spent	skip	high	Transaction metadata
last_order_id	skip	high	Transaction metadata
address2	address2	high	Secondary address line in nested address objects
tax_exempt	skip	high	Account flag, not PII
address1	address1	high	Primary street address in nested address objects
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Last names consistently populated across records
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Categorical metadata
orders_count	skip	high	Transaction metadata
country_code	skip	high	Country code abbreviation; country already captured
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Phone numbers at customer level (when populated)
admin_graphql_api_id	skip	high	Technical identifier
name	skip	high	Derived/duplicate of first_name + last_name
tax_exemptions	skip	high	Tax status array
customer_id	skip	high	Technical identifier

Notes: Data structure is Shopify customer export format. Address data is nested within 'addresses' array and 'default_address' object; extract address fields from these nested structures. Phone number appears both at top level (customer.phone) and nested within address objects (address.phone) — both should be captured as phone PII. The 'name' field within addresses is a concatenation of first_name + last_name and should be skipped as redundant. Country appears in nested address objects as both 'country' (full name) and 'country_code' (abbreviation). No SSN, password, username, DOB, middle name, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_56_20240304091551.json

25 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Clearly labeled country field
note	skip	high	Internal notes, not PII
city	city	high	Clearly labeled city field in addresses objects
created_at	skip	high	Timestamp, not PII
province_code	skip	high	Abbreviated code; full province/state name already captured in 'province' field
province	state	high	Province field maps to state; contains state/province names like Tamil Nadu, Maharashtra, Haryana
updated_at	skip	high	Timestamp, not PII
country_name	skip	high	Redundant field; country is already captured
company	skip	high	Business field, not personal PII
id	skip	high	System identifier, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Clearly labeled first_name field
email	email	high	Clearly labeled email field containing email addresses
zip	zip	high	Clearly labeled zip field containing postal codes
total_spent	skip	high	Transactional data, not PII
address2	address2	high	Clearly labeled address2 field in addresses objects
tax_exempt	skip	high	Account flag, not PII
address1	address1	high	Clearly labeled address1 field in addresses objects
last_name	lastName	high	Clearly labeled last_name field
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Metadata tags, not PII
country_code	skip	high	Abbreviated code; full country name already captured in 'country' field
orders_count	skip	high	Transactional data, not PII
phone	phone	high	Clearly labeled phone field at customer level
name	skip	high	Redundant concatenated field; firstName and lastName are already captured separately

Notes: Data structure is Shopify customer export format. Address information is nested within 'addresses' array and 'default_address' object. The 'province' field contains full state/province names and maps to the 'state' PII field. Phone field appears both at customer root level (often null) and within address objects (populated). All PII fields identified; no DOB, SSN, password, username, gender, middleName, or suffix fields present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_56_20240305112142.json

13 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses array
country	country	high	Country field in nested addresses array
address2	address2	high	Secondary address/unit field in nested addresses array
city	city	high	City field in nested addresses array
address1	address1	high	Street address field in nested addresses array
last_name	lastName	high	Explicitly named last_name field
province_code	skip	high	ISO province code, not a distinct PII field
country_code	skip	high	ISO country code, not a distinct PII field
province	state	high	Province/state field in nested addresses array
phone	phone	high	Top-level phone field (null in most records but present in schema)
name	fullName	high	Pre-composed full name in nested addresses array
first_name	firstName	high	Explicitly named first_name field
email	email	high	Top-level email field contains standard email addresses

Notes: All customer PII fields identified. Top-level fields include email, first_name, last_name, and phone. Detailed address information (address1, address2, city, state, zip, country) is nested within the 'addresses' array and 'default_address' object. The 'name' field in addresses represents fullName. Administrative fields (id, created_at, updated_at, orders_count, state, total_spent, verified_email, tags, etc.) are mapped to 'skip'. No SSN, password, username, DOB, middleName, gender, or suffix fields are present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_57_20240304093610.json

36 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country name in addresses array
note	skip	high	Internal notes
last_order_name	skip	high	Order reference
city	city	high	City name in addresses array
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Internal identifier
province_code	skip	high	State code metadata
default	skip	high	Address flag
default_address	skip	high	Nested structure (data duplicated in addresses array)
province	state	high	Province/state in addresses array
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Redundant country data
currency	skip	high	Transactional metadata
company	skip	high	Company field (null in records)
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Customer first names
email	email	high	Email addresses present in all records
zip	zip	high	Postal code in addresses array
total_spent	skip	high	Transactional data
last_order_id	skip	high	Transactional metadata
address2	address2	high	Street address line 2 in addresses array (null in records shown)
tax_exempt	skip	high	Account flag
address1	address1	high	Street address line 1 in addresses array
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Customer last names
verified_email	skip	high	Flag, not PII
tags	skip	high	Categorical tags
orders_count	skip	high	Transactional metadata
country_code	skip	high	Country code metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Phone number field at top level (null in most records shown)
admin_graphql_api_id	skip	high	Internal API identifier
name	skip	high	Composite name in addresses (redundant with first_name/last_name)
tax_exemptions	skip	high	Tax metadata array
customer_id	skip	high	Internal identifier

Notes: Data from Shopify Plus store. Top-level 'phone' field is null across records; actual phone numbers appear only in nested 'addresses' array. The 'name' field in addresses is a composite of first_name and last_name. Address data is nested within an 'addresses' array and 'default_address' object. Note that some last_name values are '.' (placeholder for missing data).

BoAtLifestyleIndia__data__shopify_customers_partial_57_20240305114047.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array objects
country	country	high	Country field within addresses array objects
province	state	high	State/province field within addresses array objects
phone	phone	medium	Top-level phone field, but null in most records; phone data primarily in addresses array
address2	address2	high	Secondary address field within addresses array objects
city	city	high	City field within addresses array objects
address1	address1	high	Street address field within addresses array objects
last_name	lastName	high	Explicit last name field at top level
first_name	firstName	high	Explicit first name field at top level
email	email	high	Top-level email field containing standard email addresses

Notes: Shopify customer data structure. Address information is nested within 'addresses' array and 'default_address' object. The 'province' key maps to state. Phone data appears in nested address objects rather than top-level phone field. Fields like 'id', 'created_at', 'orders_count', 'currency', 'tags', 'state' (account state), 'verified_email', 'tax_exempt', and 'email_marketing_consent' are not PII field mappings. 'name' field in addresses is a concatenated fullName representation but firstName/lastName are preferred. No password, username, SSN, DOB, gender, middleName, suffix, or honorific title fields present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_58_20240304095558.json

27 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
addresses	skip	high	Complex nested array; address fields mapped individually below
addresses[].address1	address1	high	Primary street address
addresses[].address2	address2	high	Secondary address line (apartment, suite, etc.)
addresses[].phone	phone	high	Phone number within address object
created_at	skip	high	Timestamp, not PII
addresses[].first_name	firstName	high	First name within address object
default_address	skip	high	Duplicate of addresses[] data; primary address already mapped
updated_at	skip	high	Timestamp, not PII
currency	skip	high	Currency code, not PII
id	skip	high	Customer ID, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Top-level first_name field contains given names
email	email	high	Top-level email field contains valid email addresses
total_spent	skip	high	Financial metric, not PII
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Top-level last_name field contains family names
verified_email	skip	high	Boolean flag, not PII
addresses[].country	country	high	Country field in address
tags	skip	high	Merchant notes/tags, not PII
orders_count	skip	high	Order metric, not PII
addresses[].province	state	high	Province/state field (India uses provinces)
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field contains phone numbers
admin_graphql_api_id	skip	high	API identifier, not PII
addresses[].city	city	high	City field in address
addresses[].last_name	lastName	high	Last name within address object
addresses[].zip	zip	high	Postal code field

Notes: Shopify customer export from boAt Lifestyle data breach. Address data is nested within 'addresses' array and 'default_address' object. Phone numbers appear in two locations: top-level (may be null) and within address objects (contains actual values). The 'name' field within address objects is redundant concatenation of first_name + last_name and should be skipped. Province field maps to state (Indian administrative divisions). All records appear to be from India based on country_code and country_name fields.

BoAtLifestyleIndia__data__shopify_customers_partial_58_20240305120127.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Purchase history metric
addresses[].address1	address1	high	Primary street address in nested addresses array
addresses[].name	fullName	high	Full name concatenation in nested addresses array
addresses[].address2	address2	high	Secondary address field (apt, suite, etc.) in nested addresses array
addresses[].phone	phone	high	Phone number at address level in nested addresses array
last_name	lastName	high	Consistently contains last names across records
created_at	skip	high	Timestamp metadata
addresses[].country	country	high	Country field in nested addresses array
province_code	skip	high	Abbreviated state code, redundant with province
orders_count	skip	high	Order history metric, not PII
country_code	skip	high	Abbreviated country code, redundant with country
addresses[].province	state	high	State/province field in nested addresses array
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone field at customer level (though mostly null, when populated contains phone numbers)
addresses[].city	city	high	City field in nested addresses array
id	skip	high	Internal customer ID, not PII mapping
state	skip	high	Account status field, not geographic state
first_name	firstName	high	Consistently contains first names across records
email	email	high	Standard email field containing customer email addresses
addresses[].zip	zip	high	Postal code in nested addresses array

Notes: Data structure contains nested 'addresses' array with address PII. Both top-level 'phone' field and nested 'addresses[].phone' field contain phone numbers. The 'default_address' object duplicates address data from the addresses array. Shopify-specific metadata fields (multipass_identifier, admin_graphql_api_id, tax_exempt, tags, etc.) mapped to skip. India-focused dataset with West Bengal and Maharashtra provinces prominent.

BoAtLifestyleIndia__data__shopify_customers_partial_59_20240304101537.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip codes in nested addresses objects
country	country	high	Country field in nested addresses objects
province	state	high	State/province field in nested addresses objects
phone	phone	high	Phone field at customer level, though often null
address2	address2	high	Secondary address field in nested addresses objects
city	city	high	City names present in nested addresses objects
address1	address1	high	Primary street address in nested addresses objects
name	fullName	high	Full name concatenation in nested addresses objects
last_name	lastName	high	Consistently contains last names
first_name	firstName	high	Consistently contains first names
email	email	high	Direct email addresses present in all records

Notes: Data structure is hierarchical with customer-level and nested address-level fields. Phone numbers appear both at customer level (often null) and within addresses array. Address data is reliably populated in nested 'addresses' array. No password, SSN, DOB, gender, suffix, username, or middleName fields present in the sample. Province field maps to state. Country is consistently 'India' in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_59_20240305122144.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code from addresses array
country	country	high	Country from addresses array
province	state	high	State/province from addresses array
phone	phone	high	Customer phone number at root level (though often null, populated in addresses)
address2	address2	high	Secondary address line in addresses array
city	city	high	City from addresses array
address1	address1	high	Primary address line in addresses array
name	fullName	high	Full name field in addresses array (e.g., 'Rohan Shinde')
last_name	lastName	high	Customer last name field
first_name	firstName	high	Customer first name field
email	email	high	Standard email field containing customer email addresses

Notes: Data is nested within 'addresses' array as well as at root level. Root-level 'phone' is frequently null, but phone numbers are reliably present in the 'addresses' array objects. The 'name' field in addresses contains fullName (first + last concatenated). 'province' and 'province_code' are present; 'province' maps to state. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state' (account state), 'total_spent', 'verified_email', 'currency', 'tags', 'company', 'country_code', 'country_name', and nested consent objects are not PII fields and should be skipped.

BoAtLifestyleIndia__data__shopify_customers_partial_5_20240303185250.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (395007, 494001); matches breach context
country	country	high	Country name (India); matches breach context
province	state	high	Indian states/provinces (Gujarat, Chhattisgarh); stored as 'province' in JSON but maps to state field
phone	phone	high	Contains phone numbers in E.164 format (+91 country code) or local format; matches breach context
address2	address2	high	Secondary address field in nested address objects (often null or empty string)
city	city	high	City names in address objects (SURAT, BASTAR, etc.); matches breach context
address1	address1	high	Primary address line found in nested address objects; matches breach context
last_name	lastName	high	Contains surnames or name suffixes (null in some records, lohra, mourya, etc.)
first_name	firstName	high	Consistently contains first names (Raju Kumar, Shiv, Harshika, Santosh)
email	email	high	Consistent email addresses across all records, matches breach context description

Notes: Shopify Plus customer data structure. Address information is nested in 'addresses' array and also replicated in 'default_address'. The 'province' field maps to 'state' PII field. No password, username, SSN, DOB, gender, or middleName fields present in the sample. The 'province_code' and 'country_code' are metadata and should be skipped.

BoAtLifestyleIndia__data__shopify_customers_partial_5_20240304185452.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Transaction metadata
tax_exempt	skip	high	Account flag, not PII
addresses[].address1	address1	high	Primary street address
addresses[].name	fullName	high	Full name derived from address object
addresses[].phone	phone	high	Phone number stored within address objects
addresses[].address2	address2	high	Secondary address line (null in provided records)
last_name	lastName	high	Customer last name
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
addresses[].country	country	high	Country field
tags	skip	high	Customer tags, not PII
orders_count	skip	high	Metadata, not PII
addresses[].province	state	high	State/province field (Indian states like Delhi, Maharashtra)
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Top-level phone field (null in most records, but field exists)
addresses[].city	city	high	City name
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status, not address state
first_name	firstName	high	Customer first name
email	email	high	Standard email field containing customer email addresses
addresses[].zip	zip	high	Postal/ZIP code

Notes: Data structure is Shopify customer export format. Address information appears in both a nested 'addresses' array and 'default_address' object; both contain identical PII fields. The 'province' field represents state/province. Phone number appears both at top-level (mostly null) and within address objects. No passwords, SSNs, DOB, gender, or username fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_60_20240304103450.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/zip code in nested address objects
country	country	high	Country field in nested address objects
province	state	high	Province/state field in nested address objects
phone	phone	high	Phone field at customer level (though null in top-level records, populated in addresses)
address2	address2	high	Street address line 2 in nested address objects
city	city	high	City field in nested address objects
address1	address1	high	Street address line 1 in nested address objects
last_name	lastName	high	Directly labeled last_name field
first_name	firstName	high	Directly labeled first_name field
email	email	high	Directly labeled email field containing email addresses

Notes: Data structure is Shopify customer export with nested address objects. Phone numbers appear in address objects rather than at customer root level. Country consistently 'India' across records. Province values map to Indian states. Last names often contain just '.' indicating incomplete data. No passwords, SSNs, DOBs, usernames, or name suffixes present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_60_20240305124103.json

35 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field within addresses array
note	skip	high	Internal note field, not PII
last_order_name	skip	high	Order reference, not PII
city	city	high	City field within addresses array
created_at	skip	high	Metadata timestamp, not PII
multipass_identifier	skip	high	Internal Shopify identifier, not PII
province_code	skip	high	State code is derived data, not PII
default	skip	high	Address flag, not PII
province	state	high	Indian state/province field; maps to state PII field
updated_at	skip	high	Metadata timestamp, not PII
country_name	skip	high	Redundant with country field; skip to avoid duplication
currency	skip	high	Currency preference, not PII
company	skip	high	Company name field is null; not PII for this breach context
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status (disabled/enabled), not PII
first_name	firstName	high	Consistent first name values across records
email	email	high	Top-level email field contains standard email addresses
zip	zip	high	Postal code field within addresses array
total_spent	skip	high	Financial metadata, not PII
last_order_id	skip	high	Order reference, not PII
address2	address2	high	Secondary address/apartment number within addresses array
tax_exempt	skip	high	Tax status flag, not PII
address1	address1	high	Street address field within addresses array
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Consistent last name values across records
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Internal categorization, not PII
country_code	skip	high	Country code is derived data, not PII
orders_count	skip	high	Behavioral data, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Top-level phone field is null in sample, but present in schema
admin_graphql_api_id	skip	high	Internal API identifier, not PII
name	skip	high	Duplicate of first_name + last_name; use atomic fields instead
tax_exemptions	skip	high	Tax metadata, not PII
customer_id	skip	high	Internal reference ID, not PII

Notes: Data from boAt Lifestyle Shopify Plus store breach (March 2024). Phone numbers appear in nested address objects, not at top level. Province field (Indian states) maps to 'state'. No passwords, DOBs, SSNs, usernames, or name suffixes present in sample. All PII mapped from Shopify customer schema structure.

BoAtLifestyleIndia__data__shopify_customers_partial_61_20240304105451.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array
country	country	high	Country field in addresses array
province	state	high	Province/state field in addresses array
phone	phone	high	Phone field at top level (though null in many records, present in addresses)
address2	address2	high	Secondary address field (apt/unit/etc) in addresses array
city	city	high	City field in addresses array
address1	address1	high	Primary street address field in addresses array
name	fullName	high	Full name field in addresses array (combines first and last name)
last_name	lastName	high	Explicit last name field at top level
first_name	firstName	high	Explicit first name field at top level
email	email	high	Explicit email field containing customer email addresses

Notes: Data structure is nested with customer-level fields at top and address details in 'addresses' array and 'default_address' object. Phone appears at top level (mostly null) but reliably populated in address objects. The 'name' field in addresses combines first_name and last_name into fullName format. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'state', 'verified_email', 'tax_exempt', 'tags', 'currency', 'company', 'province_code', 'country_code', 'country_name', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are metadata/transactional fields with no PII mapping.

BoAtLifestyleIndia__data__shopify_customers_partial_61_20240305130049.json

15 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Purchase history, not PII field type
note	skip	high	Admin notes, not PII field type
addresses	unmapped	—	No notes recorded.
last_name	lastName	high	Consistently contains last names across all records
created_at	skip	high	Timestamp, not PII field type
verified_email	skip	high	Boolean flag, not PII field type
province_code	skip	high	State code abbreviation, not PII field type
orders_count	skip	high	Order metric, not PII field type
country_code	skip	high	Country code abbreviation, not PII field type
updated_at	skip	high	Timestamp, not PII field type
phone	phone	high	Top-level phone field (mostly null in sample, but present in schema)
id	skip	high	Internal ID, not PII field type
state	skip	high	Account state/status, not PII field type
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email addresses present in all records

Notes: Shopify customer export format from boAt Lifestyle breach. Addresses are nested within 'addresses' array; phone numbers appear both at top level (mostly null) and within address objects. The 'name' field in addresses is derived/redundant. All records are from India (country_code: IN). No SSN, DOB, password, username, or gender fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_62_20240304111420.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
addresses.address2	address2	high	Secondary address line in address objects
addresses.phone	phone	high	Phone numbers at address level (supplements top-level phone)
addresses.address1	address1	high	Primary street address in address objects
phone	phone	high	Phone numbers at top level (some null)
last_name	lastName	high	Customer last names consistently populated
addresses.zip	zip	high	Postal codes in address objects
addresses.city	city	high	City names in address objects
addresses.country	country	high	Country names in address objects
first_name	firstName	high	Customer first names consistently populated
email	email	high	Direct email addresses present in all records
addresses.province	state	high	State/province names in address objects

Notes: This is a Shopify Plus store export structure. Address data is nested in 'addresses' array. The 'default_address' object duplicates the primary address from the 'addresses' array. Top-level 'phone' field may be null even when phone exists in address objects. No PII fields found for: ssn, password, username, dob, gender, suffix, middleName, or fullName (though 'name' field exists in addresses but is composite of first/last). The breach context confirms: emails, names, phones, and physical addresses are the primary PII exfiltrated.

BoAtLifestyleIndia__data__shopify_customers_partial_62_20240305132118.json

14 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array
country	country	high	Country field in addresses array
address2	address2	high	Street address line 2 in addresses array
city	city	high	City field in addresses array
address1	address1	high	Street address line 1 in addresses array
last_name	lastName	high	Explicit last_name field at top level
created_at	skip	high	Timestamp, metadata
province	state	high	Province/state field in addresses array (Indian states)
updated_at	skip	high	Timestamp, metadata
phone	phone	high	Phone field at top level (though often null, populated in addresses)
name	fullName	high	Full name field in addresses array combining first and last name
id	skip	high	Customer ID, not PII mapping field
first_name	firstName	high	Explicit first_name field at top level
email	email	high	Explicit email field containing customer email addresses

Notes: Data structure is a Shopify customer export with nested addresses array. Phone number at top level is typically null; actual phone data resides in addresses[].phone. Province field maps to state (Indian states like Karnataka, Punjab, Odisha). Country is consistently 'India'. All PII fields identified align with breach context (Shopify Plus store exfiltration of customer contact and address data).

BoAtLifestyleIndia__data__shopify_customers_partial_63_20240304113418.json

26 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field
note	skip	high	Internal notes, not PII
city	city	high	City/municipality field
created_at	skip	high	Timestamp, not PII
province_code	skip	high	ISO province code, not PII
default	skip	high	Boolean flag, not PII
province	state	high	Province/state field (Indian states like West Bengal, Gujarat)
updated_at	skip	high	Timestamp, not PII
company	skip	high	Business entity, not personal PII
currency	skip	high	Currency code, not PII
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (enabled/disabled), not PII
first_name	firstName	high	Explicitly named first_name field
email	email	high	Standard email field containing customer email addresses
zip	zip	high	Postal/zip code field
total_spent	skip	high	Transaction data, not PII
address2	address2	high	Secondary address line (apartment, suite, etc.)
tax_exempt	skip	high	Account setting, not PII
address1	address1	high	Primary street address line
last_name	lastName	high	Explicitly named last_name field
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Internal tags/metadata, not PII
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Metadata, not PII
phone	phone	high	Phone field at customer level (though often null, populated in addresses)
name	skip	medium	Duplicate of first_name + last_name combination; use discrete fields instead

Notes: This is a Shopify customer export. Phone numbers appear in the 'addresses' nested array objects rather than at the top level. Nested address objects have identical PII field mappings as top-level address fields. The 'province' field corresponds to Indian states and should map to 'state'. No SSN, DOB, password, username, gender, middleName, suffix, or generational suffixes detected in the sample records.

BoAtLifestyleIndia__data__shopify_customers_partial_63_20240305134111.json

15 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in address objects
country	country	high	Country name in address objects (India)
address2	address2	high	Street address line 2 (apartment/suite) nested in addresses array
city	city	high	City name in address objects
address1	address1	high	Street address line 1 nested in addresses array
last_name	lastName	high	Explicitly named 'last_name' field containing family names
created_at	skip	high	Timestamp metadata
province_code	skip	high	ISO state code (e.g., KA, DL) - metadata, not PII identifier
country_code	skip	high	ISO country code (IN) - metadata, not PII identifier
province	state	high	Province/state field in address objects (Indian states like Karnataka, Delhi)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Explicitly named 'phone' field containing phone numbers in addresses and root level
id	skip	high	Customer ID - internal system identifier, not PII
first_name	firstName	high	Explicitly named 'first_name' field containing given names
email	email	high	Explicitly named 'email' field containing valid email addresses

Notes: Shopify customer export from boAt Lifestyle breach (March 2024). Addresses nested in 'addresses' array and 'default_address' object. Some records have null first_name/last_name but contain full names in nested address objects. Phone numbers appear both at root level (mostly null) and in address objects. Province field maps to state. Country is consistently 'India'. All location data follows Indian administrative divisions.

BoAtLifestyleIndia__data__shopify_customers_partial_64_20240304115411.json

22 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Order history metadata, not PII
addresses[].company	skip	high	Company name, not individual PII per schema
tax_exempt	skip	high	Account setting, not PII
addresses[].address1	address1	high	Nested in addresses array
addresses[].address2	address2	high	Nested in addresses array
last_name	lastName	high	Top-level last_name field
created_at	skip	high	Timestamp, not PII
addresses[].default	skip	high	Flag, not PII
verified_email	skip	high	Boolean flag, not PII
addresses[].country	country	high	Nested in addresses array
tags	skip	high	System tags, not PII
orders_count	skip	high	Metadata, not PII
addresses[].province	state	high	Province maps to state field; Indian administrative divisions
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Top-level phone field; also present in addresses array
currency	skip	high	Metadata, not PII
addresses[].city	city	high	Nested in addresses array
id	skip	high	Customer identifier, not PII
state	skip	high	Account status (enabled/disabled), not address state
first_name	firstName	high	Top-level first_name field
email	email	high	Top-level email field present in all records
addresses[].zip	zip	high	Nested in addresses array

Notes: Shopify Plus customer data structure. Top-level name fields (first_name, last_name) may be null; address information is nested within an addresses array. Province field corresponds to Indian states. Multiple address records per customer are possible. Phone number appears at both top level and within address records.

BoAtLifestyleIndia__data__shopify_customers_partial_64_20240305140218.json

20 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses/default_address objects; postal code
total_spent	skip	high	Transaction metadata, not PII
country	country	high	Nested in addresses/default_address objects; country name
address2	address2	high	Nested in addresses/default_address objects; secondary address details
city	city	high	Nested in addresses/default_address objects; city name
tax_exempt	skip	high	Account attribute, not PII
address1	address1	high	Nested in addresses/default_address objects; primary street address
last_name	lastName	high	Top-level last_name field contains family names
created_at	skip	high	Timestamp metadata, not PII
verified_email	skip	high	Account verification flag, not PII
orders_count	skip	high	Transaction metadata, not PII
province	state	high	Nested in addresses/default_address objects; administrative region (Indian states)
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	medium	Top-level phone field is null in most records shown, but field name indicates phone numbers
name	fullName	high	Nested in addresses/default_address objects; concatenated full name
currency	skip	high	Transaction metadata, not PII
id	skip	high	Internal database identifier, not PII
state	skip	high	Account status field (enabled/disabled), not residential state
first_name	firstName	high	Top-level first_name field contains given names
email	email	high	Top-level email field consistently contains valid email addresses across all records

Notes: Shopify Plus customer export structure. Phone numbers appear at top level (null in sample) and nested within address objects. Province field maps to state. Country consistently 'India'. The 'name' field within address objects contains fullName (first + last concatenated). No SSN, DOB, password, username, gender, suffix, or middleName fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_65_20240304121424.json

15 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code within addresses nested object
country	country	high	Country field within addresses nested object
address2	address2	high	Secondary address line within addresses nested object
city	city	high	City field within addresses nested object
address1	address1	high	Street address within addresses nested object
last_name	lastName	high	Explicitly named last_name containing family names
created_at	skip	high	Timestamp metadata
country_code	skip	high	ISO country code, not PII mapping
province	state	high	Province/state field within addresses nested object (Indian states)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Top-level phone field (null in most records but present in schema)
name	skip	high	Duplicate of first_name + last_name combination already mapped
id	skip	high	Internal system identifier
first_name	firstName	high	Explicitly named first_name containing given names
email	email	high	Standard email field with valid email addresses

Notes: Data structure is Shopify Plus customer export with nested address objects. Phone number appears at both top level (null) and nested within address objects (populated). The 'province' field contains Indian state abbreviations and full names. 'name' field is concatenated first_name + last_name; mapped to skip to avoid duplication. All records are from India (country_code: IN). No sensitive fields like SSN, DOB, password, or username are present in the dataset.

BoAtLifestyleIndia__data__shopify_customers_partial_65_20240305142327.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in nested addresses object
country	country	high	Country field in nested addresses object; also country_code and country_name available
province	state	high	Province maps to state field (Indian states); also available as province_code
phone	phone	high	Top-level phone field; note most are null but nested addresses contain phone data
address2	address2	high	Street address line 2 in nested addresses object
city	city	high	City field in nested addresses object
address1	address1	high	Street address line 1 in nested addresses object
name	fullName	high	Composite name field in nested addresses object (e.g., 'Rishi Sao')
last_name	lastName	high	Explicitly named last_name field
first_name	firstName	high	Explicitly named first_name field
email	email	high	Top-level email field with standard email addresses

Notes: Data structure is Shopify customer export format. PII fields exist at both top level (email, first_name, last_name, phone) and nested within the 'addresses' array (address1, address2, city, province, zip, phone, name, country). The 'province' field should be mapped to 'state'. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'total_spent', 'verified_email', 'tax_exempt', 'currency', 'admin_graphql_api_id', 'province_code', 'country_code', 'country_name' are metadata/administrative fields and should map to 'skip'. No SSN, password, username, DOB, gender, or suffix data is present in these records.

BoAtLifestyleIndia__data__shopify_customers_partial_66_20240304123451.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses object
total_spent	skip	high	Transaction amount, not PII
country	country	high	Country field in addresses object
address2	address2	high	Secondary address field in addresses object
city	city	high	City field in addresses object
tax_exempt	skip	high	Boolean flag, not PII
address1	address1	high	Primary street address field in addresses object
last_name	lastName	high	Directly labeled last_name field
created_at	skip	high	Timestamp, not PII
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Metadata tags, not PII
orders_count	skip	high	Transaction count, not PII
province	state	high	State/province field in addresses object
updated_at	skip	high	Timestamp, not PII
phone	phone	high	Directly labeled phone field containing phone numbers
name	skip	high	Derived full name present in addresses; use firstName/lastName instead
currency	skip	high	Currency code, not PII
id	skip	high	Internal identifier, not PII
state	skip	high	Account state field, not PII
first_name	firstName	high	Directly labeled first_name field
email	email	high	Directly labeled email field containing email addresses

Notes: Data structure is Shopify customer export. Address fields are nested within addresses array and default_address object. The 'name' field in addresses object is a derived concatenation of first_name and last_name and should not be separately mapped. Province field maps to state. All records contain Indian phone numbers (+91) and addresses consistent with the boAt Lifestyle breach context.

BoAtLifestyleIndia__data__shopify_customers_partial_66_20240305144436.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested address objects
note	skip	high	Internal notes
addresses	skip	high	Container array; individual fields mapped separately
last_order_name	skip	high	Order history metadata
city	city	high	City field in nested address objects
created_at	skip	high	Timestamp metadata
multipass_identifier	skip	high	Shopify-specific identifier
province_code	skip	high	State abbreviation metadata
default	skip	high	Address preference flag
default_address	skip	high	Container object; individual fields mapped separately
province	state	high	Province/state field in nested address objects
updated_at	skip	high	Timestamp metadata
country_name	skip	high	Redundant country field
currency	skip	high	Account setting
company	skip	high	Business name, not PII in this context
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status (disabled/enabled), not address state
first_name	firstName	high	Consistently labeled first_name across all records
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal/zip code in nested address objects
total_spent	skip	high	Purchase history metadata
last_order_id	skip	high	Order history metadata
address2	address2	high	Secondary address line in nested address objects
tax_exempt	skip	high	Account setting
address1	address1	high	Primary street address in nested address objects
email_marketing_consent	skip	high	Marketing preference metadata
last_name	lastName	high	Consistently labeled last_name across all records
verified_email	skip	high	Boolean flag
tags	skip	high	Internal categorization
orders_count	skip	high	Account metadata
country_code	skip	high	Country code metadata
sms_marketing_consent	skip	high	Marketing preference metadata
phone	phone	high	Top-level phone field; also appears in addresses nested objects
admin_graphql_api_id	skip	high	Shopify API identifier
name	skip	high	Composite name field; first_name and last_name already mapped separately
tax_exemptions	skip	high	Account settings array
customer_id	skip	high	Internal reference ID

Notes: Shopify customer export from boAt Lifestyle breach. Address data is nested within 'addresses' array and 'default_address' object. The 'province' field maps to 'state' PII field. All records contain email and name fields; address information varies by record. No SSN, DOB, password, username, gender, suffix, or middleName fields present in the provided sample. The 'name' field is a composite that duplicates first_name + last_name and should not be used independently.

BoAtLifestyleIndia__data__shopify_customers_partial_67_20240304125453.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in address objects
note	skip	high	Internal notes, not PII
addresses	skip	high	Array container (mapped at object level)
last_order_name	skip	high	Order reference, not PII
city	city	high	City field in address objects
created_at	skip	high	Timestamp, not PII
multipass_identifier	skip	high	System token, not PII
province_code	skip	high	State abbreviation code, not PII
default	skip	high	Boolean flag for default address, not PII
default_address	skip	high	Nested object (mapped at object level)
province	state	high	State/province field in address objects
updated_at	skip	high	Timestamp, not PII
country_name	skip	high	Redundant country field, not PII
currency	skip	high	Currency type, not PII
company	skip	high	Company name (not in available field types)
id	skip	high	Internal system identifier, not PII
state	skip	high	Account status field (enabled/disabled), not PII
first_name	firstName	high	Explicitly labeled first name field
email	email	high	Standard email field containing customer email addresses
zip	zip	high	Postal code in address objects
total_spent	skip	high	Transaction amount, not PII
last_order_id	skip	high	Order identifier, not PII
address2	address2	high	Secondary street address line in address objects
tax_exempt	skip	high	Boolean flag, not PII
address1	address1	high	Primary street address line in address objects
email_marketing_consent	skip	high	Consent metadata, not PII
last_name	lastName	high	Explicitly labeled last name field
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Internal categorization, not PII
orders_count	skip	high	Metadata, not PII
country_code	skip	high	Country code abbreviation, not PII
sms_marketing_consent	skip	high	Consent metadata, not PII
phone	phone	high	Phone field at customer level (though mostly null, populated in address records)
admin_graphql_api_id	skip	high	Internal system identifier, not PII
name	fullName	high	Full name field in address objects
tax_exemptions	skip	high	Tax status array, not PII
customer_id	skip	high	Internal identifier, not PII

Notes: Shopify customer export from boAt Lifestyle breach. Phone numbers appear primarily in nested address objects rather than at customer root level. Full names available both as separate first_name/last_name and combined in 'name' field within address objects. No DOB, SSN, password, username, gender, or suffix fields present in data. All address fields are nested within 'addresses' array and 'default_address' object.

BoAtLifestyleIndia__data__shopify_customers_partial_67_20240305150448.json

30 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
note	skip	high	Admin notes
addresses[].address1	address1	high	Primary street address
addresses[].name	fullName	high	Combined first and last name
addresses[].phone	phone	high	Customer phone number within address objects
addresses[].address2	address2	high	Secondary address information (apartment, suite, landmark)
created_at	skip	high	System timestamp
addresses[].first_name	firstName	high	First name in address record
default_address	skip	high	Duplicate of addresses array; same PII fields already mapped
updated_at	skip	high	System timestamp
currency	skip	high	Transaction currency preference
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status, not state/province
first_name	firstName	high	Customer first name
email	email	high	Standard email field containing customer email addresses
total_spent	skip	high	Purchase history metadata
last_order_id	skip	high	Order history metadata
tax_exempt	skip	high	Account setting
email_marketing_consent	skip	high	Marketing preference, not PII
last_name	lastName	high	Customer last name
verified_email	skip	high	Email verification status flag
addresses[].country	country	high	Country name
tags	skip	high	Account classification tags
orders_count	skip	high	Account metadata
addresses[].province	state	high	Indian state/province name
sms_marketing_consent	skip	high	Marketing preference, not PII
phone	phone	high	Customer phone number at top level (though often null, present in schema)
admin_graphql_api_id	skip	high	System API identifier
addresses[].city	city	high	City name
addresses[].last_name	lastName	high	Last name in address record
addresses[].zip	zip	high	Postal code

Notes: Shopify Plus customer export from boAt Lifestyle March 2024 breach. Address data is nested within 'addresses' array and 'default_address' object. Phone numbers appear at both top level (often null) and within address records. The 'province' field contains Indian state names (Maharashtra, West Bengal, Delhi, etc.). All records are from India with country_code 'IN'. Note: Some records have null values for certain fields (e.g., phone at top level) but the field mappings remain consistent across all records.

BoAtLifestyleIndia__data__shopify_customers_partial_68_20240304131545.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested address objects
country	country	high	Country field in nested address objects
province	state	high	State/province field in nested address objects (Indian states)
phone	phone	high	Phone number field in root object and nested address objects
address2	address2	high	Street address line 2 in nested address objects
city	city	high	City field in nested address objects
address1	address1	high	Street address line 1 in nested address objects
name	fullName	high	Full name concatenation present in nested address objects
last_name	lastName	high	Explicit last name field in root object
first_name	firstName	high	Explicit first name field in root object
email	email	high	Direct email address field present in root object and matches breach context

Notes: Data is from boAt Lifestyle Shopify Plus store breach (March 2024). Structure includes nested 'addresses' array with address details. Phone appears in both root and address levels. No DOB, SSN, password, username, gender, middleName, or suffix fields present in sample. Country consistently 'India' with country_code 'IN'.

BoAtLifestyleIndia__data__shopify_customers_partial_68_20240305152509.json

12 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array objects
country	country	high	Country field within addresses array objects
country_code	skip	high	Country code (IN) is a normalized country identifier, not PII mapping
province	state	high	Province/state field within addresses array objects (Indian states like Delhi, Gujarat)
phone	phone	high	Top-level phone field; often null but present in schema
address2	address2	high	Secondary address field within addresses array objects
city	city	high	City field within addresses array objects
address1	address1	high	Street address field within addresses array objects
name	fullName	high	Composite full name field within addresses array (e.g., 'Shubham Singh')
last_name	lastName	high	Consistently populated with last names across records
first_name	firstName	high	Consistently populated with first names across records
email	email	high	Top-level email field present in all records with standard email format

Notes: Shopify customer export structure. Address data nested in 'addresses' array and 'default_address' object. Phone data appears both at top level (often null) and within address objects. 'province' maps to state. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state' (enabled/disabled), 'verified_email', 'tags', 'currency', 'admin_graphql_api_id', 'email_marketing_consent', and 'sms_marketing_consent' are transactional/metadata and map to 'skip'. No DOB, SSN, password, username, gender, or suffix data present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_69_20240304133602.json

28 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
addresses.phone	phone	high	Phone number within address objects
created_at	skip	high	Timestamp, not PII
addresses.address2	address2	high	Street address line 2 (optional)
addresses.address1	address1	high	Street address line 1
updated_at	skip	high	Timestamp, not PII
addresses.country	country	high	Country name
id	skip	high	Customer ID, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Explicitly named first_name field
default_address.phone	phone	high	Phone in default address
email	email	high	Standard email field containing valid email addresses
addresses.province	state	high	State/province name (Indian states)
default_address.address1	address1	high	Default address line 1
default_address.country	country	high	Default address country
total_spent	skip	high	Financial metadata, not PII
default_address.zip	zip	high	Default address ZIP code
addresses.last_name	lastName	high	Last name in address object
default_address.address2	address2	high	Default address line 2
last_name	lastName	high	Explicitly named last_name field
addresses.city	city	high	City name
verified_email	skip	high	Boolean flag, not PII
default_address.city	city	high	Default address city
tags	skip	high	Metadata tag, not PII
orders_count	skip	high	Order metadata, not PII
phone	phone	high	Top-level phone field (mostly null in sample, but present in addresses)
default_address.province	state	high	Default address state/province
addresses.first_name	firstName	high	First name in address object
addresses.zip	zip	high	Postal/ZIP code

Notes: Shopify customer export from boAt Lifestyle 2024 breach. Address data is nested in 'addresses' array and 'default_address' object. The 'province' field represents Indian states and should map to 'state'. Country is consistently 'India'. Phone numbers appear both at top level (usually null) and within address objects (populated). The 'name' field in address objects is a denormalized fullName but can be reconstructed from first_name and last_name. No SSN, DOB, password, username, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_69_20240305154817.json

26 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in addresses array
city	city	high	City field in addresses array
created_at	skip	high	System timestamp, not PII
province_code	skip	high	ISO state code (MH, MP), not a distinct PII field
default_address	skip	high	Metadata flag indicating primary address
province	state	high	Province/state field in addresses array (Indian states like Maharashtra, Madhya Pradesh)
updated_at	skip	high	System timestamp, not PII
currency	skip	high	Transaction metadata
company	skip	high	Business name, not personal PII
id	skip	high	Internal database ID, not PII
state	skip	high	Account status flag (enabled/disabled), not address state
first_name	firstName	high	Top-level first_name field containing given names
email	email	high	Top-level email field containing valid email addresses
zip	zip	high	Postal code field in addresses array
total_spent	skip	high	Financial transaction data
address2	address2	high	Secondary address/apartment field in addresses array
address1	address1	high	Street address field in addresses array
email_marketing_consent	skip	high	Consent metadata
last_name	lastName	high	Top-level last_name field containing family names
verified_email	skip	high	Boolean flag
tags	skip	high	Internal tagging system
country_code	skip	high	ISO country code (IN), not a distinct PII field
orders_count	skip	high	Transactional metadata
sms_marketing_consent	skip	high	Consent metadata
phone	phone	high	Top-level phone field (mostly null in sample but present in structure)
name	skip	high	Concatenated full name already captured via first_name/last_name

Notes: Shopify customer export structure from boAt Lifestyle breach. Addresses are nested in 'addresses' array and 'default_address' object. 'province' field contains Indian state names and maps to state PII field. Phone numbers appear in addresses array with higher frequency than top-level phone field. All address components (address1, address2, city, province, zip, country) are consistently present in nested address objects. No password, username, DOB, SSN, gender, or generational name suffixes found in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_6_20240303190800.json

13 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (e.g., 689101, 530046)
country	country	high	Country field consistently shows 'India'
address2	address2	high	Secondary address field; typically null in these records
city	city	high	City names (e.g., PATHANAMTHITTA, VISAKHAPATNAM)
address1	address1	high	Street address field within addresses array
last_name	lastName	medium	Contains last names but frequently null or placeholder values like '.'
province_code	skip	high	ISO state code (KL, AP); not a PII field
country_code	skip	high	ISO country code (IN); not a PII field
province	state	high	Province/state names (e.g., Kerala, Andhra Pradesh)
phone	phone	high	Phone numbers in international format (e.g., +916282786071) and local format
country_name	skip	high	Duplicate of country field; redundant
first_name	firstName	high	Contains first names; some records show full names in this field
email	email	high	Standard email field with valid email addresses

Notes: Data structure is Shopify customer export. Names are sometimes split between first_name and last_name, but first_name occasionally contains full name (e.g., 'Kessia Benny'). Address data is nested within 'addresses' array and also duplicated in 'default_address' object. Phone numbers appear in both top-level and address-nested formats. No SSN, password, username, DOB, gender, middleName, suffix, or honorific fields present in the sample. The 'name' field within address objects is a computed fullName and should not be separately mapped.

BoAtLifestyleIndia__data__shopify_customers_partial_6_20240304191450.json

25 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field in nested addresses object
city	city	high	City field in nested addresses object
created_at	skip	high	Metadata timestamp
province_code	skip	high	ISO province code, not PII; derivative of state field
province	state	high	Province/state field in nested addresses object (Indian states)
updated_at	skip	high	Metadata timestamp
currency	skip	high	Transaction metadata
id	skip	high	Internal customer ID, not PII
state	skip	high	Account state (enabled/disabled), not geographic state
first_name	firstName	high	Consistent first name field across records
email	email	high	Direct email addresses present in all records
zip	zip	high	Postal code in nested addresses object
total_spent	skip	high	Transaction metadata
last_order_id	skip	high	Order metadata
address2	address2	high	Secondary address line in nested addresses object
tax_exempt	skip	high	Account flag, not PII
address1	address1	high	Primary street address in nested addresses object
last_name	lastName	high	Consistent last name field across records
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Account metadata
country_code	skip	high	ISO country code, not PII; derivative of country field
orders_count	skip	high	Order metadata
phone	phone	high	Phone number field at top level, though often null
admin_graphql_api_id	skip	high	Internal system identifier
name	skip	high	Duplicate of first_name + last_name; redundant

Notes: Data is nested with top-level customer fields and a nested 'addresses' array containing address details. All PII fields identified map to standard e-commerce customer data. The 'phone' field at top level is frequently null; phone data is reliably present in nested address objects. The 'state' field at top level refers to account status (enabled/disabled), not geographic location; geographic state data is in nested 'province' field. Breach context confirms customer PII including emails, names, phones, and addresses were exfiltrated from boAt Lifestyle Shopify Plus store.

BoAtLifestyleIndia__data__shopify_customers_partial_70_20240304135553.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
total_spent	skip	high	Transaction amount, not PII
addresses.phone	phone	high	Phone numbers consistently populated in nested address objects
addresses.province_code	skip	high	State/province ISO code, metadata
last_name	lastName	high	Top-level last_name field containing family names
created_at	skip	high	Timestamp, not PII
addresses.country_code	skip	high	Country ISO code, metadata
addresses.city	city	high	City field in nested address objects
verified_email	skip	high	Boolean flag, not PII
addresses.company	skip	high	Company name, not core PII in this schema
addresses.address2	address2	high	Secondary address line (apartment, suite, etc.) in nested address objects
orders_count	skip	high	Numeric metadata, not PII
addresses.address1	address1	high	Primary street address in nested address objects
updated_at	skip	high	Timestamp, not PII
phone	phone	medium	Top-level phone field, though mostly null in sample; phone data present in addresses
addresses.zip	zip	high	Postal code field in nested address objects
addresses.country	country	high	Country field in nested address objects
id	skip	high	Customer ID, non-PII identifier
state	skip	high	Account status field (e.g., 'disabled'), not geographic state
first_name	firstName	high	Top-level first_name field containing given names
email	email	high	Top-level email field containing email addresses
addresses.province	state	high	Province/state field in nested address objects (Indian states like Tamil Nadu, Madhya Pradesh)

Notes: Data structure is Shopify customer export format with nested address objects. Phone numbers are primarily found in addresses array rather than top-level phone field. Top-level 'last_name' field sometimes contains only '.' (placeholder for missing data). Use nested address phone field as primary source. Country consistently 'India', confirming breach context. No password, SSN, DOB, username, or other sensitive fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_70_20240305160846.json

37 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field; contains 'India'
note	skip	high	Admin notes field
addresses	skip	high	Array container (individual fields mapped above)
last_order_name	skip	high	Order reference
city	city	high	City field in nested address objects
created_at	skip	high	Timestamp, not PII mapping
multipass_identifier	skip	high	Shopify internal identifier
province_code	skip	high	State abbreviation code
default	skip	high	Boolean flag for default address
default_address	skip	high	Nested object structure (addresses already mapped)
province	state	high	Province maps to state field; Indian states like West Bengal, Karnataka, Delhi
updated_at	skip	high	Timestamp, not PII mapping
country_name	skip	high	Redundant country field
currency	skip	high	Currency code
company	skip	high	Company name, optional
id	skip	high	Internal database identifier
state	skip	high	Account state (enabled/disabled), not geographic state
first_name	firstName	high	Top-level first_name field contains given names
email	email	high	Top-level email field contains valid email addresses
zip	zip	high	Postal code field in nested address objects
total_spent	skip	high	Transactional data
last_order_id	skip	high	Order identifier
address2	address2	high	Secondary address/apartment field in nested address objects
tax_exempt	skip	high	Account flag
address1	address1	high	Street address field in nested address objects
email_marketing_consent	skip	high	Consent metadata object
last_name	lastName	high	Top-level last_name field contains family names
verified_email	skip	high	Boolean flag
tags	skip	high	Customer tags/categories
orders_count	skip	high	Transactional metadata
country_code	skip	high	Country code (IN)
sms_marketing_consent	skip	high	Consent metadata object
phone	phone	high	Top-level phone field, though mostly null in sample; phone data present in addresses
admin_graphql_api_id	skip	high	GraphQL API identifier
name	fullName	medium	Combined first and last name in address objects
tax_exemptions	skip	high	Empty array, account metadata
customer_id	skip	high	Internal identifier

Notes: Shopify customer export from boAt Lifestyle breach (March 2024). Address data is nested within 'addresses' array and 'default_address' object. The 'province' field contains Indian state names and maps to 'state'. The 'phone' field at top level is mostly null; actual phone numbers are in nested address objects. No SSN, DOB, password, username, gender, middleName, suffix, or dob fields present in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_71_20240304141633.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	In addresses array, postal codes
total_spent	skip	high	Order history, not PII
country	country	high	In addresses array, contains country names (India)
address2	address2	high	In addresses array, street address line 2 (secondary address info)
city	city	high	In addresses array, city names
address1	address1	high	In addresses array, street address line 1
last_name	lastName	high	Consistently contains last names (patil, BORICHA, Ahmed)
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Verification flag, not PII
province_code	skip	high	ISO state code, not a PII field type
tags	skip	high	Metadata tags, not PII
country_code	skip	high	ISO country code, not a PII field type
orders_count	skip	high	Order metrics, not PII
province	state	high	In addresses array, province/state names (Gujarat, Assam)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Top-level phone field contains phone numbers (sparse in top level, present in addresses)
name	skip	high	Duplicate of first_name + last_name; use discrete fields instead
currency	skip	high	Transaction metadata, not PII
company	skip	high	Business field, not personal PII
id	skip	high	System identifier, not PII
state	skip	high	Account state flag, not PII
first_name	firstName	high	Consistently contains first names (Akshay, AMIT, Saifuddin)
email	email	high	Top-level email field contains email addresses across all records

Notes: Data structure contains nested 'addresses' array with detailed address components. Phone numbers appear primarily within addresses array rather than top-level phone field. The 'name' field duplicates first_name+last_name and should not be used; discrete fields are preferred. Country field maps to 'country' not 'address' component. Province field in addresses array maps to 'state' PII field. No SSN, password, username, DOB, gender, middleName, suffix, or generational suffixes detected in first 50 records.

BoAtLifestyleIndia__data__shopify_customers_partial_71_20240305162855.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in nested addresses
country	country	high	Country field in nested addresses
province	state	high	State/province field in nested addresses
phone	phone	high	Phone numbers in addresses nested objects
address2	address2	high	Secondary address line in nested addresses
city	city	high	City field in nested addresses
address1	address1	high	Primary address line in nested addresses
last_name	lastName	high	Explicit last name field
first_name	firstName	high	Explicit first name field
email	email	high	Direct email addresses present in all records

Notes: Data structure is Shopify customer export. Top-level 'phone' field is null in all records; phone numbers are only present in nested 'addresses' array objects. The 'name' field in addresses is a concatenated fullName (firstName + lastName) and should not be separately mapped. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state', 'total_spent', 'verified_email', 'tax_exempt', 'tags', 'currency', 'email_marketing_consent', 'admin_graphql_api_id' are metadata/non-PII and mapped to skip. The 'province_code' and 'country_code' are codes for state and country respectively and should not be separately mapped.

BoAtLifestyleIndia__data__shopify_customers_partial_72_20240304143622.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array objects
total_spent	skip	high	Transaction metric, not PII
country	country	high	Country field within addresses array objects
address2	address2	high	Secondary address field within addresses array objects
city	city	high	City field within addresses array objects
tax_exempt	skip	high	Boolean flag, not PII
address1	address1	high	Street address field within addresses array objects
last_name	lastName	high	Explicitly labeled last names
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	ISO state code, not PII by itself
tags	skip	high	Internal tagging/categorization
country_code	skip	high	ISO country code, not PII by itself
orders_count	skip	high	Behavioral metric, not PII
province	state	high	State/province field within addresses array objects (Indian states like Assam)
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone numbers in E.164 format and local formats
currency	skip	high	Currency preference, not PII
company	skip	high	Company name (optional, not core PII in breach context)
id	skip	high	Internal Shopify customer ID, not traditional PII
state	skip	high	Account status flag, not PII
first_name	firstName	high	Explicitly labeled first names
email	email	high	Direct email addresses present in all records

Notes: Data structure is Shopify customer export format. Address information is nested within 'addresses' array and 'default_address' object; map array/object fields using same column names. Phone field at root level and within address objects. Name appears concatenated in 'name' field within addresses; prefer granular first_name/last_name fields. Breach confirmed to include emails, names, phone, addresses per breach context.

BoAtLifestyleIndia__data__shopify_customers_partial_72_20240305164859.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested address objects
country	country	high	Country field in nested address objects
province	state	high	State/province field in nested address objects
phone	phone	high	Phone number field at customer level; also present in nested address objects
address2	address2	high	Secondary address line in nested address objects
city	city	high	City field in nested address objects
address1	address1	high	Primary street address in nested address objects
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email field present in all records

Notes: Shopify customer export from boAt Lifestyle breach. Top-level 'phone' field is often null; actual phone numbers appear in nested 'addresses' array objects. Customer names also duplicated in address objects. 'province_code' and 'country_code' are country/state abbreviations (non-PII metadata). Fields like 'id', 'created_at', 'updated_at', 'state' (enabled/disabled/invited), 'orders_count', 'total_spent', 'verified_email', 'currency', 'tags', 'email_marketing_consent', 'sms_marketing_consent', and 'admin_graphql_api_id' are operational metadata or system fields → skip. No SSN, DOB, password, username, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_73_20240304145651.json

28 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
country	country	high	Country field within addresses array objects
note	skip	high	Admin notes, not PII
city	city	high	City field within addresses array objects
created_at	skip	high	Timestamp, not a PII field type
province_code	skip	high	ISO state code, not a PII field type in available options
default	skip	high	Boolean flag for default address, not PII
province	state	high	Province/state field within addresses array objects (Indian context uses 'province' for state)
updated_at	skip	high	Timestamp, not a PII field type
currency	skip	high	Currency code, not PII
company	skip	high	Company name within address, not in available PII field types
id	skip	high	Customer ID, not a PII field type in available options
state	skip	high	Account state (enabled/disabled), not address state; distinct from province/state PII
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Top-level email field with valid email addresses or email-like identifiers
zip	zip	high	Postal code field within addresses array objects
total_spent	skip	high	Transaction data, not PII
last_order_id	skip	high	Order metadata, not PII
address2	address2	high	Secondary address field within addresses array objects
tax_exempt	skip	high	Account attribute, not PII
address1	address1	high	Street address field within addresses array objects
last_name	lastName	high	Explicitly named last_name field containing family names
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Account tags/metadata, not PII
country_code	skip	high	ISO country code, not a PII field type in available options
orders_count	skip	high	Order metadata, not PII
phone	phone	high	Top-level phone field, though often null; addresses array contains populated phone values
name	fullName	high	Full name field within addresses array objects
customer_id	skip	high	Foreign key reference, not PII

Notes: Data structure is Shopify customer export with nested addresses array. Top-level phone field is often null; actual phone numbers are in addresses[].phone. The 'name' field in addresses is a concatenated fullName. Province field maps to state (Indian administrative divisions). Breach context confirms this is boAt Lifestyle Shopify Plus store data containing customer PII as described.

BoAtLifestyleIndia__data__shopify_customers_partial_73_20240305170957.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested in addresses; postal code
country	country	high	Nested in addresses; country name
province	state	high	Nested in addresses; Indian state/province names (Maharashtra, Jharkhand, etc.)
phone	phone	high	Top-level phone field (mostly null in sample, but present in nested addresses)
address2	address2	high	Nested in addresses; secondary address details
city	city	high	Nested in addresses; city name
address1	address1	high	Nested in addresses; primary street address
name	fullName	high	Nested in addresses; concatenated full name (e.g., 'Abhishek Tomar')
last_name	lastName	high	Top-level last_name field with surnames
first_name	firstName	high	Top-level first_name field with given names
email	email	high	Top-level email field containing valid email addresses

Notes: Data structure is Shopify customer export format with nested address objects. Phone number appears both at top level (mostly null) and within address objects. The 'name' field in addresses represents fullName. Province codes and country codes present but mapped to standard state/country fields. No SSN, DOB, password, username, gender, or suffix fields detected in sample. No honorific prefixes or generational suffixes present.

BoAtLifestyleIndia__data__shopify_customers_partial_74_20240305172940.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes (e.g., 454775, 421503, 110091)
country	country	high	Country field contains country names (e.g., India)
province	state	high	State/province field contains regional codes (e.g., Madhya Pradesh, Maharashtra, Delhi)
phone	phone	high	Top-level phone field contains phone numbers (e.g., +918384055264)
address2	address2	high	Secondary address line, apartment/locality details (e.g., Padam sree Sanjay vihar)
city	city	high	City names (e.g., Pithampur, Badlapur, East Delhi)
address1	address1	high	Street address, primary address line (e.g., Sagor kuti, House no 207)
last_name	lastName	high	Contains family names (e.g., Chaurasiya, bubere, Singh)
first_name	firstName	high	Contains given names (e.g., Tulsi, arbaz, Shivani)
email	email	high	Consistently contains email addresses across all records (e.g., [email protected])

Notes: This is a Shopify Plus customer export from the boAt Lifestyle breach. Addresses are nested within an 'addresses' array and also appear in 'default_address'. Phone numbers appear both at the top level and within address records. The 'name' field within addresses is a concatenation of first_name and last_name and was not mapped as a separate field. Fields like 'id', 'created_at', 'orders_count', 'total_spent', 'verified_email', 'tags', 'currency', 'company', 'province_code', 'country_code', 'default', and administrative/API fields were not mapped as they are not PII field types in the available list.

BoAtLifestyleIndia__data__shopify_customers_partial_75_20240305174819.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in Indian format (444201, 413304, 781009)
country	country	high	Country field consistently shows 'India'; country_code shows 'IN'
province	state	high	Indian state/province names (Maharashtra, Assam); 'province' is the key name in nested address objects
phone	phone	high	Contains phone numbers in Indian format (7391867113, 74982 19103, 8486136187); null when not provided
address2	address2	high	Secondary address line in nested address objects (apartment, suite, etc.)
city	city	high	City names consistently present (Paturda, Pandharpur, Guwahati)
address1	address1	high	Primary street address line in nested address objects
last_name	lastName	high	Consistently contains last names (gadak, Chop, Badave, Sil)
first_name	firstName	high	Consistently contains first names (sunil, Shiv, Atish, Bijoy)
email	email	high	Consistent email addresses across all records matching standard email format

Notes: Data structure includes nested address objects under 'addresses' array and 'default_address' object. Phone field is at root level (mostly null) and also appears in nested address objects (populated). Top-level 'province' field does not exist; state/province data only appears in nested address objects. No password, username, SSN, DOB, gender, suffix, or middleName fields detected in provided records. The 'name' field in nested objects is a concatenation of first_name and last_name.

BoAtLifestyleIndia__data__shopify_customers_partial_76_20240305180627.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in nested addresses object
country	country	high	Country field in nested addresses object
province	state	high	State/province field in nested addresses object
phone	phone	high	Phone number field at customer level (though often null, present in addresses)
address2	address2	high	Secondary address field in nested addresses object
city	city	high	City field in nested addresses object
address1	address1	high	Primary street address field in nested addresses object
name	fullName	high	Complete name field present in nested addresses object
last_name	lastName	high	Explicit last name field
first_name	firstName	high	Explicit first name field
email	email	high	Direct email addresses present in all records

Notes: Data structure is Shopify customer export with nested addresses array. Phone numbers primarily located in addresses.phone rather than top-level phone field. All records are from India (boAt Lifestyle Indian customer base). Fields id, created_at, updated_at, orders_count, state, total_spent, verified_email, tax_exempt, currency, email_marketing_consent are metadata/operational fields (mapped to skip). No password, username, DOB, SSN, gender, or suffix fields present in sample.

BoAtLifestyleIndia__data__shopify_customers_partial_77_20240305182446.json

21 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field in addresses array objects
total_spent	skip	high	Transaction summary, not PII
country	country	high	Country field in addresses array objects
address2	address2	high	Secondary address line found in addresses array objects
city	city	high	City field in addresses array objects
tax_exempt	skip	high	Boolean flag, not PII
address1	address1	high	Primary address line found in addresses array objects
last_name	lastName	high	Explicit last name field at customer record level
created_at	skip	high	Timestamp metadata, not PII
verified_email	skip	high	Boolean flag, not PII
province_code	skip	high	State code abbreviation, not a PII field type
country_code	skip	high	ISO country code, not a PII field type
orders_count	skip	high	Transaction metadata, not PII
province	state	high	Province/state field in addresses array objects (Indian states)
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	high	Phone field at customer record level (null in most top-level records, populated in addresses)
company	skip	high	Business field, not in available PII types
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status flag, not PII
first_name	firstName	high	Explicit first name field at customer record level
email	email	high	Standard email field containing valid email addresses

Notes: Shopify customer data export. Phone numbers appear primarily in nested addresses array rather than top-level phone field. Province field used for Indian states. Country consistently 'India' (IN). Name field in addresses array is concatenation of first_name + last_name, not mapped separately. All records follow consistent Shopify customer schema structure.

BoAtLifestyleIndia__data__shopify_customers_partial_78_20240305184316.json

23 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code in addresses array
total_spent	skip	high	Purchase history metadata, not PII
country	country	high	In addresses array, contains country name 'India'
address2	address2	high	Secondary address/apt/building info in addresses array
city	city	high	City/locality in addresses array
address1	address1	high	Primary street address in addresses array
last_name	lastName	high	Consistently contains last names across all records
created_at	skip	high	Timestamp metadata, not PII
verified_email	skip	high	Boolean verification flag, not PII
province_code	skip	high	State code abbreviation (KA, JH), not a PII field type
country_code	skip	high	Country code abbreviation (IN), not a PII field type
orders_count	skip	high	Transaction metadata, not PII
province	state	high	In addresses array, maps to state/province field
updated_at	skip	high	Timestamp metadata, not PII
phone	phone	high	Top-level phone field (though often null, when present contains phone numbers)
name	fullName	high	In addresses array, concatenated full name (first + last)
country_name	skip	high	Duplicate of country field, skip redundant entry
currency	skip	high	Currency code metadata, not PII
company	skip	high	Company field not in available PII types
id	skip	high	Internal customer ID, not PII
state	skip	high	Account status (enabled/disabled), not address state or PII
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Top-level email field containing email addresses matching breach context

Notes: Shopify Plus customer export structure. The 'addresses' array is a nested structure containing address details. The 'default_address' field is a denormalized copy of the primary address and maps to the same PII fields as the addresses array entries. The 'name' field within addresses is a concatenated fullName. Top-level 'phone' field is often null; phone data is primarily found in the addresses array. The breach context confirms this is customer PII data (emails, names, phone, addresses, order history).

BoAtLifestyleIndia__data__shopify_customers_partial_7_20240303192335.json

19 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal codes in Indian format (6 digits)
total_spent	skip	high	Purchase history metadata
country	country	high	Country field indicating India
address2	address2	high	Secondary address field (null or empty in provided records)
city	city	high	City names in addresses array and default_address
address1	address1	high	Street address information in addresses array and default_address
last_name	lastName	high	Consistently contains last names or null values
created_at	skip	high	Timestamp metadata
verified_email	skip	high	Boolean flag, not PII
tags	skip	high	Marketing tags and internal notes
country_code	skip	high	ISO country code, not PII
orders_count	skip	high	Order statistics
province	state	high	Indian states/provinces (Maharashtra, Delhi) in addresses
updated_at	skip	high	Timestamp metadata
phone	phone	high	Phone numbers in international format (+91...) and local format
id	skip	high	Internal Shopify customer ID, not PII
state	skip	high	Account status (enabled/disabled), not state/province
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Standard email field containing valid email addresses

Notes: Breach context confirms Shopify Plus customer data. Address data is nested within 'addresses' array and 'default_address' object. The 'province' field contains Indian state names and should map to 'state' PII field. The 'country' field is always 'India' or country code 'IN'. Phone numbers appear both at customer level and within address records. No SSN, password, username, DOB, gender, or suffix fields present in provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_7_20240304193511.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal/ZIP code in nested address objects
country	country	high	Country field in nested address objects
province	state	high	Province/state field in nested address objects (Indian states like Maharashtra, Karnataka)
phone	phone	high	Top-level phone field (typically null); phone numbers also appear in nested address objects
address2	address2	high	Secondary address line (apt/unit) in nested address objects
city	city	high	City name in nested address objects
address1	address1	high	Street address - primary address line in nested address objects
name	fullName	high	Pre-computed full name in nested address objects (e.g., 'Kunal Saini')
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email field present in all records with valid email addresses

Notes: Data structure is Shopify customer export. Address information is nested within 'addresses' array and 'default_address' object. Top-level 'phone' field is present but typically null; actual phone numbers are in nested address objects. The 'province' field in addresses should map to 'state'. All records are from India (country_code: 'IN'). No passwords, SSNs, DOBs, usernames, gender, or suffix fields are present in the provided records.

BoAtLifestyleIndia__data__shopify_customers_partial_8_20240303193829.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array
country	country	high	Country field within addresses array; all values are 'India'
province	state	high	State/province field within addresses array
phone	phone	high	Phone field at customer level; contains phone numbers when populated
address2	address2	high	Secondary/apartment address field within addresses array
city	city	high	City field within addresses array
address1	address1	high	Primary street address field within addresses array
last_name	lastName	high	Consistently contains last names across all records
first_name	firstName	high	Consistently contains first names across all records
email	email	high	Direct email field present in all records

Notes: The data structure contains nested address objects within the main customer record. Phone numbers appear both at the customer level (often null) and within address objects (populated). State information is labeled 'province' in the JSON but represents state/province. Country code ('country_code': 'IN') and province code ('province_code': 'RJ') are present but mapped to skip as they are codes rather than PII values. No SSN, DOB, password, username, gender, middleName, or suffix fields are present in the sample data.

BoAtLifestyleIndia__data__shopify_customers_partial_8_20240304195558.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Zip code field in nested addresses objects
country_code	country	medium	Country code field available in addresses (e.g., 'IN' for India)
province	state	high	Province field maps to state (Indian administrative division)
phone	phone	high	Phone field with international format (+91 country code for India)
address2	address2	high	Secondary address field in nested addresses objects
city	city	high	City field in nested addresses objects
address1	address1	high	Street address field in nested addresses objects
last_name	lastName	high	Explicit last_name field consistently populated across records
first_name	firstName	high	Explicit first_name field consistently populated across records
email	email	high	Direct email field present in all records with valid email addresses

Notes: This is a Shopify Plus customer export from boAt Lifestyle. Customer data is structured with top-level fields (email, first_name, last_name, phone) and nested address objects. The 'province' field contains state information for Indian addresses. Many records have null values for phone and incomplete address data. The 'name' field in addresses is a concatenation of first_name and last_name and should not be separately mapped. No PII fields for SSN, password, username, DOB, gender, middleName, or suffix were identified in the sample.

BoAtLifestyleIndia__data__shopify_customers_partial_9_20240303195309.json

10 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Nested within addresses array; postal code (e.g., 201303, 635107)
country	country	high	Nested within addresses array; country name (India) and country_code (IN)
province	state	high	Nested within addresses array; state/province (e.g., Uttar Pradesh, Tamil Nadu). Note: also contains province_code (UP, TN) as abbreviation
phone	phone	high	Top-level field with phone numbers in E.164 format (e.g., +919026875233) or domestic format (7505609274)
address2	address2	high	Nested within addresses array; secondary address line (e.g., Plot No. 6)
city	city	high	Nested within addresses array; city name (e.g., Noida, Krishnagiri)
address1	address1	high	Nested within addresses array; primary street address (e.g., Tech Boulevard Sector 127)
last_name	lastName	high	Top-level field containing last names (e.g., Joshi, Singh, Rana); null when not provided
first_name	firstName	high	Top-level field containing first names (e.g., Samarth Verma, Vinod, Shivani, Sameer)
email	email	high	Consistently contains email addresses across all records (e.g., [email protected], [email protected])

Notes: This is a Shopify customer dataset. The structure includes both top-level and nested address fields. Phone numbers appear in both top-level (sparse, some null) and nested address contexts. The 'name' field within addresses is a concatenation of first_name and last_name and should not be mapped separately (it duplicates firstName/lastName). No DOB, SSN, password, username, gender, or suffix fields are present in the provided records. The 'state' field at top level refers to account state (enabled/disabled), not geographic state—map only the nested 'province' to the state PII field.

BoAtLifestyleIndia__data__shopify_customers_partial_9_20240304201653.json

11 columns50,000 rows

File structure

Source column	Mapped field	Confidence	LLM assessment
zip	zip	high	Postal code field within addresses array
country	country	high	Country field within addresses array
province	state	high	Province/state field within addresses array; Shopify uses 'province' for state equivalent
phone	phone	high	Phone field at customer level (though mostly null, populated in addresses)
address2	address2	high	Secondary address field (apartment, unit, etc.) within addresses array
city	city	high	City field within addresses array
address1	address1	high	Primary street address field within addresses array
name	fullName	high	Pre-formatted full name field within addresses array (e.g., 'mayur karbhari')
last_name	lastName	high	Explicitly named last_name field containing family names
first_name	firstName	high	Explicitly named first_name field containing given names
email	email	high	Standard email field with valid email addresses

Notes: Data structure is Shopify customer export format with nested addresses array. Phone numbers appear both at top level (mostly null) and within address objects (populated). The 'name' field in address objects contains the concatenated full name. Country is standardized to 'India' across all visible records. Province field uses state abbreviations (MH, AP, etc.) in province_code subfield. No PII fields found for: dob, ssn, password, username, gender, suffix, or middleName. Fields like 'id', 'created_at', 'updated_at', 'orders_count', 'state' (enabled/disabled), 'total_spent', 'verified_email', 'tax_exempt', 'tags', 'company' are metadata/operational and mapped to 'skip'.

Data found in this dataset

Search this dataset

Source files

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure

File structure