musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- groovy bass · 3 ✖
- addictive 2
- groovy 2
- low quality 2
- pop 2
- punchy kick 2
- punchy snare 2
- acoustic guitar melody 1
- arpeggiated electric guitar melody 1
- brass melody 1
- clapping 1
- crowd cheering 1
- crowd clapping 1
- electric guitar melody 1
- energetic crash cymbal 1
- exciting 1
- exciting background male vocals 1
- flat male vocal 1
- fun 1
- harmonizing background vocal 1
- harmonizing male vocals 1
- joyful 1
- live performance 1
- passonate male vocal 1
- reverberant percussion hit 1
- rock 1
- shimmering hi hats 1
- shimmering tambourine 1
- traditional 1
- …
musiccaps_names (array) 5 ✖
- Singing · 3 ✖
- Music 2
- Folk music 1
- Grunge 1
- Music of Latin America 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 | |
Farhad Shams Qarsak-e Panjsher and Sheen Khaale | The low quality recording features a traditional pop song that consists of a flat male vocal, alongside exciting background vocals, singing over claps, wooden percussive elements, groovy bass and acoustic guitar melody. It sounds energetic, addictive, fun and joyful - like something you would hear at more traditional parties. | 2013-03-18T17:13:05Z | StylezhooDB3o9 | Farhad Shams Qarsak-e Panjsher and Sheen Khaale Farhad Shams Qarsak-e Panjsher and Sheen Khaale | ["Singing", "Folk music", "Music"] | ["low quality", "pop", "traditional", "acoustic guitar melody", "wooden percussive elements", "clapping", "groovy bass", "flat male vocal", "exciting background male vocals", "wide", "energetic", "addictive", "fun", "joyful"] | 4 | qM8F6ECriRc | 4779 | |
Aerosmith - Jaded | The rock song features a passionate male vocal, alongside harmonizing background vocal, singing over tremolo electric guitar located in the left channel, arpeggiated electric guitar melody in the right channel of the stereo image, shimmering tambourine, groovy bass guitar, punchy kick and snare hits, reverberant percussive hit and energetic crash cymbal. It sounds groovy, energetic and kind of addictive thanks to that cadence. | 2013-07-13T20:48:09Z | AerosmithVEVO | "Jaded" by Aerosmith Listen to Aerosmith: https://Aerosmith.lnk.to/listenYD Watch more Aerosmith videos: https://Aerosmith.lnk.to/listenYD/youtube Subscribe to the official Aerosmith YouTube channel: https://Aerosmith.lnk.to/subscribeYD Follow Aerosmith: Facebook: https://Aerosmith.lnk.to/followFI Instagram: https://Aerosmith.lnk.to/followII Twitter: https://Aerosmith.lnk.to/followTI Website: https://Aerosmith.lnk.to/followWI Spotify: https://Aerosmith.lnk.to/followSI Lyrics: My, my baby blue Yeah, I been thinking about you My, my baby blue Yeah, you're so jaded And I'm the one that jaded you #Aerosmith #Jaded #OfficialVideo #HD #Remastered | ["Singing", "Music", "Grunge"] | ["tremolo electric guitar chord", "harmonizing background vocal", "arpeggiated electric guitar melody", "punchy snare", "punchy kick", "groovy bass", "shimmering tambourine", "passonate male vocal", "reverberant percussion hit", "energetic crash cymbal", "groovy", "rock", "addictive", "energetic"] | 4 | qbexOeoH5hg | 4801 |
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;