musiccaps_details (view)
1 row where musiccaps_names contains "Hip hop music" and youtube_description = "once upon a time we saw snow and got crazy, and wanted to do somthing. and then i glanced on my new saab CONVERTIBLE (DREAM CAR) AND START SKIDING .when we say on our mobile it looked cool to us ."
This data as json, CSV (advanced)
Suggested facets: musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
One Car In Evington Leicester Snow Skidding | The song is a hip hop song with a violin motif playing the most prominent role in the instrumental. The drum beat is a simple boom bap beat. The rapper has a raspy voice and he sounds emboldened regarding his message. The violin riff is repeated throughout the song. | 2009-02-02T01:52:57Z | farooq007 | once upon a time we saw snow and got crazy, and wanted to do somthing. and then i glanced on my new saab CONVERTIBLE (DREAM CAR) AND START SKIDING .when we say on our mobile it looked cool to us . | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "hip hop drum beat", "string instrument", "violin", "violin riff", "string motif", "raspy rap vocal", "gangsta rap"] | 3 | kX5bTiq5eBo | 4326 |
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;