musiccaps_details (view)
2 rows where musiccaps_aspects contains "pleasant", musiccaps_names contains "Blues" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- pleasant · 2 ✖
- auto harp 1
- avant-garde 1
- avante-garde 1
- bluegrass 1
- carefree 1
- cheerful 1
- country instrument 1
- country song 1
- country song instrumental 1
- dulcet 1
- emotional 1
- female singer 1
- folk music 1
- french jazz 1
- instrumental 1
- it’s a wonderful life 1
- keyboard accompaniment 1
- lilting melody 1
- love song 1
- medium tempo 1
- mellifluous 1
- minimalist 1
- nostalgic 1
- pedal steel guitar 1
- piano accompaniment 1
- regional music 1
- retro hits 1
- retro jazz 1
- retro pop hits 1
- romantic 1
- sentimental 1
- snare playing 1
- soothing 1
- steady drumming 1
- steady drumming rhythm 1
- steel guitar 1
- string section accompaniment 1
- vintage jazz 1
- vintage pop 1
- vocal vibrato 1
musiccaps_names (array) 3 ✖
- Blues · 2 ✖
- Music · 2 ✖
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gaby Moreno - "Blues de mar" (Audio Single) | A female singer sings this beautiful vintage French melody. The song is medium tempo with a steady drum rhythm, steady bass line, piano accompaniment , string section harmony and some lush snare play. The song is romantic and cheerful with an avant-garde nature. | 2012-10-18T23:56:00Z | Gaby Moreno | @Gaby_Moreno | ["Blues", "Music"] | ["female singer", "lilting melody", "vocal vibrato", "avant-garde", "string section accompaniment", "piano accompaniment", "steady drumming rhythm", "snare playing", "retro pop hits", "avante-garde", "french jazz", "retro jazz", "pleasant", "emotional", "it’s a wonderful life", "carefree", "love song", "retro hits", "vintage pop", "vintage jazz", "cheerful", "romantic"] | 1 | DgqPgNqW2hE | 1504 | |
Richard Burton... pedal steel guitar... last date | This music is a Country song instrumental. The tempo is medium with a pedal steel guitar lead harmony with steady drumming and keyboard accompaniment. The music is a simple,minimalist, sweet, dulcet, sentimental, nostalgic, soothing, pleasant and mellifluous , classic Country music instrumental. | 2011-02-03T00:25:39Z | Bob Adams | Richard's rendition of Floyd Cramer's 'Last Date' A sweet sound from that ZB Richard! | ["Blues", "Music", "Steel guitar, slide guitar"] | ["instrumental", "medium tempo", "keyboard accompaniment", "minimalist", "dulcet", "auto harp", "steel guitar", "pedal steel guitar", "steady drumming", "country song", "country song instrumental", "country instrument", "bluegrass", "regional music", "folk music", "pleasant", "nostalgic", "sentimental", "soothing", "mellifluous"] | 7 | qVT6GX1KHUY | 4788 |
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;