musiccaps_details (view)
2 rows where musiccaps_aspects contains "chaotic", musiccaps_aspects contains "distorted sounds" and musiccaps_aspects contains "static"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- chaotic · 2 ✖
- distorted sounds · 2 ✖
- fast tempo 2
- static · 2 ✖
- beep 1
- buzzing 1
- concert 1
- confusing 1
- dissonant 1
- electronic sounds 1
- enthusiastic music 1
- female vocalist 1
- funky bass line 1
- game end music 1
- hissing 1
- incoherent 1
- incomprehensible 1
- inferior audio quality 1
- instrumental 1
- live performance 1
- muddled 1
- murmurs 1
- people talking 1
- rhythmic guitar 1
- shooting 1
- unrelated music 1
- video game sounds 1
- vigorous drumming 1
- vigorous hand percussion 1
musiccaps_names (array) 4 ✖
- Music 2
- Cacophony 1
- Singing 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
McBrown and Akosua Agyapong full performance @ AICC | A female vocalist sings this pop song. The tempo is fast with vigorous percussion in the background , funky bass line, an incessant keyboard harmony and guitar. The vocals and instrumentation are incoherent as the audio quality is bad. The is sound of static, murmuring, buzzing,hissing and scuffling indicating that this is a recording of a live performance. | 2015-07-15T09:39:31Z | Devatainment | The long awaited concert to celebrate the sensational music icon, Akosua Agyapong for her 25 years in the music industry came off successfully on Saturday, May 30, 2015 at the Accra International Conference Centre (AICC). The concert which was well attended witnessed the presence of crème-de la-crème personalities of the society such as Former President Jerry John Rawlings and his wife, some members of Parliament, media personalities as well as the general public. Yaw Sakyi and Stacy Amoateng were the Mcs on the night. | ["Singing", "Music", "Tambourine"] | ["female vocalist", "fast tempo", "vigorous hand percussion", "chaotic", "live performance", "concert", "static", "buzzing", "hissing", "murmurs", "funky bass line", "live performance", "rhythmic guitar", "distorted sounds", "incoherent", "inferior audio quality", "muddled", "incomprehensible", "static", "vigorous drumming", "people talking"] | 7 | 5MOJnA715fA | 657 | |
WarioWare Touched! Hacking | This music clip is an instrumental. The tempo is fast with different electronic sounds from a video game. The sounds and music are dissonant and unrelated. There are sounds of shooting, beeping, and game ending. This music is video game music. | 2008-03-25T22:57:06Z | Sonic007SF | I hacked/cheated the game because I can. Me and a friend worked on this.The slow part at the start of the vid is the game, the game is slowing down because of a hack that caused this to happen.The first part is done in a mode where you play all minigames and the game can freeze sometimes from this because I am playing from the album mode not the Monster Megamix mode. | ["Music", "Cacophony"] | ["instrumental", "fast tempo", "distorted sounds", "electronic sounds", "unrelated music", "dissonant", "confusing", "chaotic", "static", "beep", "shooting", "video game sounds", "game end music", "enthusiastic music"] | 7 | Z-G7nL9tiws | 3332 |
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;