musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Psychedelic rock" sorted by musiccaps_names
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- uptempo · 2 ✖
- acoustic drums 1
- alternative/indie 1
- amateur recording 1
- cheerful energy 1
- crowd cheering 1
- deeper male voice singing 1
- e-bass 1
- e-guitar 1
- electric guitar chords 1
- groovy 1
- groovy repetitive bass guitar 1
- harsh 1
- harsh electric guitar solo melody 1
- low quality 1
- muffled 1
- noisy 1
- percussive toms 1
- reverberant 1
- rock&roll 1
- shimmering shakers 1
musiccaps_names (array) 6 ✖
- Music 2
- Psychedelic rock · 2 ✖
- Rock music 2
- Funk 1
- Shout 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gilmour, Wright & Mason: Pink Floyd - Arnold Layne live FULL VERSION | This song contains an acoustic drum playing along to a e-guitar strumming chords before breaking into a more silent part with the e-bass repeating the same note. The e-guitar is playing a simple short melody with delay. Then a deeper male voice is singing and the crowd starts cheering. This recording is in bad audio-quality. This song may be playing at a live concert. | 2007-05-11T07:57:44Z | Andrew Burgess | Pink Floyd's David Gilmour, Rick Wright and Nick Mason stun me and the rest of the audience by turning up and playing Arnold Layne during a tribute evening to the late Syd Barrett. Madcaps Last Laugh @ the Barbican, London, 10th May 2007. | ["Music", "Psychedelic rock", "Rock music", "Shout"] | ["amateur recording", "rock&roll", "e-guitar", "acoustic drums", "e-bass", "crowd cheering", "deeper male voice singing", "uptempo", "cheerful energy"] | 6 | oKab6-syQD4 | 4617 | |
Old file.........new knife | The low quality recording features an alternative/indie song that consists of electric guitar chords, groovy repetitive bass guitar, harsh electric guitar solo, percussive toms and shimmering shakers. It sounds muffled, harsh, groovy and it is uptempo and noisy. | 2013-08-16T09:47:12Z | Toothbeard knives | A start to finish slideshow of my last 2 knives aug 2013 | ["Swing music", "Funk", "Music", "Psychedelic rock", "Rock music"] | ["low quality", "alternative/indie", "muffled", "harsh", "noisy", "electric guitar chords", "groovy repetitive bass guitar", "harsh electric guitar solo melody", "percussive toms", "shimmering shakers", "reverberant", "uptempo", "groovy"] | 4 | xrqDoBor2dk | 5356 |
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;