musiccaps_details (view)
2 rows where musiccaps_aspects contains "noisy" and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- noisy · 2 ✖
- dark 1
- detuned 1
- echoing dark rimshot 1
- fade in 1
- flat female vocal 1
- glitchy 1
- groovy piano melody 1
- groovy thin bass 1
- mellow 1
- mellow percussions 1
- punchy kick 1
- soft reverberant female vocal 1
- sustained synth strings melody 1
- synth pad chords 1
- unbalanced stereo 1
- video game song 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 | |
Megan Fox Glamor Makeup Tutorial | The low quality recording features a flat female vocal shortly talking on a very noisy microphone, after which a song fades in. The song consists of soft, reverberant female vocal singing over echoing dark rimshots, punchy kick and groovy piano melody. Overall it has a dark and mellow vibe to it. | 2011-12-28T01:54:27Z | Julia Graf | My Website ⇒ http://hellojuliagraf.com/ ► SOCIAL MEDIA SNAPCHAT ⇒ https://www.snapchat.com/add/julia_graf INSTAGRAM ⇒ https://www.instagram.com/hellojuliagraf/ FACEBOOK ⇒ http://www.facebook.com/hellojuliagraf TWITTER ⇒ http://twitter.com/hellojuliagraf | ["New-age music"] | ["low quality", "fade in", "soft reverberant female vocal", "noisy", "flat female vocal", "echoing dark rimshot", "punchy kick", "groovy piano melody", "dark", "mellow"] | 4 | LAxCq-s84F8 | 2159 |
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;