musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- emotional · 3 ✖
- energetic · 3 ✖
- rock · 3 ✖
- groovy bass guitar 2
- low quality 2
- passionate male vocal 2
- punchy kick 2
- punchy snare 2
- addictive 1
- background male vocal 1
- crowd noises 1
- electric guitar solo melody 1
- electric guitars melodies 1
- energetic cymbals 1
- flat male vocal 1
- groovy bass 1
- groovy toms 1
- live performance 1
- loud 1
- muffled kick hits 1
- muffled snare hits 1
- noisy 1
- passionate 1
- shimmering cymbals 1
- shimmering hi hats 1
- wide electric guitars melodies 1
musiccaps_names (array) 9 ✖
- Music 3
- Disco 1
- Drum kit 1
- Guitar 1
- Musical instrument 1
- Punk rock 1
- Rock music 1
- Roll 1
- Singing 1
youtube_published (date) 3 ✖
- 2007-06-24 1
- 2011-11-06 1
- 2014-08-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Particles Like Planets - Out Of Reach (OFFICIAL Music Video) | The Rock song features a passionate male vocalist singing over wide electric guitar melodies, groovy bass guitar, shimmering cymbals, groovy toms, punchy snare and kick hits. It sounds energetic, passionate, emotional and loud. | 2011-11-06T00:52:20Z | Particles Like Planets | Particles Like Planets- http://www.facebook.com/particleslikeplanets If you want to help support us it is available on iTunes Music Video for "Out Of Reach" Artist: Particles Like Planets Album: The Owl In The Archer Director: Jaime Martinez Jaime Martinez- http://www.ilovegrafixphotography.com Credits: Band: Cody Vanhoozen, Tyler Shippy, Eric Boudreau, Mikey Tucker Film Credits: Jaime Martinez, Todd Mckernan, Jasmine Quail Location Credits: Daryl Shippy & Hemet Ryan Airport Label: Unsigned | ["Disco", "Music"] | ["rock", "punchy kick", "punchy snare", "groovy toms", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "passionate male vocal", "energetic", "passionate", "emotional", "loud"] | 4 | 1QFli7KSXAQ | 270 | |
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
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;