musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "pad" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- energetic · 3 ✖
- pad · 3 ✖
- dance 2
- electronic drums 2
- synth bass 2
- 80s pop 1
- acoustic drums 1
- bass guitar 1
- catchy 1
- electric guitar 1
- electro 1
- electronic dance music 1
- female vocal 1
- grandiose 1
- high tempo 1
- house 1
- hyperactive 1
- keyboard 1
- lead synth 1
- loud 1
- melbourne shuffle 1
- melodic singing 1
- pop music 1
- rave 1
- repeated theme 1
- simple 1
- sound effects 1
- vibrant 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
New Dance & Electro Mix || Best Electro House Mix 2014 - By Becko | This is a house music piece. It has a fuzzy synth lead playing the main melody while there is a medium-to-high pitch pad playing an arpeggio. There is a fuzzy synth bass in the background. A loud electronic drum beat provides the rhythmic background. There is a constant crowd cheering effect giving the impression of the piece being performed live. The atmosphere is energetic. This piece can be played at nightclubs and EDM venues. | 2014-11-21T13:21:44Z | Best Music | The Best Electro House Dance Mixes by Club Music!! Make sure to subscribe and like this video!! Free Download: http://bit.ly/1H4aF1M ▸Follow this Soundcloud for free downloads when it hits 10k: http://bit.ly/1Egulj1 ▸Follow CLUB MUSIC on Facebook: http://goo.gl/MSPI8q | ["Music", "Trance music", "Electronic dance music", "Dance music"] | ["dance", "electro", "house", "lead synth", "synth bass", "electronic drums", "pad", "sound effects", "repeated theme", "simple", "catchy", "energetic"] | 9 | IYtQfDsFVfA | 1916 | |
Sound Of Music - 02 Magic Night (1987) | This is a pop music piece with 80s characteristics. There is a female vocalist in the lead singing melodically. The main theme is played by a keyboard and an electric guitar at the same time in the major scale. There is a bass guitar and a medium-to-high range pad in the background. The rhythmic background is provided by a loud but simple acoustic drum beat. There is a maximalist, vibrant and energetic atmosphere. This piece could be used in the soundtrack of a romance movie. It could also fit very nicely as the soundtrack of an anime. | 2009-12-25T08:13:42Z | mixtis carminibus | Sound Of Music was a Swedish pop group who recorded two albums 1986-1987. Peter Grönvall, who wrote the music, is the son of Benny Andersson from Abba. The other two members were Nanne Grönvall and Angelique Widengren. | ["Music of Asia", "Music", "Exciting music"] | ["pop music", "80s pop", "female vocal", "melodic singing", "keyboard", "bass guitar", "electric guitar", "pad", "acoustic drums", "grandiose", "vibrant", "energetic", "high tempo"] | 9 | TN53jpjqAGI | 2833 | |
Brenton - Melbourne Shuffle showcase | This is a rave music piece. There is a loud electronic drum beat in the rhythmic background. A strong synth bass and a sharp sounding pad are the main elements of the melody. It is an energetic piece to the point of being hyperactive. This piece could be played at nightclubs and rave venues. | 2010-03-14T11:07:27Z | We Dance Hard | http://wedancehard.com for more. Showcasing Brenton from Newcastle Rockers. | ["Music", "Shuffle"] | ["rave", "melbourne shuffle", "electronic dance music", "electronic drums", "synth bass", "pad", "dance", "loud", "energetic", "hyperactive"] | 9 | XnMokzAE5kk | 3225 |
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;