musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion melody" and musiccaps_aspects contains "fun" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- accordion melody · 3 ✖
- fun · 3 ✖
- happy 2
- 4 on the floor cowbell pattern 1
- 4 on the floor kick 1
- accordion solo 1
- acoustic rhythm guitar 1
- boomy 1
- breezy 1
- carefree 1
- cheerful 1
- chirpy 1
- country 1
- crowd chattering 1
- crowd clapping 1
- electric guitar melody 1
- enthusiastic 1
- groovy bass 1
- instrumental 1
- laughing 1
- lighthearted 1
- lively 1
- low quality 1
- medium fast tempo 1
- passionate male vocal 1
- poor mix 1
- shimmering shakers 1
- simple 1
- soft crash cymbal 1
- syncopated snare 1
- tinny glass impacts 1
- trombone melody 1
musiccaps_names (array) 4 ✖
- Accordion 2
- Music 1
- Salsa music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Denis Novato | The low quality recording features an accordion melody, electric guitar melody and trombone melody, after which there is a crowd clapping, laughing and chattering sounds. There are also tinny glass impacts in the background. It gives off fun and happy vibes. | 2008-07-13T14:34:40Z | buttonbox | Denis plays at Slovenefest XXVII | ["Accordion"] | ["low quality", "accordion melody", "electric guitar melody", "trombone melody", "crowd clapping", "laughing", "crowd chattering", "fun", "happy", "tinny glass impacts"] | 4 | TWnrcjA6VTk | 2842 | |
Javier Molina & Eldorado - Cowboy Cumbia (Official Music Video) | The Country song features a passionate male vocalist singing over accordion melody, groovy bass, layered "4 on the floor" kick and cowbell pattern, soft crash cymbal, shimmering shakers and acoustic rhythm guitar. It sounds fun and happy, even though the song is poorly mixed, as it sounds a bit boomy. | 2011-08-01T16:05:34Z | TejanoSA | Javier Molina & Eldorado performing Cowboy Cumbia (Official Music Video) © 1998 Javier Molina | ["Singing", "Music", "Salsa music"] | ["country", "passionate male vocal", "accordion melody", "groovy bass", "4 on the floor cowbell pattern", "acoustic rhythm guitar", "fun", "happy", "4 on the floor kick", "syncopated snare", "soft crash cymbal", "shimmering shakers", "poor mix", "boomy"] | 4 | bLjOJRg2P_Q | 3618 | |
online 2 battle il-2 video | This music is a simple and pleasing instrumental. The tempo is medium fast with a cheerful accordion harmony. The music is minimalist,simple, cheerful, happy, fun, carefree, jolly and lighthearted. | 2009-07-12T04:42:37Z | Technonoob | short vid of ingame footage | ["Accordion"] | ["instrumental", "medium fast tempo", "lighthearted", "accordion melody", "accordion solo", "lively", "simple", "fun", "breezy", "cheerful", "chirpy", "enthusiastic", "carefree"] | 7 | tDVOUsG52Jw | 5015 |
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;