musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "no other instruments" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- low quality audio · 2 ✖
- no other instruments · 2 ✖
- acoustic guitar 1
- amateur recording 1
- child's voice 1
- distortion guitar 1
- guitar instructional clip 1
- holiday song 1
- instructional audio 1
- male voice 1
- no percussion 1
- root and fifth 1
- slow tempo 1
- vocables backing 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 |
---|---|---|---|---|---|---|---|---|---|---|
Mercado Kids Singing Christmas song Mary Did You Know by Mark Lowry | This low quality audio features a child singing the main melody. This is accompanied by other children's voices singing vocables in the background in harmony. An acoustic guitar strums chords. There are no other instruments in this song. This song has a holiday mood. This song can be played in a Christmas movie. | 2014-01-01T03:51:21Z | MercadoFamilyMusic | Hey all! This is our first YouTube upload. We are a sibling group from North Carolina. We love music, performing and most of all we love our Lord and Savior, Jesus Christ. We hope that you enjoy what we have to share. God bless! ~The Mercados Jeremiah 1:5-9 Please like, comment, subscribe and share! Be looking for more videos from us. mercadofamilymusic@gmail.com | ["Christmas music", "Singing", "Humming", "Music", "Choir", "Vocal music", "Child speech, kid speaking"] | ["amateur recording", "low quality audio", "child's voice", "vocables backing", "acoustic guitar", "no percussion", "no other instruments", "holiday song", "slow tempo"] | 0 | Ve6Zy1BXBbY | 3015 | |
Canon Rock for beginners | This song features a male giving instructions on playing a guitar. A distortion guitar is playing the root note and the fifth. After the instruction, the root note and the fifth is played individually. This song features only the male instruction voice and no vocal melody. There are no other instruments in this song. There is no percussion in this song. | 2010-06-01T03:15:47Z | Brandon Burch Music | I've made this lesson for beginners who would like to get started with Canon Rock. These are just the chords. Enjoy! When you're ready to move on to the rest of the song, I have lessons available in my channel playlists. They cover the entire song. ✅ Watch next –Canon Rock Full Series Lessons https://www.youtube.com/playlist?list=PL0C718E78A4D6FD88 Join our journey: https://www.youtube.com/brandonburch?sub_confirmation=1 Click the bell so you won't miss my sporadic uploads! Need more inspiration? Check out these playlists: Best Productions: https://www.youtube.com/watch?v=SYMOy9-Y6ZA&list=PLLRq8GHI4SPFLGa4gik1lHZQUBU83NOi5 Musicians' Corner: https://www.youtube.com/watch?v=g81OJkCcbuw&list=PLLRq8GHI4SPG6b3QmtEQ98S2T16ZTYPX0 Gear Reviews: https://www.youtube.com/watch?v=CrAXz7tgf8U&list=PLLRq8GHI4SPH9uvFmOi4ndfA9rP-uvPtT Vocal Vids: https://www.youtube.com/watch?v=zR_rJha9hZo&list=PLLRq8GHI4SPEKQuwN1aXtL0lUcBd4WBhd I wish you all the best on your guitar journey! Guitar Journey merch: https://teespring.com/stores/brandon-burch-store My gear: https://www.amazon.com/shop/brandonburch1 Follow me: My music: https://brandonburch.bandcamp.com/ Soundcloud clips: https://soundcloud.com/brandon-burch-music Behind the music: https://www.instagram.com/brandondburch/ Photography: https://www.instagram.com/brandondburchphotos/ Follow my metal band: (Analyzed Within) Our music: https://analyzedwithin.bandcamp.com/ Facebook: https://www.facebook.com/analyzedwithin/ Official YT: http://www.youtube.com/analyzedwithin Drummer YT: https://www.youtube.com/user/DANOA7X2009 Drummer Instagram: https://www.instagram.com/dano.drums_aw/ Get my music gear! * D’Addario Strings, Regular Light, 7-String, 10-59: https://amzn.to/324Mwch * Ernie Ball 5-String Power Slinky Bass Set, 50-135: https://amzn.to/3aHaL44 * Dunlop Tortex Pitch Black Jazz Picks 1 Dozen 1.14 mm: https://amzn.to/327Nbtx * Gruv Gear FretWrap String Muter (Green, Medium): https://amzn.to/3gdCSJA * Focusrite Scarlett 2i2 USB Audio Interface: https://amzn.to/2EknGgg * Ib… | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | ["guitar instructional clip", "low quality audio", "distortion guitar", "no other instruments", "male voice", "instructional audio", "root and fifth"] | 0 | fsXQHyg5qDI | 3984 |
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;