musiccaps
2 rows where aspect_list contains "nostalgic" and audioset_ids contains "/t/dd00034"
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 |
---|---|---|---|---|---|---|---|---|---|---|
C-1i2GlbiIY | A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. | ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] | ["Music", "Tender music"] | 7 | 260 | 270 | 0 | 0 | ["/m/04rlf", "/t/dd00034"] | |
FGoDfNZezh0 | A female vocalist sings this soft love song in a foreign language. The tempo is medium with a mellifluous violin harmony, keyboard accompaniment, subtle bass, steady drumming and rhythmic acoustic guitar. The song is sweet, youthful, simple, romantic, sentimental, melancholic and pensive. This song is Romantic Pop. | ["female vocalist", "medium tempo", "foreign language", "romantic pop", "soft pop", "subtle bass line", "asian music", "soundtrack", "melodic violin harmony", "keyboard accompaniment", "flute", "romantic", "love song", "young love", "first love", "sentimental", "nostalgic", "pensive", "melancholic", "rhythmic acoustic guitar"] | ["Music", "Tender music"] | 7 | 210 | 220 | 0 | 0 | ["/m/04rlf", "/t/dd00034"] |
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 );