musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "intense" and musiccaps_names contains "Bass guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- fast tempo · 2 ✖
- instrumental 2
- intense · 2 ✖
- aggressive 1
- amplified 1
- boisterous 1
- death metal 1
- distorted sounds 1
- electric guitar 1
- electronic music 1
- hard rock 1
- harsh 1
- heavy metal 1
- heavy metalloud feed back 1
- inferior audio quality 1
- loud electric guitar feedback 1
- loud feedback 1
- metal 1
- noisy 1
- passionate 1
- raw 1
- rock 1
- sharp 1
- sonic power 1
- stringed instrument 1
- subdued song in background 1
- unpleasant 1
- vigorous 1
musiccaps_names (array) 13 ✖
- Bass guitar · 2 ✖
- Music 2
- Cacophony 1
- Clatter 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Guitar 1
- Heavy metal 1
- Musical instrument 1
- Outside, urban or manmade 1
- Plucked string instrument 1
- Reverberation 1
youtube_published (date) 2 ✖
- 2009-01-21 1
- 2014-05-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Voice of the Soul (Death cover) | This music is instrumental. The tempo is fast with an electric guitar riff playing a cover of a popular melody. The music is intense, loud, passionate, violent, aggressive and thunderous. This music is heavy metal/ death metal. | 2014-05-19T11:44:39Z | Juris Alunaanc | Hi! Debut EP of my band ''HEDONYST'' is out now! Check it here: Itunes: https://apple.co/2JG2ymS Spotify: https://spoti.fi/2YgXmZV Deezer: https://bit.ly/2unWmpq Google Play: https://bit.ly/2FksQpG Follow us on social media: Facebook: https://bit.ly/2HM8UyI Soundcloud: https://bit.ly/2WjvaEd | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Cacophony", "Plucked string instrument", "Outside, urban or manmade"] | ["instrumental", "fast tempo", "electric guitar", "rock", "hard rock", "metal", "heavy metalloud feed back", "amplified", "sonic power", "intense", "passionate", "loud feedback", "heavy metal", "death metal", "aggressive", "passionate", "stringed instrument"] | 7 | P5uIpVLEpm4 | 2507 | |
Humor: That's how regular guitar sounds with Guitar Hero chords | This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. | 2009-01-21T04:02:38Z | scooperfield | Is it hard to play Guitar hero with normal guitar? | ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] | ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] | 7 | c-8SLUH5pp4 | 3673 |
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;