musiccaps_details (view)
3 rows where musiccaps_aspects contains "loud", musiccaps_aspects contains "minimalist", musiccaps_aspects contains "powerful" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
12CH Super Fighter BlitzRCWorks | Flight Review (feat. John Asher) | EDF Fighter Jet | This music is instrumental. The tempo is fast with atmospheric synthesiser, percussions like a boomy bass drum, enthusiastic steel pan and snare. The music is loud, resounding,intense, sinister, grim, suspenseful, burgeoning and boomy. This is a Percussion Instrumental. | 2011-05-01T01:25:59Z | Banana Hobby | Order now at: http://www.bananahobby.com/12-ch-blitzrcworks-super-fighter-rc-edf-jet-arf.html Hey pilots! I am so excited to bring to you this flight review! Before we get started, I just want to say how disappointed I am to not be able to give you all more flying and more aggressive flying. You all know me for never holding back when it comes to wringing out an aircraft for a review! The winds on this day of the review were so strong, the F18 actually was blown upside down on the runway breaking many parts including the canopy mechanism. From that I did some quick repair and gave you guys and gals the best flying I could do with 30 plus knots of turbulent cross winds. No one was flying, but yours truly flew this for you. Keep an eye out for Part II coming real soon! I love this FA/18 and I can't wait to bring to you the next review! ~ Pete | ["Timpani", "Music"] | ["instrumental", "intense", "vigorous drumming", "percussion instrumental", "steel pan", "snare", "resounding", "rhythmic percussion", "snare", "minimalist", "boomy bass drum", "steel pan", "synthesiser arrangements", "sinister", "anticipation of danger", "scary", "fearful", "loud", "powerful"] | 7 | 3w4nFQrUQ8k | 522 | |
Boss DN-2 Dyna Drive Demo: Gear Up | This music is instrumental. The tempo is medium fast with an energetic electric guitar lead. The music is minimalist with no accompaniment. It is youthful, powerful, enthusiastic, controlled, engaging and intense. This music is Hard Rock/Heavy Metal. | 2012-05-03T16:21:42Z | gearuptmntv | Let your pick set the gain. The Dyna Drive by Boss is very responsive to pick attack. This allows you to lighten up your touch and the drive will clean up. This technology was borrowed from the Roland Cube-60. So if you want a responsive distortion pedal this might be the one for you. Gear Up Be Sure You Go To The Gear Up Channel For Past Episodes http://www.youtube.com/gearuptmntv If you want to request a piece of gear you want on the show just send me a message!!! Also Go Stop By The Musician Network Channel for Other Great Content. http://www.youtube.com/tmntv | ["Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["instrumental", "fast tempo", "electric guitar", "metal", "heavy metal", "hard rock", "amplified guitar", "external amplification", "minimalist", "youthful", "loud", "powerful", "lead", "stringed instrument", "rock", "heavy metal"] | 7 | 9QEm6u4bowQ | 1003 | |
Carnegie Hall Trombone Master Class: Wagner's Ride of the Valkyries | This music is instrumental. The tempo is slow with a dominant Trombone lead. The music is loud, powerful, emphatic , clear and rich. This music is a Western Classical Trombone instrumental. | 2013-02-23T00:17:31Z | Carnegie Hall | Berlin Philharmonic principal trombone player Thomas Leyendecker coaches Carson King-Fournier on Wagner's Ride of the Valkyries. http://carnegiehall.org/workshops Select members of the Berlin Philharmonic woodwind and brass sections led two days of master classes focusing on orchestral repertoire and audition preparation. Participating young artists attended panel discussions with the master class leaders and heard the Berlin Philharmonic in performance, led by Sir Simon Rattle, at Carnegie Hall. Trombone Master Class Participants: Carson King-Fournier Amanda Logue Christine Mounger Berlin Philharmonic Master Class playlist: http://www.youtube.com/playlist?list=PL6on-dqI0231Xk4-XW29ayYy723nQqvq4 Weill Music Institute playlist: http://www.youtube.com/playlist?list=PL8EAC02041AEBD782 Masterclasses playlist: http://www.youtube.com/playlist?list=PL6FD5F3A6181536B8 | ["Brass instrument", "Trombone"] | ["instrumental", "slow tempo", "trumpet", "brass instrument", "loud", "dominant", "emphatic", "clear", "rich", "exquisite", "concert", "orchestra", "classical", "western classical", "trombone", "wind instrument", "aerophone", "powerful", "strong", "minimalist", "trombone solo"] | 7 | NRWlHRvaDcQ | 2337 |
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;