musiccaps_details (view)
3 rows where musiccaps_aspects contains "droning" and musiccaps_aspects contains "live performance" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- droning · 3 ✖
- live performance · 3 ✖
- amateur recording 2
- bagpiper 2
- instrumental 2
- live audience 2
- loud 2
- people talking 2
- aerophone 1
- ambient auditorium sounds 1
- ambient sounds 1
- bellows 1
- bellows-blown bagpipe 1
- chamber instrument 1
- chant like 1
- chanter 1
- chanting 1
- clapping 1
- classical 1
- classical music 1
- classical song 1
- comforting 1
- complex harmony 1
- deliberate 1
- double reed instrument 1
- drone pipes 1
- emotional 1
- extemporaneous 1
- fast tempo 1
- female singer 1
- folk song 1
- haunting 1
- humming melody 1
- hynoptic 1
- incoherent music 1
- irish 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- lilting 1
- meditative 1
- medium fast tempo 1
- melodic 1
- passionate 1
- piper 1
- rhythmic foot tapping 1
- scottish instrument 1
- sharp 1
- sharp sounds 1
- slow tempo 1
- small hand cymbals 1
- small pipe harmony 1
- soothing 1
- static 1
- vocal backup 1
- wind instrument 1
- woodwind 1
- xylophone like instrument 1
musiccaps_names (array) 7 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fred Morrison | This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. | 2010-02-12T22:46:03Z | Doug Henkle | Recorded on February 6, 2010 using a Flip Video camcorder. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] | 7 | IbD0zpcimgM | 1921 | |
Ivan Georgiev - Piping Live! 2008 | This music is a Bagpiper Instrumental. The tempo is slow with a droning , chanting melody. The melody of the music has middle eastern influences. The droning sound is incessant and hypnotic. It is charming ,sharp, and captivating. | 2008-08-29T10:50:17Z | Piping Centre | http://www.pipingfestival.co.uk Ivan Georgiev performing at the International Piping Concert during Piping Live! 2008 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "slow tempo", "deliberate", "loud", "piper", "scottish instrument", "comforting", "sharp", "bagpiper", "double reed instrument", "bellows", "drone pipes", "wind instrument", "irish", "classical", "aerophone", "chanter", "droning", "sharp sounds", "complex harmony", "live performance", "live audience"] | 7 | 7Ht_Vu1D8nc | 823 | |
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 |
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;