Fixture data — no backend, nothing is saved.
messy-customers.csv
40 rows · 8 columns · 97.2% complete
0 of 47 suggestions reviewed
Possible duplicates
6 pending · 0 resolved
Every identifying field matches exactly; the name differs only in diacritics. Same customer entered twice.
Detected because: Same email, phone, signup date and revenue as row 1; name differs only by accents ("Ana María" vs "Ana Maria").
- customer_id
- 1039
- full_name
- Ana Maria Torres
- ana.torres@example.com
- phone
- (555) 010-2233
- signup_date
- 2024-01-05
- country
- Mexico
- revenue
- 1240.50
- status
- active
Shared email address plus identical revenue. The differing phone and date formats are the same values written differently.
Detected because: Same email and revenue as row 2; name differs by one accent ("Ruiz" vs "Ruíz").
- customer_id
- 1003
- full_name
- Carlos Ruíz
- carlos.ruiz@example.com
- phone
- 5550104411
- signup_date
- 05/02/2024
- country
- Mexico
- revenue
- 890.00
- status
- active
"exmaple.com" is a keyboard transposition of "example.com". Same phone number and revenue confirm it is one customer.
Detected because: Same phone and revenue as row 7; email domain differs by a transposition.
- customer_id
- 1008
- full_name
- priya nair
- priya.nair@exmaple.com
- phone
- 555 010 3344
- signup_date
- 11/03/2024
- country
- india
- revenue
- 3420.00
- status
- active
"ONeill" is "O'Neill" with the apostrophe stripped. All other identifying fields match.
Detected because: Same email, phone and revenue as row 20; name differs by an apostrophe.
- customer_id
- 1021
- full_name
- Sam ONeill
- sam.oneill@example.com
- phone
- 5550107744
- signup_date
- 09/09/2024
- country
- ireland
- revenue
- 1130.90
- status
- active
Strong field overlap, but a one-letter name difference can also be two siblings sharing a household record. Below the bulk-accept threshold on purpose.
Detected because: Same email, phone and revenue as row 28; name differs by one letter ("Isabella" vs "Isabela").
- customer_id
- 1029
- full_name
- Isabela Silva
- isabella.silva@example.com
- phone
- (555) 010-2255
- signup_date
- 2024-12-18
- country
- brazil
- revenue
- 2470.30
- status
- active
Nowak and Novak are distinct, common Polish surnames. The shared email is suggestive but not conclusive — needs a human.
Detected because: Same email, phone and revenue as row 14; surname differs ("Nowak" vs "Novak").
- customer_id
- 1015
- full_name
- Marta Novak
- marta.nowak@example.com
- phone
- +48 555 010 6677
- signup_date
- 2024-06-15
- country
- Poland
- revenue
- 2340.10
- status
- active
47 left