musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distortion guitar" and musiccaps_aspects contains "fast tempo" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- distortion guitar · 2 ✖
- fast tempo · 2 ✖
- electric guitar 1
- fast paced percussion 1
- folk rock 1
- glam rock 1
- happy mood 1
- hard rock 1
- instrumental 1
- low quality audio 1
- male voice 1
- no voices 1
- rock bass 1
- rock percussion 1
- staccato violin 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Music 2
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Roll 1
- Singing 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arcade Fire (live) - "Poupee de Cire, Poupe de son" | This folk rock song features an electric guitar playing the main melody in the form of a solo. This is accompanied by fast paced percussion. Another guitar plays a galloping rhythm. A violin plays staccato notes at a fast tempo and the notes follow the root notes of the chords but at higher octaves. This is an instrumental song with no voices. This song has a hippie feel. This song can be played in a retro movie with a hippie theme. | 2007-10-04T15:11:40Z | Ismael Fernandez | A "new" song from Arcade Fire performed at the Olympia Theater in Paris. It's a cover of an old song. http://www.youtube.com/watch?v=8OHJEm2IwLw | ["Singing", "Music", "Roll"] | ["folk rock", "no voices", "instrumental", "fast tempo", "low quality audio", "electric guitar", "distortion guitar", "fast paced percussion", "staccato violin", "uptempo"] | 0 | 752bW5cjXzw | 808 | |
chopping new zealand maize 2014 | This hard rock song features a male voice singing the main melody. The song starts with a distortion guitar playing a riff. The percussion plays a simple beat in common time. Once the voice starts singing, the guitars play power chords using down strokes. The bass follows the root notes of the chords. The mood of this song is happy. This song can be played in a car chase sequence in a movie. | 2014-06-15T20:17:58Z | snoopfizzel | john Austin maize season new Zealand | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["hard rock", "glam rock", "male voice", "happy mood", "distortion guitar", "rock percussion", "fast tempo", "rock bass"] | 0 | Gde1fn1Y1uM | 1745 |
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;