ranked list of norwegian counties
oslo county was the only county with a percentage higher than 10 % in 1960 .
{'scope': 'all', 'row': '1', 'col': '3', 'col_other': '2', 'criterion': 'greater_than', 'value': '10.0', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', '% ( 1960 )', '10.0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose % ( 1960 ) record is greater than 10.0 .', 'tostr': 'filter_greater { all_rows ; % ( 1960 ) ; 10.0 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } }', 'tointer': 'select the rows whose % ( 1960 ) record is greater than 10.0 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', '% ( 1960 )', '10.0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose % ( 1960 ) record is greater than 10.0 .', 'tostr': 'filter_greater { all_rows ; % ( 1960 ) ; 10.0 }'}, 'county'], 'result': 'oslo', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } ; county }'}, 'oslo'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } ; county } ; oslo }', 'tointer': 'the county record of this unqiue row is oslo .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } } ; eq { hop { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } ; county } ; oslo } } = true', 'tointer': 'select the rows whose % ( 1960 ) record is greater than 10.0 . there is only one such row in the table . the county record of this unqiue row is oslo .'}
and { only { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } } ; eq { hop { filter_greater { all_rows ; % ( 1960 ) ; 10.0 } ; county } ; oslo } } = true
select the rows whose % ( 1960 ) record is greater than 10.0 . there is only one such row in the table . the county record of this unqiue row is oslo .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', '% (1960)_7': '% ( 1960 )', '10.0_8': '10.0', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'county_9': 'county', 'oslo_10': 'oslo'}
['rank', 'county', '% ( 1960 )', '% ( 2000 )', '% ( 2040 )']
[['1', 'oslo', '13.2', '11.3', '12.8'], ['2', 'akershus', '6.3', '10.4', '11.9'], ['3', 'hordaland', '9.4', '9.7', '10.2'], ['4', 'rogaland', '6.6', '8.3', '9.9'], ['5', 'sør - trøndelag', '5.8', '5.8', '6.0'], ['6', 'østfold', '5.6', '5.5', '5.5'], ['7', 'buskerud', '4.6', '5.2', '5.4'], ['8', 'møre og romsdal', '5.9', '5.4', '4.8'], ['9', 'nordland', '6.6', '5.3', '3.9'], ['10', 'vestfold', '4.8', '4.7', '4.7'], ['11', 'hedmark', '4.9', '4.1', '3.4'], ['12', 'oppland', '4.6', '4.0', '3.3'], ['13', 'vest - agder', '3.0', '3.4', '3.6'], ['14', 'telemark', '4.1', '3.6', '3.0'], ['15', 'troms', '3.5', '3.3', '2.7'], ['16', 'nord - trøndelag', '3.2', '2.8', '2.4'], ['17', 'aust - agder', '2.1', '2.2', '2.3'], ['18', 'sogn og fjordane', '2.8', '2.4', '1.8'], ['19', 'finnmark', '2.0', '1.6', '1.2'], ['sum', 'norway', '100.0', '100.0', '100.0']]