musiccaps_details (view)
5 rows where musiccaps_aspects contains "sentimental" and musiccaps_aspects contains "strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- sentimental · 5 ✖
- strings · 5 ✖
- piano 4
- melodic singing 3
- acoustic drums 2
- bass guitar 2
- female vocal 2
- flute 2
- male vocal 2
- acoustic guitar 1
- armenian 1
- ballad 1
- christian music 1
- crying 1
- dramatic 1
- dreamy 1
- emotional 1
- female voice 1
- gospel 1
- heart-touching 1
- hindi film music 1
- live performance 1
- longing 1
- medium-to-high pitch singing 1
- minor key 1
- orchestra 1
- pop music 1
- pop rock 1
- religious 1
- rock opera 1
- romantic 1
- sitar 1
- slow tempo 1
- spiritual 1
- wedding 1
musiccaps_names (array) 8 ✖
- Music 4
- Christian music 1
- Music of Asia 1
- Sad music 1
- Singing 1
- Traditional music 1
- Vocal music 1
- Wedding music 1
youtube_published (date) 5 ✖
- 2008-07-10 1
- 2010-02-13 1
- 2010-03-02 1
- 2012-10-16 1
- 2014-09-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Harut Hagopian - Du Batsvel Es Varti Nman - Armenian Music (Wedding Song) | This is an Armenian pop music ballad piece. The male vocalist is singing in a sentimental manner. The melody is being played by the piano and the strings section while the bass guitar plays a simple bass line composed of root notes. The rhythmic background is provided by a 6/8 slow tempo acoustic drum beat. The atmosphere is romantic. This piece would fit perfectly in an Armenian wedding. It could also be included in the soundtrack of a romance movie that takes place in Armenia. | 2010-03-02T05:42:21Z | Avik Hagopian | A classic! | ["Music", "Wedding music"] | ["armenian", "pop music", "ballad", "male vocal", "melodic singing", "piano", "strings", "bass guitar", "acoustic drums", "sentimental", "romantic", "wedding", "slow tempo"] | 9 | PF5LgwJjYuA | 2519 | |
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 | |
Dil Tujhe Dia Tha... (Malhar) | This is a Hindi film music piece. Initially, there is a female voice crying. Afterwards, an orchestra made up of a flute, a string element, a sitar and a piano starts playing an emotional tune. The atmosphere of the piece is heart-touching. It could be used in the soundtracks of Bollywood movies during heartbreaking scenes. | 2008-07-10T00:15:10Z | IMIRZA777 | oldie. | ["Traditional music", "Music"] | ["hindi film music", "female voice", "crying", "flute", "strings", "sitar", "piano", "sentimental", "emotional", "heart-touching"] | 9 | nnc6m1pBJ4c | 4578 | |
The City Harmonic (Feat. JJ Heller) - Holy (Wedding Day) (Official Music Video) | This is a Christian gospel music. There is a male vocalist singing melodically. The melody is being played by the piano with a strings section accompaniment. The atmosphere is spiritual and sentimental. This piece could be playing in the background of Christian social media content. | 2012-10-16T21:00:28Z | thecityharmonic | From the 2013 JUNO-Award Winning Album "I Have A Dream (It Feels Like Home)" https://itunes.apple.com/ca/album/i-have-dream-it-feels-like/id555277322 Recorded Live on the I HAVE A DREAM TOUR in Glendale, AZ running through November 2012 in select cities. Tickets at http://ihaveadrea m.thecityharmonic.com Directed by Britton Foster Produced by Caleb Kuhl Black & White Short Film created by Cross Point Creative | ["Music", "Vocal music"] | ["gospel", "christian music", "male vocal", "melodic singing", "piano", "strings", "religious", "spiritual", "sentimental"] | 9 | vWM2qG-nU-Y | 5187 |
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;