musiccaps_details (view)
6 rows where musiccaps_aspects contains "motivational" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- emotional 6
- inspiring 6
- motivational · 6 ✖
- romantic · 6 ✖
- female singer 4
- medium tempo 3
- story telling 3
- strong bass line 3
- bad audio quality 2
- guitar accompaniment 2
- live performance 2
- love song 2
- piano accompaniment 2
- poor audio quality 2
- slow tempo 2
- string section harmony 2
- amateur singing 1
- ambient room noises 1
- backup singers 1
- bass solo 1
- cameras clicking 1
- christian music 1
- church music 1
- classic hits 1
- country hits 1
- crowds clapping 1
- crowds whistling 1
- dealing with depression 1
- devotional 1
- diva 1
- drum brushes percussions 1
- encouraging crowd 1
- fretboard sounds 1
- groovy bass line 1
- groovy rhythm 1
- groovy solo 1
- guitar rhythm 1
- high spirits 1
- hip hop dance music 1
- hip hop music 1
- home video 1
- jazz band 1
- jazz music 1
- keyboard accompaniment 1
- life lessons 1
- lilting vocals 1
- loneliness 1
- loving 1
- madly in love 1
- male singer 1
- memdium tempo 1
- modern hip hop hits 1
- modern pop hits 1
- modern r&b hits 1
- music concert 1
- music interlude 1
- never give up on you 1
- nostalgia 1
- old classics 1
- organ accompaniment 1
- passionate 1
- percussive bass line 1
- poignant 1
- pop song 1
- r&b 1
- retro hits 1
- retro pop hits 1
- self discovery 1
- smooth jazz 1
- song cover 1
- soul singer 1
- spirited 1
- steady drumming rhythm 1
- steady percussive rhythm 1
- timeless hits 1
- together forever 1
- vibrato 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 4
- Applause 1
- Bass guitar 1
- Crackle 1
- Music of Asia 1
- Musical instrument 1
- Rhythm and blues 1
- Sad music 1
- Tender music 1
- Wedding music 1
youtube_published (date) 6 ✖
- 2008-05-24 1
- 2009-03-30 1
- 2009-11-25 1
- 2010-08-25 1
- 2012-12-29 1
- 2015-10-10 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BELLA's LULLABY / RIVER FLOWS IN YOU - Music Video -- NEW VERSION | The song is an instrumental. The song is slow tempo with gentle drum brushes, percussion, bass guitar solo, and piano accompaniment gently. The song is groovy and emotional. The song is possibly a Christian worship song or a smooth jazz song. The audio quality is average. | 2009-11-25T20:46:54Z | peoplewholovenewmoon | A heartbreakingly beautiful performance of this hit song by the Korean composer Yiruma - which is not the official Bella's Lullaby, but proved much more popular with Twilight fans. The version features not just piano but achingly melancholy solos by superb musicians on bass, guitar, sax, and vocals. | ["Bass guitar", "Music", "Musical instrument", "Wedding music"] | ["slow tempo", "drum brushes percussions", "inspiring", "devotional", "romantic", "together forever", "ambient room noises", "poignant", "jazz music", "bass solo", "piano accompaniment", "jazz band", "smooth jazz", "live performance", "church music", "slow tempo", "groovy solo", "emotional", "romantic", "poignant", "inspiring", "motivational", "fretboard sounds", "christian music", "music interlude"] | 1 | 0EOQco76eXQ | 135 | |
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 | |
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
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 | ||
Anne Murray: You've Got A Friend | A female singer sings this beautiful melody. The tempo is medium with a string section harmony and a strong bass line. The audio quality is poor. The song is a retro pop hit with inspiring and romantic vibes. | 2009-03-30T09:21:45Z | happysun | ["Music", "Sad music"] | ["female singer", "lilting vocals", "strong bass line", "poor audio quality", "country hits", "diva", "timeless hits", "classic hits", "emotional", "romantic", "life lessons", "inspiring", "motivational", "loving", "romantic", "medium tempo", "retro pop hits", "diva", "string section harmony", "medium tempo"] | 1 | oNryELagQUM | 4623 | ||
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;