musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar lead" and musiccaps_names contains "Grunge" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- electric guitar lead · 2 ✖
- passionate 2
- acoustic guitar harmony 1
- average audio quality 1
- cheerful 1
- classic rock 1
- compelling 1
- cover song 1
- distorted guitars 1
- emphatic 1
- emphatic vocals 1
- energetic 1
- female vocalist 1
- groovy bass line 1
- hard rock 1
- keyboard accompaniment 1
- lively electric guitar 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- percussive guitar strumming 1
- persuasive 1
- pop rock 1
- powerful 1
- powerful vocals 1
- retro rock 1
- rock 1
- rock band 1
- rock music 1
- steady drumming 1
- string rock drumming 1
- studio recording 1
- tambourine beats 1
- tambourine percussions 1
- youthful 1
musiccaps_names (array) 6 ✖
- Grunge · 2 ✖
- Music 2
- Heavy metal 1
- Progressive rock 1
- Punk 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 |
---|---|---|---|---|---|---|---|---|---|---|
Lissie - Bad Romance (Lady Gaga live cover) | A female vocalist sings this passionate Rock song. The tempo is medium with infectious electric guitars on lead and harmony, tambourine beats , steady drumming and keyboard accompaniment. The song is intense, passionate, empathic, powerful, persuasive and compelling. This song is Soft Rock. | 2010-09-10T10:21:50Z | LissieVEVO | Music video by Lissie performing Bad Romance. (C) 2010 Fat Possum Records in US; (C) 2010 Sony Music Entertainment UK Limited in remaining countries | ["Singing", "Music", "Grunge"] | ["female vocalist", "medium tempo", "cover song", "passionate", "emphatic", "powerful", "persuasive", "compelling", "tambourine beats", "lively electric guitar", "electric guitar lead", "acoustic guitar harmony", "keyboard accompaniment", "emphatic vocals", "powerful vocals", "steady drumming", "rock", "hard rock", "pop rock"] | 7 | W2EJai-3k2w | 3055 | |
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;