musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "home video", musiccaps_aspects contains "sonic power" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cacophony - concerto | This music is a vigorous electric guitar instrumental. The tempo is fast with an electric guitar rapid melody lead and an electric guitar Accompaniment. The melody is contrasted and syncopated. The music is dark, intense, extreme, dire and compelling Heavy Metal. | 2006-04-19T19:26:13Z | chrisote | cool | ["Music", "Cacophony"] | ["instrumental", "fast tempo", "electric guitar", "amplified guitars", "sonic power", "loud feedback", "syncopated harmony", "electric guitar lead", "electric guitar rhythm", "intense", "sinister", "dire", "grim", "compelling", "heavy metal", "hard rock", "dexterity", "home video", "home recording"] | 7 | BXo1Tr_oJds | 1254 | |
Keeley Caverns with Catalinbread Valcoder | This clip is an instrumental. The tempo is slow and deliberate with an electric guitar playing an energetic riff. It is minimal instrumentation with no other instrument used. The electric guitar is loud, boomy, jarring, resonant,recurring, with an insistent riff. | 2015-10-22T02:00:00Z | Iga Massardi | Keeley Caverns delay+reverb with Catalinbread Valcoder tremolo. Available at https://www.bneffects.com Contact : rigrigrigmusic@gmail.com PLEASE SUBSCRIBE :) Camera by Davian Akbar Recorded by Adam Imaduddin All cables by : http://www.rumahtjapgadjah.com Guitar : Fender Stratocaster Amp : Supro Dual Tone Mic : Sennheiser e906 http://www.rigrigrig.com http://www.facebook.com/rigrigrig http://www.twitter.com/rigrigrigdemo | ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["instrumental", "electric guitar", "jarring", "reverberating", "boomy", "home video", "amateur recording", "vibrations", "sonic power", "amplified guitar", "resonant", "loud feed back", "distorted audio", "electrical distortion"] | 7 | Xus0LI3QV2A | 3234 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 |
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;