musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- acoustic guitar · 5 ✖
- bass guitar · 5 ✖
- sentimental · 5 ✖
- acoustic drums 4
- melodic singing 4
- male vocal 3
- emotional 2
- alternative 1
- alternative rock 1
- chimes 1
- clarinet 1
- easygoing 1
- electric guitar 1
- electronic drums 1
- female vocal 1
- folk rock 1
- hmong pop 1
- indie 1
- longing 1
- malaysian 1
- melancholic 1
- mellow 1
- melodic pad 1
- minor key 1
- normal tempo 1
- piano 1
- pop rock 1
- romantic 1
- simple tune 1
- soap opera theme 1
- strings 1
musiccaps_names (array) 7 ✖
- Music 4
- Christian music 1
- Exciting music 1
- Independent music 1
- Sad music 1
- Song 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tengku Adil - Babak Cinta Official Music Video HD | This is a Malaysian alternative rock music piece. There is a male vocalist singing melodically at the forefront. The main melody is played by the acoustic guitar with the backing of a mellow electric guitar and a simple bass line on the bass guitar. The rhythmic background consists of a basic rock acoustic drum beat. There is a sentimental and easygoing atmosphere to this piece. It could be used in the soundtrack of a drama/romance movie or TV series that takes place in Malaysia. | 2012-02-18T09:35:21Z | tengkuadilmusic | Official Music Video for Babak Cinta. Artiste: Tengku Adil Song: Babak Cinta Director: Helmie Ezfar Production Team: Paint In Motion Studios Location: http://www.morningrocket.com and http://kamarseni.com For bookings and enquiries email to: music.tengkuadil@gmail.com Kord Lagu Verse - D Bm Em Gm Chorus - D Bm Em-Gm Bridge - Bm D G A Solo - Bb C D, Bb C A Outro - D F#m G A# | ["Music", "Wedding music"] | ["malaysian", "alternative rock", "indie", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "sentimental", "easygoing", "mellow"] | 9 | 1BVSYfNCcv0 | 246 | |
Dota heroes sexy | This is a pop rock piece. There is a female vocalist singing melodically at the forefront. The melody is being played by a wide-sounding strings section and an acoustic guitar. The bass guitar is playing the root notes in the background. The rhythmic structure is provided by a simple acoustic drum beat. The song is in minor key. The atmosphere is sentimental and filled with longing. This piece could be included in the soundtrack of a teenage drama movie or TV series. | 2010-02-13T16:45:07Z | elbertjann benitez | the best hero and my favorite hero my favorite is mirana the best hero of me ^^ | ["Christian music"] | ["pop rock", "female vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "longing", "minor key"] | 9 | 5P5XAclO8ko | 659 | |
"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 | |
wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 | |
Ab Tere Bin Hum Bhi Jee Lenge from AURANGZEB | This is a soap opera theme music. There is a clarinet playing the main tune with the acoustic guitar and the bass guitar in the backing. There is a melodic pad that can be heard. An acoustic sounding electronic cymbal and wind chimes strokes are playing every now and then. There is a sentimental atmosphere to this piece. | 2010-09-16T12:47:18Z | AB Shah Ahmad | very nice song | ["Music", "Sad music"] | ["soap opera theme", "acoustic guitar", "clarinet", "bass guitar", "melodic pad", "electronic drums", "chimes", "sentimental", "emotional"] | 9 | sMNuJy4f4A0 | 4944 |
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;