musiccaps_details (view)
4 rows where musiccaps_aspects contains "soulful", musiccaps_aspects contains "traditional" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 4
- soulful · 4 ✖
- traditional · 4 ✖
- noisy 3
- passionate 3
- breathy flute melody 2
- mono 2
- wooden percussions 2
- acoustic guitar chords 1
- arpeggiated string melody 1
- arpeggiated strings melody 1
- brass melody 1
- emotional 1
- flute melody 1
- live performance 1
- mystical 1
- passionate woodwind melody 1
- simple bass 1
- violin melody 1
- wide wooden percussive elements 1
- wooden percussive elements 1
musiccaps_names (array) 5 ✖
- Music 4
- Traditional music · 4 ✖
- Clarinet 1
- Musical instrument 1
- Wind instrument, woodwind instrument 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 | |
TRADITIONAL GREEK - HELLAS MUSIC | The low quality recording features a traditional song that consists of a breathy flute melody in the right channel and acoustic guitar chords in the right channel of the stereo image, followed by wooden percussion, simple bass and arpeggiated string melody. It sounds soulful and the recording is noisy. | 2010-05-24T18:02:53Z | thesskosmos | TRADITIONAL FOLK GREEK SONG,KONSTANTINOUPOLIS,HELLAS RETURN INSTRUMENTAL MUSIC BY GEORGE HAJOUDIS, ΔΙΑΣΚΕΥΗ -ΓΙΩΡΓΟΣ ΧΑΤΖΟΥΔΗΣ, ΘΕΣΣΑΛΟΝΙΚΗ 2010 TRADITIONAL MUSIC | ["Traditional music", "Music"] | ["low quality", "breathy flute melody", "simple bass", "arpeggiated string melody", "acoustic guitar chords", "traditional", "soulful", "noisy", "wooden percussions"] | 4 | 6oqbYipROOs | 790 | |
Traditional Berber Music | The low quality recording features a live performance of a traditional song and it contains wooden percussion, violin melody and flute melody. It sounds soulful, passionate and the recording is noisy and in mono. | 2008-05-22T17:53:23Z | culturexchangeteam | We had the good fortune to attend a concert of Moroccan Berber Music in Marrakesh | ["Traditional music", "Music"] | ["low quality", "live performance", "traditional", "wooden percussions", "violin melody", "flute melody", "soulful", "passionate", "noisy", "mono"] | 4 | W8Xv3Q2kGRA | 3070 | |
Veeramanidasan | Adi Velliyile | Ayiram Kannudaiyal | The low quality recording features a traditional song that consists of wide wooden percussion, arpeggiated strings melody and breathy flute melody layered with brass melody. It sounds soulful, mystical and passionate. | 2013-02-23T11:36:22Z | Symphony | Amman Music Video Album by Veeramanidaasan with an interesting Storyline and fantastic visuals and pilgrimage of amman temples. To download music visit www.mytamilsong.com To Download songs from itunes click here http://geni.us/3GZg | ["Traditional music", "Music"] | ["low quality", "wide wooden percussive elements", "arpeggiated strings melody", "breathy flute melody", "brass melody", "soulful", "mystical", "passionate", "traditional"] | 4 | rKfpCiJf9do | 4866 |
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;