musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- keyboard harmony · 3 ✖
- male singer · 3 ✖
- romantic · 3 ✖
- emotional 2
- love song 2
- acoustic guitar 1
- baby crying 1
- backup singers 1
- bass guitar 1
- clapping percussions 1
- classic pop 1
- cymbals crashing 1
- fast tempo 1
- fingers snapping 1
- fog horn 1
- forgive me 1
- groovy bass line 1
- guitar lead 1
- heartfelt 1
- infectious drumming 1
- i’m sorry 1
- male voice speaking 1
- medium tempo 1
- modern pop hits 1
- pleasant 1
- poor audio quality 1
- r&b 1
- reggae 1
- retro 1
- rock and roll 1
- slick percussion clicks 1
- slow tempo 1
- soft melodious 1
- soothing 1
- soul 1
- sound of horn 1
- static 1
- steady drumming 1
- steady drumming rhythm 1
- string section playing rhythmically 1
- strong bass line 1
- super imposed male voice 1
- superimposed noises 1
- synthesiser arrangements 1
- synthesiser articulation 1
- tapping sound 1
- together for ever 1
- upbeat 1
- violins 1
- vivacious 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Baby cry, infant cry 1
- Crying, sobbing 1
- Happy music 1
- Inside, small room 1
- Reggae 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
One Republic - Apologize (Lyrics) | A male singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a percussive string section, strong bass line, guitar lead, steady drumming rhythm , keyboard accompaniment and various percussion clicks. The song is emotional and romantic. The song is of poor audio quality. | 2013-12-06T06:01:44Z | Giz Ruar | "Apologize" belongs to One Republic. From the "Dreaming Out Loud" album, 2006. http://onerepublic.com/ Please, suscribe to my channel. TY! My Facebook Official Page: https://www.facebook.com/GizelleSixxJ If you want a special lyric video, just let me know in a comment below the video and I'll try to make it. Thanks for watching. | ["Music", "Happy music"] | ["male singer", "backup singers", "guitar lead", "medium tempo", "steady drumming rhythm", "string section playing rhythmically", "cymbals crashing", "slick percussion clicks", "strong bass line", "keyboard harmony", "modern pop hits", "emotional", "romantic", "together for ever", "i’m sorry", "forgive me", "love song", "poor audio quality", "heartfelt", "vocal harmony", "clapping percussions"] | 1 | -wymN80CiYU | 105 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 | |||||
RickRolling the Baby | A male singer sings this classic pop song. The tempo is fast with keyboard harmony, violins,infectious drumming,funky bass guitar and synthesiser arrangement. There are sounds of static, tapping and a baby crying loudly superimposed on the song. The audio quality is inferior and the recording is amateur. This song is Retro Rock and Roll. | 2008-01-26T06:05:33Z | DessertSage | http://www.marylowd.com | ["Crying, sobbing", "Music", "Baby cry, infant cry", "Inside, small room"] | ["male singer", "fast tempo", "baby crying", "youthful", "romantic", "upbeat", "superimposed noises", "synthesiser arrangements", "infectious drumming", "love song", "romantic", "vivacious", "violins", "bass guitar", "keyboard harmony", "tapping sound", "static", "steady drumming", "classic pop", "rock and roll", "retro"] | 7 | qMbGFWz9who | 4780 |
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;