musiccaps_details (view)
102 rows where search matches "guitar" and musiccaps_aspects contains "mono" sorted by musiccaps_caption
This data as json, CSV (advanced)
youtube_published (date) >30 ✖
- 2010-11-12 2
- 2006-02-23 1
- 2006-06-20 1
- 2006-06-22 1
- 2006-10-04 1
- 2006-10-08 1
- 2006-12-31 1
- 2007-05-07 1
- 2007-05-16 1
- 2007-05-27 1
- 2007-07-07 1
- 2007-07-16 1
- 2007-07-17 1
- 2007-08-06 1
- 2007-09-01 1
- 2007-09-24 1
- 2007-12-02 1
- 2008-01-09 1
- 2008-01-22 1
- 2008-04-04 1
- 2008-04-22 1
- 2008-07-06 1
- 2008-07-24 1
- 2008-07-26 1
- 2008-10-10 1
- 2008-10-19 1
- 2008-10-25 1
- 2008-10-28 1
- 2008-12-02 1
- 2009-01-31 1
- …
musiccaps_names (array) >30 ✖
- Music 90
- Musical instrument 46
- Plucked string instrument 46
- Guitar 43
- Acoustic guitar 14
- Singing 13
- Effects unit 12
- Bass guitar 11
- Strum 11
- Chorus effect 9
- Country 9
- Inside, small room 9
- Distortion 8
- Speech 8
- Mandolin 7
- Wind instrument, woodwind instrument 7
- Bluegrass 6
- Electric guitar 6
- Reverberation 6
- Steel guitar, slide guitar 6
- Ukulele 6
- Electronic tuner 5
- Harmonica 5
- Rock and roll 5
- Tapping (guitar technique) 5
- Banjo 3
- Echo 3
- Roll 3
- Soul music 3
- Swing music 3
- …
musiccaps_aspects (array) >30 ✖
- mono · 102 ✖
- low quality 101
- noisy 94
- passionate 36
- emotional 20
- live performance 15
- acoustic rhythm guitar 14
- cover 14
- flat male vocal 13
- electric guitar melody 12
- rock 11
- groovy bass 10
- passionate male vocal 10
- tutorial 9
- groovy 8
- punchy snare 8
- easygoing 7
- energetic 7
- happy 7
- fun 6
- joyful 6
- punchy kick 6
- relaxing 6
- shimmering hi hats 6
- arpeggiated acoustic guitar melody 5
- groovy bass guitar 5
- playback 5
- reverberant 5
- soulful 5
- vintage 5
- …
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tìm lại bầu trời - hướng dẫn guitarist CHop Bi (phần 2 - chơi mẫu) | The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. | 2012-03-10T11:35:16Z | thachsungabc | Lớp guitar - CLB nghệ thuật trẻ Hà Nội - link: http://enbac.com/Ha-Noi/Tong-hop/p1174061/Lop-guitar-CLB-nghe-thuat-tre-chieu-sinh-Thong-bao-chuong-trinh-tang-dan-guitar-cho-hoc-vien-moi.html | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] | 4 | cOgNXgF21u4 | 3702 | |
The Cat that loves Horses | The low quality video features a cover of a kids song and it consists of a sweet girl vocal singing over acoustic rhythm guitar. The recording is in mono, noisy and it sounds fun and happy. | 2008-10-19T03:57:30Z | kangurski | so cute :) | ["Music", "Mandolin", "Ukulele"] | ["low quality", "mono", "cover", "sweet girl vocal", "acoustic rhythm guitar", "noisy", "fun", "happy", "kids song"] | 4 | 9ZWmZdgrE78 | 1023 |
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;