musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "low quality" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- emotional · 2 ✖
- low quality · 2 ✖
- acoustic guitar melody 1
- acoustic rhythm guitar 1
- childish female vocal 1
- crowd cheering 1
- echoing passionate male vocal 1
- folk 1
- joyful 1
- live performance 1
- mono 1
- noisy 1
- passionate 1
- sustained strings melody 1
- whistling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 | ||
【みくれれ】風になる~Full version~ | The low quality recording features a childish female vocal singing over acoustic rhythm guitar. It is a bit noisy and in mono, it sounds emotional and like a background song for some video game.. | 2011-02-14T15:10:24Z | Mikulele P | 初音ミクがウクレレでアニソンを弾き語ります。 3年目に突入の第57弾は再び「猫の恩返し」から 主題歌をリメイクしてみました。 この曲はウクレレ弾きのバイブルだけあって みくれれ内での人気も高いのですが、初期作品だけに 調教、伴奏、システムと全ての面で残念な部分も多く 何とかしたいとは思っていました。 コードも微妙に違ってるっぽいし・・・(苦笑) でもまぁ、ただリメイクしてもつまらないので 今回は2周年記念の特別企画として みくれれ初のフルサイズバージョンでお届けします。 ストラムもできるだけ原曲に忠実に再現してみましたが、 さすがにウクレレ一本だといささか単調かも? *Mikulele: "Kazeni Naru" A song from "The Cat Returns" *Chords:http://d.hatena.ne.jp/chiefer/20080427 | ["Music of Asia", "Music", "Ukulele"] | ["childish female vocal", "acoustic rhythm guitar", "noisy", "mono", "low quality", "emotional"] | 4 | p_dE26TA8ig | 4723 |
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;