musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "harsh" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- electronic music · 2 ✖
- fast tempo 2
- harsh · 2 ✖
- instrumental 2
- abrupt change 1
- aggressive 1
- beeping melody 1
- boisterous 1
- dangerous 1
- death industrial 1
- distorted sounds 1
- dj 1
- dj mixer 1
- electronica 1
- empty shells falling 1
- gunshots 1
- hard style 1
- hardcore house 1
- hardcore techno 1
- inferior audio quality 1
- intense 1
- loud electric guitar feedback 1
- noisy 1
- power electronics 1
- raw 1
- scratching 1
- sharp 1
- subdued song in background 1
- techno music 1
- techno pop 1
- turn table 1
- unpleasant 1
- vigorous 1
- violence 1
- violent aggressive 1
musiccaps_names (array) 10 ✖
- Music 2
- Bass guitar 1
- Clatter 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Heavy metal 1
- Hip hop music 1
- Reverberation 1
- Ringtone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Cep Telefonu Melodileri/cell phone melody Ringtones | This music is an aggressive instrumental . The tempo is fast with a violent yet melodic tune that dips suddenly to the sound of gunshots and the metallic sound of empty shells hitting the ground. This music is a violent, harsh, loud, and violent Hard Electronica. | 2008-10-26T11:26:23Z | sanalyonetmen | Cep Telefonu Melodileri/cell phone melody riringtones | ["Ringtone", "Music", "Hip hop music"] | ["instrumental", "fast tempo", "electronic music", "beeping melody", "abrupt change", "violence", "harsh", "power electronics", "hard style", "death industrial", "techno music", "gunshots", "empty shells falling", "dj", "dj mixer", "turn table", "scratching", "violent aggressive", "techno pop", "electronica", "dangerous", "hardcore techno", "hardcore house", "aggressive"] | 7 | LnL3KFKGqHE | 2220 |
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;