musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium fast tempo" and musiccaps_names contains "Grunge"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- male singer 2
- medium fast tempo · 2 ✖
- passionate 2
- adventurous 1
- average audio quality 1
- cheerful 1
- classic rock 1
- cymbals crashing 1
- distorted guitars 1
- drum rolls 1
- electric guitar lead 1
- emotional 1
- energetic 1
- exciting 1
- female singer 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- keyboard accompaniment 1
- percussive bass line 1
- percussive guitar strumming 1
- poor audio quality 1
- retro pop hits 1
- retro rock 1
- rock band 1
- rock music 1
- romantic 1
- steady drumming rhythm 1
- string rock drumming 1
- studio recording 1
- tambourine percussions 1
- vocal duet 1
- youthful 1
musiccaps_names (array) 7 ✖
- Grunge · 2 ✖
- Music 2
- Heavy metal 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov | A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. | 2012-02-10T11:45:21Z | gian maria emendatori | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] | 1 | fXhN3_gGpQw | 3957 |
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;