musiccaps_details (view)
3 rows where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "synth bass" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- aggressive · 3 ✖
- synth bass · 3 ✖
- electronic drums 2
- loud 2
- box opening 1
- cutting sound 1
- dramatic 1
- dubstep 1
- electronic 1
- energetic 1
- fast-paced 1
- glass shatter 1
- ice break 1
- industrial sounding 1
- instructive recording 1
- no singer 1
- repeated theme 1
- russian hardbass 1
- scissor sharpener 1
- sound effects 1
- violent 1
musiccaps_names (array) 8 ✖
- Music 3
- Drum and bass 1
- Dubstep 1
- Glass 1
- Shatter 1
- Squish 1
- Techno 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 |
---|---|---|---|---|---|---|---|---|---|---|
Glass Shatter and ice break Intro on After effects & 3ds Max | These are various sound effects compiled into a track. There is an electronic music/dubstep influence on the sounds. A strong bass synth can be heard playing. The sounds of glass shattering and ice breaking were used to create a dramatic effect. The atmosphere of the track is aggressive. This track could be used as an opening theme to a gaming/sports/gym Youtube channel. Samples of this track could also be used in the sound effects of an action movie or a video game. It could also fit well in an advertisement targeted at a male audience. | 2014-08-26T19:12:58Z | GeoverProd | This Glass shatter and text transformation template was Made using After effects and 3ds Max, The plugins used were Rayfire and Element3D If you want something like this PM me here or contact me on facebook: https://www.facebook.com/G.Viper | ["Glass", "Music", "Shatter"] | ["electronic", "sound effects", "glass shatter", "ice break", "synth bass", "loud", "dramatic", "aggressive", "violent"] | 9 | 25RWrqQol7Y | 331 | |
Liquid cooling system unboxing (EK Water Blocks) | This is the recording of a box opening with a dubstep piece playing in the background. A knife cutting through the box can be heard. The track in the background has a loud synth bass and an aggressive electronic drum beat. It is a fast-paced piece. | 2011-04-28T19:17:56Z | IMIDefender | Music: Pendulum - Immersion album Liquid cooling: EK Water Blocks EK-Supreme HighFlow Universal - Nickle Acetal EK Water Blocks EK-VGA Supreme HighFlow - Nickel Acetal EK Water Blocks EK-CoolStream XT 360 Radiator - 360mm Fitings: 6x Bitspower 1/4" Matt Black Mini 13mm and 2x 1/4 for 12mm tube 3x Enermax T.B.SILENCE 120 mm - UCTB12 XSPC Laing DDC + TOP Laing DDC-1T Pump - 12 V Aqua Computer Shoggy Sandwich Antivibration Kit - rev2 Primochill PrimoFlex Pro LRT Clear Tubing - 16/11mm Thermochill EC-6 Cooling Fluid - 1L Clear AC Ryan RadGrillz Stripes 3x120mm Black NesteQ Fan Max 5.25" Controller - Alu Black | ["Music", "Squish"] | ["box opening", "cutting sound", "dubstep", "synth bass", "electronic drums", "loud", "energetic", "aggressive", "fast-paced"] | 9 | C25xvcl4YAU | 1320 | |
1. Кутикульные ножницы. Предварительная обработка | This is a Russian hardbass piece played in the background of a scissor sharpening video. The piece has a repeated theme being played by a synth bass while an electronic drum beat holds the rhythmic background. The atmosphere of the piece in the background is aggressive with industrial characteristics. | 2012-02-01T19:18:10Z | Виталий Бородин | Перед тем, как затачивать ножницы для кутикулы, их нужно подготовить - придать нужную форму полотнам. Этому и посвящено видео. | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["instructive recording", "scissor sharpener", "no singer", "russian hardbass", "synth bass", "electronic drums", "repeated theme", "aggressive", "industrial sounding"] | 9 | dIPW9gLGSx8 | 3774 |
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;