musiccaps_details (view)
2 rows where musiccaps_names contains "Independent music", musiccaps_names contains "Pop music" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_names (array) 12 ✖
- Independent music · 2 ✖
- Music 2
- Pop music · 2 ✖
- Rock music · 2 ✖
- Disco 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock and roll 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ITV Chart Show Indie Chart May 1989 | The excerpt is actually a song collage and it features third songs. In the first one a male voice is singing and the song has a dance feel to it. In the second song a male voice is singing and being backed by male voices at the same time. The instruments used are more close to the rock genre. The third song lasts for a few milliseconds and so it's hard to notice anything about it. | 2007-08-05T19:39:57Z | David Bryant | Features: Wire - Eardrum Buzz My apologies for not including Pixies "Monkey Gone To Heaven" again. Please see April's edition for the featured version. | ["Disco", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Pop music", "Rock music", "Rock and roll"] | ["collage", "male voices", "indie music"] | 2 | oT6ud0OdR_E | 4633 | |
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;