musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality", musiccaps_names contains "Bagpipes" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- poor audio quality · 2 ✖
- ambient street noise 1
- army band 1
- bagpipe melody 1
- bagpipes 1
- band arrangement 1
- drum beats 1
- flutes playing in unison 1
- instrumental music 1
- intricate celtic melody 1
- live march 1
- live performance 1
- low hum 1
- marching band 1
- marching rhythm 1
- people marching 1
- people talking 1
- percussions sounds 1
- school band 1
- social activism 1
- steady rhythm 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roncos do Diabo - Passodoble Português | This is a live recording of a performance on the bagpipes. There are two bagpipes, one playing a low pitched buzzing hum and the other playing an intricate celtic-style melody. The audio quality is poor. | 2008-03-05T20:20:26Z | colicojack | Roncos do Diabo - Almada - 26.01.2008 Saia da Carolina André Ventura (Gaita Transmontana) João Ventura (Gaita Transmontana) Mário Estanislau (Gaita Transmontana) Vitor Félix (Gaita Transmontana) Tiago Pereira (Percussão) | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["live performance", "bagpipes", "bagpipe melody", "low hum", "poor audio quality", "intricate celtic melody"] | 3 | BYnYTgeM6Go | 1257 | |
Ross Kemp joins Orange Order Feeder Parade. 12 July 2013....5 | The music track is that of a band marching in the streets. The tempo is medium with a Band march, playing percussion in a steady rhythm accompanied by flutes playing in unison. The song has bad audio quality with ambient noises of people talking and other street noises. | 2013-07-12T12:43:57Z | william belfast | Orange Order Feeder Parade www.newsflare.com | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["live march", "marching band", "instrumental music", "flutes playing in unison", "steady rhythm", "drum beats", "marching rhythm", "percussions sounds", "people marching", "social activism", "army band", "school band", "band arrangement", "poor audio quality", "ambient street noise", "people talking"] | 1 | v9TTtjEngjY | 5159 |
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;