musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- groovy · 3 ✖
- groovy bass line · 3 ✖
- youthful · 3 ✖
- funky 2
- medium tempo 2
- spirited 2
- ad jingle 1
- ambient 1
- atmospheric 1
- brass band 1
- cash register click 1
- club music 1
- dance groove 1
- dance music 1
- dance pop 1
- digital drums 1
- dreamy 1
- electric guitar lead 1
- energetic 1
- enterprising 1
- exciting 1
- foreign language 1
- funk jazz music 1
- funk rock 1
- groovy rhythm 1
- guitar solo 1
- high spirited 1
- hip-hop pop 1
- instrumental 1
- instrumental music 1
- jazz music influences 1
- lively piano 1
- male vocalist 1
- medium fast 1
- melodic 1
- neo soul 1
- passionate 1
- pleasant 1
- pop 1
- pop rock 1
- rhythmic acoustic guitar 1
- romantic 1
- shakers percussions 1
- soft rock 1
- soothing 1
- soul 1
- soul music 1
- soundtrack 1
- steady drumming 1
- steady drumming rhythm 1
- synthesiser arrangements 1
- trumpets 1
musiccaps_names (array) 4 ✖
- Music 2
- Blues 1
- Camera 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | This music is a melodic instrumental. The tempo is medium with a captivating electric guitar lead, rhythmic acoustic guitar, funky bass line, keyboard accompaniment, steady drumming and trumpets. The music is soothing, atmospheric, euphonious, youthful, and soulful. This instrumental is a Soft Rock/Funk pop. | 2011-08-18T07:00:00Z | TedeschiTrucksVEVO | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | ["Blues"] | ["instrumental", "medium tempo", "electric guitar lead", "ambient", "steady drumming", "groovy bass line", "trumpets", "melodic", "pleasant", "funky", "groovy", "soft rock", "pop rock", "funk rock", "youthful", "atmospheric", "brass band", "soul", "neo soul", "soothing", "rhythmic acoustic guitar"] | 7 | -wVWjl9Kq6U | 104 | |
【華燈市】市政店精品吊扇展示中心 | 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 | |
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 |
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;