musiccaps_details (view)
2 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- exciting · 2 ✖
- passionate · 2 ✖
- pop · 2 ✖
- break the tension 1
- building anticipation 1
- buzz 1
- crowd cheering 1
- crowd clapping 1
- distorted amplified guitar 1
- drum roll 1
- electrostatic sounds 1
- energetic 1
- enthusiastic 1
- enthusiastic drumming 1
- get tones 1
- guitar strumming 1
- heart beat melody 1
- k-pop 1
- korean rock band 1
- live performance 1
- low quality 1
- male singer 1
- passionate male vocal 1
- percussive bass line 1
- pop dance rhythm 1
- pop dance song 1
- punchy kick 1
- punchy snare 1
- shimmering riser 1
- signal tempo 1
- simple hi hats 1
- spirited 1
- storm cloud noises 1
- synth keys melody 1
- synth pad chords 1
- teen spirit 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Applause 1
- Exciting music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
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 |
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;