musiccaps_details (view)
1 row where musiccaps_aspects contains "calm", musiccaps_aspects contains "gear", musiccaps_names contains "Effects unit" and musiccaps_names contains "Guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mooer Audio Ana Echo Delay | This is an instrumental electric guitar jam meant to showcase an echo delay pedal. The guitar using the pedal is merely strumming the chords while there is another electric guitar in the background playing the melody. There is also a bass guitar playing a simple bass line. In the rhythmic background there is a chill rock beat played by the acoustic drums. There is a calm and chill atmosphere in this piece. It could be used as the loading screen music in a video game. | 2012-08-29T19:00:32Z | Prymaxe | $98.00 https://www.prymaxe.com/products/mooer-audio-ana-echo-delay The Mooer Audio Ana Echo is a very small Analog echo pedal that sounds great! Don't let the small size fool you, the tones in this box are big! The Ana Echo has 3 knobs... Rate, intense and echo. Use the Mooer for rhythmic delays or set the echo back a little for some added depth to your lead tone. The Mooer Ana Echo can also be used to self oscillate for outer space tones! | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitar", "bass guitar", "acoustic drums", "effect pedal", "echo", "delay", "gear", "repeated theme", "clean sound", "chill", "calm", "easygoing"] | 9 | GFJNgqcX7u0 | 1703 |
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;