musiccaps_details (view)
4 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Disco" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- male voice · 4 ✖
- dance song 2
- disco song 2
- moderate tempo 2
- programmed percussion 2
- backing voice 1
- bass 1
- brazilian 1
- dance 1
- dj 1
- electronic drums 1
- electronic music 1
- groovy bassline 1
- hip-hop beat 1
- hip-hop genre 1
- house 1
- loud 1
- repeated line 1
- romantic theme 1
- shouting 1
- speakers 1
- synth chords 1
- synth sound 1
- synth sounds 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Disco · 4 ✖
- Music 4
- Christian music 1
- Dance music 1
- Drum machine 1
- Electronic dance music 1
- Music of Latin America 1
- Rock and roll 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
Disco polo mix 2009 dj aro | This disco song features a male voice singing the main melody. This is accompanied by programmed percussion playing a disco beat. The kick is played at every count of the bar. The synth changes chords after two bars to a higher pitch chord, then after one bar to a higher pitch chord, then after one more bar to a higher pitch chord and finally after one more bar to a suspended fourth chord. The instruments pause for 3 counts of the bar while the voice continues to sing. The bass plays the root notes of the chords. The mood of this song is romantic. This song can be played in a club. | 2009-02-17T22:19:55Z | 2211557 | Oceniajcie pzdro | ["Disco", "Music", "Dance music"] | ["disco song", "male voice", "synth sounds", "programmed percussion", "bass", "moderate tempo", "upbeat", "romantic theme", "dance song"] | 0 | 1KN3GrwhY8c | 260 | |
Dj TmV - Balada Bleep | This is a house music piece with Brazilian elements. There is a male vocal that starts by shouting and then starts repeating the same word over and over. In the rhythmic background, there is a repetitive electronic drum beat with a very strong low end. It is a very loud piece. This music could be used in nightclubs and sports venues. | 2011-01-05T15:09:14Z | tutuhbitch | www.bleep.com.br Bleep no Limits! | ["Disco", "Music", "Electronic dance music", "Drum machine"] | ["dj", "house", "electronic music", "male voice", "shouting", "repeated line", "brazilian", "dance", "electronic drums", "loud"] | 9 | In44gO8Ej90 | 1938 | |
Little girls dancing to Hello Good Morning/wobble (trimmed) | The hip-hop music features a male voice singing repetitive short bits of melody. The music excerpt contains a strong beat rhythm which drives the pulsation of the music. A synth sound is playing a repeating melody throughout the passage. The music sounds as if it was recorded by a phone from a playing speaker. | 2010-10-11T01:45:52Z | Mooruneque | Texas Girls Fair, Dallas texas | ["Disco", "Music", "Rock and roll", "Music of Latin America"] | ["male voice", "hip-hop beat", "synth sound", "speakers", "hip-hop genre"] | 2 | MVq9PYtypy0 | 2275 | |
chaz - go for love ~ modern soul | This disco song features a male voice singing the main melody. Another voice sings in harmony with the main voice. This is accompanied by programmed percussion playing a simple melody. There is a distinctive hi-hat ring at alternate strokes giving this a unique sound. The bass plays a groovy bassline using the root notes of the chords. A synth plays chords in the background. This song is at a moderate tempo. This song can be played in a club. | 2011-02-02T23:34:17Z | KentSoul1 | chaz - go for love ~ modern soul | ["Disco", "Christian music", "Music", "Song", "Soul music"] | ["disco song", "groovy bassline", "male voice", "backing voice", "vocal harmony", "programmed percussion", "synth chords", "moderate tempo", "dance song"] | 0 | ZEuY5HnECuo | 3350 |
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;