musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "animated" and musiccaps_aspects contains "male vocalist" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 82 ✖
- animated · 5 ✖
- male vocalist · 5 ✖
- fast tempo 3
- acoustic guitar 2
- home video 2
- simple melody 2
- vivacious 2
- alternative pop 1
- alternative rock 1
- amateur recording 1
- amateur singing 1
- auto harp 1
- auto tune 1
- banjo 1
- bass kazoo 1
- boomy 1
- cello 1
- cheerful 1
- childish lyrics 1
- children’s song 1
- concert 1
- country folk music 1
- country music 1
- educational 1
- energetic 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- fiddle 1
- fun 1
- funky bass 1
- funky bass line 1
- funny 1
- funny song 1
- galloping rhtyhm 1
- groovy bass 1
- guitar 1
- hard rock 1
- high energy 1
- homer simpson cover 1
- informative 1
- intense drumming 1
- intense electric guitar feedback 1
- kazoo lead 1
- keyboard accompaniment 1
- keyboard harmony 1
- learning 1
- live audience 1
- live performance 1
- lively 1
- lively backup 1
- lively vocals 1
- medium fast tempo 1
- medium tempo 1
- merry 1
- metal 1
- minimal instruments 1
- monotone singing 1
- off key singing 1
- progressive 1
- progressive metal 1
- regional music 1
- relatable 1
- rhythmic acoustic 1
- rock 1
- simple bass lines 1
- simple lyrics 1
- skilled guitarist 1
- sound of static 1
- spirited 1
- spirited vocals 1
- steady drumming 1
- superimposed instrumental 1
- vibrant 1
- vibrations 1
- vigorous 1
- vigorous bass lines 1
- vigorous keyboard harmony 1
- vital 1
- vivacious electric guitar harmony 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 14 ✖
- Music 5
- /t/dd00003 1
- Acoustic guitar 1
- Angry music 1
- Banjo 1
- Bluegrass 1
- Country 1
- Heavy metal 1
- Musical instrument 1
- Salsa music 1
- Song 1
- Steel guitar, slide guitar 1
- Strum 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 | |
Avantasia - Wastelands (Michael Kiske) | A male vocalist sings this high energy Rock song. The tempo is fast with enthusiastic and skilled bass guitar lines, intense, hard hitting drums, groovy electric guitar accompaniment and rhythmic keyboard. The song is youthful, animated, spirited, animated,vigorous, incredibly vital and vivacious. This song is Hard Rock/ Progressive metal. | 2010-03-24T12:02:47Z | Artem Reva | The new edition of Tobias Sammet's AVANTASIA will be released as two separate albums entitled "The Wicked Symphony" and "Angel Of Babylon". Status: Ready to be release. Record deal: Nuclear Blast Records. Album scheduled for release in April 3rd 2010. The Japanese edition on 31th March. Michael sings on "Stargazers", "Wastelands", "Runaway Train" and "Promised Land". | ["Heavy metal", "Music", "Angry music"] | ["male vocalist", "fast tempo", "hard rock", "vigorous bass lines", "youthful", "animated", "vigorous", "vital", "vivacious", "progressive", "metal", "progressive metal", "intense electric guitar feedback", "intense drumming", "funky bass line", "vigorous keyboard harmony", "spirited vocals", "rock", "hard rock", "skilled guitarist", "youthful", "vibrant"] | 7 | JRmfjBDKCpE | 2006 | |
Music - David Bowie Space Oddity/Major Tom | A male vocalist sings this soft pop. The tempo is medium with an acoustic guitar accompaniment and sound of static in the background. The song has simple lyrics and melody . It is informative and educational. This song is a Children’s song/Alternative Pop. | 2007-08-12T05:38:32Z | artcarver | The orchestra entrance section to the bridge - replaced with a climbing chord progression. See my Universal Records posting: http://www.unpredictableporridge.com/artist.aspx?id=589777ec-a379-4ae5-9b22-5956d51ee4bb | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["male vocalist", "medium tempo", "acoustic guitar", "boomy", "simple melody", "simple lyrics", "informative", "educational", "learning", "monotone singing", "home video", "amateur recording", "sound of static", "simple melody", "funny song", "children’s song", "alternative pop", "alternative rock", "animated", "simple melody", "minimal instruments"] | 7 | lIBsL97sUmY | 4390 | |
Kazoo bass slap | a male vocalist sings this enthusiastic swing pop. The tempo is fast with an enthusiastic electric guitar harmony, energetic drumming, funky bass lines, keyboard harmony, emphatic vocals superimposed by an infectious Bass kazoo melody. The song is energetic, enthusiastic, youthful, fun , groovy, vivacious and chirpy. | 2011-02-26T17:39:54Z | Magublican TV | http://fraserdaley.com | ["Music", "Salsa music"] | ["male vocalist", "fast tempo", "energetic drumming", "keyboard accompaniment", "vivacious electric guitar harmony", "groovy bass", "galloping rhtyhm", "funky bass", "kazoo lead", "bass kazoo", "vibrations", "superimposed instrumental", "lively", "spirited", "animated", "vivacious", "engaging", "energetic"] | 7 | ZFimyfPWltk | 3354 |
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;