musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "electronic music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 69 ✖
- amateur recording · 5 ✖
- electronic music · 5 ✖
- instrumental 5
- digital music 2
- dj 2
- dj mixer 2
- fast tempo 2
- home recording 2
- home video 2
- medium tempo 2
- static 2
- youthful 2
- birds chirping 1
- buoyant 1
- buzzing 1
- car engine 1
- carousel 1
- carousel music 1
- children electronic toys 1
- children’s game music 1
- children’s music 1
- children’s toy music 1
- dance floor 1
- dance music 1
- digital drumming 1
- distorted sounds 1
- drum machine 1
- edm 1
- elctronic music 1
- electrifying 1
- electro pop 1
- electronica 1
- engine sound 1
- engine whirring 1
- finger snapping 1
- fourth world music 1
- freestyle dance 1
- high notes 1
- hypnotic 1
- ice-cream cart 1
- inferior audio quality 1
- low quality audio 1
- merry-go round 1
- muddled audio 1
- muffled audio 1
- muffled sounds 1
- outdoors 1
- people’s voices 1
- poor audio quality 1
- pulsating 1
- punchy drumming 1
- scuffling 1
- sharp 1
- steel pan 1
- superimposed sounds 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- synthesiser articulation 1
- tapping 1
- techno pop 1
- thudding 1
- trance 1
- video game music 1
- vigorous drumming 1
- vigours background beat 1
- whirring 1
- white noise 1
- whooshing sound 1
- xylophone melody 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Candy Cox @ TechnoTv [30.08.2006] | This music is instrumental. The tempo is fast with electronic beats and rhythm on a DJ mixer. The music is youthful, hypnotic, groovy; burgeoning and trance . | 2007-05-24T22:17:24Z | technotv | http://www.myspace.com/djcandycox | ["Scratching (performance technique)", "Electronic music", "House music", "Music", "Techno"] | ["instrumental", "fast tempo", "dj", "dj mixer", "static", "amateur recording", "home recording", "electronic music", "synthesiser arrangement", "digital music", "dance music", "electronica", "fourth world music", "youthful", "hypnotic", "trance", "techno pop", "electro pop"] | 7 | 65KYS3lIRII | 723 | |
TAIWAN Melbourne Shuffle · 曳步舞 · 鬼步舞 【T.N.S 貓少] | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | 2013-03-15T14:55:39Z | 魑魅鳳 | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | 7 | JqmOqYtQqB8 | 2038 | ||
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 | |
Missing from YouTube | This music is instrumental. The tempo is fast but the music is muffled as it is superimposed by a loud buzzing sound along with some tapping,scuffling, finger snapping ans tapping sounds. The music sounds like energetic Electronic music with vigorous drumming. | ["Electric toothbrush", "Music"] | ["instrumental", "buzzing", "tapping", "vigours background beat", "superimposed sounds", "finger snapping", "tapping", "amateur recording", "home recording", "poor audio quality", "electronic music", "vigorous drumming", "muffled sounds", "scuffling", "steel pan"] | 7 | 4042 | |||||
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN | This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. | 2010-10-29T21:53:59Z | 6877mercedes Ebay | City of Tampa Florida POLICE Diecast Car with Lights and SIREN | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] | 7 | uwPeQy7ZtGo | 5143 |
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;