musiccaps_details (view)
2 rows where musiccaps_aspects contains "speaking" and musiccaps_aspects contains "tutorial"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- speaking · 2 ✖
- tutorial · 2 ✖
- buzzy guitar amp 1
- conga 1
- differing tones 1
- electric guitar chords 1
- fruity male vocal 1
- low quality 1
- noisy 1
- random percussion 1
musiccaps_names (array) 9 ✖
- Drum 1
- Electronic tuner 1
- Guitar 1
- Music 1
- Musical instrument 1
- Percussion 1
- Plucked string instrument 1
- Speech 1
- Tabla 1
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 | |
Conga Lessons with Jerry Rivera | This is a tutorial on how to use the conga percussion instrument. The American tutor narrates his actions as he plays. There are two tones - the open tone is lower and the closed tone is higher pitched. | 2011-10-11T17:07:31Z | trueseven | Conga Lesson 1 with Jerry Rivera | ["Tabla", "Drum", "Percussion"] | ["conga", "tutorial", "speaking", "random percussion", "differing tones"] | 3 | xXRGgPVnkqk | 5338 |
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;