musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 63 ✖
- emotional · 4 ✖
- percussive bass line · 4 ✖
- story telling · 4 ✖
- male singer 3
- medium tempo 3
- guitar rhythm 2
- love song 2
- piano accompaniment 2
- spirited 2
- steady drumming rhythm 2
- auto tuned vocals 1
- bad audio quality 1
- black gospel music influences 1
- blues music 1
- cymbals crashing 1
- dream of you 1
- driving song 1
- enteric 1
- exciting 1
- female singer 1
- groovy 1
- groovy rhythm 1
- heart break 1
- hip hop hits 1
- hip hop music 1
- hustlers life 1
- inspiring 1
- jazz and blues 1
- jazz drumming rhythm 1
- jazz music 1
- love you so badly 1
- madly in love 1
- marching rhythm 1
- memdium tempo 1
- missing you 1
- modern pop hits 1
- modern r&b hits 1
- money problems 1
- motivational 1
- never give up on you 1
- old school music 1
- organ accompaniment 1
- passionate 1
- poignant 1
- poor audio quality 1
- positive cheerful 1
- r&b 1
- retro pop music 1
- romantic 1
- slick drumming rhythm 1
- slow tempo 1
- snare hits 1
- soul music 1
- soul singer 1
- special someone 1
- spirited singing 1
- synth countermelody 1
- synth horns playing 1
- the hood 1
- together forever 1
- vintage hits 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alice Fredenham - How Come You Don't Call | A female singer sings this soulful song. The song is slow tempo with piano accompaniment, strong bass line and groovy jazz drumming. The song is soulful and emotional. The song is a blues jazz song. | 2013-07-28T23:41:28Z | Virgilio Gan | Alice Fredenham - How Come You Don't Call http://www.facebook.com/realhealthnwealth Virgilio Gan World Talent Media Group | ["Music", "Happy music"] | ["female singer", "soul music", "jazz music", "blues music", "jazz and blues", "slow tempo", "black gospel music influences", "special someone", "dream of you", "missing you", "percussive bass line", "jazz drumming rhythm", "piano accompaniment", "emotional", "love song", "story telling", "love you so badly", "together forever"] | 1 | XUD-9HkQuTE | 3186 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
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 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;