musiccaps_details (view)
6 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "punchy snare"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- live performance · 6 ✖
- low quality 6
- passionate male vocal · 6 ✖
- punchy snare · 6 ✖
- energetic 3
- joyful 3
- noisy 3
- punchy kick 3
- crowd clapping 2
- emotional 2
- exciting 2
- groovy bass 2
- groovy bass guitar 2
- harmonizing male vocals 2
- rock 2
- shimmering hi hats 2
- acoustic rhythm guitar 1
- addictive 1
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- country 1
- crowd cheering 1
- electric guitar melody 1
- folk 1
- groovy 1
- hopeful 1
- messy 1
- mono 1
- passionate 1
- playback instrumental 1
- pop 1
- shimmering open hats 1
- shimmering riser 1
- shimmering tambourine 1
- simple hi hats 1
- simple kick 1
- soft kick hits 1
- soul 1
- soulful 1
- steel guitar repetitive guitar 1
- synth keys melody 1
- synth pad chords 1
- toms roll 1
- wide electric guitar melody 1
- wooden percussions 1
- woodwind melody 1
musiccaps_names (array) 14 ✖
- Music 5
- Rock and roll 2
- Singing 2
- /t/dd00003 1
- Applause 1
- Bass guitar 1
- Blues 1
- Drum 1
- Drum kit 1
- Music of Latin America 1
- Musical instrument 1
- Punk rock 1
- Rock 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 |
---|---|---|---|---|---|---|---|---|---|---|
Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
Azerbaijan Music Wedding in Israel - Issey | The low quality recording features a live performance of a folk song that consists of a passionate male vocal singing over groovy bass, woodwind melody, punchy snare and wooden percussion. It sounds joyful, energetic and the recording is noisy. | 2007-08-09T13:31:14Z | IzzIPiano | Keyboard played by Issey | ["Drum", "Drum kit", "Music", "Musical instrument", "Wedding music", "Music of Latin America"] | ["low quality", "folk", "passionate male vocal", "groovy bass", "woodwind melody", "punchy snare", "energetic", "wooden percussions", "live performance", "joyful", "noisy"] | 4 | fiAcNMpd2vM | 3971 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 | |
Lady Gaga - Applause (Soufjan) | The Voice Kids 2014 | Blind Audition | SAT.1 | The low quality recording features a live performance of a pop song and it consists of passionate male vocal singing over synth keys melody, shimmering riser, simple hi hats, punchy kick and snare hits and synth pad chords. There were some widely spread crowd claps and cheering as they were excited. It sounds energetic, exciting and passionate. | 2014-03-28T21:00:01Z | The Voice Kids | Was für eine Stimme! Soufjan macht seiner Song-Auswahl "Applause" (von Lady Gaga) alle Ehre und bringt das Publikum zum Toben! Mehr Auftritte findet ihr hier:http://www.sat1.de/tv/the-voice-kids/video/playlists/ganze-folgen The Voice Kids 2014 - Lena Meyer-Landrut, Henning Wehland und Revolverheld-Frontmann Johannes Strate suchen junge Sänger mit großartigen Stimmen Ob jung oder alt - nur die Stimme zählt: In vier „Blind Auditions" lassen sich die drei Coaches mit dem Rücken zur Bühne von den Stimmen verzaubern. Sie drücken den Buzzer, um die jungen Talente für ihr Team zu gewinnen. Anschließend treten die jungen Sängerinnen und Sänger (8 bis 14 Jahre) in drei „Battle"-Shows jeweils in Dreier-Konstellationen an. Die Gewinner der „Battles" ziehen direkt in das Finale ein. Der Sieger von „The Voice Kids" bekommt einen Ausbildungsvertrag in Höhe von 15.000 Euro sowie einen optionalen Plattenvertrag. Die Eltern entscheiden, ob sie diese Option wahrnehmen oder nicht. Moderiert wird die die zweite Staffel von „The Voice Kids" wieder von Thore Schölermann (28), als Backstage-Moderatorin ist Nela Lee (33, „taff") im Einsatz. The Voice Kids Staffel II - acht Folgen, ab Freitag, 21. März 2014, 20.15 Uhr in Sat.1 Impressum: https://www.sat1.de/service/impressum/ | ["Applause", "Music"] | ["low quality", "live performance", "pop", "passionate male vocal", "crowd clapping", "crowd cheering", "synth keys melody", "shimmering riser", "simple hi hats", "punchy snare", "punchy kick", "synth pad chords", "passionate", "energetic", "exciting"] | 4 | qwI32Si0ipE | 4835 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;