musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "distortion guitar", musiccaps_aspects contains "male voice" and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- distortion guitar · 3 ✖
- male voice · 3 ✖
- moderate tempo 2
- bass 1
- fast tempo 1
- glam rock 1
- happy mood 1
- hard rock 1
- heartbeat 1
- knife honing sound effect 1
- narration 1
- percussion 1
- percussion beat 1
- punk rock 1
- rock bass 1
- rock percussion 1
- shimmer sound 1
- upbeat song 1
musiccaps_names (array) 7 ✖
- Music 3
- Punk rock · 3 ✖
- Heavy metal 2
- Progressive rock 2
- Grunge 1
- Rock music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
1 Million Likes!!! | This song starts off with 2 heartbeats. The sound of a knife being honed is played. After this, we hear a short blasting sound. This is followed by a fast paced percussion starting off with a roll and then playing -two strokes on a hi-hat and one stroke on the snare drum. A male voice speaks in a narrative voice with a distortion guitar playing power chords in the background. The rest of the instruments continue playing in the background while the voice is narrating. | 2013-07-12T06:05:38Z | The Red Jumpsuit Apparatus | https://www.facebook.com/redjumpsuitapparatus http://www.fuelonline.co/ WE WANT TO THANK EVERYONE FOR ALL YOUR SUPPORT!!! HERE'S TO A MILLION MORE LIKES!! ~RJA | ["Music", "Punk rock", "Rock music"] | ["percussion beat", "heartbeat", "knife honing sound effect", "distortion guitar", "shimmer sound", "male voice", "narration", "moderate tempo"] | 0 | Ir82jewhXCo | 1948 | |
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;