musiccaps_details (view)
5 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "muddled audio" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- instrumental · 5 ✖
- muddled audio · 5 ✖
- medium tempo 3
- spirited 3
- amateur recording 2
- enthusiastic 2
- hard rock 2
- keyboard accompaniment 2
- loud electric guitar feedback 2
- people talking 2
- white noise 2
- youthful 2
- ambient sounds 1
- amplified guitar 1
- boomy 1
- breeze 1
- buoyant 1
- cajun 1
- chatter of people 1
- children electronic toys 1
- children’s game music 1
- clapping 1
- congas 1
- crowd cheering 1
- crowd hooting 1
- dance music 1
- distorted audio 1
- drums 1
- elctronic music 1
- electric guitar harmony 1
- electric guitar lead 1
- electronic music 1
- energetic 1
- enthusiastic amplified guitar 1
- gig 1
- groovy bass line 1
- high notes 1
- home recording 1
- home video 1
- incoherent music 1
- inferior audio recording 1
- intense 1
- keyboard harmony 1
- live performance 1
- lively 1
- melodious 1
- metal 1
- muddy 1
- muffled audio 1
- muffled sound 1
- poor audio quality 1
- punchy drumming 1
- rock 1
- sharp 1
- sonic power 1
- steel drum 1
- steel pan 1
- string instrument 1
- synthesiser 1
- synthesiser arrangements 1
- video game music 1
- vigorous 1
- whirring 1
- whooshing sound 1
- wind instrument harmony 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sounds - Diana | This song is a hard rock instrumental. The tempo is fast with bright electric guitars playing lead, steady bass line, punchy drumming and upbeat keyboard harmony The music is energetic, upbeat, youthful, engaging, buoyant, peppy, and groovy.it is a crowd pleaser ,as clapping, cheering , chatter and hooting can be heard in the background. | 2011-01-24T20:11:57Z | katrin3417 | The Sounds am 21. Januar 2011 bei der Snowhite Music Night im Postbahnhof in Berlin | ["Music", "Field recording"] | ["loud electric guitar feedback", "punchy drumming", "keyboard accompaniment", "keyboard harmony", "groovy bass line", "instrumental", "hard rock", "enthusiastic amplified guitar", "muddled audio", "crowd cheering", "crowd hooting", "people talking", "clapping", "live performance", "gig", "synthesiser", "enthusiastic", "spirited", "energetic", "youthful", "buoyant", "intense"] | 7 | 3dUo62RsD00 | 489 | |
DiMarzio Crunch Lab and LiquiFire Drive Sound Test (check up with an Ibanez S570B) | This music is an electric guitar instrumental Rock. The tempo is medium with an electric guitar lead. The music is loud and boomy with an intense riff. The audio quality is inferior so the sound is muffled and muddy. The music however is energetic, youthful, spirited and enthusiastic. | 2010-12-17T12:36:42Z | darkcashyz | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Distortion"] | ["instrumental", "amplified guitar", "youthful", "spirited", "sonic power", "enthusiastic", "muddy", "muffled sound", "medium tempo", "loud electric guitar feedback", "vigorous", "poor audio quality", "boomy", "electric guitar lead", "string instrument", "rock", "metal", "hard rock", "youthful", "enthusiastic", "muddled audio", "home recording"] | 7 | 6ayVxYbKBe0 | 769 | ||
Trinidad Music - Youth plays steelpan - Indian Trail Church | This music is instrumental. The tempo is medium with a melodic steel pan harmony. The audio quality however is inferior and amateur,so the music is muddled. There are ambient sounds of breeze and people talking , indicating that this is a live performance. | 2009-06-18T20:47:10Z | Home and Happy. | A youth pannist plays at Indian Trails Open Bible Church. Steelpans (also known as steeldrums or pans, and sometimes collectively with musicians as a steelband) is a musical instrument and a form of music originating from Trinidad. Steelpan musicians are called pannists. | ["Music", "Steelpan"] | ["white noise", "instrumental", "medium tempo", "steel pan", "amateur recording", "muddled audio", "steel drum", "inferior audio recording", "incoherent music", "melodious", "ambient sounds", "people talking", "breeze"] | 7 | _ALGXHquYkM | 3450 | |
demo kisanola | This song is an instrumental. The tempo is medium fast with enthusiastic drumming, congas and canon rhythm,electronic guitar harmony, keyboard accompaniment and a wind instrument playing a melodious harmony. There is the sound of chattering in the background. The audio is of inferior quality and muddled. The song is energetic, spirited and melodic with a catchy dance groove. | 2007-11-17T14:44:37Z | llawal41 | african men dancing like men, not women | ["Music", "Steelpan"] | ["instrumental", "distorted audio", "drums", "dance music", "wind instrument harmony", "congas", "electric guitar harmony", "keyboard accompaniment", "cajun", "lively", "spirited", "dance music", "muddled audio", "chatter of people"] | 7 | rTBQmP6Vt0g | 4878 | |
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;