musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- male voice · 4 ✖
- drums 2
- acoustic guitar 1
- bass guitar 1
- celebration song 1
- christmas vibes 1
- disco song 1
- distortion effect 1
- electric guitar 1
- foreign language 1
- funk bass 1
- guitar lead 1
- guitar strums 1
- hand claps 1
- happy mood 1
- moderate tempo 1
- pop rock 1
- pop rock genre 1
- reverb guitar 1
- simple bass 1
- simple percussion 1
- slow rock 1
- slow tempo 1
- synth bass 1
- synth sound 1
- synth string backing 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 9 ✖
- Music 4
- Pop music · 4 ✖
- Jingle (music) 2
- Christmas music 1
- Exciting music 1
- Funk 1
- Ska 1
- Song 1
- Soul music 1
youtube_published (date) 4 ✖
- 2008-09-09 1
- 2009-12-12 1
- 2013-01-20 1
- 2014-08-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Adv. of the Galaxy Rangers Music Video | The pop rock music features a male voice singing. An electric guitar with a distortion effect on plays plays two chords every two measures. The drums play a strong rhythm and together with a synth bass drive the pulse of the music. | 2008-09-09T09:05:57Z | MightyHedgehog | The 'music video' for the Adventures of the Galaxy Rangers cartoon show. The song is called 'No Guts, No Glory'...the theme played in the show's intro. | ["Funk", "Music", "Pop music", "Ska", "Exciting music"] | ["male voice", "electric guitar", "distortion effect", "drums", "synth bass", "pop rock genre"] | 2 | -hSMzrWZCAE | 74 | |
Idiot Wind - Find The Rhythm In The Noise | This pop rock song features a male voice. This is accompanied by percussion playing a simple beat in common time. A lead guitar with heavy reverb plays a fill in between lines. An acoustic guitar strums chords in the background. A bass plays the root notes of the chords. The mood of this song is romantic. This song is played at a slow tempo. This song can be played in a retro romantic movie. | 2013-01-20T19:47:00Z | Paul Martin | http://www.idiotwind.se/se Amanda Bergman is a Swedish singer-songwriter. She performs under the stage name Idiot Wind and has also performed as Hajen and Jaw Lesson Bergman co-wrote the score for the Swedish movie En Gång Om Året (Once A Year). | ["Music", "Pop music", "Song", "Soul music"] | ["slow rock", "pop rock", "male voice", "guitar lead", "simple percussion", "slow tempo", "simple bass", "acoustic guitar", "reverb guitar"] | 0 | BjAL68IMlp0 | 1281 | |
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 | |
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 |
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;