musiccaps
1 row where aspect_list contains "echo" and aspect_list contains "male voice"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- amp 1
- dreamy 1
- easygoing 1
- echo · 1 ✖
- electric guitar 1
- gear review 1
- guitar solo 1
- jam 1
- male voice · 1 ✖
- simple tune 1
- single instrument 1
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 );