musiccaps_details (view)
1 row where musiccaps_aspects contains "dreamy", musiccaps_aspects contains "funk jazz music", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
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 |
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;