musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "shimmering open hat" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- groovy bass · 5 ✖
- low quality 5
- shimmering open hat · 5 ✖
- noisy 3
- 4 on the floor kick 2
- energetic 2
- mono 2
- thin 2
- addictive 1
- afrobeats 1
- bouncy snare 1
- car engine sound effects 1
- clapping 1
- disco 1
- fruity male vocal 1
- fun 1
- funk 1
- funky keys melody 1
- groovy 1
- happy 1
- harmonized children vocals 1
- harmonizing background vocals 1
- harmonizing vocals 1
- high pitched sustained string melody 1
- high pitched tire screech 1
- laughing 1
- low flat male vocal 1
- low toms 1
- messy 1
- muffled punchy snare 1
- passionate male vocal 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- quiet 1
- reggae 1
- repetitive male vocal melody 1
- repetitive synth lead melody 1
- saxophone solo melody 1
- shimmering bells melody 1
- shimmering hi hats 1
- shimmering shakers 1
- static tv sound effect 1
- suspenseful 1
- syncopated rimshots 1
- synth keys melody 1
- unbalanced stereo 1
- vocal chants 1
- voice crack 1
- wide funky electric guitar chords 1
- wooden percussive elements 1
musiccaps_names (array) 9 ✖
- Music 5
- Christian music 1
- Christmas music 1
- Funk 1
- Music of Africa 1
- Rattle (instrument) 1
- Rhythm and blues 1
- Tambourine 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Big Mama Sound - Dub Plate Mix | The low quality recording features a reggae song sung by low flat male vocals, followed by repetitive synth lead melody, groovy bass, vocal chants, claps, punchy kick hits, shimmering hi hats and open hats. It sounds energetic, suspenseful and it is in mono. At one point the vocal cracks and it sounds out of tune for a split second. | 2010-01-06T22:42:54Z | Lila2339 | Big Mama Sound - Dub Plate Mix | ["Music", "Rhythm and blues", "Zing"] | ["low quality", "reggae", "low flat male vocal", "repetitive synth lead melody", "groovy bass", "punchy kick", "clapping", "shimmering hi hats", "shimmering open hat", "vocal chants", "energetic", "suspenseful", "mono", "voice crack"] | 4 | AcX1B_Pr-RQ | 1145 | |
oi kampanes xtipoun-one (+lyrics) | The low quality recording features a disco song that consists a fruity male vocal singing over groovy bass, punchy "4 on the floor" kick pattern, wide funky electric guitar chords, shimmering open hats, muffled punchy snare, shimmering bells melody, groovy bass, high pitched sustained strings melody and low toms. There is a short snippet of harmonizing vocals at the end of the loop. It sounds energetic and addictive. | 2008-12-01T02:18:28Z | vickoulla | Στίχοι: Μαίρη Ελευθεριάδη Μουσική: George Michael Πρώτη εκτέλεση: One Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Πέρσι για πρώτη φορά Σου χάρισα τη καρδιά μου Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Φέτος μες στη παγωνιά Ζητώ πίσω τη καρδιά μου Στο τζάκι η φωτιά Στην αγκαλιά σου να μου λες "Χρόνια Πολλά" Σαν και πέρσι μου πες σ'αγαπώ Ήτανε Χριστούγεννα και θες να σου το πω Στο δέντρο τ'αστέρι μας κοιτούσε Η καρδιά στα στήθια μου ριγούσε Κι ήτανε τόσο μαγικά Σα να'χα γεννηθεί ξανά για πρώτη φορά Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Πέρσι για πρώτη φορά Σου χάρισα τη καρδιά μου Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Φέτος μες στη παγωνιά Ζητώ πίσω τη καρδιά μου Μα ξυπνώ γύρω ερημιά Όνειρο ήταν μονάχα,όνειρο ήταν μονάχα Πήρες τη καρδιά μου Ναι,δεν είσαι πια κοντά μου, μα Δε θα κλάψω,δε θα λυπηθώ Μια άλλη αγάπη θα βρώ στο κόσμο αυτό Να μου δώσεις τη καρδιά μου μόνο πίσω ζητώ Να μου δώσεις τη καρδιά μου μόνο πίσω ζητώ Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Πέρσι για πρώτη φορά Σου χάρισα τη καρδιά μου Πέφτει το χιόνι απαλά Κι οι καμπάνες κτυπούν Χριστούγεννα Φέτος μες στη παγωνιά Ζητώ πίσω τη καρδιά μου | ["Christmas music", "Christian music", "Music"] | ["low quality", "disco", "fruity male vocal", "harmonizing background vocals", "wide funky electric guitar chords", "punchy \"4 on the floor\" kick pattern", "shimmering open hat", "muffled punchy snare", "shimmering bells melody", "groovy bass", "high pitched sustained string melody", "low toms", "energetic", "addictive"] | 4 | D3ht_xXl5S0 | 1432 | |
Wildfire - Dance With Me - FUNK | The low quality recording features a funk song that consists of passionate male vocal singing over shimmering open hats and shakers, funky and groovy keys melody, groovy bass, wooden percussive elements and "4 on the floor" kick pattern. It is noisy, but also funky and the stereo image is unbalanced, as the song is leaning towards the right channel. | 2015-06-21T00:15:31Z | Djegu | Wild Fire – WFP-0003 http://www.discogs.com/Wildfire-Time-Is-The-Answer/release/3557173 http://www.juno.co.uk/products/tropical-disco-hustle-volume-2/569473-01/ | ["Music of Africa", "Funk", "Music"] | ["low quality", "funk", "funky keys melody", "shimmering shakers", "shimmering open hat", "passionate male vocal", "wooden percussive elements", "groovy bass", "4 on the floor kick", "noisy", "unbalanced stereo"] | 4 | DdxW_JziHTA | 1500 | |
Kizomba Dance | The low quality recording features an afrobeats song played on speaker in a medium size room, and it consists at least syncopated rimshots, shimmering open hats, synth keys melody, groovy bass, repetitive male vocal melody and harmonizing vocals layered with it. Even though the recording is noisy, thin, messy and in mono, it still sounds groovy and like something you would want to dance to. | 2013-01-28T16:55:25Z | Zlatan Vlad | Sara Lopez and Albir Rojas Music : To Semedo-P`ra Ti | ["Music", "Tambourine"] | ["low quality", "afrobeats", "syncopated rimshots", "shimmering open hat", "synth keys melody", "repetitive male vocal melody", "harmonizing vocals", "mono", "noisy", "thin", "messy", "groovy bass", "groovy"] | 4 | dvDSgmqbrM0 | 3826 | |
WAKE, RATTLE & ROLL Episode 2 part 1 | The low quality recording features a song that consists of harmonized children vocals singing over bouncy snare, saxophone solo melody, groovy bass, shimmering open hats and "4 on the floor" kick pattern. There are some laughing, high pitched tire screeches and car engine sound effects in the background. The recording is very noisy and the song is quiet and thin, as it lacks bass frequencies, but it still sounds fun and happy - like something you would hear in TV shows for kids. | 2008-10-08T19:05:34Z | Jack Box | A new episode! | ["Music", "Rattle (instrument)"] | ["low quality", "quiet", "noisy", "fun", "happy", "harmonized children vocals", "bouncy snare", "thin", "laughing", "car engine sound effects", "static tv sound effect", "high pitched tire screech", "saxophone solo melody", "groovy bass", "shimmering open hat", "4 on the floor kick"] | 4 | mQM3Fd3eN9E | 4470 |
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;