MySQL · Chinook

Invoice

Source rows: 412
Synthetic rows: 412
Broken foreign keys: 0
Rows equal to a source row: 0%

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.

InvoiceId key	CustomerId	InvoiceDate	BillingAddress	BillingCity	BillingState	BillingCountry	BillingPostalCode	Total
Source database · 12 of 412 rows
1	2	2021-01-01 00:00:00	Theodor-Heuss-Straße 34	Stuttgart	NULL	Germany	70174	1.98
2	4	2021-01-02 00:00:00	Ullevålsveien 14	Oslo	NULL	Norway	0171	3.96
3	8	2021-01-03 00:00:00	Grétrystraat 63	Brussels	NULL	Belgium	1000	5.94
4	14	2021-01-06 00:00:00	8210 111 ST NW	Edmonton	AB	Canada	T6G 2C7	8.91
5	23	2021-01-11 00:00:00	69 Salem Street	Boston	MA	USA	2113	13.86
6	37	2021-01-19 00:00:00	Berger Straße 10	Frankfurt	NULL	Germany	60316	0.99
7	38	2021-02-01 00:00:00	Barbarossastraße 19	Berlin	NULL	Germany	10779	1.98
8	40	2021-02-01 00:00:00	8, Rue Hanovre	Paris	NULL	France	75002	1.98
9	42	2021-02-02 00:00:00	9, Place Louis Barthou	Bordeaux	NULL	France	33000	3.96
10	46	2021-02-03 00:00:00	3 Chatham Street	Dublin	Dublin	Ireland	NULL	5.94
11	52	2021-02-06 00:00:00	202 Hoxton Street	London	NULL	United Kingdom	N1 5LH	8.91
12	2	2021-02-11 00:00:00	Theodor-Heuss-Straße 34	Stuttgart	NULL	Germany	70174	13.86
Synthetic database · 12 of 412 rows
1	57	2025-07-26 03:00:57	167 Bridge Parkside, Barton Hills, Stuttgart	Stuttgart	NULL	Germany	39210	13.86
2	19	2025-04-12 21:01:10	61 King Central, Chorlton, Oslo	Oslo	NULL	Norway	99715	1.98
3	7	2023-10-01 17:09:45	Calle del Prado, 142, Los Remedios, Brussels	Brussels	NULL	Belgium	A0G 0R2	1.98
4	32	2023-12-27 02:13:25	107 rue Gambetta, Capitole, Edmonton	Edmonton	AB	Canada	75-891	3.96
5	32	2024-03-07 14:40:00	107 rue Gambetta, Capitole, Boston	Boston	MA	USA	75-891	5.94
6	16	2023-01-12 07:00:05	Schulstraße 6, Sachsenhausen, Frankfurt	Frankfurt	NULL	Germany	60012	1.98
7	50	2024-03-02 23:33:58	Gartenstraße 7, Kreuzberg, Berlin	Berlin	NULL	Germany	10013	5.94
8	19	2021-06-23 20:04:32	8 rue Jean Jaurès, Montmartre, Paris	Paris	NULL	France	75013	1.98
9	4	2025-08-23 09:25:51	9 rue Jean Jaurès, Caudéran, Bordeaux	Bordeaux	NULL	France	33012	8.91
10	30	2021-10-09 13:38:24	76 Church Oakwood, Lincoln Park, Dublin	Dublin	Dublin	Ireland	L2R 3E6	13.86
11	41	2022-03-18 16:50:25	11 Park Parkside, Islington, London	London	NULL	United Kingdom	01005	5.94
12	40	2022-01-31 11:35:31	52 Queen Oakwood, Salford, Stuttgart	Stuttgart	NULL	Germany	20485-090	3.96

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
InvoiceIdint	record key	New key values	S 0% Y 0%	S 412 Y 412	S 1 → 412 Y 1 → 412	S — Y —	—
CustomerIdint	record key	Foreign key, from the measured relationship	S 0% Y 0%	S 59 Y 59	S 1 → 59 Y 1 → 59	S 2 1.7% · 4 1.7% · 8 1.7% · 14 1.7% · 23 1.7% · 37 1.7% Y 57 1.7% · 7 1.7% · 32 1.7% · 16 1.7% · 50 1.7% · 4 1.7%	0.002 KS
InvoiceDatedatetime	lifecycle timestamp	Times from the measured distribution	S 0% Y 0%	S 354 Y 412	S 2021-01-01 00:00:00 → 2025-12-22 00:00:00 Y 2021-01-04 19:21:57 → 2025-12-21 22:37:56	S — Y —	0.027 KS
BillingAddressvarchar(70)	postal addresspersonal	New text in the measured format	S 0% Y 0%	S 59 Y 395	S 17.9 chars avg Y 37.9 chars avg	S Theodor-Heuss-Straße 34 1.7% · Ullevålsveien 14 1.7% · Grétrystraat 63 1.7% · 8210 111 ST NW 1.7% · 69 Salem Street 1.7% · Berger Straße 10 1.7% Y —	0% in source
BillingCityvarchar(40)	city	Kept from the source as reference data	S 0% Y 0%	S 53 Y 53	S 7.8 chars avg Y 7.8 chars avg	S Berlin 3.4% · Paris 3.4% · London 3.4% · Mountain View 3.4% · São Paulo 3.4% · Prague 3.4% Y Berlin 3.4% · Paris 3.4% · London 3.4% · Mountain View 3.4% · São Paulo 3.4% · Prague 3.4%	0 TVD
BillingStatevarchar(40)	generic value	Kept from the source as reference data	S 49.03% Y 49.03%	S 25 Y 25	S 2.2 chars avg Y 2.2 chars avg	S CA 10% · SP 10% · ON 6.7% · AB 3.3% · MA 3.3% · Dublin 3.3% Y CA 10% · SP 10% · ON 6.7% · AB 3.3% · MA 3.3% · Dublin 3.3%	0 TVD
BillingCountryvarchar(40)	country name	Kept from the source as reference data	S 0% Y 0%	S 24 Y 24	S 6.4 chars avg Y 6.4 chars avg	S USA 22.1% · Canada 13.6% · France 8.5% · Brazil 8.5% · Germany 6.8% · United Kingdom 5.1% Y USA 22.1% · Canada 13.6% · France 8.5% · Brazil 8.5% · Germany 6.8% · United Kingdom 5.1%	0 TVD
BillingPostalCodevarchar(10)	postal codepersonal	New text in the measured format	S 6.8% Y 8.01%	S 55 Y 119	S 6 chars avg Y 5.9 chars avg	S 70174 1.8% · 0171 1.8% · 1000 1.8% · T6G 2C7 1.8% · 2113 1.8% · 60316 1.8% Y —	0% in source
Totaldecimal(10,2)	monetary amount	Source values, at measured frequencies	S 0% Y 0%	S 23 Y 17	S 0.99 → 25.86 Y 0.99 → 25.86	S 1.98 26.9% · 3.96 13.8% · 5.94 13.6% · 0.99 13.3% · 8.91 13.1% · 13.86 11.9% Y 1.98 27.4% · 5.94 15.8% · 8.91 14.8% · 0.99 13.3% · 3.96 11.4% · 13.86 10%	0.024 KS