musiccaps_details (view)
1 row where musiccaps_aspects contains "building anticipation", musiccaps_aspects contains "timpani playing loud" and musiccaps_names contains "Scary 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 |
---|---|---|---|---|---|---|---|---|---|---|
Batman: The Animated Series Opening Theme | High-Def Makeovers #4 | The track is instrumental. The tempo changes building suspense, violins trilling, string section harmony, brass section plays percussively and piano plays suspenseful notes. This is a movie soundtrack. The audio quality is average. | 2011-12-04T22:52:09Z | Happy Dragon Pictures | The opening to Batman: The Animated Series is perfect Batman, simple as that. The show never even needed a title - you knew what you were about to watch based solely on this theme. So, here we have my HD remake of the opening to Batman: The Animated Series. Animated from scratch by David A. Rose. Visit our official website: http://happydragonpictures.com Like our Facebook page: http://facebook.com/happydragonpictures Follow me on Twitter: http://twitter.com/happydragondave | ["Music", "Scary music"] | ["movie soundtrack", "violins trilling", "philharmonic orchestra", "energetic", "emotional", "noir fantasy", "horn section", "instrumental music", "tempo changes", "scene changes", "animated movie track", "brass section", "conductor", "mysterious", "timpani playing loud", "piano plays suspenseful", "scary", "eerie", "building anticipation", "medium tempo", "tempo increases"] | 1 | v5nB2OJnCko | 5155 |
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;