musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-04-25
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- azerbaijani folk music 1
- bass 1
- blues song 1
- club music 1
- dance groove 1
- dance hits 1
- dance pop 1
- elec 1
- electro pop 1
- electronic music 1
- electronic pop 1
- fast tempo 1
- female singer 1
- funky bass line 1
- garmon 1
- happy mood 1
- instrumental 1
- keyboard harmony 1
- lively 1
- low quality audio 1
- male voice 1
- moderate tempo 1
- overdriven guitar 1
- paino accompaniment 1
- percussion 1
- pop 1
- punchy drumming 1
- rock song 1
- simple melody 1
- single instrument 1
- synth pop 1
- synthesiser articulation 1
- teen pop 1
- vibrant 1
- violin harmony 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Accordion 1
- Disco 1
- Musical instrument 1
- Ska 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sesame Street - ZZ Blues | This blues song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat in common time. An overdriven guitar plays a blues riff. After one bar, the guitar and bass pause while the percussion and voice continues. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a bar scene in a movie. | 2008-04-25T05:25:53Z | mstatz | A group that looks much like ZZ Top sings about the letter Z in ZZ Blues! A bluesy kind of song and another great lesson for kids. Big Bird makes an appearance before the video begins here. | ["Music", "Ska"] | ["rock song", "blues song", "male voice", "low quality audio", "overdriven guitar", "percussion", "bass", "happy mood", "moderate tempo"] | 0 | aLnBwjLUZao | 3530 | |
Vagif Bagirov "Segah" | This is an Azerbaijani folk music piece. It is an instrumental piece. The only instrument being played is a garmon which has a sound that resembles an accordion. There is a lively atmosphere in the recording. This piece can be played in the soundtrack of a documentary that takes place in the Caucasus region. It could also be used in the soundtrack of an Azerbaijani soap opera. | 2008-04-25T07:36:13Z | Hal Karim | This video was taking by me, Vagif Bagirov one of the proffesional Garmon Maker and he can also play Garmon. | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["azerbaijani folk music", "instrumental", "single instrument", "garmon", "lively", "vibrant"] | 9 | tv14XEQcY0c | 5076 | |
Cathy Dennis - Just Another Dream (HQ) | A female vocalist sings this pop song. The tempo is fast with a lively piano accompaniment, funky bass lines, violin harmony, synthesiser and electronic arrangements and punchy drumming. The song is youthful, romantic, warm, simple and groovy. This song is an Electro Pop/ Dance pop. | 2008-04-25T02:57:59Z | quad442 | First aired in July 1991. Directed by Greg Masuak. Cathy is 22 years old in this video. Cathy's eye shadow changes color in this video. Purple when wearing the orange top, and green when wearing the pink top. Thanks to Universal Music Group for allowing this video to be posted. This is by far the most popular of the eight videos posted from Move To This "The Videos" laserdisc. Here is a link that will play the complete collection in the original order. http://www.youtube.com/watch?v=pT0mBQSrtT4&feature=PlayList&p=6FFCFC907BCF5E7B&index=0&playnext=1 | ["Disco"] | ["female singer", "fast tempo", "electronic music", "youthful", "club music", "dance hits", "dance groove", "simple melody", "funky bass line", "punchy drumming", "paino accompaniment", "violin harmony", "synthesiser articulation", "keyboard harmony", "dance pop", "pop", "synth pop", "teen pop", "electronic pop", "electro pop", "elec"] | 7 | ymOjaaxRDLU | 5438 |
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;