musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "live audience" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- instrumental music · 2 ✖
- live audience · 2 ✖
- passionate · 2 ✖
- ambient noises 1
- ambient room noises 1
- average audio quality 1
- country music 1
- cowboys 1
- dance rhythm 1
- echoes 1
- electric guitar 1
- emotional 1
- energetic 1
- epic stories 1
- exciting 1
- fusion music 1
- groovy 1
- groovy music 1
- groovy rhythm 1
- guitar band 1
- guitar lead 1
- guitar pick percussions 1
- guitar solo 1
- guitar strumming 1
- gunslingers 1
- heroes and villains 1
- hindustani music 1
- improvisational 1
- indian classical music 1
- legends 1
- live performance 1
- percussive bass line 1
- poor audio quality 1
- rhythm guitars 1
- scratching tones 1
- song covers 1
- spirited 1
- story tellers 1
- strings scratched with plectrum percussions 1
- suspense 1
- tabla percussions 1
- tense 1
- the wild west 1
musiccaps_names (array) 7 ✖
- Music 2
- Country 1
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 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 | |
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 |
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;