musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "love song" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- emotional 2
- keyboard accompaniment · 2 ✖
- love song · 2 ✖
- male singer 2
- piano accompaniment · 2 ✖
- acoustic pop 1
- asian soap opera 1
- breakup song 1
- courtship song 1
- desperate for you 1
- hissing tones 1
- loneliness 1
- madly in love 1
- mameluke in love 1
- medium tempo 1
- modern love 1
- modern pop hits 1
- movie soundtrack 1
- music covers 1
- music video 1
- original song 1
- percussion hits 1
- poor audio quality 1
- romantic song 1
- sentimental 1
- shakers percussions 1
- soloist 1
- strong bass line 1
- subtle drumming 1
- tv show theme 1
- youtube music artist 1
- youtube music videos 1
musiccaps_names (array) 6 ✖
- Electric piano 1
- Keyboard (musical) 1
- Music 1
- Music of Asia 1
- Piano 1
- Song 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 | |
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 |
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;