musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Bowed string instrument" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- amateur recording 2
- medium to uptempo · 2 ✖
- upright bass 2
- acoustic guitar 1
- background noises 1
- country/folk 1
- e-guitar 1
- jazz/bossa-nova 1
- male and female voices singing 1
- mandolin 1
- violin 1
- voices 1
musiccaps_names (array) 8 ✖
- Bowed string instrument · 2 ✖
- Banjo 1
- Cello 1
- Double bass 1
- Music 1
- Musical instrument 1
- Pizzicato 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 | |
Shadow of Your Smile (jazz guitar/bass duo) | This audio contains someone playing jazz chords and melody on a e-guitar along with an upright bass also creating a slapping sound as a percussive element. In the background you can hear people talking and the sound of dishes. This song may be playing in a restaurant. | 2008-07-08T08:50:16Z | Kevin Van Sant | From a gig in the biergarten of Shalimar restaurant in Ettlingen, Germany on June 28 2008 Kevin Van Sant - guitar Ben Palmer - bass We have a new duo CD of all Horace Silver music now available at: www.KevinVanSant.com | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["amateur recording", "jazz/bossa-nova", "upright bass", "e-guitar", "background noises", "voices", "medium to uptempo"] | 6 | zu_1zpF--Zg | 5516 |
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;