musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic drumming" and musiccaps_aspects contains "melodious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- energetic drumming · 2 ✖
- keyboard harmony 2
- melodious · 2 ✖
- acoustic guitar accompaniment 1
- ambient nature music 1
- breezy 1
- catchy 1
- catchy vocal riff 1
- cheerful 1
- dissonant tambourine beats 1
- electric guitar rhythm 1
- emotional 1
- energetic 1
- female choral harmony 1
- groovy bass line 1
- jingle 1
- male vocalist 1
- medium tempo 1
- mellow 1
- metallic sound 1
- nostalgic 1
- peppy 1
- perky 1
- poignant 1
- pop 1
- punchy basslines 1
- romantic 1
- sentimental 1
- sound of wind 1
- sweet 1
- synth arrangement 1
- synthesiser arrangements 1
- whooshing sound 1
- windy 1
musiccaps_names (array) 3 ✖
- Music 2
- Grunge 1
- Walk, footsteps 1
youtube_published (date) 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This song is an upbeat pop song. The tempo is medium fast with energetic drumming, groovy bass lines, keyboard harmony, synthesiser arrangements and female vocal riff. The song is fresh, youthful, perky, catchy, cheerful and energetic. There are sounds of wind, breeze and some metal clanking. This song sounds like a Jingle. | ["Music", "Walk, footsteps"] | ["sound of wind", "energetic drumming", "cheerful", "energetic", "catchy", "perky", "metallic sound", "ambient nature music", "punchy basslines", "keyboard harmony", "synthesiser arrangements", "whooshing sound", "windy", "breezy", "catchy vocal riff", "female choral harmony", "perky", "peppy", "cheerful", "energetic", "melodious", "pop", "jingle"] | 7 | 2762 | |||||
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 |
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;