musiccaps_details (view)
11 rows where musiccaps_author = 4, musiccaps_names contains "Music" and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 74 ✖
- low quality 10
- passionate 6
- noisy 5
- live performance 4
- classical 3
- emotional 3
- energetic 2
- epic 2
- exotic 2
- fruity male vocal 2
- groovy bass 2
- muffled 2
- reverberant 2
- shimmering hi hats 2
- "4 on the floor" kick pattern 1
- accordion melody 1
- addictive 1
- applause 1
- arpeggiated strings melody 1
- calming 1
- cartoons 1
- cinematic 1
- commercial 1
- coughing 1
- crowd chattering 1
- crowd cheering 1
- distorted 1
- dynamic 1
- electric guitar melody 1
- energetic drums 1
- energetic orchestra drums 1
- folk 1
- fun 1
- groovy 1
- groovy piano melody 1
- happy 1
- hydraulophone melody 1
- loud 1
- loud impact 1
- low cello melody 1
- mono 1
- mystical 1
- opera 1
- orchestra 1
- orchestral 1
- passionate female vocal 1
- passionate male opera vocal 1
- percussive elements 1
- piano melody 1
- powerful 1
- punchy snare 1
- regional mexican 1
- relaxing 1
- repetitive addictive strings melody 1
- shimmering brass melody 1
- shimmering cymbals 1
- soft crashes 1
- steel drums melody 1
- steel pans melody 1
- syncopated snare 1
- telephone ring 1
- traditional 1
- tuba solo melody 1
- upbeat 1
- vintage 1
- water leaking 1
- wide 1
- wide brass melody 1
- wide muffled brass section 1
- wide strings melody 1
- wide violin melody 1
- wooden percussions 1
- woodwinds 1
- woodwinds melody 1
musiccaps_names (array) 23 ✖
- Music · 11 ✖
- Orchestra · 11 ✖
- Musical instrument 7
- Classical music 5
- Music of Latin America 2
- Opera 2
- Percussion 2
- Singing 2
- Speech 2
- Steelpan 2
- Traditional music 2
- Accordion 1
- Bowed string instrument 1
- Brass instrument 1
- Drum 1
- Drum kit 1
- Foghorn 1
- Inside, large room or hall 1
- Mantra 1
- Salsa music 1
- Swing music 1
- Timpani 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Amazing Grace" on the steel pans by the Dover High School Steel Drum Band | The low quality recording features a steel pans melody, shimmering hi hats, syncopated snare and "4 on the floor" kick pattern. It is a bit reverberant as it was played in a concert hall. There are some crowd cheering and applause sounds. It sounds exotic, fun and happy. | 2011-10-15T22:04:45Z | Ann Swinderman | Under the direction of Joan Wenzel, the Dover Steel Drum Band performs this favorite in the Performing Arts Center Kent State University Tuscarawas lobby. | ["Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "steel pans melody", "reverberant", "shimmering hi hats", "syncopated snare", "\"4 on the floor\" kick pattern", "groovy bass", "crowd cheering", "applause", "exotic", "fun", "happy"] | 4 | 6J3X0whM_-4 | 742 | |
orchestra jamal | The low quality recording features a traditional song that consists of a repetitive and addictive string melody, wooden percussion and shimmering cymbals. It sounds really energetic and addictive - almost like a pop song would. The recording is a bit noisy and the left channel of the stereo image is occasionally muffled. | 2012-09-30T12:52:43Z | jamal chaouad | orchestra jamal.wmv | ["Traditional music", "Music", "Orchestra"] | ["low quality", "traditional", "upbeat", "repetitive addictive strings melody", "wooden percussions", "shimmering cymbals", "energetic", "addictive", "muffled", "noisy"] | 4 | CeaWlENtRio | 1389 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Tomomi Nishimoto - Tchaikovsky : Symphony No.6 「Pathétique」3rd Mov | The Classical song features a dynamic arrangement of energetic orchestra drums, woodwinds, arpeggiated strings melody and shimmering brass melody. It sounds cinematic and epic - like a background movie soundtrack. | 2009-09-05T15:16:42Z | CLASSICsungtaek | [ Pyotr Ilyich Tchaikovsky ] - Symphony No.6 in B minor Op. 74「Pathétique」 III. Allegro molto vivace Tchaikovsky Foundation Russian Symphony Orchestra Tomomi Nishimoto, conductor | ["Timpani", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical", "dynamic", "orchestra", "energetic orchestra drums", "woodwinds", "arpeggiated strings melody", "shimmering brass melody", "cinematic", "epic"] | 4 | HQb2jhmw1BE | 1800 | |
Vaughan Williams Tuba Concerto Part 3 | The low quality recording features a live performance that consists of a tuba solo melody and some loud impact in the background. The recording is noisy, loud and distorted. | 2008-06-17T12:09:48Z | sersvet | National Filarmonica, Chisinau,R.V. Williams - Tuba Concerto, Part 3. Solist Serghei Svet | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra"] | ["low quality", "loud", "distorted", "loud impact", "tuba solo melody", "noisy", "live performance"] | 4 | KB4e9v_5uTE | 2062 | |
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 | |
Sexy Sound Served on a Plate | The low quality recording features a classical song that consists of passionate male opera vocal singing over wide strings melody, wide brass melody and woodwinds melody, over which there is a fruity male vocal talking. It sounds passionate, epic and powerful - like something for commercial. | 2013-12-20T09:02:07Z | LG TV | Slim, stylish, considerate of your needs, full-bodied... we're not talking about your ideal woman; we're talking about LG's latest product, SoundPlate (LAP340). We are proud to introduce you to the LG SoundPlate, a slim base-type speaker system that enhances the TV viewing experience with immersive audio. For more product information, please visit our websites! LG.com: http://www.lg.com/uk/speakers-sound-systems/lg-LAP340 Blog: http://whylgtv.lge.com/archives/6183 | ["Music", "Opera", "Orchestra", "Speech", "Classical music"] | ["low quality", "classical", "fruity male vocal", "passionate male opera vocal", "wide strings melody", "wide brass melody", "woodwinds melody", "passionate", "epic", "powerful", "commercial"] | 4 | YK1AEw1kf28 | 3275 | |
Mozart 'Dissonance' Quartet K.465 - 1st Movement | The low quality recording features an orchestral music played by wide violin melody and low cello. It sounds emotional and passionate - like something you would hear in old cartoons. | 2009-01-11T07:47:23Z | Calder Quartet | Calder Quartet live at the Colburn School December 5th 2008 | ["Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["low quality", "wide violin melody", "low cello melody", "emotional", "passionate", "orchestral", "cartoons"] | 4 | mjZylz3nCwQ | 4489 | |
Veneno para dos - Orquesta Bronco | The Regional Mexican song features a passionate female vocal singing over groovy piano melody, wide muffled brass section melody layered with soft crashes and percussive elements. The recording is low quality and vintage, but it still sounds passionate and emotional - like something you would dance to in a latin pub. | 2011-01-28T06:17:01Z | David Monroy | ["Swing music", "Music", "Orchestra", "Music of Latin America", "Salsa music"] | ["regional mexican", "groovy piano melody", "wide muffled brass section", "passionate female vocal", "percussive elements", "soft crashes", "low quality", "vintage", "passionate", "emotional"] | 4 | qET3h3w35EA | 4769 | ||
Hydraulophone in concert | The low quality recording features a hydraulophone melody played alongside water leaking sound. The recording is wide, noisy and it sounds relaxing and calming. | 2007-04-12T01:31:06Z | hydraulist | Suite for Hydraulophone, as performed by Ryan Janzen in the Great Hall, with the Hart House Symphonic Band. This is the world's first orchestral performance in which instruments make sound from all three states of matter (solid, liquid, and gas). Other orchestras use only 2 states of matter: solid (percussion and strings), and gas (wind instruments). For more videos, see www.splashtones.com | ["Music", "Musical instrument", "Orchestra", "Classical music", "Inside, large room or hall"] | ["low quality", "hydraulophone melody", "water leaking", "noisy", "wide", "mystical", "calming", "relaxing"] | 4 | tnJb9WyhCUc | 5066 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;