musiccaps_details (view)

3 rows where musiccaps_aspects contains "couples dancing", musiccaps_aspects contains "emotional", musiccaps_aspects contains "poor audio quality" and musiccaps_author = 1

✎ 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
Cowboy Cha Cha (partner dance) by Silver Spurs France A male singer sings this retro pop melody. The song is medium tempo with a steady drumming rhythm, steady bass line, guitar accompaniment, and fiddler playing. The song is romantic and slow dance-like. The audio quality is very poor. 2010-07-05T10:34:29Z Shirley Davidson Dance.......Cowboy Cha Cha Choreographed by Toshio Suzuki Music .......I Just Wanna Dance With You by George Strait Danced by dancers from Silver Spurs South West France at a social event July 2010. ["Singing", "Country", "Music", "Tambourine"] ["slow tempo", "slow dance music", "people dancing", "couples dancing", "dance hall", "dance floor", "ambient hall noise", "poor audio quality", "buzzing tones", "high gain noise", "male singer", "classic pop songs", "retro dance hits", "country dance", "emotional", "romantic", "fiddle playing", "guitar rhythm", "steady drumming rhythm", "love song", "love you much", "booming bass line"] 1 B8pesuUc8Ek 1209
SALSA CLASICA ROMANTICA MIX RONNY MUSIC A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. 2011-09-30T01:08:54Z ronnymusic01 BY DJ RONNY MUSIC ["Music", "Middle Eastern music", "Salsa music"] ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] 1 DKflAAykh6A 1464
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. 2015-07-07T18:32:38Z Aman (Flamenco Guitarist) Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] 1 w4Z1QuBOMWU 5236

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;