musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocal", musiccaps_names contains "Singing" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bass guitar 3
- male vocal · 3 ✖
- acoustic drums 2
- electric guitar 2
- groovy 2
- acoustic guitar 1
- ambient synth 1
- christian 1
- country music 1
- devotional 1
- easygoing 1
- electronic drums 1
- experimental pop 1
- gospel 1
- indie rock 1
- keyboard 1
- male choir 1
- melodic singing 1
- passionate singing 1
- psychedelic 1
- religious 1
- sound effects 1
- spiritual 1
- story-telling mood 1
- trippy 1
- western swing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Keith Wonderboy Johnson "Time to Get Close to Jesus" {Official Video} | This is a Christian gospel music piece. There is a male vocalist singing passionately in the lead with a male choir that is at a relatively higher pitch than him singing in the back. The main melody is played by the keyboard and the electric guitar. There is a bass guitar that can be heard. The acoustic drums are playing an upbeat rhythm. The atmosphere is religious. This piece could be played at Christian religious events. | 2009-01-05T22:09:48Z | Daphanie Cassel | Official Video for the New Single, Time to Get Close to Jesus, from Keith Wonderboy Johnson & The Spiritual Voices. | ["Singing", "Music", "Ska"] | ["gospel", "christian", "male vocal", "passionate singing", "male choir", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "religious", "spiritual", "devotional"] | 9 | xmSMAmnoRug | 5352 | |
Jim Reeves on the Grand Ole Opry This May Well Be The Best Jim Reeves Video on Youtube www keepvid com | This is a country/western swing music piece. There is a male vocalist singing melodically in the lead with a story-telling attitude. The main tune is being played by the electric guitar with a bass guitar backing. The rhythm is being played by the acoustic drums. The atmosphere is easygoing. This piece could be playing in the background at an American roadside diner. | 2010-06-16T20:31:33Z | petedrakemusic | ["Singing", "Country", "Music", "Ska", "Song"] | ["country music", "western swing", "male vocal", "melodic singing", "story-telling mood", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "groovy"] | 9 | ymGg5TA2YfM | 5437 |
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;