musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- medium to uptempo · 2 ✖
- acoustic drums 1
- acoustic/digital percussion 1
- amateur recording 1
- bongos 1
- congas 1
- djembe 1
- e-guitar 1
- male voice singing/shouting 1
- oriental music 1
- reggae 1
- shaker 1
- turkish baglama 1
musiccaps_names (array) 3 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
reggae.avi | People are playing the same groove on a lot of percussive instruments. In the background you can hear shakers. Someone is strumming chords with an effect on an e-guitar and someone is playing fill-ins on acoustic drums. This song may be playing at a local live concert from a music school. | 2010-09-10T18:11:18Z | pchedy | Primer contacto en la composicion de un reggae de la escuela de percusion de Santa Ursula bajo la direccion de Chedy Perera | ["Music", "Rattle (instrument)", "Percussion"] | ["amateur recording", "reggae", "shaker", "bongos", "djembe", "congas", "bongos", "acoustic drums", "e-guitar", "medium to uptempo"] | 6 | 9Tl2l3bsLpE | 1011 | |
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 |
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;