musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "whirring sounds" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- instrumental · 2 ✖
- whirring sounds · 2 ✖
- amateur 1
- animated 1
- beeping 1
- boisterous 1
- busy 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
- gunshots 1
- home recording 1
- home video 1
- loud 1
- muffled audio 1
- noisy 1
- phone ringing 1
- rustling 1
- scratching sound 1
- spirited 1
- synthesiser arrangement 1
- upbeat 1
- video game music 1
- whirring 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;