musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "generic" and musiccaps_aspects contains "instrumental" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- electric guitar 3
- generic · 3 ✖
- instrumental · 3 ✖
- jingle 2
- no singer 2
- acoustic guitar 1
- acoustic sounding drums 1
- advertisement 1
- bass guitar 1
- common 1
- drill sounds 1
- electronic drums 1
- groovy 1
- harp 1
- joyful 1
- keyboard 1
- medium tempo 1
- ping sound effect 1
- pop 1
- pop-rock 1
- positive 1
- rock music 1
- simple tune 1
- synth bass 1
- ukulele 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
電鑽佬-Bosch GSB 1080-2-LI 充電式鋰電電批 (可鑽牆身) | This is a jingle piece played in the background of an advertisement video. There are sounds coming from a drill. The piece in the background is an instrumental rock music piece. There is a keyboard and an electric guitar playing the melody while an acoustic sounding drum beat provides the rhythm. The sounds are bland and generic. The piece could be of some use as an advertisement jingle or it could be playing in the background of an instructive/tutorial video. | 2015-07-19T10:59:44Z | 電鑽佬 | 可到以下網址購買 https://hk.user.auctions.yahoo.com/hk/booth/wing1213142003 | ["Music", "Dental drill, dentist's drill"] | ["advertisement", "jingle", "drill sounds", "rock music", "instrumental", "electric guitar", "keyboard", "acoustic sounding drums", "generic", "simple tune"] | 9 | 0dPx94RPy2M | 193 | |
❤ My Morning Routine ❤ | This is an instrumental pop-rock piece. There is a harp playing the main melody while a ukulele is strumming chords. An electric guitar and a bass guitar join the melodic background later on. A simple acoustic drum beat is in the rhythmic background. It has a joyful aura, but the sounds used are very generic. The best use for this piece could be the background of a tutorial/instructive type of video. | 2013-03-28T02:56:49Z | Ashley Love | My morning routine is finally up! Enjoy :) Thanks for watching. Subscribe to make my day. Instagram: Ashley_Tan13 Twitter: AshleyLovesx My previous video: http://www.youtube.com/watch?v=IlYuPAAD7AI Ask me questions here: http://www.spillit.me/ashleylovesx Subscribe to my friend(Mark O'dea), he is an amazing singer!! Check him out :) http://www.youtube.com/user/markodea/videos?view=0 Love, Ashley | ["Music", "Ukulele"] | ["pop-rock", "no singer", "instrumental", "ukulele", "harp", "electric guitar", "bass guitar", "acoustic guitar", "generic", "joyful", "positive"] | 9 | Mwy5Y0S5jfM | 2311 | |
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 |
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;