musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- emotional · 5 ✖
- accordeon 1
- accordion harmony 1
- accordion players 1
- accordion virtuosos 1
- acordian harmony 1
- ambient sounds 1
- bad audio quality 1
- blues 1
- chaotic harmonies 1
- cheerful 1
- clarinet 1
- fast tempo 1
- folk music 1
- foreign language 1
- groovy music 1
- guitar strumming 1
- gypsy music 1
- happy 1
- improvisational music 1
- inferior audio quality 1
- instrumental music 1
- intense 1
- live music 1
- live performance 1
- lively 1
- loud 1
- loud ambient room noise 1
- low quality 1
- male harmony 1
- male singers 1
- male spoken word 1
- male vocal 1
- medium fast tempo 1
- melancholic 1
- mono 1
- moroccan 1
- mourning 1
- nai 1
- noisy 1
- passionate 1
- passionate singing 1
- passionate woodwind melody 1
- percussions playing rhythmically 1
- recital 1
- rhythmic acoustic guitar 1
- romanian 1
- soulful 1
- spirited exciting 1
- three part harmony 1
- traditional 1
- tragic 1
- upbeat 1
- violin 1
- walking bass style 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
- Music 5
- Musical instrument · 5 ✖
- Traditional music · 5 ✖
- Accordion 3
- Wind instrument, woodwind instrument 2
- Clarinet 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kamil - Azerbaycan teraneleri | The low quality recording features a traditional song that consists of a passionate woodwind melody played over wooden percussive elements. It sounds soulful, passionate and emotional, even though the recording is in mono and noisy. | 2008-12-07T05:51:30Z | gunazyayim | Kamil Azerbaycan treraneleri | ["Clarinet", "Traditional music", "Music", "Musical instrument", "Wind instrument, woodwind instrument"] | ["low quality", "traditional", "noisy", "mono", "passionate woodwind melody", "wooden percussive elements", "soulful", "passionate", "emotional"] | 4 | 3w_LsKl-3Pk | 523 | |
el mansouri star du tazi.DAT | This is a melancholic Moroccan music piece. The male vocalist is singing in an agitated, crying-like manner. The only accompaniment being the violin creates a dense atmosphere loaded with emotion. This piece could be used in the soundtrack of a movie or a TV show involving a tragedy which is taking place in North Africa. | 2010-01-09T21:48:11Z | ghrbaoui | a toutes les ghrbaouis | ["Music of Africa", "Traditional music", "Music", "Musical instrument"] | ["moroccan", "violin", "melancholic", "male vocal", "intense", "emotional"] | 9 | CBUAy9Zl6ZE | 1340 | |
Gheorghe Zamfir,Dumitru Farcas,Dan Zahan,Adrian Paunescu part 1 | This is a live performance of a recital. A loud accordion is holding the melodic background as the clarinet performs a solo on top of it. There is also a now (Romanian pan flute) being played. A male voice starts speaking on the recording possibly retelling a story or a poem. There is a tragic atmosphere. This piece could be used in the soundtracks of drama movies or TV series with an Eastern European/Balkan setting. | 2011-02-03T03:31:37Z | Peter Peterr | Recital omagial pentru victimele genocidului din Kosovo,moderatorul emisiunii poetul Adrian Paunescu. | ["Traditional music", "Music", "Musical instrument", "Wind instrument, woodwind instrument", "Accordion"] | ["clarinet", "recital", "accordeon", "nai", "male spoken word", "emotional", "tragic", "mourning", "romanian"] | 9 | JDBu-3VCyWc | 1980 | |
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 | |
Taraful George Ness & Costel de la Bolintin 1.mp4 | The song is an instrumental. The tempo is medium fast with three accordions playing in harmony and virtuoso style , guitar strumming and other percussion instruments. The song is highly improvisational and has a bad audio quality with ambient room noises. | 2011-11-23T21:01:09Z | Taraful George Ness | tel :0768 174 804 George Ness | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["live music", "accordion players", "accordion harmony", "percussions playing rhythmically", "blues", "guitar strumming", "chaotic harmonies", "loud ambient room noise", "bad audio quality", "medium fast tempo", "walking bass style", "groovy music", "gypsy music", "improvisational music", "emotional", "spirited exciting", "instrumental music", "accordion virtuosos"] | 1 | t6XtW3SHQNE | 5006 |
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;