musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "live performance" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- live performance · 3 ✖
- youthful 2
- acoustic drums 1
- addictive synth lead melody 1
- alternative 1
- background harmonizing vocals 1
- bass guitar 1
- boy band 1
- concert 1
- crowd cheering 1
- crowd screaming 1
- electric guitar 1
- electronic sound effect 1
- energetic drums 1
- engaging 1
- enthusiastic 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- foreign language 1
- fun 1
- groovy bass line 1
- groovy thin bass 1
- happy 1
- hip 1
- hit song 1
- indie rock 1
- k-pop 1
- laser 1
- …
musiccaps_names (array) 9 ✖
- Independent music · 3 ✖
- Music 2
- Singing 2
- Cacophony 1
- Funk 1
- Music of Asia 1
- Pop music 1
- Rapping 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Melissa Manchester - You Should Hear How She Talks About You | The low quality recording features a live performance of a pop song that consists of passionate female vocals, alongside background harmonizing vocals, singing over energetic drums, groovy, thin bass, mellow synth pad and addictive synth lead melody. Even though the recording is noisy and in mono, it sounds energetic, happy and fun. | 2007-05-21T17:06:41Z | Guido Antonio Di Carlo | Melissa Manchester - You Should Hear How She Talks About You live at Solid Gold 1982 | ["Singing", "Independent music"] | ["low quality", "mono", "noisy", "pop", "live performance", "energetic drums", "groovy thin bass", "mellow synth pad", "addictive synth lead melody", "passionate female vocal", "background harmonizing vocals", "energetic", "happy", "fun"] | 4 | W_MZo88gzrA | 3107 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Bloc Party - Hunting For Witches @ Bristol Academy 7/2/07 | This is the live performance of an indie rock/post-punk piece. There is a male vocalist in the lead. The tune is being played by the electric guitar and the bass guitar while an electronic sound effect that resembles a laser is adding texture. There is a fast and slightly off-tempo acoustic drum beat playing in the rhythmic background. The atmosphere is energetic. The piece could be playing in the soundtrack of a teenage drama TV series. | 2007-02-23T17:52:05Z | matthewm674 | Bloc Party performing Hunting For Witches live at the Bristol Carling Academy - 7th Feb 2007. | ["Singing", "Music", "Independent music", "Rock music", "Cacophony"] | ["live performance", "indie rock", "post-punk", "alternative", "male vocal", "electric guitar", "bass guitar", "electronic sound effect", "laser", "acoustic drums", "energetic", "hip", "youthful"] | 9 | xUMzNtC2ITA | 5332 |
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;