musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy" and musiccaps_aspects contains "synth pad chords"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 3
- noisy · 3 ✖
- synth pad chords · 3 ✖
- aggressive male vocal 1
- arpeggiated synth melody 1
- detuned 1
- glitchy 1
- groovy thin bass 1
- intense 1
- mellow 1
- mellow percussions 1
- mellow sustained female vocals 1
- mono 1
- relaxing 1
- reverberant percussions 1
- soft 1
- suspenseful 1
- sustained synth strings melody 1
- unbalanced stereo 1
- video game song 1
musiccaps_names (array) 5 ✖
- Music 3
- Happy music 1
- New-age music 1
- Scary music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
C418 - Chirp (Minecraft Song) | The low quality recording features an old video game song that consists of sustained synth strings melody, mellow percussions, groovy, thin bass and synth pad chords. The recording is very noisy and the stereo image is unbalanced as it is leaning towards the left channel. It sounds a bit glitchy and slightly detuned too. | 2011-10-29T18:30:30Z | stuntman9472 | Song made by C418: http://www.c418.org Minecraft made by Notch: http://www.minecraft.net Picture: http://PurpleKakashi.deviantart.com/art/The-Chicken-211411980 This is one of the 9 new songs released in the 1.9 update. | ["New-age music", "Music"] | ["low quality", "noisy", "unbalanced stereo", "detuned", "glitchy", "sustained synth strings melody", "mellow percussions", "groovy thin bass", "synth pad chords", "video game song"] | 4 | FE2kALvHjEU | 1626 | |
Donkey Kong Country Piano Water Theme Music | The low quality recording features an arpeggiated synth melody, followed by synth pad chords. It sounds mellow, soft and relaxing, while the recording is noisy. | 2007-10-17T11:35:19Z | jcondkc | Water theme from DKC. (abridged) | ["Music", "Happy music"] | ["low quality", "noisy", "arpeggiated synth melody", "synth pad chords", "mellow", "soft", "relaxing"] | 4 | PQXYWc3JHhU | 2534 | |
Brad gets mad then does Math | The low quality recording features an aggressive male vocal talking over synth pad chords, sustained, mellow female vocals and reverberant percussion. It sounds suspenseful and intense. The recording is noisy and in mono. | 2008-12-12T10:47:35Z | 4Player Network | Watch live video and more clips from 4PlayerPodcast on http://www.justin.tv/fourplayerpodcast | ["Music", "Speech", "Scary music"] | ["low quality", "aggressive male vocal", "synth pad chords", "mellow sustained female vocals", "suspenseful", "intense", "noisy", "mono", "reverberant percussions"] | 4 | S9-i_pqoUCw | 2745 |
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;