musiccaps
2 rows where aspect_list contains "sentimental" and audioset_ids contains "/m/02bk07"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2JnlmS1zzls | A male chorus sings this passionate song in a foreign language which sounds like Greek. The song is medium tempo with hand percussion like drums, small hand drum, tambourine and a beat with sticks. The vocals are emphatic and sung in lively parts. The song is passionate, emotional, sentimental, and sounds like an anthem or a love song for the Country or a Leader. | ["male harmony", "medium tempo", "foreign language", "greek song", "anthem", "hand percussion", "tambourine", "hand drums", "sticks", "choral harmony", "unity", "patriotic", "anthem", "patriotism", "passionate", "emotional", "sentimental", "love", "devotion", "loyalty", "intense", "tenor", "baritone", "bass"] | ["Mantra", "Chant", "Folk music", "Music", "Vocal music"] | 7 | 30 | 40 | 1 | 1 | ["/m/01c194", "/m/02bk07", "/m/02w4v", "/m/04rlf", "/m/0y4f8"] | |
2o1p83UjJFA | This is the live performance of an orchestral rock piece. There is a male vocalist singing melodically in the lead. The piano is gently playing the main tune of the song. The tempo of the piece is slow. There is a profound, melancholic atmosphere. This piece could be used in the soundtrack of a drama movie/TV series. It could also be playing in the background at a rock/metal bar. | ["live performance", "orchestral rock", "male vocal", "melodic singing", "piano", "sentimental", "melancholic", "profound", "slow tempo"] | ["Chant", "Music"] | 9 | 30 | 40 | 0 | 1 | ["/m/02bk07", "/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 );