musiccaps
1 row where aspect_list contains "melancholic" and aspect_list contains "youtube cover"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- casual 1
- emotional 1
- entertaining 1
- fast tempo 1
- groovy 1
- instrumental music 1
- live demo 1
- live performance 1
- lovely 1
- melancholic · 1 ✖
- no other instrumentation 1
- passionate 1
- poor audio quality 1
- relaxing 1
- technique and expertise 1
- ukulele online lessons 1
- ukulele player 1
- ukulele strummed fast 1
- youtube cover · 1 ✖
- youtube music video 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
PaQGXIh94uc | The song is an instrumental. The song is medium tempo with a ukulele played with a fast strumming technique. The song is groovy and melancholic. The song audio quality is poor but is very relaxing to listen to. | ["live performance", "ukulele player", "instrumental music", "relaxing", "casual", "fast tempo", "technique and expertise", "ukulele online lessons", "poor audio quality", "ukulele strummed fast", "lovely", "entertaining", "passionate", "groovy", "no other instrumentation", "youtube music video", "live demo", "youtube cover", "melancholic", "emotional"] | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 1 | 150 | 160 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/07xzm", "/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 );