musiccaps
2 rows where aspect_list contains "pastoral" and audioset_ids contains "/m/0g293"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0-7PyzhzuYQ | This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. | ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] | ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] | 9 | 30 | 40 | 0 | 1 | ["/m/016cjb", "/m/02w4v", "/m/0326g", "/m/04rlf", "/m/0dq0md", "/m/0g293", "/m/0gg8l"] | |
s25X6KwBpxw | This is a poor quality recording of a yodeling music piece. There is a male vocalist singing rapidly with the yodeling technique. The melody is being played by an accordion. There is a bass guitar playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is cheerful. Despite the quality issue of the recording, it would suit well as a rural radio station music playing inside the car in a movie. | ["poor quality recording", "yodeling", "american", "male vocal", "rapid singing", "accordion", "bass guitar", "acoustic drums", "cheerful", "pastoral", "upbeat"] | ["Yodeling", "Music", "Music of Latin America"] | 9 | 30 | 40 | 0 | 0 | ["/m/01swy6", "/m/04rlf", "/m/0g293"] |
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 );