musiccaps_details (view)
90 rows where search matches "guitar" and musiccaps_aspects contains "mellow"
This data as json
youtube_published (date) >30 ✖
- 2008-09-22 2
- 2006-08-06 1
- 2006-10-14 1
- 2007-01-23 1
- 2007-02-06 1
- 2007-02-17 1
- 2007-07-08 1
- 2007-11-02 1
- 2008-02-16 1
- 2008-02-17 1
- 2008-06-05 1
- 2008-06-12 1
- 2008-07-09 1
- 2008-07-13 1
- 2008-07-21 1
- 2008-07-26 1
- 2008-07-30 1
- 2008-09-19 1
- 2008-12-02 1
- 2008-12-22 1
- 2009-01-02 1
- 2009-01-19 1
- 2009-01-25 1
- 2009-02-13 1
- 2009-03-21 1
- 2009-04-17 1
- 2009-06-13 1
- 2009-08-01 1
- 2009-08-13 1
- 2009-11-23 1
- …
musiccaps_names (array) >30 ✖
- Music 81
- Guitar 15
- Plucked string instrument 14
- Musical instrument 12
- Song 9
- Effects unit 8
- Acoustic guitar 7
- Christian music 7
- Independent music 6
- Singing 6
- Tender music 6
- Reverberation 5
- Soul music 5
- Wedding music 5
- Distortion 4
- Electric guitar 4
- Flamenco 4
- Strum 4
- Ukulele 4
- Christmas music 3
- Country 3
- Echo 3
- Happy music 3
- New-age music 3
- Rock music 3
- Sad music 3
- Steel guitar, slide guitar 3
- Ambient music 2
- Brass instrument 2
- Chant 2
- …
musiccaps_aspects (array) >30 ✖
- mellow · 90 ✖
- soft 43
- emotional 30
- slow tempo 28
- acoustic guitar 24
- instrumental 21
- sentimental 18
- low quality 17
- medium tempo 15
- easygoing 13
- electric guitar 13
- romantic 13
- soothing 13
- dulcet 12
- keyboard harmony 10
- steady drumming 10
- male singer 9
- male vocal 9
- melancholic 9
- passionate 9
- bass guitar 8
- male vocalist 8
- mellifluous 8
- melodic singing 8
- acoustic drums 7
- acoustic guitar accompaniment 7
- dreamy 7
- female vocalist 7
- melodic 7
- noisy 7
- …
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;