musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "r&b"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- emotional · 3 ✖
- male singer · 3 ✖
- r&b · 3 ✖
- groovy bass line 2
- keyboard harmony 2
- medium tempo 2
- romantic 2
- soul 2
- acoustic guitar 1
- alternative rap 1
- bad audio quality 1
- engaging 1
- fingers snapping 1
- fog horn 1
- guitar rhythm 1
- hip-hop 1
- inspiring 1
- love song 1
- madly in love 1
- male voice speaking 1
- mellow 1
- memdium tempo 1
- modern pop hits 1
- modern r&b hits 1
- motivational 1
- never give up on you 1
- organ accompaniment 1
- percussive bass line 1
- pleasant 1
- reggae 1
- rhythmic electric guitar 1
- slow tempo 1
- smooth 1
- soft melodious 1
- soothing 1
- soul singer 1
- sound of horn 1
- steady drumming 1
- steady drumming rhythm 1
- story telling 1
- super imposed male voice 1
- synthesiser articulation 1
- vocal harmony 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
South Central Cartel - It's A S.C.C. Thang ft. The Chi-Lites | A male vocalist sings this groovy R&B. The tempo is medium with a funky bass guitar, steady guitar, bright electric guitar and keyboard harmony. The song is mellow, emotional, soft, smooth and engaging. This song is an R&B. | 2009-11-23T18:52:26Z | SthCentralCartelVEVO | Music video by South Central Cartel performing It's A S.C.C. Thang. (C) 1994 RAL/Def Jam | ["Music", "Rapping", "Reggae"] | ["male singer", "medium tempo", "groovy bass line", "mellow", "smooth", "emotional", "engaging", "steady drumming", "keyboard harmony", "hip-hop", "r&b", "soul", "alternative rap", "rhythmic electric guitar"] | 7 | S7R3NMq3MKk | 2739 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 | |||||
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;