musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "percussion" and musiccaps_aspects contains "upbeat song" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- moderate tempo 2
- percussion · 2 ✖
- upbeat song · 2 ✖
- bass 1
- distortion guitar 1
- guitar 1
- instrumental 1
- male voice 1
- no voices 1
- pop rock 1
- punk rock 1
musiccaps_names (array) 6 ✖
- Music 2
- Funk 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
akira's fixed gear DVD called 'street life' teaser! | This pop rock song features a guitar riff being played. This guitar has a chorus effect added to the sound. Another guitar plays one chord in a three stroke grouping. The bass plays only one note throughout the song. This is accompanied by percussion playing a simple beat in common time. There are no voices in this song. This is an instrumental song. This song can be played in a movie with sports as the focus. | 2007-01-23T05:43:17Z | Kennicam | top leading skateboarders of T19 made a fixed gear DVD last year('06) its coming out this Feb. 07 check it out and witeness with your own eyes what its really like in tokyo bike scene that you probably dont know much about!!! | ["Funk", "Music"] | ["pop rock", "guitar", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat song"] | 0 | lePP2BaZhJU | 4412 | |
tribute to Oi, ska & Punk | This punk rock song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat. A distortion guitar plays power chords using downstrokes. The bass plays the root notes of the chords. This song is played at a moderate tempo. This song can be played at the end credits of an action movie. | 2009-04-29T02:58:40Z | skinbash69 | This is the tribute to all of my friends in the Oi, Ska & Punk Scene in the asian countries such as Singapore, Malaysia, Indonesia, Philippines & Brunei. Keep the scene alive...CHEER. | ["Heavy metal", "Music", "Punk rock", "Ska", "Progressive rock"] | ["punk rock", "male voice", "distortion guitar", "percussion", "bass", "moderate tempo", "upbeat song"] | 0 | PP3kNqPM434 | 2532 |
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;