musiccaps_details (view)
2 rows where musiccaps_aspects contains "joyful", musiccaps_aspects contains "lively", musiccaps_aspects contains "no singer" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 | |
Seán McKeon, Conor McEvoy, John Blake - Traditional Irish Music from LiveTrad.com | This is an Irish folk music piece. There is no singer. The main melody is being played by the uilleann pipes and the fiddle at a high pitch. The acoustic guitar is playing a rapid procession of chords in the background. The atmosphere is lively. This piece could be playing in the background at an Irish pub. It could also be used in the soundtracks of movies and TV shows that have a theme with an Irish influence. | 2012-02-17T12:56:44Z | Livetrad | http://www.livetrad.com Performing a number of reels during a benefit concert for 'Aid Japan for Children', a group working with survivors of the earthquake and tsunami in Japan in 2011. This video was recorded by Martin Moylan at St. Anne's Church on Dawson St., Dublin 2 and we're delighted to add it to the LiveTrad YouTube channel. For more info see 'Aid Japan for Children' on Facebook. | ["Banjo", "Traditional music", "Music", "Bluegrass"] | ["irish folk music", "no singer", "instrumental", "uilleann pipes", "fiddle", "acoustic guitar", "vibrant", "joyful", "lively", "steady tempo"] | 9 | NwA9JSlK_lM | 2378 |
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;