musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "live music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- emotional 2
- instrumental music · 2 ✖
- live music · 2 ✖
- medium tempo 2
- poor audio quality · 2 ✖
- aboriginal instruments 1
- baroque music 1
- composers 1
- conductors 1
- demonstration 1
- devotional 1
- didgeridoo 1
- didgeridoo player 1
- forest music 1
- groovy rhythm 1
- hand percussions 1
- harpsichord 1
- harpsichord player 1
- harpsichordist 1
- healing 1
- home music video 1
- live audience 1
- live performance 1
- passionate 1
- percussive horn play 1
- romantic 1
- spirited 1
- tapping sounds 1
- western classical music 1
- wood clock percussions 1
musiccaps_names (array) 4 ✖
- Didgeridoo 1
- Harpsichord 1
- Keyboard (musical) 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Couperin & Clavecin | The song is an instrumental. The song is medium tempo with a harpsichord belting played with no other instrumentation. The music is emotional, passionate and melancholic. The song audio quality is poor. | 2007-10-14T21:47:21Z | profsha | Eric DEM joue Couperin au clavecin à l'église de Cesson-Sévigné. | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord", "harpsichord player", "harpsichordist", "poor audio quality", "instrumental music", "medium tempo", "composers", "conductors", "live music", "live performance", "live audience", "emotional", "spirited", "romantic", "baroque music", "passionate", "western classical music"] | 1 | S38KjqRR418 | 2737 | |
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;