musiccaps_details (view)
3 rows where musiccaps_aspects contains "off key singing" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- off key singing · 3 ✖
- amateur singing 2
- karaoke 2
- male vocalist 2
- amateur drumming 1
- amateur recording 1
- animated 1
- auto tune 1
- chaotic 1
- childish lyrics 1
- dissonant keyboard 1
- dissonant music playing over song 1
- electric guitar riff 1
- enthusiastic 1
- female singer 1
- foreign language 1
- funny 1
- groovy background bass 1
- guitar 1
- home video 1
- home videos 1
- homer simpson cover 1
- incoherent music 1
- inferior audio quality 1
- intense drumming 1
- keyboard harmony 1
- medium fast tempo 1
- medium tempo 1
- melodious background electric guitar harmony 1
- melodious background music 1
- not in sync 1
- piano accompaniment 1
- relatable 1
- rhythmic acoustic 1
- rhythmic background drumming 1
- simple bass lines 1
- simple melody 1
- steady drumming 1
- violin harmony 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- /t/dd00003 1
- /t/dd00004 1
- Music of Asia 1
- Rock and roll 1
- Roll 1
- Synthetic singing 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 | |
Homer Simpson singing poker face | A male vocalist sings this animated song. The tempo is medium fast with keyboard harmony, acoustic guitar , steady drumming and simple bass lines. The song is simple, catchy, funny, spirited, animated and easy to sing along. The lyrics are funny. | 2012-05-22T09:02:36Z | Mindaugas Paskauskas | ["Music", "/t/dd00003", "Synthetic singing"] | ["male vocalist", "medium fast tempo", "off key singing", "relatable", "simple melody", "funny", "homer simpson cover", "home video", "amateur singing", "animated", "childish lyrics", "keyboard harmony", "steady drumming", "simple bass lines", "auto tune", "rhythmic acoustic", "guitar"] | 7 | 4W8IZxn3nEI | 581 | ||
ジョウネツ | 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;