musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy mood" and musiccaps_aspects contains "no other instruments"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- happy mood · 2 ✖
- no other instruments · 2 ✖
- female voice 1
- fingerpicking 1
- folk song 1
- instrumental 1
- lute song 1
- moderate tempo 1
- no percussion 1
- no voices 1
- pop rock 1
- rock drums 1
- slow tempo 1
- sound of folding paper 1
- stringed instrument 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Italian Pavan - (lute) | This instrumental song features a lute being played. This is played using fingerstyle. The song sounds like a folk song. There are no other instruments in this song. There are no voices in this song. This song can be played in a documentary scene with green hills at the backdrop. The mood of this song is happy. | 2007-05-18T05:28:11Z | luteplayer80 | A short but beautiful dance by Joanambrosio Dalza. Somebody asked more italian renaissance music, so... here it is!!! Hope you'll like it :)))))) | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["lute song", "no percussion", "no other instruments", "no voices", "instrumental", "stringed instrument", "fingerpicking", "folk song", "slow tempo", "happy mood"] | 0 | K63Z_abB314 | 2057 | |
Avril Lavigne - Here's to Never Growing Up (Official Lyric Video) | This pop rock song features a female voice singing the main melody. The song starts off with the sound of folding paper. Then the voice starts singing. This is accompanied by rock drums playing the kick drum. The snare is struck at every alternate count. The reverb effect is added to the percussion. There are no other instruments in this song. This song has a happy mood. This song can be played in an intro scene of a coming-of-age movie. | 2013-04-09T14:15:06Z | AvrilLavigneVEVO | Download the "Avril Lavigne" album here: http://smarturl.it/avril-lavigne Spotify: http://open.spotify.com/album/512J2VIGOTP50qp5MNEUyG Follow Avril: http://www.avrillavigne.com http://youtube.com/AvrilLavigneVEVO http://twitter.com/AvrilLavigne http://facebook.com/avrillavigne http://instagram.com/avrillavigne | ["Music", "Crumpling, crinkling"] | ["pop rock", "female voice", "moderate tempo", "rock drums", "sound of folding paper", "no other instruments", "happy mood"] | 0 | iFSaNmZyPQo | 4173 |
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;