musiccaps_details (view)
2 rows where musiccaps_aspects contains "documentary soundtrack" and musiccaps_aspects contains "groovy rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- documentary soundtrack · 2 ✖
- groovy rhythm · 2 ✖
- medium tempo 2
- positive 2
- a great day 1
- adventure 1
- ambient room notes 1
- building anticipation 1
- cool 1
- drilling noises 1
- energetic 1
- good vibes 1
- groovy bas slime 1
- groovy bass line 1
- guitar accompaniment 1
- hip hop drumming rhythm 1
- instrumental music 1
- keyboard percussive tones 1
- male rap singer 1
- memdium tempo 1
- modern 1
- modern pop instrumental 1
- movie soundtrack 1
- new places 1
- passionate 1
- poor audio quality 1
- pop music 1
- sense of adventure 1
- senseof adventure 1
- soft music background track 1
- song introduction 1
- strong bass drops 1
- strong drum rhythm 1
- syncopated rhythm 1
- travel show 1
- vocal male monologue 1
- youtube tutorial 1
musiccaps_names (array) 3 ✖
youtube_published (date) 2 ✖
- 2010-07-21 1
- 2011-01-11 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
01.10.11 Phase I - Ripping up track, removing scenery and Backdrop on the Socal Desert HO Layout | A male artist talks and makes drilling noises. The song is a modern hip hop song with male rap vocals, hip hop drumming rhythm, heavy bass drops and keyboard harmony. The track has ambient room noises and the music track is very faint. The audio quality is very average. | 2011-01-11T02:20:52Z | MonsterRailroad | Well here is Part 1 of a three part series to complete this "re-tracking" | ["Music", "Dental drill, dentist's drill"] | ["vocal male monologue", "drilling noises", "youtube tutorial", "medium tempo", "documentary soundtrack", "modern", "cool", "positive", "groovy bass line", "ambient room notes", "male rap singer", "memdium tempo", "groovy bas slime", "hip hop drumming rhythm", "syncopated rhythm", "groovy rhythm", "soft music background track", "documentary soundtrack", "poor audio quality", "strong bass drops", "keyboard percussive tones"] | 1 | 4HfU5OQUqq0 | 553 | |
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 |
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;