musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "uplifting"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- groovy bass · 3 ✖
- uplifting · 3 ✖
- flat male vocal 2
- 4 on the floor kick 1
- accordion melody 1
- addictive 1
- echoing electric guitar melody 1
- electric guitar licks 1
- energetic 1
- energetic open hats 1
- flat echoing male vocal 1
- folk 1
- happy 1
- low quality 1
- metallic snare 1
- offbeat acoustic rhythm guitar chords 1
- offbeat electric guitar chords 1
- percussive elements 1
- punchy kick 1
- punchy snare 1
- reggae 1
- rock 1
- shimmering cymbals 1
- shimmering shakers 1
- simple kick 1
- wide background harmonizing female vocals 1
- wide electric guitar chord progression 1
- wide harmonizing male vocals 1
- wide piano chords 1
- wide tinny percussive elements 1
musiccaps_names (array) 9 ✖
- Music 3
- Afrobeat 2
- Music of Africa 2
- Funk 1
- Jazz 1
- Mouse 1
- Reggae 1
- Salsa music 1
- Ska 1
youtube_published (date) 3 ✖
- 2009-08-17 1
- 2009-12-20 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 | |
Eek A Mouse - Talking About The Business | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | 2009-08-17T08:56:37Z | GJW | album: eeksperience release: 2001 label: Rfo Records | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | 4 | R5JRh08zgMo | 2666 | |
villa maipu en bus | The Folk song features a flat, echoing male vocal talking over addictive accordion melody, wide piano chords, groovy bass, "4 on the floor" kick pattern, tinny percussive elements, energetic open hats, shimmering shakers and offbeat electric guitar chords. It sounds uplifting and low quality. | 2009-12-20T01:34:44Z | 14Juampa | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Salsa music"] | ["folk", "flat echoing male vocal", "accordion melody", "wide piano chords", "groovy bass", "4 on the floor kick", "percussive elements", "shimmering shakers", "energetic open hats", "offbeat electric guitar chords", "uplifting", "addictive", "low quality"] | 4 | b4FomUpNaJE | 3600 |
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;