musiccaps_details (view)
3 rows where "youtube_published" is on date 2012-08-10 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 2
- aggressive 1
- amateur recording 1
- arpeggiated harp 1
- beatbox 1
- calming 1
- cheering 1
- crowd clapping 1
- distorted static sound 1
- distorted wide electric guitars 1
- energetic 1
- energetic cymbals 1
- groovy bass 1
- low sustained strings 1
- manic 1
- mellow 1
- mellow flute melody 1
- metal 1
- mystical 1
- noisy 1
- orchestra 1
- punchy kick 1
- punchy snare 1
- repetitive piano melody 1
- screaming female vocal 1
- strings melody 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Beatboxing 1
- Classical music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Timeline of Human Evolution | The low quality recording features an orchestra playing arpeggiated harp melody, low sustained strings and mellow flute melody. It sounds mystical, mellow and calming. The recording is a bit noisy too. | 2012-08-10T02:06:10Z | MIS | This is inspired by CeeSee7's video :http://youtu.be/zohMSNpW91k Footage from Animal Armageddon (Animal Planet) http://en.wikipedia.org/wiki/Animal_Armageddon Walking with Monsters Discovering Ardi - Bringing Ardi Back (Animal Planet) Secrets of the Dead (PBS) http://en.wikipedia.org/wiki/Secrets_of_the_Dead The Ape That Took Over The World (BBC) Ape to Man (History Channel) Coca-Cola Commercial : First time http://youtu.be/JU9K_6Dxhsw Soundtrack from Jurassic Park :Theme from Jurassic Park by John Williams. http://en.wikipedia.org/wiki/Jurassic_Park_%28film_score%29 | ["Music", "Classical music"] | ["low quality", "noisy", "low sustained strings", "arpeggiated harp", "mellow flute melody", "orchestra", "calming", "mystical", "mellow"] | 4 | hSSzn4bIwZg | 4106 | |
Billy Beatbox (Musik Mulut) performance @Final FPS Gerejawi 6 HKBP Pasar Rebo | Someone is beatboxing a reggaeton beat. In the background you can hear the crowd clapping and cheering. This song may be playing live as part of a beatbox performance. | 2012-08-10T06:15:57Z | Patar Marlon Siregar | Billy Beatbox (Willem Carolus Christopherson) Nusa Indah Theater-Balai Kartini 20 Agustus 2011 FPS Gerejawi 6 Organized by : Cherubim Male Choir, Abigail Voice & Naposo HKBP Pasar Rebo - One Love One Spirit One Hope "Then Sing My Soul My Greatest God to Thee" | ["Beatboxing", "Vocal music"] | ["amateur recording", "beatbox", "crowd clapping", "cheering", "uptempo"] | 6 | HMQfp_qtF-M | 1795 | |
Nightcore Fight Inside | The low quality recording features a metal song that consists of a screaming female vocal singing over punchy kick and snare hits, energetic cymbals, groovy bass guitar, wide distorted electric guitars, strings melody and repetitive piano melody. At the very end of the loop, there is a short distorted static sound. It sounds energetic, aggressive and manic. | 2012-08-10T08:11:02Z | Tobias Fritz Holm | Like and Subscribe. picture: http://i1.ytimg.com/vi/BscoQHJrNm8/maxresdefault.jpg | ["Music", "Angry music"] | ["low quality", "metal", "screaming female vocal", "punchy snare", "energetic cymbals", "punchy kick", "repetitive piano melody", "distorted wide electric guitars", "groovy bass", "strings melody", "energetic", "aggressive", "manic", "distorted static sound"] | 4 | BscoQHJrNm8 | 1300 |
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;