musiccaps_details (view)
4 rows where musiccaps_aspects contains "dance", musiccaps_aspects contains "repeated theme" and musiccaps_aspects contains "synth bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- dance · 4 ✖
- electronic drums 4
- repeated theme · 4 ✖
- synth bass · 4 ✖
- groovy 2
- keyboard 2
- simple 2
- catchy 1
- disco 1
- electro 1
- energetic 1
- erotic 1
- female vocal sample 1
- female vocals 1
- french electronic pop 1
- hip-hop 1
- house 1
- lead synth 1
- loud 1
- male vocal 1
- male vocals 1
- melodic pad 1
- pad 1
- percussion 1
- pop 1
- rapping 1
- sensual 1
- sound effects 1
musiccaps_names (array) 9 ✖
- Music 4
- Dance music 2
- Electronic dance music 2
- Trance music 2
- /t/dd00032 1
- Disco 1
- Exciting music 1
- House music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Travis Porter - BANANAS Official Music Video (In New York City) | This is a hip-hop piece. There is a male vocal rapping at the forefront while other male vocals can be heard singing ad-libs. A repeated theme is being played by a keyboard. A synth bass with low-to-mid characteristics can be heard playing in the background. The rhythmic background consists of a hard-hitting electronic drum beat. The atmosphere is groovy. This piece could be played at nightclubs. It would also suit well with a sports venue setting. | 2010-03-02T02:24:39Z | Travis Porter | Official Travis Porter Bananas Music Video shot in NEW YORK CITY! | ["Music", "Exciting music"] | ["hip-hop", "male vocals", "rapping", "repeated theme", "keyboard", "synth bass", "electronic drums", "simple", "groovy", "dance", "loud"] | 9 | 0bRUkLsttto | 189 | |
CHEWING GUM FRAISE | This is a French electronic pop music piece. There is a male vocalist singing in the lead. A melodic pad is playing a repeated theme while a fuzzy synth bass is playing a loud bass line. There is an electronic drum beat in the rhythmic background. The atmosphere is sensual and erotic. This piece could be playing in the background at a nightclub or a dance club in France. | 2007-06-07T02:51:32Z | LTparody | lui c le moin bon surment yai vedge mes ces 1 de plus et ces special :O | ["Disco", "House music", "Music", "Techno", "Trance music", "Electronic dance music", "Dance music"] | ["french electronic pop", "male vocal", "melodic pad", "repeated theme", "synth bass", "electronic drums", "female vocal sample", "sensual", "erotic", "dance"] | 9 | 7yK4-hsVX1o | 893 | |
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 | |
Lipps Inc. - Funkytown (lyrics) | This is a famous disco piece. There are female vocals singing the lyrics joyfully. The main tune is played in major scale by a keyboard while it is supported by a syncopated synth bass in the background. The rhythm is kept by a repetitive electronic drum beat accompanied by percussion. The atmosphere is groovy and danceable. It is perfect for an 80s themed party setlist. It could also be playing in the background of an 80s themed bar. | 2008-06-28T05:10:53Z | Pippygal44 | Lipps Inc. - funkytown with lyrics. | ["Music", "/t/dd00032"] | ["pop", "disco", "female vocals", "electronic drums", "percussion", "keyboard", "synth bass", "dance", "groovy", "repeated theme"] | 9 | liuCTk2nPG8 | 4418 |
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;