musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "rebellious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- live performance · 2 ✖
- rebellious · 2 ✖
- acoustic drums 1
- amateur recording 1
- ambient room noise 1
- bass guitar 1
- death metal 1
- deteriorated audio 1
- distorted guitar rhythm 1
- electric guitar 1
- emotional 1
- energetic 1
- female singer 1
- female vocal 1
- haunting 1
- live audience 1
- loud 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- retro death metal hits 1
- rock music 1
- screaming vocals 1
- steady drumming rhythm 1
- teenage age angst 1
musiccaps_names (array) 7 ✖
- Music 2
- Distortion 1
- Grunge 1
- Pink noise 1
- Rock music 1
- Singing 1
- Yell 1
youtube_published (date) 2 ✖
- 2006-11-03 1
- 2011-04-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
Mas - Ruido Rosa en el Vive Latino 2011 | This is an amateur recording of a live rock music performance. There is a female vocalist singing in the lead. The electric guitar is playing the main melody with a bass guitar in the background. There is a fast-paced and loud acoustic drum beat in the rhythmic background. The atmosphere is loud and rebellious. | 2011-04-12T02:37:35Z | Ricardo Garcia | Ruido Rosa haciendo honor a su nombre, bien por la fuerza de su baterista!!! | ["Music", "Pink noise", "Distortion"] | ["rock music", "amateur recording", "live performance", "female vocal", "electric guitar", "acoustic drums", "bass guitar", "loud", "rebellious", "energetic"] | 9 | Lg1HG6D_0Qk | 2213 |
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;