musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "gear"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- acoustic guitar · 1 ✖
- advertising 1
- bass guitar 1
- electronic drum beat 1
- gear · 1 ✖
- jam 1
- male voice 1
- rhythm machine 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
rS8oECcQBCk | This is an advertisement video for a rhythm machine. Firstly, it is shown playing behind a bass guitar jam. Then, it is shown playing behind an acoustic guitar jam. A male voice is describing the benefits and functions of the rhythm machine. The parts where the instruments can be heard without the interruption of the voice can be sampled for use in beat-making. | ["jam", "gear", "rhythm machine", "electronic drum beat", "bass guitar", "acoustic guitar", "male voice", "advertising"] | ["Guitar", "Musical instrument", "Drum machine", "Plucked string instrument"] | 9 | 10 | 20 | 0 | 0 | ["/m/0342h", "/m/04szw", "/m/0cfdd", "/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 );