musiccaps_details (view)
2 rows where musiccaps_aspects contains "contemporary" and musiccaps_names contains "Musical instrument" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- contemporary · 2 ✖
- acoustic guitar 1
- artist 1
- blues 1
- cello 1
- cheering clapping 1
- classical music 1
- closing riff 1
- concert 1
- eccentric 1
- eerie 1
- electric guitar 1
- electronic sounding 1
- energetic 1
- enthusiastic 1
- gig 1
- instrumental 1
- live audience 1
- live performance 1
- male vocalist 1
- medium fast tempo 1
- performer 1
- rock 1
- soft rock 1
- song end 1
- southern rock 1
- stage performance 1
- theremin 1
- weird 1
musiccaps_names (array) 8 ✖
- Music 2
- Musical instrument · 2 ✖
- Bass guitar 1
- Guitar 1
- Plucked string instrument 1
- Rock music 1
- Singing 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Curtis Stigers-This Life | A male vocalist sings this spirited song. The tempo is medium fast with an acoustic and electric guitar flourish with a bass cello. This bit is the end of the song as the musician plays a closing riff and the sound of clapping and cheering can be heard. This song is an enthusiastic live performance of an energetic Soft Rock. | 2012-04-19T22:49:45Z | Roxxboise | Sons of Anarchy theme song from Curtis Stigers in-studio at KRVB, "The River," Boise, Idaho. | ["Singing", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["male vocalist", "medium fast tempo", "song end", "closing riff", "live performance", "concert", "live audience", "gig", "stage performance", "cheering clapping", "acoustic guitar", "electric guitar", "cello", "southern rock", "blues", "rock", "contemporary", "soft rock", "enthusiastic", "energetic", "performer", "artist"] | 7 | kkOGbgGJLF4 | 4352 | |
Carolina Eyck /Theremin - Elephant in Green (live 2015) | This is a contemporary classic music piece being performed on a theremin. The player gives the theremin and electronic sounding character. The atmosphere is weird and eccentric. This piece could go well in the soundtrack of an absurdist/surrealist art movie. | 2015-05-17T17:11:22Z | Carolina Eyck | This song is available for streaming and download on my new album for Theremin & Voice "Elephant in Green" https://www.carolinaeyck.com/elephant-in-green 🐘💚 ------- Encore after the performance of Kalevi Aho's Theremin Concerto "Eight Seasons" with Staatskapelle Halle and conductor Luke Dollman. Performed live on April 20, 2015 at the Georg-Friedrich-Händel-Halle in Halle, Germany. WEBSITE: http://carolinaeyck.com FACEBOOK: https://facebook.com/carolinaeyck TWITTER: https://twitter.com/CarolinaEyck Many thanks to Tom Fichtner for the recording! | ["Music", "Musical instrument", "Theremin"] | ["classical music", "contemporary", "theremin", "electronic sounding", "instrumental", "weird", "eerie", "eccentric"] | 9 | MX0wS7MX3Zo | 2277 |
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;