musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "romantic" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 5 ✖
- romantic · 5 ✖
- cymbals crashing 3
- passionate 3
- acoustic drums 2
- bass guitar 2
- groovy rhythm 2
- keyboard accompaniment 2
- male singer 2
- male vocal 2
- melodic singing 2
- percussive bass line 2
- retro pop hits 2
- rock band 2
- steady drumming rhythm 2
- 80s feel 1
- acoustic guitar 1
- adventurous 1
- average audio quality 1
- backup singers 1
- ballad 1
- classic rock band 1
- distorted guitar rhythm 1
- drum rolls 1
- energetic 1
- exciting 1
- fast tempo 1
- female back vocal 1
- female singer 1
- guitar accompaniment 1
- …
musiccaps_names (array) 10 ✖
- Independent music · 5 ✖
- Music 5
- Grunge 2
- Singing 2
- Heavy metal 1
- Pop music 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Song 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 | |
Graham Bilbrough of Child singing The Answer To The Everything | This is a pop music ballad piece. There is a male vocal singing melodically in the lead with a female back vocal singing at a higher pitch in the background. The melodic background consists of the strings, the keyboard and the bass guitar. There is a 6/8 slow tempo acoustic drum beat in the rhythmic background. The piece has an emotional atmosphere. This piece could be used in a romantic setting such as a slow dance night event or a wedding. It could also be used in the soundtrack of a romance movie. | 2011-01-23T12:39:23Z | Eleanor Bilbrough | Graham Bilbrough/ Ricky Graham of Child singing The Answer To The Everything | ["Singing", "Music", "Independent music"] | ["pop music", "ballad", "80s feel", "male vocal", "melodic singing", "female back vocal", "strings", "keyboard", "bass guitar", "acoustic drums", "romantic", "emotional", "slow tempo"] | 9 | OpWCljke4oQ | 2473 | |
The Scissors - You Can Make It Dangerous - Out 3.20.10 | A male singer sings this rock melody with backup singers in vocal harmony. The song is fast tempo with a strong drumming rhythm , percussive bass line, amplified guitar playing lead. The song is energetic and romantic. The song is a retro rock song with average audio quality. | 2010-01-21T00:22:10Z | TheScissors | http://www.thescissors.com - http://facebook.com/thescissors Scissors - You Can Make It Dangerous - Out 3.20.10 | ["Singing", "Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock", "Grunge"] | ["make singer", "fast tempo", "rock band", "backup singers", "vocal harmony", "strong rock drumming", "distorted guitar rhythm", "guitar playing lead", "tambourine percussions", "cymbals crashing", "emotional", "romantic", "groovy rhythm", "high in adrenaline", "passionate", "spirited", "retro rock hits", "average audio quality"] | 1 | Ztlcnd14Kn4 | 3426 | |
wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 |
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;