musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "rock music" and musiccaps_names contains "Heavy metal" sorted by youtube_channel
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 36 ✖
- rock music · 3 ✖
- electric guitar 2
- acoustic drums 1
- adrenaline rush 1
- adventure 1
- adventure sports documentary 1
- amateur band 1
- bass guitar 1
- calm 1
- clean sound 1
- documentary soundtrack 1
- echo 1
- energetic 1
- female vocal 1
- gentle 1
- guitar playing 1
- home video soundtrack 1
- instrumental 1
- instrumental musical 1
- jam 1
- keyboard harmony 1
- medium tempo 1
- melodic singing 1
- mysterious 1
- no singer 1
- normal tempo 1
- passionate 1
- shadow guitar bass line 1
- single instrument 1
- sound effects 1
- spirited 1
- steady drumming rhythm 1
- string section harmony 1
- suspense 1
- thai 1
- unexpected 1
musiccaps_names (array) 14 ✖
- Heavy metal · 3 ✖
- Music 3
- Progressive rock 2
- Blues 1
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Guitar 1
- Independent music 1
- Musical instrument 1
- Pop music 1
- Rock music 1
- Tick-tock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
Danelectro Reel Echo Jam | This is an instrumental rock music jam. The only instrument is a clean-sounding electric guitar playing an arpeggio with an added echo effect. The atmosphere is calming. Although the recording quality is a bit low, this piece could be playing in the background of a rock bar after a decent mix is applied. | 2008-08-10T08:24:19Z | slugsvideos | I just tried out the 'Reel Echo' a bit. Settings are: https://dl.dropbox.com/u/7261736/WP_000222.jpg | ["Echo", "Effects unit", "Guitar", "Heavy metal", "Music", "Musical instrument", "Distortion"] | ["jam", "rock music", "electric guitar", "clean sound", "single instrument", "no singer", "instrumental", "echo", "gentle", "calm"] | 9 | J0RzvGnQxD0 | 1958 |
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;