musiccaps
1 row where aspect_list contains "amplified guitar" and aspect_list contains "melodious"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- amplified guitar · 1 ✖
- blues 1
- country 1
- electric guitar 1
- external amplification 1
- hard rock 1
- heavy metal 1
- instrumental 1
- intense 1
- jazz 1
- lead instrument 1
- loud 1
- medium tempo 1
- melodious · 1 ✖
- minimal instrumentation 1
- pop 1
- powerful 1
- rock 1
- skilful 1
- sonic power 1
- string instrument 1
- vibrations 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
kaabXWuPWRg | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0b9m1", "/m/0g12c5"] |
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 );