musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "arpeggiated acoustic guitar melody", musiccaps_aspects contains "joyful" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- arpeggiated acoustic guitar melody · 2 ✖
- emotional 2
- joyful · 2 ✖
- low quality 2
- acoustic rhythm guitar chords 1
- chime bells 1
- country 1
- crowd cheering 1
- groovy bass 1
- mandoline melody 1
- passionate 1
- plucked strings melody 1
- shimmering bells melody 1
- sustained strings melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pichenda | The low quality recording features an arpeggiated acoustic guitar melody, shimmering bells melody, plucked strings melody and sustained strings melody, followed by chime bells. There are some crowd cheering noises in the background. It sounds emotional and joyful. | 2007-06-24T01:34:04Z | khmrch1cca | RHM Vol. 52 | ["Bell", "Music"] | ["low quality", "crowd cheering", "arpeggiated acoustic guitar melody", "shimmering bells melody", "chime bells", "plucked strings melody", "sustained strings melody", "emotional", "joyful"] | 4 | LTDle_h2YD8 | 2191 | |
hero of the day - in bluegrass style - iron horse | The low quality recording features a country song that consists of a passionate male vocal singing over arpeggiated acoustic guitar melody, acoustic rhythm guitar chords, mandoline guitar melody and groovy bass. It sounds passionate, joyful and emotional. | 2008-01-06T16:36:25Z | oddis123 | Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc | ["Country", "Music", "Bluegrass"] | ["low quality", "country", "groovy bass", "arpeggiated acoustic guitar melody", "acoustic rhythm guitar chords", "mandoline melody", "passionate", "joyful", "emotional"] | 4 | dzPPmuFUicc | 3832 |
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;