musiccaps_details (view)
4 rows where musiccaps_aspects contains "conductor", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "movie soundtrack" and musiccaps_aspects contains "philharmonic orchestra"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Jingle All the Way OST 18. Turbo Tom Marching Band #2 | The song is an instrumental song. The song is medium tempo with a marching drum rhythm, string section harmony, brass instruments playing and a horn section playing various harmonies. The song is exciting and adventurous in nature. The song is a movie soundtrack, and the audio quality is quite poor. | 2011-08-21T20:50:43Z | 1991Nukem | All rights go to 20th Century Fox & 1492 Pictures. | ["Theme music", "Music"] | ["movie soundtrack", "poor audio quality", "instrumental music", "trumpets playing", "soaring harmonies", "conductor", "santa claus", "christmas presents", "opera hall", "philharmonic orchestra", "string section", "solo violin", "trumelts playing", "medium tempo", "marching rhythm", "exciting", "adventurous", "christmas song", "horn section", "brass instruments playing triumphantly"] | 1 | JHkcCXF5vII | 1986 | |
Diva Song (Blood Plus) | A female opera singer sings this climatic high pitched finish. The song is medium tempo with a string section accompaniment and a rhythm Section. The song is dramatic and high on adrenaline. The audio quality is very poor. | 2008-09-23T15:24:36Z | Lagaczaka | Divas Song -+-+- great anime with best story Queen of the Chiropteran and her Aria... | ["Music", "Opera", "Classical music"] | ["female singer", "opera singer", "opera hall", "rhythm section", "philharmonic orchestra", "poor audio quality", "composer", "conductor", "operatic theme", "high pitched vocals", "bad audio quality", "song ending", "dramatic finish", "building tension", "climactic", "string section crescendo", "movie soundtrack", "medium tempo"] | 1 | X2gHQb5ubco | 3160 | |
Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 | |
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;