musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "energetic" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 30 ✖
- acoustic drums · 4 ✖
- energetic · 4 ✖
- bass guitar 3
- alternative 2
- electric guitar 2
- live performance 2
- male vocal 2
- nu-metal 2
- 80s pop 1
- aggressive 1
- chaotic 1
- distorted electric guitar 1
- e-bass 1
- e-guitars 1
- electronic elements 1
- female backing voices 1
- female vocal 1
- grandiose 1
- high tempo 1
- keyboard 1
- male voice screaming/rapping 1
- medium to uptempo 1
- melodic singing 1
- pad 1
- pop music 1
- repeated tune 1
- rock/rap 1
- scream 1
- vibrant 1
- violent 1
musiccaps_names (array) 5 ✖
- Exciting music · 4 ✖
- Music 4
- Heavy metal 2
- Grunge 1
- Music of Asia 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 | |
Sound Of Music - 02 Magic Night (1987) | This is a pop music piece with 80s characteristics. There is a female vocalist in the lead singing melodically. The main theme is played by a keyboard and an electric guitar at the same time in the major scale. There is a bass guitar and a medium-to-high range pad in the background. The rhythmic background is provided by a loud but simple acoustic drum beat. There is a maximalist, vibrant and energetic atmosphere. This piece could be used in the soundtrack of a romance movie. It could also fit very nicely as the soundtrack of an anime. | 2009-12-25T08:13:42Z | mixtis carminibus | Sound Of Music was a Swedish pop group who recorded two albums 1986-1987. Peter Grönvall, who wrote the music, is the son of Benny Andersson from Abba. The other two members were Nanne Grönvall and Angelique Widengren. | ["Music of Asia", "Music", "Exciting music"] | ["pop music", "80s pop", "female vocal", "melodic singing", "keyboard", "bass guitar", "electric guitar", "pad", "acoustic drums", "grandiose", "vibrant", "energetic", "high tempo"] | 9 | TN53jpjqAGI | 2833 | |
Dropbears - Companion (This One’s for Me) OFFICIAL MUSIC VIDEO | Someone is playing acoustic drums with a lot of fill-ins before breaking into the next part of the song. A e-guitar and e-bass are playing the same melody/chords to elevate the energy. Female voices are singing in harmony before a male voice starts to scream in a higher register and then starts rapping. The e-guitar then is playing, almost clean sound, melody. This song may be playing with headphones while skating. | 2015-11-06T09:56:06Z | DropBearsChannel | The new single Companion (This One's for Me) by DROPBEARS www.facebook.com/dropbearsband @dropbearsband | ["Heavy metal", "Music", "Grunge", "Exciting music"] | ["rock/rap", "e-guitars", "acoustic drums", "e-bass", "male voice screaming/rapping", "female backing voices", "medium to uptempo", "energetic"] | 6 | qVuxCN3JpiM | 4793 |
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;