musiccaps_details (view)
3 rows where musiccaps_aspects contains "no singer" and musiccaps_aspects contains "synth bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- electronic drums 3
- no singer · 3 ✖
- synth bass · 3 ✖
- generic 2
- instrumental 2
- action-filled 1
- aggressive 1
- brass section 1
- common 1
- electric guitar 1
- energetic 1
- groovy 1
- industrial sounding 1
- instructive recording 1
- jingle 1
- medium tempo 1
- movie music 1
- ping sound effect 1
- pop 1
- repeated theme 1
- russian hardbass 1
- scissor sharpener 1
- sound effects 1
- tv series theme 1
musiccaps_names (array) 7 ✖
- Music 3
- Drum and bass 1
- Dubstep 1
- Techno 1
- Theme music 1
- Trance music 1
- Zipper (clothing) 1
youtube_published (date) 3 ✖
- 2007-04-27 1
- 2012-02-01 1
- 2015-04-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
7 jours pour agir: generique | This is an opening theme for a TV series. It is an instrumental piece. The main theme is being played by a loud brass section. There is a groovy synth bass line playing. The rhythmic background consists of a strong electronic drum beat. The atmosphere is energetic. This piece could be used in lifting samples for beat-making. | 2007-04-27T16:05:45Z | nanardu88 | je trouve pas d'épisode! | ["Theme music", "Music"] | ["tv series theme", "no singer", "instrumental", "brass section", "synth bass", "electronic drums", "sound effects", "generic", "action-filled", "energetic", "movie music"] | 9 | LCzldLY3E4g | 2164 | |
How to Fix a Stuck Zipper | This is a pop-sounding jingle at the background of an instructive video. There is an electric guitar playing the main theme while the bass line is being played by a synth bass. In the rhythmic background, a very basic 4/4 beat is being played on the electronic drums. A ping sound effect signifies the end of the instruction in the video. The atmosphere is very generic and common-sounding. This piece could be used as a jingle in advertisements and tutorial videos. | 2015-04-21T13:11:53Z | Myntra | Here is how to fix a stuck zipper. Zipper got stuck or Zipper comes separated. No problem, This "fix a zipper" trick will work on list of items ranging from a jeans, dress to jacket and backpack. Well, this kinda things can be done on your own using this quick fix tip... by yourself by some simple household items. Zipper got stuck or Zipper comes separated. No problem, Here is how to fix a stuck zipper.This "fix a zipper" trick will work on list of items ranging from a jeans, dress to jacket and backpack. Well, this kinda things can be done on your own using this quick fix tip... by yourself by some simple household items. Things you need: 1. Wax/Candle 2. Pencil 3. Lip balm Try these really simple fixing tips: Tip 1: Apply wax/candle gently on both sides of the zipper for lubrication. Tip 2: Do the same with the pencil and you can also use lip balm, soap, coconut oil to the zipper with with some cotton. Tip 3: It's the most important... Don't ever... ever... ever force the zipper when it stuck. There's a high chances of breaking it and ruin the clothing. Tadaa! Done with zero tailoring and garment alteration knowledge. Have Time? Read the article: http://fashion.myntra.com/2015/04/30/how-to-fix-stuck-zipper-with-zero-tailoring-knowledge/ Related Zipper Problem Solved: 1. How to fix a loose zipper? - https://www.youtube.com/watch?v=28f_0T3c4_4 Subscribe us if you like this video: https://www.youtube.com/channel/UCMlJjMRSKaUQhXQ_9XjCGpg?sub_confirmation=1 DIY Tutorials: https://www.youtube.com/playlist?list=PLsmwfwtNVyU-Rcr2lswfh608tUYpn0tHB Let's Connect Facebook: https://facebook.com/myntra Twitter: https://twitter.com/myntra Google+: https://plus.google.com/+myntra | ["Zipper (clothing)", "Music"] | ["pop", "jingle", "no singer", "instrumental", "electric guitar", "synth bass", "electronic drums", "ping sound effect", "generic", "common", "groovy", "medium tempo"] | 9 | Zlbo8ygfPSM | 3410 | |
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;