musiccaps_details (view)
3 rows where musiccaps_aspects contains "male backing voice" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- male backing voice · 3 ✖
- male voice · 3 ✖
- bass 2
- moderate tempo 2
- percussion 2
- aggressive percussion 1
- alternative rock 1
- distortion guitars 1
- groovy bass 1
- keyboard 1
- reggae guitar 1
- reggae song 1
- romantic theme 1
- slow pop 1
- slow tempo 1
- synth layers 1
- trap beat 1
musiccaps_names (array) 7 ✖
- Music 3
- Grunge 1
- Heavy metal 1
- Hip hop music 1
- Punk rock 1
- Reggae 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bob Marley - Get Up Stand Up + Lyrics | This reggae song features a male voice singing the main melody. Other male voices sing backing voices repeating the same melody in between lines. This is accompanied by percussion playing a simple melody using reggae rhythm. The bass plays a groovy bassline using runs within the scale. A guitar plays chords by muting technique producing a reggae rhythm. A keyboard plays chords in the background. This song can be played in a documentary about alleviating poverty. | 2011-02-25T13:27:55Z | Γιάννης P. | The God sign's Get Up Stand Up just enjoy the music. Peace,Love & Hope Brothers & Sisters for a better world. I don't have copyrights or anything like this. | ["Music", "Reggae"] | ["reggae song", "male voice", "male backing voice", "groovy bass", "reggae guitar", "percussion", "keyboard", "moderate tempo"] | 0 | BiPwCMlghhQ | 1278 | |
iZomi - Nang A Ding | This slow pop song features a male voice singing the main melody. Another male voice sings backing voices in harmony with the main melody. A synth plays the same melody as the main voice using staccato notes. This is accompanied by percussion playing a trap beat. The bass plays the root notes of the chords and flourishes during chord changes. The bass notes are played without pausing in between notes. Instead, the notes are slid into each other. The mood of this song is romantic. This song can be played in a heartbreak scene in a romantic movie. | 2011-04-09T01:25:02Z | Khan Taithul | Lasa - Muanpi Mungleuh Sangpy Laphuak - Sangpu, Muanpi, Sangpy, Khanpi Produce by Adamack Director Khanpi | ["Music", "Zing", "Hip hop music"] | ["slow pop", "trap beat", "synth layers", "male voice", "bass", "male backing voice", "slow tempo", "romantic theme"] | 0 | CM2rKZmcR0I | 1355 | |
Mayday Parade - "Black Cat" Live at the Alley | This alternative rock song features a male voice singing the main melody at a high pitch. Other male voices sing in harmony after the main voice pauses. This is accompanied by powerful percussion playing a rock beat in common time. Distortion guitars play power chords. One of the guitars plays the same melody as the backing voices on the lead guitar. The bass plays the root notes of the chords. This song is played at a moderate tempo. The mood of this song is upbeat. This song can be played in a Transformers style movie. | 2007-08-06T21:59:06Z | Fearless Records | This is a live video of Mayday Parade performing their track "Black Cat" off their album 'A Lesson in Romantics'. Filmed by DJay Brawner at the Alley in Fullerton 2007. Get Mayday Parade's first full length album 'A Lesson In Romantics' today on iTunes: http://bitly.com/TIu6FH Stay connected to Mayday Parade: http://www.maydayparade.com/ http://www.facebook.com/maydayparade http://twitter.com/maydayparade See what's new at Fearless Records: http://www.youtube.com/fearlessrecords Distributed by WMG | ["Heavy metal", "Music", "Punk rock", "Grunge"] | ["alternative rock", "male voice", "distortion guitars", "male backing voice", "bass", "percussion", "moderate tempo", "aggressive percussion"] | 0 | fQiSoVDFRjo | 3946 |
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;