musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass" and musiccaps_aspects contains "electric guitar" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- bass · 3 ✖
- electric guitar · 3 ✖
- groovy 2
- acoustic drums 1
- acoustic guitar 1
- auto-tuned singing 1
- dance music 1
- electronic drums 1
- energetic 1
- female voice 1
- flamboyant singing 1
- hip 1
- hip-hop 1
- keyboard 1
- male vocal 1
- male vocals 1
- no other instruments 1
- no percussion 1
- percussion 1
- playful 1
- pop ballad 1
- pop song 1
- r&b 1
- remix 1
- romantic mood 1
- shuffle 1
- slow tempo 1
- soul 1
- urban 1
musiccaps_names (array) 8 ✖
- Music 2
- Bluegrass 1
- Country 1
- Hip hop music 1
- Music of Africa 1
- Rapping 1
- Rhythm and blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LIONEL RICHIE FT. BUSY SIGNAL - ALL NIGHT LONG - DJ GENESIS REMIX (MARS 2014) | This is a remix of an R&B soul piece. There is a male vocal singing in a laid-back manner joined by an auto-tuned male vocal. The keyboard provides the melody with a gentle bass guitar playing in the background. The rhythmic structure is composed of the acoustic drums and the percussion playing a medium tempo beat. The atmosphere of the piece is groovy and there is a feelgood aura to it. This piece could be used in the soundtrack of a sitcom. | 2014-03-26T13:04:56Z | Drahpaa | https://soundcloud.com/dj-genesis https://twitter.com/DJGENESIS1 CREATIVE DJ/PRODUCER/AUDIO ENGINEER/REMIX MASTER/GRAPHIC ARTIST, www.flamesradio.co.uk or 94.4FM, SEND TRACKS TO dj_genesis191@yahoo.com FOR BOOKINGS : dj_genesis191@yahoo.com | ["Music of Africa", "Music", "Rhythm and blues"] | ["r&b", "soul", "remix", "male vocals", "auto-tuned singing", "keyboard", "bass", "acoustic drums", "percussion", "electric guitar", "groovy"] | 9 | 1heMbyumHAo | 299 | |
Hip Hop Academy Sid Shuffle | This is a hip-hop dance music piece. There is a male vocalist who is singing in a flamboyant manner. There is an electric guitar playing the melody joined by a strong bass sound. There is a groovy, urban atmosphere. This piece can be used as an accompaniment piece in modern dancing courses. | 2013-09-15T18:15:10Z | HipHopAcademy08 | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "dance music", "shuffle", "male vocal", "flamboyant singing", "electric guitar", "bass", "electronic drums", "playful", "groovy", "hip", "urban", "energetic"] | 9 | V9EFYFKlYbE | 2976 | ||
Faith Hill & Carlos Santana - Breathe (High Quality) | This pop ballad features a female voice singing the main melody. This is accompanied by an acoustic guitar playing chords. An electric guitar plays a descending lick after one line. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-05-23T21:06:44Z | butt3rfli3z88 | I can feel the magic floating in the air Being with you gets me that way I watch the sunlight dance across your face and I've Never been this swept away All my thoughts just seem to settle on the breeze When I'm lying wrapped up in your arms The whole world just fades away The only thing I hear Is the beating of your heart 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe In a way I know my heart is waking up As all the walls come tumbling down I'm closer than I've ever felt before And I know And you know There's no need for words right now 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe I can feel the magic floating in the air Being with you gets me that way | ["Singing", "Country", "Bluegrass"] | ["pop ballad", "female voice", "acoustic guitar", "bass", "electric guitar", "no percussion", "no other instruments", "pop song", "slow tempo", "romantic mood"] | 0 | VJ1RqPqF9O4 | 2990 |
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;