musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "noisy", musiccaps_aspects contains "sad" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 4
- noisy · 4 ✖
- sad · 4 ✖
- emotional 3
- arpeggiated acoustic flamenco guitar melody 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
- mono 1
- muffled 1
- rock 1
- seat crackles 1
- simple electric guitar chords 1
- vintage 1
- warm 1
musiccaps_names (array) 11 ✖
- Guitar · 4 ✖
- Music 4
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Blues 1
- Distortion 1
- Echo 1
- Effects unit 1
- Flamenco 1
- Ukulele 1
youtube_published (date) 4 ✖
- 2006-12-01 1
- 2007-09-24 1
- 2009-07-22 1
- 2012-01-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
☆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;