musiccaps_details (view)
2 rows where musiccaps_names contains "Bass guitar", musiccaps_names contains "Echo", musiccaps_names contains "Electric guitar" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Keeley Magnetic Echo vs MXR Carbon Copy | This is a gear showcase jam recording. There is an electric guitar playing a calm solo with the echo effect. The tune being played is a simple one and it is rather relaxed. This recording can be used to lift guitar samples with echo effect. It can also be used in advertisement jingles. | 2015-03-06T15:22:57Z | shnobel | Buy these Pedals on Reverb.com Click Here https://reverb.com/marketplace?utm_source=shnobel&query=Keeley+Magnetic+Echo&_aid=shnobel Keeley Magnetic Echo vs MXR Carbon Copy | ["Bass guitar", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music"] | ["jam", "no singer", "instrumental", "single instrument", "electric guitar", "guitar solo", "effect pedal", "echo", "easygoing", "simple tune"] | 9 | XQB27QPic3k | 3183 |
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;