musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "melodic singing", musiccaps_aspects contains "r&b" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- melodic singing · 4 ✖
- r&b · 4 ✖
- bass guitar 3
- female vocal 3
- groovy 3
- sentimental 3
- acoustic drums 2
- electric guitar 2
- electronic drums 2
- female choir 2
- keyboard 2
- live performance 2
- male vocal 2
- slow tempo 2
- soul 2
- emotional 1
- female back vocal 1
- grandiose 1
- hip-hop 1
- melancholic 1
- neo-soul 1
- piano 1
- strong bass 1
- urban 1
musiccaps_names (array) 7 ✖
- Singing · 4 ✖
- Music 2
- Christian music 1
- Crowd 1
- Music of Asia 1
- Rhythm and blues 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 |
---|---|---|---|---|---|---|---|---|---|---|
Brandy Sings: "Long Distance" | This is a live performance of an R&B music piece. There is a female vocalist singing melodically in the lead. Three female supporting vocals can be heard singing in the back. The melody is being played by the piano while the bass guitar plays a groovy bass line. The rhythm is provided by an acoustic drum beat. The atmosphere is sentimental. This piece can be used in the soundtrack of a romance movie involving a couple in a long distance relationship. | 2008-12-10T19:16:12Z | CBS | Brandy performs the single "Long Distance" from her much anticipated album, "Human." | ["Singing", "Christian music", "Music"] | ["r&b", "live performance", "female vocal", "melodic singing", "female choir", "piano", "bass guitar", "acoustic drums", "sentimental", "groovy", "urban"] | 9 | 3u9OO9Og0Gc | 517 | |
Whitney Houston- You'll never stand alone | This is an R&B/soul music piece. There is a female vocalist singing melodically while another female vocalist is singing the backing melody. The keyboard is playing the main tune. There is a bass guitar playing in the background. The rhythm is provided by a ballad-type slow tempo acoustic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a drama movie, especially during the scenes of a reunion or a homecoming after a long period of separation. | 2008-06-02T10:06:16Z | MichaelowkaMJJ | Whitney Houston- You'll never stand alone with Bobbi Krisstina. Her daughter. My video. And I forget soft in 2:16. Sorry. | ["Singing", "Soul music"] | ["r&b", "soul", "female vocal", "melodic singing", "female back vocal", "keyboard", "bass guitar", "acoustic drums", "slow tempo", "sentimental"] | 9 | Bd9TjPP31U0 | 1267 | |
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 | |
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 |
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;