musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "folk song" and musiccaps_aspects contains "low quality audio"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- folk song · 2 ✖
- low quality audio · 2 ✖
- accordion 1
- acoustic guitar 1
- basic percussion 1
- clarinet 1
- guitar 1
- instrumental 1
- male voice 1
- moderate tempo 1
- no voices 1
- slow tempo 1
- trumpet 1
- tuba 1
musiccaps_names (array) 3 ✖
- Accordion 1
- Music 1
- Rustling leaves 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johnny Cash - Blowin' In The Wind | This folk song features a male voice singing the main melody in a southern accent. The voice falls in the bass category. This is accompanied by an acoustic guitar strumming chords. The recording is of low quality and there is a lot of white noise drowning the other sounds. A basic percussion instrument is played. The voice is emotional. This song can be played in a retro style movie where a family goes to meet their grandparents out in the countryside. | 2009-03-01T21:52:19Z | phormt2912 | Johnny Cash Cantando "Blowin' In The Wind" de Bob Dylan | ["Music", "Rustling leaves"] | ["folk song", "male voice", "low quality audio", "acoustic guitar", "basic percussion", "moderate tempo"] | 0 | 2i4UNf8tjvU | 399 | |
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 |
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;