musiccaps_details (view)
3 rows where musiccaps_aspects contains "danceable", musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "upbeat"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Black Strobe - I'm A Man | This is an electroclash piece. There is a male vocalist singing in the lead with hollering samples in the background. An electric guitar is playing the main theme repeatedly. The bass guitar is playing a groovy bass line. In the rhythmic background, there is an upbeat acoustic drum beat. The piece is groovy and danceable. It could be playing in the background at a sports bar or a rock bar. The music would also suit well with sports venues. | 2007-06-29T16:46:49Z | The Arkive | Check out the Top of the Pops playlist here ➤ https://bit.ly/2F8np11 Black Strobe (sometimes Blackstrobe) is an electroclash group formed in Paris in 1997 by producer Arnaud Rebotini and DJ Ivan Smagghe. They were instrumental in the rise of the electroclash movement in the UK with their breakthrough single "Me and Madonna". Originally producing in the house genre, they later became more influenced by music from the 1970s and 1980s, especially industrial post-punk and European electronic body music. They are heavily influenced by acts such as Cabaret Voltaire, Nitzer Ebb, Front 242, and Depeche Mode. | ["Music", "Grunge"] | ["electroclash", "male vocal", "electric guitar", "repeated theme", "bass guitar", "groovy", "danceable", "energetic", "bravado", "upbeat"] | 9 | LbPRGDwlfqs | 2206 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 | |
Bee Gees - You Should Be Dancing - Saturday Night Fever "John Travolta" USA | This is a pop/disco music piece. There is a male vocalist singing melodically in the lead while the main tune is being played by the saxophone. In the rhythmic background, there is an electronic drum beat with percussive elements surrounding it. The atmosphere is energetic and danceable. This piece could be playing in the background at a dance club during a retro-themed night. | 2012-08-17T21:44:37Z | Musicaplus Radio | John Travolta - Saturday Night Fever ► American Dance Bee Gees - You Should Be Dancing - Saturday Night Fever (John Travolta) Title: You Should Be Dancing (Edit / From "Saturday Night Fever" Soundtrack) Artist: Bee Gees Info: Saturday Night Fever is a 1977 American dance drama film directed by John Badham. It stars John Travolta as Tony Manero, a young working-class Italian-American man from Brooklyn who spends his weekends dancing and drinking at a local Brooklyn discothèque; Karen Lynn Gorney as Stephanie Mangano, his dance partner and eventual confidante; and Donna Pescow as Annette, Tony's former dance partner and would-be girlfriend. While in the disco, Tony is the champion dancer. His circle of neighborhood friends and his weekend dancing help him to cope with the harsh realities of his life: a dead-end job, clashes with his unsupportive and squabbling parents; gang violence and inter-ethnic tensions in the local community; and his general restlessness and disillusionment with his life while feeling directionless and trapped in his working-class ethnic neighborhood. ► more information https://en.wikipedia.org/wiki/Saturday_Night_Fever | ["Disco", "Music"] | ["pop music", "disco", "male vocal", "melodic singing", "saxophone", "electronic drums", "percussion", "energetic", "danceable", "upbeat"] | 9 | u0lm58cet1g | 5084 |
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;