musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "building anticipation" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- building anticipation · 2 ✖
- passionate · 2 ✖
- a great day 1
- adventure 1
- break the tension 1
- buzz 1
- distorted amplified guitar 1
- documentary soundtrack 1
- drum roll 1
- electrostatic sounds 1
- energetic 1
- enthusiastic 1
- enthusiastic drumming 1
- exciting 1
- get tones 1
- good vibes 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar strumming 1
- heart beat melody 1
- instrumental music 1
- k-pop 1
- korean rock band 1
- male singer 1
- medium tempo 1
- modern pop instrumental 1
- movie soundtrack 1
- new places 1
- percussive bass line 1
- pop 1
- pop dance rhythm 1
- pop dance song 1
- pop music 1
- positive 1
- sense of adventure 1
- senseof adventure 1
- signal tempo 1
- song introduction 1
- spirited 1
- storm cloud noises 1
- strong drum rhythm 1
- teen spirit 1
- travel show 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Exciting music 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
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;