musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "synth sounds" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- moderate tempo · 2 ✖
- synth sounds · 2 ✖
- dance song 1
- female backing voice 1
- groovy bass 1
- hip-hop feel 1
- lead male voice 1
- male backing voices 1
- male voice 1
- percussion 1
- rap song 1
- reggaeton 1
- repetitive synth melody 1
- romantic mood 1
- shaker 1
- trap beat 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BITTER ROCC - MMXIII Deluxe - Run these rats out (promo music video) | This song features a male voice rapping the lyrics. Female voices sing vocables in the background. This is accompanied by programmed percussion playing a trap beat. The bass plays a groovy bassline by sliding to notes rather than pausing in between notes. A synth plays a repetitive melody in the background. This song can be played in a gangster movie. | 2014-04-27T13:45:48Z | ROCAnimation | MMXIII Deluxe edition available on iTunes only 30.05.14. 'Run these rats out' only available on MMXIII Deluxe. Directed by ROC. assisted by Darrell Long, Evan Flynn. TheRocCollective.com BR MUSIC (C) 2014. | ["Music", "Hip hop music"] | ["rap song", "trap beat", "male voice", "female backing voice", "synth sounds", "repetitive synth melody", "moderate tempo", "groovy bass"] | 0 | 3KdyWJ6wTOw | 457 | |
reggaeton romantico mix 2009 | This reggaeton song features a male voice singing the main melody. This is accompanied by other male voices singing backing vocals. The percussion plays only in the second half of the song. The beat is a reggae beat. A shaker plays a rhythm in the beginning of the song when the main voice sings. Synth sounds are played in the beginning of the song. This synth plays a harpsichord voice. Synth strings are also played in between lines in the song. This song can be played in a club. | 2009-01-09T00:50:08Z | DJAZOGUES | reggaeton romantico | ["Afrobeat", "Music", "Rapping", "Hip hop music"] | ["reggaeton", "percussion", "lead male voice", "male backing voices", "shaker", "moderate tempo", "synth sounds", "hip-hop feel", "dance song", "romantic mood"] | 0 | 9oiSwXk8Nsk | 1045 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;