musiccaps_details (view)
21 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "fast tempo"
This data as json
musiccaps_names (array) >30 ✖
- Music 19
- Bluegrass 4
- Banjo 3
- Country 3
- Musical instrument 3
- Singing 3
- Flamenco 2
- Guitar 2
- Rattle (instrument) 2
- Rock and roll 2
- Swing music 2
- Tap 2
- Acoustic guitar 1
- Blues 1
- Dubstep 1
- Effects unit 1
- Electronic dance music 1
- Harp 1
- Jazz 1
- Jingle (music) 1
- Maraca 1
- Music of Bollywood 1
- Pizzicato 1
- Plucked string instrument 1
- Reggae 1
- Rock music 1
- Sitar 1
- Song 1
- Soul music 1
- Spray 1
- …
musiccaps_aspects (array) >30 ✖
- acoustic guitar · 21 ✖
- fast tempo · 21 ✖
- instrumental 6
- keyboard harmony 5
- youthful 5
- energetic 4
- happy 4
- male singer 4
- amateur recording 3
- cheerful 3
- cheering 3
- clapping 3
- country music 3
- enthusiastic 3
- groovy 3
- live performance 3
- lively 3
- male vocalist 3
- mandolin 3
- peppy 3
- vivacious 3
- animated 2
- animated vocals 2
- auto harp 2
- banjo 2
- bluegrass 2
- buoyant 2
- cello 2
- choral harmony 2
- concert 2
- …
youtube_published (date) 21 ✖
- 2007-08-28 1
- 2007-09-30 1
- 2007-10-29 1
- 2008-01-14 1
- 2008-11-26 1
- 2008-12-31 1
- 2009-06-12 1
- 2009-10-12 1
- 2010-05-19 1
- 2010-06-09 1
- 2010-06-29 1
- 2011-10-04 1
- 2011-11-29 1
- 2012-06-04 1
- 2013-03-30 1
- 2014-09-02 1
- 2014-10-31 1
- 2014-12-15 1
- 2015-04-05 1
- 2015-07-09 1
- 2015-09-23 1
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;