musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "male singer", musiccaps_aspects contains "violin symphony" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- emotional 3
- male singer · 3 ✖
- violin symphony · 3 ✖
- acoustic guitar 2
- amateur recording 2
- mellow 2
- pop 2
- sentimental 2
- slow tempo 2
- soft 2
- steady drumming 2
- amateur singer 1
- backup harmony 1
- baritone 1
- christmas carol 1
- christmas time 1
- chrost 1
- classic melody 1
- classic rock 1
- distorted sound 1
- dulcet 1
- foreign language 1
- french carols 1
- french song 1
- guitar accompaniment 1
- inaudible lyrics 1
- indistinct chatter 1
- inferior audio quality 1
- karaoke 1
- keyboard arrangement 1
- keyboard harmony 1
- medium tempo 1
- mellifluous 1
- melodic 1
- muffled vocals 1
- nostalgia 1
- retro 1
- retro rock and roll 1
- reverb 1
- rock and rock 1
- soft melody 1
- soft piano 1
- straight bass lines 1
- violin harmony 1
- vocal backup 1
- white christmas 1
musiccaps_names (array) 8 ✖
- Music · 3 ✖
- Christian music 1
- Christmas music 1
- Gospel music 1
- Mantra 1
- Singing 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
BJ Thomas ~ Rock And Roll Lullaby | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | 2011-06-25T22:02:46Z | IP Casino Resort Spa | BJ Thomas sings "Rock And Roll Lullaby" in Studio A in the IP Casino Resort Spa on June 24, 2011 | ["Singing", "Gospel music", "Music", "Wedding music"] | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | 7 | BUzsQ6WohH4 | 1245 | |
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 | |
Sacha Distel chante Noël (Petit papa Noël, Noël Blanc, Ding Ding Dong..) | A male vocalist sings this melodic, age old Christmas carol in French in Baritone. The tempo is slow with a violin symphony, the piano accompaniment, keyboard harmony; rhythmic acoustic guitar and steady drumming . The song is mellow, sentimental, emotional, nostalgic, pleasant ,dulcet and mellifluous . | 2015-12-04T14:36:07Z | The Best Christmas Songs | ✔ Abonnez-vous à la chaîne de Noël pour ne manquer aucune vidéo karaoké → http://bit.ly/1hl2uAM ⇓ Téléchargez "Sacha Distel chante Noël" ici → https://itunes.apple.com/album/id9499... ↓TRACKLIST↓ 1. Noël blanc : 00:00 2. Ding, ding, dong : 02:09 3. Chante Noël : 04:26 4. Petit papa Noël : 07:23 5. Si grande est la terre : 10:15 6. Noël à Bethléem : 13:41 7. L'enfant au tambour : 15:55 8. Les trois oranges : 19:02 9. Les Rois Mages : 22:00 10. Prière pour la nuit de Noël : 24:08 11. On croit toujours un peu au père Noël : 26:55 12. Je reviendrai chez nous à la Noël : 29:24 ♫ Ecoutez les plus beaux chants de noël par Tino Rossi → https://www.youtube.com/watch?v=LkrzS... | ["Mantra", "Christian music", "Music"] | ["male singer", "slow tempo", "french carols", "emotional", "sentimental", "nostalgia", "dulcet", "mellifluous", "white christmas", "baritone", "soft", "mellow", "violin symphony", "acoustic guitar", "soft piano", "french carols", "french song", "christmas carol", "christmas time", "chrost"] | 7 | bJ6e9Ja1ahQ | 3614 |
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;