musiccaps_details (view)
3 rows where musiccaps_aspects contains "movie soundtrack" and musiccaps_aspects contains "song cover"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- movie soundtrack · 3 ✖
- song cover · 3 ✖
- bad audio quality 2
- emotional 2
- female singer 2
- slow tempo 2
- acapella band 1
- ambient sounds 1
- beauty 1
- body percussions 1
- cellist 1
- cello 1
- cheering sounds 1
- choral band 1
- classic romance 1
- crowds talk 1
- groovy music 1
- hissing and buzzing distortions 1
- hissing tones 1
- inspiring 1
- keyboard accompaniment 1
- life’s lessons 1
- love song 1
- medium tempo 1
- modern pop covers 1
- modern pop hits 1
- mouth percussions 1
- no percussions 1
- odern pop hits 1
- passionate 1
- piano accompaniment 1
- poignant 1
- pop song 1
- slamming door percussion 1
- sorrowful 1
- spirited 1
- story telling 1
- strong bass line 1
- suspense 1
- technique 1
- together forever 1
- trendy 1
- vibrato 1
- vocal echoes 1
- vocal harmony 1
- western classical music 1
musiccaps_names (array) 6 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Music of Asia 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 |
---|---|---|---|---|---|---|---|---|---|---|
Pitch Perfect - "funny moments" | A female singer leads other backup singers in a vocal harmony. The song is medium tempo with just mouth and body percussion. The song is groovy and played with a lot of ambient crowd noises. The song is a movie soundtrack. | 2013-02-18T17:04:44Z | MAFER TV | Pitch Perfect Is an upcoming 2012 comedy musical film directed by Jason Moore. The screenplay was written by Kay Cannon. Plot The story follows an all-girls a cappella group who rebuild so they can make their way to the championship and take on the boys. This leads to a competition, and new girl Beca is determined to revamp the set-list so that it includes music that's more up-to-date. Cast Anna Kendrick as Beca Brittany Snow as Chloe Rebel Wilson as Fat Amy Anna Camp as Aubrey Christopher Mintz-Plasse as Tommy Skylar Astin as Jesse Freddie Stroma as Luke Adam DeVine as Bumper Alexis Knapp as Stacie Ben Platt as Benji Brock Kelly as Howie Kether Donohue as Alice Ester Dean as Cynthia Rose Hana Mae Lee as Lilly | ["Music of Asia", "Music"] | ["female singer", "acapella band", "ambient sounds", "choral band", "mouth percussions", "body percussions", "crowds talk", "cheering sounds", "movie soundtrack", "vocal harmony", "medium tempo", "groovy music", "song cover", "groovy music", "bad audio quality", "modern pop hits"] | 1 | 4ymXDU-48EE | 620 | |
"My Heart Will Go On" Titanic Theme Cello Cover (Tribute to James Horner) - NDREW | A cellist plays this lilting melody with a piano accompaniment and no other instruments. The music is emotional and tragic. The tempo is slow and has a lot of beauty to it. The song is a cover of a famous love song. | 2015-06-26T04:07:21Z | NDREW | This is my humble rendition to a wonderful man whose music inspired many artists and musicians. R.I.P. James Horner. If you like this then check out my cover of Falling Slowly: https://www.youtube.com/watch?v=KOyzibkm4dw ---------------------------------------------------------------------------------------------------------- Check out my website: http://www.ndrewmusic.com ---------------------------------------------------------------------------------------------------------- iTunes - http://apple.co/2cXx9uu Google Play – https://goo.gl/zgBcwu Amazon - http://amzn.to/2dq2iYq Spotify – https://play.spotify.com/track/3y1vpqQTipKyqnPWHvXK6J Soundcloud – https://soundcloud.com/ndrewmusic/my-heart-will-go-on ----------------------------------------------------------------------------------------------------------- If you'd like you can follow me on: Facebook - https://www.facebook.com/NDREWmusic Twitter - https://twitter.com/NDREWmusic Instagram - https://instagram.com/ndrewmusic/ Snapchat - @NDREWmusic ---------------------------------------------------------------------------------------------------------- I'm also on: iTunes - http://apple.co/2dg5qTt Google Play - https://goo.gl/AEh5sw Amazon - http://amzn.to/2dg4Nck Spotify - https://open.spotify.com/artist/1EhyJoRR3KwBUvm9JZALUS Pandora - http://www.pandora.com/ndrew Soundcloud – https://soundcloud.com/ndrewmusic | ["Cello", "Double bass", "Bowed string instrument"] | ["cello", "cellist", "piano accompaniment", "slow tempo", "movie soundtrack", "vibrato", "technique", "beauty", "trendy", "poignant", "sorrowful", "western classical music", "song cover", "no percussions", "emotional", "love song", "together forever", "classic romance"] | 1 | SlnjJv305Vg | 2788 | |
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 |
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;