gistfile1.txt

mysql> select odate,boolean from t2 where metric='Adjusted net national income';
+----------+---------+
| odate    | boolean |
+----------+---------+
| 19710000 |       0 |
| 19720000 |       0 |
| 19730000 |       0 |
| 19740000 |       0 |
| 19750000 |       0 |
| 19760000 |       0 |
| 19770000 |       0 |
| 19780000 |       0 |
| 19790000 |       0 |
| 19800000 |       0 |
| 19810000 |       0 |
| 19820000 |       0 |
| 19830000 |       0 |
| 19840000 |       0 |
| 19850000 |       0 |
| 19860000 |       0 |
| 19870000 |       0 |
| 19880000 |       0 |
| 19890000 |       0 |
| 19900000 |       0 |
| 19910000 |       0 |
| 19920000 |       0 |
| 19930000 |       0 |
| 19940000 |       0 |
| 19950000 |       0 |
| 19960000 |       0 |
| 19970000 |       0 |
| 19980000 |       0 |
| 19990000 |       0 |
| 20000000 |       0 |
| 20010000 |       0 |
| 20020000 |       0 |
| 20030000 |       0 |
| 20040000 |       0 |
| 20050000 |       0 |
| 20060000 |       0 |
| 20070000 |       0 |
| 20080000 |       0 |
| 20090000 |       0 |
| 20100000 |       0 |
| 20110000 |       0 |
| 20120000 |       0 |
| 20130000 |       0 |
| 20140000 |       0 |
| 20150000 |       0 |
| 19700000 |       1 |
| 19710000 |       1 |
| 19720000 |       1 |
| 19730000 |       1 |
| 19740000 |       1 |
| 19750000 |       1 |
| 19760000 |       1 |
| 19770000 |       1 |
| 19780000 |       1 |
| 19790000 |       1 |
| 19800000 |       1 |
| 19810000 |       1 |
| 19820000 |       1 |
| 19830000 |       1 |
| 19840000 |       1 |
| 19850000 |       1 |
| 19860000 |       1 |
| 19870000 |       1 |
| 19880000 |       1 |
| 19890000 |       1 |
| 19900000 |       1 |
| 19910000 |       1 |
| 19920000 |       1 |
| 19930000 |       1 |
| 19940000 |       1 |
| 19950000 |       1 |
| 19960000 |       1 |
| 19970000 |       1 |
| 19980000 |       1 |
| 19990000 |       1 |
| 20000000 |       1 |
| 20010000 |       1 |
| 20020000 |       1 |
| 20030000 |       1 |
| 20040000 |       1 |
| 20050000 |       1 |
| 20060000 |       1 |
| 20070000 |       1 |
| 20080000 |       1 |
| 20090000 |       1 |
| 20100000 |       1 |
| 20110000 |       1 |
| 20120000 |       1 |
| 20130000 |       1 |
| 20140000 |       1 |
| 20150000 |       1 |
| 19700000 |       1 |
| 19710000 |       1 |
| 19720000 |       1 |
| 19730000 |       1 |
| 19740000 |       1 |
| 19750000 |       1 |
| 19760000 |       1 |
| 19770000 |       1 |
| 19780000 |       1 |
| 19790000 |       1 |
| 19800000 |       1 |
| 19810000 |       1 |
| 19820000 |       1 |
| 19830000 |       1 |
| 19840000 |       1 |
| 19850000 |       1 |
| 19860000 |       1 |
| 19870000 |       1 |
| 19880000 |       1 |
| 19890000 |       1 |
| 19900000 |       1 |
| 19910000 |       1 |
| 19920000 |       1 |
| 19930000 |       1 |
| 19940000 |       1 |
| 19950000 |       1 |
| 19960000 |       1 |
| 19970000 |       1 |
| 19980000 |       1 |
| 19990000 |       1 |
| 20000000 |       1 |
| 20010000 |       1 |
| 20020000 |       1 |
| 20030000 |       1 |
| 20040000 |       1 |
| 20050000 |       1 |
| 20060000 |       1 |
| 20070000 |       1 |
| 20080000 |       1 |
| 20090000 |       1 |
| 20100000 |       1 |
| 20110000 |       1 |
| 20120000 |       1 |
| 20130000 |       1 |
| 20140000 |       1 |
| 20150000 |       1 |
+----------+---------+
137 rows in set (0.04 sec)