musiccaps_details (view)
2 rows where musiccaps_aspects contains "simple tune" and musiccaps_names contains "Ska" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- bass guitar 2
- electric guitar 2
- simple tune · 2 ✖
- upbeat 2
- acoustic drums 1
- acoustic guitar 1
- acoustic sounding drums 1
- country music 1
- cozy 1
- easygoing 1
- energetic 1
- female vocal 1
- groovy 1
- joyful 1
- live performance 1
- male vocal 1
- male vocals 1
- rimshots 1
- rock-n-roll 1
- story-telling mood 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue devils - Mystery girl | This is a rock-n-roll music piece. There is a male vocalist singing as if he is telling a story in the lead. The electric and the bass guitar are playing a simple tune. The acoustic drums are playing an upbeat rhythm with a heavy use of rimshots. The atmosphere of the piece is groovy. This piece could be used in the soundtrack of a romance/romantic comedy movie where the protagonist cannot stop thinking about a girl. | 2008-09-10T20:16:30Z | Tage_ | ["Music", "Ska", "Rock and roll"] | ["rock-n-roll", "male vocal", "story-telling mood", "electric guitar", "simple tune", "bass guitar", "acoustic drums", "rimshots", "upbeat", "energetic", "groovy"] | 9 | D6xrH93lnoc | 1437 | ||
Mandolin Bridge Part 1 | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | 2014-04-08T18:01:39Z | janrohan | This video is about the Mandolin Bridge band Ohio -- rocking country, dance and oldies! Visit us at www.mandolinbridge.com ! | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | 9 | QSaX7QfeWog | 2620 |
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;