musiccaps_details (view)
1 row where musiccaps_aspects contains "dance", musiccaps_aspects contains "electronic percussion", musiccaps_aspects contains "lo-res" and musiccaps_names contains "Dubstep"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;