musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "movie music" and musiccaps_aspects contains "no singer" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- instrumental 2
- movie music · 2 ✖
- no singer · 2 ✖
- acoustic guitar 1
- adventurous 1
- anticipation 1
- bass guitar 1
- eccentric 1
- electric guitar 1
- granular synth 1
- mandolin 1
- orchestra 1
- repeated theme 1
- suspense 1
- ukulele 1
- video game music 1
- western music 1
musiccaps_names (array) 4 ✖
- Music 2
- Flamenco 1
- Salsa music 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
This War of Mine - Teaser Trailer | This is an instrumental piece. An electric guitar is playing the melody while another is playing secondary riffs. There is a granular synth holding notes at a high pitch. The overarching atmosphere of this piece is suspenseful. It feels like something big is about to happen that will break the intentionally superficial calmness. This piece would suit perfectly during suspense scenes in a movie soundtrack. | 2014-03-12T18:00:04Z | GameSpot | Take a look at this teaser trailer for 11 bit studios' new IP, This War of Mine. Follow This War of Mine at GameSpot.com! http://www.gamespot.com/this-war-of-mine/ Official Site - http://www.11bitstudios.com/games/16/this-war-of-mine Visit all of our channels: Features & Reviews - http://www.youtube.com/user/gamespot Gameplay & Guides - http://www.youtube.com/user/gamespotgameplay Trailers - http://www.youtube.com/user/gamespottrailers MLG, NASL & eSports - http://www.youtube.com/user/gamespotesports Mobile Gaming - http://www.youtube.com/user/gamespotmobile Like - http://www.facebook.com/GameSpot Follow - http://www.twitter.com/GameSpot Stream Live - http://twitch.tv/GameSpot http://www.gamespot.com | ["Music", "Vibraphone"] | ["instrumental", "no singer", "granular synth", "electric guitar", "suspense", "anticipation", "repeated theme", "movie music"] | 9 | Hxf1seOpijE | 1852 | |
cowboy music-instrumental | This is a Western music piece performed live by an orchestra. There is a mandolin playing the main melody. Many strummed instruments such as acoustic guitar and ukulele are being played in the melodic background. These sounds evoke an adventurous feeling This piece could be used in the soundtrack of a Western movie/TV series. It could also suit well in the soundtrack of a wild west themed video game like Red Dead Redemption. | 2011-07-30T10:27:10Z | shashirao20072001 | cowboy music-instrumental | ["Flamenco", "Music", "Salsa music"] | ["western music", "no singer", "instrumental", "orchestra", "mandolin", "ukulele", "acoustic guitar", "bass guitar", "adventurous", "eccentric", "movie music", "video game music"] | 9 | w9CxACZ5Oi0 | 5244 |
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;