musiccaps_details (view)
3 rows where musiccaps_aspects contains "madly in love" and musiccaps_aspects contains "modern pop hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- emotional 3
- madly in love · 3 ✖
- modern pop hits · 3 ✖
- love song 2
- male singer 2
- modern love 2
- romantic 2
- acoustic pop 1
- bad audio quality 1
- breakup song 1
- courtship song 1
- crowds cheering 1
- desperate for you 1
- girls screaming 1
- guitar accompaniment 1
- guitar rhythm 1
- hissing noises 1
- inspiring 1
- keyboard accompaniment 1
- live shows 1
- loneliness 1
- love songs 1
- mameluke in love 1
- medium tempo 1
- memdium tempo 1
- modern r&b hits 1
- motivational 1
- music covers 1
- never give up on you 1
- organ accompaniment 1
- original song 1
- packed stadium 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- pop hits 1
- pop star sings live 1
- r&b 1
- sentimental 1
- soloist 1
- soul singer 1
- steady drumming rhythm 1
- story telling 1
- strong bass line 1
- teen heartthrob 1
- teenage romance 1
- vocal harmony 1
- youtube music artist 1
- youtube music videos 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Keyboard (musical) 1
- Music 1
- Music of Asia 1
- Piano 1
- Pop music 1
- Singing 1
- Whoop 1
youtube_published (date) 3 ✖
- 2012-12-29 1
- 2013-08-20 1
- 2014-06-28 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Three Days Grace/ Breaking Benjamin/ Paramore - Mashup Cover by Kevin Staudt | A male singer sings this emotional melody. The song is medium tempo with a piano accompaniment and a strong bass drum kick . The song is emotional and romantic. The song is a home music video . | 2014-06-28T20:20:04Z | Kevin Staudt | Hey everyone, since I haven't uploaded much new stuff lately I wanted to put a few requests (Three Days Grace - Take Me Under / Breaking Benjamin - Dance With The Devil / Paramore - Decode) together in one cover. http//www.facebook.com/kevinstaudtmusic | ["Electric piano", "Keyboard (musical)", "Piano"] | ["male singer", "piano accompaniment", "soloist", "modern love", "loneliness", "breakup song", "mameluke in love", "music covers", "youtube music videos", "youtube music artist", "modern pop hits", "courtship song", "desperate for you", "madly in love", "original song", "acoustic pop", "emotional", "love song", "sentimental", "strong bass line", "keyboard accompaniment"] | 1 | 1OIfQHKnAcw | 265 | |
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 | |
Harry Styles | Best Vocals [Part 2] | A male singer sings various songs in live audience situations. The songs have a different tempo and are mostly accompanied by a band. The songs are sung at live venues with people screaming and cheering. The songs are modern pop hits , recorded in poor audio quality with hissing noises. | 2013-08-20T05:03:21Z | fr0zenintimeee | follow me i follow back :) ♡ https://twitter.com/fr0zentweets ♡ Tumblr: http://http://harryfml.tumblr.com/ (1D blog) i don't own any of these videos. I don't own any rights to this song. No copyright intended. | ["Singing", "Music", "Pop music", "Whoop"] | ["poor audio quality", "hissing noises", "pop star sings live", "live shows", "emotional", "passionate", "crowds cheering", "guitar accompaniment", "pop hits", "romantic", "girls screaming", "packed stadium", "pop hits", "teen heartthrob", "modern pop hits", "love songs", "romantic", "madly in love", "modern love", "teenage romance"] | 1 | pNlrM-GhFZU | 4705 |
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;