musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_author = 6 and musiccaps_names contains "Psychedelic rock" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 15 ✖
- acoustic drums 3
- medium tempo · 3 ✖
- bluesrock 2
- e-bass 2
- e-guitar 2
- background cheering 1
- experimental 1
- guitars 1
- happy 1
- light sounding 1
- male mid range voice singing 1
- oriental sounding string instrument 1
- pop 1
- slide guitar 1
- synthesizer bit sound 1
musiccaps_names (array) 5 ✖
- Music 3
- Psychedelic rock · 3 ✖
- Bass guitar 1
- Rock and roll 1
- Rock music 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 | |
Merle Haggard Blue Yodel #9 Standin' On The Corner | This seems to be a life recording because you can hear people in the background cheering. An electric bass is playing a bluesy bassline along with the drums holding a simple steady groove. One guitar is panned to the right side of the speakers playing chords while another e-guitar is playing a melody on the left side of the speakers. Both are fairly in the background. A male mid ranged voice is singing with a little reverb on his voice. This song may be playing life at a festival. | 2012-06-24T01:38:42Z | Lancuhsturcounty | Merle's live cover of a Jimmie Rodgers classic. From the album Rainbow Stew. Live in Anaheim Stadium in 1981. | ["Music", "Psychedelic rock", "Rock and roll"] | ["bluesrock", "e-bass", "background cheering", "guitars", "acoustic drums", "male mid range voice singing", "medium tempo"] | 6 | ZJZxWLYzNh8 | 3360 | |
SHUFFLE BLUES - Lap Steel Lessons in Open D Tuning | An acoustic drum set is playing a shuffle groove with hits on the ride along with an e-bass playing a blues walking bassline. Someone is playing a slide-e-guitar. This song may be playing at a live concert. | 2014-06-12T23:05:38Z | Troy Brenningmeyer | http://www.LessonsWithTroy.com - for Tablature + Jam Tracks + Performance Tracks + Full Lesson check out the site! | ["Bass guitar", "Music", "Psychedelic rock", "Rock music"] | ["bluesrock", "e-guitar", "slide guitar", "acoustic drums", "e-bass", "medium tempo"] | 6 | kVuG_F3qCuY | 4325 |
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;