musiccaps

2 rows where aspect_list contains "rap" and audioset_names contains "Music of Asia"

✎ View and edit SQL

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
6Sdu56gquJE A male vocalist sings this intense Rap. The tempo is slow with boomy bass drumming and atmospheric synthesiser. The music is minimalist with emphatic vocals. The song is a passionate, youthful,insightful,persuasive and intense Synth Rap. ["male singer", "slow tempo", "rap", "hip-hop", "synth rap", "rhythmic patter", "rhythmic speechlow notes", "rapper", "electroni music", "atmospheric synthesiser", "boomy bass", "psychedelic synthesiser", "minimalist music", "intense", "serious", "grim", "emotional", "passionate"] ["Heart murmur", "Music of Asia", "Music"] 7 0 10 0 1 ["/m/01jg1z", "/m/028sqc", "/m/04rlf"]
LaaC_q3QDUE The recording contains two parts. One being a song with digital drums with a sub bass on the kick and a finger snapping sound used as a snare. A steeldrum sample is playing a repeating melody while a male voice is rapping in a higher pitch along to backing vocals creating a cheerful atmosphere. Then the song stops and you can hear mobile phones ringing. Two male voices are talking to each other. Then the recording stops with a beeping sound. This recording may be playing in a movie scene. ["rap", "mobile phones ringing", "male voices talking", "backgroundnoises", "male voice rapping", "higher register", "medium tempo"] ["Dial tone", "Music of Asia", "Music", "Speech"] 6 90 100 0 0 ["/m/015jpf", "/m/028sqc", "/m/04rlf", "/m/09x0r"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);