musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- exciting 2
- groovy rhythm · 2 ✖
- instrumental music · 2 ✖
- medium tempo 2
- steady drumming rhythm · 2 ✖
- ad jingle 1
- advertisement jingle 1
- bass drum hits 1
- bouncy rhythm 1
- cash register click 1
- cheerful 1
- cool bass solo 1
- cool drum roll 1
- documentary video soundtrack 1
- dreamy 1
- drum sticks 1
- energetic 1
- enterprising 1
- funk jazz music 1
- funk pop music 1
- funky groove 1
- groovy 1
- groovy bass line 1
- guitar solo 1
- hand saw 1
- jazz music influences 1
- passionate 1
- poor audio quality 1
- positive 1
- romantic 1
- sawing noise 1
- shakers percussions 1
- soul music 1
- soundtrack 1
- spirited 1
- tom sounds 1
- video soundtrack’ toms sounds 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
【華燈市】市政店精品吊扇展示中心 | The song is an instrumental. The song is medium tempo with a guitar playing solo, steady drum rhythm, groovy bass line and steady bass line. The song is funky and groovy in nature. The song is an ad jingle. | 2015-05-18T10:07:19Z | 華燈市燈飾 吊扇 光源 設計 | 官網-https://www.waldens-lighting.com/ 免費到府勘查- https://www.waldens-lighting.com/cont... 華燈市提供您全省安裝服務,自有工班提供您專業的燈具安裝、吊扇安裝、照明燈具、安裝維修、五星級安裝,產品有保固,購買燈具有保障,一年保固終身保修 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ 華燈市為全國最大的精品吊扇展示中心,吊扇種類最多,針對不同的需求,提供您最佳的吊扇 選擇,從 #Fanaway、 #Fanscool、 #ModernFan、到 #Vento…,無論是國際精品品牌,或者是台灣之光,您都可以透過店內實品展示的體驗,實際感受及體驗這些精品吊扇的魅力 #燈的事就交給華燈市 #全省安裝 #精品吊扇 | ["Music", "Camera"] | ["instrumental music", "cash register click", "passionate", "spirited", "exciting", "medium tempo", "groovy rhythm", "romantic", "energetic", "youthful", "jazz music influences", "dreamy", "enterprising", "guitar solo", "groovy bass line", "steady drumming rhythm", "ad jingle", "soundtrack", "funk jazz music", "shakers percussions", "groovy", "soul music", "medium tempo"] | 1 | D2w3qHmJrdU | 1429 | |
JS-7 Japanese Hand Saw | The song is an instrumental. The tempo is medium with ambient sounds like a sawing tool sounds, guitar rhythm, bass guitar solo and a steady drumming with various percussion hits. The song is an advertisement jingle for a tool works company. The sound quality is average with ambient room sounds. | 2009-03-24T01:04:51Z | Bridge City Tool Works | A look at Bridge City Tool Works Adjustable Back Rip and Crosscut Japanese Saw. | ["Sawing", "Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Tools", "Rub", "Wood", "Bass drum", "Percussion"] | ["hand saw", "instrumental music", "documentary video soundtrack", "advertisement jingle", "poor audio quality", "bouncy rhythm", "tom sounds", "sawing noise", "medium tempo", "cool bass solo", "steady drumming rhythm", "groovy rhythm", "video soundtrack’ toms sounds", "drum sticks", "cool drum roll", "bass drum hits", "exciting", "positive", "cheerful", "funky groove", "funk pop music"] | 1 | ZCR7qJ2IgGI | 3347 |
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;