musiccaps_details (view)
1 row where musiccaps_aspects contains "guitar strings", musiccaps_aspects contains "low quality recording", musiccaps_names contains "Acoustic guitar" and musiccaps_names contains "Guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;