musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "sentimental" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- bass guitar · 4 ✖
- female vocal 4
- sentimental · 4 ✖
- melodic singing 3
- acoustic drums 2
- keyboard 2
- piano 2
- pop music 2
- r&b 2
- slow tempo 2
- amp 1
- clicks 1
- dramatic 1
- drums 1
- electric guitar 1
- electronic drums 1
- female back vocal 1
- female choir 1
- groovy 1
- live performance 1
- male vocal 1
- medium tempo 1
- medium-to-high pitch 1
- reverb 1
- simple tune 1
- soul 1
- urban 1
- vibrant 1
- vocal performance 1
musiccaps_names (array) 9 ✖
- Singing · 4 ✖
- Music 3
- /t/dd00004 1
- Christian music 1
- Music of Asia 1
- Pop music 1
- Radio 1
- Reverberation 1
- Soul music 1
youtube_published (date) 4 ✖
- 2007-08-29 1
- 2008-06-02 1
- 2008-12-10 1
- 2010-05-30 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 | |
Me singing the voice within | This is a vocal performance recording of a pop music piece. It is an amateur recording. The female vocalist is singing in a rising-and-falling manner in medium-to-high pitch. The backing track consists of a simple piano tune, a groovy bass line provided by a bass guitar and a 4/4 signature slow tempo drum beat with clicks on every fourth beat. The atmosphere is sentimental and heart-touching. | 2007-08-29T23:39:26Z | jessalovexox | Me singing the Voice within by christina aguilera.. my first youtube video so please be nice, lol. | ["Singing", "Music", "/t/dd00004"] | ["vocal performance", "pop music", "female vocal", "medium-to-high pitch", "piano", "bass guitar", "drums", "clicks", "slow tempo", "dramatic", "sentimental"] | 9 | 8DHtPopFvII | 903 | |
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 | |
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 |
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;