musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- bass guitar · 4 ✖
- cheerful · 4 ✖
- upbeat · 4 ✖
- accordion 2
- instrumental 2
- acapella 1
- acoustic drums 1
- acoustic sounding drums 1
- american 1
- balkan music 1
- brush 1
- eerie 1
- electronic drums 1
- female synth vocal 1
- finger click 1
- folk dance 1
- harmony singing 1
- male vocal 1
- no singer 1
- pastoral 1
- playful 1
- poor quality recording 1
- rapid singing 1
- snare drum 1
- swing jazz 1
- trumpets 1
- virtual sounds 1
- vocaloid 1
- wind band 1
- yodeling 1
musiccaps_names (array) 9 ✖
- Music 2
- A capella 1
- Accordion 1
- Brass instrument 1
- Happy music 1
- Music of Latin America 1
- Trumpet 1
- Vocal music 1
- Yodeling 1
youtube_published (date) 4 ✖
- 2007-06-23 1
- 2010-10-26 1
- 2012-12-12 1
- 2015-09-25 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 | |
Mum and the Trumpet Girls (Bugler's Holiday) | This is an instrumental wind band music piece. There are three trumpets playing the main melody while a wind instrument sound is playing a supporting tune. There is a bass guitar playing in the background. The rhythm consists of a simple electronic drum beat. The atmosphere is playful and cheerful. This piece could be used in the soundtrack of a kids TV show. | 2010-10-26T09:13:56Z | krystalstawarz95 | ["Brass instrument", "Trumpet"] | ["no singer", "instrumental", "wind band", "trumpets", "bass guitar", "electronic drums", "playful", "upbeat", "cheerful"] | 9 | Z0O2r0Dl2T4 | 3334 | ||
딸한테 아카펠라를 시켰다 | This is an acapella version of a swing jazz music piece that was performed with various layers of a vocal synth software called vocaloid. Three different harmonies can be heard from this vocal synth. There is a bass guitar playing a walking bass line in the background. The rhythmic background consists of finger clicks and a swing jazz beat performed with brushes on a snare drum. The atmosphere is cheerful but eerie. This piece could be used in the soundtrack of an arcade/analog type video game. It could also work well in the soundtrack of an anime. | 2015-09-25T14:24:08Z | Rain Silver | http://tvple.com/350077 http://www.nicovideo.jp/watch/sm25083117 | ["Music", "Vocal music", "A capella", "Happy music"] | ["acapella", "vocaloid", "swing jazz", "female synth vocal", "harmony singing", "bass guitar", "finger click", "snare drum", "brush", "eerie", "cheerful", "upbeat"] | 9 | nYO8n62Piys | 4550 | |
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 |
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;