musiccaps_details (view)
4 rows where musiccaps_aspects contains "piano", musiccaps_author = 9 and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- piano · 4 ✖
- bass guitar 3
- female vocal 3
- live performance 3
- sentimental 3
- dramatic 2
- melodic singing 2
- acoustic drums 1
- clicks 1
- dreamy 1
- drums 1
- female choir 1
- flute 1
- groovy 1
- joyful 1
- male vocals 1
- medium-to-high pitch 1
- medium-to-high pitch singing 1
- orchestra 1
- playful 1
- pop music 1
- pop rock 1
- r&b 1
- rock opera 1
- slow tempo 1
- strings 1
- upbeat 1
- urban 1
- vocal performance 1
musiccaps_names (array) 8 ✖
- Music 4
- Singing · 4 ✖
- /t/dd00004 1
- Christian music 1
- Music of Asia 1
- Sad music 1
- Ska 1
- Speech 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 | |
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 | |
Chas and Dave - Gertcha (1979) | This is a live performance of a pop rock music piece. Two male vocals are singing melodically at the same time. There is a piano playing an upbeat melody while the bass guitar plays a simple bass line in the background. The piece has a joyful aura to it. This piece could be used in the soundtrack of a sit-com during the scenes of a character happily walking through the city. | 2013-07-27T13:24:08Z | Chas and Dave Videos | Chas and Dave on 'Top Of The Pops', in 1979... they performed this song 3 times on TOTP, 31st May, 14th June & 28th June. This is probably either the 2nd or 3rd appearance. | ["Singing", "Music", "Ska", "Speech"] | ["pop rock", "live performance", "male vocals", "melodic singing", "piano", "bass guitar", "playful", "joyful", "upbeat"] | 9 | q87TmUmVg0Y | 4756 |
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;