musiccaps
2 rows where audioset_ids contains "/m/07gxw", audioset_ids contains "/m/07s72n" and author_id = 2
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
UkZ76EFfLSg | The techno music excerpt features only a beat, no other melodic or harmonic instruments. By the sound of it, the beat was made using sampled drums. Other percussive instruments can be heard in the background. This music would be played in a club. | ["club music", "techno music", "drum beat", "percussive instruments", "no melody", "no harmony", "sampled drums"] | ["Drum and bass", "House music", "Music", "Techno", "Tick", "Dubstep", "Dance music"] | 2 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/03mb9", "/m/04rlf", "/m/07gxw", "/m/07qjznt", "/m/07s72n", "/m/0ggx5q"] | |
oJ0rdNlghn4 | The rock music features a bass guitar playing a repeating melody with a distortion effect in the really-low pitch register. A set of drums is accompanying the bassist with a well-rooted and repeating rhythm. | ["drums", "bass guitar", "distortion effect", "rock genre"] | ["Music", "Techno", "Chorus effect", "Dubstep"] | 2 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07gxw", "/m/07m2kt", "/m/07s72n"] |
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 );