musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "ambient room noises" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- ambient room noises · 3 ✖
- medium tempo · 3 ✖
- emotional 2
- instrumental music 2
- live performance 2
- spirited 2
- acoustic song 1
- amateur play 1
- average audio quality 1
- bass guitar player 1
- bass guitar solo 1
- choppy playing 1
- clapping percussions 1
- dance rhythm 1
- electric guitar 1
- exciting 1
- folk singers 1
- guitar accompaniment 1
- guitar amplifiers 1
- guitar demonstration 1
- guitar lessons online 1
- guitar licks 1
- guitar strumming rhythm 1
- hissing sounds 1
- jarring string noises 1
- live audience 1
- male and female singer 1
- people clapping 1
- poor audio quality 1
- poor recording quality 1
- practice session 1
- soloist 1
- strumming chords 1
- traditional folk song 1
- traditional music 1
- varying tempos 1
- virtuoso 1
- yodelling melody 1
- youtube instrument tutorial 1
- youtube music video 1
musiccaps_names (array) 12 ✖
- Music 3
- Guitar 2
- Musical instrument 2
- Bass guitar 1
- Chant 1
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Plucked string instrument 1
- Singing 1
- Vocal music 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 | |
easy bass guitar lesson 5 rock songs for beginners iron man led zeppelin green day sabbath | The song is an instrumental. The tempo is medium and changes as the player changes the lick. The guitar is played solo styling with jarring string action. Playing amateur music is like a music lesson. The song is a bass guitar tutorial and sounds amateurish. The audio quality is poor. | 2011-10-10T18:32:03Z | finbarbass | http://www.amazon.com/Epic-Beginner-Bass-Mastery-Course/dp/B00A3YY8U6/ref=sr_1_1?ie=UTF8&qid=1354834620&sr=8-1&keywords=epic+beginner+bass+mastery Click this link for Beginner Bass Mastery DVD Course http://www.finbarfriends.com/ click this link to receive three FREE bass lessons not found on Youtube - basic to advanced included easy bass guitar lesson 5 rock songs for beginners iron man led zeppelin green day sabbath | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | ["instrumental music", "bass guitar player", "bass guitar solo", "varying tempos", "amateur play", "practice session", "guitar licks", "youtube instrument tutorial", "ambient room noises", "poor recording quality", "jarring string noises", "choppy playing", "medium tempo"] | 1 | VZJfkEet6EQ | 3008 | |
요들송 _ 키스 요들 _ 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;