musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass · 2 ✖
- simple percussion · 2 ✖
- backing vocal harmony 1
- distortion guitar 1
- female voice 1
- gothic rock 1
- male voice 1
- moderate tempo 1
- piano 1
- pop song 1
- romantic theme 1
- slow tempo 1
- string section 1
- suspenseful song 1
- synth 1
musiccaps_names (array) 7 ✖
- Music 2
- Singing · 2 ✖
- Christian music 1
- Heavy metal 1
- Psychedelic rock 1
- Rock music 1
- Song 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 | |
Top 10 songs Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | This gothic rock song features a male voice singing the main melody. The melody is repetitive for each line. This is accompanied by percussion playing a simple rock beat in common time. A distortion guitar plays power chords. A synth plays a high pitched repetitive melody. This song has a suspenseful feel. This song can be played in a horror movie. | 2009-08-13T22:53:50Z | Dyhg | Top 10 de musica oscura Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | ["Singing", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song"] | ["gothic rock", "male voice", "distortion guitar", "simple percussion", "bass", "synth", "suspenseful song", "moderate tempo"] | 0 | WRZGYDh7qRo | 3094 |
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;