musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "dance song", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "programmed percussion"
This data as json, CSV (advanced)
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 | |
Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan | This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. | 2011-05-25T01:24:21Z | T-Series | Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series | ["Singing", "Music of Asia", "Music"] | ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] | 0 | ctJI7pCbxAo | 3751 | |
Tunji Ige - Behind The Grind: A Piece on Production | This audio is of a low quality recording. It is a hip-hop song featuring a male voice singing the main melody. This is accompanied by a female voice singing vocals in an angelic voice in the background. Programmed percussion plays a simple beat with the hi-hat being struck at every count. The bass plays the root notes of the chords. The bass notes are allowed to ring. This song has a slow tempo. This song can be played in a club. | 2016-05-06T15:57:49Z | Tunji Ige | Behind the creative & collaborative process of making "On My Grind", produced by Tunji Ige & Noah Breakfast. | ["Music", "Rapping"] | ["low quality audio", "programmed percussion", "male voice", "female backing", "hip-hop song", "bass", "slow tempo", "dance song"] | 0 | tPJMr890HeE | 5033 |
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;