musiccaps
2 rows where aspect_list contains "electric guitar" and audioset_ids contains "/m/0326g"
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 |
---|---|---|---|---|---|---|---|---|---|---|
QS3DabGF41Y | This is an instrumental rock music piece. The piece is being performed on a clean sounding electric guitar. There is an easygoing guitar solo being played. The atmosphere is groovy. This piece could be used as an advertisement jingle. | ["rock music", "no singer", "instrumental", "single instrument", "electric guitar", "clean sound", "guitar solo", "easygoing", "groovy"] | ["Flamenco", "Guitar", "Musical instrument", "Plucked string instrument"] | 9 | 120 | 130 | 0 | 0 | ["/m/0326g", "/m/0342h", "/m/04szw", "/m/0fx80y"] | |
YzpzKyzyL0Y | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | ["Flamenco", "Music", "Music of Latin America"] | 8 | 110 | 120 | 1 | 1 | ["/m/0326g", "/m/04rlf", "/m/0g293"] |
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 );