musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Bagpipes"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- instrumental · 2 ✖
- slow tempo · 2 ✖
- aerophone 1
- bagpiper 1
- bellows 1
- chanter 1
- classical 1
- comforting 1
- complex harmony 1
- deliberate 1
- double reed instrument 1
- drone pipes 1
- droning 1
- irish 1
- live audience 1
- live performance 1
- loud 1
- meditation song 1
- no other instruments 1
- no percussion 1
- no voices 1
- piper 1
- relaxing song 1
- scottish instrument 1
- sharp 1
- sharp sounds 1
- synth song 1
- wind instrument 1
musiccaps_names (array) 2 ✖
- Bagpipes · 2 ✖
- Wind instrument, woodwind instrument 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
SGPB Sleeping Tune.mpg | This song features a synth playing the main melody. The synth plays a heavenly voice with a pad like backing. There are no other instruments in this song. There is no voice in this song. The mood of this song is relaxing. This song can be played in a meditation center. | 2010-03-06T18:33:49Z | gwwoodworth | Bagpipe concert 3/5/10 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["synth song", "no other instruments", "no percussion", "no voices", "instrumental", "slow tempo", "relaxing song", "meditation song"] | 0 | w0yHqPxybQE | 5230 |
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;