musiccaps_details (view)
3 rows where musiccaps_aspects contains "love song", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- love song · 3 ✖
- medium tempo · 3 ✖
- story telling · 3 ✖
- bad audio quality 2
- emotional 2
- male singer 2
- retro pop hits 2
- romantic 2
- vocal harmony 2
- backup singers 1
- bass guitar solo 1
- big band 1
- brass band 1
- cheerful 1
- dance floor 1
- dance music 1
- enegetic 1
- exciting 1
- female backup singers 1
- funk pop hits 1
- groovy 1
- groovy bass line 1
- guitar lead 1
- guitar rhythm 1
- inspiring 1
- madly in love 1
- male singers 1
- medium drumming rhythm 1
- memdium tempo 1
- missing you 1
- modern pop hits 1
- modern r&b hits 1
- motivational 1
- never give up on you 1
- noir style 1
- organ accompaniment 1
- percussion hits 1
- percussions 1
- percussive bass line 1
- percussive hits 1
- pop song 1
- r&b 1
- rhythm guitar 1
- soul singer 1
- steady drumming rhythm 1
- strong bass guitar 1
- tambourine percussions 1
- together forever 1
- trumpets playing percussively 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
Despicable Me - Boogie Fever - The Sylvers | A male singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, ethnic drumming rhythm, trumpets playing percussively and a keyboard harmony. The song is groovy and cheerful. The song is retro final pop song; | 2010-07-15T01:19:34Z | Duke Tran | I do not own the music or take any credit for this video. I am not claiming that it is mine nor taking any form of incentive. | ["Funk", "Music"] | ["male singers", "backup singers", "vocal harmony", "funk pop hits", "dance floor", "percussive hits", "medium tempo", "groovy bass line", "medium drumming rhythm", "trumpets playing percussively", "story telling", "love song", "brass band", "pop song", "female backup singers", "exciting", "cheerful", "enegetic", "retro pop hits", "dance music"] | 1 | SSO7F_Ex0s4 | 2767 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;