musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Doorbell" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- moderate tempo · 2 ✖
- bass 1
- calling bell 1
- chiming sound 1
- dance music 1
- dj music 1
- drum 1
- drum machine 1
- high pitch melody 1
- male voices 1
- no instruments 1
- no voices 1
- simple melody 1
- wireless doorbell sound 1
musiccaps_names (array) 7 ✖
- Ding-dong 2
- Doorbell · 2 ✖
- Bell 1
- Electronic music 1
- Music 1
- Musical instrument 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HiFaNa Digital Scratch DJ from Japan | This audio clip features a tom roll followed by a descending slide on the bass. This is followed by the sound of two different calling bells one after the other. Four different voices call out numbers one through four in ascending order one after the other. This is followed by a pattern played on a drum machine. This song can be played at a DJ party. | 2007-03-26T06:44:11Z | Richard Poulin III | Japanese Digital Scratch DJ | ["Electronic music", "Doorbell", "Music", "Musical instrument", "Ding-dong", "Speech"] | ["drum", "bass", "calling bell", "drum machine", "male voices", "dj music", "dance music", "moderate tempo"] | 0 | 6iyinlZEgS4 | 779 | |
32 Music Wireless 1 Remote Control 2 Doorbell Door bell | This sound is of a doorbell. It is playing a high pitched melody with a chiming sound. There are no other instruments in this song. There are no voices in this song. This sound is similar to what you would find in a music box. | 2013-08-14T12:11:50Z | Toan Trinh Music | i just bought this item from ebay. this make you easy to preview the music of the bell. thanks for watching. enjoy! | ["Bell", "Doorbell", "Ding-dong"] | ["wireless doorbell sound", "high pitch melody", "chiming sound", "no instruments", "no voices", "moderate tempo", "simple melody"] | 0 | BurGML_ZqSA | 1303 |
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;