MySQL · Chinook
Customer
- Source rows
- 59
- Synthetic rows
- 59
- Broken foreign keys
- 0
- Rows equal to a source row
- 0%
References: SupportRepId → Employee
Rows
Both databases, first rows by primary key, in one table: scrolling sideways moves them together. Rows at the same position are unrelated, unless the table holds kept reference data. Long values are cut at 60 characters.
| CustomerId key | FirstName | LastName | Company | Address | City | State | Country | PostalCode | Phone | Fax | SupportRepId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source database · 12 of 59 rows | ||||||||||||
| 1 | Luís | Gonçalves | Embraer - Empresa Brasileira de Aeronáutica S.A. | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | +55 (12) 3923-5555 | +55 (12) 3923-5566 | luisg@embraer.com.br | 3 |
| 2 | Leonie | Köhler | NULL | Theodor-Heuss-Straße 34 | Stuttgart | NULL | Germany | 70174 | +49 0711 2842222 | NULL | leonekohler@surfeu.de | 5 |
| 3 | François | Tremblay | NULL | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | +1 (514) 721-4711 | NULL | ftremblay@gmail.com | 3 |
| 4 | Bjørn | Hansen | NULL | Ullevålsveien 14 | Oslo | NULL | Norway | 0171 | +47 22 44 22 22 | NULL | bjorn.hansen@yahoo.no | 4 |
| 5 | František | Wichterlová | JetBrains s.r.o. | Klanova 9/506 | Prague | NULL | Czech Republic | 14700 | +420 2 4172 5555 | +420 2 4172 5555 | frantisekw@jetbrains.com | 4 |
| 6 | Helena | Holý | NULL | Rilská 3174/6 | Prague | NULL | Czech Republic | 14300 | +420 2 4177 0449 | NULL | hholy@gmail.com | 5 |
| 7 | Astrid | Gruber | NULL | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | NULL | Austria | 1010 | +43 01 5134505 | NULL | astrid.gruber@apple.at | 5 |
| 8 | Daan | Peeters | NULL | Grétrystraat 63 | Brussels | NULL | Belgium | 1000 | +32 02 219 03 03 | NULL | daan_peeters@apple.be | 4 |
| 9 | Kara | Nielsen | NULL | Sønder Boulevard 51 | Copenhagen | NULL | Denmark | 1720 | +453 3331 9991 | NULL | kara.nielsen@jubii.dk | 4 |
| 10 | Eduardo | Martins | Woodstock Discos | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | +55 (11) 3033-5446 | +55 (11) 3033-4564 | eduardo@woodstock.com.br | 4 |
| 11 | Alexandre | Rocha | Banco do Brasil S.A. | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | +55 (11) 3055-3278 | +55 (11) 3055-8131 | alero@uol.com.br | 5 |
| 12 | Roberto | Almeida | Riotur | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | +55 (21) 2271-7000 | +55 (21) 2271-7070 | roberto.almeida@riotur.gov.br | 3 |
| Synthetic database · 12 of 59 rows | ||||||||||||
| 1 | Sophia | Kelley | NULL | 88 rue Gambetta, Minimes, Brussels | Brussels | NT | Canada | 9972 | +1 (571) 466-2955 | NULL | sophia.kelley211@stonegate.test | 4 |
| 2 | Nora | Taylor | JetBrains s.r.o. | 2 rue de la République, Saint-Pierre, Bordeaux | Bordeaux | FL | Italy | 33011 | +1 (224) 950-3817 | +55 119 060 85139 | nora.taylor187@inbox.pineledger.example | 2 |
| 3 | Kyle Liam | Turner | NULL | 3 rue de la République, Belleville, Paris | Paris | NY | France | 75012 | +17 05 906 27 44 | NULL | kyleliam.turner365@northwind.test | 7 |
| 4 | Nathan | Anderson | NULL | 4 Church Oakwood, Evanston, Chicago | Chicago | NULL | Japan | 60613 | +17 24 660 43 80 | NULL | nathan.anderson409@notes.example | 2 |
| 5 | Jack | Warren | Microsoft Corporation | 16 Church Oakwood, Bronx, Vancouver | Vancouver | UT | Canada | 48936 | +1 (321) 859-8330 | +55 519 301 84484 | jack.warren361@redkite.test | 2 |
| 6 | Laura Mason | Evans | NULL | 42 Church West End, Downtown, Salt Lake City | Salt Lake City | NULL | Japan | 52005-400 | +1 (319) 963-9617 | NULL | lauramason.evans357@brightloft.test | 4 |
| 7 | Liam Emma | Thomas | NULL | Calle del Prado, 142, Los Remedios, Copenhagen | Copenhagen | NULL | Italy | NULL | +1 (240) 563-5532 | NULL | liamemma.thomas40@quietdesk.test | 7 |
| 8 | Ryan | Rose | NULL | Hauptstraße 147, Neukölln, Prague | Prague | NULL | Czech Republic | 7697 | +1 (859) 218-3839 | NULL | ryan.rose600@pineledger.test | 4 |
| 9 | Detlef | Vasquez | NULL | 66 Church West End, Etobicoke, Winnipeg | Winnipeg | NULL | Brazil | HH0 4SA | +1 (680) 647-4708 | NULL | detlef.vasquez321@quietdesk.test | 7 |
| 10 | Emily | Myers | NULL | 10 Park Oakwood, Scarborough, Toronto | Toronto | NSW | Portugal | 519 | +19 00 704 70 26 | NULL | emily.myers285@stonegate.test | 7 |
| 11 | Ian | Rivera | NULL | Calle Mayor, 109, Salamanca, Prague | Prague | NT | Germany | 32215-084 | +1 (860) 935-3120 | NULL | ian.rivera212@bluefinch.example | 7 |
| 12 | Jak | Stewart | NULL | 73 King Central, Staten Island, Halifax | Halifax | NULL | Brazil | EB4 2HN | +16 228 588 989 | NULL | jak.stewart344@posta.mavisaha.test | 7 |
Column by column
Each figure is computed from all rows of both databases in the same way. S is the source, Y the synthetic copy. Difference runs from 0 (same distribution) to 1 (no overlap): Kolmogorov-Smirnov for numbers and times, total variation for columns with few values. Personal columns are meant to differ, so they show how many values also appear in the source instead. Lyrebird draws names from built-in lists, not from the source, so common names can match.
| Column | Model read it as | How it was generated | Empty | Distinct | Range or length | Most common | Difference |
|---|---|---|---|---|---|---|---|
| CustomerIdint | record key | New key values | S 0% Y 0% | S 59 Y 59 | S 1 → 59 Y 1 → 59 | S 1 1.7% · 2 1.7% · 3 1.7% · 4 1.7% · 5 1.7% · 6 1.7% Y 1 1.7% · 2 1.7% · 3 1.7% · 4 1.7% · 5 1.7% · 6 1.7% | — |
| FirstNamevarchar(40) | first namepersonal | New text in the measured format | S 0% Y 0% | S 57 Y 49 | S 5.8 chars avg Y 6.1 chars avg | S Mark 3.4% · Frank 3.4% · Luís 1.7% · Leonie 1.7% · François 1.7% · Bjørn 1.7% Y Julia 5.1% · Sophia 3.4% · Nathan 3.4% · Jack 3.4% · Liam Emma 3.4% · James 3.4% | 16.9% in source |
| LastNamevarchar(20) | last namepersonal | New text in the measured format | S 0% Y 0% | S 59 Y 49 | S 6.9 chars avg Y 5.9 chars avg | S Gonçalves 1.7% · Köhler 1.7% · Tremblay 1.7% · Hansen 1.7% · Wichterlová 1.7% · Holý 1.7% Y Anderson 5.1% · Thomas 3.4% · Rivera 3.4% · Alexander 3.4% · Kelly 3.4% · Clark 3.4% | 3.4% in source |
| Companyvarchar(80) | company name | Source values, at measured frequencies | S 83.05% Y 83.05% | S 10 Y 7 | S 16.6 chars avg Y 14 chars avg | S Embraer - Empresa Brasileira de Aeronáu… 10% · JetBrains s.r.o. 10% · Woodstock Discos 10% · Banco do Brasil S.A. 10% · Riotur 10% · Telus 10% Y Google Inc. 30% · Microsoft Corporation 20% · JetBrains s.r.o. 10% · Rogers Canada 10% · Riotur 10% · Apple Inc. 10% | 0.3 TVD |
| Addressvarchar(70) | postal addresspersonal | New text in the measured format | S 0% Y 0% | S 59 Y 59 | S 17.9 chars avg Y 37.9 chars avg | S Av. Brigadeiro Faria Lima, 2170 1.7% · Theodor-Heuss-Straße 34 1.7% · 1498 rue Bélanger 1.7% · Ullevålsveien 14 1.7% · Klanova 9/506 1.7% · Rilská 3174/6 1.7% Y 88 rue Gambetta, Minimes, Brussels 1.7% · 2 rue de la République, Saint-Pierre, B… 1.7% · 3 rue de la République, Belleville, Par… 1.7% · 4 Church Oakwood, Evanston, Chicago 1.7% · 16 Church Oakwood, Bronx, Vancouver 1.7% · 42 Church West End, Downtown, Salt Lake… 1.7% | 0% in source |
| Cityvarchar(40) | city | Source values, at measured frequencies | S 0% Y 0% | S 53 Y 33 | S 7.8 chars avg Y 7.9 chars avg | S Prague 3.4% · São Paulo 3.4% · Mountain View 3.4% · Berlin 3.4% · Paris 3.4% · London 3.4% Y Montréal 6.8% · São Paulo 6.8% · Paris 5.1% · Prague 5.1% · Edinburgh 5.1% · London 5.1% | 0.373 TVD |
| Statevarchar(40) | generic value | Source values, at measured frequencies | S 49.15% Y 49.15% | S 25 Y 17 | S 2.2 chars avg Y 2.4 chars avg | S SP 10% · CA 10% · ON 6.7% · QC 3.3% · RJ 3.3% · DF 3.3% Y SP 13.3% · Dublin 10% · NT 6.7% · UT 6.7% · ON 6.7% · TX 6.7% | 0.333 TVD |
| Countryvarchar(40) | country name | Source values, at measured frequencies | S 0% Y 0% | S 24 Y 14 | S 6.4 chars avg Y 6.8 chars avg | S USA 22% · Canada 13.6% · Brazil 8.5% · France 8.5% · Germany 6.8% · United Kingdom 5.1% Y USA 20.3% · Brazil 13.6% · Canada 11.9% · United Kingdom 11.9% · Germany 10.2% · France 8.5% | 0.254 TVD |
| PostalCodevarchar(10) | postal codepersonal | New text in the measured format | S 6.78% Y 6.78% | S 55 Y 55 | S 6 chars avg Y 6.2 chars avg | S 12227-000 1.8% · 70174 1.8% · H2G 1A7 1.8% · 0171 1.8% · 14700 1.8% · 14300 1.8% Y 9972 1.8% · 33011 1.8% · 75012 1.8% · 60613 1.8% · 48936 1.8% · 52005-400 1.8% | 0% in source |
| Phonevarchar(24) | phone numberpersonal | New text in the measured format | S 1.69% Y 1.69% | S 58 Y 58 | S 16.8 chars avg Y 16.7 chars avg | S +55 (12) 3923-5555 1.7% · +49 0711 2842222 1.7% · +1 (514) 721-4711 1.7% · +47 22 44 22 22 1.7% · +420 2 4172 5555 1.7% · +420 2 4177 0449 1.7% Y +1 (571) 466-2955 1.7% · +1 (224) 950-3817 1.7% · +17 05 906 27 44 1.7% · +17 24 660 43 80 1.7% · +1 (321) 859-8330 1.7% · +1 (319) 963-9617 1.7% | 0% in source |
| Faxvarchar(24) | phone numberpersonal | New text in the measured format | S 79.66% Y 79.66% | S 12 Y 12 | S 17.3 chars avg Y 17 chars avg | S +55 (12) 3923-5566 8.3% · +420 2 4172 5555 8.3% · +55 (11) 3033-4564 8.3% · +55 (11) 3055-8131 8.3% · +55 (21) 2271-7070 8.3% · +55 (61) 3363-7855 8.3% Y +55 119 060 85139 8.3% · +55 519 301 84484 8.3% · +55 219 933 32786 8.3% · +55 419 375 58894 8.3% · +55 619 800 20876 8.3% · +55 819 797 53583 8.3% | 0% in source |
| Emailvarchar(60) | emailpersonal | New text in the measured format | S 0% Y 0% | S 59 Y 59 | S 21 chars avg Y 31.4 chars avg | S luisg@embraer.com.br 1.7% · leonekohler@surfeu.de 1.7% · ftremblay@gmail.com 1.7% · bjorn.hansen@yahoo.no 1.7% · frantisekw@jetbrains.com 1.7% · hholy@gmail.com 1.7% Y sophia.kelley211@stonegate.test 1.7% · nora.taylor187@inbox.pineledger.example 1.7% · kyleliam.turner365@northwind.test 1.7% · nathan.anderson409@notes.example 1.7% · jack.warren361@redkite.test 1.7% · lauramason.evans357@brightloft.test 1.7% | 0% in source |
| SupportRepIdint | record key | Foreign key, from the measured relationship | S 0% Y 0% | S 3 Y 3 | S 3 → 5 Y 2 → 7 | S 3 35.6% · 4 33.9% · 5 30.5% Y 7 35.6% · 2 33.9% · 4 30.5% | 0.356 KS |