musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy riff" and musiccaps_aspects contains "catchy vocal riff"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- catchy riff · 2 ✖
- catchy vocal riff · 2 ✖
- fast tempo 2
- ambient street sounds 1
- animated 1
- animated singing 1
- bouncy 1
- busker 1
- busking 1
- cheering 1
- chirpy 1
- clapping 1
- club music 1
- concert 1
- disco 1
- dj 1
- dj mixer 1
- enthusiastic paino 1
- gig 1
- inferior audio quality 1
- instrumental 1
- live performance 1
- male vocalist 1
- mufffled audio 1
- people talking 1
- phonograph record 1
- piano harmony 1
- repetitive 1
- rotating platform 1
- scratching 1
- street performance 1
- thumping beats 1
- turn table 1
- vehicle sounds 1
- vinyl disc 1
- vivacious 1
- vivid 1
musiccaps_names (array) 4 ✖
youtube_published (date) 2 ✖
- 2007-10-08 1
- 2015-07-30 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bicycle Piano -Mickey Mouse March | A male vocalist sings this energetic song. The tempo is fast with a spirited piano accompaniment and ambient street noises like vehicles, people talking and breeze. There is a sound of clapping and cheering indicating that this is a live street performance. The audio quality is inferior causing static and muffled sounds.This song is a cheerful, animated, spirited, happy, chirpy and bouncy pop. | 2007-10-08T15:21:12Z | M K | Who the leader of the club that made for you and me! | ["Applause", "Music"] | ["male vocalist", "fast tempo", "piano harmony", "bouncy", "chirpy", "animated", "vivid", "vivacious", "ambient street sounds", "inferior audio quality", "mufffled audio", "catchy riff", "animated singing", "enthusiastic paino", "catchy vocal riff", "clapping", "people talking", "cheering", "vehicle sounds", "live performance", "gig", "concert", "street performance", "busking", "busker"] | 7 | 6ragcEJVErI | 792 | |
DJ Sara - Scratch Practice 【2015】 | This music is a youthful instrumental. The tempo is fast with a DJ using a turntable to manipulate sounds and music on a turntable using vinyl records. The music has a repetitive, catchy vocal riff , thumping beats and scratching sounds. | 2015-07-30T05:03:51Z | djsararyusei scratch | Sara (16 years old) | ["Scratching (performance technique)", "Beatboxing", "Music"] | ["instrumental", "fast tempo", "turn table", "thumping beats", "catchy vocal riff", "repetitive", "rotating platform", "phonograph record", "vinyl disc", "disco", "club music", "catchy riff", "dj", "dj mixer", "scratching"] | 7 | Cd7JefC6-Zw | 1384 |
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;