musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- live performance · 4 ✖
- low quality 4
- passionate male vocal · 4 ✖
- punchy kick · 4 ✖
- punchy snare 3
- emotional 2
- energetic 2
- exciting 2
- groovy bass guitar 2
- noisy 2
- passionate 2
- rock 2
- shimmering hi hats 2
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- crowd cheering 1
- crowd clapping 1
- electric guitar melody 1
- groovy 1
- harmonizing male vocals 1
- messy 1
- pop 1
- regional mexican 1
- shimmering open hats 1
- shimmering riser 1
- shimmering tambourine 1
- simple hi hats 1
- soft synth keys melody 1
- soulful 1
- synth keys melody 1
- synth pad chords 1
- wide electric guitar melody 1
musiccaps_names (array) 10 ✖
- Music 4
- Rock and roll 2
- Applause 1
- Bass guitar 1
- Christmas music 1
- Gospel music 1
- Punk rock 1
- Rock music 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ずっと好きだった | 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 | ||
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
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;