musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Wind instrument, woodwind instrument" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 26 ✖
- medium tempo · 4 ✖
- acoustic guitar 3
- amateur recording 3
- harmonica 3
- accordion player 1
- ambient crowd noise 1
- country/pop 1
- dance music 1
- enthusiastic 1
- ethnic instruments 1
- flute playing 1
- folk music 1
- guitar playing 1
- gypsy music 1
- home studio 1
- instrumental harmony 1
- instrumental music 1
- jam session 1
- life is good 1
- live jam 1
- live performance 1
- melancholic 1
- nostalgic moments 1
- people enjoying the music 1
- relaxing 1
- singer-songwriter 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Eu Quero é Sossego", de K-Ximbinho, com Nonato Lima e Grupo Murmurando.mp4 | The song is an instrumental. The tempo is medium with an accordion player, guitar rhythm, flute player and other percussion playing in harmony. The song is groovy and has gypsy flavour to it. The song audio quality is poor with ambient crowd noises. | 2013-01-24T15:01:39Z | claudeide | Programa Brasileirinho, 20 de Janeiro de 2013 - Acordeonista Nonato Lima toca a música "Eu Quero é sossego", de K-Ximbinho, acompanhado pelo Quinteto Murmurando. | ["Wind instrument, woodwind instrument", "Accordion"] | ["accordion player", "life is good", "relaxing", "jam session", "home studio", "melancholic", "nostalgic moments", "people enjoying the music", "instrumental harmony", "folk music", "flute playing", "guitar playing", "live jam", "instrumental music", "medium tempo", "ambient crowd noise", "enthusiastic", "dance music", "gypsy music", "folk music", "ethnic instruments", "dance music", "live performance"] | 1 | tbovKStEnME | 5051 | |
Oasis - Don´t Look Back in Anger | Someone is strumming chords on a guitar while someone else is playing a melody using a harmonica. This song sounds like sitting around a bonfire. | 2008-06-27T21:00:21Z | Rafael Modesto | Hugo no violão e Modesto na gaita mandando um Oasis mto lokooo!! | ["Harmonica", "Wind instrument, woodwind instrument"] | ["country/pop", "amateur recording", "acoustic guitar", "harmonica", "medium tempo"] | 6 | F8wGRd9332s | 1618 | |
"sözlerimi geri alamam" MIZIKA GİTAR ERKAN İPEK YORUMU | Someone is strumming chords on a guitar while playing a sad sounding melody on a harmonica. This song may be playing sitting on a bonfire surrounded by friends. | 2011-04-05T21:56:48Z | piyanist5151 | "SÖZLERİMİ GERİ ALAMAM" GİTAR MIZIKA ERKAN İPEK YORUMU | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "acoustic guitar", "harmonica", "medium tempo"] | 6 | MyH8zQw9csc | 2312 | |
Pink Floyd - Wish You Were Here (Acoustic & Harmonica Cover) | This song contains someone strumming chords on an acoustic guitar while playing a harmonica. This song may be playing at a local bar. | 2013-02-03T12:46:04Z | EnJayMuzak | Acoustic cover of Pink Floyd's Wish You Were Here. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "singer-songwriter", "acoustic guitar", "harmonica", "medium tempo"] | 6 | _xURU_-ffC4 | 3502 |
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;