musiccaps_details (view)
4 rows where "youtube_published" is on date 2009-04-11
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- "4 on the floor" kick pattern 1
- alternative rock 1
- ambient crowd noises 1
- bad audio quality 1
- blues rock 1
- cheering fans 1
- dimuendo 1
- electric guitar lick 1
- energetic 1
- engaging crowds 1
- enthusiastic 1
- famous guitarist 1
- fast tempo 1
- flat male vocal 1
- folk 1
- fretboard sounds 1
- fun 1
- groovy bass 1
- guitar master class 1
- guitar solo 1
- guitarist talks 1
- happy 1
- harmonizing female vocals 1
- incessant 1
- instrumental 1
- laughing 1
- live audience 1
- live concert 1
- live performance 1
- live recording 1
- lively vigorous 1
- low quality 1
- no fixed tempo 1
- performer 1
- poor audio quality 1
- random notes 1
- rock 1
- sax concerto 1
- shimmering hi hats 1
- single reed instrument 1
- soloist 1
- strings melody 1
- tuning legs 1
- tuning notes 1
- tuning pegs 1
- untiring 1
- vibrant 1
- western classical 1
- woodwind 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Paganini on Saxophone (Audio) | This music is instrumental. The tempo is fast with a vigorous and rapid western classical saxophone harmony. It is spirited, vibrant,untiring, engaging, skillful and high-spirited. | 2009-04-11T15:06:22Z | hkams | Paganini Caprices No. 1 and 5 on alto saxophone by saxophonist Raaf Hekkema | ["Brass instrument", "Saxophone"] | ["instrumental", "fast tempo", "western classical", "vibrant", "untiring", "sax concerto", "dimuendo", "enthusiastic", "lively vigorous", "woodwind", "single reed instrument", "incessant"] | 7 | TsTdffJ9LHg | 2873 | |
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
Andy McKee explains fanned frets (Multi-scale Geometry) - Piermont, NY 3/3/09 (7/10) | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | 2009-04-11T05:55:32Z | Rael0505 | While preparing for Shanghai (as requested by someone in the audience), Andy McKee broke a string and began talking about his tour in Asia while restringing. Towards the end of the video he explains why the frets on his guitar are crooked, a question a lot of people are wondering. Basically, the fanned frets on his new Greenfield guitar are both comfortable ergonomically and provide more accurate intonation. And although he doesn't mention it in this video, fan frets handle dropped tunings much better than regular frets do (and since Andy plays in so many different alternate tunings, fanned frets must be a dream come true). Thicker strings are naturally designed for a wider scale length - I would say all guitars should be built this way, and for a lot of handmade instruments with more than 6 strings, they are mandatory. You can see him play Shanghai in the next video, linked below: http://www.youtube.com/watch?v=uuUeAwnTYzA&fmt=18 | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | 1 | cQX-WgT0ACQ | 3705 | |
Kachchi Kaliyaan Song | Laaga Chunari Mein Daag | Rani Mukerji, Konkona | Sonu, Shreya, KK, Sunidhi | The low quality recording features a folk song that consists of flat male vocals, alongside harmonizing female vocals, singing over groovy bass, strings melody, shimmering hi hats, and "4 on the floor" kick pattern. It sounds energetic, happy and fun. | 2009-04-11T02:28:01Z | YRF | ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! #YRFnewreleases - https://www.youtube.com/playlist?list=PLCB05E03DA939D484 🎧 Song Credits: Song: Kachchi Kaliyaan Singers: Sonu Nigam, KK, Sunidhi Chauhan, Shreya Ghoshal Music: Shantanu Moitra Lyrics: Swanand Kirkire Stay in the filmy loop: ► Like us on Facebook: Facebook/yrf ► Follow us on Twitter: Twitter/yrf ► Follow us on Instagram: Instagram/yrf ► Visit us on: yashrajfilms.com 🎬 Movie Credits: Movie: Laaga Chunari Mein Daag - Journey Of A Woman Starring: Jaya Bachchan, Rani Mukerji, Konkona Sen Sharma, Kunal Kapoor, Anupam Kher, Abhishek Bachchan Special Appearance: Hema Malini Director: Pradeep Sarkar Producer: Aditya Chopra & Pradeep Sarkar Music: Shantanu Moitra Lyrics: Swanand Kirkire Director Of Photography: Sushil Rajpal Release Date: 12 October 2007 Watch all videos from the film 'Laaga Chunari Mein Daag - Journey Of A Woman': https://www.youtube.com/watch?v=luu39msPZrs&list=PL5E5D630D859255EC Synopsis: When a small town girl Badki (Rani Mukerji) from Banaras lands in the big bad city of Mumbai to earn an honest living for her family back home - things don’t go exactly as she hoped. When her kid sister Chutki (Konkona Sen Sharma) comes face to face and her double life is revealed the 2 sisters are in a confrontation that none of them expected or would have dreamt of in their wildest dreams - the whole family is thrown in to a tumultuous storm. Everything threatens to explode in their faces leaving a trail of destruction. #YRFnewreleases #LaagaChunariMeinDaag #YRF #AbhishekBachchan #RaniMukerji #KonkanaSenSharma #KunalKapoor #KK #ShreyaGoshal #SonuNigam #SunidhiChauhan #SwanandKirkire #ShantanuMoitra #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFSongs #YRFmusic #YashChopra #AdityaChopra © Yash Raj Films Pvt. Ltd. | ["Music of Asia", "Music"] | ["low quality", "folk", "flat male vocal", "harmonizing female vocals", "groovy bass", "\"4 on the floor\" kick pattern", "shimmering hi hats", "strings melody", "energetic", "happy", "fun"] | 4 | xe9vDoF8TQM | 5343 |
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;