musiccaps_details (view)
2 rows where musiccaps_aspects contains "alternative rock", musiccaps_names contains "Rock music" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- alternative rock · 2 ✖
- bass rumbling 1
- classic rock 1
- distorted audio 1
- engaging 1
- fast tempo 1
- female vocalist 1
- fuzzy audio 1
- groovy bass lines 1
- indie male vocalist 1
- indie rock 1
- live recording 1
- low quality audio 1
- powerful 1
- progressive rock 1
- reverb 1
- rock 1
- slick drumming 1
- soft rock 1
- symphonic rock 1
- synthesiser articulation 1
- upbeat 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 2
- Rock music · 2 ✖
- Singing · 2 ✖
- Heavy metal 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Rock and roll 1
- Roll 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Peter, Bjorn & John - "Young Folks" @ Laneway Festival 2007 | This is a recording of a live indie rock performance. The recording is distorted and of a low quality. There are two male singers singing in an indie style with a lot of reverb applied to their vocals. The bass is rumbling and low and constant. | 2007-03-04T14:57:51Z | onelinergirl | With special guest - Traceyanne Campbell of Camera Obscura - 2nd annual Laneway Festival, Circular Quay, Sydney, Sunday March 4, 2007 | ["Singing", "Music", "Rock music", "Roll", "Rock and roll"] | ["live recording", "indie rock", "alternative rock", "upbeat", "low quality audio", "fuzzy audio", "distorted audio", "indie male vocalist", "reverb", "bass rumbling"] | 3 | 9JlifkCmUOk | 993 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;