musiccaps
2 rows where aspect_list contains "melancholic" 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 |
---|---|---|---|---|---|---|---|---|---|---|
P-eIhvCaK-s | This is an instrumental heavy metal piece. There is a bass guitar gently playing the melody with a clean sound. It is a melodic piece with a touch of melancholy. This piece can be used in the soundtrack of a drama movie or a TV series, especially during flashback scenes. It could also be used in video games during story exposition cutscenes. | ["heavy metal", "no singer", "single instrument", "instrumental", "bass guitar", "clean sound", "melodic", "melancholic", "soothing"] | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 9 | 90 | 100 | 1 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/m/0fx80y", "/t/dd00125"] | |
WCiS9IDILQg | This is a classical music piece. It is an instrumental piece. There is a violin playing a melancholic tune. The atmosphere is suspenseful. The quality of the recording is slightly poor. This piece could suit well during a mysterious sequence in a thriller movie. | ["classical music", "amateur recording", "instrumental", "violin", "melancholic", "suspenseful", "movie music", "slightly poor quality"] | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "Inside, small room"] | 9 | 60 | 70 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/07y_7", "/m/0ggq0m", "/m/0l14_3", "/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 );