musiccaps_details (view)
1 row where musiccaps_aspects contains "omani traditional music" and musiccaps_names contains "Bagpipes" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 5 ✖
- bagpipes 1
- lively 1
- omani traditional music · 1 ✖
- street atmosphere 1
- vibrant 1
musiccaps_names (array) 2 ✖
- Bagpipes · 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 |
---|---|---|---|---|---|---|---|---|---|---|
Omani Traditional Music and Dance in Arab Street Singapore | This is an Omani traditional music piece performed live on the street. The melody is being performed by the bagpipes. The atmosphere is vibrant and lively. This piece could be used in the soundtrack of a historical drama that takes place in the Gulf region during British imperial rule. | 2012-11-12T18:12:05Z | Victor Barrero | Omani Traditional Music and Dance. This beautiful dance is originally from Oman. I recorded this during an Oman cultural exhibition in Arab Street, in Singapore, in November 2012. Beautiful Omani music and dance. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["omani traditional music", "street atmosphere", "bagpipes", "vibrant", "lively"] | 9 | gEYTdeQiFv8 | 4018 |
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;