musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "romantic" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 4 ✖
- romantic · 4 ✖
- acoustic guitar 2
- male singer 2
- r&b 2
- acoustic drums 1
- average audio quality 1
- bass guitar 1
- distorted 1
- fast guitar strumming 1
- fast tempo 1
- fingers snapping 1
- flamenco guitar 1
- fog horn 1
- folk music 1
- folk singer 1
- groovy bass line 1
- groovy music 1
- groovy tempo 1
- guitar accompaniment 1
- heartfelt 1
- hmong pop 1
- keyboard harmony 1
- latin singer 1
- live performance 1
- male vocal 1
- male voice speaking 1
- melodic singing 1
- normal tempo 1
- passionate 1
- …
musiccaps_names (array) 8 ✖
- Music 4
- Song · 4 ✖
- Flamenco 1
- Independent music 1
- Reggae 1
- Singing 1
- Vocal music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
Shook - "Lullaby" | The R&B song features a passionate male vocalist singing over a wide funky electric guitar melody, smooth bass guitar, punchy kick and snare hits, shimmering hi hats, snappy rimshots and soft crash cymbals. The rimshots are present in the first half of the loop, while a more energetic second part of the loop consists of punchy snare hits. It sounds emotional and heartfelt, as the vocal is slightly distorted. | 2010-07-15T19:21:57Z | funkysoul2000 | from EP "Can U Still Dance?" © 2010 www.shooksounds.com | ["Music", "Song", "Zing"] | ["r&b", "passionate male vocal", "punchy snare", "punchy kick", "shimmering hi hats", "soft crash cymbal", "wide funky electric guitar melody", "smooth bass guitar", "snappy rimshots", "emotional", "romantic", "heartfelt", "distorted"] | 4 | _m-N4i-ge28 | 3487 | |
wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 | |
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 |
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;