musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "clicking sound"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- amateur recording · 2 ✖
- clicking sound · 2 ✖
- catchy riff 1
- digital drum beat 1
- dj 1
- dj mixer 1
- electric guitar riff 1
- fast tempo 1
- home recording 1
- instrumental 1
- keyboard harmony 1
- mandolin solo 1
- muddled music 1
- scratching 1
- sharp sound 1
- static 1
- vinyl records 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Bicchio "Scratching with Duca" | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | 2007-10-17T21:52:00Z | sistahduka | Dj Bicchio "Scratching with Duca" | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | 7 | 5tt_GKV13G0 | 704 | |
Man of Constant Sorrow Mandolin Solo with Dyno-Tab ™ | This song contains a mandolin being strummed along to a clicking sound. This song may be playing in a video-tutorial. | 2013-03-26T13:40:17Z | musiciansworkshop | Order the Full Course At: http://www.musicians-workshop.com/index.php/mandolin/intermediate/mandolin-solos-intermediate-vol-4.html This lesson is from MANDOLIN SONGS INTERMEDIATE VOL 4. (10 volumes in all). the course is book/cd combo but can be downloaded and singles can be downloaded. I Know What It Means to Be Lonesome Little Sadie Pig in a Pen Pretty Little Miss Prisoner's Song Saro Jane Man of Constant Sorrow There's More Pretty Girls Than One Walkin' in My Sleep Wreck of the Old '97 Learn how to play 10 intermediate level Bluegrass Mandolin solos designed to help you develop your personal solo designing skills. From the title song from the movie: Oh Brother Where Art Thou (Man of Constant Sorrow), to the Tony Rice hit song "Little Sadie", this course is packed with great material. Little Sadie even teaches 2 variations! You're going to have fun with these, I guarantee it. Dan Huckabee On the AUDIO portion of this course, each lesson is presented in 3 steps. • First each solo is played at normal speed with accompanying rhythm guitar to demonstrate the finished product. • Second, the solo is played at half speed so the student can hear it under the microscope. • And last, a jam along version allows the student to play along after he or she is ready to keep up with the music. • The jam track consists of 5 rounds, with the solos recorded on the 1st, 3rd, and 5th round and an empty space for the student on the 2nd and 4th rounds. The WRITTEN MATERIAL is 45 pages in tablature notation with chords, lyrics, and supportive material such as: How to Read Tablature, Pick Direction, Mandolin parts, Tuning, Setting & Tuning the Bridge, Open Chords for Mandolin, Bluegrass chop, Rhythm Chords, Basic Bluegrass Chord Progressions, Advanced Chop Rhythm Chords, Key Changing Wheel, Misc Information, Mandolin Fingerboard Chart, Major Scales, The Bill Monroe Bluegrass Scale, Major Arpeggios, Double Stops, Finger Exercises, Crazy Scales etc. visit: http://www.musicians-workshop.com | ["Acoustic guitar", "Music", "Mandolin"] | ["mandolin solo", "clicking sound", "amateur recording"] | 6 | Wil8e6kBxe8 | 3130 |
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;