musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "punk rock" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- fast tempo 3
- instrumental · 3 ✖
- punk rock · 3 ✖
- catchy 2
- upbeat 2
- vibrant 2
- youthful 2
- aggressive 1
- amplified guitar 1
- animated 1
- bass guitar 1
- complex harmony 1
- distorted electric guitar 1
- dub 1
- electric guitar feedback 1
- electric guitar melody 1
- energetic 1
- energetic drumming 1
- enthusiastic 1
- enthusiastic electric guitar lead 1
- external amplification 1
- funk pop 1
- funky 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- guitar harmony 1
- infectious drumming 1
- intense drumming 1
- keyboard harmony 1
- loud 1
- loud acoustic drums 1
- loud electric guitar feedback 1
- rock 1
- sonic power 1
- sonic treat 1
- synth rock 1
- synthesiser articulation 1
- upbeat catchy 1
- upbeat vivacious 1
- vibrations 1
- violent 1
- vivacious 1
musiccaps_names (array) 15 ✖
- Music 2
- Ambient music 1
- Bass drum 1
- Bass guitar 1
- Blues 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Percussion 1
- Rimshot 1
- Rock and roll 1
- Rock music 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funk Step Paul Reed Smith Single Cut Trem Demo - Funk Rock PRS Demo - Crunch Sound PRS | This music is instrumental. The tempo is fast with an electric guitar playing a bright lead with infectious drumming and syncopated bass lines. The music is upbeat, energetic, youthful, animated, spirited, enthusiastic, groovy and funky. | 2013-11-05T09:44:52Z | Marco Cirillo | Funk Step Paul Reed Smith Single Cut Trem Demo - Funk Rock PRS Demo - Crunch Sound PRS This is an old Demo of this beautiful Guitar. Prs Single Cut Trem is a quite versatile Electric Guitar with Humbucker Pickup and Switch for Single Coil. The quality Video is not that good as I said this is an old video, but I hope it can help you to have an Idea of the sound..... Thank you for watching. Subscribe and Keep Update | ["Blues", "Bass guitar", "Music", "Rock music", "Rock and roll"] | ["instrumental", "fast tempo", "amplified guitar", "loud electric guitar feedback", "sonic power", "sonic treat", "external amplification", "vibrations", "funk pop", "youthful", "punk rock", "energetic drumming", "funky bass line", "enthusiastic electric guitar lead", "infectious drumming", "catchy", "upbeat", "vibrant", "complex harmony", "loud", "enthusiastic", "youthful", "guitar harmony", "funky", "groovy", "upbeat catchy"] | 7 | VM-U7MyZAck | 2993 | |
Super Smash Bros 64 move swap | This song is an instrumental. The tempo is fast with an animated keyboard harmony, funky bass lines; groovy electric guitar melody, slick drumming and synthesiser arrangements. The instrumental is upbeat, catchy, vibrant, animated, youthful and vivacious. This song is an Electro Rock/ Synth Rock. | 2009-04-18T22:29:08Z | YoYoSpln | Super Smash Bros 64 move swap HEX | ["Music", "Ambient music"] | ["instrumental", "fast tempo", "synthesiser articulation", "electric guitar melody", "keyboard harmony", "upbeat", "vivacious", "youthful", "electric guitar feedback", "groovy bass lines", "intense drumming", "animated", "vibrant", "catchy", "youthful", "upbeat vivacious", "rock", "synth rock", "punk rock"] | 7 | VNjYW4OXqTs | 2996 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 |
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;