musiccaps_details (view)
2 rows where musiccaps_aspects contains "calming", musiccaps_author = 4 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_names (array) 10 ✖
- Music 2
- Musical instrument · 2 ✖
- Acoustic guitar 1
- Classical music 1
- Guitar 1
- Inside, large room or hall 1
- Jazz 1
- Orchestra 1
- Plucked string instrument 1
- Strum 1
musiccaps_aspects (array) 10 ✖
- calming · 2 ✖
- low quality 2
- noisy 2
- relaxing 2
- hydraulophone melody 1
- jazzy electric guitar melody 1
- mono 1
- mystical 1
- water leaking 1
- wide 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fingerstyle Jazz Guitar Improv - Jody Fisher | The low quality recording features a jazzy electric guitar melody. The recording is noisy and it is in mono - regardless, it sounds calming and relaxing. | 2006-02-23T23:43:33Z | workshoplive | http://www.workshoplive.com/index.cfm?WT.mc_id=YTJZGIT-JF1 Jody Fisher, one of our jazz instructors at workshoplive, took some time to jam some jazz musings on his Klein electric guitar. Enjoy Jody's music! | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jazzy electric guitar melody", "low quality", "mono", "noisy", "calming", "relaxing"] | 4 | 476vNb6thyM | 540 | |
Hydraulophone in concert | The low quality recording features a hydraulophone melody played alongside water leaking sound. The recording is wide, noisy and it sounds relaxing and calming. | 2007-04-12T01:31:06Z | hydraulist | Suite for Hydraulophone, as performed by Ryan Janzen in the Great Hall, with the Hart House Symphonic Band. This is the world's first orchestral performance in which instruments make sound from all three states of matter (solid, liquid, and gas). Other orchestras use only 2 states of matter: solid (percussion and strings), and gas (wind instruments). For more videos, see www.splashtones.com | ["Music", "Musical instrument", "Orchestra", "Classical music", "Inside, large room or hall"] | ["low quality", "hydraulophone melody", "water leaking", "noisy", "wide", "mystical", "calming", "relaxing"] | 4 | tnJb9WyhCUc | 5066 |
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;