musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Happy music" sorted by video
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- simple percussion · 2 ✖
- bass 1
- bass guitar 1
- country song 1
- female voice 1
- male voice 1
- moderate tempo 1
- muted guitar 1
- pedal steel guitar 1
- piano song 1
- pop ballad 1
- romantic mood 1
- romantic theme 1
- synth fill 1
- vocal harmony 1
- vocal octaves 1
musiccaps_names (array) 4 ✖
- Happy music · 2 ✖
- Music 2
- Funk 1
- Independent music 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This country song features a female voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. A pedal steel guitar plays sliding licks in the background. The bass plays the root and fifth of the chords. The mood of this song is romantic. This song can be played in a romantic movie. | ["Music", "Happy music"] | ["country song", "female voice", "pedal steel guitar", "bass guitar", "simple percussion", "moderate tempo", "romantic mood"] | 0 | 2699 | |||||
Tony Wilson - just one time | This pop ballad features two male voices singing in octaves. This is accompanied by percussion playing a simple beat. A bass plays the root notes of the chords. A piano plays the chords by striking them just once per bar. When the voice pauses between verses, another voice sings descending pattern vocables in falsetto. When the main voice resumes, a synth fill is played along with a muted guitar. The rest of the instruments continue to play their respective parts. This song has a romantic mood. This song can be played in a romantic movie. | 2014-03-25T09:41:11Z | Gvantsa Tsutsko | https://www.youtube.com/channel/UCvW36-FtYjhZli7AsVAGVBw | ["Funk", "Music", "Independent music", "Happy music"] | ["pop ballad", "piano song", "simple percussion", "male voice", "romantic theme", "vocal harmony", "vocal octaves", "muted guitar", "bass", "synth fill"] | 0 | lV0-LMVpZLg | 4405 |
Advanced export
JSON shape: default, array, newline-delimited
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;