musiccaps_details (view)
2 rows where musiccaps_aspects contains "simple percussion" and musiccaps_aspects contains "string section"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- simple percussion · 2 ✖
- string section · 2 ✖
- backing vocal harmony 1
- bass 1
- epic feel 1
- female voice 1
- flute bass 1
- instrumental 1
- no voices 1
- orchestra song 1
- piano 1
- pop song 1
- romantic theme 1
- shakers 1
- slow tempo 1
- tambourine 1
- victorious mood 1
musiccaps_names (array) 6 ✖
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 | |
Final Fantasy3『 悠 久 の 風 』 | This orchestral song is an instrumental. There are no voices. It starts off with the string section playing a victorious melody. This is accompanied by percussion playing a simple fill. A timpani is also played. A repetitive lick is played in the background by a plucked or struck instrument. After the strings, a high pitched melody is played with a flute, This song has an epic feel and can be played at the beginning of an adventure scene in a movie. | 2010-07-10T15:18:28Z | DarkSugar178 | 大胆なアレンジですね!でもこう言うの大好きです^^ | ["Background music", "Music", "Rustling leaves", "Soundtrack music"] | ["orchestra song", "instrumental", "no voices", "epic feel", "victorious mood", "string section", "shakers", "simple percussion", "tambourine", "flute bass"] | 0 | sm7eBFHtdeA | 4977 |
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;