musiccaps_details (view)
2 rows where "youtube_published" is on date 2009-07-30 sorted by youtube_link
This data as json, CSV (advanced)
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 | The low quality recording features a wide arpeggiated electric guitar melody. It sounds clean, passionate and the recording is a bit noisy. | 2009-07-30T18:48:06Z | BenRandallGuitar | Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 Regius PRO 6 with Schaller Floyd Rose PRO for dive-bombing, fluttering, vibratoing and whatever else you like with the reliability of 11-pieces neck-thru construction. Standard 25,4" scale only. Ergonomic contoured body perfectly shaped for easy access to the upper frets. Swamp Ash body for modern sound with quick attack or Mahogany for more warm and round tones. Artist-grade Flamed Maple 'radiused' top. Strings-thru-body fixed bridge for the wood vibration enhancement. Equipped with Sperzel locking tuners and Seymour Duncan, EMG or DiMarzio pickups. Several colour options and hardcase included. http://www.mayones.com http://www.blackhawkmusic.co.uk http://www.myspace.com/benrandallguitar For more information, contact Ben Hawker: Call +44 (0)7990 828779 or Email ben@blackhawkmusic.co.uk | ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "wide arpeggiated electric guitar melody", "clean", "passionate"] | 4 | IIK0EuHyb6w | 1890 | |
didgeridoo | Someone is playing a didgeridoo along with a percussive sound. You can hear people talking in the background. This is an amateur recording. This song may be played live by someone that is busking on the streets. | 2009-07-30T15:32:35Z | Helmut Muschalle | http://www.waschbrettbauch.umagic.de Ulm um die Mittagszeit, war gerade bei meiner Fotorunde als ich den jungen Polen in der Hirschstraße mit dem Didgeridoo sah. Guter Sound und gute Technik, wäre froh wenn ich die so genannte Synchronantmung beherschen würde. Habe schon mehrere vergebliche Versuche hinter mir und mein Didgeridoo was vermutlich eher für dekorative Zwecke geeignet war habe ich verschenkt. | ["Didgeridoo", "Music"] | ["didgeridoo", "percussion", "amateur recording", "uptempo"] | 6 | ZfSlWX1C8yY | 3401 |
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;