musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "romantic theme" and musiccaps_aspects contains "simple percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- bass · 2 ✖
- romantic theme · 2 ✖
- simple percussion · 2 ✖
- backing vocal harmony 1
- female voice 1
- male voice 1
- muted guitar 1
- piano 1
- piano song 1
- pop ballad 1
- pop song 1
- slow tempo 1
- string section 1
- synth fill 1
- vocal harmony 1
- vocal octaves 1
musiccaps_names (array) 6 ✖
- Music 2
- Christian music 1
- Funk 1
- Happy music 1
- Independent music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Carpenters - You | This pop song starts off with the backing singers singing vocables in harmony. This is backed by percussion playing a simple beat. The bass plays a flourish ending on the root note of the next chord. The string section plays high pitched notes. The piano plays a flourish of ascending notes before the main female voice starts to sing the main melody. This is accompanied by the percussion continuing with the simple beat. The string section fades away. The bass plays a descending walk down and ends on a high note. This song has a romantic feel. This song can be played in a romantic movie. | 2008-06-25T12:52:31Z | sisterlead02 | One of their beautiful songs! From A kind of hush album. | ["Singing", "Christian music", "Music"] | ["pop song", "female voice", "bass", "backing vocal harmony", "simple percussion", "piano", "string section", "slow tempo", "romantic theme"] | 0 | 6QHfXuVLhe0 | 755 | |
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;