musiccaps_details (view)
3 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "story telling" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- male singer · 3 ✖
- story telling · 3 ✖
- youthful · 3 ✖
- emotional 2
- medium tempo 2
- passionate 2
- adventurous 1
- auto tuned vocals 1
- compelling 1
- disco rap 1
- distorted guitar lead 1
- driving song 1
- engaging 1
- exciting 1
- funky bass lines 1
- groovy 1
- groovy bass line 1
- guitar rhythm 1
- head bangers 1
- heart break 1
- hip hop hits 1
- hip hop music 1
- hip-hop 1
- hip-hop hits 1
- hustlers life 1
- intense drumming 1
- money problems 1
- people screaming 1
- percussive bass line 1
- persuasive 1
- piano accompaniment 1
- poignant 1
- poor audio quality 1
- pop rap 1
- positive 1
- rap 1
- retro classic rock 1
- rhythmic speech 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- screaming vocals 1
- slick drumming rhythm 1
- slow tempo 1
- spirited 1
- synth countermelody 1
- synth horns playing 1
- synthesiser arrangements 1
- the hood 1
- vocal backup 1
musiccaps_names (array) 11 ✖
- Music 3
- Tender music 2
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Rhythm and blues 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lately (Official Music Video) | A male vocalist sings this mellow rap. The tempo is medium with a groovy bass line, keyboard harmony , slick drumming and vocal backup. The song is youthful, story telling, passionate, impactful, compelling and engaging. This song is contemporary Hip-Hop/Rap. | 2016-04-16T18:42:59Z | Official Lobo | Song: Lately Artist: Lobo Directed/Produced/Edited by: Lobo Shot by: CHRIS Kai Bordenave Lobo | ["Music", "Tender music"] | ["male singer", "slow tempo", "funky bass lines", "intense drumming", "synthesiser arrangements", "vocal backup", "hip-hop", "rap", "pop rap", "hip-hop hits", "disco rap", "rhythmic speech", "story telling", "passionate", "emotional", "persuasive", "compelling", "engaging", "persuasive", "youthful"] | 7 | 0Ubu4BqSWmU | 174 | |
Savvy - Stop It Official Music Video | A male rapper sings this emotional melody. The song is medium tempo with a steady techno drumming rhythm, strong bass line, various percussion hits, piano playing accompaniment and synth horns playing countermelody. The song is emotional and storytelling in nature. The song is a modern hip hop song. | 2016-06-17T14:13:21Z | NoLettingUpTheLabel | #loyalgang #betonme #artistontherise #youtubemusic #unsignedhype #vibegod #subscribe Loyal Gang Entertainment's Artist Savvy Performing Her Hit Record " Stop It " ( Dir By : Reggbvisual ) Follow Savvy On Social Media https://www.instagram.com?dareal_savvy https://www.twitter.com/Dareal_savvy https://www.facebook.com/Darealsavvy https://www.youtube.com/loyalgangentertainment Booking & Features : Loyalgangenetertainment@gmail.com | ["Music", "Rhythm and blues", "Tender music"] | ["male singer", "hip hop music", "hip hop hits", "groovy", "synth countermelody", "driving song", "auto tuned vocals", "medium tempo", "slick drumming rhythm", "percussive bass line", "piano accompaniment", "story telling", "emotional", "synth horns playing", "passionate", "the hood", "hustlers life", "money problems", "passionate", "spirited", "poignant", "youthful", "heart break"] | 1 | i6WtNBpRll0 | 4158 | |
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;