musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_author = 3 and musiccaps_names contains "Country"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- acoustic guitar · 2 ✖
- country-folk 1
- double bass 1
- exciting 1
- fantasy 1
- folk harmonies 1
- folk rock 1
- guitar arpeggios 1
- powerful guitar stabs 1
- repeated vocal motif 1
musiccaps_names (array) 3 ✖
- Country · 2 ✖
- Music 2
- Wedding music 1
youtube_published (date) 2 ✖
- 2011-05-23 1
- 2015-12-22 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mumford & Sons - Sigh No More (Free Album Download Link) | This is a quintessentially folk-rock song, with at least a three-part country-folk harmony. There is an acoustic guitar arpeggio throughout the clip, and a powerful stab on the bass strings every second bar. The song feels sombre, in a way. | 2011-05-23T13:02:11Z | montana8804 | Free Album Download Link: http://bit.ly/igQOpr Mumford & Sons - Sigh No More Sigh No More | ["Country", "Music"] | ["folk rock", "acoustic guitar", "folk harmonies", "country-folk", "powerful guitar stabs", "repeated vocal motif"] | 3 | DA3fNvbZoBM | 1446 | |
Star Wars Theme - Double Bass Solo | This is an instrumental track featuring the double bass and acoustic guitar. Initially, chords are strummed on the acoustic guitar, and then arpeggio notes are played. The double bass is played with a bow and plays the leading melodic motif in the song. The song feels like it would be suitable in an adventure movie. | 2015-12-22T22:50:11Z | TESEO | Star Wars Theme - Double Bass Solo - Plays Francesco Tesei - New Fan Page https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Country", "Music", "Wedding music"] | ["double bass", "acoustic guitar", "guitar arpeggios", "fantasy", "exciting"] | 3 | X6Q53uXgaHc | 3161 |
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;