musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_names contains "Bass guitar" and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
musiccaps_names (array) 10 ✖
- Acoustic guitar 2
- Bass guitar · 2 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Strum · 2 ✖
- Flamenco 1
- Happy music 1
- Plucked string instrument 1
- Speech 1
musiccaps_aspects (array) 10 ✖
- acoustic guitar · 2 ✖
- classical atmosphere 1
- exotic 1
- fingerstyle-guitar 1
- flamenco 1
- jam 1
- male voice 1
- medium tempo 1
- review 1
- sensual 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Doraemon guitar music | This audio contains an acoustic guitar. The piece is played in fingerstyle. Meaning that the chords and the melody are played at the same time. The guitar has some reverb on it. This song may be playing live at an art gallery. | 2006-07-14T12:51:19Z | fenderld | Doraemon music ,china men play guitar | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Happy music"] | ["fingerstyle-guitar", "acoustic guitar", "medium tempo", "classical atmosphere"] | 6 | 07FxCXxknY4 | 123 | |
Paco de Lucia plays an Erez Perelman Flamenco Guitar Part 1 | This is an instrument review jam that is played in the style of flamenco music. There is an acoustic guitar being played while a male voice gives his opinion concerning the instrument. The character of the sound is sensual. The guitar sounds can be sampled for use in beat-making. | 2011-11-22T11:13:27Z | Erez Perelman | Order Your Handmade Classical or Flamenco Guitar Here: http://erez-perelman.com/contact/ Paco de Lucias playing Erez Perelman flamenco guitar. | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["jam", "flamenco", "acoustic guitar", "male voice", "review", "exotic", "sensual"] | 9 | axqtExFY5-s | 3590 |
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;