musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "passionate" and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional 2
- groovy · 2 ✖
- passionate · 2 ✖
- auto tuned vocals 1
- chimes bells 1
- driving song 1
- filtered male vocal 1
- heart break 1
- hip hop 1
- hip hop hits 1
- hip hop music 1
- hustlers life 1
- low quality 1
- male singer 1
- medium tempo 1
- mellow arpeggiated piano melody 1
- money problems 1
- passionate female vocal 1
- percussive bass line 1
- piano accompaniment 1
- poignant 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- slick drumming rhythm 1
- spirited 1
- story telling 1
- sustained strings melody 1
- synth countermelody 1
- synth horns playing 1
- …
musiccaps_names (array) 3 ✖
- Music 2
- Tender music · 2 ✖
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Mali Bang Mag Mahal by CRSP (official music video) | The low quality recording features a hip hop song that consists of a mellow arpeggiated piano melody played over sustained strings melody, chime bell and filtered male vocal in the first half of the loop. In the second half the beat drops and it consists of a punchy kick and snare hits, shimmering hi hats and passionate female vocals singing over. It sounds passionate, groovy and emotional. | 2013-07-04T05:19:16Z | MrRight VEVO | Directed by : Lilcoli Tugista Singer : Still One & Loraine Composed by : Right One Arranged by : Still One & Right One Released : July 2013 | ["Music", "Tender music"] | ["low quality", "hip hop", "mellow arpeggiated piano melody", "filtered male vocal", "sustained strings melody", "chimes bells", "punchy kick", "punchy snare", "shimmering hi hats", "passionate female vocal", "passionate", "emotional", "groovy"] | 4 | jD0nqkyuHPg | 4242 |
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;