musiccaps_details (view)
5 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate" and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- emotional 5
- low quality · 5 ✖
- passionate · 5 ✖
- mellow piano chords 2
- sad 2
- sustained strings melody 2
- background music 1
- classical 1
- crowd singing 1
- cymbal riser 1
- heartfelt 1
- live performance 1
- low brass melody 1
- mellow marimba melody 1
- mellow piano melody 1
- mellow woodwinds melody 1
- passionate male vocal 1
- pop 1
- punchy kick 1
- reverberant soft male vocal 1
- shimmering hi hats 1
- snappy rimshots 1
- soft bass 1
- soft wide strings melody 1
- soulful 1
- suspenseful 1
- woodwind melody 1
musiccaps_names (array) 3 ✖
- Music 5
- Sad music · 5 ✖
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Googoosh Music Academy من همینم | The low quality recording features a passionate male vocal singing over mellow piano chords, shimmering hi hats, snappy rimshots, punchy kick and soft bass. It sounds emotional, passionate and heartfelt. | 2010-11-04T20:15:13Z | manototv | آکادمی موسیقی گوگوش 2010 اجرای گروهی «من همینم» آهنگساز : بابک سعیدی ترانه سرا : رها اعتمادی کارگردانان و خوانندگان به ترتیب حروف الفبا ارسلان ارغوان امیر سارا سروش فروغ کسرا هاله http://www.manoto1.com manoto1 Hotbird Frequency: 11317 Vertical Symbole Rate: 27500 | ["Music", "Sad music"] | ["low quality", "snappy rimshots", "shimmering hi hats", "mellow piano chords", "soft bass", "punchy kick", "passionate male vocal", "emotional", "passionate", "heartfelt"] | 4 | 1YPYQP6yupA | 286 | |
Top 10 Most Dangerous Animals | The low quality recording features a classical song that consists of a soft wide strings melody, followed by mellow woodwinds melody and low brass melody. There is a short snippet of a cymbal riser at the very end of the loop. It sounds passionate, emotional and suspenseful. | 2009-04-04T16:07:11Z | Angelo Ierullo | Top 10 . These weights are totally bogus, I was a tad nuts the day I made the video. | ["Music", "Sad music"] | ["classical", "low quality", "soft wide strings melody", "mellow woodwinds melody", "low brass melody", "cymbal riser", "passionate", "emotional", "suspenseful"] | 4 | 3PuzzYmTDA4 | 464 | |
Pasti menangis saat menonton video sedih ini - Kabar dari ayah | The low quality recording features a mellow piano melody playing over sustained strings melody. It sounds sad, emotional and passionate. | 2014-12-30T00:00:23Z | Onino Mansah | Video mengharukan tentang Ayah yang menitipkan kabar untuk anaknya. Saya buat video ini ketika menunggu Abah, Drs H.M.Sulaeman Nawawi dirawat di Rumah Sakit selama hampir satu bulan karena infeksi lambung. Kini beliau sudah berpulang ke rahmatullah pada tanggl 19 Januari 2015 di usia yang ke 70 tahun. Selamat jalan Abah.. Kemuliaanmu selalu menginspirasiku. Semoga Allah memberikan tempat terbaik untukmu | ["Music", "Sad music"] | ["low quality", "mellow piano melody", "sustained strings melody", "sad", "emotional", "passionate"] | 4 | AgJH6Ul1EFg | 1153 | |
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 | |
22- Cry (The Holiday) | The low quality recording features a sustained string melody, followed by woodwind and mellow marimba melodies. It sounds emotional, passionate and sad - like something you would hear in the movies, as the background music. | 2009-04-10T11:23:48Z | filmfreak14 | music by Hans Zimmer | ["Music", "Sad music", "Tender music"] | ["low quality", "sustained strings melody", "woodwind melody", "mellow marimba melody", "emotional", "passionate", "sad", "background music"] | 4 | _Rpn2FUAUgY | 3470 |
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;