musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "vibrant" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- instrumental · 3 ✖
- vibrant · 3 ✖
- lively 2
- no singer 2
- acoustic guitar 1
- azerbaijani folk music 1
- daf 1
- eastern sounding 1
- fiddle 1
- garmon 1
- iranian classical music 1
- irish folk music 1
- joyful 1
- profound 1
- single instrument 1
- steady tempo 1
- tar 1
- uilleann pipes 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hosein Nourshargh, Majid Dearkhshani, Shahriar Nazari. Moscow, 2009 | This is an Iranian classical music piece. There is no singer in the piece. The melody is being played by the tar which is an Iranian lute. The rhythm is being played by the daf which is an Iranian percussion instrument. The atmosphere is profound. This piece could be playing in the background at an Iranian cuisine restaurant. It could also be used in the soundtrack of a mystery movie that takes place in the Middle East. | 2009-12-16T05:25:56Z | Arctide Descendants | Иранская классическая музыка , Чахар-мезраб Нава с авазом. Хосейн Нуршарг - голос, Маджид Дэрахшани - тар, Шахриар Назари - дайере. Поэзия Бахмана Рафеи. Мосфильм, 16.10.09 Tchaharmezrab Nava with avaz. Hosein Nourshargh - voice, Majid Derakhshani - tar, Shahriar Nazari - dayere. Verses by Bahman Rafeie. Mosfilm studio, 16.10.09 چهارمضراب نوا و آواز. مجید درخشانی و حسین نورشرق.شعر بهمن رافعی | ["Traditional music", "Music"] | ["iranian classical music", "no singer", "instrumental", "tar", "daf", "vibrant", "profound", "eastern sounding"] | 9 | BQ_KrefFiTw | 1236 | |
Seán McKeon, Conor McEvoy, John Blake - Traditional Irish Music from LiveTrad.com | This is an Irish folk music piece. There is no singer. The main melody is being played by the uilleann pipes and the fiddle at a high pitch. The acoustic guitar is playing a rapid procession of chords in the background. The atmosphere is lively. This piece could be playing in the background at an Irish pub. It could also be used in the soundtracks of movies and TV shows that have a theme with an Irish influence. | 2012-02-17T12:56:44Z | Livetrad | http://www.livetrad.com Performing a number of reels during a benefit concert for 'Aid Japan for Children', a group working with survivors of the earthquake and tsunami in Japan in 2011. This video was recorded by Martin Moylan at St. Anne's Church on Dawson St., Dublin 2 and we're delighted to add it to the LiveTrad YouTube channel. For more info see 'Aid Japan for Children' on Facebook. | ["Banjo", "Traditional music", "Music", "Bluegrass"] | ["irish folk music", "no singer", "instrumental", "uilleann pipes", "fiddle", "acoustic guitar", "vibrant", "joyful", "lively", "steady tempo"] | 9 | NwA9JSlK_lM | 2378 | |
Vagif Bagirov "Segah" | This is an Azerbaijani folk music piece. It is an instrumental piece. The only instrument being played is a garmon which has a sound that resembles an accordion. There is a lively atmosphere in the recording. This piece can be played in the soundtrack of a documentary that takes place in the Caucasus region. It could also be used in the soundtrack of an Azerbaijani soap opera. | 2008-04-25T07:36:13Z | Hal Karim | This video was taking by me, Vagif Bagirov one of the proffesional Garmon Maker and he can also play Garmon. | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["azerbaijani folk music", "instrumental", "single instrument", "garmon", "lively", "vibrant"] | 9 | tv14XEQcY0c | 5076 |
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;