musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "strings" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
[NEW] All SNSD Music Videos 2007-2014 (OFFICIAL) | The pop music features a female voice singing and being accompanied by other female voices. The drums and bass guitar play a simple and repetitive groove and drive the pulsation of the music. An electric guitar is playing a funky accompaniment. A group of strings play a repetitive melody that ascends in pitch with each repetition. | 2014-12-07T18:59:58Z | soshistars | This is all the Music Videos SNSD has made from 2007 to 2014! Lets hope they make more in the future! Thanks for watching please like, comment, share & SUBSCRIBE! (if you havent already!) New Videos Every week of Kpop girl groups (especially SNSD) and SM boy groups! | ["Music", "Dance music", "Happy music"] | ["female voice", "female backing vocals", "drums", "bass guitar", "strings", "electric guitar", "pop genreș"] | 2 | 32C6w8V7TX8 | 435 | |
Say it Again - Don Williams | The country music features a male voice singing while being backed by female vocals. The drums play a simple and repeating rhythm and together with the bass guitar drive the pulse of the music. An electric guitar plays short repeating musical phrases that incorporate the slide technique. In the background a group of strings fills the harmony and also provides a melody in the higher register. | 2009-12-26T16:37:25Z | WhatchaNeed23 | Say it Again Don Williams Harmony 1976 ABC Records | ["Swing music", "Music"] | ["male voice", "female backing vocals", "electric guitar", "drums", "bass guitar", "strings", "slide technique", "country genre"] | 2 | VJ-dpTx_3Cg | 2989 |
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;