musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "male singer" and musiccaps_author = 8 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- male singer · 4 ✖
- electric bass 2
- acoustic guitar arpeggios 1
- acoustic guitar strumming 1
- acoustic-electric nylon string guitar 1
- afrobeat 1
- carribean 1
- cello counter melody 1
- drums 1
- electric bass guitar 1
- fingerpicking 1
- free singing 1
- half time feel 1
- heavily distorted audio 1
- international 1
- low fidelity 1
- medium tempo 1
- melancholy 1
- middle eastern 1
- odd meter 1
- piano accompaniment 1
- piano chords 1
- rock beat 1
- sentimenal 1
- simple bass 1
- slow rock drum beat 1
- soft rock 1
- south asain 1
- sweet 1
- syncopated 1
- syncopated drumset 1
- synthesizer brass 1
- tom tom 1
- two chords 1
- various african percussion 1
musiccaps_names (array) 6 ✖
- Music 4
- Folk music 1
- Music for children 1
- Singing 1
- Ska 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ALEM YIFTER TIGREGNA MUSIC 8 | Heavily distorted with poor audio quality, this low fidelity music features syncopation and odd meters, a repetitive tom tom drum, electric bass guitar, synthesized brass sounds, a male singer, and an international flavor. Sounds like it could be middle eastern or south Asian. | 2014-10-09T10:15:54Z | Fekadu Mengesha | ["Folk music", "Music"] | ["heavily distorted audio", "low fidelity", "syncopated", "odd meter", "electric bass", "tom tom", "synthesizer brass", "male singer", "international", "south asain", "middle eastern"] | 8 | mhqHHQ1gSvM | 4486 | ||
Hachiko video with Tunde Bayewu.Dog at work in Belgium.Good cause. | Medium tempo rock drum beat with a half time feel, using only two chords played by acoustic guitar arpeggios, piano chords and a male singer. The mood is sentimental. | 2010-01-22T15:38:38Z | Hachikosupport | Music by Tunde Bayewu (beautiful song anaesthetic) Ann and her dog from hachiko demonstrate perfectly how they have a good band at home and the dog is happy to do his best. A dog trained by Hachiko helps people to be independent and much more. For more info and if you want to support visit the website www.hachiko.org. You can also add hachiko on facebook and twitter. | ["Music", "Music for children"] | ["medium tempo", "rock beat", "half time feel", "drums", "acoustic guitar arpeggios", "piano chords", "two chords", "male singer", "sentimenal"] | 8 | ev_YCCuGVSs | 3906 | |
Alan Parsons Project - Time | A sweet, melancholy sounding soft rock song with a male singer accompanied by acoustic guitar strumming, a cello counter melody, piano, simple electric bass, and a slow rock drum beat. | 2009-09-09T07:18:53Z | BachChannel | No description. | ["Singing", "Music", "Tender music"] | ["soft rock", "cello counter melody", "male singer", "melancholy", "acoustic guitar strumming", "piano accompaniment", "sweet", "slow rock drum beat", "simple bass", "electric bass guitar"] | 8 | too9MtXBwts | 5068 | |
Abandoned Detroit Skyscrapers | Afrobeat inspired music with an island flavor. Fingerpicked acoustic-electric nylon string guitar carries the harmony, while a male singer sings freely. syncopated electric bass and drumset meld with various African percussion. | 2008-07-13T06:16:51Z | SamaritanUSA | http://www.amazon.com/Circling-Yellowstone-ebook/dp/B004VS3K5Y/ref=sr_1_1?ie=UTF8&qid=1311272493&sr=8-1 http://www.amazon.com/Circling-Yellowstone-Tale-Desperate-Misadventure/dp/1461081475/ref=sr_1_2?ie=UTF8&qid=1311299969&sr=8-2 It is an open secret that the downtown of Detroit, Michigan is as empty as the residential districts that surround it. On a walking tour of the city core one July 2008 Sunday, this is what I found; the setting for Detroit 1-8-7. Music is "Little Child" by Din Din Wo. | ["Music", "Ska"] | ["acoustic-electric nylon string guitar", "fingerpicking", "afrobeat", "carribean", "various african percussion", "male singer", "electric bass", "syncopated drumset", "free singing"] | 8 | 0JbGxIR8JTk | 145 |
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;