musiccaps_details (view)
4 rows where musiccaps_aspects contains "cover", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- cover · 4 ✖
- instrumental · 4 ✖
- complex 2
- guitar solo 2
- shredding 2
- aggressive 1
- amateur recording 1
- bells 1
- calming 1
- cello 1
- distorted electric guitar 1
- electric guitar 1
- heavy metal 1
- lullaby 1
- lyre 1
- medieval sound 1
- melodic 1
- no singer 1
- orchestral 1
- poor quality 1
- pop 1
- popular song 1
- progressive metal 1
- quiet 1
- rapid 1
- rock 1
- sleep-inducing 1
- soothing 1
- speed metal 1
- strings 1
- violent 1
- winds 1
- xylophone 1
musiccaps_names (array) 11 ✖
- Music · 4 ✖
- Background music 1
- Guitar 1
- Heavy metal 1
- Lullaby 1
- Musical instrument 1
- Orchestra 1
- Plucked string instrument 1
- Rock music 1
- Tapping (guitar technique) 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Let it Be-Royal Philharmonic Orchestra | Quiet instrumental cover of a popular pop/rock song by an orchestra that features winds and strings trading off parts of the melody. | 2010-03-05T20:28:03Z | cisne27 | "Let it Be" Royal Philharmonic Orchestra -Musica Relajante- | ["Music", "Orchestra", "Tender music"] | ["instrumental", "quiet", "cover", "orchestral", "winds", "strings", "popular song", "pop", "rock"] | 8 | MPxwPOOIskc | 2264 | |
Britney Spears - Toxic - Lullaby Version | This is a lullaby version of a pop music piece. The main tune is played by a lyre which creates a medieval aura in the song. There is also a xylophone playing in the background with a supporting tune. A cello can be heard playing staccato notes for the bassline. An occasional bell percussion that sounds similar to a sleigh bell can be heard in the background. This could both be played in wholesome social media content and also due to its soothing nature in playlists meant to be played at bedtime for babies. | 2012-01-31T04:51:39Z | BritneySpearsFans | No copyright Infringement Intended. http://www.amazon.de/Lullaby-Versions-of-Britney-Spears/dp/B006ZBEHBG/ref=sr_1_1?ie=UTF8&qid=1327271873&sr=8-1 | ["Background music", "Music", "Lullaby"] | ["lullaby", "melodic", "instrumental", "cover", "medieval sound", "lyre", "cello", "xylophone", "bells", "calming", "soothing", "sleep-inducing"] | 9 | VlgOLOoctm0 | 3029 | |
13 year old kid plays Eruption by Van Halen | This is an amateur cover of a guitar solo in a heavy metal piece. The solo is being played on an electric guitar. There is a rapid procession of high-pitch notes in the solo. The feel is complex and aggressive. The quality of the recording is a bit poor. If the quality issue can be resolved, this piece could be sampled for use in beat-making. | 2008-05-01T15:30:23Z | dave8386 | Me playing Eruption on my dad's Squire Strat. For everyone saying that I "deserve a better guitar": I got a Fender Stratocaster that Christmas so I'm sorry if you're disappointed that it was played on a Squire but I don't feel it sounded too bad on it! =) | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["cover", "amateur recording", "heavy metal", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "complex", "aggressive"] | 9 | Y6OOFbrzdP8 | 3254 |
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;