musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy" and musiccaps_names contains "Psychedelic rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- happy · 2 ✖
- medium tempo 2
- acoustic drums 1
- badly tuned strings 1
- cello playing 1
- cheerful 1
- discordant harmonies 1
- e-guitar 1
- experimental 1
- groovy cello bass 1
- groovy rhythm 1
- indie music 1
- light sounding 1
- male singers 1
- offbeat 1
- old world charm 1
- oriental sounding string instrument 1
- poor video quality 1
- pop 1
- psychedelic pop 1
- quirky and eccentric 1
- story telling 1
- strumming guitars 1
- synthesizer bit sound 1
- vocal harmony 1
musiccaps_names (array) 4 ✖
- Music 2
- Psychedelic rock · 2 ✖
- Independent music 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sita's Fire from Sita Sings the Blues - Music by Egemen Sanli | This song has some experimental sounds. The string instrument sounds processed and slightly oriental. The synth plucks sound as running through different effects that are changing the bit rate and some filters. These elements are panned to the right and left and right side of the speakers playing different melodies. An acoustic drum is holding the whole construct together while an e-bass is playing his own run along with the drums. An e-guitar is playing long single chords. This song may be playing in an adventurous indie-videogame. | 2011-05-01T11:51:25Z | Egemen Sanli | This is a derivative work of Nina Paley's inspiring animation "Sita Sings the Blues" Ms. Paley is a revolutionary artist who advocates copyleft licences and free culture movement. The free culture movement is a social movement that promotes the freedom to distribute and modify creative works in the form of free content by using the Internet and other forms of media. This is my take on a part of her amazing work. I was truly inspired by this story and I had to do something about it. To watch the whole movie: http://www.sitasingstheblues.com/ Listen on Spotify: https://open.spotify.com/artist/39Hxxiq33beoXGP8uKjbXi Listen on iTunes: https://itunes.apple.com/us/artist/egemen-sanli/356530309 https://egemensanli.com/ https://www.facebook.com/turksitar/ https://soundcloud.com/egesan/ https://www.instagram.com/egesan/ | ["Music", "Psychedelic rock"] | ["pop", "oriental sounding string instrument", "synthesizer bit sound", "e-guitar", "acoustic drums", "experimental", "medium tempo", "happy", "light sounding"] | 6 | PeQ8L_svYcU | 2552 | |
Strobe Light by Luke Janela - Cello Rock Music | Male singers sing this vocal harmony. The song is medium tempo with steady drumming rhythm, cello playing the bass line, guitars strumming rhythm and various percussion hits. The song is chaotic and exciting. The song is an amateur band playing a retro pop song with audio quality. | 2009-10-14T23:46:39Z | Luke Janela | Buy the album, REDWOOD SUMMER on iTunes at: http://itunes.apple.com/us/album/redwood-summer/id336710013 or order the cd at: http://www.cdbaby.com/cd/lukejanela5 Cellist/Songwriter Luke Janela performs the song "Strobe Light" off his album REDWOOD SUMMER. | ["Music", "Punk rock", "Independent music", "Psychedelic rock"] | ["cello playing", "discordant harmonies", "offbeat", "groovy rhythm", "old world charm", "indie music", "poor video quality", "male singers", "vocal harmony", "strumming guitars", "medium tempo", "groovy cello bass", "quirky and eccentric", "badly tuned strings", "cheerful", "happy", "story telling", "psychedelic pop"] | 1 | oYECB7KFJgU | 4639 |
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;