musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "e-guitar" and musiccaps_aspects contains "sensual" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- e-guitar · 3 ✖
- sensual · 3 ✖
- female voice singing 2
- acoustic drums 1
- amateur recording 1
- backing track 1
- e-bass 1
- erotic 1
- keys 1
- medium tempo 1
- medium to uptempo 1
- r&b/soul 1
- slow tempo 1
- soul 1
- soul/ballad 1
- soulful 1
- synthesizer 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Singing "Officially Missing You" by Tamia - Michelle Martinez Cover | A female voice is singing soulfully, sounding a little airy and sensual. Someone is playing neo-soul chords on an e-guitar. This song may be playing at home singing along to a karaoke song. This is an amateur recording. | 2008-01-28T05:12:40Z | Michelle Martinez | ** SIDENOTE: i get a lot of comments about being too close to the camera. haha. sorry guys, i'm recording off my laptop and if i don't get close to it, you can't hear my singing. i'll work on getting an external mic. =) singing a tamia classic. | ["Music", "/t/dd00004"] | ["r&b/soul", "female voice singing", "e-guitar", "sensual", "soulful", "amateur recording", "medium to uptempo"] | 6 | 2G4lyzAZ1vk | 343 | |
Test : Guitar Kit with Clean sound By LocalHero | Someone is playing a solo on a clean e-guitar along with a backing track that sounds like a slow soulful, sad ballad with strings,bass, acoustic drums and an e-guitar strumming single chords as a rhythmic instrument. This song may be played outside by a busker. | 2009-09-24T11:14:20Z | Korrakote Rodrat | Guitar Kit with Clean sound By LocalHero รั่วอยู่เยอะครับ ไม่ต้องสนใจ ฟังซาวด์ ฟังโทนของกีตาร์ก็พอครับ ฮ่าๆ ^_^" | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["soul/ballad", "backing track", "e-guitar", "slow tempo", "sensual"] | 6 | wKoFJHb2BoI | 5255 | |
Slow Train Soul - Tell Me Somethin' | This song sounds sensual, slightly erotic. The female voice is singing in the mid range and with delay and reverb on her voice. The bass is playing long notes with little changes. The drums are playing a rather complex groove. An e-guitar is playing single notes contributing to the rhythm while another guitar is playing an almost looped melody on top. This guitar has some effect on it and it sounds sensual and provocative. Synthesizer hits and keys are adding more little elements that are panned to the left and right side of the speakers. This is a very rhythmic song with its harmonic elements. This song may be playing at a nightclub for adults. | 2014-01-28T17:16:31Z | SlowTrainSoul Official | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Rhythm and blues", "Hip hop music"] | ["soul", "e-guitar", "keys", "synthesizer", "e-bass", "female voice singing", "acoustic drums", "sensual", "erotic", "medium tempo"] | 6 | B7V_grbxflg | 1207 |
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;