musiccaps_details (view)
3 rows where musiccaps_aspects contains "romantic theme" and musiccaps_aspects contains "vocal harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- romantic theme · 3 ✖
- vocal harmony · 3 ✖
- male voice 2
- acapella 1
- amateur recording 1
- bass 1
- double bass 1
- drums 1
- guitar 1
- live recording 1
- low quality music 1
- male voices 1
- moderate tempo 1
- muted guitar 1
- no instruments 1
- no lyrics 1
- piano song 1
- pop ballad 1
- simple percussion 1
- slow rock 1
- slow tempo 1
- synth fill 1
- vocables 1
- vocal octaves 1
musiccaps_names (array) 9 ✖
- Music 2
- A capella 1
- Electric guitar 1
- Funk 1
- Guitar 1
- Happy music 1
- Independent music 1
- Tick 1
- Vocal music 1
youtube_published (date) 3 ✖
- 2007-10-22 1
- 2010-02-16 1
- 2014-03-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Deer Tick 10-18-2007 Ashamed 1/10 | This song is a low quality live recording of a performance. This features a male voice singing the main melody. At the end of the song, other voices sing with the main voice in harmony. This is accompanied by an electric guitar plucking chords. The double bass plays the root notes of the chords. The percussion plays the cymbal, increasing volume slowly, giving it a swell feel. The mood of the song seems romantic. | 2007-10-22T00:17:05Z | vincenz7 | Live @ Cakeshop. CMJ's. Unfortunately it got cut 1 1/2 minutes into the song. But check out the rest of the show! | ["Electric guitar", "Guitar", "Music", "Tick"] | ["live recording", "male voice", "slow rock", "guitar", "double bass", "drums", "low quality music", "romantic theme", "vocal harmony", "moderate tempo"] | 0 | P90rFZQFqWk | 2510 | |
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 | |
Bon Iver - For Emma A cappella | This song features a pop song being sung by male voices in acapella . The voices sing the different parts of a choir. They are singing vocables and not words. The voices sing in harmony. Voices are singing the bass; alto and tenor parts. The mood of this song is romantic. This is an amateur recording. This song can be played in a romantic movie. | 2010-02-16T16:53:38Z | mghadiri | All male a cappella group G-Tones at Grinnell College singing Bon Iver - For Emma for our Haiti benefit concert. | ["Vocal music", "A capella"] | ["amateur recording", "acapella", "male voices", "vocal harmony", "no instruments", "slow tempo", "vocables", "no lyrics", "romantic theme"] | 0 | qwz7oLASJqg | 4837 |
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;