musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-05-01 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- emotional 2
- aboriginal instruments 1
- bass guitar 1
- comedy 1
- demonstration 1
- devotional 1
- didgeridoo 1
- didgeridoo player 1
- electronic drums 1
- forest music 1
- goofy 1
- groovy rhythm 1
- hand percussions 1
- healing 1
- home music video 1
- inhale sound 1
- instrumental 1
- instrumental music 1
- intimate 1
- keyboard 1
- laughing track 1
- live music 1
- low quality 1
- medium tempo 1
- mystical 1
- passionate 1
- percussive horn play 1
- poor audio quality 1
- reverberant breathy flute melody 1
- sound effects 1
- synth 1
- tapping sounds 1
- weird 1
- wood clock percussions 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ondrej Smeykal Didjeridu Solo 2 | The song is an instrumental. The tempo is medium with a wood block percussion and a didgeridoo playing percussively. The song is spiritual and emotional in nature. The audio quality is poor. | 2009-05-01T20:56:34Z | Barry Martin | Here's the much anticipated second clip of Ondrej Smeykal playing didgeridoo while visiting LA Outback. Ondrej is playing this didjeridu solo with a pair of clapsticks. If you ever have the chance to see him live definitely make it a point to do so. Check out a wide selection of didgerdioo made in Australia and available in the US at http://www.laoutback.com | ["Didgeridoo", "Music"] | ["didgeridoo", "didgeridoo player", "live music", "home music video", "demonstration", "aboriginal instruments", "poor audio quality", "wood clock percussions", "instrumental music", "hand percussions", "tapping sounds", "medium tempo", "percussive horn play", "groovy rhythm", "emotional", "devotional", "healing", "forest music"] | 1 | q7U8p-m8J3s | 4753 | |
Joke On You - Scratch My Back | This song is used as a theme for a prank video. There is a keyboard and bass guitar providing the melodic background while a dissonant synth plays an on-the-nose comedic tune. There is a funky but simple electronic drum beat for the rhythmic background. Scratching sound effects and a laughing track were also used to emphasize the comedic element. | 2009-05-01T19:20:08Z | DMCMediaz | ["Music", "Scratch"] | ["instrumental", "comedy", "sound effects", "keyboard", "synth", "bass guitar", "electronic drums", "laughing track", "weird", "goofy"] | 9 | A7RgbrJYe_s | 1070 | ||
笛演奏 「田舎笛と空笛」 ~伝統音楽デジタルライブラリー | The low quality recording features a reverberant breathy flute melody with an inhale sound in-between. It sounds mystical, passionate and emotional. | 2009-05-01T09:21:47Z | senzoku-online | 笛の演奏 | ["Wind instrument, woodwind instrument", "Flute"] | ["reverberant breathy flute melody", "inhale sound", "low quality", "intimate", "mystical", "passionate", "emotional"] | 4 | 0u5-WiBKam8 | 221 |
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;