musiccaps_details (view)
2 rows where musiccaps_aspects contains "programmed percussion" and musiccaps_names contains "Drum and bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- male voice 2
- moderate tempo 2
- programmed percussion · 2 ✖
- bass 1
- club music 1
- dj song 1
- explicit lyrics 1
- hand claps 1
- hip-hop song 1
- rap 1
- repetitive synth melody 1
- synth backing 1
- synth bursts 1
- techno song 1
- vocal effect 1
musiccaps_names (array) 8 ✖
- Drum and bass · 2 ✖
- Music 2
- Dubstep 1
- Electronic dance music 1
- Electronic music 1
- Independent music 1
- Rapping 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pendulum - Blood Sugar + Lyrics [HQ] | This techno song starts off with a synth playing a melody followed by another synth playing a burst of two chords. The two chord bursts are accompanied by percussion playing an outro roll. The instruments pause and a male voice starts to narrate a few lines. After two lines, the pitch of the voice is lowered in pitch to reach a bass pitch. This voice fades away to silence. This song can be played in a movie featuring a robot. | 2010-01-08T17:57:19Z | Ascendic | Thanks for 500.000 views, you guys rock! They have returned! https://www.facebook.com/pendulum/photos/a.498356746152.287685.24979476152/10153868789116153/?type=3&theater Lyrics: Ladies and Gentlemen we understand that you have come tonight to bear witness to the sound of drum... and... bass We regret to announce that this is not the case as instead, we come tonight to bring you, the sonic recreation of the end of the World Ladies and Gentlemen prepare to Hold Your Colour! Okay, fuck it, I lied it's drum and bass ... what you gonna do!? | ["Drum and bass", "Electronic music", "Music", "Independent music", "Speech"] | ["techno song", "dj song", "synth bursts", "male voice", "vocal effect", "explicit lyrics", "programmed percussion", "moderate tempo"] | 0 | XPGtOugQ69U | 3182 | |
Big Dog YoGo - Go Hard Or Go Home (J.West Production)...Official Music Video BTB | This hip-hop song features a male voice rapping the main lyrics. This is accompanied by programmed percussion playing a simple beat. Hand claps are played on every alternate count. The synth plays a repetitive melody in loop. The bass plays the root notes of the chords in harmony with the synth. This is a moderate tempo song. This song can be played in a club. | 2010-10-16T02:02:34Z | BRUMSOUNDS | Download YoGo Mixtape Goon Tunez Vol1 @ http://grimeblog.com/?p=1419 | ["Drum and bass", "Music", "Rapping", "Dubstep", "Electronic dance music"] | ["hip-hop song", "rap", "male voice", "synth backing", "hand claps", "repetitive synth melody", "moderate tempo", "club music", "programmed percussion", "bass"] | 0 | vEMNk-lbGTE | 5165 |
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;