musiccaps_details (view)

1 row where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "pop", musiccaps_aspects contains "synthesizer bit sound" and "youtube_published" is on date 2011-05-01

✎ 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
Sita's Fire from Sita Sings the Blues - Music by Egemen Sanli This song has some experimental sounds. The string instrument sounds processed and slightly oriental. The synth plucks sound as running through different effects that are changing the bit rate and some filters. These elements are panned to the right and left and right side of the speakers playing different melodies. An acoustic drum is holding the whole construct together while an e-bass is playing his own run along with the drums. An e-guitar is playing long single chords. This song may be playing in an adventurous indie-videogame. 2011-05-01T11:51:25Z Egemen Sanli This is a derivative work of Nina Paley's inspiring animation "Sita Sings the Blues" Ms. Paley is a revolutionary artist who advocates copyleft licences and free culture movement. The free culture movement is a social movement that promotes the freedom to distribute and modify creative works in the form of free content by using the Internet and other forms of media. This is my take on a part of her amazing work. I was truly inspired by this story and I had to do something about it. To watch the whole movie: http://www.sitasingstheblues.com/ Listen on Spotify: https://open.spotify.com/artist/39Hxxiq33beoXGP8uKjbXi Listen on iTunes: https://itunes.apple.com/us/artist/egemen-sanli/356530309 https://egemensanli.com/ https://www.facebook.com/turksitar/ https://soundcloud.com/egesan/ https://www.instagram.com/egesan/ ["Music", "Psychedelic rock"] ["pop", "oriental sounding string instrument", "synthesizer bit sound", "e-guitar", "acoustic drums", "experimental", "medium tempo", "happy", "light sounding"] 6 PeQ8L_svYcU 2552

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;