musiccaps_details (view)
3 rows where musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Tap" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- medium tempo · 3 ✖
- amateur recording 2
- instrumental music 2
- poor audio quality 2
- amateur production 1
- amateur tap dancing 1
- amateur tapping tones 1
- ambient room noises 1
- beeping tones 1
- dance lessons 1
- dance rhythm 1
- experimental 1
- explosions 1
- folksong 1
- game soundtrack 1
- gamers 1
- guns shooting rhythmically 1
- jazz music 1
- jukebox 1
- memdiumm tempo 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- people talking 1
- percussive blasts 1
- piano accompaniment 1
- projectile explosions 1
- rap dancers 1
- spirited 1
- theme song 1
- unconventional instrumentation 1
- video game 1
- war game 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Counter-Strike Gun Sounds 2 | The song is an instrumental. The song is medium tempo with various explosive sounds played percussively, along with counter beeps. The song is exciting and very novel. The song is probably the theme song of a modern video game. | 2007-07-07T15:05:14Z | djct1213cs | Counter-Strike Gun Sounds 2 CS1.6 Non-Steam: Cool CS Music Weapons | ["Music", "Tap"] | ["video game", "beeping tones", "medium tempo", "experimental", "spirited", "gamers", "percussive blasts", "theme song", "explosions", "guns shooting rhythmically", "poor audio quality", "amateur production", "projectile explosions", "game soundtrack", "instrumental music", "unconventional instrumentation", "war game"] | 1 | 70pyoqX0U9Y | 802 | |
42nd street tap dance! | The song is instrumental. The tempo is medium with a piano playing solo accompaniment with no other instrumentation. Tap dancers tap to the piano accompaniment not perfectly in sync , with a lot of ambient room noises and people talking. The audio quality is very poor in this home video. | 2010-02-25T02:39:37Z | n3v3rb33ndone3 | classic tap dance to broadway's 42nd street.. Done by dancers at mary ann's dance studio | ["Music", "Tap"] | ["instrumental music", "poor audio quality", "rap dancers", "medium tempo", "amateur tapping tones", "piano accompaniment", "no other instrumentation", "jazz music", "amateur tap dancing", "ambient room noises", "people talking", "memdiumm tempo", "out of sync tapping rhythm", "dance rhythm", "dance lessons", "amateur recording", "instrumental music"] | 1 | pG6yeC3yUY4 | 4693 | |
Tap Dance | A jukebox is playing a folk melody in a very bad audio-quality along with some plastic clapping sounds. This is an amateur recording. | 2007-07-11T10:22:30Z | calbeelau | Very nice toy!! Meet The Hayz at: http://hk.myblog.yahoo.com/the_hayz | ["Music", "Tap"] | ["amateur recording", "folksong", "jukebox", "medium tempo"] | 6 | uYYpqx0rzok | 5123 |
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;