musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Pizzicato"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality · 4 ✖
- emotional 2
- noisy 2
- passionate 2
- arpeggiated harp melody 1
- arpeggiated strings melody 1
- breathy flute melody 1
- classical 1
- double bass slap 1
- filtered monster growl 1
- flat male vocal 1
- haunting 1
- joyful 1
- mellow woodwind melody 1
- mono 1
- scary 1
- spooky 1
- violin melody 1
- wide arpeggiated synth 1
musiccaps_names (array) 6 ✖
- Bowed string instrument · 4 ✖
- Pizzicato · 4 ✖
- Double bass 2
- Harp 2
- Violin, fiddle 2
- Cello 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ural of New England, Ural Retro "Classic" Maroon-Black | The low quality recording features a classical song that consists of an arpeggiated strings melody and mellow woodwind melody playing in the background. It sounds emotional and passionate. | 2011-11-25T18:10:26Z | AlphaCars & Motorcycles | A stylish look from the thirties with the technology and reliability of the 21st century. This is by far the most technologically advanced bike that one can purchase with the true Pre-WWII look and the best-in-class 2 year Unlimited Mileage Factory Warranty. At Ural of New England we offer Retro "Classic" - the original configuration that is no longer offered by Ural in US. We convinced factory management to manufacture 20 bikes in 2012 for Ural of New England in this gorgeous "Classic" configuration. Some of the notable "Classis" features include factory applied pinstriping, larger comfort seat for the rider, luxury sidecar leather seat and velour interior trim, wooden floor mat, right side tank shifter for easy reverse gear engagement. These features are no longer available on regular 2012 Retro models. In addition to these features these 20 bikes will have c Final Gears with higher ratio. This particular Maroon Retro has Black Powder coated Engine, Transmission and Final Drive. We also would like to point out that "Retro" model is dramatically different from all other Ural models: bike frame, side car frame, wheels, suspensions, head lamp styling, tear-drop style gas tank, fenders, running lighting, foot brake pedal arrangement and much more. Final price of $16,999 includes all dealer fees, Maroon with Black Frame Custom Color Option, Black Powder Coated Drivetrain (Engine, transmission, final drive w/2WD, side car brake backing plate), Custom 3.89 Final Gears with Engine Tuning. Shown with the following options that are not included in the price. Passenger Seat with Leather Covering, Vintage Style Sidecar Bumper, Right Side Lighting Kit for the Bike, Hella H4 headlamp lens upgrade. | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["low quality", "classical", "arpeggiated strings melody", "mellow woodwind melody", "emotional", "passionate"] | 4 | 54yI3In3DrU | 630 | |
Upright bass slap lesson | The low quality recording features a flat male vocal talking over a double bass slap. The recording is noisy and in mono. | 2014-03-13T20:30:35Z | Heath Williamson | Learn four different upright bass slaps. Single Slap, Double Slap, Triplet Slap, Drag Triplet. Quick easy lesson on right hand technique. | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["low quality", "double bass slap", "flat male vocal", "noisy", "mono"] | 4 | LNFAeJ06KVs | 2182 | |
Musici Nuziali - Canone di Pachelbel - Arpa, Violino, Flauto | The low quality recording features a breathy flute melody, violin melody and arpeggiated harp melody. It sounds joyful, emotional and passionate. The recording is a bit noisy. | 2010-04-03T14:31:22Z | musicinuziali | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["low quality", "noisy", "breathy flute melody", "violin melody", "arpeggiated harp melody", "joyful", "emotional", "passionate"] | 4 | j5R0hwX27Gk | 4234 | ||
Godzilla Ultimate Fan Contest - Enter to Win! | The low quality recording features a filtered monster growl, followed by a wide arpeggiated synth. It sounds spooky and haunting. | 2014-04-08T19:11:29Z | Nerdist | Enter to Win at http://ultimatefancontest.godzillamovie.com Are you the ultimate Godzilla fan? Prove it! Get creative and send your videos showing why you are Godzilla's #1 fan! Prizing: The ultimate Godzilla fan from the US will be joining their #1 fan counterparts from around the world on a trip to London for the European premiere and press junket where the fans will get a chance to meet and interview director Gareth Edwards! Do: Get creative, stand out from the crowd. Show off what makes you the biggest fan. Don't: Use movie footage from the trailer or other Godzilla movies Use music that you did not create Do anything that puts yourself or anyone else in danger Subscribe for more from Nerdist: http://bit.ly/Sub2Nerdist Follow us on Twitter: https://twitter.com/NerdistDotCom Check out Nerdist.com: http://www.nerdist.com | ["Double bass", "Pizzicato", "Bowed string instrument"] | ["low quality", "filtered monster growl", "wide arpeggiated synth", "scary", "spooky", "haunting"] | 4 | pcOPueObfWs | 4727 |
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;