musiccaps_details (view)
2 rows where "youtube_published" is on date 2009-12-02 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 9 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Hi-hat 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Wail, moan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tinashe - Mr. Presumption | A digital kick in playing on every beat along with short voice samples with breathy sounds that sound seductive. Then the song changes into someone fingerpicking an acoustic guitar along to someone playing an acoustic snare/hihat with brushes. This first song may be playing in a club and the second one at a live concert. | 2009-12-02T21:26:27Z | boXd productions | as introduced by 4Music's 'Intros' series - but without the annoying and highly pretentious introduction at the beginning ... | ["Cymbal", "Drum", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["techno/singer-songwriter", "acoustic guitar", "digital/acoustic drums", "male voice samples", "seductive", "medium to uptempo"] | 6 | gjujPd1lP8E | 4050 | |
"Wail to God" - Anthony F Schepperd, with new sound design | The clip is a combination of various sound effects. There's a general atmospheric buzz of crowd chatter, and there are various beeping and buzzing sounds in the clip. The clip ends with a loud, slamming thud. | 2009-12-02T08:58:44Z | Hucksley | http://cautioushorses.bandcamp.com The official video for Ape School's tune 'Wail to God', animated by Anthony F Schepperd, except with the sound taken out and replaced with original sound design. Find the original of this video at: http://www.youtube.com/watch?v=lhw0PjvGjGk | ["Music", "Wail, moan"] | ["sound effects", "buzzing sounds", "squeaky sounds", "slapping sounds", "animal sounds", "loud thud", "distant crowd chatter", "futuristic whirring sound"] | 3 | U4MdEIQcZxs | 2885 |
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;