musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital bass sound" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- digital bass sound · 2 ✖
- uptempo · 2 ✖
- dance 1
- digital drum 1
- electro/dubstep/pop&lock 1
- electro/pop 1
- electronic drums 1
- lower pitched sample 1
- male voice rapping 1
- singing 1
- sound effects 1
- uplifitng energy 1
musiccaps_names (array) 4 ✖
- Music 2
- Afrobeat 1
- Electronic music 1
- Exciting music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
8. Mario P. Amigo - Hos Alvaro | HQ | Animation/Music Of The Week | This song contains a digital drum with a shaker panned to the left side of the speaker. There are other rhythmic sound effects panned to the right side of the speakers. A digital bass playing a repeating melody is the center of this song. This song may be playing in a dance battle. | 2012-04-15T09:37:39Z | Jsinnay | • https://vimeo.com/jsinnay http://soundcloud.com/mario-p-amigo | ["Music", "Exciting music"] | ["electro/dubstep/pop&lock", "digital drum", "digital bass sound", "sound effects", "uptempo", "uplifitng energy"] | 6 | 4dilYyxYLmM | 591 | |
Mc Pat Flynn Love Inside | This song has a catchy synthesizer bassline that is repeating. The electronic drums are playing a four on the floor techno groove with some tambourines and some processed crash sounds. The elements are gently panned to the left and right side of the speakers. The male voice is rapping over the instrumental while a low pitched vocal sample melody is singing a melody and some pieces of that are also panned to the left and right side of the speakers along with some reverb and light delay. This song may be playing in a club or a beach party. | 2014-07-14T21:00:24Z | New Eire Media | This channel and I do not claim any right over any of the graphics, images, songs used in this video. All rights reserved to the respective copyright owners. | ["Afrobeat", "Electronic music", "Music"] | ["electro/pop", "lower pitched sample", "singing", "male voice rapping", "digital bass sound", "electronic drums", "uptempo", "dance"] | 6 | FENJIDecy5s | 1627 |
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;