musiccaps_details (view)
7 rows where musiccaps_aspects contains "emotional" and musiccaps_author = 6
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Robert Pattinson singing live " I was broken" | The male mid to high range voice sings loudly and full of emotions pouring out of his soul while strumming some minor chords on the guitar. This recording is of poor quality. This song may be played in an open mic, poetry bar. | 2009-06-22T02:39:38Z | pinkstarvero08 | Robert Pattinson singing live " I was broken"this song it by far my fav song from rob..LOVE IT..and PLZ sub,rate and comment!! | ["Music", "/t/dd00003"] | ["country/pop/singersongwriter", "acoustic guitar", "male singer", "emotional", "soulful"] | 6 | 0cNYPgD6cEA | 192 | |
| Alexander Rybak - Bergrosa | This audio contains someone playing a violin with a sad melody and strong bow strokes. The piece sounds as if someone is frustrated and emotional. This song may be playing at a concert. | 2009-05-26T21:58:16Z | eddott | Alexander Rybak performing Bergrosa (the mountain rose) at Bild.de. | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["amateur recording", "violin", "fast tempo", "emotional", "sad", "frustrated"] | 6 | CZZSQ6rd8h0 | 1378 | |
| BOLEROS CON GUITARRA FLAMENCA | Someone is playing an acoustic guitar flamenco style finger-picking while a female voice sings loud and emotionally. This song may be playing live in a restaurant. This is an amateur recording. | 2012-10-31T16:51:52Z | Olga Chito | NANI CANTANDO, Y JONI A LA GUITARRA | ["Guitar", "Music", "Musical instrument", "Opera", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "female voice singing", "sensual", "emotional"] | 6 | OjoDuBkPDM8 | 2463 | |
| Allemande from Bach's Cello Suite No. 1 (Official Music Video) - Tina Guo | This audio contains someone playing a piece on cello ranging from the low register up into the higher register. This song may be playing during a live performance. | 2015-02-12T18:30:59Z | Tina Guo | ► https://linktr.ee/tinaguo MERCH ➜ https://TinaGuoStore.com My Favorite Things ➜ https://amazon.com/shop/tinaguo P A T R E O N ➜ http://patreon.com/tinaguo F A C E B O O K ➜ https://facebook.com/tinaguo I N S T A G R A M ➜ https://instagram.com/tinaguo T W I T T E R ➜ https://twitter.com/tinaguo W E B S I T E ➜ http://tinaguo.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Business Inquiries: Office@TinaGuo.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - My Spotify playlist: http://spoti.fi/2jfV7V2 #Bach #Allemande #TinaGuo #Cello Director of Photography: Joel Moody Producer/Editor: Tina Guo | ["Cello", "Double bass", "Bowed string instrument"] | ["classical", "cello", "emotional"] | 6 | _3GnNMrDuCs | 3439 | |
| Hästpojken Gitarrer & Bas, Trummor & Hat | The male voice singing sounds emotional and sad while a piano is playing a minor chord progression along with an acoustic guitar strumming chords. Then a fat sounding acoustic drum comes in with a simple groove along with an e-bass. This song may be playing on headphones while sitting in the bus riding downtown being lost in thoughts. | 2009-11-26T17:51:55Z | TussilagoSwe | Hästpojken Gitarrer & Bas, Trummor & Hat. Musikvideo: Tussilago, Theo Gabay Skivbolag: Roxy Recordings | ["Music", "Independent music", "Song"] | ["pop/rock/ singer-songwriter", "piano", "acoustic guitar", "acoustic drums", "male voice singing", "higher register", "emotional", "melancholic", "medium tempo"] | 6 | qRCjs90-1RQ | 4784 | |
| Vulcan Harp & Theremin | Someone is playing a Theremin on a very high pitch going up in pitch and with a lot of vibrato. This song may be playing at home while enjoying your instrument. | 2011-01-19T00:59:37Z | Peter Pringle | This is called THE KATRIC ARK and it is one of a series of 12 compositions for Vulcan harp and theremin. Since the Vulcan harp was introduced by artist and visionary Wah Ming Chang more than 40 years ago, it has evolved considerably, along with the technology involved with its manufacture. It is acoustic, electroacoustic and electronic (it is the electronic component that permits such things as the playing of complex harmonies, glide pitch shifts, etc.). As a sculptor, Chang molded the instrument to fit the human body, and it is great to hold because it is so wonderfully ergonomic. This particular harp has 26 strings (copper, brass and silver) and is played with finger picks. There are no steel strings and the instrument does not use magnetic pickups like electric guitars. It also does not need to be plugged into anything so there are no annoying cables to get in the way. It transmits directly to its amplifier and speakers by means of an antenna integrated into the pin column (the extended curved vertical arm that holds the tuning pins). The two speakers you see in the video are JBL JRX-125 monitors. As a concept, the characteristics of "Vulcan music" are determined by the remarkable capabilities of the Vulcan harp which include many of the possibilities of the classical instruments of India. The sound of the Vulcan harp has been described as a combination of harp, lute, violin and sitar. If you add to this everything that is possible with the use of the shift disc and the harmonic valves (the seven button controls - one for each note of the diatonic scale - riding above the brass plate) you have an extraordinary number of combinations that can be explored. The harmonic valves are all level-sensitive (each responds to three degrees of left hand finger pressure applied to them: touch, half, and full) and this determines the harmony applied to the vibrating strings. Octave displacement is played by multiple valve configurations depending on the register in which the harpist wants to play. There is also a … | ["Music", "Musical instrument", "Theremin"] | ["vulcan harp/theremin", "slow tempo", "emotional"] | 6 | xRfbWrI03gc | 5329 | |
| Marco Guazzone - Alarm Clock (Live on the street) | someone is playing a digital piano composition while a male voice is singing loudly a melody with long notes. In the background birds chirping and other noises can be heard. This is an amateur recording. This song may be playing in a live performance. | 2009-09-24T16:37:23Z | Marco Guazzone | -------Alarm Clock------- Wake up, its morning Alarm clock is ringing Lets get out off bed Breakfast is ready I made fresh orange juice Youre still half asleep I keep on calling you And your eyes Your eyes Opening one at a time Then they look at me Asking for just five minutes more The alarm clock is ringing for us too ---Music & Lyrics by Marco Guazzone--- SEGUI MARCO GUAZZONE: ►https://www.marcoguazzone.com ►https://www.instagram.com/guazzonemarco ►https://www.facebook.com/marcoguazzone ►https://www.tiktok.com/@guazzonemarco | ["New-age music", "Music"] | ["singer-songwriter", "digital piano", "male voice singing", "environmental noises", "medium tempo", "soothing", "emotional", "amateur recording"] | 6 | zUaZGKZIKic | 5483 |
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;