eurozone
the only country adopted into the eurozone in 1999 that has a population of less than 1 million is luxembourg .
{'scope': 'subset', 'row': '11', 'col': '3', 'col_other': '1,2', 'criterion': 'less_than', 'value': '1000000', 'subset': {'col': '2', 'criterion': 'fuzzily_match', 'value': '1999'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_less', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'adopted', '1999'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; adopted ; 1999 }', 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 .'}, 'population ( 2011 - 01 - 01 )', '1000000'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 .', 'tostr': 'filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } }', 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_less', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'adopted', '1999'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; adopted ; 1999 }', 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 .'}, 'population ( 2011 - 01 - 01 )', '1000000'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 .', 'tostr': 'filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 }'}, 'state'], 'result': 'luxembourg', 'ind': 3, 'tostr': 'hop { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } ; state }'}, 'luxembourg'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } ; state } ; luxembourg }', 'tointer': 'the state record of this unqiue row is luxembourg .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } } ; eq { hop { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } ; state } ; luxembourg } } = true', 'tointer': 'select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 . there is only one such row in the table . the state record of this unqiue row is luxembourg .'}
and { only { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } } ; eq { hop { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } ; state } ; luxembourg } } = true
select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 . there is only one such row in the table . the state record of this unqiue row is luxembourg .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_less_1': 'filter_less', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'adopted_8': 'adopted', '1999_9': '1999', 'population (2011 - 01 - 01)_10': 'population ( 2011 - 01 - 01 )', '1000000_11': '1000000', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'state_12': 'state', 'luxembourg_13': 'luxembourg'}
['state', 'adopted', 'population ( 2011 - 01 - 01 )', 'nominal gdp world bank , 2009 ( million usd )', 'relative gdp of total ( nominal )', 'gdp per capita world bank , 2009 nominal ( usd )']
[['austria', '1999 - 01 - 01', '8404252', '384908', '3.09 %', '45799'], ['belgium', '1999 - 01 - 01', '10918405', '468522', '3.76 %', '42911'], ['cyprus ( incl uk military base )', '2008 - 01 - 01', '838896 14500', '24910', '0.20 %', '30966'], ['estonia', '2011 - 01 - 01', '1340194', '19120', '0.15 %', '14267'], ['finland', '1999 - 01 - 01', '5375276', '237512', '1.91 %', '44186'], ['france', '1999 - 01 - 01', '65075373', '2649390', '21.26 %', '40713'], ['germany', '1999 - 01 - 01', '81751602', '3330032', '26.73 %', '40734'], ['greece', '2001 - 01 - 01', '11325897', '329924', '2.65 %', '29130'], ['ireland', '1999 - 01 - 01', '4480858', '227193', '1.82 %', '50703'], ['italy', '1999 - 01 - 01', '60626442', '2112780', '16.96 %', '34849'], ['luxembourg', '1999 - 01 - 01', '511840', '52449', '0.42 %', '102471'], ['malta', '2008 - 01 - 01', '417617', '7449', '0.06 %', '17837'], ['netherlands', '1999 - 01 - 01', '16655799', '792128', '6.36 %', '47559'], ['portugal', '1999 - 01 - 01', '10636979', '227676', '1.83 %', '21404'], ['slovakia', '2009 - 01 - 01', '5435273', '87642', '0.70 %', '16125'], ['slovenia', '2007 - 01 - 01', '2050189', '48477', '0.39 %', '23645'], ['spain', '1999 - 01 - 01', '47190493', '1460250', '11.72 %', '30944'], ['eurozone', 'eurozone', '331963357', '12460362', '100 %', '37535']]