musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "accordion" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- accordion · 2 ✖
- instrumental 2
- acoustic guitar 1
- alpine folk music 1
- bass guitar 1
- cello 1
- cheerful 1
- clarinet 1
- flute 1
- folk dance 1
- joyful 1
- lively 1
- no singer 1
- orchestra 1
- percussion 1
- punjabi film music 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mitja kvintet - S klarineti na pot-Mit Klarinetten unterwegs | This is an Alpine folk music piece. The piece is instrumental. It is being performed by an orchestra composed of the clarinets, the accordion, the cello and the acoustic guitar. The atmosphere is cheerful. This piece could be used in the soundtrack of a movie that takes place in the Alps region. | 2008-01-16T21:07:21Z | horni110607 | Mit Klarinetten unterwegs Komp.: Damir Tkavc - Alpenoberkrainer / Alpski kvintet Mitja Mastnak Robi Marzel Sandi Jug Zmago Tkavc Matjaz Vodisek Mario Reumüller | ["Wind instrument, woodwind instrument", "Accordion"] | ["alpine folk music", "instrumental", "orchestra", "clarinet", "accordion", "cello", "acoustic guitar", "cheerful", "joyful"] | 9 | 9mqA4YdX444 | 1041 | |
Channa Sachi Muchi [Full Song] Channa Sachi Muchi | This is a Punjabi film music piece. At first, the melody is being played by the accordion. Then, it is being played by the flute. In the background, a bass guitar is playing. The rhythm is provided by the percussion. The atmosphere is vibrant. This piece could be used as an accompaniment piece for a folk dance course. | 2011-05-17T00:20:26Z | T-Series | Song - Channa Sachi Muchi Film - Channa Sachi Muchi Singer - Miss Pooja Lyricist - Romi Tahli Music Director - Jassi Bros. Artist - Miss Pooja, Goldy Sumal, Jas Dhillon, Rana Ranbir Music On - T-Series | ["Wind instrument, woodwind instrument", "Flute", "Accordion"] | ["punjabi film music", "no singer", "instrumental", "accordion", "flute", "bass guitar", "percussion", "vibrant", "lively", "folk dance"] | 9 | eWSA0xubW7I | 3871 |
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;