musiccaps_details (view)
3 rows where musiccaps_aspects contains "hip-hop" and musiccaps_aspects contains "synth" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- electronic drums 3
- hip-hop · 3 ✖
- synth · 3 ✖
- groovy 2
- male vocal 2
- rapping 2
- urban 2
- clap sound 1
- danceable 1
- electronica 1
- energetic 1
- funk 1
- german language 1
- keyboard 1
- loud 1
- male vocoder 1
- melodic 1
- remix 1
- repeated theme 1
- shouting sounds 1
- strings 1
- strong bass 1
- swiss rap 1
musiccaps_names (array) 4 ✖
- Music 3
- Funk 1
- Hip hop music 1
- Ping 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DeFrancosTraining.com - STRONG. (Movie trailer) | This is an electronica piece played over a workout camp video. There is a male vocoder sound in the lead. The main theme is being played by the medium pitched keyboard. A groovy electronic drum beat with strong kicks provide the rhythmic background. | 2008-05-15T01:44:30Z | joedefranco | Here's another trailer from the documentary entitled, STRONG, which was shot at our gym last year. The documentary will be released VERY shortly!!!! | ["Music", "Ping"] | ["electronica", "hip-hop", "male vocoder", "keyboard", "synth", "electronic drums", "clap sound", "shouting sounds", "energetic", "loud", "melodic"] | 9 | 9ZilD_4pi7E | 1025 | |
Phumaso & Smack - Hands Up! | This is a Swiss rap music piece. There is a male vocal rapping in the German language. The melody consists of a repeating theme played by a synth sound. A low-to-medium range string sample can be heard every now and then. The rhythmic background consists of an electronic drum beat which contains very faint clicking sounds added for texture. It is an urban sounding piece. This piece would fit perfectly in the soundtrack of a crime movie that takes place in the ghettos of a German-speaking city. | 2011-02-13T17:43:12Z | deenow | Rap-Duo aus Winterthur Album Gratis downladen : http://www.ps-music.ch Myspace : http://www.myspace.com/smackphumaso Facebook : http://www.facebook.com/pages/Phumaso-Smack/118549244846934 | ["Music", "Hip hop music"] | ["swiss rap", "hip-hop", "male vocal", "rapping", "german language", "synth", "repeated theme", "strings", "electronic drums", "groovy", "urban"] | 9 | NsR60ehkHGA | 2372 | |
Snoop dogg funk remix de fou | This is a funk remix of a hip-hop music piece. There is a male vocal rapping calmly almost as if he is just having a normal conversation with someone. There are various layers of different synths playing different melodies. The piece has a strong bass sound. The rhythm is being played by a groovy electronic drum beat. The atmosphere of the piece is danceable and the sound is urban. This piece could be playing at a retro-themed party at a nightclub. | 2011-12-27T06:21:53Z | goldenboy30900 | remix funk | ["Funk", "Music"] | ["funk", "remix", "hip-hop", "male vocal", "rapping", "synth", "strong bass", "electronic drums", "groovy", "danceable", "urban"] | 9 | oypg41SWGDc | 4673 |
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;