musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing", musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
دورة المياه في الطبيعة | The low quality recording features a smooth bass, electric guitar melody, synth pad chords and mellow piano chords playing. It sounds soft, mellow and easygoing. | 2013-01-13T18:52:46Z | Malak Msarwa | ["Music", "Sad music"] | ["low quality", "smooth bass", "electric guitar melody", "synth pad chords", "mellow piano chords", "soft", "mellow", "easygoing"] | 4 | Vwekk3EOa-U | 3043 | ||
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;