musiccaps_details (view)
3 rows where musiccaps_aspects contains "trippy" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- trippy · 3 ✖
- acoustic drums 2
- bass guitar 2
- chill 2
- electric guitar 2
- groovy 2
- keyboard 2
- male vocal 2
- atmospheric synthesiser 1
- club music 1
- contemporary pop 1
- dance groove 1
- dance music 1
- digital drumming 1
- disco pop 1
- dj 1
- dj mixer 1
- edm 1
- elctronic beats 1
- electro pop 1
- electronic music 1
- enigmatic 1
- enthusiastic 1
- fast tempo 1
- female vocalisation 1
- hypnotic 1
- instrumental 1
- jamaican 1
- laid-back singing 1
- proto-reggae 1
- psychedelic 1
- reggae 1
- relaxed singing 1
- rocksteady 1
- slow tempo 1
- synth pop 1
- trance 1
- trance music 1
- tropical 1
- upbeat 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Big Mountain - Baby I Love Your Way (1994) | This is a reggae music piece. There is a male vocalist singing in a laid-back manner. The keyboard is playing the main tune. The electric guitar is being strummed in a staccato off-beat pattern. There is a groovy bass line being played by the bass guitar. The rhythmic background consists of a reggae acoustic drum beat. The atmosphere is chill and trippy. This piece could be used in the soundtrack of a romance movie with a tropical setting. | 2012-02-07T22:10:21Z | BillyStollNewsletter | While recording our second album "Unity", we were approached by Ron Fair of RCA Records, resulting in this remake of Peter Frampton's "Baby I Love Your Way" for the "Reality Bites" movie soundtrack album. | ["Singing", "Music", "Soul music"] | ["reggae", "male vocal", "laid-back singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "chill", "trippy", "groovy"] | 9 | DvN5813H7Bo | 1519 | |
Bob Marley - Stir It Up subtitulado | This is a rocksteady/proto-reggae music piece. There is a male vocalist singing in a relaxed manner. The electric guitar and the bass guitar is playing a groovy melody while occasional synth sounds from the keyboard can be heard. The rhythmic background consists of a slow tempo reggae acoustic drum beat. The atmosphere is chill. This piece could be used in the soundtrack of a summertime movie taking place on a tropical island. | 2012-03-02T22:47:34Z | Sebas cuba | Bob Marley - Stir It Up subtitulado | ["Music", "Soul music"] | ["rocksteady", "proto-reggae", "male vocal", "relaxed singing", "jamaican", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "chill", "trippy", "groovy", "tropical", "slow tempo"] | 9 | pSt8NwXyDlg | 4711 | |
Elisa - Love Vibration | This music is an electronic instrumental. The tempo is fast with atmospheric synthesiser, digital drum arrangements and an insistent, recurring female vocalisation. The music is upbeat, youthful, trance, trippy, hypnotic, psychedelic, incessant, and enthusiastic EDM/Synth Pop. | 2009-01-22T22:47:43Z | outy1978 | HQ version: http://uk.youtube.com/watch?v=u9n4R78UBtA&fmt=18 Label: FFRR Catalog#: FXDJ 200 Country: UK Released: 1992 | ["Disco", "Music", "Soul music"] | ["instrumental", "fast tempo", "female vocalisation", "electronic music", "digital drumming", "atmospheric synthesiser", "edm", "club music", "dance music", "dj", "dj mixer", "elctronic beats", "youthful", "enthusiastic", "trippy", "trance", "hypnotic", "enigmatic", "trance music", "psychedelic", "disco pop", "contemporary pop", "electro pop", "synth pop", "upbeat", "dance groove"] | 7 | u9n4R78UBtA | 5092 |
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;