musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy kick" and musiccaps_names = "["Jazz", "Music"]"
This data as json, CSV (advanced)
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 | |
Shukri Jamal - Abbaan lafaa dhabe lafasaa (Oromo Music 2014 New) | The low quality recording features an echoing flat male vocal, alongside harmonizing male vocal, singing over sustained strings melody, shimmering open hats, wooden percussions, punchy kick and groovy bass. It sounds traditional and passionate. | 2014-04-18T18:56:19Z | Oromp3 | Check http://www.oromp3.com/ for more Oromo music, comedy, drama & MP3 Songs. | ["Jazz", "Music"] | ["low quality", "echoing flat male vocal", "wooden percussions", "shimmering open hats", "sustained strings melody", "punchy kick", "groovy bass", "joyful", "passionate", "traditional", "harmonizing male vocal"] | 4 | Bap5P9buB0Y | 1264 |
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;