musiccaps_details (view)
3 rows where musiccaps_aspects contains "synth" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- synth · 3 ✖
- bass 2
- male voice 2
- moderate tempo 2
- bowed lute 1
- dance 1
- dance pop song 1
- distortion guitar 1
- electronic drums 1
- foreign language 1
- gothic rock 1
- harmonica 1
- intimate 1
- keyboard 1
- male vocals 1
- mellow bass 1
- melodic singing 1
- middle-eastern feel 1
- neo-soul 1
- programmed percussion 1
- r&b 1
- seductive 1
- simple percussion 1
- suspenseful song 1
musiccaps_names (array) 10 ✖
- Music 3
- Song · 3 ✖
- Afrobeat 1
- Dance music 1
- Heavy metal 1
- Pop music 1
- Psychedelic rock 1
- Rhythm and blues 1
- Rock music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carl Thomas: Conquer | This is a neo-soul music piece. There is a male vocal singing melodically with another male back vocal singing in a more erotic fashion. The tune is played with a keyboard and a synth. There is a mellow bass line in the background. An acoustic-sounding electronic drum kit provides the rhythmic background. The piece has a seductive atmosphere to it. It could be played at a nightclub during earlier hours. It could also work well as the jingle of a fashion/fragrance advertisement. | 2011-07-15T01:14:54Z | CarlThomasLive | Carl Thomas new album "Conquer" Coming out October 4th, 2011 | ["Music", "Rhythm and blues", "Song"] | ["r&b", "neo-soul", "male vocals", "melodic singing", "keyboard", "synth", "mellow bass", "electronic drums", "harmonica", "dance", "seductive", "intimate"] | 9 | 9ZAmdxKLnhs | 1021 | |
Top 10 songs Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | This gothic rock song features a male voice singing the main melody. The melody is repetitive for each line. This is accompanied by percussion playing a simple rock beat in common time. A distortion guitar plays power chords. A synth plays a high pitched repetitive melody. This song has a suspenseful feel. This song can be played in a horror movie. | 2009-08-13T22:53:50Z | Dyhg | Top 10 de musica oscura Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | ["Singing", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song"] | ["gothic rock", "male voice", "distortion guitar", "simple percussion", "bass", "synth", "suspenseful song", "moderate tempo"] | 0 | WRZGYDh7qRo | 3094 | |
اغنية تركية- اسماعيل - Turkish Pop Dance Music | This dance pop song features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a dance beat. The percussion is programmed. The bass plays the root notes of the chords. Synth sounds are played in the background. Bowed lute play fills in between lines to give this song a middle-eastern feel. This song can be played in a club. The mood of this song is flirty. | 2009-05-30T10:00:18Z | Mozzoona | ismail yk bomba bomba: Turkish music, turkish dance, turkish travel, turkish food, turkish boy, turkish man, turkish gay, turkish sex, turkish lesbian, turkish girl, turkish woman, turkish homosexual, istanbul, turkey, ankara, izmir, tarkan, arabic music, arabic dance, belly dance, sex video, sexy girl, erotic pictures, sex images, porno images, arabic language, arabic football, asian, olympic, china, beijin, middle east, medditerian, italy, spain, rome, madrid, andalucia, algeria, morocco, tunisia, libya, egypt, syria, israel, palestine, jordan, lebanon, iraq, saudi arabia, yemen, sudan, bahrain, kuwait, qatar, emirates, oman, iran, pakistan, afghanistan, kabul, india, karachi, tehran, new delhi, pop music, classical music, jazz, techno, greek, greek music, funny cat, funny video, comedy, guru, oriental music, arabian gulf, persian gulf, song, romance, romantic, madonna, keylie minogue, britney spears, michael jackson, japan, tokyo, philippine, australia, USA, washington, chicago, los angeles, miami, havana. | ["Afrobeat", "Music", "Pop music", "Song", "Dance music"] | ["dance pop song", "male voice", "foreign language", "programmed percussion", "moderate tempo", "middle-eastern feel", "synth", "bass", "bowed lute"] | 0 | bmVd2Zj8_Cc | 3652 |
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;