musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male voice" and "youtube_published" is on date 2013-02-13 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- male voice · 2 ✖
- acoustic gutiar 1
- double stop 1
- electric guitar 1
- instructional clip 1
- moderate tempo 1
- narration 1
- no other instruments 1
- no percusion 1
- pentatonic scale descending run 1
- string bending 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kraft Music - Yamaha APX and CPX Series Demo with Jake Blake | This clip features a male voice narrating about guitars. In the background, an acoustic guitar is strumming chords and picking notes used as fills. The mood of the song is happy and uptempo. There are no other instruments in this song. This song can be played in a romantic mood. This audio can be used in a guitar promotional video. | 2013-02-13T19:14:08Z | Kraft Music | Find exclusive Yamaha guitar packages at Kraft Music. Our guitar bundles ship with all the accessories you need to go along with your new instrument: http://www.kraftmusic.com/brands/yamaha/guitars/acoustic-electric/?utm_source=youtube&utm_medium=video&utm_content=vid&utm_campaign=yam-apx-cpx-blowout Kraft Music team member Jake Blake demonstrates the Yamaha APX700II, CPX700II, APX1000, and CPX1000 acoustic electric guitars. | ["Music", "Speech", "Happy music"] | ["acoustic gutiar", "male voice", "narration", "moderate tempo", "no percusion", "no other instruments"] | 0 | 1O4LpU7HggY | 264 | |
Stevie Ray Vaughan - Love Struck Baby - Blues Guitar Intros - SRV - Blues Guitar Lessons | This audio clip features an instruction of playing the guitar. An electric guitar plays a descending pentatonic run at two different places on the guitar to give a different feel. The voice narrates the process of playing the notes. This is followed by a double stop which is played seven times with a string bend on the eighth time. This can be used in an instruction video. | 2013-02-13T21:04:13Z | GuitarJamz | Please watch: "Beginner Acoustic guitar lesson "Tom Petty I won't back down" How to" https://www.youtube.com/watch?v=xJDQyT1zStY --~-- Click Here http://www.guitarjamz.com/ytblues | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "instructional clip", "male voice", "pentatonic scale descending run", "double stop", "string bending"] | 0 | rn_v88OiRks | 4902 |
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;