musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "whirring sounds" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- instrumental · 3 ✖
- whirring sounds · 3 ✖
- amateur 1
- ambient room sounds 1
- animated 1
- background music 1
- beeping 1
- boisterous 1
- busy 1
- button clicks 1
- buzzing 1
- clattering sound 1
- clicking sound 1
- dissonant 1
- door bell ringing 1
- electronic music 1
- elevator bell 1
- energetic 1
- engine sound 1
- enthusiastic 1
- fast tempo 1
- female voice 1
- gunshots 1
- home recording 1
- home video 1
- loud 1
- medium tempo 1
- muffled audio 1
- musical instruments 1
- noisy 1
- offbeat 1
- phone ringing 1
- poor audio quality 1
- pop song 1
- quirky 1
- rustling 1
- scratching sound 1
- spirited 1
- synthesiser arrangement 1
- tooth brush music 1
- upbeat 1
- vibration magic 1
- video game music 1
- weird 1
- whirring 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Music Toothbrush | The song is music created by a toothbrush. The tempo is medium and sounds like a female singer singing in high pitch, motor whirring sounds and button clicks. The audio is poor quality in nature. | 2009-03-13T14:03:47Z | dixter | ["Toothbrush", "Music"] | ["button clicks", "whirring sounds", "background music", "poor audio quality", "weird", "musical instruments", "quirky", "offbeat", "ambient room sounds", "poor audio quality", "female voice", "pop song", "tooth brush music", "weird", "offbeat", "vibration magic", "instrumental", "medium tempo"] | 1 | QYxFWV85-pg | 2626 | ||
Juki DDL 8700 - with servo motor, silent machine | This clip is an instrumental with dissonant sounds like whirring, an engine starting, door bell or elevator bell , clattering and rustling. This is an amateur home recording. | 2010-01-16T10:21:13Z | www.jomaq.com Máquinas de costura | Juki DDL- 8700 lockstitch machine, equipped with servo motor. Very silent machine and cheap machine. Ideal for home use and small business. | ["Music", "Sewing machine"] | ["instrumental", "whirring sounds", "engine sound", "amateur", "home recording", "dissonant", "door bell ringing", "elevator bell", "rustling", "clattering sound"] | 7 | heZw1TTrtTU | 4123 | |
Disney Dancing and Singing Donald Duck (Solo) | This song is an instrumental. The tempo is fast with electronic instrumentation and sounds. There is a vigorous keyboard harmony along with sounds of gunshots, clicking, whirring, beeping, phone ring and scratching. The music is busy, animated and boisterous. The audio quality is inferior and muddled, making it difficult to hear the finer elements. | 2009-02-28T11:39:55Z | xiaohwee85 | 3 x great songs from Daffy 3 x AA battery operated | ["Music", "Synthetic singing"] | ["instrumental", "fast tempo", "loud", "busy", "boisterous", "beeping", "whirring", "noisy", "scratching sound", "video game music", "upbeat", "energetic", "enthusiastic", "electronic music", "clicking sound", "animated", "synthesiser arrangement", "muffled audio", "home video", "whirring sounds", "gunshots", "buzzing", "phone ringing", "spirited", "energetic"] | 7 | XjoRxeEyjz4 | 3217 |
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;