musiccaps_details (view)
1 row where musiccaps_aspects contains "tutorial", musiccaps_author = 4, musiccaps_names contains "Steel guitar, slide guitar" and "youtube_published" is on date 2013-07-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Pixies - Where Is My Mind Guitar Lesson (Intro, Lead, Guitar Solo, Chords and more!) | The low quality recording features a tutorial where a flat male vocalist is talking, after which he plays an arpeggiated acoustic guitar melody. The recording is extremely noisy. | 2013-07-03T17:41:40Z | GuitarMadeEZ.com | This is the guitar lesson for the pixies song where is my mind off the fight club soundtrack. This guitar tutorial covers how to play the song, the struming pattern, guitar chords used and also covers the guitar solo in depth! Where is my mind is a great song to learn how to play. Please like and comment. Thanks! | ["Music", "Steel guitar, slide guitar", "Speech", "Plucked string instrument"] | ["low quality", "noisy", "arpeggiated acoustic guitar", "flat male vocal", "tutorial"] | 4 | ieEPKa3HiGo | 4211 |
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;