musiccaps_details (view)
4 rows where musiccaps_aspects contains "oud" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- oud · 4 ✖
- acoustic guitar 1
- claps 1
- darbuka 1
- eastern sounding 1
- engaging 1
- flamenco 1
- hindustani music 1
- indian classical 1
- indian classical instruments 1
- instrumental 1
- khaliji music 1
- left speaker 1
- live performance 1
- lute 1
- medium tempo 1
- medium to uptempo 1
- mesmerising 1
- orchestra 1
- pakistani music 1
- percussion 1
- raga 1
- riq 1
- sarod harmony 1
- skilful musicians 1
- sliding pitches 1
- slow tempo 1
- stringed instrument 1
- sympathetic strings 1
- vibrant 1
- violin 1
musiccaps_names (array) 12 ✖
- Music 4
- Musical instrument · 4 ✖
- Guitar 3
- Plucked string instrument 2
- Traditional music 2
- Bowed string instrument 1
- Flamenco 1
- Mandolin 1
- Middle Eastern music 1
- Percussion 1
- Tabla 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
Anouar Brahim - Bahia (Astrakan Cafe) | This song contains someone playing a melody on the oud. This song may be playing by a performer live on stage. | 2008-05-31T07:55:19Z | Amr Shannan | oriental Jazz | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["oud", "left speaker", "slow tempo"] | 6 | AaajkQEU3A0 | 1140 | |
خالد الملا على كثر | This is a live performance of a Khaliji music piece. There is an orchestra performing the piece. The melody is being played by the oud and the violin. The rhythmic background is composed of various percussive elements such as the riq, the darbuka and performers clapping their hands. The atmosphere is vibrant. This piece could be playing in the background at an Arab cuisine restaurant. | 2012-12-22T12:53:27Z | saaa64 | المطرب خالد الملا حضرميه على كثر | ["Traditional music", "Music", "Musical instrument", "Middle Eastern music", "Plucked string instrument", "Bowed string instrument"] | ["khaliji music", "live performance", "orchestra", "violin", "oud", "percussion", "riq", "darbuka", "claps", "vibrant", "eastern sounding"] | 9 | MHHshnnqyco | 2251 | |
Flamenco Duo, Bulerías | Someone is playing a melody on an acoustic guitar and someone another melody on a oud. The two melodies complement each other. This song may be playing in a live presentation. | 2011-05-29T08:10:47Z | Mundo Flamenco | Mariano Martin and Amir John Haddad played this "Bulerías" in may 2011, during a recording session for the website of Mundo Flamenco. Mariano plays a Francisco Barba Caviuna guitar with top of spruce and Amir plays an old arabian lute (Ud) from his father. | ["Flamenco", "Guitar", "Music", "Mandolin", "Musical instrument"] | ["flamenco", "acoustic guitar", "oud", "medium to uptempo"] | 6 | t6jlx6jAb-Q | 5007 |
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;