musiccaps_details (view)
2 rows where musiccaps_author = 4, musiccaps_names contains "Musical instrument" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- low quality 2
- mono 2
- addictive 1
- addictive staccato violin melody 1
- boomy bass 1
- claps 1
- dj scratching sound effect 1
- dj scratching sound effects 1
- electro 1
- energetic 1
- flat male vocal 1
- haunting female vocals melody 1
- hip hop 1
- noisy 1
- offbeat shimmering hi hats 1
- punchy "4 on the floor" kick pattern 1
- punchy snare 1
- short snare hit 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
violon vs scratch | The low quality recording features a hip hop song that contains boomy bass, punchy snare layered with claps, DJ scratching sound effects, addictive staccato violin melody and haunting female vocals melody in the background. The recording is in mono and it sounds energetic and addictive, regardless of the quality of the recording. | 2008-02-16T03:18:15Z | Finnels Workshop | c trop mortel style hip hop associé au style celtik ca donne un mix kje kiffe a mort | ["Scratching (performance technique)", "Music", "Musical instrument", "Scratch", "Violin, fiddle"] | ["low quality", "mono", "hip hop", "boomy bass", "punchy snare", "claps", "dj scratching sound effects", "addictive staccato violin melody", "haunting female vocals melody", "energetic", "addictive"] | 4 | A_oaLt-n4fQ | 1137 | |
【石橋楽器店】初心者のためのDJ How to Setup! | The low quality recording features a flat male vocal talking over an electro song that consists of a punchy "4 on the floor" kick pattern, short snare hit and offbeat shimmering hi hats. In the second part of the loop, the electro song is being scratched by a DJ. The recording is noisy and in mono. | 2008-01-25T05:00:44Z | 1484tv イシバシ楽器公式 | <DJを始めてみたいけど「何か難しそうだな‥‥」と思っているアナタ!そんな事はありません!> このムービーでは、ターンテーブルの定番「Technics / SL-1200MK5」と、DJミキサーの定番「Technics / SH-EX1200」の基本的な特徴から、カートリッジの選び方やカートリッジの取り付け方法、さらには針飛び時の対処法まで伝授いたします。もちろんシステムのセットアップと接続方法も判りやすくご紹介しております。 https://www.ishibashi.co.jp/ | ["Scratching (performance technique)", "Music", "Musical instrument", "Speech"] | ["flat male vocal", "dj scratching sound effect", "electro", "punchy \"4 on the floor\" kick pattern", "short snare hit", "offbeat shimmering hi hats", "low quality", "noisy", "mono"] | 4 | pnh_C1w4yGc | 4735 |
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;