musiccaps
1 row where aspect_list contains "90’s hit song" and aspect_list contains "male vocalist"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- 90’s hit song · 1 ✖
- ambient concert sounds 1
- back street boys 1
- boy band 1
- concert 1
- electrifying 1
- energetic 1
- fans screaming 1
- hysteria 1
- inferior audio quality 1
- live audience 1
- live performance 1
- male vocalist · 1 ✖
- medium fast tempo 1
- muffled audio 1
- muffled instrumentation 1
- pop 1
- pop hit 1
- pulsating 1
- thumping beats 1
- vibrant 1
- vivacious 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
ab8V7MYQVyg | A male vocalist sings this Popular 90’s song. The tempo is medium fast with thumping drum beats, keyboard harmony, boomy bass and vocal backup.The song is a live performance at a concert with ambient sounds of fans screaming, clapping and singing along and responding. The audio is incoherent as it is an amateur recording. This song is a Hit 90’s Pop. | ["male vocalist", "medium fast tempo", "boy band", "90’s hit song", "pop", "live performance", "live audience", "concert", "back street boys", "ambient concert sounds", "fans screaming", "hysteria", "thumping beats", "inferior audio quality", "muffled audio", "muffled instrumentation", "energetic", "electrifying", "pulsating", "vibrant", "vivacious", "pop hit"] | ["Crowd", "Music", "Rock music", "Shout", "Bang"] | 7 | 190 | 200 | 0 | 0 | ["/m/03qtwd", "/m/04rlf", "/m/06by7", "/m/07p6fty", "/m/07pws3f"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );