musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Heavy metal"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- medium tempo · 2 ✖
- spirited 2
- adrenaline rush 1
- adventure 1
- adventure sports documentary 1
- amateur band 1
- amplified guitar 1
- boomy 1
- documentary soundtrack 1
- electric guitar lead 1
- enthusiastic 1
- guitar playing 1
- hard rock 1
- home recording 1
- home video soundtrack 1
- instrumental 1
- instrumental musical 1
- keyboard harmony 1
- loud electric guitar feedback 1
- metal 1
- muddled audio 1
- muddy 1
- muffled sound 1
- mysterious 1
- passionate 1
- poor audio quality 1
- rock 1
- rock music 1
- shadow guitar bass line 1
- sonic power 1
- …
musiccaps_names (array) 10 ✖
- Electric guitar · 2 ✖
- Heavy metal · 2 ✖
- Music 2
- Bass guitar 1
- Blues 1
- Distortion 1
- Effects unit 1
- Progressive rock 1
- Rock music 1
- Tapping (guitar technique) 1
youtube_published (date) 2 ✖
- 2010-12-17 1
- 2012-01-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DiMarzio Crunch Lab and LiquiFire Drive Sound Test (check up with an Ibanez S570B) | This music is an electric guitar instrumental Rock. The tempo is medium with an electric guitar lead. The music is loud and boomy with an intense riff. The audio quality is inferior so the sound is muffled and muddy. The music however is energetic, youthful, spirited and enthusiastic. | 2010-12-17T12:36:42Z | darkcashyz | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Distortion"] | ["instrumental", "amplified guitar", "youthful", "spirited", "sonic power", "enthusiastic", "muddy", "muffled sound", "medium tempo", "loud electric guitar feedback", "vigorous", "poor audio quality", "boomy", "electric guitar lead", "string instrument", "rock", "metal", "hard rock", "youthful", "enthusiastic", "muddled audio", "home recording"] | 7 | 6ayVxYbKBe0 | 769 | ||
Canoe Verdon, Kayak Castellane,...Canoe-Kayak Raft dans les Gorges du Verdon (Castellane) | The song is an instrumental. The tempo is medium with a strong drumming rhythm, keyboard harmony, string synth harmony, guitar lead and a bass guitar shadowing the melody line in harmony. The song has rock music influences with a sense of mystery and adventure. The song is a soundtrack for an adventure sports documentary. | 2012-01-12T08:54:25Z | Base Sport et Nature | Canoe Verdon, Kayak Gorges du Verdon, Castellane. Le Cano-Raft et le Kaya-Raft est un savoureux mélange entre le rafting et le canoë connu de tous. Le Verdon est une merveilleuse rivière aux eaux émeraude dessinant à travers la Provence, au Nord des plages de la Côte d'Azur, le plus grand canyon d'Europe. www.basesportnature.com | ["Blues", "Electric guitar", "Heavy metal", "Music", "Rock music", "Progressive rock"] | ["instrumental musical", "mysterious", "medium tempo", "string section harmony", "keyboard harmony", "guitar playing", "shadow guitar bass line", "steady drumming rhythm", "rock music", "amateur band", "adventure", "suspense", "adrenaline rush", "passionate", "spirited", "home video soundtrack", "adventure sports documentary", "documentary soundtrack", "unexpected"] | 1 | GYx6HNQbP1w | 1735 |
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;