musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "bass guitar" and musiccaps_names contains "Echo" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- bass guitar · 3 ✖
- electric guitar 2
- instrumental 2
- acoustic drums 1
- calm 1
- chill 1
- clean sound 1
- delay 1
- drums 1
- easygoing 1
- echo 1
- effect pedal 1
- female voices 1
- gear 1
- occult rock 1
- ominous 1
- repeated theme 1
- sinister 1
- slow tempo 1
- strings 1
- unison 1
- unnerving 1
- unsettling 1
musiccaps_names (array) 9 ✖
- Echo · 3 ✖
- Music 3
- Distortion 2
- Effects unit 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
少女時代 (SNSD) Girls' Generation HOOT PV | The music features a group of female voices singing the same melody in unison. The drums and bass guitar blend together and drive the pulse of the music. In the first half of the music excerpt strings play the same melody as the singers. | 2010-11-19T22:58:32Z | randomlife2004 | ["Echo", "Music", "Pop music"] | ["female voices", "unison", "drums", "bass guitar", "strings"] | 2 | pWms_9wpRB4 | 4717 | ||
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 | |
Year of the Goat - 04 Lucem Ferre | This is an instrumental occult rock piece. There is an electric guitar playing a simple melody with a minimal bass guitar backing. The atmosphere of this piece is sinister and unsettling, it gives the impression of a Satanic ritual about to commence. The tempo is slow. This music piece could be included in the soundtrack of a ritualistic horror movie/TV series or a video game of the similar genres. | 2011-05-13T14:40:43Z | Robert Black | Lucem Ferre by Year of the Goat from their EP Lucem Ferre on Van Records 2011 | ["Echo", "Electric guitar", "Music", "Distortion"] | ["occult rock", "instrumental", "electric guitar", "bass guitar", "sinister", "ominous", "unsettling", "unnerving", "slow tempo"] | 9 | 7p_Mnxl4Vq8 | 885 |
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;