musiccaps
1 row where aspect_list contains "powerful" and aspect_list contains "song cover"
This data as json, CSV (advanced)
aspect_list (array) 24 ✖
- amateur tourist video 1
- ambient street noise 1
- cheerful 1
- crowds laughing 1
- emotional 1
- funny 1
- guitar rhythm 1
- guitar strumming 1
- handicapped man 1
- inspiring 1
- jovial 1
- look ma no hands 1
- male singer 1
- man talking 1
- medium tempo 1
- motivational 1
- never give 1
- no other instruments 1
- poor audio quality 1
- positive 1
- powerful · 1 ✖
- retro pop 1
- song cover · 1 ✖
- strength 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
33LJ36nAozM | A handicapped musician plays the guitar with his feet and sings and jokes about. The song is medium tempo and retro pop with just a guitar strumming and no other instrumentation. The song is inspiring and relaxing. The song audio quality is very poor. | ["emotional", "powerful", "strength", "never give", "inspiring", "motivational", "retro pop", "handicapped man", "guitar rhythm", "guitar strumming", "male singer", "man talking", "medium tempo", "crowds laughing", "ambient street noise", "no other instruments", "funny", "jovial", "cheerful", "positive", "song cover", "poor audio quality", "amateur tourist video", "look ma no hands"] | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/018vs", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/09x0r", "/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 );