musiccaps_details (view)
2 rows where musiccaps_aspects contains "quirky sounds" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- quirky sounds · 2 ✖
- slow tempo · 2 ✖
- accordion 1
- acoustic guitar 1
- amateur recording 1
- bass 1
- children's song 1
- croaking sound 1
- falsetto voice 1
- happy mood 1
- instrumental 1
- male voice singing vocables 1
- no other instruments 1
- no voice 1
- percussion 1
- two chords 1
- xylophone family instrument 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2007-10-29 1
- 2014-11-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banjo-Tooie Music: Glitter Gulch Mine | This children's song features an accordion playing chords. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. An instrument like the xylophone plays the main melody on the low frequencies. There are no voices in this song. This song is an instrumental. The mood of this song is happy. This song can be played in a children's animation series. | 2007-10-29T03:32:40Z | southernpickle | The theme to Glitter Gulch Mine from the game Banjo-Tooie. | ["Music", "Tender music"] | ["children's song", "quirky sounds", "percussion", "bass", "happy mood", "accordion", "croaking sound", "slow tempo", "instrumental", "no voice", "xylophone family instrument"] | 0 | 2UnlMwW8nyI | 372 | |
Disturbing The Peace 2.3 ThanksGiving Special | This song features an acoustic guitar playing chords using only down strokes. There are only two chords being played. The rhythm is played on a 6/8 time signature. A male voice sings vocables in falsetto. Toward the end, the voice produces a belching sound. There are no lyrics in this song. There are no other instruments in this song. This song can be played at a quirky party. | 2014-11-27T22:16:35Z | StevenJoTV | ThanksGiving Special! Follow Me on Twitter And IG - @StevenJoTV Follow me on instagram! - @StevenjoTV Follow Me On Twitter - http://twitter.com/#!/StevenJoTV Like My Facebook Page - http://www.facebook.com/StevenJoTV | ["Tapping (guitar technique)", "Guitar", "Plucked string instrument"] | ["amateur recording", "male voice singing vocables", "falsetto voice", "acoustic guitar", "two chords", "quirky sounds", "slow tempo", "no other instruments"] | 0 | YlgCFc3OvmI | 3310 |
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;