musiccaps_details (view)
9 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate" and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- low quality 9
- noisy · 9 ✖
- passionate · 9 ✖
- emotional 7
- live performance 4
- classical 2
- mellow piano chords 2
- opera 2
- reverberant 2
- soulful 2
- arpeggiated plucked strings melody 1
- audio cut 1
- brass melody 1
- breathy woodwind melody 1
- cello solo melody 1
- choir 1
- coughing 1
- cover 1
- cultural 1
- easygoing 1
- echoing female vocal 1
- epic 1
- fruity male vocal 1
- groovy bass 1
- groovy piano melody 1
- harmonizing female vocals 1
- harmonizing male vocals 1
- harpsichord melody 1
- mellow percussions 1
- mono 1
- muffled 1
- mystical 1
- passionate female vocal 1
- piano melody 1
- plucked strings melody 1
- powerful 1
- punchy kick 1
- punchy snare 1
- repetitive percussive element 1
- reverberant passionate female vocal 1
- shimmering hi hats 1
- sizzling triangle 1
- strings melody 1
- sustained strings melody 1
- telephone ring 1
- traditional folk 1
- wide brass melody 1
- wide choir 1
- wide strings melody 1
musiccaps_names (array) 17 ✖
- Classical music · 9 ✖
- Music 8
- Opera 4
- Singing 4
- Musical instrument 3
- Cello 2
- /t/dd00004 1
- Bowed string instrument 1
- Carnatic music 1
- Choir 1
- Christian music 1
- Christmas music 1
- Electric piano 1
- Mantra 1
- Orchestra 1
- Traditional music 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 |
---|---|---|---|---|---|---|---|---|---|---|
"Ay mi morena" - Luisa Fernanda (2006) | The low quality recording features a wide choir singing over widely spread strings and brass melody, followed by a sizzling triangle. It sounds epic, powerful and passionate. The recording is a bit noisy. | 2008-02-28T20:50:43Z | Ursey52 | Placido Domingo sings the beautiful love song from Act 3 of Luisa Fernanda. Also known as "Ay mi morena" Performed at the Teatro REal, Madrid | ["Opera", "Classical music"] | ["low quality", "noisy", "wide choir", "sizzling triangle", "wide brass melody", "wide strings melody", "epic", "powerful", "passionate"] | 4 | 19-GI2LzOtc | 241 | |
Veronica Mansour - Tarantella by Squire | The low quality recording features a cello solo melody played over mellow piano chords. It sounds passionate and emotional. The recording is noisy. | 2008-06-26T16:51:50Z | baronqsolotar | a fabulous performance by a 9-year old at the National Cello Institute - CA June 2008 | ["Cello", "Music", "Musical instrument", "Classical music", "Bowed string instrument"] | ["low quality", "cello solo melody", "mellow piano chords", "noisy", "passionate", "emotional"] | 4 | F2ekiX14ID4 | 1610 | |
Marin Marais: Chaconne in A Major (Book 5); Elisabeth Reed, viola da gamba | The low quality recording features a live performance of a classical song and it consists of harpsichord and sustained strings melodies. The recording is a bit noisy and quite reverberant, as it was recorded in a medium size concert hall. It sounds easygoing, passionate and emotional. | 2015-02-24T02:45:02Z | Voices of Music | The Chaconne in A Major from Marin Marais' fifth book (Pièces de Viole, Cinquième Livre, Paris, 1725). Performed on the viola da gamba by Elisabeth Reed, with Cassandra Luckhardt, viola da gamba, and Katherine Heater, harpsichord. In the first half of the 18th century, the French viol players dazzled audiences with their varied and beautifully crafted compositions as well as their technical abilities. Marais' chaconne shows the work of a mature composer; he balances the motivic elements perfectly with the registration of the instruments. HD Video from Voices of Music. | ["Cello", "Music", "Musical instrument", "Wedding music", "Classical music"] | ["low quality", "classical", "live performance", "harpsichord melody", "sustained strings melody", "emotional", "passionate", "reverberant", "noisy", "easygoing"] | 4 | HJuR9WJ1iRY | 1790 | |
Johanna Kurkela - Joululaulu | The low quality recording features mellow piano chords playing. There is a short audio cut and the recording is noisy and in mono. | 2006-09-15T02:41:39Z | biljardi | Johanna Kurkela esittää Mel Tormén Joululaulun. | ["Christmas music", "Electric piano", "Christian music", "Music", "Musical instrument", "Classical music"] | ["low quality", "mellow piano chords", "noisy", "mono", "passionate", "emotional", "audio cut"] | 4 | NBnz0xV9nb4 | 2324 | |
Cantor Helfgot @ Lincoln Center | The low quality recording features a live performance of a classical song that consists of a fruity male opera singer over a piano melody. In the background there are coughing and telephone ring sounds. The recording is noisy, muffled and it sounds emotional and passionate. | 2008-01-02T17:40:24Z | yessory | Helfgot sings Vlirusholayim Ircha, Avery Fisher Hall, Dec. 02, 2007. At the concert while this selection was sung, rare footage of how Moshe koussevitsky masterfully sang this selection were shown. The recorded audio appears with a slideshow of pictures, from previous Helfgot Performances. | ["Singing", "Mantra", "Music", "Opera", "Orchestra", "Classical music"] | ["low quality", "live performance", "reverberant", "noisy", "muffled", "coughing", "classical", "opera", "fruity male vocal", "piano melody", "emotional", "passionate", "telephone ring"] | 4 | PFa1XVCgPgM | 2522 | |
Classical Music; concluding part | The low quality recording features a live performance of a traditional song and it consists of an echoing female vocal singing over breathy woodwind melody and arpeggiated plucked string melody. It sounds passionate, soulful and mystical, even though the recording is noisy. | 2011-07-22T14:55:51Z | KhyberWatch | Peshawar, Singer Humaira Naaz, Asfandyar Moomand and Gulzar Alam are performing at Baacha Khan Markaz where selected audience was gathered to listen to the classical show of AMN web tv. Also see; ,Bacha Khan, Baacha Khan, Wali Khan, Asfandyar Wali Khan, Mahmoud Khan Achakzai, Mahmood Khan, Khushal Khan Khattak, Ghani Khan, Pakhtunkhwa, Pashtoonkhwa, Pukhtoonkhwa, ANP, PkMPA, PkSF, Peshawar, Mardan, Rustam, Sawabi, Swabi, Kohat, Swat, Malakand, Buner, Karak, Waziristan, Chitral, Pakistan, Kabul, Kandahar, Qandahaar, Pakhtun Girl, Pakhtun women, KhyberWatch, Shamshad tv, AVT Khyber, Award Show, New Show, Khyber, Musafar, Pashto Music, Pashto Ghazal, Pashto Music, Pashto Song, 2009, 2010, 2011, 2012, Pushto, Pakhtu, Khan, Irfan Khan, Khalid Malik, Shoukat Mahmoud, Ashraf Gulzar, Hashamat Sahar, Maas Khan, Ghazala Javed, Ghazala Jawed, Janas Khan, Sarfaraz, Zeek Afridi, Mudassir Zaman, Bakhtiar Khattak, Hamayoun Khan, Hamayoon Khan, Pashto Singers, Nazia Iqbal, Saima Naaz, Saima Naz, Salma Naz, Rabia Tabassum, Noor Jehan, Asma Lata, Aasma lata, Raheem Shah, Arooj Mohmand, Moomand, Farzana, Farzana Naz, Naghma, Musarrat Mohmand, Muskaan, Muskan, Faza Fayaz, Fayaz Kheshki, Shabnam | ["Traditional music", "Music", "Classical music"] | ["low quality", "echoing female vocal", "breathy woodwind melody", "arpeggiated plucked strings melody", "mystical", "soulful", "passionate", "noisy"] | 4 | QrJVAHIkpCo | 2643 | |
Take Me to the Water (Rollo Dilworth) - NH All State 2010 | The low quality recording features a choir singing over punchy kick and snare hits, shimmering hi hats, groovy piano and groovy bass. In the first half, there are harmonizing female vocals singing, after which the male harmonizing vocals start singing. It sounds soulful, passionate and emotional. The recording is a bit noisy. | 2010-04-27T21:15:01Z | musiclvr731 | (Take Me to the Water) The 2010 NH All State Mixed Choir under the direction of Dr. Janet Galvan performs Take Me to the Water by Rollo Dilworth. | ["Singing", "Music", "Opera", "Classical music", "Choir"] | ["low quality", "noisy", "choir", "harmonizing female vocals", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy piano melody", "groovy bass", "live performance", "soulful", "passionate", "emotional"] | 4 | TokHdpvX7Es | 2866 | |
Raag Bhopali | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | 2011-01-20T17:29:46Z | aradhanakarhade | Raag Bhupali tutorial for beginners - Raag Bhopali has five notes, and is thus a raag of the "audhav jaati". Follow the instructions and practice this raag. Here, it is sung in the scale of B major. The corresponding notes in B scale are B, C#, D#, F#, G# PLEASE SUBSCRIBE TO OUR NEW CHANNEL: https://www.youtube.com/channel/UCezyky1nT-IVvKAEZagViUA | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | 4 | VV-DgnPPhSo | 3006 | |
Teen Opera Singer Aria Tesolin at 13 | The low quality recording features a live performance of an opera that consists of a passionate female vocal singing over strings melody, brass melody and mellow percussion. It sounds emotional and passionate. | 2007-05-17T22:15:55Z | Aria Tesolin | Teen opera singer, Aria Tesolin sings Mozart aria Voi Che Sapete. The teen talent's videos are Amazing 8 Year Old Child Opera Singing Sensation, Youngest Opera Singer in the World, & Teen Opera Singer Sings Puccini | ["Singing", "Music", "Opera", "Classical music"] | ["low quality", "noisy", "live performance", "opera", "passionate female vocal", "strings melody", "brass melody", "mellow percussions", "passionate", "emotional"] | 4 | hlHb9HwNxk8 | 4136 |
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;