musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "mid-range"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- medium tempo · 2 ✖
- mid-range · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic kick 1
- arpeggios 1
- e-bass 1
- e-guitar 1
- funky 1
- male backing vocals 1
- male singer 1
- male voice singing 1
- pop 1
- synthesizer sounds 1
- synthpop 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Africa 1
- Ska 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Splendid - You Don't Understand | This song contains acoustic drums with a fat kick drum and a funky bassline. The acoustic guitar is strumming chords in the background being panned to the left side of the speaker while a e-guitar panned to the right side of the speaker is playing the lead melody strumming chords with a wah-wah pedal. A male backing voice is singing the same melody in a loop. The male lead voice is singing over the backing vocals. This song may be playing on a road trip. | 2007-10-23T20:56:12Z | splendidmusic | The long awaited all in the family happy happy sunshine videoclip for the Splendid track "You Don't Understand", taken from the 2006 album "Rebirth". iTunes: http://itunes.apple.com/nl/album/rebirth/id320728481 http://www.splendidmusic.nl Bookings: http://www.agentsafterall.nl | ["Music", "Ska"] | ["pop", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "mid-range", "male backing vocals", "medium tempo", "funky"] | 6 | Aw2ctwyhe28 | 1185 | |
City Of Night (Miracle Of Sound Music Video) | A male voice is singing with a mid-melody. Different synthesizer sounds are playing arpeggios being used as bassline and other sounds as melody in the mid range and higher register. An acoustic sounding kick is playing on every beat. This song may be playing in a synth retro movie. | 2013-05-25T13:36:57Z | Jevanimation | So basically I was doing my final major project in college and long story short I had to drop my first film idea with 3 weeks until the deadline. So after finding out I couldn't afford the flight to Mexico I decided yo make an animation. After 3 weeks (I think) this is what I ended up with. I know the animation is a bit rough but it was a bit rushed towards the end because I'm lazy and didn't do much in the first two weeks. But anyway, huge thanks to Miracle Of Sound for letting me use this track, if you haven't heard his music look him up on youtube he makes awesome game and movie related original songs. Hope you guys enjoy :) Also kudos for actually reading all the description, what a kind soul! | ["Music of Africa", "Music", "Tender music"] | ["synthpop", "male singer", "mid-range", "synthesizer sounds", "arpeggios", "acoustic kick", "medium tempo"] | 6 | nc6h6rC3wdk | 4564 |
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;