musiccaps_details (view)
8 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- distorted · 8 ✖
- live performance · 8 ✖
- low quality 8
- mono · 8 ✖
- noisy 7
- loud 3
- crushed 2
- metal 2
- punchy kick 2
- punchy snare 2
- rock 2
- bright bells 1
- buzzy 1
- cello strings melody 1
- classical 1
- compilation 1
- cover 1
- crowd cheering 1
- distorted bass 1
- electric guitar chords 1
- emotional 1
- energetic 1
- energetic female vocal 1
- energetic muffled instrumental 1
- exciting 1
- harmonizing vocals 1
- harsh 1
- mellow piano chords 1
- messy 1
- muffled 1
- orchestra 1
- passionate 1
- passionate background male vocal 1
- passionate male vocal 1
- resonating sound 1
- screaming male vocal 1
- shimmering hi hats 1
- simple bass 1
- soulful 1
- staccato strings melody 1
- sustained accordion melody 1
- sustained woodwinds melody 1
- synth pads 1
- tinny percussive elements 1
- traditional 1
- weird 1
musiccaps_names (array) 18 ✖
- Music 6
- Singing 4
- Pop music 2
- Rock music 2
- Bellow 1
- Bowed string instrument 1
- Cacophony 1
- Carnatic music 1
- Cello 1
- Chink, clink 1
- Double bass 1
- Drum 1
- Drum kit 1
- Music of Asia 1
- Orchestra 1
- Punk rock 1
- Roll 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vlog No. 12 - SHINee's unofficial Vlogs of 2012 - mistakes & unexpected | The low quality recording features a compilation of recordings where the first recording in the loop is a live performance that's distorted, loud and in mono. The second part of the recording is very noisy and it features bright bells, some resonating sounds and it sounds weird. | 2013-01-11T19:53:33Z | maggie198333 | more to come~ please do not re-upload https://twitter.com/maggieline7 http://www.tudou.com/home/maggie198333 | ["Singing", "Music of Asia", "Music", "Pop music", "Chink, clink"] | ["low quality", "live performance", "loud", "distorted", "bright bells", "noisy", "mono", "resonating sound", "weird", "compilation"] | 4 | 6II4JGJDyZo | 740 | |
I Love Rock'n Roll - Anna-Maria Zimmermann | The low quality recording features a live performance of a rock song that consists of an energetic female vocal singing over electric guitar chords, punchy snare and kick hits and distorted bass guitar. The recording is very noisy and buzzy, in mono, muffled and messy, as it was probably recorded with a phone. It still sounds energetic. | 2007-12-02T10:34:45Z | Leni281 | Anna-Maria Zimmermann (von DSDS 2006) singt "I Love Rock'n Roll" Livemitschnitt vom Nevio Konzert vom 09.04.06 in Hirschaid | ["Singing", "Music", "Rock music", "Roll"] | ["low quality", "buzzy", "noisy", "rock", "mono", "energetic", "muffled", "messy", "distorted", "live performance", "punchy kick", "punchy snare", "distorted bass", "energetic female vocal", "electric guitar chords"] | 4 | 7Mv4eKPe850 | 838 | |
KC Concepcion in Chicago #8 | The low quality recording features harmonizing vocals singing over punchy kick and snare hits, shimmering hi hats, synth pads, simple bass and mellow piano chords. There are crowd cheering noises in the background as this is a live performance. It sounds passionate, emotional, exciting and the recording is noisy, in mono and slightly distorted. | 2011-10-31T01:02:49Z | TeamKC4life | KC Concepcion as Vivian sings the themesong of Lovers in Paris, Wag Na Wag Mong Sasabihin. Much love & thanks to my honey, John, for being KC's best videographer. | ["Singing", "Music", "Pop music", "Whoop"] | ["live performance", "low quality", "noisy", "mono", "crowd cheering", "distorted", "harmonizing vocals", "punchy snare", "punchy kick", "shimmering hi hats", "synth pads", "simple bass", "mellow piano chords", "passionate", "emotional", "exciting"] | 4 | He63KV_9Pwg | 1823 | |
dsce rock band cacophony at "furore 09" | The low quality recording features a live performance of a metal song and it consists of screaming male vocal singing over energetic, muffled instrumental. The recording is crushed, loud, distorted and mono - everything that the metal live performance should be. | 2009-04-05T07:09:35Z | Puneet J | the very own band of dayananda sagar colg....!! awesome show by them at furore 2009..!! | ["Music", "Cacophony"] | ["low quality", "metal", "live performance", "screaming male vocal", "energetic muffled instrumental", "mono", "loud", "crushed", "distorted"] | 4 | IT5hcf0KhYE | 1908 | |
Russian Sailor's Dance, CHS Symphony Orchestra | The low quality recording features a live performance of an orchestra that consists of staccato strings melody and sustained woodwinds melody at least. The recording is very noisy, to the point that it is distorting, and in mono - as it was probably recorded with a poor quality microphone. | 2008-05-22T11:27:06Z | CHSBandBooster | Russian Sailor's Dance, CHS Symphony Orchestra Russian Sailor's Dance by R. Gliere preformed by the Coronado High School Symphony Orchestra. Ida Stedman, Orchestra director. The Symphony Orchestra is composed of students from Band and the String Orchestra. The EPISD Festival for Orchestra was held on Thursday May 15, 2008 at the "Ross Capshaw Auditorium" Coronado High School in El Paso Texas. | ["Orchestra"] | ["low quality", "noisy", "live performance", "mono", "orchestra", "distorted", "staccato strings melody", "sustained woodwinds melody"] | 4 | O6xMQnKJROc | 2400 | |
Avenged Sevenfold - Second Heartbeat (Cover) | The low quality recording features a live performance of a metal song. The recording is noisy, in mono and so crushed, distorted, harsh and loud that you can barely hear anything but the loud noise. | 2006-04-06T15:42:42Z | merman2006 | Here is a cover of Second Heartbeat By Avenged Sevenfold performed at the "Last KLCVI Concert" Ricky Bowes - Screams Tim Burak - Drums Steph Barette - Guitar/vocals Scott Merhar - Guitar Shawn Vucko - Bass | ["Singing", "Drum", "Drum kit", "Music", "Punk rock", "Rock music", "Bellow"] | ["low quality", "noisy", "mono", "metal", "crushed", "distorted", "loud", "live performance", "harsh"] | 4 | XjGm3Bn4j5k | 3215 | |
Michelle - The Beatles | The low quality recording features a live performance of a classical cover of a rock song that consists of a cello strings melody playing.The recording is noisy, slightly distorted and in mono. | 2007-04-11T00:32:13Z | bronichka | 6th grade students from Advanced String Orchestra performed songs at the International Art Exhibition in our local school. (There were beautiful drawings and paintings by young students from Uganda, Kazachstan, China, etc.) Encouraging comments to our students are welcome. | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "live performance", "rock", "classical", "cover", "cello strings melody", "noisy", "mono", "distorted"] | 4 | i6dFcfV64RE | 4159 | |
Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi | The low quality recording features a live performance of a traditional song and it consists of passionate male vocal, alongside passionate background male vocal singing over sustained accordion melody and some tinny percussive elements. Even though it is a bit distorted, mono and noisy, it still sounds soulful. | 2010-11-01T13:24:25Z | Zee Marathi | Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi Free Subscription click here : http://bit.ly/SubscribeZeeMarathi Get notified about our Latest update by Clicking the Bell Icon 🔔 Award Shows Paid Subscription #Zee5 click here: https://bit.ly/32gxIJ4 To #Free #Download ZEE5 #Mobile app click the link below Playstore: http://bit.ly/Zee5PlayStore iTunes: http://bit.ly/Zee5ITunes Connect with Zee Marathi on Social Media Facebook - http://bit.ly/ZeeMarathiFb Instagram - http://bit.ly/ZeeMarathiInsta Twitter - http://bit.ly/ZeeMarathiTwitter Connect with Zee5 on Social Media Facebook : http://bit.ly/Zee5MarathiFB Instagram : http://bit.ly/Zee5MarathiInsta Twitter : http://bit.ly/Zee5MarathiTwitter | ["Carnatic music", "Music"] | ["traditional", "live performance", "passionate male vocal", "sustained accordion melody", "low quality", "tinny percussive elements", "passionate background male vocal", "noisy", "mono", "distorted", "soulful"] | 4 | pzm90xLX9HM | 4747 |
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;