musiccaps
2 rows where aspect_list contains "german song" and audioset_ids contains "/m/0140xf"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BXUS7pTYDzI | A female vocalist sings this soft melody. The song is slow tempo with accordion harmony and acoustic guitar accompaniment and alto vocal harmony. The song is mellow, soft, pleasant, dulcet, emotional, romantic and nostalgic. This song is a Swiss/German folk song. | ["female vocalist", "vocal backup", "accordion harmony", "german folk song", "soft", "mellow", "melodious", "alto backup vocals", "swiss folk song", "german song", "soft elbow", "dulcet", "pleasant", "soothing", "peaceful", "mellow acoustic guitar"] | ["Christmas music", "Music"] | 7 | 30 | 40 | 0 | 1 | ["/m/0140xf", "/m/04rlf"] | |
UOKWQ2EHJQI | A male vocalist sings this animated melody. The song is minimal instrumentation with a bright accordion harmony and organ accompaniment. It is perky, animated, bright, energetic, enthusiastic, and vibrant. This song is a classic German folk song. | ["male vocalist", "medium tempo", "accordion harmony", "folk song", "regional song", "world music", "german song", "organ accomapniment", "spirited", "lively", "vibrant", "passionate", "emotional", "bright", "classic", "foreign language"] | ["Christmas music", "Music"] | 7 | 20 | 30 | 0 | 1 | ["/m/0140xf", "/m/04rlf"] |
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 );