musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- groovy bass line · 5 ✖
- romantic · 5 ✖
- story telling · 5 ✖
- hip hop dance music 3
- hip hop music 3
- male singer 3
- medium tempo 3
- emotional 2
- exciting 2
- female singer 2
- groovy rhythm 2
- guitar rhythm 2
- love song 2
- male backup singers 2
- passionate 2
- adventurous 1
- animated singing 1
- backup singers 1
- cheerful 1
- dance rhythm 1
- distorted guitar lead 1
- emphatic vocals 1
- energetic 1
- energetic acoustic guitar 1
- groovy music 1
- head bangers 1
- high spirits 1
- inspiring 1
- jealous 1
- keyboard accompaniment 1
- keyboard harmony 1
- life is good 1
- life lessons 1
- lively piano accompaniment 1
- medium fast tempo 1
- melancholic 1
- modern hip hop hits 1
- modern love 1
- motivational 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- people dancing 1
- people screaming 1
- poor audio quality 1
- positive 1
- rapping vocals 1
- reggae hip hops music 1
- relaxing playlists 1
- retro classic rock 1
- retro dance hits 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- screaming vocals 1
- self discovery 1
- sentimental 1
- slow tempo 1
- spirited 1
- spirited spanish guitar 1
- steady percussive rhythm 1
- string harmony 1
- string symphony 1
- vibrant ukelele harmony 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 13 ✖
- Music 4
- Rhythm and blues 2
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Reggae 1
- Rock music 1
- Singing 1
- Song 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 | ||
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;