musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "poignant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- emotional 3
- keyboard harmony · 3 ✖
- medium tempo · 3 ✖
- poignant · 3 ✖
- groovy bass line 2
- acoustic guitar accompaniment 1
- amateur music production 1
- dance club 1
- dance mix 1
- dance music 1
- discomforting effect 1
- discotheque 1
- dissonant tambourine beats 1
- eerie 1
- electric guitar rhythm 1
- energetic drumming 1
- euro pop 1
- faint vocals 1
- female singer 1
- flute countermelody 1
- groovy music 1
- guitar accompaniment 1
- hardship 1
- harp accompaniment 1
- haunting 1
- haunting harmony 1
- horror film soundtrack 1
- inspiring 1
- male rapper 1
- male vocalist 1
- melancholic 1
- mellow 1
- melodious 1
- no percussions 1
- nostalgic 1
- offbeat 1
- passionate 1
- people dancing 1
- poor audio quality 1
- purposeful 1
- quirky 1
- romantic 1
- russian hit songs 1
- russian rap music 1
- sentimental 1
- steady drumming rhythm 1
- story telling 1
- sweet 1
- synth arrangement 1
- underground music 1
- unsettling 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 3
- Grunge 1
- Hip hop music 1
- Rapping 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
the GHOST BRIDE | A female singer sings this eerie melody. The song is medium tempo with a rolling bells keyboard harmony, and other ambient echo tones and harp tones. The song is haunting and unsettling. The audio quality is very poor and not enjoyable. | 2013-10-04T23:18:46Z | grav3yardgirl | -DON'T WORRY- makeup & hair tutorial COMING TOMORROW! SWAMP FAMILY TEA CUPS ARE BACK! https://www.etsy.com/listing/125139605/16-oz-swamp-family-tea-cup http://www.youtube.com/subscription_center?add_user=grav3yardgirl INSTAGRAM: @grav3yardgirl www.numestyle.com Coupon code: funnybunny - $115 off Curling Wands and Flat Irons Coupon code: bunny8 - $120 off all our styling sets Coupon code: bunny1 - $97 FOR the Lustrum, Couture and Argan Oil, total discount of $366 OFF! http://goo.gl/BGoya3 WANNA SEND ME MAIL? SEND IT HERE!: GRAV3YARDGIRL PO BOX #2263 PEARLAND, TEXAS 77588 follow me on twitter: http://twitter.com/grav3yardgirl LIKE ME ON FACEBOOK: http://www.facebook.com/grav3yardgirl please check out MY ETSY PAGE!!: http://www.etsy.com/shop/enmortem?ref... please take a moment to subscribe!! FTC- I am not being paid by any of the mentioned companies or designers to make this video. The views in this video are strictly my own and I am not affiliated with any of these companies. | ["Music", "Scary music"] | ["female singer", "faint vocals", "eerie", "haunting", "emotional", "poor audio quality", "discomforting effect", "poignant", "unsettling", "offbeat", "quirky", "amateur music production", "haunting harmony", "horror film soundtrack", "no percussions", "harp accompaniment", "keyboard harmony", "medium tempo"] | 1 | KoAGZ_dB8MM | 2119 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
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;