musiccaps_details (view)
1 row where musiccaps_aspects contains "practice", musiccaps_names contains "Acoustic guitar", musiccaps_names contains "Music" and musiccaps_names contains "Plucked string instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Magical guitar review : Taylor 314 ghost graphtech-mounted with GR-55 | The low quality recording features a country song played on acoustic guitar. The chords are sliding and the recording is noisy and it sounds like a player is practicing. At the very end of the loop, there is a short snippet of percussive instrumental. | 2012-12-02T09:00:40Z | Oliwoods | My Taylor 314-CE, modified with a graphtech ghost acoustiphonic steel kit and played on a roland GR55 with my own presets : - Emulated bass sound on E,A and D, mixed with the natural guitar sound - Strings, accordion, organ or xylophone added to guitar/bass sound - Emulated banjo, sitar, resonator, bass, electric guitar + an example of making a loop with drum, bass, organ and electric guitar All were recorded directly from the GR-55. Enjoy ! The ghost system : http://www.graphtech.com/products.html?SubCategoryID=102 Some pics of the installation on www.sebastiendumont.fr Songs played in the video: - Talking about a revolution (Guitar with Bass) - Too young to die (Guitar with Bass) - Somebody else's guy (Guitar with Bass, flanger effect) - Somebody i used to know (Guitar with Bass, xylophone) - Les bourgeois (Guitar with Bass, accordion) - Stairway to heaven (Guitar with Bass, pan flute) - Rehab (Guitar with Bass, organ) - Nothing else matters (Guitar with Bass, strings) - Les bêtises (Emulated banjo) - Paint it black (Emulated sitar) - Resonator example (Emulated) - Oye como va (Looper with drum, bass, organ and emulated fender electric guitar) - Electric guitar example (Looper with drum, bass and emulated Les Paul electric guitar) | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "country", "acoustic guitar chords", "noisy", "practice", "percussive instrumental", "sliding"] | 4 | E7q_QwLYI8U | 1535 |
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;