musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "pop" and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- acoustic guitar · 2 ✖
- pop · 2 ✖
- amateur recording 1
- amateur singer 1
- backup harmony 1
- doorbell ringing 1
- e-bass 1
- emotional 1
- foreign language 1
- karaoke 1
- keyboard harmony 1
- laughing sample 1
- male and female voices singing 1
- male singer 1
- medium tempo 1
- mellow 1
- percussions 1
- reverb 1
- sentimental 1
- soft 1
- steady drumming 1
- straight bass lines 1
- uplifting energy 1
- uptempo 1
- violin harmony 1
- violin symphony 1
- vocal backup 1
musiccaps_names (array) 4 ✖
- Christmas music · 2 ✖
- Music 2
- Christian music 1
- Song 1
youtube_published (date) 2 ✖
- 2007-11-02 1
- 2015-12-03 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thien kong nyit cie jiu ko ho ( Hakka song ) | A male vocalist sings this soft melody. The song is medium tempo, with violin harmony, steady drumming, straight bass lines, acoustic guitar and keyboard accompaniment with vocal backup. The song is in a foreign language. It is slow, and has a mellow, soft, emotional , sentimental and romantic vibe. This is a regional Pop song. | 2007-11-02T14:18:16Z | HakkaNyinXmantan | hakka love song | ["Christmas music", "Music", "Song"] | ["male singer", "medium tempo", "foreign language", "steady drumming", "keyboard harmony", "straight bass lines", "acoustic guitar", "vocal backup", "violin harmony", "violin symphony", "emotional", "sentimental", "mellow", "soft", "reverb", "backup harmony", "karaoke", "amateur recording", "amateur singer", "soft", "mellow", "emotional", "sentimental", "pop"] | 7 | MZhaDGgULtc | 2281 | |
RFM - Musica de Natal - 2015 - Bolas de Natal | This audio contains a lot of different percussive instruments spread to both sides of the speakers. In the background you can hear a laughing sample in a high pitch. A male voice is singing in a higher pitch than a female voice takes over singing. A doorbell is ringing. An acoustic guitar is strumming chords. This song may be playing at an open air festival where everybody can dance along. | 2015-12-03T08:13:43Z | RFM | Aqui está a nossa música de natal deste ano RFM - Bolas de Natal Junta-se a família à volta da mesa, É a tradição Rimos e choramos, relembramos outros anos, uh Vemos televisão A gente come come come come come come come até se sentir mal O meu tio bebe bebe bebe bebe bebe nós somos BOLAS DE NATAL No natal, multiplicamos É normal porque é o dia em que Jesus faz anos Se tens a mais achamos bem, Que vás para a rua partilhar com quem não tem É natal x3 BOLAS DE NATAL O pai natal anda aflito Mas aprendi que quanto mais dou mais rico eu fico. Se tens a mais, tem a certeza Que o teu vizinho não passa a noite sozinho à mesa É natal x3 Já viste o tempo passa a voar Tens tudo ainda pra preparar É natal, É natal, já é natal mulher Me belisca só podes estar a sonhar se achas que não me vais ajudar Queres natal? Queres Natal? Ajuda a tua mulher FELIZ NATAL ÁTOA Carolina Deslandes Mikkel Solnado Music Landrick Diego Miranda | ["Christmas music", "Christian music", "Music"] | ["pop", "percussions", "acoustic guitar", "laughing sample", "doorbell ringing", "male and female voices singing", "e-bass", "uptempo", "uplifting energy"] | 6 | oNggxSyyyq8 | 4621 |
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;