musiccaps_details (view)
47 rows where search matches "guitar", musiccaps_aspects contains "emotional" and musiccaps_author = 7
This data as json
youtube_published (date) >30 ✖
- 2008-09-22 2
- 2010-02-07 2
- 2007-01-23 1
- 2007-06-29 1
- 2007-07-08 1
- 2007-11-02 1
- 2008-03-20 1
- 2008-03-22 1
- 2008-06-12 1
- 2008-07-09 1
- 2008-12-22 1
- 2009-03-21 1
- 2009-04-17 1
- 2009-04-20 1
- 2009-08-01 1
- 2009-10-25 1
- 2009-11-23 1
- 2009-12-31 1
- 2010-01-19 1
- 2010-01-30 1
- 2010-06-15 1
- 2010-07-11 1
- 2010-11-22 1
- 2011-03-18 1
- 2011-06-25 1
- 2011-07-01 1
- 2011-11-13 1
- 2011-12-11 1
- 2012-03-15 1
- 2012-06-04 1
- …
musiccaps_names (array) >30 ✖
- Music 44
- Singing 9
- Guitar 6
- Musical instrument 6
- Plucked string instrument 6
- Song 5
- Soul music 5
- Independent music 4
- Blues 3
- Christian music 3
- Christmas music 3
- Reggae 3
- Sad music 3
- Wedding music 3
- Acoustic guitar 2
- Country 2
- Funk 2
- Gospel music 2
- Happy music 2
- Inside, small room 2
- Rhythm and blues 2
- Rock music 2
- Ukulele 2
- /m/05zppz 1
- /t/dd00003 1
- /t/dd00004 1
- Accordion 1
- Bagpipes 1
- Brass instrument 1
- Choir 1
- …
musiccaps_aspects (array) >30 ✖
- emotional · 47 ✖
- sentimental 26
- mellow 19
- slow tempo 19
- medium tempo 17
- romantic 17
- male singer 14
- passionate 14
- soft 14
- acoustic guitar 13
- steady drumming 12
- keyboard harmony 11
- love song 11
- male vocalist 11
- keyboard accompaniment 10
- instrumental 9
- melodic 8
- pop 8
- rhythmic acoustic guitar 8
- country pop 7
- female singer 7
- foreign language 7
- dulcet 6
- groovy bass line 6
- melancholic 6
- poignant 6
- soothing 6
- youthful 6
- auto harp 5
- christian song 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;