musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- electric guitar melody · 3 ✖
- energetic · 3 ✖
- low quality 3
- shimmering hi hats · 3 ✖
- addictive 2
- groovy 2
- groovy bass 2
- pop 2
- punchy snare 2
- brass melody 1
- claps 1
- crowd cheering 1
- crowd clapping 1
- crowd talking sounds 1
- exciting 1
- groovy synth bass 1
- happy 1
- harmonizing female vocal 1
- harmonizing male vocals 1
- live performance 1
- mellow kick hits 1
- noisy 1
- passionate female lead vocal 1
- passionate female vocal 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- rock 1
- short groovy synth keys chords 1
- uptempo acoustic rhythm guitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 | |
"Same Heart" - Bella Thorne & Zendaya [OFFICIAL FULL] (Lyrics Video) HQ | The low quality recording features a pop song that consists a passionate female lead vocal, alongside harmonizing female vocal, singing over groovy synth bas, claps, shimmering hi hats, punchy "4 on the floor" kick pattern, electric guitar melody and short groovy synth keys chords. It sounds energetic, groovy and addictive. The recording is noisy. | 2012-08-08T23:07:02Z | BellaDisneyLyrics | Song: Same Heart Artist: Zendaya ft.Bella Thorne Album: Shake It Up: Made In Japan | ["Disco"] | ["low quality", "pop", "groovy synth bass", "passionate female lead vocal", "harmonizing female vocal", "claps", "shimmering hi hats", "punchy \"4 on the floor\" kick pattern", "electric guitar melody", "short groovy synth keys chords", "energetic", "groovy", "addictive", "noisy"] | 4 | ojdqgnmcgYM | 4654 | |
2014 REWIND Meet & Greet Highlights | The low quality recording features a rock song that consists of a passionate female vocal singing over shimmering hi hats, punchy snare, mellow kick hits, uptempo acoustic rhythm guitar, groovy bass and some crowd talking sounds in the background. It sounds energetic, happy and addictive. | 2014-12-27T20:59:50Z | How To Cook That | Subscribe: http://bit.ly/H2CThat Recipe: http://howtocookthat.net How To Cook That Channel: http://youtube.com/howtocookthat ❤️Support on patreon: https://patreon.com/h2ct ❤️merch: https://youtube.com/howtocookthat/store Hi I am Ann, How to Cook Join me for creative cakes, chocolate & desserts. New video every Friday. SUBSCRIBE ( http://bit.ly/H2CThat ) for step by step tutorials for yummy desserts, sweet macarons, cupcakes, chocolate and cake decorating. Recipe details: http://www.howtocookthat.net SUBSCRIBE on youtube : http://bit.ly/H2CThat SUBSCRIBE for EMAIL updates: http://bit.ly/H2CTemail MEET & GREET VOLUNTEERS: Mandy Andrews insta: http://goo.gl/mgn5c2 Brendan Andrews Mark Pedlow youtube: http://goo.gl/tAmgca Naomi Scesny youtube: http://goo.gl/g4XGGu Mickey insta: http://goo.gl/MlWqb4 David Reardon insta: http://goo.gl/bspEfY My Kids youtube: http://goo.gl/ehwKkl THUMBNAIL: polymer clay cakes by Priscilla H a subscriber since Jan 2013 Youtube Channel: http://youtube.com/howtocookthat Google Plus: http://google.com/+Howtocookthat Facebook: https://www.facebook.com/howtocookthat Twitter: https://twitter.com/howtocookthat Instagram: http://instagram.com/howtocookthat Pinterest: http://www.pinterest.com/howtocookthat/ More videos by Ann: CHOCOLATE TUTORIALS: http://goo.gl/xFznw DESSERT RECIPES: http://goo.gl/fSr1u CAKE DECORATING LESSONS: http://goo.gl/1RyOh MACARONS & CAKE POPS: http://goo.gl/GzdXl Business enquiries only: howtocookthat [at] iinet.net.au MUSIC BY: SET SAIL used with permission, check out their other songs on iTunes... https://itunes.apple.com/au/artist/set-sail/id388088498?uo=4&at=11lsF8 SEND MAIL TO: Ann Reardon PO Box 202 Chirnside Park LPO Australia 3116 | ["Independent music"] | ["low quality", "rock", "passionate female vocal", "shimmering hi hats", "punchy snare", "uptempo acoustic rhythm guitar", "electric guitar melody", "groovy bass", "crowd talking sounds", "mellow kick hits", "happy", "addictive", "energetic"] | 4 | t8SLY7xn7Sc | 5009 |
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;