musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- happy · 2 ✖
- punchy snare · 2 ✖
- addictive 1
- christmas song 1
- crowd talking sounds 1
- electric guitar melody 1
- energetic 1
- energetic crash cymbals 1
- euphoric 1
- groovy bass 1
- groovy bass guitar 1
- harmonized vocals 1
- low quality 1
- mellow kick hits 1
- nostalgic 1
- passionate female vocal 1
- pop 1
- rock 1
- shimmering hi hats 1
- short drum break 1
- soft kick hits 1
- uptempo acoustic rhythm guitar 1
- wide electric guitars melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TOKIO - ding-dong KARAOKE | The Pop song features harmonizing vocals singing over energetic crash cymbals, groovy bass guitar, wide electric guitar melody, punchy snare and soft kick hits. There is a short drum break at the very beginning of the loop. It sounds happy, nostalgic and euphoric, as it gives off vibes of a Christmas song. | 2015-12-24T09:53:22Z | Sandra B | Merry Christmas! My Christmas gift to the TOKIO-fan community is here. Thank you so much for being so welcoming even if I'm a bit late to the party. I am so glad I was able to finish this on time and I hope you like it. For those who don't know this was the first pv Mabo directed (and I really wish he still was because they are absolutely adorable). Music by: TOKIO Song: ding-dong Edited by: Sandra Bergholm Lyrics credit: JpopAsia (http://www.jpopasia.com/lyrics/15166/tokio/ding-dong.html) Program: Vegas Pro 12.0 Please note that I make no claim to the music or video footage. I only claim to be responsible for the editing and I do not or will ever make money off this video. | ["Music", "Independent music"] | ["harmonized vocals", "pop", "energetic crash cymbals", "short drum break", "groovy bass guitar", "wide electric guitars melody", "punchy snare", "soft kick hits", "happy", "nostalgic", "euphoric", "christmas song"] | 4 | _3OlK_1yQOk | 3440 | |
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;