musiccaps_details (view)
5 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "romantic mood"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- bass · 5 ✖
- male voice · 5 ✖
- romantic mood · 5 ✖
- moderate tempo 2
- percussion 2
- simple percussion 2
- slow tempo 2
- accordion 1
- ballad 1
- brass section 1
- claves 1
- dance music 1
- guitar 1
- hand claps 1
- kizomba 1
- latin beat 1
- latin pop 1
- male backing voices 1
- piano 1
- pop song 1
- programmed percussion 1
- reggae song 1
- shakers 1
- slow dance song 1
- slow pop 1
- spanish pop 1
- synth 1
- synth pads 1
- synth strings 1
musiccaps_names (array) 7 ✖
- Music 5
- Blues 1
- Music of Africa 1
- Music of Latin America 1
- Sad music 1
- Salsa music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kizomba - Do's and Don'ts | This song features a male voice singing the main melody. This is accompanied by other male voices singing backing vocals in harmony. The bass plays the root notes of the chords. A synth plays a melody similar to the backing voices and continues to play even when the main voice sings. The synth has an accordion voice. This is accompanied by programmed percussion playing a Latin dance beat. The mood of this song is romantic. This song can be played in a dance party. | 2013-01-13T22:38:06Z | Frans & Sarah Kizombalove | This vidéo is meant to help those willing to learn our Angolan values on things to avoid while dancing Kizomba. Song: Adi Cudz - Pense moi & Badoxa Pro - Tas maluca --------------------------------------------------------------------------------------------- "Teaching Method: José N'dongala Kizombalove Methodology. Kizombalove Academy paving the way for the future Kizomba & Semba generation". --------------------------------------------------------------------------------------------- www.kizombalove.com | ["Music of Africa", "Music"] | ["dance music", "latin beat", "kizomba", "programmed percussion", "bass", "synth", "romantic mood", "slow tempo", "male voice", "male backing voices"] | 0 | 2umjh27MkjU | 412 | |
Orq. Bronco - Duena De Mi Cuerpo | This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. | 2010-03-26T03:09:29Z | EdwardMulenze | gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] | 0 | 92QYLjfo68Q | 972 | |
Landscapes and Music of Costa Rica | This Spanish pop song features a male voice singing the main melody. This is accompanied by percussion playing a Latin beat. A shaker or maracas plays a continuous rhythm. An accordion plays chords in the background. The bass plays the root note of the chords. This song can be played at a party. The mood of this song is romantic. | 2011-01-10T18:05:18Z | Heredia por Media Calle | Video of Costa Rica with diferent landscapes province by province. | ["Blues", "Music"] | ["spanish pop", "shakers", "simple percussion", "accordion", "male voice", "moderate tempo", "bass", "romantic mood"] | 0 | BdKiPR3kdjo | 1268 | |
Eric Donaldson - Jah Love | This reggae song features a male voice singing the main melody. This is accompanied by percussion playing a simple reggae beat. The bass plays notes in reggae style. A guitar plays fills in the beginning and in between lines. Hand claps are played in groups of two and one in an alternating pattern. This song can be played in a romantic movie. | 2010-01-24T10:52:12Z | NinjaBuziness | Album : Children Of Jah Label : Roots & Culture Records Released : 1999 | ["Music", "Soul music"] | ["reggae song", "male voice", "guitar", "bass", "simple percussion", "moderate tempo", "romantic mood", "hand claps"] | 0 | QHNREJJRTS4 | 2608 | |
Thelo na kano erota mazi sou | This slow pop song features a male voice singing the main melody. This song starts with a melody played on synth strings. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords with a run to reach the next note. There are different synth layers playing different melodies within the scale to produce a complex melody. The voice starts to sing a romantic melody. This is accompanied by the percussion playing a minimalistic beat. The synth pads play a sustained chord in the background. The bass note is sustained through the line being sung. This song can be played in a romantic movie. | 2008-10-01T16:22:38Z | Giorgos Theodwroy | Τραγουδιστης αγνωστος | ["Music", "Sad music"] | ["pop song", "slow pop", "ballad", "male voice", "synth strings", "percussion", "bass", "synth pads", "slow tempo", "romantic mood"] | 0 | XNlFs7Yjauk | 3179 |
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;