northumberland county , new brunswick
blackville encompasses about three times the area of rogersville in northumberland county , new brunswick .
{'row_1': '4', 'row_2': '3', 'col': '3', 'col_other': '1', 'relation': 'greater', 'record_mentioned': 'no', 'diff_result': None}
{'func': 'greater', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'official name', 'blackville'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose official name record fuzzily matches to blackville .', 'tostr': 'filter_eq { all_rows ; official name ; blackville }'}, 'area km 2'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; official name ; blackville } ; area km 2 }', 'tointer': 'select the rows whose official name record fuzzily matches to blackville . take the area km 2 record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'official name', 'rogersville'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose official name record fuzzily matches to rogersville .', 'tostr': 'filter_eq { all_rows ; official name ; rogersville }'}, 'area km 2'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; official name ; rogersville } ; area km 2 }', 'tointer': 'select the rows whose official name record fuzzily matches to rogersville . take the area km 2 record of this row .'}], 'result': True, 'ind': 4, 'tostr': 'greater { hop { filter_eq { all_rows ; official name ; blackville } ; area km 2 } ; hop { filter_eq { all_rows ; official name ; rogersville } ; area km 2 } } = true', 'tointer': 'select the rows whose official name record fuzzily matches to blackville . take the area km 2 record of this row . select the rows whose official name record fuzzily matches to rogersville . take the area km 2 record of this row . the first record is greater than the second record .'}
greater { hop { filter_eq { all_rows ; official name ; blackville } ; area km 2 } ; hop { filter_eq { all_rows ; official name ; rogersville } ; area km 2 } } = true
select the rows whose official name record fuzzily matches to blackville . take the area km 2 record of this row . select the rows whose official name record fuzzily matches to rogersville . take the area km 2 record of this row . the first record is greater than the second record .
{'greater_4': 'greater', 'result_5': 'true', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'official name_7': 'official name', 'blackville_8': 'blackville', 'area km 2_9': 'area km 2', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_10': 'all_rows', 'official name_11': 'official name', 'rogersville_12': 'rogersville', 'area km 2_13': 'area km 2'}
['official name', 'status', 'area km 2', 'population', 'census ranking']
[['miramichi', 'city', '179.84', '17811', '232 of 5008'], ['neguac', 'village', '26.69', '1678', '1500 of 5008'], ['rogersville', 'village', '7.23', '1170', '1875 of 5008'], ['blackville', 'village', '21.73', '990', '2086 of 5008'], ['doaktown', 'village', '28.74', '793', '2387 of 5008']]