musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2009-05-01
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- aboriginal instruments 1
- bass guitar 1
- comedy 1
- demonstration 1
- devotional 1
- didgeridoo 1
- didgeridoo player 1
- electronic drums 1
- emotional 1
- forest music 1
- goofy 1
- groovy rhythm 1
- hand percussions 1
- healing 1
- home music video 1
- instrumental 1
- instrumental music 1
- keyboard 1
- laughing track 1
- live music 1
- medium tempo 1
- percussive horn play 1
- poor audio quality 1
- sound effects 1
- synth 1
- tapping sounds 1
- weird 1
- wood clock percussions 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Didgeridoo 1
- Scratch 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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;