musiccaps_details (view)
4 rows where "youtube_published" is on date 2007-09-16 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- burping 1
- chaotic 1
- digital drums 1
- disorderly 1
- distortion guitar 1
- electronic drums 1
- fast tempo 1
- female vocal 1
- groovy bass 1
- guitar solo 1
- jazz 1
- jingle 1
- keyboard 1
- low quality amateur recording 1
- male voice 1
- mashup 1
- mellow 1
- no other instruments 1
- pad 1
- passionate 1
- psy trance 1
- random 1
- saxophone solo melody 1
- shimmering bells melody 1
- shimmering hi hats 1
- soft 1
- soulful 1
- speed picking 1
- string bending 1
- synth arpeggios 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Psy trance | This audio contains a digital drum playing a four on the flor groove with a kick on every beat and building up kicks to doubletime and triplets. Synth bass sounds and synth sounds in the midrange are playing arpeggiated melodies. This song may be playing with headphones while playing video-games. | 2007-09-16T07:20:51Z | Italo Lopes | Oxys - Zumbination : www.oxys.palcomp3.com.br Visitem nossa comunidade no orkut : http://www.orkut.com.br/Main#Community.aspx?cmm=76612689 | ["Electronic music", "Music", "Techno", "Trance music"] | ["psy trance", "digital drums", "synth arpeggios", "fast tempo"] | 6 | I_kUf7vgVNM | 1919 | |
whitesnake crying in the rain - my solo | This low quality amateur recording features a guitar solo being played on a distortion guitar. The solo is played up the neck on the higher register. The guitarist plays with very fast picking techniques. This song starts off with string bending which is followed by fast picking on descending licks. | 2007-09-16T15:27:54Z | Damcka | me going nuts with a whitesnake solo by john sykes. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["low quality amateur recording", "guitar solo", "string bending", "distortion guitar", "speed picking", "no other instruments"] | 0 | 1FnA3w94zXI | 250 | |
Blessed Relief - Frank Zappa | The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. | 2007-09-16T15:33:59Z | zemoraes000 | A Tribute to Frank Zappa - Blessed Relief, one of the best songs composed by him. I took the video from "trance fusion - Chunga's Revenge" (author unknown). Awsome!!! see also: http://br.youtube.com/watch?v=smSfnpCZMeI hehehe | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] | 4 | sSavMIH-e-w | 4951 | |
cacophony - MTV | This is the opening jingle of a TV show that is in the style of a mashup. There is a male voice speaking and then burping. There is a melodic pad playing at random occasions. A female vocalist can be heard singing with a keyboard melody and an electronic drum beat very briefly. Then the male voice and the pad returns. There is a chaotic atmosphere. Separate samples from this piece could be used in both beat-making and DJ sets/remixes. | 2007-09-16T17:13:27Z | newmediaclass | by shahar shamay... hi :-) | ["Music", "Cacophony"] | ["mashup", "jingle", "pad", "male voice", "burping", "female vocal", "keyboard", "electronic drums", "chaotic", "disorderly", "random"] | 9 | KDzy3ZL626U | 2068 |
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;