musiccaps
1 row where aspect_list contains "electric guitar harmony" and aspect_list contains "emphatic"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- amplified guitar 1
- electric guitar harmony · 1 ✖
- electric guitar lead 1
- electric guitar solo 1
- emotional 1
- emphatic · 1 ✖
- hard rock 1
- heavy metal 1
- instrumental 1
- loud 1
- loud feedback 1
- melancholy 1
- metal 1
- pensive 1
- pop 1
- resounding 1
- rock 1
- sentimental 1
- slow tempo 1
- soft rock 1
- sonic power 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
_0-2meOf9qY | This music is an electronic guitar instrumental. The tempo is slow with a melancholic , resounding harmony on the guitar. It is mellow, soft, poignant, sentimental and emotional. | ["instrumental", "slow tempo", "electric guitar harmony", "electric guitar solo", "electric guitar lead", "amplified guitar", "loud", "emphatic", "resounding", "sonic power", "loud feedback", "rock", "hard rock", "metal", "heavy metal", "soft rock", "pop", "youthful", "pensive", "melancholy", "sentimental", "emotional"] | ["Echo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | 7 | 10 | 20 | 0 | 0 | ["/m/01jnbd", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"] |
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 );