musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "fruity male vocal" and musiccaps_aspects contains "noisy" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- fruity male vocal · 3 ✖
- low quality 3
- noisy · 3 ✖
- accordion melody 1
- acoustic rhythm guitar 1
- buzzy guitar amp 1
- clapping 1
- cool 1
- country blues 1
- electric guitar chords 1
- emotional 1
- groovy 1
- groovy bass 1
- groovy electric guitar melodies 1
- hopeful 1
- live performance 1
- mellow snare 1
- mono 1
- passionate 1
- shimmering bells 1
- shimmering cymbals 1
- soft kick hits 1
- speaking 1
- tutorial 1
- uptempo 1
- vintage 1
musiccaps_names (array) 15 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
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 | |
Arany Zoltán & World Music Syndicate - La molinera | The low quality recording features a live performance that consists of fruity male vocal singing over accordion melody, acoustic rhythm guitar chords and shimmering bells. It sounds emotional and hopeful. The recording is a bit noisy and in mono, as it was probably recorded with a phone. | 2013-12-20T09:55:03Z | Arany Zoltán | https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ Arany Zoltán - fiddle Gonda Szabolcs - guitar Gonda "Sikh" Zoltán - bass Huszti László - percussion Mangu Róbert - percussion Made by Kilincsfilm | ["Folk music", "Acoustic guitar", "Music", "Middle Eastern music"] | ["low quality", "live performance", "fruity male vocal", "accordion melody", "acoustic rhythm guitar", "shimmering bells", "emotional", "hopeful", "mono", "noisy"] | 4 | -nlkWWphiaM | 85 |
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;