musiccaps_details (view)
3 rows where musiccaps_aspects contains "chill", musiccaps_author = 4 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- chill · 3 ✖
- easygoing 3
- low quality 3
- noisy 2
- relaxing 2
- chill electric guitar melody 1
- electric guitar melody 1
- groovy double bass 1
- groovy piano melody 1
- jazz 1
- mellow 1
- shimmering shakers 1
- smooth 1
- smooth buzzy bass guitar 1
- soft hi hats 1
- unbalanced stereo 1
musiccaps_names (array) 13 ✖
- Music 3
- Musical instrument · 3 ✖
- Guitar 2
- Plucked string instrument 2
- Acoustic guitar 1
- Bass guitar 1
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Jazz 1
- Saxophone 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Days of Wine and Roses Dexter Gordon | The low quality recording features a jazz song that consists of groovy double bass located in the right channel, groovy piano melody leaning towards the left channel of the stereo image and widely spread shimmering shakers and soft hi-hats. It sounds smooth, chill, easygoing and relaxing - like something you would hear in high-end restaurants. | 2011-03-27T23:23:26Z | nickwreiter | From the album "Tangerine" (1972) New Jersey at the Van Gelder Studios Personnel: Dexter Gordon - Tenor Sax Cedar Walton - Piano Buster Williams - Bass Billy Higgins - Drums | ["Jazz", "Music", "Musical instrument", "Saxophone"] | ["low quality", "jazz", "groovy piano melody", "groovy double bass", "shimmering shakers", "soft hi hats", "smooth", "easygoing", "chill", "relaxing"] | 4 | AgVUGzrzJ20 | 1154 | |
Round Midnight - Guitar and acoustic bass guitar | The low quality recording features a smooth buzzy bass guitar and chill, electric guitar melody playing. It is noisy and the stereo image is unbalanced, as the bass guitar is leaning toward the left channel. It sounds easygoing, chill and relaxing. | 2015-03-24T20:19:36Z | Matt Otten | I bought this bass guitar about 2 weeks ago; this is my first recording with it :) starting with a slow tune to get used to the fretless playing, it's a challenge! I have played bass guitar for quite some time, but acoustic and fretless is another thing. | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "smooth buzzy bass guitar", "chill electric guitar melody", "noisy", "unbalanced stereo", "chill", "easygoing", "relaxing"] | 4 | ZmgkpmzvL6c | 3412 | |
TC Electronic Corona Chorus Effect Pedal With Toneprint, In Stereo (Video) | The low quality recording features an electric guitar melody. It sounds mellow, chill and easygoing. | 2011-04-22T17:05:00Z | gearwire | Even if you typically associate chorus effects and Coronas with muzak and d-bags, respectively, you owe it to yourself to check out the TC Electronic Corona Chorus. I mean, it's got Toneprint, man! What's Toneprint, you ask? Why it's nothing less than the ability to download a practically infinite number of presets from the TC Electronic website and add them to your pedal, free of charge. It's like an open bar of presets you can never get kicked out of! And while the stock chorus and tri-chorus modes sound pretty great, the Toneprint Owen downloaded for this particular demo sounds absolutely fantastic. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["low quality", "noisy", "electric guitar melody", "mellow", "easygoing", "chill"] | 4 | ib8pMT_ug7o | 4206 |
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;