list of number - one singles of 1999 ( canada )
mambo no 5 is the only number one single of 1999 in canada that spent 11 weeks on top .
{'scope': 'all', 'row': '15', 'col': '3', 'col_other': '4', 'criterion': 'equal', 'value': '11', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'weeks on top', '11'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose weeks on top record is equal to 11 .', 'tostr': 'filter_eq { all_rows ; weeks on top ; 11 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; weeks on top ; 11 } }', 'tointer': 'select the rows whose weeks on top record is equal to 11 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'weeks on top', '11'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose weeks on top record is equal to 11 .', 'tostr': 'filter_eq { all_rows ; weeks on top ; 11 }'}, 'song'], 'result': 'mambo no 5', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; weeks on top ; 11 } ; song }'}, 'mambo no 5'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; weeks on top ; 11 } ; song } ; mambo no 5 }', 'tointer': 'the song record of this unqiue row is mambo no 5 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; weeks on top ; 11 } } ; eq { hop { filter_eq { all_rows ; weeks on top ; 11 } ; song } ; mambo no 5 } } = true', 'tointer': 'select the rows whose weeks on top record is equal to 11 . there is only one such row in the table . the song record of this unqiue row is mambo no 5 .'}
and { only { filter_eq { all_rows ; weeks on top ; 11 } } ; eq { hop { filter_eq { all_rows ; weeks on top ; 11 } ; song } ; mambo no 5 } } = true
select the rows whose weeks on top record is equal to 11 . there is only one such row in the table . the song record of this unqiue row is mambo no 5 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_eq_0': 'filter_eq', 'all_rows_6': 'all_rows', 'weeks on top_7': 'weeks on top', '11_8': '11', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'song_9': 'song', 'mambo no 5_10': 'mambo no 5'}
['volume : issue', 'issue date ( s )', 'weeks on top', 'song', 'artist']
[['68:10 - 12', '30 november - 4 january 1999 §', '6 §', 'thank u', 'alanis morissette'], ['68:13', '11 january - 18 january ≠', '2 ≠', "it 's all been done", 'barenaked ladies'], ['68:14', '25 january', '1', 'hands', 'jewel'], ['68:15', '1 february', '1', 'you get what you give', 'new radicals'], ['68:16', '8 february', '1', '… baby one more time', 'britney spears'], ['68:17 - 18', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks'], ['68:19', '1 march', '1', 'believe', 'cher'], ['68:20 - 24', '8 march - 5 april', '5', 'every morning', 'sugar ray'], ['68:25 - 26', '12 april - 19 april', '2', 'love song', 'sky'], ['69:1 - 2', '26 april - 3 may', '2', 'no scrubs', 'tlc'], ['69:3 - 5', '10 may - 24 may', '3', 'kiss me', 'sixpence none the richer'], ['69:6 - 13', '31 may - 19 july', '8', "livin ' la vida loca", 'ricky martin'], ['69:14 - 15', '26 july - 2 august', '2', 'beautiful stranger', 'madonna'], ['69:16 - 21', '9 august - 13 september', '6', 'if you had my love', 'jennifer lopez'], ['69:22 - 26 , 70:1 - 6', '20 september - 29 november', '11', 'mambo no 5', 'lou bega'], ['70:7', '6 december', '1', 'smooth', 'santana featuring rob thomas'], ['70:8 - 9', '13 december - 3 january 2000 ÷', '2 ÷', 'blue', 'eiffel 65']]