musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "no singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- amateur recording · 5 ✖
- instrumental 5
- no singer · 5 ✖
- jam 3
- electric guitar 2
- single instrument 2
- aggressive 1
- clean sound 1
- complex 1
- cover 1
- cozy 1
- crunchy 1
- didgeridoo 1
- distorted electric guitar 1
- easygoing 1
- guitar solo 1
- hard-hitting 1
- heavy metal 1
- irish flute 1
- irish folk music 1
- low-to-medium range 1
- ominous 1
- playful 1
- poor quality 1
- random 1
- rehearsal 1
- shredding 1
- simple tunes 1
- tribal 1
- unfamiliar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
9 year old boy genius guitar player | This is an electric guitar jam being performed by a 9 year-old. It is an amateur recording, so there is a constant feedback noise coming from the amp. The electric guitar has a clean sound. The tunes are mostly simple with a lot of muted strokes. The recording has an easygoing atmosphere. If the feedback noise can be bypassed, the tunes from this recording can be used in beat-making. | 2007-02-27T05:22:37Z | ricki lake | Check this 9 year old guitar wizz playing jimi hendrix classic, Little Wing. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "no singer", "instrumental", "amateur recording", "electric guitar", "clean sound", "simple tunes", "easygoing"] | 9 | 1SO5RJLWKAs | 276 | |
DIDJERIDU (DIDJERIDOO) | This is the amateur recording of an instrument showcase jam. There is a didgeridoo playing at low-to-medium range making various resonant sounds in the process. The atmosphere is ominous and tribal. The quality of the audio is quite poor. This piece could be played at a primary school music class to give the kids an impression of how a didgeridoo sounds like. | 2007-12-30T16:57:55Z | kaypacha | Didgeridus para la venta en julio 2007. http://www.kaypacha.com.ar Didgeridoos for the sale in July 2007. | ["Didgeridoo", "Music"] | ["jam", "no singer", "instrumental", "amateur recording", "poor quality", "single instrument", "didgeridoo", "low-to-medium range", "unfamiliar", "ominous", "tribal"] | 9 | 8KIoQ2HZ0Hg | 911 | |
13 year old kid plays Eruption by Van Halen | This is an amateur cover of a guitar solo in a heavy metal piece. The solo is being played on an electric guitar. There is a rapid procession of high-pitch notes in the solo. The feel is complex and aggressive. The quality of the recording is a bit poor. If the quality issue can be resolved, this piece could be sampled for use in beat-making. | 2008-05-01T15:30:23Z | dave8386 | Me playing Eruption on my dad's Squire Strat. For everyone saying that I "deserve a better guitar": I got a Fender Stratocaster that Christmas so I'm sorry if you're disappointed that it was played on a Squire but I don't feel it sounded too bad on it! =) | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["cover", "amateur recording", "heavy metal", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "complex", "aggressive"] | 9 | Y6OOFbrzdP8 | 3254 | |
Low Tin Whistle Morrison's Jig irish flute music | This is an amateur recording of an Irish folk music piece. It is an instrumental piece. There is an Irish flute playing a playful melody in a home setting. The atmosphere is cozy. This piece could be used in the soundtrack of an arcade adventure video game during the parts where the protagonist is traversing through forested areas. | 2007-10-17T13:57:59Z | spennamac | Morrisons Jig played on an Overton low whistle in D low whistle | ["Wind instrument, woodwind instrument", "Flute"] | ["amateur recording", "irish folk music", "no singer", "instrumental", "single instrument", "irish flute", "playful", "cozy"] | 9 | YjTz5y8DnWo | 3307 | |
TJ's Angry Dad And His Friend Bodka Bob Attempt To Play Some Music Fail! | This is a home recording of two electric guitar players jamming some random rock/metal tunes. It is a dated amateur recording so the quality is quite poor. The electric guitars have a distortion effect that gives them a crunchy sound. The sound is hard-hitting, but the atmosphere feels spontaneous and random. Parts of this recording could be lifted as distorted electric guitar samples to be used in beat-making. | 2013-02-21T17:02:06Z | TJandFriends | March 28, 2002 TJ's Angry Dad and his friend Bob also known as 'Bodka' attempt to play some music but just can't seem to get it together. I think they had just finished smoking? This was earlier that day before my parents fought about allowing the cops in the house for animal hoarding without a warrant. This all happened on March 28, 2002. Please Subscribe To My Personal Facebook! http://www.Facebook.com/TJBrowneJr Please Like Us On Facebook! http://www.Facebook.com/TJandFriends | ["Electric guitar", "Guitar", "Music", "Theremin", "Distortion"] | ["jam", "rehearsal", "amateur recording", "no singer", "instrumental", "distorted electric guitar", "hard-hitting", "crunchy", "random"] | 9 | Z19W44ZI15Q | 3337 |
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;