musiccaps_details (view)
2 rows where musiccaps_aspects contains "distortion guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "low quality audio"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- distortion guitar · 2 ✖
- instrumental · 2 ✖
- low quality audio · 2 ✖
- no voices 2
- bass 1
- electric guitar 1
- fast paced percussion 1
- fast tempo 1
- folk rock 1
- guitar solo 1
- harmonics 1
- moderate tempo 1
- percussion 1
- rock song 1
- staccato violin 1
- string bending 1
- uptempo 1
musiccaps_names (array) 9 ✖
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 | |
Tomáš Valášek - www.kytarova-skola.com, www.kytara-online.cz | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | 2010-04-24T08:39:01Z | kytarovaskola | www.kytara-online.cz, www.kytarova-skola.com. | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | 0 | CM7jMnBXw2Y | 1356 |
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;