musiccaps_details (view)
3 rows where musiccaps_aspects contains "medium tempo", musiccaps_author = 7 and musiccaps_names contains "Vocal music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- medium tempo · 3 ✖
- acoustic guitar accompaniment 1
- amateur beat boxer 1
- anthem 1
- bad beat boxing 1
- baritone 1
- bass 1
- beatboxing 1
- beatboxing failed attempt 1
- bouncy 1
- choral harmony 1
- club music 1
- crowd cheering 1
- crowd hooting 1
- devotion 1
- emotional 1
- energetic 1
- enthusiastic 1
- female singer 1
- female voice speaking 1
- foreign language 1
- fresh 1
- fresh punchy 1
- funky 1
- funky bass line 1
- funny 1
- gig 1
- greek song 1
- hand drums 1
- hand percussion 1
- instrumental 1
- intense 1
- keyboard harmony 1
- live performance 1
- love 1
- loyalty 1
- lucid vocals 1
- male harmony 1
- passionate 1
- patriotic 1
- patriotism 1
- perky vocals 1
- pop 1
- punchy 1
- sentimental 1
- slick drumming 1
- sound of chatter 1
- spirited 1
- sticks 1
- tambourine 1
- tenor 1
- unity 1
- upbeat groove 1
- vocal percussion 1
- youthful 1
musiccaps_names (array) 9 ✖
- Vocal music · 3 ✖
- Music 2
- Beatboxing 1
- Chant 1
- Folk music 1
- Mantra 1
- Singing 1
- Soul music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Η γη των μακεδόνων. Τhe Land of the Macedonians. TRADITIONAL Folklore Music | A male chorus sings this passionate song in a foreign language which sounds like Greek. The song is medium tempo with hand percussion like drums, small hand drum, tambourine and a beat with sticks. The vocals are emphatic and sung in lively parts. The song is passionate, emotional, sentimental, and sounds like an anthem or a love song for the Country or a Leader. | 2010-03-08T11:03:55Z | Florinamak | http://florinamak.blogspot.com/2010/03/blog-post.html H ΓΗ ΤΟΥ ΜΕΓΑΛΕΞΑΝΔΡΟΥ Η γη του Μεγαλέξανδρου η γη των Μακεδόνων Η γη του Μεγαλέξανδρου η γη των Μακεδόνων ήταν και θα ναι ελληνική το καμάρι των αιώνων ήταν και θα ναι ελληνική το καμάρι των αιώνων Απ το βορά ως το νοτιά Ανατολή και Δύση Απ τον βορά ως το νοτιά Ανατολή και Δύση Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσειιιι ΤΑ ΤΡΑΓΟΥΔΙΑ ΤΗΣ ΜΑΚΕΔΟΝΙΑΣ ΤΕΡΖΗΣ ΜΠΑΓΙΩΚΗΣ | ["Mantra", "Chant", "Folk music", "Music", "Vocal music"] | ["male harmony", "medium tempo", "foreign language", "greek song", "anthem", "hand percussion", "tambourine", "hand drums", "sticks", "choral harmony", "unity", "patriotic", "anthem", "patriotism", "passionate", "emotional", "sentimental", "love", "devotion", "loyalty", "intense", "tenor", "baritone", "bass"] | 7 | 2JnlmS1zzls | 352 | |
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 | |
bu çocuk muhteşem | This clip is an amateur attempt at beatboxing. The tempo is medium and the beat is Catchy but it is a failed attempt at imitating digital drums. There is a female voice speaking in foreign language. | 2007-06-20T07:36:43Z | vefa82 | komik,kozanli,akp,korku,eğlence,oyun, | ["Beatboxing", "Speech", "Vocal music"] | ["instrumental", "medium tempo", "beatboxing", "vocal percussion", "amateur beat boxer", "funny", "female voice speaking", "beatboxing failed attempt", "bad beat boxing"] | 7 | j4A1ObGurUk | 4233 |
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;