musiccaps_details (view)
2 rows where "youtube_published" is on date 2007-04-02 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- passionate 2
- abrupt ending 1
- addictive 1
- bad audio quality 1
- buzzy synth lead melody 1
- death metal 1
- distorted guitar playing rhythm 1
- emo teens 1
- energetic crash cymbal 1
- excitement 1
- fast metal drumming 1
- fast tempo 1
- groovy bass 1
- happiness 1
- head banging 1
- low quality 1
- male vocals 1
- mosh pit 1
- noisy 1
- pain 1
- percussive bass line 1
- poor audio quality 1
- punchy snare 1
- retro death metal 1
- song ending 1
- thin kick hits 1
- wide harmonizing vocals 1
- wide toms 1
- youthful 1
musiccaps_names (array) 9 ✖
- Angry music 1
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
x..FirstLady..x Not okay with change | The low quality recording features a wide harmonizing vocals singing over wide toms, groovy bass, punchy snare, energetic crash cymbal, thin kick hits and buzzy synth lead melody. It sounds passionate and addictive thanks to that synth lead. The recording is noisy. | 2007-04-02T12:17:54Z | Susan Harrison | FABB song :p | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "wide harmonizing vocals", "wide toms", "punchy snare", "groovy bass", "thin kick hits", "buzzy synth lead melody", "addictive", "passionate", "energetic crash cymbal", "noisy"] | 4 | ow12iGt8z5Q | 4667 | |
COBHC = Omituisten Otusten Kerho | A male singer sings this death metal melody with screaming vocals. The tempo is fast, with fast metal drumming, percussive bass line, rhythmic distorted guitar play and various percussion hits. The song is exciting and high on adrenaline. The audio quality is poor. | 2007-04-02T23:01:04Z | Zooperstar | Fanvid about the weird guys from the band Children of Bodom... Yeah, I was bored! Music: Rölli - Omituisten Otusten Kerho, CoB - Hate Crew Deathroll Videoclips taken from the official Bodom EPs and DVDs | ["Music", "Angry music"] | ["death metal", "male vocals", "fast tempo", "mosh pit", "head banging", "poor audio quality", "song ending", "abrupt ending", "passionate", "youthful", "pain", "excitement", "happiness", "retro death metal", "bad audio quality", "emo teens", "fast metal drumming", "percussive bass line", "distorted guitar playing rhythm"] | 1 | OM04OFjNPGw | 2430 |
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;