musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "reverberant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- emotional · 3 ✖
- low quality 3
- reverberant · 3 ✖
- live performance 2
- noisy 2
- passionate 2
- passionate male vocal 2
- acoustic rhythm guitar 1
- aggressive strumming 1
- electric rhythm guitar melody 1
- flamenco 1
- flamenco rhythm guitar 1
- flat female vocal 1
- groovy 1
- groovy double bass 1
- mono 1
- plucked violin melody 1
- rock 1
- simple piano keys chords 1
- smooth 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marianne Faithfull - "As Tears go By" | The low quality recording features a live performance that consists of a flat female vocal singing over electric rhythm guitar melody. It sounds passionate, reverberant and emotional. The recording is noisy and in mono, as it was probably recorded with a phone. | 2007-07-16T14:01:51Z | Jan Jansen van der Sligte | "As Tears go By" - as she performed in the Cultuurcentrum Oosterpoort in Groningen (Netherlands) on the 10th of April 2007. Sorry that the camera is shaking a bit ("too much"). I just had it two days. | ["Singing", "Music", "Vocal music"] | ["low quality", "live performance", "flat female vocal", "electric rhythm guitar melody", "passionate", "reverberant", "emotional", "noisy", "mono"] | 4 | X28GWrn9LlI | 3159 | |
The Infamous Stringdusters Here Comes The Sun into Chopping Can at nTelos Pavilion 5/12/12 | The low quality recording features a live performance of a rock song and it features a passionate male vocal singing over groovy double bass, acoustic rhythm guitar, plucked violin melody and simple piano chords. It sounds reverberant, emotional, groovy and smooth - like something you would sing along to at the concert. | 2012-08-31T10:03:14Z | ConcertCasters | Check out the jam half way through! The Infamous Stringdusters cover Here Comes The Sun into Chopping Can at Charlottesville Virginia "nTelos Pavilion" 5/12/12 bluegrass live concert stage banjo slide guitar bass "blue mountain sports" "sound board mix" | ["Singing", "Music", "Song", "Bluegrass"] | ["low quality", "rock", "reverberant", "passionate male vocal", "acoustic rhythm guitar", "groovy double bass", "plucked violin melody", "simple piano keys chords", "smooth", "groovy", "emotional"] | 4 | dW4eW0Xreik | 3795 | |
Flamenco, Song and Dance, Spain | The low quality recording features a live performance of a flamenco song sung by passionate male vocalists and followed by aggressive strumming of flamenco rhythm guitar. It is reverberant and noisy, as it was probably recorded with a phone, and it sounds passionate and emotional. | 2013-05-31T14:07:04Z | Grill Friendly Chef | Flamenco (Spanish pronunciation: [flaˈmeŋko]) is a genre of Spanish music, song, and dance from Andalusia, in southern Spain, that includes cante (singing), toque (guitar playing), baile (dance) and palmas (handclaps). First mentioned in literature in 1774, the genre grew out of Andalusian and Romani music and dance styles. Flamenco is often associated with the Romani people of Spain (Gitanos) and a number of famous flamenco artists are of this ethnicity. In recent years flamenco has become popular all over the world and is taught in many countries: in Japan there are more academies than there are in Spain. | ["Flamenco", "Music", "Vocal music"] | ["low quality", "flamenco", "flamenco rhythm guitar", "aggressive strumming", "passionate male vocal", "live performance", "reverberant", "noisy", "passionate", "emotional"] | 4 | gxzU5EqNL14 | 4069 |
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;