musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocal", musiccaps_aspects contains "simple" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Indie Music Lounge - Amy | This is an indie/alternative music piece. There is a male vocalist singing melodically. In the background, an eastern sounding tune is playing with a bass and electronic drum beat alongside it. The atmosphere is generic and easygoing. This piece could fit well as an advertisement jingle. | 2013-06-30T15:52:07Z | janicehunter75 | Indie Music Lounge "indie music" "indie music videos" "indie rock" "indie band" "recording studio" "music gear" "pro tools" "pro audio" bogner marshall neve api "universal audio" drums bass teletronix fender mesaboogie ssl shure neuman akg | ["Jingle (music)", "Music", "Song"] | ["indie rock", "alternative", "male vocal", "melodic singing", "eastern tune", "bass", "electronic drums", "simple", "generic", "easygoing"] | 9 | WoWF7gGzGVY | 3137 | |
Dos Eddies-Come And Get Your Love (cover)-HD-Ogden Tap Room-Ogden, NC-6/14/14 | This is a live acoustic performance of a rock music song. There is a male vocalist singing at a medium-to-high pitch in a melodic manner while two acoustic guitars are carrying the background with a simple tune composed of only four chords. The music might be played at a bar in the background. | 2014-06-17T01:56:11Z | castromusicfreak | Dos Eddies performing Redbone's "Come And Get Your Love" at the Ogden Tap Room in Ogden, NC on 6/14/14. Greg Miller and Mark Weathers have created an acoustic duo version of The Steady Eddies, streamlined for those events that call for an unplugged experience. For more information about Dos Eddies, visit their Facebook page at: https://www.facebook.com/pages/Dos-Eddies/152709704894082 Video by Sue Kropp A Stolen Rune Recording | ["Country", "Music"] | ["acoustic rock", "acoustic guitar", "male vocal", "live performance", "simple", "melodic", "easygoing"] | 9 | eiFyXXqd9Rk | 3892 | |
George Formby - When i'm cleaning windows | This is an acoustic comedic piece. The male vocalist is singing in a manner similar to a bard, telling us a story. He is also playing the melody on a ukulele at the same time. The tune is very simple and easygoing. The atmosphere is jovial. This could be used in the soundtrack of a comedy movie or in the background of a funny video. | 2007-12-25T17:49:28Z | Petey1308 | Formby singing "When I'm cleaning windows" with his uke | ["Music", "Musical instrument", "Ukulele"] | ["comedic", "ukulele", "male vocal", "story-telling mood", "repeated theme", "simple", "jovial", "easygoing", "acoustic"] | 9 | sfmAeijj5cM | 4969 |
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;