musiccaps_details (view)
6 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "sound effects"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- acoustic drums · 6 ✖
- bass guitar · 6 ✖
- sound effects · 6 ✖
- electric guitar 5
- energetic 2
- generic 2
- jingle 2
- keyboard 2
- male vocal 2
- melodic singing 2
- no singer 2
- normal tempo 2
- playful 2
- breath 1
- cheerful 1
- chewing 1
- childlike 1
- easygoing 1
- explosions 1
- female vocal 1
- funky 1
- instrumental 1
- instrumental rock 1
- jazz 1
- jovial 1
- joyful 1
- kids show theme 1
- kids song 1
- lion roaring 1
- lively 1
- mild 1
- playful singing 1
- pop funk 1
- pop punk 1
- robotic voice 1
- rock music 1
- simple theme 1
- squeaking 1
- stamp 1
- thai 1
- trumpet 1
- xylophone 1
- zipper 1
musiccaps_names (array) 10 ✖
- Music 6
- Independent music 2
- Heart murmur 1
- Heavy metal 1
- Oink 1
- Pop music 1
- Progressive rock 1
- Tick-tock 1
- Timpani 1
- Zipper (clothing) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kids Shows in Australia in the 1990s & Early 2000s - Part 1 | This is the opening theme of a program that was meant for kids. It is in an instrumental piece. There is a keyboard playing the main melody in the lead. There is a bass guitar playing in the background. The rhythm is provided by a fast-tempo acoustic drum beat. There are various sound effects that add a lively texture to this piece. The atmosphere is playful. This piece could be used in kids shows or cartoons. It could also be played during kindergarten activities or child birthday parties. | 2013-04-25T13:23:22Z | Allen Douangchak | I was inspired to make this video after watching '90's Epic ABC Compilation' by Morryjnr. A collection of kid shows that aired in Australia in the 1990s and early 2000s. These are mostly from ABC Kids and Channel Ten. Includes: Art Attack Babar Captain Planet and the Planeteers Fireman Sam Madeline Pingu Postman Pat Round The Twist Sesame Street Spot The Simpsons Thomas and Friends Are You Afraid Of The Dark? Dinosaurs Johnson and Friends Rugrats Social media links: Facebook: http://www.facebook.com/profile.php?id=1012716251 Twitter: https://twitter.com/AllenDouangchak Instagram: https://www.instagram.com/allendouangchak/?hl=en Patreon: https://www.patreon.com/adouangchak | ["Timpani", "Music"] | ["kids show theme", "no singer", "instrumental", "keyboard", "bass guitar", "acoustic drums", "sound effects", "playful", "joyful", "energetic", "lively", "childlike"] | 9 | AAWe4zRLVVU | 1077 | |
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
SkylanderDude VS the big green fat pig angry birds space | This is a jazz piece played in the background of a video game. A trumpet plays the main melody while a xylophone and a bass guitar is supporting the tune in the background. A playful jazz drum beat carries the rhythmic background. Occasional electric guitar fills in the form a strum can be heard. There are a lot of sound effects related to the game such as squeaking, chewing and explosions. | 2012-07-30T19:33:03Z | SkylanderDudeFilms | ewww. over cooked popcorn | ["Music", "Oink"] | ["jazz", "trumpet", "acoustic drums", "xylophone", "electric guitar", "bass guitar", "sound effects", "squeaking", "chewing", "explosions", "playful", "jovial"] | 9 | BkOfrw3c3EE | 1284 | |
Cornetto Love Stories - Cut desktop Trailer eng | This is a pop funk piece used as a jingle for an ad. There is a male vocalist singing melodically while the electric guitar is playing a catchy tune with the bass guitar playing a groovy bass line. A normal tempo acoustic drum beat provides the rhythmic background. There are a couple of sound effects in the end. The piece has an easygoing atmosphere. It is the perfect match for a jingle. It could also be used in DJ sets or remixes. | 2015-07-03T10:38:53Z | Cornetto Netherlands | ["Heart murmur", "Music"] | ["pop funk", "jingle", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "funky", "easygoing", "normal tempo", "sound effects", "breath", "stamp", "generic", "easygoing"] | 9 | H6qzijVEqZQ | 1775 | ||
Descubre como las Bolsas Zipper de Albal pueden facilitarte la vida con su cierre Zzzzip | This is an instrumental rock piece which is a jingle for an ad. There is a clean electric guitar and a high-pitched keyboard playing the main melody. There is a mild bass guitar in the background supporting the melody. In the rhythmic background, there is a rock beat being played by the acoustic drums. A zipper sound effect can be heard synchronized with the ad. The atmosphere is very generic and calm. It is most suitable as an ad jingle or music behind a tutorial video. | 2014-09-24T11:01:18Z | Albal | Las Bolsas Zipper de Albal permiten conservar, congelar y transportar cualquier tipo de alimento fresco o cocinado con total seguridad. No se sale y se puede llevar a cualquier sitio. | ["Zipper (clothing)", "Music"] | ["instrumental rock", "no singer", "jingle", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "sound effects", "zipper", "generic", "mild"] | 9 | M4yst1q1nlU | 2241 | |
Animal Songs: "You Gotta Love a Lion," by StoryBots | Netflix Jr | This is a kids song in the style of pop punk. There is a male vocalist singing in a playful manner. It is joined occasionally by a robotic voice and the roars of a lion. The electric guitar and the bass guitar are playing a simple theme. The rhythmic background consists of a fast tempo acoustic drum beat. The atmosphere is cheerful. It could go well in the soundtrack of a kids show. | 2014-02-24T22:56:23Z | Netflix Jr. | As soon as you hear this wild, wacky song about the king of beasts, you've gotta love it! The StoryBots are curious little creatures who live beneath our screens, offering a world of learning and fun for kids. The Emmy Award-winning “Ask the StoryBots” is now streaming on Netflix! LYRICS: You gotta love a lion You gotta love a lion He roars a happy tune Then he sleeps all afternoon You gotta love a lion You gotta love a lion His tail has a tuft and His mane is always fluffed You know you can't stop smiling Cause that lion's just so stylin' There really is no denying That you gotta love a lion You gotta love a lion You gotta love a lion His claws are kind of sharp so Don't let him play your harp You gotta love a lion You gotta love a lion They say that he's the king Just listen to him sing Ra-roar-roar-roar-roar-roar Ra-roar-roar-roar-roar-roar Ra-roar-roar-roar-roar-roar Ra-roar-roar-roar-roar-roar You know you can't stop smiling Cause that lion's just so stylin' There really is no denying That you gotta love a lion Roar-roar-roar-roar-roar-roar-roar You gotta love a lion! | ["Music", "Independent music"] | ["kids song", "pop punk", "male vocal", "playful singing", "electric guitar", "simple theme", "bass guitar", "acoustic drums", "sound effects", "robotic voice", "lion roaring", "cheerful"] | 9 | bVtHAk5w2Z8 | 3631 |
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;