musiccaps
1 row where aspect_list contains "easygoing", aspect_list contains "electric guitar" and aspect_list contains "gear review"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ihJT65fZaHY | This is a gear review jam video. There is a male voice describing the tone that he achieves from using an amp with the electric guitar. The said amp applies an echo effect to the electric guitar, making it sound more dreamy. The performer is playing a simple tune. This piece could be sampled for use in an advertisement jingle or in beat-making. | ["jam", "gear review", "male voice", "single instrument", "electric guitar", "guitar solo", "amp", "echo", "easygoing", "dreamy", "simple tune"] | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | 9 | 30 | 40 | 0 | 0 | ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"] |
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 );