musiccaps_details (view)
6 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "sentimental" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- live performance · 6 ✖
- sentimental · 6 ✖
- melodic singing 3
- piano 3
- female vocal 2
- heart-touching 2
- male vocal 2
- orchestra 2
- acoustic drums 1
- bass guitar 1
- catchy tune 1
- classical music 1
- dramatic 1
- dreamy 1
- female choir 1
- flute 1
- french horn 1
- german romantic music 1
- grand piano 1
- groovy 1
- keyboard 1
- medium-to-high pitch singing 1
- melancholic 1
- orchestral rock 1
- piano sound 1
- poor quality 1
- pop music 1
- profound 1
- r&b 1
- rock opera 1
- slow tempo 1
- strings 1
- urban 1
- violin 1
musiccaps_names (array) 15 ✖
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 | |
Disturbed - The Sound of Silence [Live in Dawson Creek, BC, Canada] | This is the live performance of an orchestral rock piece. There is a male vocalist singing melodically in the lead. The piano is gently playing the main tune of the song. The tempo of the piece is slow. There is a profound, melancholic atmosphere. This piece could be used in the soundtrack of a drama movie/TV series. It could also be playing in the background at a rock/metal bar. | 2016-02-23T20:05:43Z | Disturbed | Recorded on February 19, 2016 at Encana Events Centre in Dawson Creek, BC, Canada. Download "The Sound of Silence" now: http://smarturl.it/immortalized Watch the official music video for "The Sound of Silence" - http://smarturl.it/disturbedtsos On tour now: http://disturbed1.com New album 'Evolution' out now: https://disturbed.lnk.to/evolution Connect with Disturbed: Official Website - http://disturbed1.com Facebook - http://facebook.com/disturbed Twitter - http://twitter.com/disturbed Instagram - http://instagram.com/disturbed Spotify - http://smarturl.it/disturbed.spotify Disturbed - The Sound of Silence [Live in Dawson Creek, NC, Canada] | ["Chant", "Music"] | ["live performance", "orchestral rock", "male vocal", "melodic singing", "piano", "sentimental", "melancholic", "profound", "slow tempo"] | 9 | 2o1p83UjJFA | 407 | |
Brandy Sings: "Long Distance" | This is a live performance of an R&B music piece. There is a female vocalist singing melodically in the lead. Three female supporting vocals can be heard singing in the back. The melody is being played by the piano while the bass guitar plays a groovy bass line. The rhythm is provided by an acoustic drum beat. The atmosphere is sentimental. This piece can be used in the soundtrack of a romance movie involving a couple in a long distance relationship. | 2008-12-10T19:16:12Z | CBS | Brandy performs the single "Long Distance" from her much anticipated album, "Human." | ["Singing", "Christian music", "Music"] | ["r&b", "live performance", "female vocal", "melodic singing", "female choir", "piano", "bass guitar", "acoustic drums", "sentimental", "groovy", "urban"] | 9 | 3u9OO9Og0Gc | 517 | |
2009文化盃音樂大賽 -決賽音樂會 | This is a German Romantic era music piece. It is being performed live, however the quality of the recording is poor with frequently occurring peak noise. The french horn is playing the main melody while the background consists of a steady grand piano tune. The piece has a heart-touching feel to it. | 2009-04-12T17:58:41Z | oyutan131 | 6. 史特勞斯:降E大調第一號法國號協奏曲作品11 Richard Strauss:Concerto No.1 in E flat major Op.11 法國號 / 劉品均 (第二名) | ["Brass instrument", "French horn"] | ["german romantic music", "live performance", "poor quality", "french horn", "grand piano", "sentimental", "heart-touching"] | 9 | NDJEKij2qOg | 2326 | |
Nicola Benedetti plays Bruch at the Last Night of the Proms 2012 | This is a live performance of a classical music piece. There is an orchestra performing the piece with a violin lead playing the main melody. The atmosphere is sentimental and heart-touching. This piece could be playing in the background at a classy restaurant. | 2012-09-10T19:04:24Z | ecodef | Violin concerto No. 1 in G minor, by Bruch soloist: Nicola Benedetti conductor: Jiri Belohlavek BBC Symphony Orchestra recorded @ the Royal Albert Hall, London (8 sept. 2012) | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["classical music", "live performance", "orchestra", "violin", "sentimental", "heart-touching"] | 9 | XmMN-6g1L8w | 3222 | |
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 |
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;