musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "playful" and musiccaps_aspects contains "vibrant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- instrumental · 3 ✖
- playful · 3 ✖
- vibrant · 3 ✖
- live performance 2
- accordion 1
- aerophone 1
- bass guitar 1
- blues harp 1
- cheerful 1
- cimbalom 1
- contrabass 1
- energetic 1
- enthusiastic 1
- fiddle 1
- fiddle solo 1
- folk music 1
- free reed instrument 1
- french harp 1
- harmonica melody 1
- irish folk music 1
- joyful 1
- loud 1
- lucid 1
- male voice speaking 1
- medium tempo 1
- melodious 1
- mouth organ 1
- no singer 1
- romanian folk music 1
- tapping 1
- tuneful 1
- upbeat 1
- violin 1
- wind instrument 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Galati - Petrecere cu lautari, Crama Lautarilor Galati, 25.11.2011 - Clip 2 - www.djgalati.ro | This is a Romanian folk music piece. It is a live performance. In the background, there is a contrabass and a cimbalom playing. The main melody is being played by the violin and the accordion. The atmosphere is vibrant and cheerful. This piece could be used in the soundtrack of a comedy movie that takes place in eastern Europe or the Balkans, especially during an escape scene. | 2012-01-02T00:50:03Z | Dj Galati Dj Nunta Galati | http://www.djgalati.ro - Sonorizare Echipa DjGalati - Petrecere cu lautari http://www.hotelmagnus.ro/crama.html - Crama Lautarilor Galati - 25.11.2011 *** Voce : Gicu Petrache - Clarinet\Saxofon : George Udila - Tambal : Florica Sandor - Acordeon : Costel de la Bolintin - Vioara : Dorel Zamfir - Bas : Tica | ["Wind instrument, woodwind instrument", "Accordion"] | ["romanian folk music", "live performance", "instrumental", "cimbalom", "contrabass", "violin", "accordion", "vibrant", "playful", "cheerful"] | 9 | 0ewWspUqB6Y | 195 | |
Harmonica: Tongue Block vs. Pucker | This music is a lively harmonica instrumental. The tempo is medium with a spirited melody. The music is lively, clear, energetic, vibrant and breezy with a male voice at the end of the audio clip. This is probably a Harmonica tutorial. | 2006-11-05T01:45:40Z | 12gagedan | This is my 2cents (or 5 minutes) added to the old debate of TB vs. Pucker embuochure when playing the harmonica. My take is very "end justifies the means" and don't limit yourself or worry about myths. (I believed for a very long time that bending and TB was impossible) The bottom line is: achieve the sound you want by working towards good tone with either approach. Apologies to all U-Blockers, as I'm not very good with that. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "medium tempo", "harmonica melody", "male voice speaking", "vibrant", "energetic", "enthusiastic", "playful", "loud", "lucid", "mouth organ", "free reed instrument", "wind instrument", "folk music", "aerophone", "french harp", "blues harp", "tuneful", "melodious"] | 7 | _94ra2KoZGo | 3447 | |
Irish Country Fiddle Solo 'FinnMacCool' - "Pinch of Snuff" | This is the live performance of an Irish folk music piece. There is no singer. The fiddle is playing an upbeat solo while the bass guitar is playing a complex bass line using the tapping technique. The atmosphere is joyful. This piece could be used in the soundtrack of a documentary that has scenes of rapid movement. | 2006-11-03T14:50:10Z | Adrian Keating Archive - Sydney Lyric Orchestra | Blistering Violin Solo by Mark Oates "Pinch of Snuff" -performed by the Finn McCool band; Greg O'Brian gtr, David "Mad Dog" Warwick mandolin, Mark Oates Violin, Steve Sampson bass, every Sat arvo in the Mercantile Hotel, the Rocks, Sydney. Take them seriously. I do. 4 Cameras, 6 sound sources. Mashed together on my (Adrian K) computer. Check out the other Video's of Sydneys Live Music Scene with me all over them @ http://www.youtube.com/profile?user=musodata http://members.ozemail.com.au/~classblu/ check out another raging violinist mate of ours, http://www.youtube.com/watch?v=L0-UjUto2_8 iancooper.com Tags: irish country jig reel traditional electric violin bass guitar mandolin | ["Country", "Music", "Musical instrument", "Violin, fiddle", "Bluegrass"] | ["irish folk music", "live performance", "no singer", "instrumental", "bass guitar", "tapping", "fiddle", "fiddle solo", "playful", "vibrant", "joyful", "upbeat"] | 9 | qMd2DTyF9EE | 4781 |
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;