musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "rock" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- emotional · 4 ✖
- low quality 4
- rock · 4 ✖
- shimmering hi hats · 4 ✖
- flat male vocal 3
- punchy kick 3
- addictive 2
- arpeggiated electric guitar melody 2
- groovy bass 2
- groovy bass guitar 2
- live performance 2
- punchy snare 2
- background male vocal 1
- crowd cheering 1
- crowd singing 1
- easygoing 1
- electric guitars melodies 1
- energetic 1
- harmonizing background vocals 1
- passionate 1
- passionate female vocals 1
- shimmering crash cymbal 1
- snappy rimshot 1
- snappy rimshots 1
- soft kick 1
- sustained electric guitar melody 1
- wide electric guitar melody 1
musiccaps_names (array) 10 ✖
- Music 4
- Musical instrument 2
- Singing 2
- Blues 1
- Choir 1
- Drum kit 1
- Guitar 1
- Punk rock 1
- Rock music 1
- Sad music 1
youtube_published (date) 4 ✖
- 2007-06-24 1
- 2007-12-08 1
- 2008-04-19 1
- 2013-10-18 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEF LEPPARD - "Goodbye" (Official Music Video) | The low quality recording features a rock song that consists of flat male vocal singing over sustained and arpeggiated electric guitar melodies, followed by snappy rimshots, soft kick, shimmering hi hats and groovy bass guitar. It sounds emotional and easygoing. | 2013-10-18T15:47:22Z | DEF LEPPARD | Get tickets to Def Leppard's 2020 Stadium Tour with Mötley Crüe and special guests Poison & Joan Jett here: https://defleppard.com Subscribe to our channel for new videos: http://bit.ly/LeppardYT Def Leppard’s Full Catalog Now Available to Stream & Download Worldwide: https://UMe.lnk.to/DefLeppardDigital ___________ LISTEN TO DEF LEPPARD: Apple/iTunes: https://DefLeppard.lnk.to/itunesapple Spotify: https://ume.lnk.to/DefLeppardDigital/spotify Amazon: https://ume.lnk.to/DefLeppardDigital/Amazon Deezer: https://ume.lnk.to/DefLeppardDigital/Deezer Pandora: https://ume.lnk.to/DefLeppardDigital/pandora FOLLOW DEF LEPPARD: Website: http://www.DefLeppard.com/ YouTube: https://www.youtube.com/defleppard Instagram: http://instagram.com/DefLeppard Facebook: https://www.facebook.com/DefLeppard Twitter: https://twitter.com/DefLeppard Publisher: http://www.PrimaryWave.com | ["Music", "Sad music"] | ["low quality", "rock", "flat male vocal", "groovy bass guitar", "sustained electric guitar melody", "arpeggiated electric guitar melody", "snappy rimshot", "soft kick", "shimmering hi hats", "easygoing", "emotional"] | 4 | -M-6VinyMiY | 37 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;