musiccaps_details (view)
3 rows where musiccaps_aspects contains "synth", musiccaps_names contains "Hip hop music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUTURE SOUND FRIDAY'S #9 Behind-The-Scenes Edition | This is an excerpt from a music show. There is a female voice narrating an event that took place. In the background, there is hip-hop music playing. A male vocal can be heard rapping. The melody is being played by a synth sound. There is a strong bass in the piece. The rhythm is played by the electronic drums. This piece could be used as an advertisement jingle for a sportswear or automobile company. | 2011-12-02T06:24:19Z | futuresoundjapan | Visit: http://FutureSound.TV Welcome DAISHA! Our newest host to Future Sound Friday's. Go behind the scenes at KOJOE & ISH-ONE's new music video "4 ALL WE KNOW". Custom cars, fly girls, and pure Hip Hop. New videos this week: + TOKYO DREAM GIRL High School Mansion + NOIR - Ciroc Premium Vodka Party at Velours | ["Music", "Speech", "Hip hop music"] | ["music show", "female voice", "narrating", "hip-hop music", "male vocal", "rapping", "synth", "strong bass", "electronic drums", "urban sound"] | 9 | NQXQsVawPhU | 2336 | |
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 | |
Smack Igor Ty nevíš co sem dělal dřív | This is a Czech rap music piece. There is a male voice rapping in the Czech language. There is a medium-pitch synth playing the melody. The medium tempo electronic drum beat carries the rhythmic background. The atmosphere of the piece is loud and aggressive. This piece could be used in the soundtrack of a crime movie taking place in Central Europe. | 2012-11-19T13:02:12Z | Radek Betyár | ["Music", "Rapping", "Hip hop music"] | ["rap", "czech", "male vocals", "synth", "electronic drums", "aggressive", "loud"] | 9 | tQ1Nl4Dy2aI | 5035 |
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;