musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "psychedelic" and musiccaps_author = 9
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- electronic drums · 2 ✖
- psychedelic · 2 ✖
- trippy 2
- acoustic guitar 1
- ambient synth 1
- bass guitar 1
- effect pedal 1
- electric guitar 1
- experimental pop 1
- groovy 1
- guitar solo 1
- indie rock 1
- instrumental 1
- male vocal 1
- progressive rock 1
- sound effects 1
musiccaps_names (array) 10 ✖
- Music 2
- Electric guitar 1
- Guitar 1
- Independent music 1
- Progressive rock 1
- Rock music 1
- Singing 1
- Ska 1
- Skateboard 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oceans -- Prog Rock Instrumental -- 1976 Electra Omega X210 | This is an instrumental progressive rock piece. There is an electric guitar playing an arpeggio in the melodic background while another is playing a solo as the lead. A simple 4/4 rock beat is with electronic drum sounds. The atmosphere has a trippy, psychedelic feeling to it. This piece could be used in the trip/nightmare sequences of retro themed horror movies. | 2008-07-09T02:39:57Z | wnorcott | http://www.fillmorepedal.com This is a -- S T E R E O -- progressive rock guitar instrumental called Oceans. Played on the 1976 Electra Omega X210 guitar. This guitar piece is kind of like Pink Floyd meets Robin Trower meets Yes. I built the guitar effects myself. The 1976 Electra Omega X210 guitar is a Les Paul Custom with a jacaranda figureboard and Electra's funktastic Magnaflux 50 pickups. I recorded part 2 over on Vimeo here is the link http://www.vimeo.com/1324272 NOTE To play it in stereo type this at the end of the URL &fmt=18 or just click on this link http://www.youtube.com/watch?v=FXQxobF8FWw&fmt=18 I HOPE YOU LIKE IT. | ["Electric guitar", "Guitar", "Music", "Independent music", "Rock music", "Progressive rock"] | ["progressive rock", "instrumental", "electric guitar", "guitar solo", "effect pedal", "electronic drums", "trippy", "psychedelic"] | 9 | FXQxobF8FWw | 1645 | |
Sonar Promo | This is an indie rock piece. There is a male vocalist in the lead with heavy effects. There is an ambient synth in the background playing the melody with the accompaniment of an acoustic guitar. A mellow bass guitar plays a groovy bass line. The rhythmic background consists of an electronic drum beat full of percussion samples. The piece has a trippy aura. It could be played at nightclubs. It could also be used in the soundtracks of drama films with a modern, urban setting. | 2009-12-15T04:16:49Z | swoop hamilton | Sonar is a park based video being filmed in ladslide skatepark in the winter of 2009 each skater wll have an individual part an there is a section for friends the skaters are Jesse Dagle Mike Baldwin Mike Molahan Will Dandalides Alex Podladowsi Michael Demeter Don Bolter and Lincoln Okaji not everyone was in the promo bu everyone has and is in the process of geting footage | ["Singing", "Music", "Skateboard", "Ska", "Song"] | ["indie rock", "experimental pop", "male vocal", "acoustic guitar", "bass guitar", "ambient synth", "electronic drums", "sound effects", "trippy", "groovy", "psychedelic"] | 9 | YrGQKTbiG1g | 3316 |
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;