musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar melody", musiccaps_names contains "Banjo" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- electric guitar melody · 2 ✖
- low quality 2
- acoustic rhythm guitar melody 1
- background instrumental music 1
- banjo 1
- crowd noises 1
- energetic 1
- flat male vocal 1
- folk 1
- groovy bass 1
- live performance 1
- noisy 1
- passionate 1
- punchy snare 1
- shimmering cymbals 1
- soulful 1
- steel guitar solo melody 1
- tutorial 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 7 ✖
- Banjo · 2 ✖
- Guitar 2
- Music · 2 ✖
- Musical instrument 2
- Plucked string instrument 2
- Effects unit 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
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 |
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;