musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- male voice · 3 ✖
- bass guitar 2
- female voice 2
- acoustic drums 1
- banjo song 1
- cebuano language 1
- cheerful 1
- christmas music 1
- christmas vibes 1
- drums 1
- duet 1
- electric guitar 1
- electric piano 1
- festive 1
- folk song 1
- guitar song 1
- happy mood 1
- melodic singing 1
- minimal instruments 1
- moderate tempo 1
- no percussion 1
- repetitive melody 1
- synth sound 1
- vocal harmony 1
musiccaps_names (array) 9 ✖
- Christmas music · 3 ✖
- Music 3
- Jingle (music) 2
- Banjo 1
- Bluegrass 1
- Christian music 1
- Country 1
- Pop music 1
- Song 1
youtube_published (date) 3 ✖
- 2009-12-12 1
- 2010-12-10 1
- 2012-12-24 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cool Christmas Songs | The music features a male voice singing a melody in the med-high register. The drummer plays a steady and repeating rhythm. The bass guitar, for the most part, plays two repeating notes every beat. A synth sound is playing a melody in the mid-high register. Listening to this song I get Christmas vibes. | 2009-12-12T18:07:55Z | Arvanne H.V.B | Subscribe for more cool music videos! LINK TO THE SECOND VIDEO: http://www.youtube.com/watch?v=9WTTqlja0_U LINK TO THE FIRST TECHNO EDITION!: http://www.youtube.com/watch?v=ljuUIjYFRg8 LINK TO THE SWEDISH TECHNO EDITION!: http://www.youtube.com/watch?v=6M7dnmnnO_o I Love Christmas, and their songs, So I uploaded a video with 4 Christmas songs! Please react and rate! Playlist: Wham- Last Christmas Cher- Chrismas Maria Carey- All I Want For Christmas Dean Martin-Let It Snow | ["Christmas music", "Jingle (music)", "Music", "Pop music"] | ["male voice", "drums", "synth sound", "bass guitar", "christmas vibes"] | 2 | XwhAoMLNYWQ | 3238 | |
Scar Tissue (The Red Hot Chili Peppers) | This folk song is a duet and features a male and a female voice singing in harmony. This is accompanied by an acoustic guitar strumming chords. A banjo player fills in between lines. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be played in a coffee shop. | 2012-12-24T02:14:04Z | goosebearmusic | if you dig the tune you can download it here: https://soundcloud.com/thejunebugs/scar-tissue-the-red-hot-chili Goose and me throwing out some 90's folk... or something like that. | ["Christmas music", "Banjo", "Country", "Music", "Song", "Bluegrass"] | ["folk song", "duet", "male voice", "female voice", "vocal harmony", "banjo song", "guitar song", "no percussion", "minimal instruments", "happy mood", "moderate tempo", "repetitive melody"] | 0 | f6wrXzvByrg | 3922 | |
Mag-ambahan | This is a Christmas music piece. There is a male voice and a female voice singing melodically in the Cebuano language. The electric piano is playing the main melody while the electric guitar and the bass guitar are playing in the background. The rhythm is provided by a simple and upbeat acoustic drum beat. The atmosphere is festive and cheerful. This piece could be the opening theme of a Christmas movie that takes place in the southern Philippines. | 2010-12-10T09:35:04Z | ryahnz | Mag-ambahan ta ning pasko sa kalipay Ang kagul-anan ta ato nga isalikway Ug duyog ning awit sa malipayong dughan Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya Wad-on ta ang mga kayugot Isalikway ta ang pagdumot Ang pagpasaylo mao'y angay buhaton ta Ning adlaw sa manunubos (Repeat Mag-ambahan stanza) Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya | ["Christmas music", "Christian music", "Jingle (music)", "Music"] | ["christmas music", "male voice", "female voice", "melodic singing", "cebuano language", "electric piano", "electric guitar", "bass guitar", "acoustic drums", "festive", "cheerful"] | 9 | tDZPGf8WYmI | 5016 |
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;