musiccaps_details (view)
4 rows where musiccaps_aspects contains "male vocal", musiccaps_names contains "Singing" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- male vocal · 4 ✖
- bass guitar 3
- melodic singing 3
- acoustic drums 2
- acoustic guitar 2
- easygoing 2
- electric guitar 2
- groovy 2
- acoustic sounding drums 1
- alternative rock 1
- ambient synth 1
- christian music 1
- country music 1
- crowd cheering 1
- electronic drums 1
- emotional 1
- experimental pop 1
- gentle 1
- gospel 1
- harp sound 1
- indie rock 1
- keyboard 1
- korean indie rock 1
- live performance 1
- mellow 1
- psychedelic 1
- religious 1
- simple tune 1
- slow tempo 1
- sound effects 1
- …
musiccaps_names (array) 10 ✖
- Music 4
- Singing · 4 ✖
- Song · 4 ✖
- Ska 2
- Choir 1
- Country 1
- Gospel music 1
- Independent music 1
- Pop music 1
- Skateboard 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Yaweh(Official Video HD)- Ausward 2014 | This is a Christian gospel music piece. There is a male vocalist singing melodically and in an emotion-filled manner. The keyboard is playing the melody with a harp sound while the rhythmic background consists of a simple acoustic sounding drum beat that is only played on the hi-hats. The atmosphere is spiritual. This piece could be playing in the background at a Christian religious event. | 2014-03-08T09:11:01Z | Sfe Productions | Artist: Ausward Title: Yaweh Video by Bezariel Mwanza for Sound Factory Entertainment. For more information contact 0977751165 or 0966963340. | ["Singing", "Gospel music", "Music", "Song", "Choir"] | ["gospel", "christian music", "live performance", "crowd cheering", "male vocal", "melodic singing", "keyboard", "harp sound", "acoustic sounding drums", "religious", "spiritual", "emotional"] | 9 | AVogdV8khxc | 1128 | |
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 | |
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
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;