musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic percussion" and musiccaps_aspects contains "energetic" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- electronic percussion · 3 ✖
- energetic · 3 ✖
- keyboard 3
- repeated theme 2
- club music 1
- danceable 1
- dizzying 1
- electric guitar 1
- electronic afrobeat 1
- electronic dance 1
- electronic dance music 1
- electronic drums 1
- female vocals 1
- high tempo 1
- house 1
- latin dance 1
- male vocal sample 1
- male vocals 1
- maraca 1
- melodic singing 1
- rising pattern 1
- trumpet 1
musiccaps_names (array) 7 ✖
- Music 3
- Music of Africa 2
- Afrobeat 1
- Drum machine 1
- Happy music 1
- Maraca 1
- Song 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jucafri maraca | This is a latin dance piece. There are two vocals taking turns singing the same line repeatedly. There is a keyboard and a trumpet playing the main melody. A fast-paced electronic percussion is playing in the rhythmic background. This is a dizzyingly high tempo song. It is very danceable. This piece can be played in latin nightclubs and latin dance courses. | 2008-03-05T03:25:33Z | 2redrose22 | Jucafri dale maraca | ["Afrobeat", "Music of Africa", "Music", "Song", "Maraca"] | ["maraca", "latin dance", "male vocals", "repeated theme", "trumpet", "keyboard", "electronic percussion", "high tempo", "energetic", "dizzying"] | 9 | _yXtw_z2xf4 | 3506 | |
If You Could Read My Mind (Lyrics) - Stars On 54 | This is an electronic dance/house music piece. There are female vocals singing melodically. The melody is being played by the keyboard with the electric guitar samples in the background. The rhythm consists of an electronic drum beat and electronic percussive elements. The atmosphere is danceable and energetic. This piece could be used in the soundtrack of a romantic comedy movie, especially during the scenes where a character is hesitating to open up to their crush. | 2013-01-05T01:57:37Z | SERENDIPITYPATTERN | For educational purposes only and no copyright infringement intended. | ["Music", "Happy music"] | ["electronic dance music", "house", "female vocals", "melodic singing", "keyboard", "electric guitar", "electronic drums", "electronic percussion", "danceable", "energetic"] | 9 | r1W1z_31Obw | 4844 | |
VEE MAMPEEZY"HAPPY!!!"(AFRICAN MUSIC#BOTSWANA) | This is an electronic afrobeat music piece. The electronic percussive elements are providing the rhythmic background. The keyboard is playing a repeated theme in a rising pattern. There is a brief shouting male vocal sample in the distance. The atmosphere is energetic. This piece could be playing at a nightclub or a dance club. | 2015-11-17T16:45:31Z | VEE MAMPEEZY | OFFICIAL VIDEO FOR THE 2ND SINGLE FROM #SUPERNATURAL VOL. 3 #HAPPY#SNVL3#AFRICA#WALAOLAJESO | ["Music of Africa", "Music", "Drum machine"] | ["electronic afrobeat", "electronic dance", "electronic percussion", "male vocal sample", "keyboard", "repeated theme", "rising pattern", "energetic", "club music"] | 9 | vfscNjNneZg | 5196 |
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;