musiccaps_details (view)

4 rows where musiccaps_aspects contains "easygoing" and musiccaps_names contains "Ska"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
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
Jah prayza-Ngoda This is an afrobeat music piece. There is a male vocalist singing playfully in the lead. The electric guitar is playing a groovy melody with the bass guitar playing in the background. The rhythm is being played by the acoustic drums. The atmosphere is cheerful. This piece could be used in the soundtrack of a feelgood movie taking place in Africa. 2013-10-09T16:24:49Z Edmore Chizororo Jah Prayza the beast, the best!!! Good work ["Music", "Ska"] ["afrobeat", "male vocal", "playful singing", "electric guitar", "bass guitar", "acoustic drums", "cheerful", "chill", "easygoing"] 9 asYb6iDz_kM 3583
Shake Rattle n' Roll demo video 1 The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. 2009-09-30T03:58:48Z Bill Crane Demo video recorded 9/28/09. ["Country", "Music", "Ska", "Rock and roll"] ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] 4 rmKh9uaikTU 4900
Jim Reeves on the Grand Ole Opry This May Well Be The Best Jim Reeves Video on Youtube www keepvid com This is a country/western swing music piece. There is a male vocalist singing melodically in the lead with a story-telling attitude. The main tune is being played by the electric guitar with a bass guitar backing. The rhythm is being played by the acoustic drums. The atmosphere is easygoing. This piece could be playing in the background at an American roadside diner. 2010-06-16T20:31:33Z petedrakemusic ["Singing", "Country", "Music", "Ska", "Song"] ["country music", "western swing", "male vocal", "melodic singing", "story-telling mood", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "groovy"] 9 ymGg5TA2YfM 5437

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;