musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "playful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- easygoing · 2 ✖
- live performance · 2 ✖
- playful · 2 ✖
- acoustic guitar 1
- banjo 1
- banjo solo 1
- bluegrass 1
- instrumental 1
- jazz steel pan 1
- joyful 1
- male vocals 1
- percussion 1
- relaxing 1
- rhythm 1
- uplifting 1
- upright bass 1
musiccaps_names (array) 12 ✖
- Music 2
- Bluegrass 1
- Drum 1
- Drum kit 1
- Electronic organ 1
- Flamenco 1
- Jazz 1
- Mandolin 1
- Musical instrument 1
- Organ 1
- Percussion 1
- Steelpan 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 | |
Andy Narell Solo | This is the live performance of a percussion piece. There is a playful sounding jazz steel pan solo being performed on stage. The atmosphere is easygoing. This piece could be used during tropical scenery shots in a movie with a summer/vacation theme. | 2008-03-30T15:10:09Z | nehpets99 | Andy Narell, world famous steel pan composer/performer, solos as the guest artist for Miami University's Steel Band. | ["Organ", "Drum", "Drum kit", "Jazz", "Electronic organ", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["percussion", "rhythm", "live performance", "instrumental", "jazz steel pan", "playful", "relaxing", "easygoing"] | 9 | cQpK9zs_uv0 | 3706 |
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;