musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "suspense"
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- instrumental music · 3 ✖
- passionate · 3 ✖
- suspense · 3 ✖
- emotional 2
- live performance 2
- medium tempo 2
- ambient room noises 1
- average audio quality 1
- average sound quality 1
- bell tones 1
- cellos playing percussively 1
- classical music 1
- country music 1
- cowboys 1
- echoes 1
- eerie 1
- electric guitar 1
- epic stories 1
- ethereal sounds 1
- ethereal tones 1
- exquisite technique 1
- flute playing poignantly 1
- glass harp harmony 1
- glass harpist 1
- groovy 1
- groovy music 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- gunslingers 1
- heroes and villains 1
- journey in to the unknown 1
- legends 1
- live audience 1
- majestic and scary 1
- male and female players 1
- master class 1
- mesmerising 1
- movie soundtrack 1
- ominous music 1
- percussive hits 1
- rhythm guitars 1
- scratching tones 1
- serious 1
- song covers 1
- sound effects 1
- spirited 1
- steady drumming 1
- story tellers 1
- string orchestra 1
- strings scratched with plectrum percussions 1
- strong harmony 1
- tamil movie soundtrack 1
- tense 1
- the wild west 1
- trumpets playing furiously 1
- vibrato 1
- wine cellar 1
- wonder 1
musiccaps_names (array) 7 ✖
- Music 3
- Musical instrument 2
- Glass 1
- Guitar 1
- Plucked string instrument 1
- Strum 1
- Theme music 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 | |
Sugar Plum Fairy by Tchaikovsky - GlassDuo LIVE (glass harp) | The song is an instrumental. The tempo is medium with the glass harp being played percussively by two glass harpists with no other instrumentation . The song is mysterious and ethereal in nature. | 2011-02-18T09:48:59Z | GlassDuo - Glass Harp | GlassDuo at the "Festival di Santo Stefano" in Bologna, Italy. GlassDuo have created an exceptional musical instrument from a set of custom made wine glasses. The result is the biggest professional #GlassHarp in the world. This beautiful #ChristmasMusic from the "GLASSIFIED" album is available here: http://shop.glassduo.com Some links about GlassDuo and the #MusicalGlasses: http://GlassDuo.com - official website http://GlassHarp.eu - order your own glass harp http://shop.glassduo.com - buy CD and MP3 https://www.facebook.com/GlassHarp.GlassDuo - Facebook profile https://www.instagram.com/glassharpduo - Instagram profile Donation via PayPal: https://www.paypal.com/donate/?hosted_button_id=NXNGF7WPNT3LL | ["Glass", "Music", "Musical instrument"] | ["glass harp harmony", "male and female players", "ethereal tones", "glass harpist", "master class", "live performance", "wine cellar", "serious", "instrumental music", "mesmerising", "ethereal sounds", "bell tones", "serious", "eerie", "wonder", "suspense", "medium tempo", "vibrato", "classical music", "sound effects", "journey in to the unknown", "exquisite technique", "instrumental music", "passionate"] | 1 | QdoTdG_VNV4 | 2631 | |
BILLA 2 Theme music [Original sound track] | The song is an instrumental music section. The song is medium tempo with a string section playing percussively with violins and cellos in harmony, flute playing a melancholic solo, percussive hits and steady bass line. The song is full of suspense and passion. The song is a Tamil movie instrumental soundtrack. | 2012-05-02T14:19:34Z | Palani Kumar | ["Theme music", "Music"] | ["instrumental music", "string orchestra", "ominous music", "movie soundtrack", "emotional", "passionate", "spirited", "flute playing poignantly", "medium tempo", "steady drumming", "cellos playing percussively", "strong harmony", "trumpets playing furiously", "suspense", "tamil movie soundtrack", "average sound quality", "majestic and scary", "percussive hits"] | 1 | fRpJfrfjoZo | 3947 |
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;