musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_names contains "Funk" and musiccaps_names contains "Swing music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- low quality 2
- uptempo 2
- acoustic drums 1
- acoustic guitars 1
- almost fast tempo 1
- alternative/indie 1
- bass guitar 1
- buzzy bass guitar 1
- chaotic 1
- drums 1
- e-bass 1
- electric guitar 1
- electric guitar chords 1
- energetic 1
- energetic drums 1
- filtered female vocal 1
- groovy 1
- groovy repetitive bass guitar 1
- harsh 1
- harsh electric guitar chords 1
- harsh electric guitar solo melody 1
- instrumental 1
- latin music 1
- loud 1
- male backing voices 1
- male voice singing/rapping 1
- muffled 1
- no voice 1
- noisy 1
- percussive toms 1
- …
musiccaps_names (array) 13 ✖
- Funk · 4 ✖
- Music 4
- Swing music · 4 ✖
- Music of Latin America 2
- Bass guitar 1
- Blues 1
- Music of Africa 1
- Pop music 1
- Psychedelic rock 1
- Rock music 1
- Salsa music 1
- Ska 1
- Song 1
youtube_published (date) 4 ✖
- 2010-03-19 1
- 2010-08-06 1
- 2012-01-16 1
- 2013-08-16 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DR. RING DING - "Latin Goes Ska" | The instrumental music features a medium sized band playing Latin music. The melody is being played in unison by the saxophones, trumpets and trombones in an almost fast tempo. A bass guitar is playing repeating lines in the low register. The drums play a busy rhythm. An electric guitar is playing a chord on the second half of every beat. | 2012-01-16T08:38:37Z | thegroverrecords | Album - DANDIMITE www.moskito-mailorder.com | ["Swing music", "Funk", "Music", "Music of Latin America", "Salsa music"] | ["trumpets", "saxophones", "trombones", "drums", "bass guitar", "electric guitar", "instrumental", "no voice", "latin music", "almost fast tempo"] | 2 | CuUu6L5hhMs | 1412 | |
Comb Your Hair by LoveStruck | The low quality recording features a rock song that contains filtered female vocal singing over loud and harsh electric guitar chords, energetic drums and buzzy bass guitar. It sounds chaotic due to the bad mix and since the drums are panned in an unconventional way - making the stereo image unbalanced. It sounds harsh, but also energetic. | 2010-03-19T19:57:05Z | stuspasm | LoveStruck is: Lady Anne, Vocals/ Guitar. Stu Spasm, Bass. Bloody Rich Hutchins, Drums. The band is based in Brooklyn, NYC. This song is out on Limited Edition 7" vinyl... http://www.myspace.com/lovestrucknyc or http://www.reverbnation.com/lovestrucknyc http://vimeo.com/9691399 http://www.facebook.com/pages/LoveStruck/118702 218460?ref=sgm http://garagepunk.ning.com/profile/LadyAnne | ["Blues", "Swing music", "Bass guitar", "Funk", "Music", "Pop music", "Song"] | ["low quality", "loud", "rock", "harsh electric guitar chords", "filtered female vocal", "energetic drums", "unbalanced stereo", "chaotic", "energetic", "buzzy bass guitar"] | 4 | uAgizG1hYw0 | 5096 | |
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 | |
DEUX ZACH SKA SKA apres une histoir vrais ... | This song sounds lightly uplifting. An e-bass is playing a repeating melody along with a guitar playing an almost melody at a higher key. Another acoustic guitar is strumming chords. The male voice is singing almost rapping/talking while backing voices are singing repeating the melody and phrases. This song may be playing outside on a bike on a sunny day. | 2010-08-06T23:42:32Z | zach deux | ["Swing music", "Music of Africa", "Funk", "Music", "Ska", "Music of Latin America"] | ["ska", "acoustic guitars", "shaker", "e-bass", "acoustic drums", "male voice singing/rapping", "male backing voices", "uptempo"] | 6 | 0OYlHvyfNk4 | 158 |
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;