SQL Server · AdventureWorksLT
SalesLT.Address
- Source rows
- 450
- Synthetic rows
- 450
- Broken foreign keys
- No foreign keys
- 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.
| AddressID key | AddressLine1 | AddressLine2 | City | StateProvince | CountryRegion | PostalCode | rowguid | ModifiedDate |
|---|---|---|---|---|---|---|---|---|
| Source database · 12 of 450 rows | ||||||||
| 9 | 8713 Yosemite Ct. | NULL | Bothell | Washington | United States | 98011 | 268AF621-76D7-4C78-9441-144FD139821A | 2006-07-01 00:00:00 |
| 11 | 1318 Lasalle Street | NULL | Bothell | Washington | United States | 98011 | 981B3303-ACA2-49C7-9A96-FB670785B269 | 2007-04-01 00:00:00 |
| 25 | 9178 Jumping St. | NULL | Dallas | Texas | United States | 75201 | C8DF3BD9-48F0-4654-A8DD-14A67A84D3C6 | 2006-09-01 00:00:00 |
| 28 | 9228 Via Del Sol | NULL | Phoenix | Arizona | United States | 85004 | 12AE5EE1-FC3E-468B-9B92-3B970B169774 | 2005-09-01 00:00:00 |
| 32 | 26910 Indela Road | NULL | Montreal | Quebec | Canada | H1Y 2H5 | 84A95F62-3AE8-4E7E-BBD5-5A6F00CD982D | 2006-08-01 00:00:00 |
| 185 | 2681 Eagle Peak | NULL | Bellevue | Washington | United States | 98004 | 7BCCF442-2268-46CC-8472-14C44C14E98C | 2006-09-01 00:00:00 |
| 297 | 7943 Walnut Ave | NULL | Renton | Washington | United States | 98055 | 52410DA4-2778-4B1D-A599-95746625CE6D | 2006-08-01 00:00:00 |
| 445 | 6388 Lake City Way | NULL | Burnaby | British Columbia | Canada | V5A 3A6 | 53572F25-9133-4A8B-A065-102FF35416EE | 2006-09-01 00:00:00 |
| 446 | 52560 Free Street | NULL | Toronto | Ontario | Canada | M4B 1V7 | 801A1DFC-5125-486B-AA84-CCBD2EC57CA4 | 2005-08-01 00:00:00 |
| 447 | 22580 Free Street | NULL | Toronto | Ontario | Canada | M4B 1V7 | 88CEE379-DBB8-433B-B84E-A35E09435500 | 2006-08-01 00:00:00 |
| 448 | 2575 Bloor Street East | NULL | Toronto | Ontario | Canada | M4B 1V6 | 2DF6D0AD-0926-4F34-A450-9B1083150CBF | 2007-08-01 00:00:00 |
| 449 | Station E | NULL | Chalk Riber | Ontario | Canada | K0J 1J0 | 8B5A7729-CB75-4303-A607-7F9793B4D94F | 2005-08-01 00:00:00 |
| Synthetic database · 12 of 450 rows | ||||||||
| 9 | 153 Station Hillcrest, Manhattan, Portland | NULL | Portland | Nevada | United States | V02 4ON | CE17699F-77DA-416F-8000-000000000000 | 2005-09-01 00:00:00 |
| 34 | 145 King Central, Etobicoke, Chicago | NULL | Chicago | Quebec | Illinois | 60669 | CE17699F-77DA-416F-8000-000000000001 | 2006-08-01 00:00:00 |
| 59 | 64 Queen Oakwood, Islington, Ottawa | NULL | Ottawa | Washington | United States | 03742 | CE17699F-77DA-416F-8000-000000000002 | 2007-08-01 00:00:00 |
| 84 | 63 King Hillcrest, Evanston, Puyallup | NULL | Puyallup | California | United States | 31851 | CE17699F-77DA-416F-8000-000000000003 | 2005-09-01 00:00:00 |
| 109 | 123 High Hillcrest, Loop, Toronto | NULL | Toronto | Washington | Ontario | 577 | CE17699F-77DA-416F-8000-000000000004 | 2007-09-01 00:00:00 |
| 134 | 145 King Central, Salford, Phoenix | NULL | Phoenix | Queensland | United States | 47432 | CE17699F-77DA-416F-8000-000000000005 | 2005-07-01 00:00:00 |
| 159 | 1 High Central, Staten Island, London | NULL | London | California | England | 01044 | CE17699F-77DA-416F-8000-000000000006 | 2006-08-01 00:00:00 |
| 184 | 93 Market Hillcrest, North York, Madrid | NULL | Madrid | California | Comunidad de Madrid | 28013 | CE17699F-77DA-416F-8000-000000000007 | 2006-09-01 00:00:00 |
| 209 | 159 High Hillcrest, Manhattan, Austin | NULL | Austin | Quebec | Texas | 78757 | CE17699F-77DA-416F-8000-000000000008 | 2005-09-01 00:00:00 |
| 234 | 135 King Hillcrest, Downtown, Round Rock | NULL | Round Rock | California | United States | 09074 | CE17699F-77DA-416F-8000-000000000009 | 2006-09-01 00:00:00 |
| 259 | 137 Church Parkside, Greenwich, Manchester | NULL | Manchester | Michigan | England | 122 | CE17699F-77DA-416F-8000-00000000000A | 2005-08-01 00:00:00 |
| 284 | 63 High Hillcrest, Downtown, Toronto | NULL | Toronto | Washington | Ontario | 528 | CE17699F-77DA-416F-8000-00000000000B | 2007-09-01 00:00:00 |
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 |
|---|---|---|---|---|---|---|---|
| AddressIDint | record keypersonal | New key values | S 0% Y 0% | S 450 Y 450 | S 9 → 11382 Y 9 → 11234 | S — Y — | — |
| AddressLine1nvarchar(60) | postal addresspersonal | New text in the measured format | S 0% Y 0% | S 445 Y 449 | S 19.5 chars avg Y 37.8 chars avg | S — Y — | 0% in source |
| AddressLine2nvarchar(60) | postal addresspersonal | New text in the measured format | S 97.56% Y 97.56% | S 11 Y 11 | S 11.2 chars avg Y 37.3 chars avg | S Floor 7 9.1% · Suite 2501 9.1% · Box 8033 9.1% · Stanford House 9.1% · PO Box 4023 9.1% · Raven House, Kingsgate 9.1% Y 109 High Central, Salford, Manchester 9.1% · 119 Bridge Parkside, Hyde Park, Chicago 9.1% · 169 High Central, Hackney, London 9.1% · 145 King Central, Barton Hills, Austin 9.1% · 43 Market Central, Brooklyn, New York 9.1% · 115 Market Central, Chorlton, Manchester 9.1% | 0% in source |
| Citynvarchar(30) | city | Source values, at measured frequencies | S 0% Y 0% | S 269 Y 79 | S 8.1 chars avg Y 7.5 chars avg | S — Y London 10.9% · Toronto 10% · Chicago 6.9% · New York 6.7% · Austin 6.4% · Manchester 5.8% | — |
| StateProvince[dbo].[Name] | region | Source values, at measured frequencies | S 0% Y 0% | S 25 Y 20 | S 8.1 chars avg Y 8 chars avg | S California 17.3% · Ontario 12.2% · Washington 11.3% · Texas 8.9% · England 8.9% · Quebec 5.3% Y California 17.3% · Ontario 12.7% · Washington 10.9% · Texas 10.7% · England 8.7% · Quebec 4.7% | 0.08 TVD |
| CountryRegion[dbo].[Name] | country name | Generated together with related columns | S 0% Y 0% | S 3 Y 17 | S 11.3 chars avg Y 9.6 chars avg | S United States 65.6% · Canada 25.6% · United Kingdom 8.9% Y United States 27.8% · England 16.7% · Canada 12% · Ontario 10% · Illinois 6.9% · New York 6.7% | 0.56 TVD |
| PostalCodenvarchar(15) | postal codepersonal | New text in the measured format | S 0% Y 0% | S 303 Y 368 | S 5.6 chars avg Y 5 chars avg | S — Y — | 0.7% in source |
| rowguiduniqueidentifier | uuid | New key values | S 0% Y 0% | S 450 Y 450 | S 36 chars avg Y 36 chars avg | S — Y — | — |
| ModifiedDatedatetime | lifecycle timestamp | Times from the measured distribution | S 0% Y 0% | S 25 Y 22 | S 2005-07-01 00:00:00 → 2008-06-01 00:00:00 Y 2005-07-01 00:00:00 → 2008-06-01 00:00:00 | S 2005-08-01 00:00:00 14.2% · 2006-09-01 00:00:00 13.6% · 2006-08-01 00:00:00 12.2% · 2005-09-01 00:00:00 11.3% · 2007-09-01 00:00:00 11.1% · 2006-07-01 00:00:00 7.3% Y 2006-09-01 00:00:00 14.7% · 2005-08-01 00:00:00 12.7% · 2006-08-01 00:00:00 11.8% · 2005-09-01 00:00:00 11.6% · 2007-08-01 00:00:00 11.3% · 2007-09-01 00:00:00 9.8% | 0.042 KS |