musiccaps_details (view)
7 rows where musiccaps_aspects contains "inspiring" and musiccaps_aspects contains "story telling" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 95 ✖
- inspiring · 7 ✖
- story telling · 7 ✖
- emotional 6
- female singer 4
- motivational 4
- bad audio quality 3
- groovy bass line 3
- love song 3
- medium tempo 3
- passionate 3
- romantic 3
- guitar accompaniment 2
- hissing tones 2
- keyboard accompaniment 2
- keyboard harmony 2
- male singer 2
- piano accompaniment 2
- pop song 2
- slow tempo 2
- steady drumming rhythm 2
- strong bass line 2
- acoustic pop hits 1
- backup singers 1
- building anticipation 1
- classic pop hits 1
- dance club 1
- dance mix 1
- dance music 1
- death metal music 1
- deteriorated audio quality 1
- discotheque 1
- eerie 1
- energetic 1
- euro pop 1
- fast drumming rhythm 1
- fast metal drumming 1
- flute countermelody 1
- game soundtrack 1
- groovy music 1
- groovy rhythm 1
- guitar rhythm 1
- hall reverb 1
- hardship 1
- high spirits 1
- hip hop dance music 1
- hip hop music 1
- hissing and buzzing distortions 1
- life’s lessons 1
- live audience 1
- live concert 1
- madly in love 1
- male rapper 1
- medium fast tempo 1
- melancholic 1
- memdium tempo 1
- modern hip hop hits 1
- modern pop 1
- modern pop covers 1
- modern pop hits 1
- modern r&b hits 1
- movie soundtrack 1
- never give up on you 1
- nostalgia 1
- odern pop hits 1
- old classics 1
- organ accompaniment 1
- people dancing 1
- percussive bass line 1
- poignant 1
- poor audio quality 1
- pop diva 1
- pop hit 1
- pop super hits 1
- purposeful 1
- r&b 1
- retro hits 1
- russian hit songs 1
- russian rap music 1
- scary 1
- self discovery 1
- slamming door percussion 1
- song cover 1
- soul singer 1
- soulful singing 1
- spirited 1
- steady percussive rhythm 1
- string section harmony 1
- subtle bass line 1
- suspense 1
- underground music 1
- vibrato 1
- video game soundtrack 1
- vocal echoes 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 12 ✖
- Music 5
- Angry music 1
- Christian music 1
- Hip hop music 1
- Music of Asia 1
- Rapping 1
- Rhythm and blues 1
- Scary music 1
- Singing 1
- Song 1
- Speech 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A time for us ~ lyrics ***there is a mistake with the name of singer. This is not Loreena*** | A female singer sings this lilting melody. The song is medium tempo with an acoustic guitar accompaniment, strong bass line, steady rhythm and piano accompaniment. The song has a bad audio quality. The song is emotional and nostalgic in nature. | 2010-08-25T18:09:52Z | CathCthrn | (Love Theme from Romeo and Juliet) (Words by Larry Kusik, Eddie Snyder / Music by Nino Rota) Lyrics A time for us, some day there'll be When chains are torn by courage born of a love that's free A time when dreams so long denied can flourish As we unveil the love we now must hide A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me | ["Music", "Tender music"] | ["female singer", "bad audio quality", "medium tempo", "strong bass line", "guitar accompaniment", "pop song", "vibrato", "piano accompaniment", "string section harmony", "old classics", "retro hits", "story telling", "inspiring", "motivational", "emotional", "romantic", "nostalgia"] | 1 | 5Tq56BN8PCQ | 661 | |
ArcheAge - Archer 50 lvl pvp, DollVasta (19.04.14) | A male singer sings these whispering vocals. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is tense and full of suspense. The song is a game soundtrack. | 2014-04-19T14:38:05Z | b1shock | DollVasta(BIOSHOCK,BIOPWNZ) | ["Music", "Speech", "Angry music"] | ["death metal music", "male singer", "game soundtrack", "building anticipation", "fast drumming rhythm", "medium fast tempo", "video game soundtrack", "passionate", "energetic", "scary", "eerie", "fast metal drumming", "groovy bass line", "story telling", "inspiring", "keyboard harmony"] | 1 | LLDHkHHKYkI | 2179 | |
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 | ||
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 | |
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 | |
Adele crying at Royal Albert Hall - Someone like you live HD | A female pop star sings this lilting melody. The song is medium tempo with a piano playing accompaniment with a subtle bass line. The song is emotional and inspiring. The song is a modern pop hit played to a live audience. The song audio quality is poor and deteriorated. | 2012-09-29T19:17:31Z | Nil Iys | XL Records C. http://tinyurl.com/97zvsko Adele crying at Royal Albert Hall after singing someone like you! :) | ["Singing", "Christian music", "Music", "Song"] | ["female singer", "poor audio quality", "pop hit", "live concert", "emotional", "love song", "classic pop hits", "story telling", "live audience", "pop diva", "soulful singing", "piano accompaniment", "deteriorated audio quality", "hissing tones", "acoustic pop hits", "inspiring", "emotional", "love song", "motivational", "subtle bass line", "pop super hits", "modern pop", "hall reverb"] | 1 | nSinUcyFFqg | 4539 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;