musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "slow tempo" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- electronic drums · 3 ✖
- slow tempo · 3 ✖
- bass guitar 2
- electric guitar 2
- keyboard 2
- male vocal 2
- melodic singing 2
- r&b 2
- sentimental 2
- autotune singing 1
- dreamy 1
- emotional 1
- female vocals 1
- groovy 1
- male vocals 1
- melancholic 1
- neo-soul 1
- remix 1
- romanian pop music 1
- soul 1
- strong bass 1
- synth sound 1
musiccaps_names (array) 4 ✖
- Christian music 2
- Music 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Be Strong ..xX | This is an R&B/soul music piece. There is a whole mix of male and female vocals singing melodically. The tune is being performed by the keyboard while the electric guitar and the bass guitar are playing in the background. There is a slow tempo electronic drum beat in the rhythmic background. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie, especially during the scenes of resolution. | 2006-10-28T13:51:06Z | xxnicholsonxx | a video made by me for heartbroken girls | ["Christian music", "Music"] | ["r&b", "soul", "remix", "male vocals", "female vocals", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "emotional", "dreamy", "slow tempo"] | 9 | MFxMPOAbUPA | 2250 | |
Jaar Project-dOar tu | This is a Romanian pop music piece. There is a male vocalist singing with autotune. The melody is being played by a synth sound. There is a bass guitar playing a simple bass line while the rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a Romanian soap opera, especially during romantic scenes. | 2009-08-25T17:51:29Z | DyeNuZzA1 | va place?... | ["Christian music", "Music"] | ["romanian pop music", "male vocal", "autotune singing", "synth sound", "bass guitar", "electronic drums", "slow tempo", "sentimental"] | 9 | b2-izZk5_BM | 3598 | |
OFFICIAL VIDEO: "Dealing" featuring Lalah Hathaway | This is an R&B/neo-soul music piece. There is a male vocalist in the lead singing melodically. The main tune is being played by the electric guitar and the keyboard. There is a strong and groovy bass sound. The rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a romantic comedy movie that takes place in the big city, especially during the scenes where a character is going through the feeling of heartbreak. | 2009-12-19T06:08:47Z | Eric Roberson | "Dealing" feat. Lalah Hathaway Directed by Impakt Studio (Chris & Blaq) www.ericrobersonmusic.com www.impaktstudio.com www.lalahhathaway.com | ["Singing", "Rhythm and blues"] | ["r&b", "neo-soul", "male vocal", "melodic singing", "keyboard", "electric guitar", "strong bass", "electronic drums", "slow tempo", "groovy", "sentimental", "melancholic"] | 9 | lAMiOhScSPg | 4378 |
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;