musiccaps_details (view)
3 rows where musiccaps_aspects contains "slow tempo", musiccaps_author = 9 and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- acoustic drums 3
- melodic singing 3
- slow tempo · 3 ✖
- acoustic guitar 2
- bass guitar 2
- easygoing 2
- alternative rock 1
- ballad 1
- calm 1
- cartoon theme 1
- crowd singing 1
- electric guitar 1
- emotional 1
- female vocal 1
- festive music 1
- gentle 1
- keyboard 1
- korean indie rock 1
- live performance 1
- male vocal 1
- mellow 1
- pop music 1
- serene 1
- simple tune 1
- spanish 1
- teen female vocal 1
musiccaps_names (array) 7 ✖
- Music 3
- Song · 3 ✖
- Singing 2
- A capella 1
- Independent music 1
- Music for children 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Auguri di Capodanno divertenti! Felice anno nuovo con canzoni e un video Disney divertente.Buon 2020 | This is a festive music piece used as a theme for a cartoon. It is a slow tempo piece. There is a female vocalist singing melodically. The keyboard is playing the melody while the bass guitar is following in the background. The rhythm consists of a calm acoustic drum beat. The atmosphere is serene. This piece could be playing in the background at a slow dance event. | 2012-12-28T23:51:31Z | EmporioGenova | Auguri di Buon Capodanno 2020 con un video divertente! Auguri di Felice Anno Nuovo con questo video divertente ispirato ai personaggi più famosi delle fiabe Disney, da Biancaneve e i sette nani a Cenerentola, dalla Sirenetta alla Bella e la Bestia, senza dimenticare i Tre Porcellini e gli animali della fattoria! La colonna sonora è l'intramontabile "Happy New Year" degli Abba, mixata con l'altrettanto intramontabile "Happy Days" sigla della nota serie TV anni '70. All'interno del canale youtube Emporio Genova puoi trovare altri video per gli auguri di Natale, Capodanno ed Epifania.... e molto altro ancora, condividili con i tuoi amici su facebook o tramite whatsapp e twitter. ************************************************* SEGUICI SUI SOCIAL: iscriviti al canale youtube: http://www.youtube.com/user/EmporioGenova?sub_confirmation=1 pagina facebook: https://www.facebook.com/emporiogenova/ negozio online: https://emporiogenova.com/ | ["Music", "Music for children", "Song"] | ["cartoon theme", "festive music", "female vocal", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "calm", "serene", "easygoing", "slow tempo"] | 9 | 8fibq2VXibw | 934 | |
Invencible/Music Club de Vázquez Sounds | This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. | 2014-09-29T02:14:40Z | Vázquez Sounds Support Mexico | Nuestras redes sociales: Facebook: http://bitly.com/1rW5VpV Youtube: http://bitly.com/1vpC2gw Instagram: http://bit.ly/1oHYlJB Twitter: http://bitly.com/1yEsrar Ask: http://bit.ly/1CKk6AM {Grabado por nosotros} Club de fans oficial. Vazquez Sounds en vivo (Live) | ["Singing", "Music", "Song", "A capella"] | ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] | 9 | BaMBwXQwK3g | 1263 | |
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 |
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;