musiccaps_details (view)
1 row where musiccaps_aspects contains "clean amp channel", musiccaps_names contains "Electric guitar", musiccaps_names contains "Guitar" and musiccaps_names contains "Music"
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 |
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;