musiccaps
2 rows where aspect_list contains "acoustic guitar", aspect_list contains "easygoing" and audioset_ids contains "/m/07xzm"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DAPGvg8qOAU | This is an acoustic folk piece. The main melody is being played with a mandolin while there is an acoustic guitar backing. A male vocalist is singing in a story-telling mood. The overall atmosphere of the piece is mellow. This piece could definitely be used in the soundtracks of romantic movies. It could also be played in sequences that emphasize longing and loneliness. | ["acoustic folk", "mandolin", "acoustic guitar", "male vocal", "story-telling mood", "mellow", "gentle", "cozy", "easygoing", "american"] | ["Singing", "Music", "Mandolin", "Ukulele"] | 9 | 0 | 10 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/04rzd", "/m/07xzm"] | |
lqCx0HgF1ZM | This is an acoustic performance of a k-pop piece. The lead is a male vocal that is singing gently and melodically in the Korean language. He is also playing an acoustic guitar as the melodic background of the piece. The song is in the major scale which gives it this positive and uplifting aura. This piece could be used in the soundtrack of a coming-of-age/teenage drama TV series that takes place in Korea. It could also be playing in the background of a coffee house. | ["k-pop", "korean", "acoustic", "male vocal", "melodic singing", "acoustic guitar", "mellow tune", "easygoing", "positive", "uplifting"] | ["Singing", "Music", "Ukulele"] | 9 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/07xzm"] |
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 );