musiccaps_details (view)
2 rows where musiccaps_names contains "Drum machine", musiccaps_names contains "Electronica" and musiccaps_names contains "Synthesizer"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roland Aira TR8 - 808 Day 8th August 2017 | The low quality recording features a reverberant instrumental that consists of punchy kick hits, claps, shimmering hi hats, bouncy and tinny percussive elements. There are wide echoing effects at one point of the loop. Sounds energetic and groovy, like something you would hear in underground clubs. | 2015-08-04T19:57:58Z | Carl Nilsson | Famous TR808 beats to celebrate the 8/08 day programmed on the TR8. The last minutes is an improvising jam session. | ["Sampler", "Music", "Musical instrument", "Drum machine", "Synthesizer", "Electronica"] | ["low quality", "reverberant", "instrumental", "clapping", "punchy kick", "shimmering hi hats", "tinny percussive elements", "wide echoing effects", "groovy", "energetic"] | 4 | DLJGT99uEh4 | 1466 | |
Make your own dubstep beats fast and easy - Try the software today | This is a simple dubstep piece. Electronic drums and percussion are played at the rhythmic background at 120 BPM. There is a high-pitched synth and a fuzzy synth bass playing a simple melody. The all-around quality of the sounds are a bit old-fashioned, reminiscing of the early 2000s. The piece has a danceable, trippy feel to it. It could be used in a retro-themed venue. | 2013-12-30T09:53:19Z | Nanette Arenivas | http://tinyurl.com/lruc8hy Make your own dubstep beats fast and easy - Try the software today Today audio fidelity and clarity is more important than ever before, since just about everybody has speakers or a set of headphones with which the difference is clearly noticeable. Artists can't get away with settling for whatever is "good enough" anymore, because the only thing good enough now is the absolute best. | ["Music", "Techno", "Dubstep", "Drum machine", "Synthesizer", "Electronica"] | ["dubstep", "electronic drums", "electronic percussion", "synth bass", "sound effects", "high-pitched synth", "lo-res", "mid-tempo", "trippy", "fuzzy", "dance"] | 9 | SkIDF7iNJQE | 2785 |
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;