musiccaps_details (view)
3 rows where musiccaps_aspects contains "rock", musiccaps_names contains "Plucked string instrument" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- rock · 3 ✖
- acoustic drums 1
- acoustic guitar 1
- artist 1
- blues 1
- cello 1
- cheering clapping 1
- closing riff 1
- concert 1
- contemporary 1
- distorted electric guitar chords 1
- e-bass 1
- e-guitar 1
- electric guitar 1
- energetic 1
- enthusiastic 1
- gig 1
- harsh 1
- live audience 1
- live performance 1
- low quality 1
- male vocalist 1
- male voices singing 1
- medium fast tempo 1
- medium to uptempo 1
- messy 1
- performer 1
- playback 1
- soft rock 1
- song end 1
- southern rock 1
- stage performance 1
musiccaps_names (array) 10 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument · 3 ✖
- Rock music · 3 ✖
- Bass guitar 1
- Electronic music 1
- Grunge 1
- Progressive rock 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Curtis Stigers-This Life | A male vocalist sings this spirited song. The tempo is medium fast with an acoustic and electric guitar flourish with a bass cello. This bit is the end of the song as the musician plays a closing riff and the sound of clapping and cheering can be heard. This song is an enthusiastic live performance of an energetic Soft Rock. | 2012-04-19T22:49:45Z | Roxxboise | Sons of Anarchy theme song from Curtis Stigers in-studio at KRVB, "The River," Boise, Idaho. | ["Singing", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["male vocalist", "medium fast tempo", "song end", "closing riff", "live performance", "concert", "live audience", "gig", "stage performance", "cheering clapping", "acoustic guitar", "electric guitar", "cello", "southern rock", "blues", "rock", "contemporary", "soft rock", "enthusiastic", "energetic", "performer", "artist"] | 7 | kkOGbgGJLF4 | 4352 | |
Dani California cover | The low quality recording features distorted electric guitar chords playing over rock songs played on playback. It sounds messy and harsh, as the frequencies of the room and the actual sound of the guitar and song are clashing with each other. | 2006-05-01T21:34:48Z | geraci89 | just me playing along to my favourite song on the radio right now by my favourite band:):) enjoy! | ["Guitar", "Music", "Musical instrument", "Rock music", "Progressive rock", "Plucked string instrument"] | ["low quality", "distorted electric guitar chords", "playback", "harsh", "messy", "rock"] | 4 | m8poFnEbvW8 | 4447 | |
The Sunshine Underground - Put You In Your Place | This song contains a male voice repeating the same melody in a loop while another male voice is singing on top in a higher register. An acoustic drum is holding a four on the floor groove with a kick on every beat. The e-bass and e-guitar are playing along to the loop, repeating themselves. This song may be playing at a live concert downtown. | 2006-04-17T19:07:34Z | TomasTurbado | Videoclip indie rock | ["Electronic music", "Guitar", "Music", "Musical instrument", "Rock music", "Grunge", "Plucked string instrument"] | ["rock", "e-guitar", "e-bass", "male voices singing", "acoustic drums", "medium to uptempo"] | 6 | x7tOPTm31tQ | 5305 |
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;