musiccaps_details (view)
44 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_author = 7
This data as json
youtube_published (date) >30 ✖
- 2006-04-19 1
- 2006-08-04 1
- 2006-08-08 1
- 2007-02-02 1
- 2007-02-17 1
- 2007-02-19 1
- 2007-07-11 1
- 2008-03-18 1
- 2008-06-05 1
- 2008-06-18 1
- 2008-06-24 1
- 2008-10-22 1
- 2009-01-27 1
- 2009-02-08 1
- 2009-05-03 1
- 2009-07-17 1
- 2009-08-10 1
- 2010-02-07 1
- 2010-03-08 1
- 2010-03-31 1
- 2010-05-19 1
- 2010-05-31 1
- 2010-09-07 1
- 2010-10-16 1
- 2010-11-01 1
- 2011-02-03 1
- 2011-03-15 1
- 2011-07-01 1
- 2012-04-19 1
- 2012-05-03 1
- …
musiccaps_names (array) >30 ✖
- Music 41
- Musical instrument 18
- Guitar 17
- Plucked string instrument 17
- Distortion 14
- Electric guitar 14
- Effects unit 12
- Chorus effect 8
- Tapping (guitar technique) 6
- Bass guitar 4
- Echo 4
- Reverberation 4
- Singing 4
- Speech 4
- Electronic tuner 3
- Acoustic guitar 2
- Blues 2
- Cacophony 2
- Christmas music 2
- Country 2
- Funk 2
- Harmonic 2
- Rock music 2
- Soul music 2
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Choir 1
- Christian music 1
- Crowd 1
- …
musiccaps_aspects (array) >30 ✖
- electric guitar · 44 ✖
- instrumental 32
- rock 19
- sonic power 16
- amplified guitar 15
- medium tempo 15
- fast tempo 12
- intense 11
- hard rock 10
- loud 10
- metal 10
- powerful 10
- vibrations 10
- heavy metal 9
- stringed instrument 8
- youthful 8
- acoustic guitar 7
- electric guitar lead 7
- external amplification 7
- passionate 7
- amateur recording 6
- blues 6
- loud feedback 6
- medium fast tempo 6
- pop 6
- soft rock 6
- tutorial 6
- amplified 5
- catchy riff 5
- electric guitar lesson 5
- …
0 records
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;