musiccaps
2 rows where aspect_list contains "cheerful" and audioset_ids contains "/m/028sqc"
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 |
---|---|---|---|---|---|---|---|---|---|---|
aOGNUGgTQ8k | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | 1 | 210 | 220 | 1 | 1 | ["/m/0145m", "/m/0164x2", "/m/028sqc", "/m/04rlf", "/m/064t9", "/m/06cqb", "/m/06j64v", "/m/0g293", "/m/0gywn"] | |
lZavPVn7O4Q | This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. | ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] | ["Christmas music", "Music of Asia", "Christian music", "Music"] | 9 | 180 | 190 | 0 | 0 | ["/m/0140xf", "/m/028sqc", "/m/02mscn", "/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 );