musiccaps_details (view)
4 rows where musiccaps_aspects contains "polka"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- polka · 4 ✖
- electronic drums 2
- european 2
- female vocal 2
- live performance 2
- playful 2
- accordion 1
- acoustic drums 1
- bass 1
- bowed strings 1
- cheerful 1
- comedic 1
- danceable 1
- deeper voice singing 1
- e-bass 1
- finnish techno pop 1
- folk 1
- folk dance 1
- keyboard 1
- lively 1
- lo-res 1
- male 1
- male vocal 1
- male vocal sample 1
- medium tempo 1
- orchestra 1
- remix 1
- slow tempo 1
- techno 1
- tuba 1
- vibrant 1
- winds 1
- yodel-like singing 1
- yodeling 1
musiccaps_names (array) 9 ✖
- Music 3
- Brass instrument 1
- Child singing 1
- Clarinet 1
- Electronic music 1
- Jingle (music) 1
- Reggae 1
- Techno 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Loituma - Ievan's Polkka (live, techno original version) | This is a finnish techno pop piece with polka influences. There is a female vocalist in the lead singing rapidly in a manner that resembles yodeling. A male vocalist occasionally joins her at a lower pitch while singing the melody. The melodic background consists of a keyboard tune and a simple bass line. The rhythmic background is provided by an electronic disco drum beat. The atmosphere is playful and danceable. This piece could be used in the background of a comedic social media content. It could also be played at children's events. | 2010-10-21T08:13:23Z | nestorrente | Loituma performs their song Ievan's Polkka in a rare techno version. | ["Electronic music", "Music", "Techno"] | ["finnish techno pop", "polka", "live performance", "male vocal", "female vocal", "yodel-like singing", "keyboard", "bass", "electronic drums", "european", "playful", "vibrant", "danceable", "medium tempo"] | 9 | 0i8VM_EooCs | 201 | |
BARITON POLKA - COLI | This is a live performance of a polka music piece. It is being performed by a wind orchestra. The main melody is being performed by the tuba. There is a lively, cheerful atmosphere to this piece. It could be used as an accompaniment piece for a European folk dance course. | 2009-04-23T09:58:11Z | Primož Beuc | KONCERT PIHALNEGA ORKESTRA VIDEM KRŠKO - SOLIST COLNER GREGA | ["Brass instrument", "Clarinet", "Trumpet"] | ["live performance", "polka", "orchestra", "winds", "tuba", "lively", "cheerful", "folk dance"] | 9 | 3q9K2PgA2-U | 507 | |
Hiss - Friedhofspolka | The bass and drums build the foundation of this song with a simple grove with kick and snare. The strings support the snare with short bow strokes being percussive elements of the song. The male voice is singing in the lower to mid range, he sounds like telling a story. This song may be playing at home, cleaning the house and singing along. | 2013-08-21T15:00:33Z | Kapelle Hiss | "Friehofspolka", ein Titel aus der DVD "10J Hiss" Live im Scala Ludwigsburg 2005 http://www.hiss.net/ https://de-de.facebook.com/HISS.BAND http://hiss.believeband.com/ | ["Jingle (music)", "Music", "Reggae"] | ["polka", "bowed strings", "accordion", "e-bass", "acoustic drums", "male", "deeper voice singing", "slow tempo"] | 6 | BRTHyoVgZT0 | 1238 | |
Roundabout Mayhem | This is a techno remix of a polka music piece. There is a female vocalist singing and yodeling. Once the remix kicks in, the male vocal sample can be heard singing a bass line. There is a loud electronic drum beat for the rhythmic background. The vocals have a slight sidechain effect on kick drum hits. The atmosphere is playful. The piece is in low resolution. This piece can be used in the background of funny social media content. | 2011-01-15T23:26:51Z | MonkeyWrenchDog | A German roundabout | ["Music", "Child singing"] | ["polka", "folk", "techno", "remix", "female vocal", "yodeling", "male vocal sample", "electronic drums", "lo-res", "european", "playful", "comedic"] | 9 | xuxKtxzq2Cs | 5363 |
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;