musiccaps_details (view)
5 rows where musiccaps_aspects contains "keyboard", musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- keyboard · 5 ✖
- melodic singing · 5 ✖
- pop music · 5 ✖
- bass guitar 4
- acoustic drums 3
- male vocal 3
- electric guitar 2
- emotional 2
- female vocal 2
- live performance 2
- sentimental 2
- vibrant 2
- 80s feel 1
- 80s pop 1
- amp 1
- ballad 1
- boy band 1
- catchy tune 1
- dance-pop 1
- electronic drums 1
- energetic 1
- female back vocal 1
- grandiose 1
- high tempo 1
- male vocals 1
- medium tempo 1
- pad 1
- piano sound 1
- reverb 1
- romantic 1
- simple tune 1
- slow tempo 1
- strings 1
- tear-jerking 1
musiccaps_names (array) 11 ✖
- Music 4
- Singing 3
- Exciting music 2
- Music of Asia 2
- Electric piano 1
- Independent music 1
- Keyboard (musical) 1
- Piano 1
- Pop music 1
- Radio 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mika live at Virgin Radio 2007 | This is a live performance of a pop music piece. There is a male vocalist singing melodically in the lead. There is a catchy tune that is being performed on a keyboard with a piano sound.The atmosphere is sentimental. This piece could be used in the soundtrack of a romantic comedy movie, especially during the scenes where the characters are starting to fall in love with each other. | 2007-03-19T11:53:31Z | annamurmur | Mika live at Virgin Radio Zoo Session. Songs: My Interpretation, Love Today and Grace Kelly. | ["Electric piano", "Keyboard (musical)", "Piano"] | ["pop music", "live performance", "male vocal", "melodic singing", "keyboard", "piano sound", "sentimental", "catchy tune"] | 9 | 2bcnAoZbptI | 388 | |
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 | |
Graham Bilbrough of Child singing The Answer To The Everything | This is a pop music ballad piece. There is a male vocal singing melodically in the lead with a female back vocal singing at a higher pitch in the background. The melodic background consists of the strings, the keyboard and the bass guitar. There is a 6/8 slow tempo acoustic drum beat in the rhythmic background. The piece has an emotional atmosphere. This piece could be used in a romantic setting such as a slow dance night event or a wedding. It could also be used in the soundtrack of a romance movie. | 2011-01-23T12:39:23Z | Eleanor Bilbrough | Graham Bilbrough/ Ricky Graham of Child singing The Answer To The Everything | ["Singing", "Music", "Independent music"] | ["pop music", "ballad", "80s feel", "male vocal", "melodic singing", "female back vocal", "strings", "keyboard", "bass guitar", "acoustic drums", "romantic", "emotional", "slow tempo"] | 9 | OpWCljke4oQ | 2473 | |
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 | |
N'Sync - Selfish | This is the live recording of a boy band performing a pop music piece. The male vocals are singing melodically. There is a keyboard and a bass guitar playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is emotional. This piece could be included in the soundtrack of a teenage romance/drama movie. | 2007-07-24T07:50:18Z | Yan Chat | N'Sync - Selfish... N'Sync Popodyssey Live... | ["Singing", "Music", "Exciting music"] | ["live performance", "pop music", "dance-pop", "boy band", "male vocals", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "emotional", "tear-jerking"] | 9 | kw2wPVxUgQY | 4367 |
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;