musiccaps_details (view)
2 rows where musiccaps_aspects contains "epic", musiccaps_aspects contains "instrumental", musiccaps_author = 2 and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
angry birds star wars boss music (duel of the fates) | The music features an orchestra playing a fast tempo piece. Since the song is purely instrumental there is no voice singing. The trombones and the trumpets stand out the most. The music is epic and can work pretty well for a movie, especially a chasing scene. | 2014-01-07T23:22:01Z | Miguel Timoty 99 | ["Jazz", "Music", "Rhythm and blues"] | ["orchestra", "instrumental", "no voice", "trumpets", "trombones", "fast tempo", "epic", "movie music"] | 2 | 38R9Vnwt890 | 443 | ||
100 Greatest Classical Music Works | The orchestral music is purely instrumental and makes an exception only towards the ending of the music excerpt, where a male voice can be heard. Throughout this passage one can notice that segments of three different pieces are played one after the other, the 3rd one being the shortest - about 1 second in length. The first piece sounds like it depicts a dance, the second one an epic moment and the 3rd one is too short to draw any conclusions. | 2012-05-19T06:27:33Z | bornahorn | My list of the 100 greatest classical music pieces of all time | ["Music", "Classical music"] | ["instrumental", "male voice", "orchestra", "collage", "epic", "classical music genre"] | 2 | NhVkzcCL0SA | 2356 |
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;