musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "retro pop hits" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 60 ✖
- medium tempo · 4 ✖
- retro pop hits · 4 ✖
- emotional 3
- male singer 3
- romantic 3
- backup singers 2
- energetic 2
- keyboard accompaniment 2
- love song 2
- passionate 2
- percussive bass line 2
- steady drumming rhythm 2
- average audio quality 1
- bad audio quality 1
- bass guitar solo 1
- big band 1
- cheerful 1
- clapping percussions 1
- classic rock band 1
- cymbals crashing 1
- dance rhythm 1
- ethnic percussions 1
- exciting 1
- female singer 1
- female singers 1
- fun 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- hissing vocals 1
- home studio 1
- inspiring 1
- keybiard accompaniment 1
- keyboard harmony 1
- life lessons 1
- missing you 1
- motivational 1
- noir style 1
- percussion hits 1
- percussions 1
- percussive bas slime 1
- pop hits 1
- pop music 1
- positive 1
- rhythm guitar 1
- rock band 1
- song cover 1
- song ending 1
- spirited 1
- story telling 1
- strong bass guitar 1
- tambourine percussions 1
- together forever 1
- various percussion hits 1
- video soundtrack 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Independent music 2
- Singing 2
- Blues 1
- Happy music 1
- Pop music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 | ||
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
豬之歌 - 香香 | A female singer sings this lovely melody with a choral harmony support. The song is medium tempo with a Steady drumming rhythm, various percussion, percussive bass line, keyboard accompaniment and guitar rhythm. The song slows down at the end. The song is emotional and exciting. | 2011-11-26T13:35:07Z | TigerleoAB | 豬之歌 詞/曲:毛慧 豬 你的鼻子有兩個孔 感冒時的你 還掛著鼻涕牛牛 豬 你有著黑漆漆的眼 望呀望呀望 也看不到邊 豬 你的耳朵是那麼大 呼扇呼扇 也聽不到我在罵你傻 豬 你的尾巴是卷又捲 原來跑跑跳跳 還離不開它 哦~~~ 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙從不打架 豬 你的肚子是那麼鼓 一看就知道 受不了生活的苦 豬 你的皮膚是那麼白 上輩子一定投在 那富貴人家 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙 從不打架 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 你很像他 咳咳嗯 | ["Music", "Happy music"] | ["female singer", "backup singers", "pop music", "percussive bass line", "song ending", "medium tempo", "keyboard accompaniment", "fun", "cheerful", "positive", "emotional", "romantic", "vocal harmony", "steady drumming rhythm", "percussive bas slime", "keyboard harmony", "ethnic percussions", "exciting", "energetic", "vocal harmony", "pop hits", "retro pop hits", "video soundtrack", "various percussion hits"] | 1 | Ur8O3h8S0K4 | 2947 |
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;