musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "people talking"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 59 ✖
- instrumental · 3 ✖
- medium tempo · 3 ✖
- people talking · 3 ✖
- amateur recording 2
- amplified guitar 2
- electric guitar 2
- loud 2
- abrupt end 1
- accompanying music 1
- acoustic guitar 1
- amateur 1
- ambient nature sounds 1
- background noises 1
- background sounds 1
- boomy 1
- catchy 1
- cheerful 1
- cheering 1
- chirpy 1
- chord progression 1
- chords 1
- dissonant 1
- energetic drumming 1
- enthusiastic 1
- happy 1
- hard rock 1
- home recording 1
- home video 1
- intense 1
- keyboard harmony 1
- lively beat 1
- loud feedback 1
- melodic 1
- merry 1
- metal 1
- muffled audio 1
- of static 1
- people talking in the background 1
- pop song 1
- popular 1
- powerful 1
- rhythmic acoustic guitar 1
- rhythmic beat 1
- rock 1
- rock instrumental 1
- sharp 1
- simple 1
- sonic power 1
- sonic power’ 1
- sound of laughter 1
- spirited 1
- static 1
- string instrument 1
- tapping 1
- vehement 1
- vibrations 1
- xylophone harmony 1
- youthful 1
- ’ enjoyable 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 |
---|---|---|---|---|---|---|---|---|---|---|
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Curt Mitchell Chop Shop Solo Rockoryon Cover | This music is an Electric Guitar instrumental. The tempo is fast with a dissonant background score . There is the sound of people talking in the background. The music is superimposed on a track which doesn’t seem to be in sync. The lead however is powerful, loud, intense and emphatic. This is a Rock Instrumental. | 2009-08-10T15:54:08Z | OR1ON Orion Meshorer | (RockOryon Cover - when I was 12 years old) This is a great solo from Curt Mitchell Chop Shop. working hard on this solo, has improved my playing tremendously. it still needs more refinement but I want to use this occasion and thank Dear Curt Mitchell for his great teachings. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["instrumental", "electric guitar", "people talking in the background", "home recording", "amateur recording", "rock instrumental", "intense", "loud", "amplified guitar", "youthful", "enthusiastic", "vehement", "spirited", "sonic power’", "medium tempo", "background noises", "accompanying music", "people talking", "loud", "powerful", "intense", "rock", "hard rock", "metal", "dissonant"] | 7 | hBQFoDI3NMI | 4082 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;