musiccaps_details (view)
2 rows where "youtube_published" is on date 2007-06-11 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- additive rhythm 1
- complex 1
- cover 1
- distorted electric guitar 1
- guitar solo 1
- hand percussion 1
- hypnotic 1
- instrumental 1
- male singer 1
- odd meter 1
- poor quality 1
- progressive metal 1
- rapid 1
- regular rhythm 1
- shredding 1
- speed metal 1
- trance inducing 1
- violent 1
- violin 1
- violin doubling singer 1
musiccaps_names (array) 5 ✖
- Heavy metal 1
- Music 1
- Percussion 1
- Rock music 1
- Tabla 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ekkadi Manusha Janmam? (Annamacharya song) | Hand percussion accompanies a male singer and violin doubling a melody with a constant regular rhythm. Mood is hypnotic and trance inducing. Features additive rhythms and odd meters. | 2007-06-11T23:00:23Z | musiquebox | Prince Rama Varma renders an eloquent Annamacharya composition in the Raaga Revagupti at NGMA Mumbai. He is accompanied on the violin by Shri Madhavan and on the mridangam by Shri Ganesh. | ["Tabla", "Percussion"] | ["hand percussion", "male singer", "regular rhythm", "violin", "violin doubling singer", "hypnotic", "trance inducing", "additive rhythm", "odd meter"] | 8 | w_XFNKSRgKI | 5276 | |
Through The Fire And Flames - AGAIN! | This is the guitar cover of a speed metal/progressive metal piece. The distorted electric guitar is playing a solo. There is a rapid and complex procession of notes in the solo which is played by the shredding technique. There is a loud and violent atmosphere to the recording. The quality is quite poor since the recording is a bit dated. | 2007-06-11T07:06:05Z | longestsoloever | I try the DragonForce song again, this time with my clone! That handsome guy on the left is off by a split second, but thats one of the hazards of compositing! | ["Heavy metal", "Music", "Rock music"] | ["cover", "speed metal", "progressive metal", "instrumental", "distorted electric guitar", "guitar solo", "shredding", "complex", "rapid", "violent", "poor quality"] | 9 | DYp8940tHso | 1492 |
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;