musiccaps_details (view)
2 rows where musiccaps_aspects contains "adventure" and musiccaps_aspects contains "positive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- adventure · 2 ✖
- building anticipation 2
- instrumental music 2
- positive · 2 ✖
- a great day 1
- animate vocals 1
- arcade game music 1
- average sound quality 1
- cheer 1
- documentary soundtrack 1
- energetic 1
- excited vocals 1
- excitement 1
- fun 1
- good vibes 1
- groovy bas slime 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- keyboard harmony 1
- medium fast tempo 1
- medium tempo 1
- modern pop instrumental 1
- movie soundtrack 1
- mysterious 1
- new places 1
- passionate 1
- pop music 1
- sense of adventure 1
- senseof adventure 1
- song introduction 1
- steady drumming rhythm 1
- string synth harmony 1
- strong drum rhythm 1
- suspense 1
- the great adventure 1
- travel show 1
- video game soundtrack 1
- whip sounds 1
musiccaps_names (array) 3 ✖
- Music 2
- Burst, pop 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Walk Across America - Behind the Scenes | The song is an instrumental. The tempo is medium with a guitar accompaniment and leads into a strong drumming rhythm and bass line. The song is exciting and energetic. The song is a movie soundtrack for a travel show or a documentary. | 2010-07-21T22:40:16Z | walkUSA | Here is how we created Guy Walks Across America. You can see our entire route on Google Maps here: http://bit.ly/brNULW Music - "Down River" by The Temper Trap http://www.thetempertrap.com | ["Music", "Ukulele"] | ["instrumental music", "song introduction", "travel show", "new places", "senseof adventure", "a great day", "positive", "good vibes", "pop music", "adventure", "sense of adventure", "building anticipation", "groovy rhythm", "energetic", "passionate", "movie soundtrack", "guitar accompaniment", "strong drum rhythm", "modern pop instrumental", "documentary soundtrack", "medium tempo"] | 1 | cp8t27oT_ww | 3746 | |
Mario Party 9 | Bowser Pop | The song is an instrumental. The song is medium fast tempo with keyboard accompaniment, steady drumming rhythm, whopping sounds, strong bass line, and string synth harmony. The song is exciting and suspenseful. The song is a video arcade game soundtrack with average quality audio. | 2013-05-26T00:11:26Z | Red9378 | [122 - 720p HD] Mario Party 9 | Bowser Pop Talk about an inflated ego! The COM was set to Master difficulty. This video was recorded on May 16, 2013. | ["Music", "Burst, pop"] | ["arcade game music", "animate vocals", "average sound quality", "instrumental music", "video game soundtrack", "excitement", "adventure", "suspense", "building anticipation", "fun", "cheer", "positive", "the great adventure", "excited vocals", "mysterious", "whip sounds", "medium fast tempo", "groovy bas slime", "keyboard harmony", "string synth harmony", "groovy bass line", "steady drumming rhythm"] | 1 | tAdNaRRFFXg | 5013 |
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;