musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 6 ✖
- live performance · 6 ✖
- spirited · 6 ✖
- passionate 4
- guitar accompaniment 3
- medium tempo 3
- ambient room noises 2
- average audio quality 2
- dance rhythm 2
- fast tempo 2
- instrumental music 2
- live audience 2
- poor audio quality 2
- romantic 2
- traditional music 2
- acoustic guitar accompaniment 1
- acoustic song 1
- amateur singing 1
- ambient sounds 1
- bad audio quality 1
- bagpiper 1
- banjo 1
- bellows 1
- cameras clicking 1
- cheerful 1
- child performers 1
- clapping percussions 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- …
musiccaps_names (array) 19 ✖
- Music 5
- Musical instrument 2
- Plucked string instrument 2
- Singing 2
- Vocal music 2
- Applause 1
- Bagpipes 1
- Banjo 1
- Bowed string instrument 1
- Chant 1
- Chorus effect 1
- Country 1
- Crackle 1
- Effects unit 1
- Electric guitar 1
- Flamenco 1
- Guitar 1
- Song 1
- Wind instrument, woodwind instrument 1
youtube_published (date) 6 ✖
- 2007-06-29 1
- 2008-05-24 1
- 2010-11-11 1
- 2011-05-15 1
- 2011-10-24 1
- 2016-01-22 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ジャズコーラスの音色とマーシャルガバナーの威力 | The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. | 2011-10-24T16:02:01Z | yskpai81 | ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] | 1 | 2xATintzaj4 | 420 | |
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 | |
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 | |
Gordon Walker 4 - Glenfiddich Ceilidh 2003 | This music is a lively Bagpiper instrumental. The tempo is fast with a piper playing a cheerful harmony on the bagpiper with an enthusiastic acoustic guitar accompaniment. The music is vibrant, vivacious, vigorous, engaging, cheerful and merry. The performance is live with a live audience and ambient sounds. | 2007-06-29T17:30:17Z | Chris Eyre | The last of 4 clips of Gordon Walker giving a wonderful and entertaining display during the ceilidh at the New Scotland Hotel in Pitlochry on the evening following the Glenfiddich competition at Blair Castle. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "bagpiper", "acoustic guitar accompaniment", "live performance", "live audience", "ambient sounds", "lively", "spirited", "rich", "drone pipes", "melody pie", "bellows", "double reed instrument", "piper", "passionate", "spirited", "emotional", "high-spirited", "engaging", "mesmerising", "sharp sounds", "high notes"] | 7 | JjF1G5wgcvY | 2028 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
요들송 _ 키스 요들 _ 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;