musiccaps_details (view)
4 rows where musiccaps_aspects contains "easygoing" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| »Take Five« harmonica Jazz on diminished harp and acoustic guitar | The low quality recording features a harmonica solo melody played over funky acoustic rhythm guitar. It sounds passionate and easygoing, even though the recording is a bit noisy and in mono. | 2012-05-05T17:09:08Z | /// | Acoustic instrumental version of »Take Five« played by Alfred Hirsch on diminished tuned diatonic harmonica and acoustic fingerstyle guitar (steel strings). Yes I know -- this tune has been played about 1.000.000.000.000 times but what can I do... I really like this song and none of my band buddies wants to play it with me... The first solo is an interpretation of Paul Desmond's solo on the record »Take 5« the second one is an own improvisation. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "mono", "harmonica solo melody", "funky acoustic rhythm guitar", "passionate", "easygoing"] | 4 | IAeYandwJqc | 1877 | |
| Zelda Wind Waker: Dragon Roost Island, self duet guitar+flute (recorder) | The low quality recording features a breathy flute melody playing over acoustic rhythm guitar. The recording is noisy, in mono and it sounds passionate and easygoing. | 2008-04-22T19:52:10Z | JumpmanFR | Music by Kenta Nagata Arrangement by JumpmanFR Finally this version sounds like what I expected. Which one do you like better? Recorder (flûte) or ocarina? For other vids, tabs and cool stuff, visit my website: http://www.jumpman.fr | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "acoustic rhythm guitar", "breathy flute melody", "noisy", "mono", "passionate", "easygoing"] | 4 | KsFCPOKAH60 | 2128 | |
| Mondharmonica beginners video 5; solo opbouw deel 1 : diverse loopjes | This is an amateur recording of a harmonica solo being performed over a blues/rock-n-roll music piece. The piece is instrumental. The harmonica plays a melodic solo in the style of blues. The backing track consists of the electric guitar and the bass guitar playing a simple tune while the medium tempo acoustic drums are playing a basic blues rock beat. The atmosphere is easygoing. This piece could be playing from the radio during a road trip in a movie. | 2011-05-23T18:08:11Z | Harmonicaworkshops | Toonsoort: G , harp in C Video-instructie behorende bij de vervolg-lessen van Hans de Vries. Een solo wint aan kracht als je structuur aanbrengt. Al met een paar eenvoudige loopjes kun je een functionele solo spelen... je kunt in deze solo ook nog je handen gebruiken voor een mooi vibrato affect. Ik laat dit achterwege, zodat je goed kunt zien wat ik doe. De originele backingtrack om zelf op los te gaan , vind je hier: https://www.youtube.com/watch?v=68dvF4_5HK0 Want more? zie http://www.harmonicatips.nl | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "blues", "rock-n-roll", "instrumental", "harmonica solo", "backing track", "electric guitar", "bass guitar", "acoustic drums", "easygoing"] | 9 | Ypuv3htJlpg | 3313 | |
| Safe and sound - Taylor Swift flute cover | This is an amateur flute cover of a pop music piece. The flute is playing a gentle melody in the major key. There is a backing track that has a mellow acoustic guitar playing. The atmosphere is calming and easygoing. Although the audio quality is not that great, this piece could be sampled for use in beat-making. | 2012-03-24T11:55:13Z | Melissa.Flutes | Sorry I've been gone so long! But I'm back now making more videos so keep the requests coming!! Love you guys!!! Links: Notes: http://www.melissaflutes.com/notes/ Facebook: https://www.facebook.com/Missmelflute Twitter: https://twitter.com/Missmelflute Instagram: http://instagram.com/missmelflute Vlog channel : http://www.youtube.com/user/Missmelflutevlogs Facebook: http://www.facebook.com/Missmelflute Twitter: https://twitter.com/#!/Missmelflute | ["Wind instrument, woodwind instrument", "Flute"] | ["cover", "amateur recording", "pop music", "instrumental", "flute", "gentle playing", "acoustic guitar", "calming", "easygoing"] | 9 | _IP6zlayY7k | 3460 |
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;