musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "wide harmonizing male vocals" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass 2
- punchy kick · 2 ✖
- wide harmonizing male vocals · 2 ✖
- brass section progression 1
- echoing electric guitar melody 1
- energetic 1
- euphoric 1
- excited 1
- flat male lead vocal 1
- flat male vocal 1
- fun 1
- happy 1
- muffled bells melody 1
- nostalgic 1
- punchy snare 1
- rock 1
- seasonal 1
- shimmering cymbals 1
- shimmering shaker bells 1
- simple piano chord progression 1
- soft snare 1
- staccato strings melody 1
- uplifting 1
- wide electric guitar chord progression 1
musiccaps_names (array) 4 ✖
- Music 2
- Christmas music 1
- Jazz 1
- Soul music 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 | |
Brian Lexus - The Christmas Song | This seasonal song features a flat male vocal, supported by wide harmonizing male vocals, singing over punchy kick, soft snare, groovy bass, shimmering shaker bells, muffled bells melody, staccato strings melody, brass section progression and simple piano chord progression. It sounds fun and happy, leaving the listener with the feelings of euphoria, nostalgia and excitement. | 2014-06-29T21:08:11Z | Grzegorz Burzyński | Lyrics and Music by Sebastian Kwiatkowski Brian Lexus - The Christmas Song | ["Christmas music", "Music", "Soul music"] | ["seasonal", "wide harmonizing male vocals", "flat male lead vocal", "soft snare", "groovy bass", "punchy kick", "simple piano chord progression", "muffled bells melody", "brass section progression", "staccato strings melody", "fun", "happy", "nostalgic", "euphoric", "excited", "shimmering shaker bells"] | 4 | BS2ZnUhmHj4 | 1239 |
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;