musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "orchestral", musiccaps_aspects contains "sustained strings" and musiccaps_names contains "French horn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
World of Warships - 1:42 Scale: Cruiser Varyag | The low quality recording features a short snippet of flat male vocal talking, while in the background an orchestral music is playing. The music contains sustained brass melody, wide huge percussion and sustained strings melody. It sounds powerful and epic. | 2016-01-27T14:26:16Z | Wargaming Europe | They are small, only 1:42 in scale compared to their real-life counterparts, but they have great stories to tell. New video in our series focuses on Russian cruiser Varyag. To keep up to date with our latest development, contests and events visit http://worldofwarships.eu/ Follow us on Facebook: http://www.facebook.com/worldofwarships Instagram: https://instagram.com/Wargaming_EU/ Vine: https://vine.co/Wargaming_EU Twitter: https://twitter.com/Wargaming_netEN https://twitter.com/Wargaming_netCZ https://twitter.com/Wargaming_netDE https://twitter.com/Wargaming_netES https://twitter.com/Wargaming_netFR https://twitter.com/Wargaming_netPL https://twitter.com/Wargaming_netTR | ["Brass instrument", "French horn"] | ["low quality", "orchestral", "sustained brass melody", "wide huge percussions", "sustained strings", "flat male vocal", "epic", "powerful"] | 4 | W4eLgBYEEqA | 3060 |
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;