musiccaps_details (view)

3 rows where musiccaps_aspects contains "mono" and musiccaps_names contains "Swing music"

✎ 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
The Music City Soul Brothers - let our love go on (Music City) The low quality recording features harmonizing mixed vocals singing over groovy bass, shimmering cymbals, soft snare hits, funky guitar melody and bright brass melody. The recording is very noisy, in mono, with some crackles in it and it sounds funky and addictive - thanks to those vocals. Sounds like something you would hear in clubs during the 60s and 70s. 2014-01-27T18:37:44Z Alex Rural Soul this song remind me the impressions Hit "it's allright"..i love this style of mid tempo soul ... for first time on youtube!!!! ["Singing", "Swing music", "Music", "Psychedelic rock", "Rock and roll"] ["funk/soul", "low quality", "harmonizing mixed vocals", "groovy bass", "shimmering cymbals", "soft snare hits", "bright brass melody", "funky guitar melody", "funky", "noisy", "crackles", "addictive", "mono"] 4 ZsmfIMEzrQs 3422
Swing Amor "Rose Room" The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. 2008-12-02T16:54:14Z hailletmusic About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] 4 iUHqyjf3NcQ 4191
Camarón & Paco Cepero - Tangos - 1976 The low quality recording features a groovy Spanish acoustic guitar. It sounds very noisy, vintage and the guitar was recorded in mono. 2011-12-09T02:59:34Z QuintoSertorio1987 IV Festival Joaquín el de la Paula 1976 ["Swing music", "Music", "Soul music"] ["low quality", "groovy spanish acoustic guitar melody", "noisy", "mono", "vintage"] 4 ktTrTDQidsE 4363

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;