musiccaps_details (view)
2 rows where musiccaps_aspects contains "single instrument" and musiccaps_aspects contains "solo" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- instrumental 2
- melancholic 2
- single instrument · 2 ✖
- solo · 2 ✖
- disappointment 1
- emotional 1
- garmon 1
- harmonica 1
- live performance 1
- no singer 1
- russian folk music 1
musiccaps_names (array) 3 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Harmonica Comparison | This is the recording of a harmonica solo. The tune being played on the harmonica is a melancholic one. There is an emotional aura to it. It could be used in the soundtrack of an animation movie, especially during a scene where a character is going through feelings of heartbreak or disappointment. | 2009-10-27T22:24:03Z | roady43 | Audio Quiz In the added mp3 sample I recorded the same melody on 8 different harmonicas, always trying to use the same, quite strong airflow. Instruments: Seydel Chromatic deLuxe, Hohner Hard Bopper , Mellow Tone, Chromonica 270 Deluxe, Meisterklasse, Chrometta 8, 270 Standart, CX-12. Some are in augmented tuning. The order in the sound sample is not the same as I mentioned them above... Can anybody tell the correct order? Does one really hear much more than only some slight differences in volume? Now tell me who is who... Enjoy! roady43 | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "single instrument", "harmonica", "solo", "melancholic", "emotional", "disappointment"] | 9 | Lhw0H3P4zUE | 2215 | |
Одинокая гармонь | This is a live performance of a Russian folk music piece. There is no singer in this piece. The single instrument being played is a garmon. The performer is playing a melancholic solo on the garmon. This piece could be used in the soundtrack of a movie or a documentary that takes place in Russia. It could also be playing in the background at a Russian cuisine restaurant. | 2011-06-26T14:54:47Z | apelsin9899 | Am 08.07.2010 fand in der Carl von Ossietzky Universität ein Open-Air-Konzert der Deutsch-Russischen Kulturbrücke aus Oldenburg statt. Friedrich Weigel (Knopfakkordeon) Фёдор Андреевич Вайгель - баян Ilja Weigel (Piano) Илья Вайгель - пианино http://www.drk-most.de/ | ["Accordion"] | ["russian folk music", "live performance", "no singer", "instrumental", "single instrument", "garmon", "solo", "melancholic"] | 9 | MtVLmOvQopM | 2306 |
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;