musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- emotional 3
- groovy bass line · 3 ✖
- keyboard harmony · 3 ✖
- romantic · 3 ✖
- melodious 2
- sentimental 2
- acoustic guitar 1
- acoustic guitar accompaniment 1
- classic pop 1
- dissonant tambourine beats 1
- electric guitar 1
- electric guitar rhythm 1
- energetic drumming 1
- female vocalist 1
- fingers snapping 1
- first love 1
- fog horn 1
- indonesian pop 1
- love song 1
- male singer 1
- male vocalist 1
- male voice speaking 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- nostalgic 1
- passionate 1
- pleasant 1
- poignant 1
- pop 1
- r&b 1
- reggae 1
- rhythmic acoustic guitar 1
- slow tempo 1
- soft melodious 1
- soothing 1
- soul 1
- sound of horn 1
- straight drumming 1
- super imposed male voice 1
- sweet 1
- synth arrangement 1
- synthesiser 1
- synthesiser articulation 1
- tambourine beats 1
- vivacious 1
- vivid 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 3
- Christmas music 1
- Grunge 1
- Happy music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Lie To Me opening theme - Music - Ryan Star - Brand New Day | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | 2009-04-17T03:37:09Z | Ricardo Miranda | Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT | ["Music", "Grunge"] | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | 7 | l9vYSBR9nio | 4377 | |
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 | |||||
Ten2Five - My World Is Full With You | A female vocalist sings this beautiful pop melody. The tempo is medium fast with rhythmic acoustic guitar, keyboard harmony, electric guitar melody, straight drumming;steady bass and tambourine beats. The song is mellow, sweet, passionate,emotional, youthful, romantic, simple and tender. This song is a hit Indonesian Pop. | 2012-10-13T23:03:56Z | Xily Gina | Indonesian indie band | ["Christmas music", "Music", "Happy music"] | ["female vocalist", "medium fast tempo", "pop", "straight drumming", "classic pop", "passionate", "emotional", "romantic", "first love", "indonesian pop", "melodious", "rhythmic acoustic guitar", "electric guitar", "groovy bass line", "keyboard harmony", "tambourine beats", "synthesiser", "vivid", "vivacious", "youthful", "love song", "emotional", "sentimental"] | 7 | zTtZH-Q61Ik | 5480 |
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;