musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "sad" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality · 5 ✖
- sad · 5 ✖
- emotional 4
- noisy 4
- arpeggiated acoustic flamenco guitar melody 1
- arpeggiated acoustic guitar 1
- arpeggiated acoustic guitar melody 1
- car passing by 1
- cozy 1
- easygoing 1
- echoing melancholic electric guitar melody 1
- flat male vocal 1
- heartfelt 1
- live performance 1
- mellow 1
- mono 1
- muffled 1
- rock 1
- seat crackles 1
- simple electric guitar chords 1
- soft 1
- vintage 1
- warm 1
musiccaps_names (array) 12 ✖
- Guitar · 5 ✖
- Music 5
- Musical instrument 3
- Plucked string instrument 3
- Acoustic guitar 2
- Blues 1
- Distortion 1
- Echo 1
- Effects unit 1
- Flamenco 1
- Strum 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweater Weather by The Neighbourhood acoustic guitar instrumental cover with onscreen lyrics karaoke | The low quality recording features an arpeggiated acoustic guitar. It sounds mellow, soft, emotional and sad. | 2014-02-10T00:29:44Z | avg iQ | Download http://avg-iq.com/2014/02/sweater-weather-neighbourhood.html More instrumentals http://avg-iq.com/p/more-songs_28.html Chords: Eb Cm Gm Bb (Beginning to End) Sweater Weather by The Neighbourhood acoustic guitar instrumental cover with onscreen lyrics karaoke backing track . Singing Tips http://bit.ly/avgiQsingingtips Guitar Lesson http://bit.ly/avgiQguitarlesson Piano Lesson http://bit.ly/avgiQpianolesson . . We want to make you an exclusive guitar instrumental of your favorite song or any song you want. Please email avgiQacoustic@gmail.com . Request a Song http://avg-iq.com/p/request-song.html | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "arpeggiated acoustic guitar", "mellow", "soft", "emotional", "sad"] | 4 | 2x9735gU01s | 419 | |
☆Black Sheep cover Ver☆Fastest Pram☆the pillowsカバーコンテスト | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over simple electric guitar chords. The recording is noisy and it has some seat crackling noises in it. It sounds sad and emotional though. | 2009-07-22T12:28:48Z | hiro2cyclone | [black sheep/ Fastest Pram] the pillowsカバーコンテスト。 the pillows20周年おめでとうございます! 7/20 BUSTERS TRIBUTE SHOW!!!と銘打って関東関西同時に行われたイベントから! ピロウズの曲は楽しく弾いてなんぼ!ってことでこの曲を^^ | ["Blues", "Guitar", "Music"] | ["low quality", "live performance", "seat crackles", "noisy", "simple electric guitar chords", "flat male vocal", "emotional", "sad", "rock"] | 4 | FbV2Lgt3H1Q | 1655 | |
FLAMENCO GUITAR CHILL-OUT | The low quality recording features an arpeggiated acoustic flamenco guitar melody. The recording is noisy, in mono, and it sounds sad, easygoing and emotional. | 2007-09-24T10:53:49Z | maitzegur | Flamenco Chill-Out | ["Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "mono", "noisy", "arpeggiated acoustic flamenco guitar melody", "sad", "emotional", "easygoing"] | 4 | IKfmu7tAyUE | 1894 | |
Stairway to Heaven - [Led Zeppelin] | The low quality recording features an arpeggiated acoustic guitar melody and some cars passing by sounds in the background. It sounds heartfelt, emotional and sad. The recording is noisy. | 2006-12-01T13:01:34Z | Ted Kim | I think best of Led Zeppelin | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "car passing by", "arpeggiated acoustic guitar melody", "emotional", "sad", "heartfelt", "noisy"] | 4 | j-TVVmVmygg | 4227 | |
Ibanez DE7 Delay/Echo Pedal | The low quality recording features a melancholic electric guitar melody with echoing effects on. Even though it sounds muffled and noisy, it gives it a vintage, warm character. It kind of feels cozy listening to it. | 2012-01-19T04:11:29Z | hovercraft Artifact | nice foggy repeats. | ["Echo", "Effects unit", "Guitar", "Music", "Distortion"] | ["low quality", "echoing melancholic electric guitar melody", "muffled", "noisy", "sad", "warm", "vintage", "cozy"] | 4 | yfZ0z1C3blk | 5428 |
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;