musiccaps_details (view)

2 rows where musiccaps_aspects contains "quirky", musiccaps_names contains "Music" and musiccaps_names contains "Musical instrument"

✎ 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
Zappa Plays Zappa - Inca Roads (Part I) 70's jazz fusion featuring an eccentric male singer accompanied by drum kit, electric bass, electric piano and mallet percussion all playing odd meters and complex rhythms and staccato band hits. The music is quirky and complicated and features a drum fill. 2008-11-25T17:35:19Z IGotVirus Don't worry, I didn't cut the Dweezil solo ;) ["Singing", "Guitar", "Music", "Musical instrument", "Ska", "Plucked string instrument"] ["quirky", "complicated", "eccentric male vocalist", "staccato band hits", "drum fill", "jazz fusion", "70's", "odd meter", "complex rhythms", "electric piano", "drums", "electric bass", "mallet percussion"] 8 7IndxxjZe1c 826
Theremin Cover of "Edelweiss" The music features no vocals and the main melody is made with a theremin. The sound is wobbly and quirky. In the background there are subtle strings that contrast the main melody by sustaining chords. This is a song you could hear in a movie about aliens. 2009-02-09T03:31:03Z Terry Barbre This is me covering the tune "Edelweiss" from the musical "The Sound of Music." I'm playing the theremin. I'm "hand-syncing" on the video as any theremin player could tell since I'm too close to the computer and furniture. I sequenced all the background parts on my Mac, and then took the best of about 15 takes with the theremin. Cut me some slack. I've been a thereminist for about 48 hours. Once I get better I'll post more videos. ["Music", "Musical instrument", "Theremin"] ["instrumental", "no vocals", "theremin", "wobbly", "subtle strings", "quirky", "dreamy"] 5 JP637fg_ZC0 2001

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;