musiccaps_details (view)
3 rows where musiccaps_aspects contains "amplified guitar harmony" and musiccaps_author = 7 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- amplified guitar harmony · 3 ✖
- compelling 2
- hard rock 2
- heavy metal 2
- instrumental 2
- active 1
- ambient 1
- amplified instruments 1
- atmospheric 1
- call and response 1
- clapping 1
- complex harmony 1
- concert 1
- contemporary jazz 1
- crowd cheering 1
- dense bass lines 1
- distorted guitars 1
- electrifying 1
- electronic guitar lead 1
- empahtic 1
- emphatic 1
- emphatic rhythm 1
- emphatic vocals 1
- energetic 1
- enthusiastic 1
- fans 1
- fast tempo 1
- gig 1
- grim 1
- groovy bass line 1
- hard hitting drums 1
- improvisation 1
- infectious drumming 1
- informal 1
- intense 1
- intense electric guitar feedback 1
- intense keyboard 1
- irregular beats 1
- jazz 1
- keyboard accompaniment 1
- live performance 1
- lively 1
- male vocalist 1
- medium tempo 1
- polished 1
- polyrhythms 1
- powerful 1
- rim shot 1
- rock 1
- rock music 1
- singing along 1
- smooth 1
- solos 1
- sonic power 1
- spirited 1
- string instruments 1
- syncopation 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Grunge 1
- Percussion 1
- Rock and roll 1
- Roll 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Led Zeppelin - Rock and Roll (Live) | A male vocalist sings this energetic Rock song. The tempo is fast with intense drumming, vigorous electric guitar, funky bass and keyboard harmony. The song is a vibrant, enthusiastic, youthful, animated, spirited, buoyant and electrifying Heavy Metal/Rock. There are sounds of people cheering, clapping and singing along, indicating that this is a live performance. | 2008-03-13T23:04:36Z | Rodolfo Baravalle | Rock and Roll en no sé donde.. Viva la pepa (?) | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "enthusiastic", "string instruments", "amplified instruments", "sonic power", "infectious drumming", "live performance", "gig", "intense electric guitar feedback", "amplified guitar harmony", "keyboard accompaniment", "emphatic vocals", "concert", "live performance", "hard rock", "heavy metal", "rock", "crowd cheering", "clapping", "singing along", "fans", "enthusiastic", "youthful", "electrifying", "compelling"] | 7 | QvwD7NEg3Mw | 2650 | |
Mimi Jones Band Live @ Smalls: Fast Lane | This music is a Jazz instrumental. The tempo is medium with a groovy bass one, smooth harmony on acoustic guitar and rim shots.The music is smooth, lively, informal, chill, ambient and atmospheric with the sound of musicians talking to each other. | 2010-10-01T16:24:53Z | Mimi Jones | Mimi Jones, bass; Sean Harkness, guitar; Miki Hayama, piano; Chris Eddleton, drums; Sam Newsome, soprano sax | ["Wood block", "Percussion"] | ["instrumental", "medium tempo", "jazz", "contemporary jazz", "call and response", "irregular beats", "solos", "rim shot", "complex harmony", "syncopation", "groovy bass line", "amplified guitar harmony", "polyrhythms", "ambient", "atmospheric", "improvisation", "lively", "energetic", "spirited", "active", "informal", "smooth", "polished", "empahtic"] | 7 | WK-gdfCurCg | 3085 | |
Tocotronic Rock Pop in Concert english | This instrumental is a Heavy Metal instrumental. The tempo is fast with hard hitting drumming, furious and vigorous amplified keyboard playing a harmony, electric bass guitar and electric guitar accompaniment. The music is intense, grim, compelling, passionate, powerful and harmonious. The vibe of the music is serious, sinister, grim and steely. This is used in Hard Rock/Heavy Metal. | 2008-12-05T22:28:11Z | petapanda | from KOOK english album, singing at 1:30 | ["Music", "Grunge"] | ["instrumental", "hard rock", "heavy metal", "intense keyboard", "electronic guitar lead", "amplified guitar harmony", "grim", "intense", "rock music", "distorted guitars", "emphatic rhythm", "dense bass lines", "powerful", "emphatic", "compelling", "hard hitting drums"] | 7 | u_TfWvyYY0Y | 5126 |
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;