musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "love song" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- bad audio quality · 2 ✖
- emotional 2
- love song · 2 ✖
- male singer 2
- medium tempo 2
- romantic 2
- story telling · 2 ✖
- bass guitar solo 1
- big band 1
- groovy 1
- guitar lead 1
- guitar rhythm 1
- inspiring 1
- madly in love 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
- r&b 1
- retro pop hits 1
- rhythm guitar 1
- soul singer 1
- steady drumming rhythm 1
- strong bass guitar 1
- tambourine percussions 1
- together forever 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Blues 1
- Music of Asia 1
- Singing 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 | ||
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;