musiccaps_details (view)
1 row where musiccaps_aspects contains "boomy bass drum", musiccaps_aspects contains "loud", musiccaps_names contains "Music" and musiccaps_names contains "Timpani"
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 |
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;