musiccaps_details (view)
1 row where musiccaps_aspects contains "punchy snare", musiccaps_aspects contains "shimmering cymbals", musiccaps_aspects contains "uplifting" and musiccaps_aspects contains "wide electric guitar chord progression"
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 |
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;