musiccaps_details (view)
1 row where musiccaps_aspects contains "intro", musiccaps_aspects contains "synth keys" and "youtube_published" is on date 2014-10-01
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 |
---|---|---|---|---|---|---|---|---|---|---|
Nasty Nasty (네스티네스티) - KNOCK (노크) [DANCE COVER] ft. East2West (E2W)'s Scott, Ruisha & David | The low quality recording features a pop song that consists of an echoing electric guitar melody, followed by really bad samples of knocking and door opening sound effects. At the end of the loop the synth keys and smooth synth bass appear. It sounds like an intro section of a song. | 2014-10-01T01:08:09Z | The It Girls Official | Follow us on all our social networks! Facebook: https://www.facebook.com/pages/The-It-Girls/130299027113164?ref=hl Instagram: http://instagram.com/theitgirlsofficial Weibo: http://www.weibo.com/theitgirlsoffical Here is the dance cover of Nasty Nasty's Knock. This time, we invited three talented dancers from East2West (E2W) to collaborate with us; Scott Tin, Ruisha Yuan and David Lieu. We hope you will like it, and leave a comment to tell us your feedback. Our next cover video will be up soon so stay tuned for other great dances. Don't forget to subscribe to our Channel! Thank you!! Video edited by: Lee Kim Anh | ["Music", "Knock"] | ["echoing electric guitar melody", "low quality", "knocking", "door opening sound effect", "synth keys", "pop", "smooth synth bass", "intro"] | 4 | WNv-YNn1cZ8 | 3090 |
Advanced export
JSON shape: default, array, newline-delimited
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;