musiccaps_details (view)
4 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "no singer" and musiccaps_aspects contains "repeated theme"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- electronic drums · 4 ✖
- no singer · 4 ✖
- repeated theme · 4 ✖
- instrumental 3
- synth 3
- aggressive 2
- electronic music 2
- airy 1
- ambient house 1
- bass 1
- car sounds 1
- cover 1
- danceable 1
- electric guitar sound 1
- energetic 1
- engine 1
- exhaust 1
- guitar solo 1
- industrial sounding 1
- instructive recording 1
- j-pop 1
- keyboard 1
- percussive elements 1
- resonating 1
- reverberating 1
- russian hardbass 1
- scissor sharpener 1
- sound effects 1
- synth bass 1
- techno 1
musiccaps_names (array) 11 ✖
- Music 3
- Dubstep 2
- Ambient music 1
- Clatter 1
- Drum and bass 1
- Electric piano 1
- Keyboard (musical) 1
- New-age music 1
- Piano 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Car Wash Equipment: High Pressure Water Cleaners | This is an ambient house music piece. There is no singer in the music. There are various resonating synth sounds used with ambient sound effects. Electronic drum hits can be heard reverberating in the piece. The atmosphere is airy. The best use for this piece would be either as an advertisement jingle or as a background music for a tutorial/instructive video. | 2011-06-24T03:27:58Z | NewEdgeCorp | These high pressure cleaners that use water allow easy cleaning of cars and trucks. Distribution in Malaysia: sales@newedgecorp.com | ["New-age music", "Music", "Ambient music"] | ["electronic music", "ambient house", "no singer", "instrumental", "synth", "repeated theme", "electronic drums", "percussive elements", "sound effects", "airy", "resonating", "reverberating"] | 9 | ABSLnckbB8w | 1079 | |
Kis-My-Ft2 - SHE!HER!HER! 弾いてみた! | This is an instrumental cover of a J-pop music piece. There is no singer in this piece. The melodic background consists of the keyboard and the bass playing a repeated theme. There is a synth solo with an electric guitar sound being played as the lead. In the rhythmic background, there is a fast tempo electronic drum beat. The atmosphere is danceable and energetic. This piece can be used in the soundtrack of a car racing video game. It could also be used in the soundtrack of an anime during competitive scenes. | 2012-02-15T09:13:54Z | るるる | 3月21日発売キスマイの3rdシングルを弾いてみました。 チャンネル移転しました。今後はこちらで投稿していきます。 https://www.youtube.com/channel/UCEvafWR0r3HI3jgxGBjquwg?feature=watch たくさんのコメントありがとうございます。 一部のコメントや質問に関しまして、ドラムやベースからすべて私の打ち込みです。CDなしで弾いてくださいというコメントがありますが発売前ですし動画内でCDは一切使用しておりません。 ドラム含めて私自身の演奏ですのでご理解ください。 | ["Electric piano", "Keyboard (musical)", "Piano"] | ["j-pop", "cover", "no singer", "instrumental", "electric guitar sound", "guitar solo", "keyboard", "synth", "bass", "electronic drums", "repeated theme", "danceable", "energetic"] | 9 | Sa3Ky5sJshU | 2777 | |
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 | |
Buddy Club Pro Spec Exhaust Sound Video | This is a techno music piece played in the background of a car video. The sounds coming from the car such as the exhaust sound can be heard in the video. The electronic music piece consists of a crisp synth sound playing a repeated theme while there is an electronic drum beat in the rhythmic background. There is an aggressive atmosphere in the piece. Samples lifted from the track could be used in the soundtrack of a car racing video game. | 2007-04-12T05:13:47Z | Niecewonje | My Buddy Club Pro Spec Exhaust sound video on a 2002 Honda Civic Ex. | ["Music", "Clatter", "Dubstep"] | ["electronic music", "techno", "no singer", "instrumental", "synth", "repeated theme", "electronic drums", "car sounds", "engine", "exhaust", "aggressive"] | 9 | yCGM8aJV6fM | 5393 |
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;