musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "muffled audio" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- fast tempo · 2 ✖
- muffled audio · 2 ✖
- rock · 2 ✖
- amateur recording 1
- buoyant 1
- catchy riff 1
- cymbals 1
- dance groove 1
- digital drums 1
- electric guitar 1
- energetic 1
- energetic riff 1
- enthusiastic 1
- female vocalist 1
- groovy bass lines 1
- hard rock 1
- inferior audio quality 1
- inferior quality audio 1
- instrumental 1
- instrumental rock 1
- intense 1
- intense electric guitar feed back 1
- loud singing 1
- passionate 1
- pop rock 1
- soft drumming 1
- sonic power 1
- spirited 1
- synth arrangements 1
- tambourine 1
- vibrant 1
- vigorous drumming 1
musiccaps_names (array) 5 ✖
- Music 2
- Blues 1
- Electric guitar 1
- Guitar 1
- Independent music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ITV Chart Show Indie Chart July 1995 | A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. | 2007-09-09T16:56:00Z | David Bryant | Features: Buffalo Tom - Summer Song Menswear - Daydreamer | ["Music", "Independent music"] | ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] | 7 | J48F0e0guSQ | 1966 | |
Blink 182 - cacophony bass cover | A musician plays this rock instrumental. The tempo is fast with an intense, emphatic electric guitar riff and enthusiastic drumming and cymbal rides in the background and tambourine beats. The music is muffled as the sound quality is inferior. The music is energetic, enthusiastic, and animated . This is a Rock instrumental. | 2010-05-31T18:19:30Z | Walli182 | ["Blues", "Electric guitar", "Guitar", "Music"] | ["instrumental", "fast tempo", "electric guitar", "inferior audio quality", "catchy riff", "rock", "instrumental rock", "sonic power", "muffled audio", "soft drumming", "cymbals", "tambourine", "inferior audio quality", "energetic riff", "amateur recording"] | 7 | xx3nnVzGXa0 | 5366 |
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;