musiccaps_details (view)
2 rows where musiccaps_aspects contains "country" and musiccaps_aspects contains "fruity male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- country · 2 ✖
- fruity male vocal · 2 ✖
- passionate 2
- emotional 1
- energetic 1
- heartfelt 1
- keys chords 1
- live performance 1
- low quality 1
- percussive acoustic rhythm guitar 1
- simple bass 1
- smooth double bass 1
- ukulele orchestra chord progressions 1
- uptempo 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ukulele Orchestra of GB - Orange blossom | The low quality recording features a live performance of a country song played by ukulele orchestra, smooth double bass and sung by fruity male vocals. It is uptempo and it sounds energetic, even without drums, and passionate. | 2008-01-04T19:37:26Z | slowmoon | From the live DVD 'Anarchy in the Ukulele' | ["Music", "Musical instrument", "Ukulele"] | ["low quality", "live performance", "fruity male vocal", "country", "ukulele orchestra chord progressions", "smooth double bass", "uptempo", "energetic", "passionate"] | 4 | H18aK9HhNSM | 1771 | |
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 |
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;