musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male vocalist", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "people talking"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- live performance 2
- male vocalist · 2 ✖
- medium tempo · 2 ✖
- people talking · 2 ✖
- acoustic pop rock 1
- ambient sounds 1
- boomy 1
- coughing 1
- emphatic vocals 1
- energetic 1
- enthusiastic 1
- folk song 1
- gig 1
- groovy bass line 1
- haunting melody 1
- inferior audio quality 1
- intense drumming 1
- lilting 1
- live audience 1
- lively electric guitar 1
- lively spanish guitar 1
- loud 1
- minimalist 1
- muffled audio 1
- pop rock 1
- popnrock 1
- popular folk music 1
- powerful vocals 1
- regional music 1
- rustling 1
- spanish song 1
- static 1
- synthesiser harmony 1
- vibrant 1
- vocals 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Josh Rouse - Love vibration (live in Madrid 2007) | A male vocalist sings this lively pop rock. The tempo is medium with an intense electric guitar harmony, punchy drumming, groovy bass lines and keyboard harmony. The song is muffled as the audio quality is inferior but it sounds enthusiastic, youthful, passionate and vibrant. This could be a live performance as there are background sounds of people talking, coughing, rustling. This song is Pop Rock. | 2007-11-23T05:28:53Z | ruben garrido | Josh Rouse en directo en Madrid - 22 noviembre 2007 (live in Madrid) Mi cronica del concierto pinchando aqui: http://40formasdeintimidad.wordpress.com/2007/11/23/en-joy-josh-rouse/ | ["Blues", "Country", "Jazz", "Music"] | ["male vocalist", "medium tempo", "popnrock", "live performance", "gig", "acoustic pop rock", "pop rock", "youthful", "energetic", "vibrant", "enthusiastic", "people talking", "coughing", "rustling", "lively electric guitar", "intense drumming", "synthesiser harmony", "groovy bass line", "muffled audio", "inferior audio quality", "static", "boomy", "loud"] | 7 | SwaqANBpZGY | 2797 | |
Juan Fernando canta fandangos de Huelva en Amsterdam | A male vocalist sings this powerful solo in a foreign language. The tempo is medium with a spanish guitar accompaniment. The song has minimalist music with captivating, lilting and almost haunting vocals. This is a live performance with ambient sounds of people talking. The audio quality is inferior as it is an amateur recording. This song is a Latin/Spanish Folk song. | 2010-08-06T14:25:01Z | coroflamenco | Juan Fernando en un concierta del cuadro de cante de la Peña Flamenca de Huelva y del coro flamenco Calle Real en Amsterdam. Toque Antonio Dovao, Ramón Jesús Díaz. Baile: Teresa Jaldón, Director de cine: Stijn van der Loo, studio BBH | ["Singing", "Yodeling", "Flamenco", "Music", "Music of Latin America"] | ["male vocalist", "medium tempo", "spanish song", "minimalist", "folk song", "regional music", "popular folk music", "lively spanish guitar", "emphatic vocals", "powerful vocals", "live performance", "live audience", "ambient sounds", "people talking", "lilting", "haunting melody", "vocals"] | 7 | _zQTlTCqMzs | 3508 |
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;