musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic rhythm guitar" and musiccaps_aspects contains "addictive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- acoustic rhythm guitar · 3 ✖
- addictive · 3 ✖
- low quality 3
- energetic 2
- groovy bass guitar 2
- passionate male vocal 2
- punchy snare 2
- rock 2
- shimmering hi hats 2
- bouncy snare hits 1
- country 1
- crowd clapping 1
- electric guitar chord progression 1
- electric rhythm guitar melody 1
- groovy bass 1
- harmonizing background vocals 1
- instrumental 1
- joyful 1
- live performance 1
- shimmering wide cymbals 1
- simple kick 1
- soft kick hits 1
- steel guitar repetitive guitar 1
- wide toms roll 1
musiccaps_names (array) 7 ✖
- Music 2
- Blues 1
- Exciting music 1
- Grunge 1
- Punk rock 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Silversun Pickups - Kissing Families [Official Music Video] | The low quality recording features a rock song instrumental that consists of shimmering hi hats, punchy snare, groovy bass guitar, acoustic rhythm guitar in the left channel and electric guitar chord progression in the right channel of the stereo image. It sounds energetic and addictive. | 2009-03-20T17:08:17Z | Silversun Pickups | Directed by Suzie Vlcek Get PIKUL here: http://smarturl.it/sspupikulEP http://silversunpickups.com http://twitter.com/sspu http://instagram.com/sspu http://facebook.com/silversunpickups | ["Music", "Exciting music"] | ["low quality", "rock", "instrumental", "shimmering hi hats", "punchy snare", "groovy bass", "acoustic rhythm guitar", "electric guitar chord progression", "energetic", "addictive"] | 4 | -XN0NtrnfMY | 58 | |
Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
The Crags - Please, Sniff The Air (Official) | The low quality recording features a rock song that consists passionate male vocal, alongside, harmonizing background vocals, singing over shimmering wide cymbals, bouncy snare hits, soft kick hits, electric rhythm guitar melody in the left channel, groovy bass guitar, acoustic rhythm guitar in the right channel of the stereo image and some wide toms roll. It sounds addictive and energetic. | 2015-08-24T07:36:04Z | Mathieu Epiney | Please, Sniff The Air by The Crags © 2015 www.thecrags.ch https://www.facebook.com/thecragsmusic Music Video by EPIDEMIC music video epidemic.ch epidemicmusicvideos@gmail.com Recorded & Mixed by Claude Lander @ Taurus Studio | ["Music", "Punk rock", "Grunge", "Soul music"] | ["low quality", "rock", "passionate male vocal", "harmonizing background vocals", "shimmering wide cymbals", "bouncy snare hits", "soft kick hits", "electric rhythm guitar melody", "groovy bass guitar", "wide toms roll", "addictive", "energetic", "acoustic rhythm guitar"] | 4 | U-UF93NA3ko | 2881 |
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;