musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar", musiccaps_author = 0, musiccaps_names contains "Echo" and musiccaps_names contains "Plucked string instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
fender deluxe reverb...heavy metal amp?? | This is a live recording of a guitar being played through a high gain amp. The signal is clean at the beginning and switches to an overdrive or distortion tone. A humming noise is heard when the channel is switched to the distortion channel. There are no other instruments played in this clip apart from one guitar. The guitarist seems to be testing the clean and dirty channels of the guitar amplifier. | 2010-04-06T00:07:26Z | diagrammatisk | Chirp chirp chirp | ["Bass guitar", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Plucked string instrument", "Distortion"] | ["live recording", "high gain amp sound", "electric guitar", "overdrive amp channel", "clean amp channel", "humming noise", "noise signal above threshold"] | 0 | SEDfsU63w8I | 2749 | |
The Smiths - Some Girls Are Bigger Than Others (guitar riff) | This song features an electric guitar playing the main melody. The guitar plays three ascending chords. Each chord is strummed once at the beginning of the bar. The tremolo bar is used to give the sound a tremulous effect. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be played in a guitar instruction video. | 2012-01-03T09:49:44Z | yoooyooomaaa | Gretsch G5122 Ibanez CS9 MXR carbon copy | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "no voices", "tremolo bar", "three chords", "no other instruments", "instrumental"] | 0 | uxLY3CBoPo8 | 5144 |
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;