musiccaps
2 rows where aspect_list contains "sonic power" and audioset_ids contains "/t/dd00125"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ij1-640aafg | This music is instrumental. The tempo is medium with a short,electric guitar riff and a male voice doing an introduction to a demo. The video is a tutorial/review of an electric guitar. | ["instrumental", "medium tempo", "introduction", "evie’s", "mark lucas", "male voice speaking", "demo", "electric guitar tutorial", "loud", "sonic power", "amplified", "stringed instrument", "rock", "metal", "heavy meal", "hard rock"] | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 7 | 30 | 40 | 0 | 0 | ["/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0b_fwt", "/m/0fx80y", "/t/dd00125"] | |
_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 );