musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion", musiccaps_aspects contains "upbeat" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- accordion · 3 ✖
- upbeat · 3 ✖
- bass guitar 2
- cheerful 2
- instrumental 2
- acoustic drums 1
- acoustic guitar 1
- acoustic sounding drums 1
- american 1
- balkan music 1
- fiddle 1
- folk dance 1
- joyful 1
- live performance 1
- lively 1
- male vocal 1
- pastoral 1
- percussion 1
- poor quality recording 1
- rapid singing 1
- romanian folk music 1
- upright bass 1
- virtual sounds 1
- yodeling 1
musiccaps_names (array) 4 ✖
- Accordion 2
- Music 1
- Music of Latin America 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guerrini Accordions - Demo Mix Kola [Virtual Acoustic] | This is a folk music piece from the Balkans. It is an instrumental piece performed with virtual sounds. The leading tune is played by a realistic accordion sound. There is an upbeat bass guitar following the rhythm of a fast tempo acoustic sounding drum beat. The atmosphere is cheerful. This piece could be the perfect accompaniment piece for a Balkan folk dancing course. It could also fit well in the soundtrack of a comedy movie that takes place in the Balkan region. | 2012-12-12T20:12:03Z | VirtualAcoustic | http://www.virtual-acoustic.com/ http://www.virtual-acoustic.com/products/legacy-products/guerrini-superior-2 http://www.virtual-acoustic.com/products/legacy-products/guerrini-professional-4 Combination of two Virtual Acoustic accordions. There is also sample of that accordion in SoundFont (SF2) format: Visit us on Facebook http://www.facebook.com/VirtualAcoustic | ["Accordion"] | ["balkan music", "instrumental", "virtual sounds", "accordion", "bass guitar", "acoustic sounding drums", "cheerful", "upbeat", "folk dance"] | 9 | LUtBqNS27AQ | 2193 | |
Chicken Yodel - Kerry Christensen | This is a poor quality recording of a yodeling music piece. There is a male vocalist singing rapidly with the yodeling technique. The melody is being played by an accordion. There is a bass guitar playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is cheerful. Despite the quality issue of the recording, it would suit well as a rural radio station music playing inside the car in a movie. | 2007-06-23T22:30:16Z | UnitedFan4Eva1 | Using RuneScape. Thanks To Madcrazykid1 ( Me ) MollyMoo22 ( My Sis ) --They are the main people-- If you wanna contact me, my MSN is josh.dude-@hotmail.co.uk Thanks! | ["Yodeling", "Music", "Music of Latin America"] | ["poor quality recording", "yodeling", "american", "male vocal", "rapid singing", "accordion", "bass guitar", "acoustic drums", "cheerful", "pastoral", "upbeat"] | 9 | s25X6KwBpxw | 4916 | |
dorel bass boss si lilian de la craiova | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | 2010-10-02T11:31:13Z | bosssbosssmihaita | la o terasa in las palmas de gran canarias | ["Accordion"] | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | 9 | xR2p3UED4VU | 5328 |
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;