musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "rock" and musiccaps_author = 8 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- rock · 2 ✖
- acoustic guitar strumming 1
- active bass guitar 1
- cymbal crashes 1
- drum kit 1
- electric guitar 1
- four chord jam 1
- harmonized lead guitars 1
- instrumental 1
- overdrive 1
- strumming 1
- warm 1
musiccaps_names (array) 7 ✖
- Music 2
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Harmonic 1
- Progressive rock 1
- Rock music 1
youtube_published (date) 2 ✖
- 2008-02-07 1
- 2014-10-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Magasin - Eraserheads (Paolo Santos Cover) | instrumental rock music with a drum kit, lots of cymbal crashes, acoustic guitar strumming, harmonized lead guitars and an active bass guitar. | 2008-02-07T23:57:50Z | joaq25 | Song:Magasin Artist:Eraserheads(This version sang by Paolo Santos) | ["Music", "Rock music", "Progressive rock"] | ["rock", "four chord jam", "drum kit", "cymbal crashes", "acoustic guitar strumming", "harmonized lead guitars", "active bass guitar", "instrumental"] | 8 | 9kt7rsziUVQ | 1038 | |
Greer Amps Southland Harmonic Overdrive - Top Boost Gear | Solo performance of an electric guitar player strumming chords. The tone is overdriven and warm. The genre is rock. | 2014-10-17T13:45:51Z | Top Boost Gear | Available at WWW.TOPBOOSTGEAR.COM! The Southland Harmonic Overdrive is built on the Lightspeed Organic Overdrive platform, we have developed what we believe to be the best overdrive on the market. The Lightspeed was built with the specific purpose of being a light to mild overdrive. The Southland is the next logical step for the Lightspeed platform—more gain, with two stages of clipping (utilizing different diode types for each stage of clipping), a focused midrange (not that annoying “hump”), and a bit of presence on top of the signal, to help cut through the mix. The Southland Harmonic Overdrive, like the Lightspeed, is touch sensitive, responds to pick attack, and has dynamics that just won’t stop. On top of that, we’ve selected a chip to drive the Southland that takes it to the next level. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "overdrive", "strumming", "rock", "warm"] | 8 | NzvkMWY4EjA | 2387 |
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;