musiccaps_details (view)
2 rows where musiccaps_aspects contains "loud", musiccaps_aspects contains "snare" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- loud · 2 ✖
- snare · 2 ✖
- anticipation of danger 1
- bass drum 1
- boomy bass drum 1
- club music 1
- digital drum 1
- dj 1
- droning sound 1
- electronic arrangements 1
- electronic music 1
- fearful 1
- hypnotic 1
- instrumental 1
- intense 1
- medium fast tempo 1
- minimalist 1
- monotone 1
- percussion instrumental 1
- powerful 1
- psychedelic 1
- resounding 1
- rhythmic percussion 1
- scary 1
- sharp 1
- sinister 1
- slick drumming 1
- steel pan 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- trance 1
- unpleasant droning sound 1
- vigorous drumming 1
musiccaps_names (array) 9 ✖
- Music 2
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Electronica 1
- Sampler 1
- Techno 1
- Timpani 1
- Trance music 1
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 | |
Tinnitus y sordera-Tinnitus and deafness | This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, digital drumming and an insistent, persistent ,and incessant electronic drone sound that over powers the background music. It is loud, sharp and unpleasant after a bit. | 2016-06-07T16:46:22Z | Remedios naturales Comenius | Si te gustó este vídeo ¡SUSCRÍBETE! Dale manita arriba para mucho mas vídeos como este, comparte con tus amigos y déjame tus comentarios. | ["Sampler", "Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Drum machine", "Electronica"] | ["electronic music", "medium fast tempo", "loud", "sharp", "unpleasant droning sound", "synthesiser arrangement", "slick drumming", "digital drum", "electronic arrangements", "droning sound", "monotone", "bass drum", "snare", "psychedelic", "trance", "hypnotic", "club music", "dj"] | 7 | XZurp_Ex9No | 3196 |
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;