musiccaps
2 rows where aspect_list contains "story telling" and audioset_ids contains "/m/06cqb"
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 |
---|---|---|---|---|---|---|---|---|---|---|
bSX5-VPL8rE | Make the singer sing this Latin rap song in vocal harmony. The song is medium tempo with a steady drum drumming rhythm, keyboard accompaniment, string section harmony, percussive bass line and machine gunshot sounds. The song is story telling and violent in nature. The song has bad audio quality. | ["latin male singers", "latin rap singers", "gunshots", "bad audio quality", "machine gun sounds", "vocal harmony", "explicit lyrics", "string section harmony", "keyboard accompaniment", "groovy bass line", "steady drumming rhythm", "violence", "struggles", "story telling", "gang fights", "drug wars", "life is tough", "energetic", "youthful", "the hood", "ghetto boys", "reciting pain"] | ["Music", "Rapping", "Reggae", "Music of Latin America", "Hip hop music"] | 1 | 80 | 90 | 0 | 0 | ["/m/04rlf", "/m/06bxc", "/m/06cqb", "/m/0g293", "/m/0glt670"] | |
jQYSfy4DzIc | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | ["Music", "Reggae"] | 1 | 100 | 110 | 0 | 0 | ["/m/04rlf", "/m/06cqb"] |
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 );