musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Percussion" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- amateur recording · 2 ✖
- acoustic drums 1
- ambient auditorium sounds 1
- bongos 1
- chant like 1
- chanting 1
- clapping 1
- classical music 1
- classical song 1
- congas 1
- djembe 1
- droning 1
- e-guitar 1
- extemporaneous 1
- female singer 1
- folk song 1
- hynoptic 1
- incoherent music 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- lilting 1
- live performance 1
- meditative 1
- medium fast tempo 1
- medium to uptempo 1
- melodic 1
- people talking 1
- reggae 1
- shaker 1
- small hand cymbals 1
- soothing 1
- vocal backup 1
- xylophone like instrument 1
musiccaps_names (array) 5 ✖
- Music 2
- Percussion · 2 ✖
- Rattle (instrument) · 2 ✖
- Folk music 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lao Traditional Music 2013 4 (ຂັບທຸ້ມຫຼວງພະບາງ) | A female vocalist sings this loud chant like folk song in a foreign language. The tempo is medium fast with vocal backup, rhythmic small hand cymbals and xylophone like instruments. The audio quality is inferior so the music is incoherent. This song is a live performance or concert with ambient sounds. The song is loud, lilting, chant-like, meditative, droning, hynoptic, melodious and classical. This song is a Classical Laos Folk song. | 2013-04-27T04:36:46Z | vkone kone | ຂັບທຸ້ມຫຼວງພະບາງສະບັບເກົ່າ ນຳສະແດງໂດຍຄະນະສິນລະປະວັນນະຄະດີເຮືອນວັດທະນທຳພວງຈຳປາ ເນຶ່່່ອງໃນໂອກາດໄປສະແດງທີ່ປະເທດຝຮັ່ງ. | ["Folk music", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["female singer", "medium fast tempo", "lilting", "chant like", "droning", "hynoptic", "folk song", "classical song", "laos classical song", "laos folk song", "melodic", "extemporaneous", "incoherent music", "live performance", "ambient auditorium sounds", "people talking", "clapping", "amateur recording", "lao folk music", "vocal backup", "small hand cymbals", "xylophone like instrument", "classical music", "laotian classical music", "chanting", "meditative", "soothing"] | 7 | 8MbxazeMw2E | 917 | |
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 |
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;