musiccaps_details (view)
2 rows where musiccaps_aspects contains "adventure" and musiccaps_aspects contains "movie soundtrack"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- adventure · 2 ✖
- instrumental music 2
- medium tempo 2
- movie soundtrack · 2 ✖
- a great day 1
- against all odds 1
- animated movie 1
- building anticipation 1
- cyberwars 1
- dangerous game 1
- documentary soundtrack 1
- energetic 1
- fight the machines 1
- good vibes 1
- groovy rhythm 1
- guitar accompaniment 1
- keyboard accompaniment 1
- modern pop instrumental 1
- new places 1
- ominous 1
- passionate 1
- percussion hits 1
- philharmonic orchestra 1
- poor audio quality 1
- pop music 1
- positive 1
- sci-fi movie 1
- sense of adventure 1
- senseof adventure 1
- song introduction 1
- sonic effects 1
- strong drum rhythm 1
- super hits 1
- ticking clock percussions 1
- travel show 1
- various percussion effects 1
- various sound effects 1
musiccaps_names (array) 3 ✖
- Music 2
- Scary music 1
- Ukulele 1
youtube_published (date) 2 ✖
- 2010-07-21 1
- 2011-07-01 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 | |
Transformers 3 Soundtrack #3 Lost Signal- Steve Jablonsky | The song is instrumental. The tempo is medium with a steady percussive rhythm, keyboard accompaniment, string section harmony and various sound effects. The song is ominous and full of suspense. The song is a movie soundtrack and has poor audio quality. | 2011-07-01T17:15:00Z | TheP1291pictures | soundtrack | ["Music", "Scary music"] | ["movie soundtrack", "sci-fi movie", "instrumental music", "poor audio quality", "various percussion effects", "dangerous game", "adventure", "against all odds", "fight the machines", "cyberwars", "animated movie", "super hits", "sonic effects", "philharmonic orchestra", "ticking clock percussions", "various sound effects", "percussion hits", "ominous", "instrumental music", "medium tempo", "keyboard accompaniment"] | 1 | zSq2D_GF00o | 5479 |
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;