musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate solo acoustic guitar melody" and musiccaps_author = 4 sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- passionate solo acoustic guitar melody · 2 ✖
- acoustic rhythm guitar chords 1
- cover 1
- elegant 1
- emotional 1
- jazz 1
- low quality 1
- noisy 1
- passionate 1
- playback 1
- rock 1
- simple double bass 1
- smooth 1
- staccato strings melody 1
musiccaps_names (array) 8 ✖
- Guitar 2
- Mandolin 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Bluegrass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maxwell Swing by Texas Gypsies | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | 2012-07-31T05:33:50Z | maxwellswing | Original Gypsy Jazz tune by Texas Gypsies from the Cafe du Swing CD! www.texasgypsies.com Photos by John Heiman, Bruce Buhrow, Chad Windham,David Meadows | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | 4 | AmAThmRphk0 | 1168 | |
"September" by Andy Timmons | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | 2006-04-17T07:15:29Z | aristocrap | A beautiful song by the tone king himself. | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | 4 | 36ToDxW_hns | 441 |
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;