musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- energetic 2
- flat male vocal · 2 ✖
- groovy bass · 2 ✖
- punchy kick 2
- punchy snare 2
- rock · 2 ✖
- background male vocal 1
- echoing electric guitar melody 1
- electric guitars melodies 1
- emotional 1
- low quality 1
- shimmering cymbals 1
- shimmering hi hats 1
- uplifting 1
- wide electric guitar chord progression 1
- wide harmonizing male vocals 1
musiccaps_names (array) 7 ✖
- Music 2
- Drum kit 1
- Guitar 1
- Jazz 1
- Musical instrument 1
- Punk rock 1
- Rock music 1
youtube_published (date) 2 ✖
- 2007-06-24 1
- 2014-12-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BIONICLE 2015 Music Video: Ride | The Rock song features wide harmonizing male vocals singing over wide electric guitar chord progression, punchy snare and kick hits, shimmering cymbals and groovy bass. At the very beginning of the loop there is a flat male vocal singing over echoing electric guitar melody and less energetic drums, after which the previously mentioned chorus starts. It sounds energetic and uplifting. | 2014-12-17T11:18:06Z | iBunny | Please like this video, and feel free to leave a comment below. Have a friend who's excited for the relaunch of BIONICLE? Share this video with them! The song is Ride by Presence ================================================ Made using the animated clips from: LEGO.com/BIONICLE All media used in this video are the property of their respective owners (which is not me). This video is not, and will not be monetized in the future. | ["Jazz", "Music"] | ["rock", "wide harmonizing male vocals", "flat male vocal", "wide electric guitar chord progression", "echoing electric guitar melody", "punchy snare", "punchy kick", "shimmering cymbals", "groovy bass", "energetic", "uplifting"] | 4 | BYwS1dJRTi0 | 1258 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;