musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live recording", musiccaps_author = 0 and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- live recording · 2 ✖
- clean amp channel 1
- double bass 1
- drums 1
- electric guitar 1
- guitar 1
- high gain amp sound 1
- humming noise 1
- low quality music 1
- male voice 1
- moderate tempo 1
- noise signal above threshold 1
- overdrive amp channel 1
- romantic theme 1
- slow rock 1
- vocal harmony 1
musiccaps_names (array) 9 ✖
- Electric guitar · 2 ✖
- Guitar 2
- Music 2
- Bass guitar 1
- Distortion 1
- Echo 1
- Effects unit 1
- Plucked string instrument 1
- Tick 1
youtube_published (date) 2 ✖
- 2007-10-22 1
- 2010-04-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Deer Tick 10-18-2007 Ashamed 1/10 | This song is a low quality live recording of a performance. This features a male voice singing the main melody. At the end of the song, other voices sing with the main voice in harmony. This is accompanied by an electric guitar plucking chords. The double bass plays the root notes of the chords. The percussion plays the cymbal, increasing volume slowly, giving it a swell feel. The mood of the song seems romantic. | 2007-10-22T00:17:05Z | vincenz7 | Live @ Cakeshop. CMJ's. Unfortunately it got cut 1 1/2 minutes into the song. But check out the rest of the show! | ["Electric guitar", "Guitar", "Music", "Tick"] | ["live recording", "male voice", "slow rock", "guitar", "double bass", "drums", "low quality music", "romantic theme", "vocal harmony", "moderate tempo"] | 0 | P90rFZQFqWk | 2510 | |
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;