musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "repeated theme"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mona Lisa "Angel" (Max Sound HD Audio Version) Official Music Video | This is a pop music piece. There is a female vocalist singing melodically at the forefront with muffled repetitions of the same voice in the back. The simple and repeated theme is being played by a piano while the rhythmic background consists of an electronic drum beat with loud kick beats. There is a melancholic aura to this piece and a sense of resentment. This piece could be used in the soundtrack of a drama movie. | 2011-08-03T18:10:14Z | MonaLisaMusicVideos | Now on iTunes!***** "Angel" now on itunes: http://itunes.apple.com/us/album/angel-single/id464099477?uo=4 | ["Music", "Sad music", "Tender music", "Exciting music"] | ["pop music", "modern r&b", "female vocal", "melodic singing", "piano", "repeated theme", "electronic drums", "groovy", "melancholic", "resentment"] | 9 | bVc7-sZAi6s | 3630 | |
BENNY ED - Beny Ed Series: "IT'S TODAY" (Ep. 4) | This is an alternative rock music piece. There is a male vocalist singing melodically. The electric guitar is playing a simple and catchy tune while the bass guitar plays a groovy bass line in the background. The rhythm is provided by an acoustic drum beat. This piece could be used in the soundtrack of a teenage drama or a high school TV series. | 2012-03-14T21:42:55Z | Benny Ed | IT'S TODAY: Alternative Rock from Beny Ed Series, Episode 4 Beny Ed Series Album at http://itunes.apple.com/us/album/beny-ed-series-2012-ep/id534152453 FILMED NEAR CORDOBA, ARGENTINA, 2012 Http://www.ReadyNever.com http://bennyed.com http://facebook.com/bennyed http://twitter.com/_bennyed "IT's TODAY" (LYRICS) I play with fire all alone make it stronger and i promise to come home in a little longer I once wanted to be true now I'm lying if you want I'll give a clue always dying AND WHAT YOU SAY AND WAHT YOU TELL ME ITS TODAY BEFORE WE GO BACK to the start, in your heart, make your mark IT's ToDaY, It'S ToO LaTE, IT DON't HAvE To Be THiS WaY, It's ToO LATE How much longer have you asked theres no answer but if you think about the past circles come and go in the same place look at your face, you're feeling funny, thats ok it's a good day, I'm sure you've got some things to say AND WHAT YOU SAY AND WHAT YOU TELL ME ITS TODAY BEFORE WE GO BACK to the start, in your heart, make your mark IT's ToDaY, It'S ToO LaTE, IT DON't HAvE To Be THiS WaY, It's ToO LATE | ["Music", "Angry music"] | ["alternative rock", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "easygoing", "catchy tune", "repeated theme", "medium tempo"] | 9 | rkQPSAHNoeI | 4898 |
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;