musiccaps_details (view)
4 rows where musiccaps_aspects contains "male mid range voice singing" and musiccaps_author = 6
This data as json, CSV (advanced)
| 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 | 徳永ゆうきのキャラクター・カピやんのご挨拶 ～中川家・礼二氏も絶賛した芸【指パッチン】 ～徳永ゆうきが「涙そうそう」をアカペラ歌唱。 みんなが待ってた、勇気の歌声！ ＮＨＫ「のど自慢2012 チャンピオン大会」グランドチャンピオンを 受賞した、演歌歌謡一直線・徳永ゆうき（１８才）の特別映像。 ５０年前にビルボード１位を獲得した「SUKIYAKI」にあやかって 映像シリーズを「TAKOYAKI」と命名、８月８日蛸の日にスタート。 第１回映像は、徳永ゆうきのキャラクター・カピやんのご挨拶～ 中川家・礼二氏も絶賛した芸【指パッチン】～「涙そうそう」歌唱。 ２０１３年１１月１３日には、ＢＥＧＩＮ・比嘉栄昇氏が手掛けた 作品で、全国デビューも決定！！ 勇気りんりん、徳永ゆうきを宜しくお願いします。 (徳永ゆうき HP) http://emirecords.jp/tokunaga/ | ["Finger snapping", "Music"] | ["amateur recording", "finger snipping", "male mid range voice singing", "reverb"] | 6 | -0vPFx-wRRI | 3 | |
| Robert Pattinson singing I'll be your lover too | someone is playing an acoustic guitar. Two chordshapes mostly played as single notes with some little hammering while a male voice sings. This song may be playing at a poetry open mic night. | 2009-01-26T22:12:53Z | temmazy | Robert Pattinson singing i'll be your lover too live with lyrics & great pictures ;) Plz Comment XoXo Temmazy | ["Music", "/t/dd00003"] | ["singer-songwriter", "acoustic guitar", "male mid range voice singing", "amateur recording", "slow tempo"] | 6 | 5jT_i7S9QSM | 689 | |
| Merle Haggard Blue Yodel #9 Standin' On The Corner | This seems to be a life recording because you can hear people in the background cheering. An electric bass is playing a bluesy bassline along with the drums holding a simple steady groove. One guitar is panned to the right side of the speakers playing chords while another e-guitar is playing a melody on the left side of the speakers. Both are fairly in the background. A male mid ranged voice is singing with a little reverb on his voice. This song may be playing life at a festival. | 2012-06-24T01:38:42Z | Lancuhsturcounty | Merle's live cover of a Jimmie Rodgers classic. From the album Rainbow Stew. Live in Anaheim Stadium in 1981. | ["Music", "Psychedelic rock", "Rock and roll"] | ["bluesrock", "e-bass", "background cheering", "guitars", "acoustic drums", "male mid range voice singing", "medium tempo"] | 6 | ZJZxWLYzNh8 | 3360 | |
| I Am the Very Model of a Modern Major-General | A male choir is at the end of a phrase before a single male voice takes over singing with a mid ranged opera voice along to a piano and an accordion. In the background the crowd is cheering,laughing and clapping. This song may be playing in a theater. | 2007-11-11T09:03:29Z | ThePenzancePirate | Gilbert and Sullivan's raucous operatic tale is captured in all its fun and glory in this production, recorded live at Central Park's Delacorte Theater. Kevin Kline sparkles as the swashbuckling and libidinous Pirate King while Linda Ronstadt makes her theatrical debut as the lovely and virginal Mabel. When Mabel and Frederic, a young pirate bound to serve the Pirate King, fall in love, complications arise and high spirited antics ensue. The incomparable cast offers the best in this boisterous romp. Despite some of the technical shortcomings of the DVD I found it more rewarding than the 1983 movie. I would thoroughly recommend adding a copy of this DVD to your library. | ["Applause", "Music"] | ["musical/opera", "male mid range voice singing", "acoustic piano", "accordion", "male choir", "background cheering and clapping", "uptempo", "comedic"] | 6 | zSGWoXDFM64 | 5477 |
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;