toronto and nipissing railway
engine number 11 was the only engine built in 1872 .
{'scope': 'all', 'row': '11', 'col': '4', 'col_other': '1', 'criterion': 'equal', 'value': '1872', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'date', '1872'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose date record is equal to 1872 .', 'tostr': 'filter_eq { all_rows ; date ; 1872 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; date ; 1872 } }', 'tointer': 'select the rows whose date record is equal to 1872 . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'date', '1872'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose date record is equal to 1872 .', 'tostr': 'filter_eq { all_rows ; date ; 1872 }'}, 'number'], 'result': '11', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; date ; 1872 } ; number }'}, '11'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; date ; 1872 } ; number } ; 11 }', 'tointer': 'the number record of this unqiue row is 11 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; date ; 1872 } } ; eq { hop { filter_eq { all_rows ; date ; 1872 } ; number } ; 11 } } = true', 'tointer': 'select the rows whose date record is equal to 1872 . there is only one such row in the table . the number record of this unqiue row is 11 .'}
and { only { filter_eq { all_rows ; date ; 1872 } } ; eq { hop { filter_eq { all_rows ; date ; 1872 } ; number } ; 11 } } = true
select the rows whose date record is equal to 1872 . there is only one such row in the table . the number record of this unqiue row is 11 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_eq_0': 'filter_eq', 'all_rows_6': 'all_rows', 'date_7': 'date', '1872_8': '1872', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'number_9': 'number', '11_10': '11'}
['number', 'builder', 'type', 'date', 'works number']
[['1', 'avonside engine company', '4 - 4 - 0', 'september 1870', '808'], ['2', 'canadian engine & machinery company', '4 - 4 - 0', 'november 1870', '83'], ['3', 'canadian engine & machinery company', '4 - 4 - 0', 'december 1870', '84'], ['4', 'canadian engine & machinery company', '4 - 4 - 0', 'early 1871', '85'], ['5', 'canadian engine & machinery company', '4 - 4 - 0', 'march 1871', '86'], ['6', 'canadian engine & machinery company', '4 - 4 - 0', 'may 1871', '87'], ['7', 'canadian engine & machinery company', '4 - 4 - 0', 'may 1871', '88'], ['8', 'avonside engine company', '4 - 6 - 0', 'december 1871', '867'], ['9', 'avonside engine company', '0 - 6 - 6 - 0 fairlie', 'december 1871', '864 & 865'], ['10', 'avonside engine company', '4 - 6 - 0', 'early 1873', 'uncertain but probably one of 931 - 934'], ['11', 'avonside engine company', '4 - 6 - 0', '1872', 'uncertain but probably one of 935 - 939'], ['12', 'avonside engine company', '4 - 6 - 0', 'early 1873', 'uncertain but probably one of 935 - 939']]