musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur singing" and musiccaps_aspects contains "male vocalist" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 29 ✖
- amateur singing · 2 ✖
- male vocalist · 2 ✖
- off key singing 2
- amateur drumming 1
- animated 1
- auto tune 1
- chaotic 1
- childish lyrics 1
- dissonant keyboard 1
- dissonant music playing over song 1
- electric guitar riff 1
- funny 1
- groovy background bass 1
- guitar 1
- home video 1
- homer simpson cover 1
- intense drumming 1
- karaoke 1
- keyboard harmony 1
- medium fast tempo 1
- melodious background electric guitar harmony 1
- melodious background music 1
- not in sync 1
- relatable 1
- rhythmic acoustic 1
- rhythmic background drumming 1
- simple bass lines 1
- simple melody 1
- steady drumming 1
musiccaps_names (array) 5 ✖
- Music 2
- /t/dd00003 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 |
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;