musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "electric guitar melody" and musiccaps_names contains "Speech" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- electric guitar melody · 4 ✖
- low quality 4
- flat male vocal 3
- noisy 3
- groovy 2
- groovy bass 2
- punchy snare 2
- accordion melody 1
- background instrumental music 1
- banjo 1
- crowd chattering 1
- distorted 1
- folk 1
- fun 1
- funny 1
- happy 1
- live performance 1
- metallic impact 1
- mono 1
- passionate 1
- shimmering cymbals 1
- shimmering hi hats 1
- stuttering vocal sound effect 1
- sustained strings 1
- tutorial 1
musiccaps_names (array) 17 ✖
- Music 4
- Speech · 4 ✖
- Musical instrument 3
- Guitar 2
- Plucked string instrument 2
- Accordion 1
- Banjo 1
- Bass guitar 1
- Bell 1
- Blues 1
- Effects unit 1
- Harmonic 1
- Music of Latin America 1
- Orchestra 1
- Rhythm and blues 1
- Singing 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to make guitar sound like banjo and cool bell sound | The low quality recording features a tutorial on how to make the electric guitar sound like a banjo. It consists of a flat male vocalist talking over the background instrumental music, after which he starts playing the electric guitar. The recording is noisy. | 2007-11-04T00:51:59Z | lpknocko | guitar effects how to make a regular electric guitar sound like banjo and cool bell sound. | ["Banjo", "Effects unit", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["flat male vocal", "background instrumental music", "electric guitar melody", "banjo", "tutorial", "low quality", "noisy"] | 4 | NnYfF7E12dk | 2364 | |
Thomas & Friends ep 18 A Bad Day for Freddie | The low quality recording features a flat male vocal talking over electric guitar melody and sustained strings, with some metallic impact sound and stuttering vocal sound effect. It sounds funny and the recording is noisy and in mono. | 2008-07-24T18:28:24Z | Daniel Alsop | Here's the 2nd narrow gauge episode this time featrueing Fearless Freddie. | ["Bell", "Music", "Speech"] | ["low quality", "noisy", "mono", "flat male vocal", "stuttering vocal sound effect", "sustained strings", "electric guitar melody", "metallic impact", "funny"] | 4 | q7sK_xrJz-k | 4755 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | 2012-11-21T19:01:01Z | TrueFire | *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | 4 | NZ2kFIaW05k | 2345 |
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;