musiccaps_details (view)
4 rows where musiccaps_aspects contains "home recording", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- home recording · 4 ✖
- poor audio quality · 4 ✖
- instrumental 3
- medium tempo 2
- spirited 2
- amateur recording 1
- ambient room noises 1
- amplified guitar 1
- audio hiss tones 1
- banjo 1
- banjo lead 1
- bluegrass 1
- boomy 1
- buzzing 1
- country 1
- country music 1
- dance music 1
- disc scratching tones 1
- dj 1
- dj face off 1
- dj practising 1
- dj turntable 1
- electric guitar lead 1
- electronic dance music 1
- electronic music 1
- enthusiastic 1
- fast fingers 1
- fast tempo 1
- finger snapping 1
- folk 1
- folk song 1
- freestyle dj 1
- groovy 1
- hard rock 1
- high pitched sounds 1
- instrumental all music 1
- lively 1
- loud electric guitar feedback 1
- melodious 1
- metal 1
- muddled audio 1
- muddy 1
- muffled sound 1
- muffled sounds 1
- no accompaniment 1
- regional music 1
- rock 1
- scuffling 1
- sonic power 1
- steady drumming rhythm 1
- steel pan 1
- string instrument 1
- stringed instrument 1
- superimposed sounds 1
- tapping 1
- tone manipulation 1
- vigorous 1
- vigorous drumming 1
- vigours background beat 1
- vinyls 1
- world music 1
- youthful 1
musiccaps_names (array) 13 ✖
- Music · 4 ✖
- Banjo 1
- Bass guitar 1
- Bluegrass 1
- Distortion 1
- Drum machine 1
- Effects unit 1
- Electric guitar 1
- Electric toothbrush 1
- Heavy metal 1
- Scratch 1
- Scratching (performance technique) 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
Greatest Sound Man Freestyle Scratch | The song is an instrumental. The tempo is medium with a slick drumming rhythm and a DJ creating cool melodies by scratching and manipulating spinning music discs. The song is energetic and has a dance groove. The song is electronic dance music with poor audio quality and is at home. | 2008-11-29T06:19:22Z | Juan | Some weak on the spot cutting. Nothing fancy, just gettin some footage | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["instrumental all music", "dj", "electronic dance music", "home recording", "audio hiss tones", "fast fingers", "freestyle dj", "dj face off", "medium tempo", "steady drumming rhythm", "vinyls", "tone manipulation", "groovy", "disc scratching tones", "dance music", "dj practising", "ambient room noises", "poor audio quality", "dj turntable"] | 1 | KUE_I30--AY | 2087 | |
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 | |
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 |
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;