musiccaps
1 row where aspect_list contains "hissing tones" and aspect_list contains "techno dance song"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- ambient noises 1
- crowd noise 1
- groovy bass line 1
- high gain volume 1
- hissing tones · 1 ✖
- home video 1
- keyboard accompaniment 1
- kids dancing 1
- live performance 1
- male singer 1
- medium tempo 1
- noise 1
- noisy crowds 1
- poor audio quality 1
- school dance program 1
- school program 1
- techno dance rhythm 1
- techno dance song · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
-1UWSisR2zo | A male singer sings this groovy melody. The song is a techno dance song with a groovy bass line, strong drumming rhythm and a keyboard accompaniment. The song is so groovy and serves as a dance track for the dancing children. The audio quality is very poor with high gains and hissing noise. | ["live performance", "poor audio quality", "ambient noises", "school dance program", "crowd noise", "high gain volume", "hissing tones", "medium tempo", "techno dance song", "male singer", "groovy bass line", "techno dance rhythm", "keyboard accompaniment", "kids dancing", "noisy crowds", "home video", "school program", "noise"] | ["Music", "Maraca"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0xzly"] |
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 );