analysis
293 rows where family = 029
This data as json, copyable, CSV (advanced)
| id ▼ | name | family |
|---|---|---|
| 0290012000 | MACH Basic 2000 | OTTO 029 |
| 0290012100 | MACH Basic 2001 | OTTO 029 |
| 0290012200 | MACH Basic 2002 | OTTO 029 |
| 0290012300 | MACH Basic 2003 | OTTO 029 |
| 0290012400 | MACH Basic 2004 | OTTO 029 |
| 0290012500 | MACH Basic 2005 | OTTO 029 |
| 0290012501 | MACH 2005 Basic (französisch) | OTTO 029 |
| 0290012600 | MACH Basic 2006-1 | OTTO 029 |
| 0290012601 | MACH Basic 2006-2 | OTTO 029 |
| 0290012701 | MACH Basic 2007-1 | OTTO 029 |
| 0290012702 | MACH Basic 2007-2 | OTTO 029 |
| 0290012712 | MACH Basic 2007-2 (Sonderversion Berner Zeitung) | OTTO 029 |
| 0290012801 | MACH Basic 2008-1 | OTTO 029 |
| 0290012802 | MACH Basic 2008-2 | OTTO 029 |
| 0290012812 | MACH Basic 2008-2 Sonderversion | OTTO 029 |
| 0290012901 | MACH Basic 2009-1 | OTTO 029 |
| 0290012902 | MACH Basic 2009-2 | OTTO 029 |
| 0290012912 | MACH Basic 2009-1 Sonderversion | OTTO 029 |
| 0290012922 | MACH Basic 2009-2 Sonderversion | OTTO 029 |
| 0290013001 | MACH Basic 2010-1 | OTTO 029 |
| 0290013002 | MACH Basic 2010-2 | OTTO 029 |
| 0290013022 | MACH Basic 2010-1 Sonderversion | OTTO 029 |
| 0290013023 | MACH Basic 2010-2 Sonderversion | OTTO 029 |
| 0290013101 | MACH Basic 2011-1 | OTTO 029 |
| 0290013102 | MACH Basic 2011-2 | OTTO 029 |
| 0290013122 | MACH Basic 2011-1 Sonderversion | OTTO 029 |
| 0290013123 | MACH Basic 2011-2 Sonderversion | OTTO 029 |
| 0290013201 | MACH Basic 2012-1 | OTTO 029 |
| 0290013202 | MACH Basic 2012-2 | OTTO 029 |
| 0290013222 | MACH Basic 2012-1 Sonderversion | OTTO 029 |
| 0290013223 | MACH Basic 2012-2 Sonderversion | OTTO 029 |
| 0290013301 | MACH Basic 2013-2 | OTTO 029 |
| 0290013323 | MACH Basic 2013-2 Sonderversion | OTTO 029 |
| 0290013401 | MACH Basic 2014-1 | OTTO 029 |
| 0290013402 | MACH Basic 2014-2 | OTTO 029 |
| 0290013423 | MACH Basic 2014-1 Sonderversion | OTTO 029 |
| 0290013424 | MACH Basic 2014-2 Sonderversion | OTTO 029 |
| 0290013501 | MACH Basic 2015-1 | OTTO 029 |
| 0290013502 | MACH Basic 2015-2 | OTTO 029 |
| 0290013523 | MACH Basic 2015-1 Sonderversion | OTTO 029 |
| 0290013524 | MACH Basic 2015-2 Sonderversion | OTTO 029 |
| 0290013601 | MACH Basic 2016-1 | OTTO 029 |
| 0290013602 | MACH Basic 2016-2 | OTTO 029 |
| 0290013623 | MACH Basic 2016-1 Sonderversion | OTTO 029 |
| 0290013624 | MACH Basic 2016-2 Sonderversion | OTTO 029 |
| 0290013701 | MACH Basic 2017-1 | OTTO 029 |
| 0290013702 | MACH Basic 2017-2 | OTTO 029 |
| 0290013723 | MACH Basic 2017-1 Sonderversion | OTTO 029 |
| 0290013724 | MACH Basic 2017-2 Sonderversion | OTTO 029 |
| 0290013801 | MACH Basic 2018-1 | OTTO 029 |
| 0290013802 | MACH Basic 2018-2 | OTTO 029 |
| 0290013823 | MACH Basic 2018-1 Sonderversion | OTTO 029 |
| 0290013824 | MACH Basic 2018-2 Sonderversion | OTTO 029 |
| 0290022500 | MACH 2005 Consumer (deutsch) | OTTO 029 |
| 0290022601 | MACH Consumer 2006-1 | OTTO 029 |
| 0290022602 | MACH Consumer 2006-2 | OTTO 029 |
| 0290022701 | MACH Consumer 2007-1 | OTTO 029 |
| 0290022702 | MACH Consumer 2007-2 | OTTO 029 |
| 0290022801 | MACH Consumer 2008-1 | OTTO 029 |
| 0290022802 | MACH Consumer 2008-2 | OTTO 029 |
| 0290022812 | MACH Consumer 2008-2 (Berner Zeitung) | OTTO 029 |
| 0290022901 | MACH Consumer 2009-1 | OTTO 029 |
| 0290022902 | MACH Consumer 2009-2 | OTTO 029 |
| 0290023001 | MACH Consumer 2010-1 | OTTO 029 |
| 0290023002 | MACH Consumer 2010-2 | OTTO 029 |
| 0290023101 | MACH Consumer 2011-1 | OTTO 029 |
| 0290023102 | MACH Consumer 2011-2 | OTTO 029 |
| 0290023201 | MACH Consumer 2012-1 | OTTO 029 |
| 0290023202 | MACH Consumer 2012-2 | OTTO 029 |
| 0290023301 | MACH Consumer 2013 | OTTO 029 |
| 0290023401 | MACH Consumer 2014 | OTTO 029 |
| 0290023501 | MACH Consumer 2015 | OTTO 029 |
| 0290023601 | MACH Consumer 2016 | OTTO 029 |
| 0290023701 | MACH Consumer 2017 | OTTO 029 |
| 0290023801 | MACH Consumer 2018 | OTTO 029 |
| 0290032901 | MACH Cinema Test 2009-1 | OTTO 029 |
| 0290032902 | MACH Cinema Basic 2009 | OTTO 029 |
| 0290033002 | MACH Cinema Basic 2010 | OTTO 029 |
| 0290033102 | MACH Cinema Basic 2011 | OTTO 029 |
| 0290033202 | MACH Cinema Basic 2012 | OTTO 029 |
| 0290033302 | MACH Cinema Basic 2013 | OTTO 029 |
| 0290033402 | MACH Cinema Basic 2014 | OTTO 029 |
| 0290033502 | MACH Cinema Basic 2015 | OTTO 029 |
| 0290033602 | MACH Cinema Basic 2016 | OTTO 029 |
| 0290042902 | MACH Cinema Consumer 2009 | OTTO 029 |
| 0290043002 | MACH Cinema Consumer 2010 | OTTO 029 |
| 0290043102 | MACH Cinema Consumer 2011 | OTTO 029 |
| 0290043202 | MACH Cinema Consumer 2012 | OTTO 029 |
| 0290043212 | MACH Cinema Consumer 2012 | OTTO 029 |
| 0290043302 | MACH Cinema Consumer 2013 | OTTO 029 |
| 0290043402 | MACH Cinema Consumer 2014 | OTTO 029 |
| 0290043502 | MACH Cinema Consumer 2015 | OTTO 029 |
| 0290043602 | MACH Cinema Consumer 2016 | OTTO 029 |
| 0290112600 | MACH Basic 2006-1 DSG | OTTO 029 |
| 0290112601 | MACH Basic 2006-2 DSG | OTTO 029 |
| 0290112701 | MACH Basic 2007-1 DSG | OTTO 029 |
| 0290112702 | MACH Basic 2007-2 DSG | OTTO 029 |
| 0290112801 | MACH Basic 2008-1 DSG | OTTO 029 |
| 0290112802 | MACH Basic 2008-2 DSG | OTTO 029 |
| 0290112901 | MACH Basic 2009-1 DSG | OTTO 029 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE analysis ( id VARCHAR(10) NOT NULL, name VARCHAR(250), family VARCHAR(3), PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(family) REFERENCES families (id) );