musiccaps_details (view)
4 rows where musiccaps_aspects contains "karaoke" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- karaoke · 4 ✖
- amateur recording 3
- medium tempo 3
- violin harmony 3
- female singer 2
- foreign language 2
- inferior audio quality 2
- keyboard harmony 2
- off key singing 2
- vocal backup 2
- acoustic guitar 1
- amateur drumming 1
- amateur singer 1
- amateur singing 1
- backup harmony 1
- chaotic 1
- dissonant keyboard 1
- dissonant music playing over song 1
- electric guitar riff 1
- emotional 1
- emphatic vocals 1
- enthusiastic 1
- enthusiastic drumming 1
- groovy background bass 1
- home recording 1
- home videos 1
- incoherent music 1
- intense drumming 1
- loud vocals 1
- male singer 1
- male vocalist 1
- mellow 1
- melodious background electric guitar harmony 1
- melodious background music 1
- not in sync 1
- piano accompaniment 1
- pop 1
- reverb 1
- rhythmic background drumming 1
- sentimental 1
- soft 1
- steady drumming 1
- straight bass lines 1
- violin symphony 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 4
- /t/dd00004 2
- Song 2
- /m/02zsn 1
- Christmas music 1
- Music of Asia 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Eric Clapton I've Got a Rock and Roll Heart Shreds | A male vocalist sings this song. The tempo is slow, with intense drumming; keyboard harmony, groovy bass lines and electric guitar harmony in the background. The vocalist is singing a dissonant tune along with syncopated music over the melodious and rhythmic background. This is probably karaoke. | 2010-01-30T00:00:05Z | boilingsand | Featuring Billy Joel during the middle portion. With respect to the great EC and Billy Joel, and also to StSanders. | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "electric guitar riff", "intense drumming", "melodious background music", "rhythmic background drumming", "groovy background bass", "melodious background electric guitar harmony", "dissonant music playing over song", "dissonant keyboard", "karaoke", "amateur singing", "amateur drumming", "chaotic", "off key singing", "not in sync"] | 7 | 2BGzxAuetOA | 340 | |
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 | |
Me singing: I'll Make A Man Out Of You [yeah! Female version!XD] | A female vocalist sings this enthusiastic song.The tempo is medium with loud , emphatic vocals and subdued music in the background .The song is a karaoke with enthusiastic drumming, melodious violin harmony, keyboard accompaniment, groovy bass line and rhythmic acoustic guitar. | 2009-11-29T00:14:20Z | Nekokumagoro | Just for fun!^^ I sung in the last 5 minutes before I going to go sleep^^ Enjoy Rights: Disney Videorights: Kingdom Hearts(c) Square enix Karaoke by HopefulActress09 | ["/m/02zsn", "Music", "Song", "/t/dd00004"] | ["female singer", "medium tempo", "karaoke", "loud vocals", "enthusiastic drumming", "keyboard harmony", "violin harmony", "home recording", "amateur recording", "emphatic vocals", "inferior audio quality"] | 7 | gEvCUcZ6w88 | 4019 | |
ジョウネツ | A female vocalist sings this pop song in a foreign language. The tempo is medium with karaoke music and vocal backup. The audio quality is inferior and the music is incoherent except for a violin harmony and piano accompaniment. This song is an amateur home video. | 2007-11-26T14:12:35Z | yupanntu | 熱い~ よっ釣れた(笑) | ["Music of Asia", "Music", "/t/dd00004"] | ["female singer", "medium tempo", "foreign language", "violin harmony", "piano accompaniment", "karaoke", "off key singing", "vocal backup", "incoherent music", "amateur recording", "inferior audio quality", "enthusiastic", "youthful", "home videos"] | 7 | jKWl63gozLE | 4246 |
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;