musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "shakers percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- medium tempo · 2 ✖
- shakers percussions · 2 ✖
- ad jingle 1
- asian soap opera 1
- cash register click 1
- dreamy 1
- emotional 1
- energetic 1
- enterprising 1
- exciting 1
- funk jazz music 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- guitar solo 1
- hissing tones 1
- instrumental music 1
- jazz music influences 1
- keyboard accompaniment 1
- love song 1
- male singer 1
- movie soundtrack 1
- music video 1
- passionate 1
- percussion hits 1
- piano accompaniment 1
- poor audio quality 1
- romantic 1
- romantic song 1
- soul music 1
- soundtrack 1
- spirited 1
- steady drumming rhythm 1
- subtle drumming 1
- tv show theme 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Camera 1
- Music of Asia 1
- Song 1
youtube_published (date) 2 ✖
- 2008-10-01 1
- 2015-05-18 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 | |
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 |
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;