musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "acoustic rhythm guitar" and musiccaps_aspects contains "instrumental" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 10 ✖
- acoustic rhythm guitar · 1 ✖
- addictive 1
- electric guitar chord progression 1
- energetic 1
- groovy bass 1
- instrumental · 1 ✖
- low quality 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
musiccaps_names (array) 2 ✖
- Exciting music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Silversun Pickups - Kissing Families [Official Music Video] | The low quality recording features a rock song instrumental that consists of shimmering hi hats, punchy snare, groovy bass guitar, acoustic rhythm guitar in the left channel and electric guitar chord progression in the right channel of the stereo image. It sounds energetic and addictive. | 2009-03-20T17:08:17Z | Silversun Pickups | Directed by Suzie Vlcek Get PIKUL here: http://smarturl.it/sspupikulEP http://silversunpickups.com http://twitter.com/sspu http://instagram.com/sspu http://facebook.com/silversunpickups | ["Music", "Exciting music"] | ["low quality", "rock", "instrumental", "shimmering hi hats", "punchy snare", "groovy bass", "acoustic rhythm guitar", "electric guitar chord progression", "energetic", "addictive"] | 4 | -XN0NtrnfMY | 58 |
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;