musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering shakers", musiccaps_author = 4 and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 2
- shimmering shakers · 2 ✖
- alternative/indie 1
- bells melody 1
- big band 1
- electric guitar chords 1
- euphoric 1
- fun 1
- groovy 1
- groovy repetitive bass guitar 1
- happy 1
- harsh 1
- harsh electric guitar solo melody 1
- muffled 1
- noisy 1
- nostalgic 1
- percussive toms 1
- piano chords progression 1
- reverberant 1
- shimmering cymbals 1
- smooth bass 1
- soft kick 1
- tinny percussive elements 1
- tom rolls 1
- uptempo 1
- vintage 1
- wide reverberant brass section melody 1
musiccaps_names (array) 5 ✖
- Music 2
- Swing music · 2 ✖
- Funk 1
- Psychedelic rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
James Last - Happy Music | The low quality recording features a big band song that consists of wide reverberant brass section melody, shimmering shakers and cymbals, bells melody, piano chord progression, smooth bass and soft kick hits. There are some tom rolls that represent a transition into the next section. It sounds happy and fun, but it also gives off euphoric and nostalgic vibes, as it sounds vintage. | 2009-10-19T14:24:00Z | anggip lesmana | JAMES LAST didn't burst forth on the popular music scene with a fanfare of trumpets and explosions of fire-work. He just sort of emerged in a quiet cloak of talent. For three years running LAST was voted best bass player in a German jazz poll. But the minute he found out that having an orchestra and being able to experiment with hit songs was much more satisfying and rewarding, JAMES LAST was on the way to becoming a true giant in the world of today popular music. The remarkable abilities as a bass player are only part of his musical talent. He also is an accomplished songwriter, arranger and bandleader. | ["Swing music", "Music"] | ["low quality", "big band", "wide reverberant brass section melody", "shimmering cymbals", "shimmering shakers", "tinny percussive elements", "tom rolls", "bells melody", "piano chords progression", "smooth bass", "soft kick", "happy", "fun", "nostalgic", "euphoric", "vintage"] | 4 | VnJeG9RGUVM | 3031 | |
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;