musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- bass guitar · 3 ✖
- energetic · 3 ✖
- instrumental · 3 ✖
- acoustic drums 2
- no singer 2
- aggressive 1
- bebop jazz 1
- childlike 1
- complex 1
- distorted electric guitar 1
- dub 1
- fast tempo 1
- improvisation 1
- joyful 1
- keyboard 1
- kids show theme 1
- lively 1
- loud acoustic drums 1
- organ 1
- playful 1
- poor quality 1
- punk rock 1
- solo 1
- sound effects 1
- violent 1
musiccaps_names (array) 16 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Electric piano 1
- Hammond organ 1
- Hi-hat 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Percussion 1
- Piano 1
- Rimshot 1
- Snare drum 1
- Timpani 1
youtube_published (date) 3 ✖
- 2006-05-02 1
- 2007-10-17 1
- 2013-04-25 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 | |
Cory henry | This is the poor quality recording of a bebop jazz music performance. The organ is playing an insanely complex improvised solo. In the background, there is a bass guitar and a jazz acoustic drum beat. The atmosphere is energetic. | 2007-10-17T20:56:15Z | joeydkeys | Cory killin donna lee | ["Organ", "Electric piano", "Hammond organ", "Keyboard (musical)", "Piano"] | ["poor quality", "no singer", "instrumental", "bebop jazz", "organ", "solo", "improvisation", "bass guitar", "acoustic drums", "energetic", "complex"] | 9 | GWxiiDBK5s8 | 1731 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 |
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;