musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "r&b", musiccaps_names contains "Music" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- r&b · 3 ✖
- bass guitar 2
- female choir 2
- female vocal 2
- groovy 2
- live performance 2
- melodic singing 2
- acoustic drums 1
- acoustic guitar 1
- digital drums 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female voice singing 1
- grandiose 1
- hip-hop 1
- male vocal 1
- piano 1
- sentimental 1
- soul 1
- sub bass 1
- synth pad 1
- uptempo 1
- urban 1
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Singing · 3 ✖
- Christian music 1
- Crowd 1
- Exciting music 1
- Music of Asia 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 | |
Diam's - DJ (Clip officiel) | This song contains digital drums with a soft sub bass playing along every kick hit. An acoustic guitar/sitar is playing a melody with a synth sound playing a high counter melody panned to the left side of the speakers. A synth pad is playing a long note melody in a higher register. A female voice is singing the main melody. Her voice is doubled and backing voices are adding harmonies. This song may be playing in a hip-hop club. | 2009-02-26T21:52:50Z | Diam's officiel | Music video by Diam's performing Dj. | ["Singing", "Music", "Exciting music"] | ["r&b", "acoustic guitar", "synth pad", "digital drums", "sub bass", "female voice singing", "uptempo"] | 6 | oRVivXC83hA | 4629 | |
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;