musiccaps_details (view)
2 rows where musiccaps_author = 9 and "youtube_published" is on date 2011-10-21
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- ambient synth 1
- clarinet 1
- comedy 1
- dance 1
- dramatic 1
- energetic 1
- female voice 1
- goofy tune 1
- hardcore 1
- high-pitched 1
- instrumental 1
- loud electronic drums 1
- melodic singing 1
- rave 1
- sound effects 1
- strings 1
- synth 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Break You - Yade | This is a hardcore rave music piece. There is a female vocalist singing melodically. The high-pitched synth is playing the main theme while an ambient synth with medium-pitched characteristics is playing in the background. A very loud and fast-paced electronic drum beat carries the rhythmic background. The atmosphere is very energetic. This piece could be used in an anime or a video game. It could also be used in DJ sets at rave venues. | 2011-10-21T17:27:56Z | Desuvi Music | Break You - Yade • Independent Artist Release • Free Download: http://soundcloud.com/yadedhardcore/01-yade-break-you-dj-promo-320 Yade: Listen: https://soundcloud.com/yadedhardcore Like: https://www.facebook.com/YadeHardcore Wanna hear more hardcore rave music? Subscribe! http://goo.gl/LKgneE • jordesuvi Tweet: http://www.twitter.com/jor_desu Tumblr: http://jordesu.tumblr.com/ Google+: http://www.google.com/+jordesuvi Producers submit your song to be promoted on jordesuvi here! http://full.sc/12sr1i7 | ["Music", "Zing"] | ["hardcore", "rave", "synth", "female voice", "melodic singing", "ambient synth", "loud electronic drums", "sound effects", "high-pitched", "energetic", "dance"] | 9 | JvvnL7UnCGA | 2046 | |
Ranma 1/2 Live Action Cast | This is an instrument comedy music piece. There is a clarinet playing a goofy tune. Then, the clarinet stops and the strings section starts playing a dramatic melody. This piece could be sampled to be used as instrumentals in an advertisement jingle. | 2011-10-21T00:40:13Z | Rumic World | The cast of the new Ranma 1/2 special in full costume. The special will air on December 9, 2011 at 7:00pm on NTV. Kento Kaku (male Ranma) Natsuna Wantanabe (female Ranma) Yui Aragaki (Akane) Kyoko Hasegawa (Kasumi) Shosuke Tanihara (Dr. Tofu) Maki Nishiyama (Nabiki) Kento Nagayama (Tatewaki Kuno) Yuta Kanai (Hikaru Gosunkugi) Arata Furuta (Genma) Katsuhisa Namase (Soun) Ryousei Tayama (Okamada) The song is "Lychee & Jasmine" from the Movie 1 OST. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["comedy", "instrumental", "clarinet", "goofy tune", "strings", "dramatic"] | 9 | fvTh5m9RHZw | 3988 |
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;