musiccaps_details (view)
2 rows where musiccaps_aspects contains "female backing voice" and musiccaps_aspects contains "synth sounds" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- female backing voice · 2 ✖
- male voice 2
- moderate tempo 2
- synth sounds · 2 ✖
- electropop song 1
- fuzzy bass 1
- groovy bass 1
- narrative mood 1
- rap song 1
- repetitive synth melody 1
- shaker 1
- simple percussion 1
- trap beat 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tenant - Mystery Mountain (Official Video) | This song features a male voice and a female voice singing together. This is accompanied by percussion playing a simple beat. A shaker is played once on the count and twice on the end of each count. The bass plays a melody using a fuzzy tone. A synth holds chords in the background. The mood of the singers is narrative. This song can be played in a mystery movie. | 2011-07-12T14:10:36Z | thetenantislistening | Powered by Grooveshark Artists. Stream free at http://grooveshark.com/thetenant iTunes: http://bit.ly/hustlersoftheworld Website: http://thetenantislistening.com Facebook: http://facebook.com/thetenantband Twitter: http://twitter.com/thetenantband MGMT/Booking: mike@subversiveinc.com Directed by Behn Fannin - http://www.behnfannin.com Starring Caroline Macey From the album "Hustlers of the World" - ©2011-2012 The Tenant. | ["Music", "Independent music"] | ["electropop song", "fuzzy bass", "shaker", "simple percussion", "male voice", "female backing voice", "synth sounds", "moderate tempo", "narrative mood"] | 0 | 5C70IZwHA5g | 641 | |
BITTER ROCC - MMXIII Deluxe - Run these rats out (promo music video) | This song features a male voice rapping the lyrics. Female voices sing vocables in the background. This is accompanied by programmed percussion playing a trap beat. The bass plays a groovy bassline by sliding to notes rather than pausing in between notes. A synth plays a repetitive melody in the background. This song can be played in a gangster movie. | 2014-04-27T13:45:48Z | ROCAnimation | MMXIII Deluxe edition available on iTunes only 30.05.14. 'Run these rats out' only available on MMXIII Deluxe. Directed by ROC. assisted by Darrell Long, Evan Flynn. TheRocCollective.com BR MUSIC (C) 2014. | ["Music", "Hip hop music"] | ["rap song", "trap beat", "male voice", "female backing voice", "synth sounds", "repetitive synth melody", "moderate tempo", "groovy bass"] | 0 | 3KdyWJ6wTOw | 457 |
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;