musiccaps_details (view)
3 rows where musiccaps_aspects contains "arpeggiated strings melody" and musiccaps_aspects contains "low quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- arpeggiated strings melody · 3 ✖
- low quality · 3 ✖
- passionate 2
- advertisement 1
- brass melody 1
- breathy flute melody 1
- camera shuttering sound effects 1
- classical 1
- emotional 1
- epic 1
- exciting 1
- high pitched down sweeps 1
- mellow woodwind melody 1
- mystical 1
- orchestra percussions 1
- soulful 1
- synth sound effects 1
- traditional 1
- wide wooden percussive elements 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Professional DSLR Camera | The low quality recording features an advertisement that consists of camera shuttering effects and high pitched down sweeps, followed by arpeggiated strings melody, orchestra percussions and synth sound effects playing in the background. It sounds exciting and epic. | 2012-05-30T08:02:40Z | Sanjay Khaparde | By Olympus. Mirror less technology with Fast Auto Focus. Buy It Now! | ["Music", "Single-lens reflex camera"] | ["low quality", "advertisement", "camera shuttering sound effects", "high pitched down sweeps", "arpeggiated strings melody", "epic", "orchestra percussions", "synth sound effects", "exciting"] | 4 | 0soVCtJgDTk | 217 | |
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 | |
Veeramanidasan | Adi Velliyile | Ayiram Kannudaiyal | The low quality recording features a traditional song that consists of wide wooden percussion, arpeggiated strings melody and breathy flute melody layered with brass melody. It sounds soulful, mystical and passionate. | 2013-02-23T11:36:22Z | Symphony | Amman Music Video Album by Veeramanidaasan with an interesting Storyline and fantastic visuals and pilgrimage of amman temples. To download music visit www.mytamilsong.com To Download songs from itunes click here http://geni.us/3GZg | ["Traditional music", "Music"] | ["low quality", "wide wooden percussive elements", "arpeggiated strings melody", "breathy flute melody", "brass melody", "soulful", "mystical", "passionate", "traditional"] | 4 | rKfpCiJf9do | 4866 |
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;