musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality recording" and musiccaps_names contains "Guitar" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- low quality recording · 2 ✖
- bassline 1
- birds noises in the background 1
- distortion guitar 1
- guitar strings 1
- guitar tuning check 1
- male voice 1
- metal song 1
- moderate tempo 1
- multiple guitars 1
- no other instruments 1
- no voice 1
- out of time guitar 1
- playing with plectrum 1
- power drumming 1
musiccaps_names (array) 8 ✖
- Guitar · 2 ✖
- Music 2
- Plucked string instrument 2
- Acoustic guitar 1
- Electronic tuner 1
- Musical instrument 1
- Roll 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 | |
GUITAR TUNER 🎸📟 - 1 STEP DOWN / Acoustic Guitar - D Standard = D G C F A D / GuiTuners 🎸 | This clip features a guitar being tuned. The first note played is the open note on the D string. Then the third string, G, is plucked three times. There are no other instruments in this clip. This is a low quality recording and sounds of birds can be faintly heard in the background. | 2016-01-23T23:31:44Z | GuiTabs | GuiTabs Class - Tuning: 1/D; 2/A; 3/F; 4/C; 5/G; 6/D ♫ Click Here To Subscribe : http://goo.gl/mrJrYl ------------------------------------------------------------------------------ #Guitar #Tuner #Tuning ► Other Tuners: ♫ Tuners List: → https://youtu.be/qqewCwUL7hY ♫ Standard Acoustic: → https://youtu.be/2QBJjX1fNH4 ♫ Standard Electric: → https://youtu.be/wGpynzZ6-lI ♫ Standard Classic: → https://youtu.be/WR1vSIeX-is ♫ Standard Acoustic 12 Strings: → https://youtu.be/P2BgEq_UyLo ♫ Standard Acoustic ½ Step Down: → https://youtu.be/O1IHpiCVQ58 ♫ Standard Electric ½ Step Down: → https://youtu.be/BppMAWfyosM ♫ Standard Classic ½ Step Down: → https://youtu.be/ykjVqRCRYKk ♫ Standard Acoustic 1 Step Down: → https://youtu.be/iQ7qeIrssds ♫ Standard Electric 1 Step Down: → https://youtu.be/hEJKBrzN86w ♫ Standard Classic 1 Step Down: → https://youtu.be/z3uMtL3FB18 ♫ Acoustic Open D: → https://youtu.be/4d6ALDlqHyU ♫ Acoustic Open E: → https://youtu.be/WweviSS9D6k ♫ Acoustic Open G: → https://youtu.be/oxdgo7L--jE ♫ Acoustic Drop C: → https://youtu.be/kjHgupbjg_c ♫ Acoustic Drop D: → https://youtu.be/4IliTjioe_8 ♫ Standard Bass: → https://youtu.be/f0b6MBtPDSI ♫ Standard Ukulele: → https://youtu.be/w898dD1TkK8 ♫ Standard Mandolin: → https://youtu.be/9c6ZDig_0lI ♫ Standard Requinto: → https://youtu.be/EotxGS6YXwc ► Social Networks: All about Music and much more → Facebook: https://www.facebook.com/GuiTabs/ → Twitter: https://twitter.com/GuitTabs/ → Google +: https://plus.google.com/+GuiTabs/ → BlogSpot: http://guitabz.blogspot.pe/ → YouTube: http://www.youtube.com/c/GuiTabs/ --------------------------------------------------- See you in the next video ☺ ♫ | ["Guitar", "Acoustic guitar", "Music", "Strum", "Electronic tuner", "Plucked string instrument"] | ["guitar strings", "low quality recording", "birds noises in the background", "playing with plectrum", "guitar tuning check", "no other instruments", "no voice"] | 0 | iQ7qeIrssds | 4181 |
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;