musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- energetic · 2 ✖
- accordion melody 1
- addictive 1
- amateur band 1
- average audio quality 1
- cheerful 1
- childhood memories 1
- cymbals crashes 1
- disco 1
- excitement 1
- fruity male vocal 1
- full of cheer 1
- groovy bass 1
- guitar strumming rhythm 1
- happy 1
- harmonizing background vocals 1
- high pitched sustained string melody 1
- instrumental music 1
- low quality 1
- low toms 1
- medium tempo 1
- muffled punchy snare 1
- nostalgic 1
- pleasant 1
- punchy "4 on the floor" kick pattern 1
- shimmering bells melody 1
- shimmering open hat 1
- steady marching drumming rhythm 1
- train journey 1
- walking bass line 1
- wide funky electric guitar chords 1
- wonder 1
musiccaps_names (array) 3 ✖
- Christmas music · 2 ✖
- Music 2
- Christian music 1
youtube_published (date) 2 ✖
- 2008-12-01 1
- 2016-07-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) | The song is an instrumental. The song is medium tempo with a walking bass line, steady drumming rhythm with cymbal crashes, guitar strumming rhythm and an accordion playing melody. The song is background music for a toy hobbyist video. The song is cheerful and reminiscent of a childhood adventure. | 2016-07-12T20:16:51Z | TrainWorldTV | LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) http://www.trainworld.com The model railroad equipment & accessories we sell are not toys, and are not intended for use by children under the age of 14, | ["Christmas music", "Music"] | ["instrumental music", "steady marching drumming rhythm", "nostalgic", "full of cheer", "average audio quality", "wonder", "accordion melody", "cymbals crashes", "guitar strumming rhythm", "walking bass line", "pleasant", "cheerful", "happy", "energetic", "excitement", "train journey", "childhood memories", "medium tempo", "amateur band"] | 1 | BsLFQV8HVZE | 1298 | |
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;