musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "male voices" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- male voices · 4 ✖
- moderate tempo · 4 ✖
- guitar 2
- simple percussion 2
- accordion music 1
- acoustic guitar 1
- aggressive mood 1
- aggressive voice 1
- bass 1
- bassline 1
- distortion guitar 1
- falsetto voice 1
- female voice 1
- happy mood 1
- heavy metal 1
- keyboard 1
- kick focused percussion 1
- motown feel 1
- piano 1
- r&b song 1
- reggae song 1
- romantic mood 1
- tuba 1
- vocal harmony 1
- waltz song 1
musiccaps_names (array) 5 ✖
- Music 3
- Accordion 1
- Angry music 1
- Happy music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
林司令BastardMarley - Season In The Sun [Official Music Video] | This reggae song features a male voice making an announcement in the beginning. A female voice sings a one-line melody. This is accompanied by the main male voice singing vocables in the background. Until this part, only a keyboard and guitar are playing a reggae rhythm. This is followed by the main male voice singing the main melody in a reggae style. This is accompanied by a kick driven percussion playing a simple beat. There are voices singing vocables in the background. The mood of this song is happy. This song can be played in a movie with a holiday theme. | 2015-08-20T12:00:09Z | UNTV | 作曲:林司令BastardMarley 作詞: 林司令BastardMarley MV影像製作:StayHighCrew 攝影:StayHighCrew 導演:StayHighCrew 剪接後製:StayHighCrew U.N官方SoundCloud: https://soundcloud.com/un_ent U.N官方粉絲專頁: Underground Nation / 地下國度 https://www.facebook.com/UndergroundNationTaiwan YSJ / 楊素貞: https://www.facebook.com/youngsouljaz.tw BastardMarley/林司令: https://www.facebook.com/BastardMarley Tipsy: https://www.facebook.com/TipsyKao1230 4PLAY / 四少: https://www.facebook.com/UN4play 大衛.蕭: https://www.facebook.com/therealdvd StayHighCrew: https://www.facebook.com/SHCProduction | ["Music", "Happy music"] | ["reggae song", "male voices", "female voice", "keyboard", "kick focused percussion", "guitar", "moderate tempo", "happy mood"] | 0 | 2JNY2SaMk7s | 351 | |
T.REX Tribute | This heavy metal song features a male voice singing at a distance in the background. Distortion guitars play a riff and end with a power chord. This is accompanied by percussion playing an aggressive metal beat. The bass follows the rhythm guitar for the beginning of the song and later plays licks while the notes of the distortion guitars are sustained. The mood of this song is aggressive. This song can be played on the entrance of a WWE star into the arena. | 2007-09-10T18:17:52Z | TheDeadLand | why cant i have a go and see what u think first try at a tribute hope u like it for more information go to www.thedeadlandseries.piczo.com music: Three days grace pictures: google and ollirockon well one a gd idea about making a tribute is make it about something, mine is about how t.rex is misunderstood and how no one will ever know what he was really like. | ["Music", "Angry music"] | ["heavy metal", "male voices", "distortion guitar", "bassline", "simple percussion", "aggressive voice", "aggressive mood", "moderate tempo"] | 0 | JxwRvkjNJQ0 | 2047 | |
The Temptations "The Girl's Alright With Me" My Extended Version! | This R&B song features a male voice singing the main melody in falsetto. There are other male voices singing backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords without any flourishes or embellishments. A piano plays an arpeggiated pattern that changes with the chords of the song. A guitar strums chords using upstrokes. The mood of this song is romantic. The melody has a motown feel. This song can be played at the end credits of a romantic movie. | 2012-04-20T20:56:50Z | mosogotam | No copyright infringement intended. One of my favorite Tempts tunes....extended just a smidge. | ["Music", "Soul music"] | ["r&b song", "male voices", "vocal harmony", "falsetto voice", "guitar", "simple percussion", "bass", "piano", "motown feel", "moderate tempo", "romantic mood"] | 0 | LGi38MqlPFA | 2170 | |
Ansambel Lojze Slak / Dezelica sonca in grozdja. | This waltz song features accordions playing in harmony. Male voices sing the main melody. The voices sing in harmony. When the voices start to sing, the accordions play the same melody as the voices. The bass is played on a tuba. An acoustic guitar strums chords. A tambourine plays the part of the percussion. There are trumpets and clarinets playing in this song. This is a folk song. The mood of this song is happy. | 2012-08-09T23:11:27Z | Johan Hopman | Lojzeta Slaka Was A Great Diatonic Button Accordion Player From Slovenia. Born: 23 July 1932 In Jordankal,Near Mirna Pec Died: 29 September 2011 In Ljubliana. Lojzeta Was Burried In Sentvid,He Was 79 Jears Old. | ["Accordion"] | ["accordion music", "tuba", "acoustic guitar", "male voices", "waltz song", "moderate tempo"] | 0 | zj2G-KVw4N4 | 5506 |
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;