musiccaps_details (view)
2 rows where musiccaps_aspects contains "regional music" and musiccaps_aspects contains "stringed instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- instrumental 2
- regional music · 2 ✖
- stringed instrument · 2 ✖
- arabic music 1
- banjo 1
- banjo lead 1
- bluegrass 1
- classical music 1
- country 1
- country music 1
- emotional 1
- fast tempo 1
- folk 1
- folk song 1
- high pitched sounds 1
- home recording 1
- lively 1
- lonely 1
- melancholic 1
- melodious 1
- middle eastern music 1
- minimalist 1
- no accompaniment 1
- nostalgic 1
- oud melody 1
- poor audio quality 1
- sentimental 1
- slow tempo 1
- spirited 1
- wistful 1
- world music 1
musiccaps_names (array) 4 ✖
- Music 2
- Banjo 1
- Bluegrass 1
- Middle Eastern music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 | |
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;