musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2012-12-02
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality 2
- acoustic guitar chords 1
- animated music video 1
- blood spillage sound effects 1
- bright 1
- country 1
- groovy 1
- groovy bass 1
- groovy piano chords 1
- grunting sound effects 1
- hip hop 1
- noisy 1
- percussive instrumental 1
- practice 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- sliding 1
- sword slicing sound effect 1
musiccaps_names (array) 8 ✖
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 | |
Whimper | The low quality recording features a hip hop song that consists of groovy bass, groovy piano chords, shimmering hi-hats and punchy kick and snare hits over sword slicing, blood spillage and grunting sound effects. Overall the song is very groovy, bright and judging by the volume of the sounds, it could be an Animated Music Video. | 2012-12-02T16:12:34Z | SaladUK | Xperiment - Stayin' Steady http://www.facebook.com/saladuk http://www.twitter.com/saladuk http://vine.co/saladuk | ["Music", "Wail, moan"] | ["low quality", "hip hop", "groovy bass", "grunting sound effects", "blood spillage sound effects", "animated music video", "sword slicing sound effect", "groovy piano chords", "punchy kick", "punchy snare", "shimmering hi hats", "bright", "groovy"] | 4 | n3X8RGZsGg4 | 4516 |
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;