musiccaps_details (view)
6 rows where musiccaps_aspects contains "keyboard", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "melodic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- keyboard · 6 ✖
- live performance · 6 ✖
- melodic singing · 6 ✖
- bass guitar 3
- emotional 3
- male vocal 3
- acoustic drums 2
- electronic drums 2
- pop music 2
- religious 2
- acoustic sounding drums 1
- amateur recording 1
- boy band 1
- catchy tune 1
- christian music 1
- crowd cheering 1
- dance pop 1
- dance-pop 1
- easygoing 1
- electric guitar 1
- electronic percussion 1
- female vocal 1
- female vocals 1
- generic 1
- gospel 1
- harp sound 1
- k-pop 1
- korean 1
- male vocals 1
- piano sound 1
- reggae 1
- repeated theme 1
- sentimental 1
- simple tune 1
- slow tempo 1
- spiritual 1
- tear-jerking 1
- upbeat 1
musiccaps_names (array) 13 ✖
- Music 5
- Singing 4
- Ambient music 1
- Choir 1
- Electric piano 1
- Exciting music 1
- Gospel music 1
- Keyboard (musical) 1
- Music of Asia 1
- Piano 1
- Reggae 1
- Sad music 1
- Song 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 | |
Yaweh(Official Video HD)- Ausward 2014 | This is a Christian gospel music piece. There is a male vocalist singing melodically and in an emotion-filled manner. The keyboard is playing the melody with a harp sound while the rhythmic background consists of a simple acoustic sounding drum beat that is only played on the hi-hats. The atmosphere is spiritual. This piece could be playing in the background at a Christian religious event. | 2014-03-08T09:11:01Z | Sfe Productions | Artist: Ausward Title: Yaweh Video by Bezariel Mwanza for Sound Factory Entertainment. For more information contact 0977751165 or 0966963340. | ["Singing", "Gospel music", "Music", "Song", "Choir"] | ["gospel", "christian music", "live performance", "crowd cheering", "male vocal", "melodic singing", "keyboard", "harp sound", "acoustic sounding drums", "religious", "spiritual", "emotional"] | 9 | AVogdV8khxc | 1128 | |
Goldfinger - Spice *LIVE* performance at Reggae Sumfest 2009 | This is the live performance of a reggae piece. There is a female vocalist in the lead singing melodically. The keyboard can be heard playing the main melody. The bass guitar is playing a simple but groovy bass line. In the rhythmic background, there is a slow tempo acoustic drum beat. The atmosphere is emotional. This is an amateur recording and a bit dated, so the audio quality is quite poor. | 2009-07-31T17:41:45Z | Chris Goldfinger | Spice it up! Spice live on stage at Reggae Sumfest 2009 | ["Singing", "Music", "Reggae", "Ambient music"] | ["reggae", "live performance", "amateur recording", "female vocal", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "emotional", "slow tempo"] | 9 | Cn3xoxvbkF0 | 1401 | |
[Comeback Stage] GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨, Show Music core 20150711 | This is a K-pop music piece being performed live by a girl group. There are female vocals singing melodically. There is a keyboard playing a simple and repeated theme. The rhythmic background consists of a danceable electronic drum beat. The atmosphere is easygoing. This piece could be playing in the background at a clothing store. | 2015-07-11T07:45:45Z | MBCkpop | Music core 20150711 GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨 ▶Show Music Core Official Facebook Page - https://www.facebook.com/mbcmusiccore | ["Music of Asia", "Music"] | ["k-pop", "dance pop", "korean", "live performance", "female vocals", "melodic singing", "keyboard", "electronic drums", "simple tune", "repeated theme", "generic", "easygoing", "upbeat"] | 9 | CretxKgW4Jk | 1408 | |
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 | |
hebron song ''gorepilla'' sung by brp.p.suresh, music by bro.stephen | This is a live performance of a religious song. There is a male vocalist singing melodically as the lead. The main melody is being played by the keyboard with the electric guitar and the bass guitar in the background. The rhythmic background is provided by the electronic drums and the electronic percussion. The piece has movements reminiscent of Jewish music. | 2015-05-01T09:06:39Z | Dr. Suresh David | ["Singing", "Music", "Sad music"] | ["live performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "electronic percussion", "keyboard", "religious"] | 9 | teyDfFbVMSY | 5056 |
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;