musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "pop music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Sound Of Music - 02 Magic Night (1987) | This is a pop music piece with 80s characteristics. There is a female vocalist in the lead singing melodically. The main theme is played by a keyboard and an electric guitar at the same time in the major scale. There is a bass guitar and a medium-to-high range pad in the background. The rhythmic background is provided by a loud but simple acoustic drum beat. There is a maximalist, vibrant and energetic atmosphere. This piece could be used in the soundtrack of a romance movie. It could also fit very nicely as the soundtrack of an anime. | 2009-12-25T08:13:42Z | mixtis carminibus | Sound Of Music was a Swedish pop group who recorded two albums 1986-1987. Peter Grönvall, who wrote the music, is the son of Benny Andersson from Abba. The other two members were Nanne Grönvall and Angelique Widengren. | ["Music of Asia", "Music", "Exciting music"] | ["pop music", "80s pop", "female vocal", "melodic singing", "keyboard", "bass guitar", "electric guitar", "pad", "acoustic drums", "grandiose", "vibrant", "energetic", "high tempo"] | 9 | TN53jpjqAGI | 2833 | |
Acrobatic Rock and Roll - Europe championship 2009 - Foot technique | This is the live recording of a dance performance that uses a pop music piece as accompaniment. There is a male and a female vocalist singing melodically. The tune of the piece is being played by the electric guitar, the bass guitar and the synth. There is an upbeat acoustic drum beat in the rhythmic background. The audience can be heard clapping to the beat. The atmosphere is loud and lively. It could work well as the backing track in a modern dance course. | 2009-11-16T10:03:37Z | Tomáš Tlášek | RNR - Velika Gorica - 7.11.2009 - Foot technique - Ivan KLIMOV - Katrin GAZAZYAN (RUS), Lukas FURST - Alzbeta SLAMOVA (CZE), Maurizio MANDORINO - Jade MANDORINO (SUI), Jacek TARCZYLO - Anna MIADZIELEC (POL), Julien FOULON - Ingrid FOULON (FRA), Michael TRÜB - Stephanie RÜEGG (SUI), Neven IVIC - Ivana MIHALIC (CRO) | ["Music", "Roll", "Rock and roll"] | ["pop music", "dance", "male and female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "synth", "audience clapping", "loud", "lively", "catchy", "upbeat"] | 9 | ggBivmG6yHQ | 4045 | |
The Weeknd - The Hills [Cover by Twenty One Two] | This is a cover of a pop music piece. There is a male vocalist singing melodically. The melody is being played by the acoustic guitar and the electric guitar while the bass guitar is playing in the background. The rhythm is provided by a slow tempo acoustic drum beat. There is a mellow atmosphere in this piece. It could be used in the soundtrack of a drama TV series. | 2015-12-10T20:23:27Z | Twenty One Two | Download/Stream our cover of 'The Hills' by The Weeknd: iTunes: http://full.sc/1nbaTyR Spotify: http://full.sc/1OcaZ20 Loudr: http://full.sc/1nbaZXr The Hills Have Eyes... Hope you like our cover of The Weeknd's "The Hills" :) If you wanna see more videos from us in the future make sure to subscribe: http://full.sc/1iTcqQ4 Please help us share our cover videos with the world by posting them on your Facebook, Twitter, Tumblr etc. Every share helps us immensely, Thanks! Follow us on twitter, instagram, tumblr and facebook to keep up with all our shenanigans! https://twitter.com/twentyonetwose http://instagram.com/twentyonetwose http://twentyonetwose.tumblr.com https://www.facebook.com/twentyonetwose "The Hills" - originally by The Weeknd Written by: Ahmad Balshe, Carlo Montagnese, Emmanuel Nickerson, Abel Tesfaye Published by: The Weeknd XO, Inc., Manufactured and Marketed by Republic Records, a Division of UMG Recordings, Inc | ["Singing", "Independent music"] | ["cover", "pop music", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "mellow", "simple tune", "slow tempo"] | 9 | gkMbHlNAFig | 4052 | |
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 |
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;