musiccaps_details (view)
2 rows where musiccaps_aspects contains "disco song" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- disco song · 2 ✖
- male voice 2
- moderate tempo 2
- upbeat · 2 ✖
- bass 1
- celebration song 1
- dance song 1
- foreign language 1
- funk bass 1
- guitar strums 1
- hand claps 1
- happy mood 1
- programmed percussion 1
- romantic theme 1
- synth sounds 1
- synth string backing 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Music 2
- Dance music 1
- Disco 1
- Jingle (music) 1
- Pop 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 | |
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 |
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;