musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "melancholic" and musiccaps_aspects contains "melodic singing" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- melancholic · 4 ✖
- melodic singing · 4 ✖
- acoustic drums 2
- acoustic guitar 2
- bass guitar 2
- electric guitar 2
- keyboard 2
- male vocal 2
- sentimental 2
- alternative 1
- electronic drums 1
- emotional 1
- female vocal 1
- folk rock 1
- groovy 1
- haunting 1
- japanese pop 1
- neo-soul 1
- pop music 1
- r&b 1
- romantic 1
- simple drum track 1
- slow tempo 1
- strong bass 1
- teen female vocal 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Singing Chasing Pavements | This is an amateur vocal cover of a pop music piece. There is a teen female vocalist singing melodically. On the backing track, an acoustic guitar is heard playing the main theme while an acoustic sounding drum track is playing the rhythmic background. The atmosphere is melancholic. | 2008-11-14T00:46:48Z | alyssa bernal | I think it's safe to say that this is one of my favorite songs now. I love it man! geeze. baha. Okay random. freakin love y'all;; lyss | ["Music", "/t/dd00004"] | ["pop music", "teen female vocal", "melodic singing", "acoustic guitar", "simple drum track", "melancholic", "emotional"] | 9 | 1RhYdQnZ_hw | 274 | |
september rain | This is a Japanese pop music piece. The music has a 70s feel to it. There is a female vocalist singing melodically at the forefront. There is a keyboard playing a melody while being backed by an electric guitar and a bass guitar. There is a simple acoustic drum beat in the rhythmic background. The piece has a melancholic, haunting atmosphere to it. This piece could be used in drama movies and TV series that take place in Japan. | 2007-06-22T14:57:44Z | kklichiang | kugatsu__ame | ["Music", "Independent music"] | ["japanese pop", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "melancholic", "haunting", "romantic"] | 9 | Uxyu3XwXEV8 | 2963 | |
"2 Stroke" by RYDE Music Video | This is a folk rock/alternative music piece. There is a male vocalist singing melodically in the lead. The main tune is played by the acoustic guitar with a rather quiet bass line in the background. There is a timid acoustic drum beat in the rhythmic background. The atmosphere is sentimental and melancholic. This piece could be used in the soundtrack of a drama TV series, especially during a scene where the episode would end with the characters daydreaming. | 2006-10-23T02:12:48Z | ctheojr450 | For the MP3 of this song, visit www.myspace.com/rydewithus | ["Music", "Exciting music"] | ["folk rock", "alternative", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "melancholic"] | 9 | echeYDYFhlY | 3886 | |
OFFICIAL VIDEO: "Dealing" featuring Lalah Hathaway | This is an R&B/neo-soul music piece. There is a male vocalist in the lead singing melodically. The main tune is being played by the electric guitar and the keyboard. There is a strong and groovy bass sound. The rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a romantic comedy movie that takes place in the big city, especially during the scenes where a character is going through the feeling of heartbreak. | 2009-12-19T06:08:47Z | Eric Roberson | "Dealing" feat. Lalah Hathaway Directed by Impakt Studio (Chris & Blaq) www.ericrobersonmusic.com www.impaktstudio.com www.lalahhathaway.com | ["Singing", "Rhythm and blues"] | ["r&b", "neo-soul", "male vocal", "melodic singing", "keyboard", "electric guitar", "strong bass", "electronic drums", "slow tempo", "groovy", "sentimental", "melancholic"] | 9 | lAMiOhScSPg | 4378 |
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;