musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no other instruments" and musiccaps_aspects contains "no 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 |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Dust In The Wind - Vocal Cover. | This slow rock song starts with an acoustic guitar playing chords in fingerstyle. For each chord, a pedal bass note is played while the higher pitch notes are played in a repeated sequence of three notes being played one after the other. A male voice sings the main melody. There are no other instruments in this song. This song can be played in a movie scene where a car is driving across a deserted highway. | 2009-10-12T20:44:26Z | Aaron James Haslam Guitar Covers | This is my dads cover of the great Kansas song Dust in the wind. He's wanted to record this song for a long time so we decided to get him into our home studio. Recorded raw onto a backing track. Pretty good I think you'll agree? Look out for our original tunes coming soon! | ["Music", "Bluegrass"] | ["slow rock song", "male voice", "acoustic guitar", "fingerstyle guitar", "moderate tempo", "no other instruments", "no percussion", "pedal bass notes"] | 0 | wc4UEh8wvCA | 5278 |
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;