musiccaps_details (view)
5 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "poor quality" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- instrumental · 5 ✖
- poor quality · 5 ✖
- no singer 4
- complex 2
- piano 2
- acoustic drums 1
- acoustic guitar 1
- amateur recording 1
- bass guitar 1
- bebop jazz 1
- classical 1
- cover 1
- didgeridoo 1
- distorted electric guitar 1
- emotional 1
- energetic 1
- gentle 1
- guitar solo 1
- improvisation 1
- jam 1
- live performance 1
- low-to-medium range 1
- mellow 1
- movie music 1
- ominous 1
- optimistic 1
- organ 1
- progressive metal 1
- rapid 1
- romantic 1
- saxophone 1
- saxophone solo 1
- shredding 1
- single instrument 1
- solo 1
- speed metal 1
- strings 1
- tribal 1
- unfamiliar 1
- violent 1
musiccaps_names (array) 13 ✖
- Music 4
- Didgeridoo 1
- Echo 1
- Electric piano 1
- Hammond organ 1
- Heavy metal 1
- Keyboard (musical) 1
- New-age music 1
- Organ 1
- Piano 1
- Rock music 1
- Saxophone 1
- Wedding music 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Beauty and the Beast - Saxophone Wedding Song | This is a live performance of a movie music piece. The recording has a very poor quality. The saxophone is playing the main tune while the piano can be heard providing a melodic background. The atmosphere is romantic and it is probably a wedding setting. | 2008-04-27T14:01:36Z | saxophonedaniel | Beauty and the Beast - Saxophone Wedding Song | ["Music", "Wedding music", "Saxophone"] | ["movie music", "classical", "live performance", "no singer", "instrumental", "saxophone", "saxophone solo", "piano", "romantic", "emotional", "poor quality"] | 9 | as7MhTe961k | 3581 | |
Shout to the Lord - American Sign Language | This is a poor quality instrumental piece played in the background of a sign language video. There is an optimistic sounding tune being played by the strings, the piano and the acoustic guitar. The atmosphere is mellow and gentle. Samples from this piece could be lifted to be used in beat-making. | 2010-11-08T21:09:46Z | Ag00dgranma | Class, here is our new song for class. Sorry it took me so long to get it up. Hope you enjoy and happy signing. | ["Echo", "New-age music", "Music"] | ["poor quality", "no singer", "instrumental", "piano", "strings", "acoustic guitar", "gentle", "mellow", "optimistic"] | 9 | -RYtUAsNhF0 | 46 | |
DIDJERIDU (DIDJERIDOO) | This is the amateur recording of an instrument showcase jam. There is a didgeridoo playing at low-to-medium range making various resonant sounds in the process. The atmosphere is ominous and tribal. The quality of the audio is quite poor. This piece could be played at a primary school music class to give the kids an impression of how a didgeridoo sounds like. | 2007-12-30T16:57:55Z | kaypacha | Didgeridus para la venta en julio 2007. http://www.kaypacha.com.ar Didgeridoos for the sale in July 2007. | ["Didgeridoo", "Music"] | ["jam", "no singer", "instrumental", "amateur recording", "poor quality", "single instrument", "didgeridoo", "low-to-medium range", "unfamiliar", "ominous", "tribal"] | 9 | 8KIoQ2HZ0Hg | 911 | |
Through The Fire And Flames - AGAIN! | This is the guitar cover of a speed metal/progressive metal piece. The distorted electric guitar is playing a solo. There is a rapid and complex procession of notes in the solo which is played by the shredding technique. There is a loud and violent atmosphere to the recording. The quality is quite poor since the recording is a bit dated. | 2007-06-11T07:06:05Z | longestsoloever | I try the DragonForce song again, this time with my clone! That handsome guy on the left is off by a split second, but thats one of the hazards of compositing! | ["Heavy metal", "Music", "Rock music"] | ["cover", "speed metal", "progressive metal", "instrumental", "distorted electric guitar", "guitar solo", "shredding", "complex", "rapid", "violent", "poor quality"] | 9 | DYp8940tHso | 1492 | |
Cory henry | This is the poor quality recording of a bebop jazz music performance. The organ is playing an insanely complex improvised solo. In the background, there is a bass guitar and a jazz acoustic drum beat. The atmosphere is energetic. | 2007-10-17T20:56:15Z | joeydkeys | Cory killin donna lee | ["Organ", "Electric piano", "Hammond organ", "Keyboard (musical)", "Piano"] | ["poor quality", "no singer", "instrumental", "bebop jazz", "organ", "solo", "improvisation", "bass guitar", "acoustic drums", "energetic", "complex"] | 9 | GWxiiDBK5s8 | 1731 |
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;