musiccaps_details (view)
3 rows where musiccaps_author = 6, musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 15 ✖
musiccaps_names (array) 10 ✖
- Bowed string instrument · 3 ✖
- Music 3
- Musical instrument · 3 ✖
- Violin, fiddle 2
- Banjo 1
- Bass guitar 1
- Classical music 1
- Guitar 1
- Plucked string instrument 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alexander Rybak - Bergrosa | This audio contains someone playing a violin with a sad melody and strong bow strokes. The piece sounds as if someone is frustrated and emotional. This song may be playing at a concert. | 2009-05-26T21:58:16Z | eddott | Alexander Rybak performing Bergrosa (the mountain rose) at Bild.de. | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["amateur recording", "violin", "fast tempo", "emotional", "sad", "frustrated"] | 6 | CZZSQ6rd8h0 | 1378 | |
Victor Wooten bass solo & Amazing Grace - Budapest 2007 | This audio contains someone playing a bass solo melody. In the background you can hear something that almost sounds like a dog barking. This song may be playing while listening to a live concert. | 2007-01-26T11:22:22Z | nmhu77 | Budapest A38 Béla Fleck and the Flecktones 22 January 2007 (2nd show) | ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["amateur recording", "e-bass", "background noises", "funky"] | 6 | LHTA8VZGoMs | 2173 | |
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 |
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;