musiccaps_details (view)
2 rows where musiccaps_aspects contains "muddy" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 2
- muddy · 2 ✖
- punchy snare 2
- 4 on the floor kick 1
- dj scratching 1
- dj scratching sound effect 1
- electro 1
- energetic 1
- energetic crash 1
- flat male vocal 1
- groovy bass 1
- hip hop 1
- messy 1
- mono 1
- muffled 1
- noisy 1
- punchy kick 1
- shimmering hi hats 1
- sustained filter mod bass 1
- synth keys melody 1
musiccaps_names (array) 6 ✖
- Music 2
- Scratching (performance technique) · 2 ✖
- Drum machine 1
- Sampler 1
- Scratch 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bad Boy Bill - BTD - Scratching | The low quality recording features a DJ scratching his vinyl record of an electro song that consists of flat male vocals talking over "4 on the floor" kick, synth keys melody, groovy bass, shimmering hi hats, energetic crash cymbals and punchy snare hits. It sounds muddy and messy, since the frequencies are clashing and since it is probably recorded with a phone. | 2007-10-03T01:01:58Z | djoslo | Bad Boy Bill - BTD - Scratching | ["Scratching (performance technique)", "Music"] | ["low quality", "dj scratching sound effect", "electro", "flat male vocal", "groovy bass", "synth keys melody", "4 on the floor kick", "energetic", "punchy snare", "shimmering hi hats", "energetic crash", "muddy", "messy"] | 4 | 9NJEKpPeWpE | 1000 | |
scratch session d'astro | The low quality recording features a DJ scratching the vinyl of a hip hop instrumental that consists of punchy kick and snare hits and sustained filter modulated bass. The recording is muffled, noisy, mono and muddy, as it was probably recorded with a phone. | 2006-11-30T11:34:41Z | Jerome GARCIA | petite session scratch... | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Drum machine", "Synthesizer"] | ["low quality", "dj scratching", "hip hop", "sustained filter mod bass", "punchy kick", "punchy snare", "muffled", "noisy", "mono", "muddy"] | 4 | zNgRUFOj3HI | 5470 |
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;