musiccaps_details (view)
2 rows where musiccaps_aspects contains "oriental music" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- oriental music · 2 ✖
- accordion-like wind instrument 1
- acoustic/digital percussion 1
- male voice singing/shouting 1
- medium to upbeat 1
- medium to uptempo 1
- tablas 1
- turkish baglama 1
musiccaps_names (array) 5 ✖
- Music 2
- Carnatic music 1
- Folk music 1
- Rattle (instrument) 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baba Zula & the Istanbul Music Scene | Belly Dancing in Turkey | A digital drum is playing a reggaeton groove along with some acoustic percussion while someone is playing a turkish baglama. A male voice is singing/shouting. This is an amateur recording. This song may be playing outside busking with a band. | 2008-07-27T17:28:38Z | Rudy Maxa's World | For "Rudy Maxa's World," Istanbul's rock group Baba Zula performed in their rehearsal studio, complete with two exotic belly dancers. Turkish style belly dancing and the psychedelic music of this popular band are just one of the cultural highlights this region has to offer. Check out more about Turkey and Istanbul at http://rudymaxasworld.com/episodes/turkey-istanbul/ | ["Music", "Rattle (instrument)"] | ["oriental music", "turkish baglama", "acoustic/digital percussion", "male voice singing/shouting", "medium to uptempo"] | 6 | OB7GyVqufwQ | 2409 | |
Canti indiani e harmonium | A accordion-like wind instrument is playing a melody along with someone playing a rhythm on the tablas. This song may be playing at a music school jamming with the teacher. | 2009-12-01T17:08:58Z | Scuola Olistica Ananda Ashram Milano | http://www.yogamilano.it/corsi-settimanali/musica-indiana/ | ["Carnatic music", "Folk music", "Music", "Sitar"] | ["oriental music", "accordion-like wind instrument", "tablas", "medium to upbeat"] | 6 | U4UtZeTl2DE | 2886 |
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;