musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "suspense" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- passionate · 2 ✖
- suspense · 2 ✖
- adrenaline rush 1
- adventure 1
- adventure sports documentary 1
- amateur band 1
- ambient room noises 1
- average audio quality 1
- country music 1
- cowboys 1
- documentary soundtrack 1
- echoes 1
- electric guitar 1
- emotional 1
- epic stories 1
- groovy 1
- groovy music 1
- guitar band 1
- guitar pick percussions 1
- guitar playing 1
- guitar solo 1
- gunslingers 1
- heroes and villains 1
- home video soundtrack 1
- instrumental music 1
- instrumental musical 1
- keyboard harmony 1
- legends 1
- live audience 1
- live performance 1
- medium tempo 1
- mysterious 1
- rhythm guitars 1
- rock music 1
- scratching tones 1
- shadow guitar bass line 1
- song covers 1
- spirited 1
- steady drumming rhythm 1
- story tellers 1
- string section harmony 1
- strings scratched with plectrum percussions 1
- tense 1
- the wild west 1
- unexpected 1
musiccaps_names (array) 10 ✖
- Music 2
- Blues 1
- Electric guitar 1
- Guitar 1
- Heavy metal 1
- Musical instrument 1
- Plucked string instrument 1
- Progressive rock 1
- Rock music 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
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;