musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow", musiccaps_aspects contains "plucked string instrument" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- instrumental 2
- mellow · 2 ✖
- plucked string instrument · 2 ✖
- stringed instrument 2
- beautiful 1
- bow shaped harp 1
- calming 1
- cascading melody 1
- celestial 1
- cheerful sound 1
- chordophone 1
- classical music 1
- clear 1
- dreamy 1
- ethereal 1
- flowing 1
- four stringed instrument 1
- full sounding 1
- gentle 1
- harp 1
- harp solo 1
- hawaiian instrument 1
- male voice speaking 1
- medium tempo 1
- minimalist 1
- oldest instrument 1
- portable instrument 1
- resonating 1
- rich 1
- sharp sound 1
- simple melody 1
- slow tempo 1
- soft 1
- soothing 1
- ukelele lesson 1
- ukelele tutorial 1
- western classical 1
musiccaps_names (array) 7 ✖
- Harp 1
- Music 1
- Musical instrument 1
- Pizzicato 1
- Plucked string instrument 1
- Speech 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bach Prelude and Fugue BWV 539 | This music is a beautiful Harp instrumental. The tempo is slow with a mellow, gentle and rich Harp melody. The music is dreamy, cascading, ethereal, soothing, calming and harmonic. This music is a Western Classical Harp Solo. | 2011-01-08T20:54:38Z | cbembia | Caroline Bembia playing Bach's Prelude and Fugue in d minor, transcribed for harp | ["Harp", "Pizzicato"] | ["instrumental", "slow tempo", "harp", "gentle", "mellow", "soothing", "harp solo", "minimalist", "celestial", "ethereal", "beautiful", "calming", "stringed instrument", "plucked string instrument", "classical music", "western classical", "bow shaped harp", "chordophone", "oldest instrument", "full sounding", "clear", "flowing", "dreamy", "resonating", "sharp sound", "cascading melody", "rich"] | 7 | POOu05eUvqE | 2531 | |
honey baby (intro) tutorial | This music is a ukelele instrumental. The tempo is medium with a simple melody and a male voice at the end of this clip. This is a ukelele lesson/ tutorial. | 2008-09-18T23:12:01Z | dFav3 | hope u guys learned something in this vid..i made some mistakes coz im still learning myself. hope it helped u guys..hav fun and enjoy! keep practicing. | ["Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "ukelele lesson", "hawaiian instrument", "plucked string instrument", "portable instrument", "four stringed instrument", "cheerful sound", "male voice speaking", "ukelele tutorial", "stringed instrument", "mellow", "soft", "simple melody"] | 7 | U8yqYlErUz8 | 2890 |
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;