musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LADRON-MASKATESTA | This ska song features a trumpet playing the main melody. The trumpet plays one staccato note followed by a six note pattern and then plays the same sequence starting on a different root note. This is accompanied by percussion playing a simple beat. A keyboard plays chords in the background. The bass plays a groovy bassline. There are no voices in this song. This is an instrumental song. The mood of this song is happy. This song can be played in a comedy movie. | 2009-03-06T22:39:59Z | Hector Israel Reyes Leal | VERSION ORIGINAL | ["Music", "Ska"] | ["ska song", "keyboard", "trumpets", "bass", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat", "happy mood", "groovy bass", "simple beat", "simple song"] | 0 | AH6Xnyj6Ykc | 1097 | |
Tomáš Valášek - www.kytarova-skola.com, www.kytara-online.cz | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | 2010-04-24T08:39:01Z | kytarovaskola | www.kytara-online.cz, www.kytarova-skola.com. | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | 0 | CM7jMnBXw2Y | 1356 | |
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 | |
Lap Steel Lessons - Blues Licks Vol. 1 with Dave Anderson www.OnlineLessonVideos.com | This song features a solo played on a pedal steel guitar. This is a country blues melody. This involves slides on the guitar. This is accompanied by percussion playing a simple beat in common time. The bass plays 12 bar blues style bassline. An organ outlines chords in the background. This is an instrumental song. There are no voices. This song can be played in a bar. | 2010-01-29T00:33:04Z | OnlineLessonVideos | www.OnlineLessonVideos.com - Check it out for Full Lesson + TAB + Mp3 Backing Tracks! | ["Blues", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["pedal steel guitar solo", "slide guitar", "country song", "percussion", "bass", "organ", "no voices", "instrumental", "moderate tempo", "blues mood"] | 0 | W4nQpOHIPEw | 3061 |
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;