musiccaps_details (view)
6 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "piano accompaniment" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 85 ✖
- bad audio quality · 6 ✖
- emotional 6
- piano accompaniment · 6 ✖
- medium tempo 5
- passionate 4
- female singer 3
- groovy bass line 2
- guitar accompaniment 2
- pop song 2
- retro hits 2
- romantic 2
- steady drumming rhythm 2
- story telling 2
- acoustic love song 1
- aggressive 1
- backup singers 1
- boomy bass line 1
- chord changes 1
- classic rock 1
- classic rock song 1
- club 1
- cult classic 1
- cymbal crashes 1
- cymbals crashing 1
- disco music 1
- disco romance hits 1
- distorted vocals 1
- eerie 1
- electric guitar lead 1
- energetic 1
- falsetto 1
- goth rap 1
- groovy rhythm 1
- guitar rhythm 1
- haunting 1
- hissing noise 1
- iconic solo 1
- inspiring 1
- instrumental music 1
- keybiard accompaniment 1
- keyboard harmony 1
- live performance 1
- love song 1
- love songs 1
- male backup singer 1
- male rapper 1
- male singer 1
- marry me 1
- melancholic 1
- missing you 1
- modern pop songs 1
- motivational 1
- new age 1
- nostalgia 1
- old classics 1
- poor audio quality 1
- pop cover 1
- pop songs 1
- rap song 1
- realisation 1
- retro pop song 1
- rock anthem 1
- rock super-hits 1
- romantic song 1
- sad song 1
- sadness 1
- sentimental 1
- serious 1
- slowing down 1
- song covers 1
- song retarding 1
- specials sound effects 1
- spirited 1
- steady drumming 1
- string bass line 1
- string section harmony 1
- strong bass line 1
- synth string section 1
- tambourine percussions 1
- tempo changes 1
- together forever 1
- vibrato 1
- vocal harmony 1
- with you forever 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 5
- Bell 1
- Christian music 1
- Keyboard (musical) 1
- Musical instrument 1
- Rapping 1
- Singing 1
- Soul music 1
- Swing music 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 |
---|---|---|---|---|---|---|---|---|---|---|
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 | |
Jak Progresso - Yip Wreck | A male rapper sings this rap medley with a backup singer in vocal harmony. The song is medium tempo with a boomy bass line, synth string section and piano accompaniment. The song is storytelling and haunting in its style. The song is a retro rap song with poor audio quality. | 2010-02-18T12:01:56Z | Ih8thePolice | Track 9 of Pestilence | ["Music", "Rapping"] | ["bad audio quality", "male rapper", "story telling", "emotional", "male backup singer", "piano accompaniment", "medium tempo", "eerie", "haunting", "serious", "steady drumming rhythm", "boomy bass line", "keyboard harmony", "aggressive", "rap song", "goth rap", "synth string section"] | 1 | TrvI6t4pAP0 | 2870 | |
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 | |
Matthew Perryman Jones - Save you lyrics | A male singer sings this poignant love song. The song is medium tempo with a steady drumming rhythm, strong bass line, keyboard accompaniment, guitar accompaniment and percussion hits. The song is emotional and romantic. The song audio quality is bad. | 2010-08-30T19:02:00Z | dionyts91 | Matthew Perryman Jones' official website: http://mpjmusic.com this is one of the KYLE XY 's, ONE TREE HILL 's , PRETTY LITTLE LIARS' soundtracks !! i love it!! I M SORRY FOR POSSIBLE MISTAKES ON THE LYRICS!! i don't own any rights! | ["Christian music", "Music"] | ["male singer", "classic rock", "pop song", "bad audio quality", "medium tempo", "string bass line", "guitar accompaniment", "piano accompaniment", "keybiard accompaniment", "steady drumming rhythm", "emotional", "passionate", "groovy rhythm", "new age", "romantic song", "sadness", "realisation", "modern pop songs", "love songs"] | 1 | Jq2w30NYstQ | 2037 | |
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
Rock Band 3 - Bohemian Rhapsody [Splitscreen] [100% FC Expert Pro Keys] | The song is an instrumental. The song is medium tempo and tempo changes occur later, with piano accompaniment, guitar solo, chord changes, steady drumming rhythm, rhythm guitar, and strong bass line . The song is an iconic rock hit and has a bad audio quality. | 2011-07-07T00:24:37Z | RockerSVK | Bohemian Rhapsody - Queen XBL Gamertag: RockerSVK My friend lent me a camera so I could finally record my hands playing pro keys as many of you requested that. I ReFCd Bohemian Rhapsody just to show you my hands, I also made it one handed just for you. I even improved my best score :) Also notice this is my first splitscreen video ever so I hope you like it :D Btw I recorded my hands playing 2 other songs I already FCd (you can guess which ones) so stay tuned :) I had to change a pitch of audio track half a semitone up otherwise the video will be blocked in some countries. Sorry for that. | ["Swing music", "Musical instrument", "Keyboard (musical)"] | ["electric guitar lead", "chord changes", "specials sound effects", "groovy bass line", "piano accompaniment", "classic rock song", "instrumental music", "cymbal crashes", "piano accompaniment", "emotional", "sentimental", "rock super-hits", "passionate", "spirited", "cult classic", "bad audio quality", "passionate", "energetic", "youthful", "iconic solo", "rock anthem", "tempo changes", "medium tempo"] | 1 | LR3U4b_fVBc | 2186 |
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;