musiccaps_details (view)
2 rows where musiccaps_aspects contains "no voices", musiccaps_aspects contains "percussion" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- no voices · 2 ✖
- percussion · 2 ✖
- bass 1
- compound time signature 1
- descending bassline 1
- distortion guitar 1
- distortion guitars 1
- guitar solo 1
- happy mood 1
- heavy metal 1
- instrumental 1
- low quality sound 1
- moderate tempo 1
- slow blues 1
musiccaps_names (array) 7 ✖
- Music 2
- Rock music · 2 ✖
- Grunge 1
- Inside, large room or hall 1
- Inside, public space 1
- Progressive rock 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Iron Maiden - The Clairvoyant | This clip features low quality audio. The song is a heavy metal song where a guitar solo is played on the higher register of the scale. This is accompanied by percussion playing an uptempo beat. The bass plays a heavy riff using open notes and its octave. The distortion guitar plays power chords. There are no voices in this song. This is an instrumental song. This song can be played in a racecar sequence in a movie. | 2006-04-22T14:12:37Z | lammeaap | The Clairvoyant played live at Birmingham during the Seventh Tour of a Seventh Tour. | ["Music", "Rock music", "Inside, large room or hall", "Inside, public space"] | ["low quality sound", "heavy metal", "guitar solo", "no voices", "bass", "percussion", "distortion guitars", "happy mood", "instrumental", "moderate tempo"] | 0 | CdWA-SNcYpM | 1386 | |
Back Door Slam, Aint No City | This slow blues song features a distortion guitar playing a guitar solo and the song is in 6/8 time signature. This is accompanied by a bass guitar playing a descending bassline. The percussion is playing a simple beat over a 6/8 time signature with a roll at the end of the bar. There are no voices in this song. This song can be played in a spy movie in a scene when a plan is being executed. | 2006-10-09T16:59:16Z | Christy DeHaven | Live at the Gaiety Theatre June 2006. Taken from full length DVD out November 2006 - buy it here http://www.loverboyrecords.com/shop.htm (only available in PAL format) | ["Music", "Rock music", "Rock and roll", "Progressive rock", "Grunge"] | ["slow blues", "no voices", "distortion guitar", "descending bassline", "compound time signature", "percussion"] | 0 | y7PtSsbkGdM | 5384 |
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;