musiccaps_details (view)
1 row where musiccaps_aspects contains "buzzy guitar amp", musiccaps_aspects contains "fruity male vocal", musiccaps_aspects contains "speaking" and musiccaps_names contains "Musical instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Psychobilly guitar tutorial - psychobilly blues/boogie | The low quality recording features a tutorial where a fruity male vocalist is talking in-between electric guitar chords. There is a very buzzy guitar amp in the background and the recording is very noisy. | 2012-07-16T14:01:01Z | Adrian Whyte | Tabs Available for a few dollars here: Support, Get Access to the tabs for the intro and heaps of other things! https://www.patreon.com/Adrianwhyte Checkout my original psychobilly band 'the Vaudevilains' (now defunct but stuff is on itunes) and see my solo album 'Death Rides a Harley" A run through of psychobilly styled chord progression based on the blues, with some theoretical insight towards the end of the video on the tones that give psychobilly that kooky sound! Skype lessons now available - just pm me! Thanks!! Adrian | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["tutorial", "fruity male vocal", "speaking", "electric guitar chords", "low quality", "buzzy guitar amp", "noisy"] | 4 | _KaRkSyELy4 | 3465 |
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;