musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- jazz · 2 ✖
- 8 stringed instrument 1
- acoustic rhythm guitar chords 1
- bluegrass 1
- classical 1
- country song 1
- country songs 1
- elegant 1
- ethnic music 1
- folk 1
- high notes 1
- instrumental 1
- lute instrument 1
- mandolin 1
- mandolin instrumental 1
- medium tempo 1
- melodious 1
- passionate solo acoustic guitar melody 1
- simple double bass 1
- smooth 1
- soprano tone 1
- string instrument 1
- sweet 1
- tutorial 1
musiccaps_names (array) 8 ✖
- Mandolin · 2 ✖
- Music 2
- Acoustic guitar 1
- Banjo 1
- Bluegrass 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
10 songs to play on mandolin that aren't bluegrass | This song is a mandolin instrumental. The tempo is medium with a lively melody on the mandolin. The music is minimalist without any other instruments. The music is high pitched, melodious and charming. This audio ends abruptly indicating that this could be a mandolin tutorial. | 2014-08-08T12:17:31Z | mandohat | I love bluegrass, but the mandolin is a great instrument for lots of styles! http://www.andyslessons.com ---Andy Hatfield, mandolin and guitarist | ["Music", "Mandolin"] | ["instrumental", "medium tempo", "mandolin", "folk", "classical", "jazz", "ethnic music", "country songs", "tutorial", "string instrument", "mandolin instrumental", "8 stringed instrument", "country song", "bluegrass", "high notes", "melodious", "sweet", "lute instrument", "soprano tone"] | 7 | 2ZogsGp-T4o | 381 | |
Maxwell Swing by Texas Gypsies | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | 2012-07-31T05:33:50Z | maxwellswing | Original Gypsy Jazz tune by Texas Gypsies from the Cafe du Swing CD! www.texasgypsies.com Photos by John Heiman, Bruce Buhrow, Chad Windham,David Meadows | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | 4 | AmAThmRphk0 | 1168 |
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;