musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "amateur singing" and musiccaps_names contains "Music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 62 ✖
- amateur singing · 4 ✖
- emotional 2
- home video 2
- male vocalist 2
- off key singing 2
- amateur drumming 1
- amateur guitarist 1
- animated 1
- auto tune 1
- cameras clicking 1
- chaotic 1
- childish lyrics 1
- christian worship 1
- crowds clapping 1
- crowds whistling 1
- dealing with depression 1
- dissonant keyboard 1
- dissonant music playing over song 1
- electric guitar riff 1
- encouraging crowd 1
- female singer 1
- female vocalist 1
- foreign language 1
- funny 1
- groovy background bass 1
- guitar 1
- guitar accompaniment 1
- home recording 1
- homer simpson cover 1
- inspiring 1
- intense drumming 1
- karaoke 1
- keyboard harmony 1
- live performance 1
- loneliness 1
- lullaby 1
- medium fast tempo 1
- mellow 1
- melodious background electric guitar harmony 1
- melodious background music 1
- motivational 1
- muffled recording 1
- music concert 1
- not in sync 1
- passionate 1
- poor audio quality 1
- praise and worship 1
- relatable 1
- rhythmic acoustic 1
- rhythmic background drumming 1
- romantic 1
- sentimental 1
- simple bass lines 1
- simple melody 1
- sleepy 1
- slow tempo 1
- soft 1
- song cover 1
- spirited 1
- steady drumming 1
- strong bass line 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
- Music · 4 ✖
- /t/dd00003 1
- Applause 1
- Crackle 1
- Rock and roll 1
- Roll 1
- Synthetic singing 1
- Ukulele 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 | ||
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
Still [Tagalog Version] | A female vocalist sings this emotional song. The tempo is slow with guitar accompaniment and vocal backup. The song is soft, mellow, emotional and sentimental in a foreign language that sounds like a lullaby.This is a Pop Folk song. | 2008-09-22T13:08:16Z | Carmina dela cruz | Eph 3:19, 20 Speak to one another with Psalms, hymns and spiritual songs. Sing and make music in your heart to the Lord. Always giving thanks to God and the Father for everything, in the name of our Lord Jesus Christ! ____________________________________________ sorry may konting sablay...but all honor and Glory to Jesus alone!! Words and music by Darlene Zchech [Hillsong] Tagalog Version by Richard bermudez and Carmina Dela cruz I do not own copyrights to translate these songs nor do I claim the melody as mine. I only translated them for my own enjoyment purposes. Thank You. | ["Music", "Ukulele"] | ["female vocalist", "slow tempo", "lullaby", "sleepy", "vocal harmony", "amateur guitarist", "amateur singing", "home recording", "muffled recording", "christian worship", "foreign language", "praise and worship", "soft", "mellow", "emotional", "sentimental"] | 7 | LEG7xkYOsWA | 2165 |
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;