musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "fruity male vocal" and musiccaps_aspects contains "groovy bass" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- fruity male vocal · 4 ✖
- groovy bass · 4 ✖
- low quality 4
- low toms 2
- addictive 1
- brass stabs 1
- clapping 1
- cool 1
- country blues 1
- disco 1
- electric guitar melody 1
- emotional 1
- energetic 1
- energetic crash 1
- exciting 1
- groovy 1
- groovy electric guitar melodies 1
- happy 1
- harmonizing background vocals 1
- high pitched sustained string melody 1
- joyful 1
- mellow snare 1
- muffled punchy snare 1
- noisy 1
- nostalgic 1
- passionate 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- punchy snare 1
- shimmering bells melody 1
- shimmering cymbals 1
- shimmering open hat 1
- shimmering shakers 1
- soft kick hits 1
- southern rock 1
- steel drums melody 1
- sustained organ keys chord 1
- uptempo 1
- vintage 1
- wide electric guitar melody 1
- wide funky electric guitar chords 1
musiccaps_names (array) 14 ✖
- Music 4
- Singing 2
- Blues 1
- Christian music 1
- Christmas music 1
- Country 1
- Dance music 1
- Funk 1
- Jazz 1
- Music of Latin America 1
- Pop music 1
- Rhythm and blues 1
- Swing music 1
- Theme music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
WWE NXT New Official Theme Music - Wild & Young | The low quality recording features a southern rock song that consists of a fruity male vocal singing over groovy bass guitar, low toms and wide electric guitar melody. It sounds emotional and nostalgic. | 2010-02-21T17:26:22Z | UniverseOfWWE | ["Theme music", "Jazz", "Music", "Pop music", "Dance music"] | ["low quality", "southern rock", "wide electric guitar melody", "groovy bass", "low toms", "fruity male vocal", "emotional", "nostalgic"] | 4 | 53UF6F7D284 | 629 | ||
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Boom Boom Room-J Paul Jr. | The low quality recording features a fruity male vocal singing over steel drums melody, electric guitar melody, brass stabs, punchy kick and snare hits, energetic crash cymbal, groovy bass, shimmering shakers and sustained organ keys chord. It sounds joyful, happy and exciting. | 2011-07-14T03:42:01Z | Bigzydecohal21 | Let Tha Rebel take u to the Boom Boom Room | ["Singing", "Funk", "Music"] | ["low quality", "steel drums melody", "electric guitar melody", "brass stabs", "sustained organ keys chord", "punchy snare", "punchy kick", "groovy bass", "energetic crash", "fruity male vocal", "shimmering shakers", "joyful", "happy", "exciting"] | 4 | d61plJ66vE8 | 3762 | |
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 |
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;