musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "live performance" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- acoustic drums 3
- bass guitar · 3 ✖
- live performance · 3 ✖
- alternative 2
- energetic 2
- male vocal 2
- nu-metal 2
- aggressive 1
- boy band 1
- chaotic 1
- dance-pop 1
- distorted electric guitar 1
- electric guitar 1
- electronic elements 1
- emotional 1
- keyboard 1
- male vocals 1
- melodic singing 1
- pop music 1
- repeated tune 1
- scream 1
- tear-jerking 1
- violent 1
musiccaps_names (array) 4 ✖
- Exciting music · 3 ✖
- Music 3
- Heavy metal 1
- Singing 1
youtube_published (date) 3 ✖
- 2007-07-24 1
- 2009-03-09 1
- 2009-07-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
She's All That shouting out Music Music! (live @ Rheinkultur Bonn 2009) | This is a nu-metal piece performed live on the stage. There is a male vocal shouting the words at the end of the song. The electric guitar is repeating the same tune while the bass guitar is playing in the background. The drummer plays fills on the acoustic drums to provide the rhythmic background. There is a high energy atmosphere to this piece. It could be used in an ad targeted for teenagers. | 2009-07-05T21:32:23Z | pnolle | Those Nu-Break-maniacs give you the ultimate thrill on stage, hiding their identity behind bizarre masks. A ferocious mixture of electro, ragga, punk and breakbeat. Visit www.shesallthat.de SATrk09 SuperKid 640x360 | ["Music", "Exciting music"] | ["nu-metal", "alternative", "live performance", "male vocal", "electric guitar", "repeated tune", "bass guitar", "acoustic drums", "energetic"] | 9 | 79tuMIiWMZ4 | 816 | |
WRENCH LIVE O-EAST DYNAMITE MUSIC | This is the live recording of an alternative metal piece. There is a male vocal screaming every now and then. There is a heavy use of electronic elements which makes up for the majority of the melodic structure. There is a distorted electric guitar and a bass guitar playing. The rhythmic background consists of an aggressive acoustic metal drum playing in synchrony with the electronic elements. The atmosphere is energetic and violent. This piece could be playing in the background at a metal bar. | 2009-03-09T04:09:02Z | nrsrnge | WRENCH LIVE O-EAST DYNAMITE MUSIC 2009 01 30 | ["Heavy metal", "Music", "Exciting music"] | ["nu-metal", "alternative", "live performance", "male vocal", "scream", "distorted electric guitar", "bass guitar", "electronic elements", "acoustic drums", "energetic", "aggressive", "chaotic", "violent"] | 9 | AsR5us-IS00 | 1177 | |
N'Sync - Selfish | This is the live recording of a boy band performing a pop music piece. The male vocals are singing melodically. There is a keyboard and a bass guitar playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is emotional. This piece could be included in the soundtrack of a teenage romance/drama movie. | 2007-07-24T07:50:18Z | Yan Chat | N'Sync - Selfish... N'Sync Popodyssey Live... | ["Singing", "Music", "Exciting music"] | ["live performance", "pop music", "dance-pop", "boy band", "male vocals", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "emotional", "tear-jerking"] | 9 | kw2wPVxUgQY | 4367 |
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;