musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "playful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- energetic · 2 ✖
- playful · 2 ✖
- acoustic drums 1
- bass 1
- bass guitar 1
- childlike 1
- dance music 1
- electric guitar 1
- electronic drums 1
- flamboyant singing 1
- groovy 1
- hip 1
- hip-hop 1
- instrumental 1
- joyful 1
- keyboard 1
- kids show theme 1
- lively 1
- male vocal 1
- no singer 1
- shuffle 1
- sound effects 1
- urban 1
musiccaps_names (array) 4 ✖
- Music 2
- Hip hop music 1
- Rapping 1
- Timpani 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 | |
Hip Hop Academy Sid Shuffle | This is a hip-hop dance music piece. There is a male vocalist who is singing in a flamboyant manner. There is an electric guitar playing the melody joined by a strong bass sound. There is a groovy, urban atmosphere. This piece can be used as an accompaniment piece in modern dancing courses. | 2013-09-15T18:15:10Z | HipHopAcademy08 | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "dance music", "shuffle", "male vocal", "flamboyant singing", "electric guitar", "bass", "electronic drums", "playful", "groovy", "hip", "urban", "energetic"] | 9 | V9EFYFKlYbE | 2976 |
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;