musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- emotional 2
- haunting · 2 ✖
- live audience 2
- live performance · 2 ✖
- passionate 2
- amateur recording 1
- ambient room noise 1
- ambient sounds 1
- bagpiper 1
- bellows-blown bagpipe 1
- chamber instrument 1
- death metal 1
- deteriorated audio 1
- distorted guitar rhythm 1
- droning 1
- fast tempo 1
- female singer 1
- humming melody 1
- instrumental 1
- loud 1
- medium tempo 1
- people talking 1
- percussive bass line 1
- poor audio quality 1
- rebellious 1
- retro death metal hits 1
- rhythmic foot tapping 1
- screaming vocals 1
- small pipe harmony 1
- static 1
- steady drumming rhythm 1
- teenage age angst 1
- woodwind 1
musiccaps_names (array) 7 ✖
- Bagpipes 1
- Grunge 1
- Music 1
- Rock music 1
- Singing 1
- Wind instrument, woodwind instrument 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
Fred Morrison | This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. | 2010-02-12T22:46:03Z | Doug Henkle | Recorded on February 6, 2010 using a Flip Video camcorder. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] | 7 | IbD0zpcimgM | 1921 |
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;