musiccaps_details (view)

1 row where musiccaps_aspects contains "clapping hands effect", musiccaps_author = 3 and musiccaps_names contains "Exciting 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
GENER8ION + M.I.A. - The New International Sound Pt. II (Official music video) The song has a futuristic kind of feel. It's a synth pop song with a female vocalist who has a robotic filter and autotune applied to her voice. The feel of the song is sort of epic and progressive. It's action-oriented and feels like something cool is about to happen. 2015-06-15T15:01:51Z Bromance Records GENER8ION is a new multi-disciplinary project by Surkin. Full ep available on iTunes: http://apple.co/1IXt04d --- Directed by Inigo Westmeier and featuring the 36 000 students of Shaolin Tagou, the biggest fighting school for kids in China. Directed by Inigo Westmeier Edited by Walter Mauriot Creative direction by Ben Surkin Produced by Bromance Records. Executive production by Romain Gavras and Iconoclast. Adapted From “Dragon Girls” produced by Open Window Film & Gap Films. Identity by David Rudnick --- Full ep available here: iTunes: http://apple.co/1IXt04d Spotify: http://bit.ly/1Shq9V5 Deezer: http://www.deezer.com/album//10490622 --- SOCIALS: http://bromancerecords.com http://gener8ion.org // http://www.facebook.com/gener8ionofficial --- LYRICS: Mia you can wiki me I don't be no dummenee Dumbing me is killing me Like it can be that enemy They come at me They gonna meet my people gonna cover me The ones that govern me Ain't the ones that can power me It's the sun and moon that's turning me If I get high it's burning me You can kill my privacy But you can't kill that love in me. It's a game can't me tamed Keep your fame and I'll keep my faith Oh yeah you can keep it Store my name say my name Know my name And I'll keep my faith Oh yeah you can keep it Light it up, turn em on, that’s when my powers gone, gonna keep it, I take em off, turn em off, and my powers on. ["Music", "Exciting music"] ["futuristic synth pop", "female pop vocal", "filtered pop vocal", "robotic vocal filter", "autotuned female vocal", "fast paced bass synth", "clapping hands effect"] 3 uAYPacrJnyQ 5095

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;