musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "amateur recording" and youtube_description = "California Sound es el pedal que emula los mesas mk2 californianos de siempre. Prince, Slash, Santana,...entre otros. http://sxguitarist.com/ California sound, simulates mesa boogie MK ? amplifier 2.Get natural permeable or original sound and very full principal tone 3.High, mid, and low sound switches and voice, level and drive switches 4.True bypass design to minimize the tone loss 5.LED power indicator 6.Powered by 6F22 9V battery(included) or to the wall optional psu not included Specifications: 1.Input impedance: 1 Mω 2.Output impedance:1 kω 3.Running current: 3.8 mA 4.Voltage: 9V battery/adapter 5.Dimension: 120 x 97 x 55 mm 6.Net weight: 390g 7.Color: white http://sxguitarist.com/"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_names (array) 3 ✖
youtube_description 1 ✖
- California Sound es el pedal que emula los mesas mk2 californianos de siempre. Prince, Slash, Santana,...entre otros. http://sxguitarist.com/ California sound, simulates mesa boogie MK ? amplifier 2.Get natural permeable or original sound and very full principal tone 3.High, mid, and low sound switches and voice, level and drive switches 4.True bypass design to minimize the tone loss 5.LED power indicator 6.Powered by 6F22 9V battery(included) or to the wall optional psu not included Specifications: 1.Input impedance: 1 Mω 2.Output impedance:1 kω 3.Running current: 3.8 mA 4.Voltage: 9V battery/adapter 5.Dimension: 120 x 97 x 55 mm 6.Net weight: 390g 7.Color: white http://sxguitarist.com/ · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
pedal joyo californiasound | Someone is playing an e-guitar melody and licks. This is an amateur recording. This song may be playing at home practicing e-guitar. | 2011-08-16T21:21:59Z | sxguitar666 | California Sound es el pedal que emula los mesas mk2 californianos de siempre. Prince, Slash, Santana,...entre otros. http://sxguitarist.com/ California sound, simulates mesa boogie MK ? amplifier 2.Get natural permeable or original sound and very full principal tone 3.High, mid, and low sound switches and voice, level and drive switches 4.True bypass design to minimize the tone loss 5.LED power indicator 6.Powered by 6F22 9V battery(included) or to the wall optional psu not included Specifications: 1.Input impedance: 1 Mω 2.Output impedance:1 kω 3.Running current: 3.8 mA 4.Voltage: 9V battery/adapter 5.Dimension: 120 x 97 x 55 mm 6.Net weight: 390g 7.Color: white http://sxguitarist.com/ | ["Tapping (guitar technique)", "Music", "Distortion"] | ["amateur recording", "e-guitar"] | 6 | I-XYm2Ck2r8 | 1858 |
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;