musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance" and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- live performance · 3 ✖
- bass guitar 1
- crowd singing 1
- dramatic 1
- dreamy 1
- electric guitar 1
- electronic drums 1
- electronic percussion 1
- emotional 1
- female vocal 1
- flute 1
- keyboard 1
- low quality 1
- male vocal 1
- medium-to-high pitch singing 1
- mellow piano chords 1
- melodic singing 1
- orchestra 1
- passionate 1
- piano 1
- pop 1
- religious 1
- reverberant soft male vocal 1
- rock opera 1
- sentimental 1
- soulful 1
- strings 1
musiccaps_names (array) 4 ✖
- Music 3
- Sad music · 3 ✖
- Singing 2
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Han Kyung-il - Sad invitation, 한경일 - 슬픈 초대장, Music Camp 20030830 | The low quality recording features a live performance of a pop song that contains a reverberant soft male vocal singing over mellow piano chords. There are crowd singing noises in the background. It sounds soulful, passionate and emotional. | 2012-04-16T01:06:53Z | MBCkpop | Han Kyung-il - Sad invitation, 한경일 - 슬픈 초대장, Music Camp(음악캠프), 193회, EP193, 2003/08/30, MBC TV, South Korea | ["Music", "Sad music"] | ["low quality", "live performance", "pop", "reverberant soft male vocal", "crowd singing", "mellow piano chords", "soulful", "passionate", "emotional"] | 4 | Xl4RSHQsnl8 | 3220 | |
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 | |
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;