musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "reverb"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- amateur recording · 2 ✖
- reverb · 2 ✖
- acoustic guitar 1
- amateur singer 1
- backup harmony 1
- emotional 1
- finger snipping 1
- foreign language 1
- karaoke 1
- keyboard harmony 1
- male mid range voice singing 1
- male singer 1
- medium tempo 1
- mellow 1
- pop 1
- sentimental 1
- soft 1
- steady drumming 1
- straight bass lines 1
- violin harmony 1
- violin symphony 1
- vocal backup 1
musiccaps_names (array) 4 ✖
- Music 2
- Christmas music 1
- Finger snapping 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
徳永ゆうき - 「涙そうそう~指ぱっちん編~」 | a male voice is singing a melody with changing tempos while snipping his fingers rhythmically. The recording sounds like it has been recorded in an empty room. This song may be playing, practicing snipping and singing along. | 2013-08-08T10:46:43Z | UNIVERSAL MUSIC JAPAN | 徳永ゆうきのキャラクター・カピやんのご挨拶 ~中川家・礼二氏も絶賛した芸【指パッチン】 ~徳永ゆうきが「涙そうそう」をアカペラ歌唱。 みんなが待ってた、勇気の歌声! NHK「のど自慢2012 チャンピオン大会」グランドチャンピオンを 受賞した、演歌歌謡一直線・徳永ゆうき(18才)の特別映像。 50年前にビルボード1位を獲得した「SUKIYAKI」にあやかって 映像シリーズを「TAKOYAKI」と命名、8月8日蛸の日にスタート。 第1回映像は、徳永ゆうきのキャラクター・カピやんのご挨拶~ 中川家・礼二氏も絶賛した芸【指パッチン】~「涙そうそう」歌唱。 2013年11月13日には、BEGIN・比嘉栄昇氏が手掛けた 作品で、全国デビューも決定!! 勇気りんりん、徳永ゆうきを宜しくお願いします。 (徳永ゆうき HP) http://emirecords.jp/tokunaga/ | ["Finger snapping", "Music"] | ["amateur recording", "finger snipping", "male mid range voice singing", "reverb"] | 6 | -0vPFx-wRRI | 3 | |
Thien kong nyit cie jiu ko ho ( Hakka song ) | A male vocalist sings this soft melody. The song is medium tempo, with violin harmony, steady drumming, straight bass lines, acoustic guitar and keyboard accompaniment with vocal backup. The song is in a foreign language. It is slow, and has a mellow, soft, emotional , sentimental and romantic vibe. This is a regional Pop song. | 2007-11-02T14:18:16Z | HakkaNyinXmantan | hakka love song | ["Christmas music", "Music", "Song"] | ["male singer", "medium tempo", "foreign language", "steady drumming", "keyboard harmony", "straight bass lines", "acoustic guitar", "vocal backup", "violin harmony", "violin symphony", "emotional", "sentimental", "mellow", "soft", "reverb", "backup harmony", "karaoke", "amateur recording", "amateur singer", "soft", "mellow", "emotional", "sentimental", "pop"] | 7 | MZhaDGgULtc | 2281 |
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;