musiccaps_details (view)
2 rows where musiccaps_aspects = "["amateur recording", "e-guitar"]" and musiccaps_names contains "Tapping (guitar technique)"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_names (array) 8 ✖
- Music 2
- Tapping (guitar technique) · 2 ✖
- Distortion 1
- Electric guitar 1
- Electronic tuner 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
musiccaps_aspects (array) 2 ✖
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 |
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;