musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "star wars" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 14 ✖
- acoustic drums 1
- bass guitar · 1 ✖
- brass 1
- danceable 1
- funk 1
- instrumental 1
- lively 1
- movie theme 1
- outer space 1
- robotic sound effects 1
- space disco 1
- star wars · 1 ✖
- strings 1
- unique 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Star Wars Disco Rampage | This is a space disco music piece. It is a funky version of the Star Wars movie theme. There is a lively combination of the strings and the brass sections playing the main melody while a groovy bass guitar is playing alongside them. The rhythmic background is composed of a disco type acoustic drum beat. Robotic sounds akin to the ones that can be heard in the movie are added in the music. The atmosphere is unique and danceable. This piece could be used in retro-themed parties. It could also be playing in the background at a Star Wars themed event. | 2006-07-18T11:58:51Z | 093306 | lol, I just got Bored and decided to Make a video of the slaughtering of clone troopers and droids from Star Wars. Sorry for the lag. | ["Disco", "Funk", "Music"] | ["space disco", "funk", "instrumental", "star wars", "movie theme", "strings", "brass", "bass guitar", "acoustic drums", "robotic sound effects", "lively", "unique", "danceable", "outer space"] | 9 | 7l4-QmvXxEs | 879 |
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;