musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2012-08-10
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- low quality 2
- aggressive 1
- arpeggiated harp 1
- calming 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
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Classical music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;