musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- cheerful · 3 ✖
- groovy rhythm · 3 ✖
- steady drumming rhythm · 3 ✖
- instrumental music 2
- medium tempo 2
- positive 2
- advertisement jingle 1
- animated singing 1
- bass drum hits 1
- bouncy rhythm 1
- caribbean music 1
- children’s favourites 1
- children’s song 1
- clapping rhythm 1
- cool bass solo 1
- cool drum roll 1
- dance party 1
- disney movie 1
- documentary video soundtrack 1
- drum sticks 1
- emotional 1
- exciting 1
- funk pop music 1
- funky groove 1
- hand saw 1
- inspiring 1
- instrumental cover 1
- life is good 1
- male backup singers 1
- male singer 1
- memdium tempo 1
- motivational 1
- movie sound track 1
- people dancing 1
- percussionist 1
- percussive bass line 1
- playful 1
- poor audio quality 1
- pop anthem 1
- pop dance hits 1
- pop song 1
- reggae music influences 1
- sand and sea 1
- sawing noise 1
- screaming vocals 1
- soloist 1
- song cover 1
- steel drums 1
- strong bass line 1
- tom sounds 1
- tropical beach party 1
- video soundtrack’ toms sounds 1
- vocal harmony 1
musiccaps_names (array) 16 ✖
- Music 2
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Hi-hat 1
- Hip hop music 1
- Percussion 1
- Rhythm and blues 1
- Rimshot 1
- Rub 1
- Sawing 1
- Snare drum 1
- Steelpan 1
- Tools 1
- Wood 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hairless Dancing Nathan : "Cupid Shuffle" | A male singer sings this animated melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, clapping percussion and strong bass hits. The song is a pop dance hit with a groovy dance rhythm. | 2014-02-14T03:00:29Z | DancingNathan | Dancing Nathan is a hairless chinese crested who LOVES to chair dance. He was adopted from Bald is Beautiful Hairless & Small Breed Rescue and is quite a character. #dancingnathan #hotmessgilligan #hairlessdog #chinesecrested @dancenekkid #cupidshuffle | ["Music", "Rhythm and blues", "Hip hop music"] | ["male singer", "animated singing", "male backup singers", "dance party", "people dancing", "groovy rhythm", "strong bass line", "clapping rhythm", "steady drumming rhythm", "screaming vocals", "pop dance hits", "children’s song", "pop anthem", "playful", "cheerful", "vocal harmony", "medium tempo", "pop song"] | 1 | 9CJu43AvIds | 982 | |
Under The Sea (Little Mermaid) | The song is an instrumental. The song is medium tempo with a percussionist playing a delightful melody on the steel drums with a steady drum rhythm and a percussive bass line. The song is cheerful and has a life message of being happy. The song audio quality is poor. | 2007-12-03T17:19:35Z | Steel Drum Music | Now on iTunes ♫ This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA Google - http://bit.ly/38mMiPu or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net | ["Music", "Steelpan"] | ["steel drums", "caribbean music", "song cover", "percussive bass line", "movie sound track", "groovy rhythm", "instrumental cover", "instrumental music", "percussionist", "groovy rhythm", "memdium tempo", "steady drumming rhythm", "reggae music influences", "soloist", "emotional", "life is good", "sand and sea", "tropical beach party", "disney movie", "children’s favourites", "cheerful", "positive", "inspiring", "life is good", "motivational"] | 1 | H-bTMbePj0A | 1770 | |
JS-7 Japanese Hand Saw | The song is an instrumental. The tempo is medium with ambient sounds like a sawing tool sounds, guitar rhythm, bass guitar solo and a steady drumming with various percussion hits. The song is an advertisement jingle for a tool works company. The sound quality is average with ambient room sounds. | 2009-03-24T01:04:51Z | Bridge City Tool Works | A look at Bridge City Tool Works Adjustable Back Rip and Crosscut Japanese Saw. | ["Sawing", "Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Tools", "Rub", "Wood", "Bass drum", "Percussion"] | ["hand saw", "instrumental music", "documentary video soundtrack", "advertisement jingle", "poor audio quality", "bouncy rhythm", "tom sounds", "sawing noise", "medium tempo", "cool bass solo", "steady drumming rhythm", "groovy rhythm", "video soundtrack’ toms sounds", "drum sticks", "cool drum roll", "bass drum hits", "exciting", "positive", "cheerful", "funky groove", "funk pop music"] | 1 | ZCR7qJ2IgGI | 3347 |
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;