musiccaps_details (view)
2 rows where musiccaps_aspects contains "classical music" and musiccaps_aspects contains "minimalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- classical music · 2 ✖
- instrumental 2
- minimalist · 2 ✖
- slow tempo 2
- stringed instrument 2
- arabic music 1
- beautiful 1
- bow shaped harp 1
- calming 1
- cascading melody 1
- celestial 1
- chordophone 1
- clear 1
- dreamy 1
- emotional 1
- ethereal 1
- flowing 1
- full sounding 1
- gentle 1
- harp 1
- harp solo 1
- lonely 1
- melancholic 1
- mellow 1
- middle eastern music 1
- nostalgic 1
- oldest instrument 1
- oud melody 1
- plucked string instrument 1
- regional music 1
- resonating 1
- rich 1
- sentimental 1
- sharp sound 1
- soothing 1
- western classical 1
- wistful 1
musiccaps_names (array) 4 ✖
- Harp 1
- Middle Eastern music 1
- Music 1
- Pizzicato 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 | |
Very sad rabab music رباب by gulnoor parachinar | This music is instrumental. The tempo is slow with an Oud solo. The music is minimalist, simple, melancholic, nostalgic, emotional, wistful, pensive; poignant and intense. This is Middle Eastern classical music. | 2014-09-29T13:20:28Z | Gulfam Hussain Noor | Gulfam Hussain Noor Zeran Lalmay Parachinar Gulfam_12345@yahoo.com | ["Music", "Middle Eastern music"] | ["instrumental", "slow tempo", "oud melody", "classical music", "regional music", "arabic music", "middle eastern music", "stringed instrument", "melancholic", "lonely", "nostalgic", "sentimental", "emotional", "wistful", "minimalist"] | 7 | dSyue3RJllA | 3788 |
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;