musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass" and musiccaps_author = 0
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| BITTER ROCC - MMXIII Deluxe - Run these rats out (promo music video) | This song features a male voice rapping the lyrics. Female voices sing vocables in the background. This is accompanied by programmed percussion playing a trap beat. The bass plays a groovy bassline by sliding to notes rather than pausing in between notes. A synth plays a repetitive melody in the background. This song can be played in a gangster movie. | 2014-04-27T13:45:48Z | ROCAnimation | MMXIII Deluxe edition available on iTunes only 30.05.14. 'Run these rats out' only available on MMXIII Deluxe. Directed by ROC. assisted by Darrell Long, Evan Flynn. TheRocCollective.com BR MUSIC (C) 2014. | ["Music", "Hip hop music"] | ["rap song", "trap beat", "male voice", "female backing voice", "synth sounds", "repetitive synth melody", "moderate tempo", "groovy bass"] | 0 | 3KdyWJ6wTOw | 457 | |
| LADRON-MASKATESTA | This ska song features a trumpet playing the main melody. The trumpet plays one staccato note followed by a six note pattern and then plays the same sequence starting on a different root note. This is accompanied by percussion playing a simple beat. A keyboard plays chords in the background. The bass plays a groovy bassline. There are no voices in this song. This is an instrumental song. The mood of this song is happy. This song can be played in a comedy movie. | 2009-03-06T22:39:59Z | Hector Israel Reyes Leal | VERSION ORIGINAL | ["Music", "Ska"] | ["ska song", "keyboard", "trumpets", "bass", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat", "happy mood", "groovy bass", "simple beat", "simple song"] | 0 | AH6Xnyj6Ykc | 1097 | |
| Bob Marley - Get Up Stand Up + Lyrics | This reggae song features a male voice singing the main melody. Other male voices sing backing voices repeating the same melody in between lines. This is accompanied by percussion playing a simple melody using reggae rhythm. The bass plays a groovy bassline using runs within the scale. A guitar plays chords by muting technique producing a reggae rhythm. A keyboard plays chords in the background. This song can be played in a documentary about alleviating poverty. | 2011-02-25T13:27:55Z | Γιάννης P. | The God sign's Get Up Stand Up just enjoy the music. Peace,Love & Hope Brothers & Sisters for a better world. I don't have copyrights or anything like this. | ["Music", "Reggae"] | ["reggae song", "male voice", "male backing voice", "groovy bass", "reggae guitar", "percussion", "keyboard", "moderate tempo"] | 0 | BiPwCMlghhQ | 1278 | |
| Chuck Mangione Feels So Good. | This jazz song features the main melody played on a flugelhorn and a saxophone. Both instruments play in harmony with variations in melody. These instruments compliment each other. This is accompanied by percussion playing a jazz beat with constant strokes on the ride cymbal. The bass guitar plays a groovy bassline starting with a descending lick. This is then followed with an ascending lick to reach the higher notes before descending back. The guitar plays chords with string muting in a jazz rhythm. The mood of this song is upbeat. This song can be played in an advertisement for a luxury car. | 2010-09-28T22:54:21Z | krushade100123 | I DO NOT CONSENT OF OWNING THIS MATERIAL THIS ONLY FOR ENTERTAINMENT PURPOSES Chuck mangione performs Feel so Good | ["Jazz", "Music", "Musical instrument"] | ["jazz", "flugelhorn", "saxophone", "percussion", "groovy bass", "jazz guitar", "moderate tempo", "happy mood", "no voices", "instrumental"] | 0 | V1A4wBgvPgI | 2968 | |
| Donny Hathaway - We Need You Right Now Lord | This gospel song features a male voice singing the main melody in an emotional voice. This is accompanied by the percussion playing continuously in sixteenth notes on the ride cymbal. The bass plays a groovy lick and fill based on the root note of the chord. The piano plays a chord followed by a fill and an ascending run. This song can be played in a Christian movie. | 2010-12-31T15:46:16Z | Reggie Miles | Classic Spiritual/Inspirational/Soul song from a gifted and talented writer, singer, and producer the late Donny Hathaway I do not own the rights to this song. | ["Music", "Soul music"] | ["gospel song", "male voice", "groovy bass", "piano", "percussion", "ride cymbal", "slow tempo", "emotional voice"] | 0 | YcfGSJB1YvQ | 3299 |
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;