musiccaps_details (view)
3 rows where musiccaps_aspects contains "synth bass", musiccaps_author = 9 and musiccaps_names contains "Techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- electronic drums 3
- synth bass · 3 ✖
- dance 2
- repeated theme 2
- aggressive 1
- dubstep 1
- electronic percussion 1
- erotic 1
- female vocal sample 1
- french electronic pop 1
- fuzzy 1
- high-pitched synth 1
- industrial sounding 1
- instructive recording 1
- lo-res 1
- male vocal 1
- melodic pad 1
- mid-tempo 1
- no singer 1
- russian hardbass 1
- scissor sharpener 1
- sensual 1
- sound effects 1
- trippy 1
musiccaps_names (array) 12 ✖
- Music 3
- Techno · 3 ✖
- Dubstep 2
- Trance music 2
- Dance music 1
- Disco 1
- Drum and bass 1
- Drum machine 1
- Electronic dance music 1
- Electronica 1
- House music 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CHEWING GUM FRAISE | This is a French electronic pop music piece. There is a male vocalist singing in the lead. A melodic pad is playing a repeated theme while a fuzzy synth bass is playing a loud bass line. There is an electronic drum beat in the rhythmic background. The atmosphere is sensual and erotic. This piece could be playing in the background at a nightclub or a dance club in France. | 2007-06-07T02:51:32Z | LTparody | lui c le moin bon surment yai vedge mes ces 1 de plus et ces special :O | ["Disco", "House music", "Music", "Techno", "Trance music", "Electronic dance music", "Dance music"] | ["french electronic pop", "male vocal", "melodic pad", "repeated theme", "synth bass", "electronic drums", "female vocal sample", "sensual", "erotic", "dance"] | 9 | 7yK4-hsVX1o | 893 | |
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 | |
1. Кутикульные ножницы. Предварительная обработка | This is a Russian hardbass piece played in the background of a scissor sharpening video. The piece has a repeated theme being played by a synth bass while an electronic drum beat holds the rhythmic background. The atmosphere of the piece in the background is aggressive with industrial characteristics. | 2012-02-01T19:18:10Z | Виталий Бородин | Перед тем, как затачивать ножницы для кутикулы, их нужно подготовить - придать нужную форму полотнам. Этому и посвящено видео. | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["instructive recording", "scissor sharpener", "no singer", "russian hardbass", "synth bass", "electronic drums", "repeated theme", "aggressive", "industrial sounding"] | 9 | dIPW9gLGSx8 | 3774 |
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;