musiccaps_details (view)
44 rows where search matches "guitar", musiccaps_aspects contains "mellow" and musiccaps_author = 7
This data as json
youtube_published (date) >30 ✖
- 2008-09-22 2
- 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-21 1
- 2008-07-26 1
- 2008-09-19 1
- 2008-12-22 1
- 2009-02-13 1
- 2009-03-21 1
- 2009-04-17 1
- 2009-08-01 1
- 2009-11-23 1
- 2009-12-03 1
- 2010-02-19 1
- 2010-11-22 1
- 2011-03-15 1
- 2012-07-08 1
- 2012-12-14 1
- 2012-12-16 1
- 2012-12-19 1
- 2012-12-25 1
- 2013-07-10 1
- …
musiccaps_names (array) >30 ✖
- Music 41
- Guitar 7
- Musical instrument 5
- Plucked string instrument 5
- Song 5
- Acoustic guitar 4
- Soul music 4
- Christian music 3
- Christmas music 3
- Flamenco 3
- Steel guitar, slide guitar 3
- Strum 3
- Tender music 3
- Ukulele 3
- Country 2
- Effects unit 2
- Electric guitar 2
- Reggae 2
- Sad music 2
- /t/dd00032 1
- Ambient music 1
- Background music 1
- Bird vocalization, bird call, bird song 1
- Blues 1
- Brass instrument 1
- Chirp, tweet 1
- Chorus effect 1
- Distortion 1
- Echo 1
- Exciting music 1
- …
musiccaps_aspects (array) >30 ✖
- mellow · 44 ✖
- soft 29
- slow tempo 24
- emotional 19
- sentimental 16
- instrumental 15
- medium tempo 13
- soothing 13
- acoustic guitar 12
- dulcet 12
- romantic 12
- keyboard harmony 10
- steady drumming 10
- male singer 9
- male vocalist 8
- melancholic 8
- mellifluous 8
- acoustic guitar accompaniment 7
- female vocalist 7
- pleasant 7
- poignant 7
- simple melody 7
- country pop 6
- melodic 6
- nostalgic 6
- pop 6
- auto harp 5
- keyboard accompaniment 5
- love song 5
- pensive 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;