musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic percussion" and musiccaps_names contains "Drum machine" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- electronic percussion · 2 ✖
- club music 1
- dance 1
- dubstep 1
- electronic afrobeat 1
- electronic dance 1
- electronic drums 1
- energetic 1
- fuzzy 1
- high-pitched synth 1
- keyboard 1
- lo-res 1
- male vocal sample 1
- mid-tempo 1
- repeated theme 1
- rising pattern 1
- sound effects 1
- synth bass 1
- trippy 1
musiccaps_names (array) 7 ✖
- Drum machine · 2 ✖
- Music 2
- Dubstep 1
- Electronica 1
- Music of Africa 1
- Synthesizer 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Make your own dubstep beats fast and easy - Try the software today | This is a simple dubstep piece. Electronic drums and percussion are played at the rhythmic background at 120 BPM. There is a high-pitched synth and a fuzzy synth bass playing a simple melody. The all-around quality of the sounds are a bit old-fashioned, reminiscing of the early 2000s. The piece has a danceable, trippy feel to it. It could be used in a retro-themed venue. | 2013-12-30T09:53:19Z | Nanette Arenivas | http://tinyurl.com/lruc8hy Make your own dubstep beats fast and easy - Try the software today Today audio fidelity and clarity is more important than ever before, since just about everybody has speakers or a set of headphones with which the difference is clearly noticeable. Artists can't get away with settling for whatever is "good enough" anymore, because the only thing good enough now is the absolute best. | ["Music", "Techno", "Dubstep", "Drum machine", "Synthesizer", "Electronica"] | ["dubstep", "electronic drums", "electronic percussion", "synth bass", "sound effects", "high-pitched synth", "lo-res", "mid-tempo", "trippy", "fuzzy", "dance"] | 9 | SkIDF7iNJQE | 2785 |
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;