musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_names (array) 8 ✖
- Electric guitar · 3 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument · 3 ✖
- Boing 1
- Electronic tuner 1
- Tapping (guitar technique) 1
musiccaps_aspects (array) 5 ✖
- e-guitar · 3 ✖
- medium tempo · 3 ✖
- amateur recording 2
- finger tapping 1
- mouth harp 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gibson Custom Shop 1957 Les Paul Goldtop | Someone is strumming a melody on a clean e-guitar. This may be playing for an advertisement. | 2011-08-17T23:02:03Z | MusicStoreTV | GIBSON CS Les Paul '54 VOS Reissue GT Gold Top Die Gibson Les Paul 1957 Goldtop wurde dem neu entwickelten Lackieverfahren (VOS) unterzogen. Durch dieses Verfahren ist die Gitarre jetzt auch optisch auf dem Ton-Level dieser einzigartigen Les Paul. Mehr Sustain als mit einer Les Paul gibt es einfach nicht. Aber hören Sie selbst! Erhältlich unter: http://www.musicstore.de/de_DE/EUR/Gibson-1954-Les-Paul-Goldtop-VOS-Antique-Gold/art-GIT0016115-000 http://www.musicstore.de | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["e-guitar", "medium tempo"] | 6 | XOLVI1bgxqk | 3180 | |
ピックアップで音は変わるのか? | This audio contains someone playing a mouthwarp. Then another recording starts where someone is strumming chords on an e-guitar fingerpicking a melody. This song may be playing for a photo slide show made for the family. | 2012-08-24T11:50:48Z | ingen99900 | ※演奏に関しては勘弁してね(;´∀`) エピフォン ウィルシャーのPUを ディマジオ スーパーディストーションに交換。 POD HD→ガレージバンドで録音。 思いのほかタップした時のサウンドが良いですな。 | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Boing"] | ["amateur recording", "mouth harp", "e-guitar", "medium tempo"] | 6 | aeDZVfGk7bk | 3563 | |
BEST Guitar Tapping EVER 2!!!! | someone is playing a distorted e-guitar. Playing a melody using finger tapping. This is an amateur recording. This song may be playing at home practicing finger tapping guitar. | 2011-07-03T09:00:26Z | Angel Rising Guitar Channel | FREE download of my 1st album at http://www.sutros.com/listenangel TABS Here http://www.listenangel.com/pages/tabs/guitar-hero-2.html | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["e-guitar", "finger tapping", "amateur recording", "medium tempo"] | 6 | kGo-dAQXtsA | 4305 |
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;