musiccaps_details (view)
2 rows where "youtube_published" is on date 2009-02-27 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
musiccaps_names (array) 4 ✖
- Music 2
- Funk 1
- Inside, large room or hall 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988) | The rock music features a screaming male voice singing a melody. One of the electric guitars accompanies the singer with strummed chords while the other, for the second part of the music excerpt, plays a melody. Both guitars have a distortion effect on. The drums play a well grounded rhythm and together with the bass guitar drive the pulse of the music. The quality of the audio recording is not that good, most probably this is an old live recording. | 2009-02-27T12:49:06Z | Christo Toupa | Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988). | ["Music", "Yell", "Inside, large room or hall"] | ["low quality audio recording", "rock genre", "screaming male voice", "electric guitars", "distortion effect", "drums", "bass guitar", "live recording"] | 2 | qie2k2gZ7wA | 4809 | |
Lily Allen - Alfie | This song would be classified as bubblegum pop. The music is more suitable for children, as it has a young and light-hearted style of production. There's a bright and tinny synth which is used to play a repeated motif, and at one point we hear a pair of birds mimicking the melody in their squeaky bird-like tones. | 2009-02-27T19:39:47Z | Parlophone Records | Lily Allen's brand new track "Hard Out Here" is available to download on iTunes now here: http://smarturl.it/HardOutHere?IQid=vevoyt Watch the video here: http://smarturl.it/HardOutHereVideo?IQid=vevoyt Also out now is "Somewhere Only We Know" as featured in the TV Advert here! http://smarturl.it/lilysowk?IQid=vevoyt Follow Lily online: http://www.lilyallenmusic.com https://twitter.com/LilyAllen https://www.facebook.com/lilyallen http://instagram.com/lilyallen http://lilyallenmusic.tumblr.com https://plus.google.com/+lilyallen | ["Funk", "Music"] | ["cheerful", "happy", "pop", "light-hearted", "bubblegum pop", "bright tinny synth melody", "bird chirping melody", "dance", "fun", "simple youthful pop drum beat"] | 3 | Sr2Grfi3lFg | 2791 |
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;