musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "upright bass" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- easygoing · 2 ✖
- upright bass · 2 ✖
- acoustic guitar 1
- banjo 1
- banjo solo 1
- bluegrass 1
- comedic 1
- complaining 1
- female vocal 1
- flute 1
- joyful 1
- live performance 1
- male vocals 1
- movie music 1
- musical 1
- piano 1
- playful 1
- story-telling mood 1
- strings 1
- uplifting 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Greensky Bluegrass | 3/01/2014 | "Letter To Seymour" - "New Rize Hill" | This is the live performance of a bluegrass music piece. There are male vocals singing together in a lively manner. There are two banjos playing the melody, one acting as the lead and the other as the rhythm. There is also an acoustic guitar following the banjos. An upright bass is playing the bass line which acts as a rhythmic background. The general atmosphere of the piece is very uplifting. The piece can be used in the soundtrack of rural comedies. It could also be used in the background for funny social media content. | 2014-04-20T16:36:51Z | GreenskyBluegrass | Greensky Bluegrass live at the Neptune Theater in Seattle, Washington on March 1, 2014 performing a medley of Letter To Seymour into New Rize Hill. Anders Beck: dobro Michael Arlen Bont: banjo and vocals Dave Bruzza: guitar and vocals Mike Devol: bass and vocals Paul Hoffman: mandolin and vocals Filmed & Edited by Mark Burgin (tapermark) © 2014 Greensky Bluegrass All Rights Reserved www.greenskybluegrass.com | ["Flamenco", "Music", "Mandolin", "Bluegrass"] | ["bluegrass", "live performance", "male vocals", "banjo", "banjo solo", "upright bass", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing"] | 9 | Tvwi_YuLehk | 2876 | |
The Sound of Music Soundtrack - 4 - Maria | This is a musical piece. There is a story-telling mood in this piece. The female vocalist is singing about her troubles in a complaining manner. There are many instruments in the melodic background such as piano, strings, flute and upright bass. The atmosphere of the piece is easygoing and comedic. | 2011-03-15T01:45:42Z | xosoundtrackloverxo | ["Yodeling", "Music", "Soundtrack music"] | ["musical", "movie music", "female vocal", "story-telling mood", "piano", "strings", "flute", "upright bass", "complaining", "easygoing", "comedic"] | 9 | OKZF0oG1E14 | 2427 |
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;