musiccaps_details (view)
1 row where musiccaps_aspects contains "female voice", musiccaps_aspects contains "sound of folding paper" and musiccaps_author = 0
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;