musiccaps_details (view)
3 rows where musiccaps_aspects = "["amateur recording", "e-guitar"]", musiccaps_author = 6 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
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 | |
Sperzel How To: Drop D Tuning Using "D-Thing Tuner" | Someone is playing a fast paced melody running up and down a scale. This is an amateur recording. This song may be playing soundcheck with a band. | 2011-04-09T20:41:10Z | Peter Barlow | Sperzel 1 | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["amateur recording", "e-guitar"] | 6 | JKbUVdMJAO8 | 1990 | |
MARSHALL 8200 VALVESTATE AMP HEAD DEMO W Bi-Chorus | Someone is strumming chords on an e-guitar. The e-guitar is slightly out of tune. This song may be playing at home trying out sounds on the e-guitar. | 2013-08-30T20:43:55Z | allanz00 | This demo is only meant to show a little of the performance of what the Marshall 8200 Amp head can do (Not My playing LOL.) The gear is a Marshall 8200 Valvestate 200w (100w x 100w) head on top of a Marshall JCM 900 Lead 1960 4 speaker cab. The pedal is a Fulltone GT-500 Distortion & Booster/OD pedal. Used the Chorus channel at around 2:43 nothing fancy, really just played a bit of whatever I was felling at the time. | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar"] | 6 | PB3i02Cjf1k | 2515 |
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;