musiccaps_details (view)
54 rows where search matches "guitar" and musiccaps_names contains "Pop music" sorted by youtube_link
This data as json
youtube_published (date) >30 ✖
- 2011-04-03 2
- 2006-04-14 1
- 2006-06-21 1
- 2006-09-22 1
- 2006-12-12 1
- 2007-05-13 1
- 2007-10-13 1
- 2008-01-23 1
- 2008-03-02 1
- 2008-03-16 1
- 2008-09-09 1
- 2009-04-12 1
- 2009-04-13 1
- 2009-08-31 1
- 2009-09-03 1
- 2009-10-27 1
- 2009-11-28 1
- 2009-12-12 1
- 2010-02-21 1
- 2010-03-10 1
- 2010-03-19 1
- 2010-05-30 1
- 2010-08-05 1
- 2010-08-29 1
- 2010-10-30 1
- 2010-11-19 1
- 2010-12-19 1
- 2011-02-09 1
- 2011-08-26 1
- 2012-03-10 1
- …
musiccaps_names (array) >30 ✖
- Pop music · 54 ✖
- Music 53
- Singing 16
- Independent music 9
- Song 9
- Ska 8
- Music of Asia 7
- Funk 6
- Dance music 4
- Disco 4
- Exciting music 4
- Country 3
- Progressive rock 3
- Rock music 3
- Yell 3
- Afrobeat 2
- Bang 2
- Folk music 2
- Guitar 2
- Heavy metal 2
- Jazz 2
- Jingle (music) 2
- Musical instrument 2
- Psychedelic rock 2
- Soul music 2
- Swing music 2
- Whoop 2
- /m/05zppz 1
- /t/dd00003 1
- /t/dd00032 1
- …
musiccaps_aspects (array) >30 ✖
- bass guitar 15
- energetic 14
- acoustic drums 11
- low quality 10
- melodic singing 10
- electric guitar 9
- live performance 8
- pop 7
- amateur recording 6
- emotional 6
- male vocal 6
- medium tempo 6
- passionate 6
- acoustic guitar 5
- drums 5
- e-bass 5
- e-guitar 5
- exciting 5
- female vocal 5
- keyboard 5
- male singer 5
- youthful 5
- crowd cheering 4
- easygoing 4
- electronic drums 4
- energetic drums 4
- fast tempo 4
- female singer 4
- groovy bass 4
- groovy bass guitar 4
- …
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;