musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "guitar accompaniment" and musiccaps_aspects contains "live performance" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 70 ✖
- emotional 5
- guitar accompaniment · 5 ✖
- live performance · 5 ✖
- poor audio quality 4
- romantic 3
- spirited 3
- folk music 2
- live audience 2
- male singer 2
- medium tempo 2
- passionate 2
- acoustic song 1
- amateur singing 1
- ambient noises 1
- ambient room noises 1
- ambient room nosiness 1
- average audio quality 1
- bass rhythm 1
- beautiful love 1
- cameras clicking 1
- clapping percussions 1
- crowds clapping 1
- crowds whistling 1
- dance rhythm 1
- dealing with depression 1
- encouraging crowd 1
- endless love 1
- energetic 1
- exciting 1
- fast guitar strumming 1
- fast tempo 1
- female singer 1
- flamenco guitar 1
- folk singer 1
- folk singers 1
- forever together 1
- groovy bass line 1
- groovy music 1
- groovy tempo 1
- guitarist 1
- hissing sounds 1
- home video 1
- inspiring 1
- instrumental music 1
- latin singer 1
- loneliness 1
- love song 1
- male and female singer 1
- melancholic music 1
- motivational 1
- music concert 1
- passionate music 1
- passionate singing 1
- people clapping 1
- people talking 1
- pure and innocent 1
- sad 1
- slow tempo 1
- song cover 1
- spirited singing 1
- steady percussions 1
- story telling 1
- street musician 1
- strong bass line 1
- theremin 1
- traditional folk song 1
- traditional latin music 1
- traditional music 1
- yodelling melody 1
- youtube music video 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
Devendra Banhart - Chin Chin & Muck Muck | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | 2009-04-21T19:14:32Z | eachnotesecure | Devendra Banhart performs Chin Chin & Muck Muck live at The Independent in San Francisco in April 2009 | ["Singing", "Music", "Rattle (instrument)"] | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | 1 | jFek2xLbEww | 4243 | |
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 | |
Tubular Bells (Start of the 2nd part) on Theremin | The song is an instrumental. The song is in slow tempo with a theremin playing a melancholic melody with a guitar accompaniment. The song is emotional and lilting. The audio quality is poor. | 2007-05-29T15:55:35Z | DANI ROTTENBRAIN | Versión thereministica del principio de la segunda parte de tubular bells de Mike Oldfield | ["Music", "Theremin"] | ["theremin", "emotional", "guitar accompaniment", "poor audio quality", "romantic", "love song", "endless love", "forever together", "ambient noises", "youtube music video", "beautiful love", "pure and innocent", "live performance", "live audience", "melancholic music", "instrumental music", "slow tempo", "emotional", "sad"] | 1 | 03frQGyrgQ4 | 114 | |
요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 |
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;