musiccaps_details (view)
8 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- amateur recording · 8 ✖
- traditional · 8 ✖
- bagpipes 4
- slower tempo 2
- uptempo 2
- anthem 1
- background voices 1
- bagpipe 1
- brass section 1
- crickets chirping 1
- drum rolls 1
- drums 1
- flute 1
- flutes 1
- guzheng 1
- kicks 1
- marching group 1
- medium tempo 1
- medium to uptempo 1
- side drum 1
- slow tempo 1
- snare rolls 1
- string instruments 1
- theremin 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pumpkins Fancy - Side Drum and Bagpipes | This audio contains someone playing bagpipes with something that sounds like a traditional piece. Someone is also playing a side drum snare along. This song may be playing on the street performed by buskers. | 2010-03-09T06:02:20Z | GreenCrystalRain | The same two musicians playing on the street in Edinborough, Scotland. Taken on a trip to Europe summer 2009. | ["Bagpipes", "Drum", "Wind instrument, woodwind instrument", "Percussion"] | ["amateur recording", "bagpipes", "side drum", "background voices", "uptempo", "traditional"] | 6 | 4_s5vHgfxnw | 586 | |
ทยอยใน เถา วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย | This song contains string instruments being played with a bow playing the main melody. Coming in after a flute starts playing the melody. An acoustic instrument is providing the rhythm. A guzheng is playing the same melody in a lower register. In the background you can hear crickets chirping. This song may be playing as a live performance from a music school. | 2012-03-05T21:28:19Z | Saisaw | ทยอยใน เถา จุฬาวาทิต ครั้งที่ ๑๗๐ วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย ควบคุมการบรรเลงโดย ศาสตราภิชานปกรณ์ รอดช้างเผื่อน และคณะ วันศุกร์ที่ ๒ มีนาคม ๒๕๕๕ เวลา ๑๗.๓๐ น. | ["Music", "Rattle (instrument)", "Bowed string instrument"] | ["traditional", "string instruments", "guzheng", "flute", "crickets chirping", "amateur recording", "medium tempo"] | 6 | 9m0tNvskmTc | 1039 | |
Шотланские волынки и барабаны у Исторического Музея | This audio contains people playing a melody with bagpipes in a higher pitch. This song may be playing live during a traditional and formal event. | 2009-09-10T08:42:20Z | Passynkov | Шотланские волынки и барабаны Королевского электро-механического инженерного корпуса Великобритании у Исторического Музея 09.09.09 в 19:30. Музыканты вышли из своей резиденции для разминки перед очередным выступлением на вечернем представлении фестиваля "Спасская Башня" . И простой московской публике, пришедшей к Красной Площади, точнее только к памятнику маршалу К. Жукову у Казанских Ворот и Манежной Площади, исполнили в течение 30 минут настоящее представление шотланской музыки. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["traditional", "bagpipes", "amateur recording", "slower tempo"] | 6 | OECgm1obaFs | 2413 | |
United States Service Medley | This audio contains drum-rolls in the background playing along with a brass section and flutes. In the foreground someone is playing the same melody on a theremin. This song may be practicing playing along with an instrument. | 2007-05-26T04:30:43Z | ThomasGrillo | http://www.thomasgrillo.com In honor of those who serve, and support the United States armed services. Thank You! U. S. Service Medley played by Thomas Grillo on Moog Etherwave Pro theremin with audio accompaniment by Centenial Concert Band. Next year's version will have the Air Force theme. Copyright 2007 Thomas Grillo | ["Music", "Theremin"] | ["anthem", "amateur recording", "theremin", "drum rolls", "flutes", "brass section", "medium to uptempo", "traditional"] | 6 | PFtcnQqLdEc | 2523 | |
Pulse Percussion 2011 Warm Up | This audio contains a lot of people playing a complex snare roll groove in synchronicity along with people playing bass drums. The bass drums are overloading the speakers of the recording. This composition may be playing for an army celebration. | 2011-04-04T02:49:34Z | Vivian Thornton | Great Oaks HS | ["Music", "Pulse", "Percussion"] | ["amateur recording", "marching group", "snare rolls", "kicks", "uptempo", "traditional"] | 6 | duMRKOb4E2w | 3825 | |
gaida gajda goat goat bagpipes Na Stojan Gosti mu dojdoa lele гајда гайда Risto Todoroski | Someone is playing a fast melody on bagpipes in the lower higher register accompanied by a base drone sound. This song may be playing during a traditional ceremony or event. | 2009-03-21T16:24:34Z | Risto Todoroski | Goat Bagipes (gaida) available from Risto. sirulsko@gmail.com. The bag with the goat's head is unusual in the Balkans - usually the leather is turned outward and there is no head, but Risto would play this type of gaida on special occasions like a wedding. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "bagpipes", "slow tempo", "traditional"] | 6 | f1NV9qTjOv8 | 3915 | |
Mull Of Kintyre mit Dudelsack | This audio contains someone playing a piece of music on a bagpipe. The music sounds traditional. This song may be playing at a folksfest. | 2008-03-26T19:21:45Z | Jürgen Rech | Mull of Kintyre von Paul McCartney, hier gespielt von Jürgen Rech auf dem schottischen Dudelsack. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "traditional", "bagpipe"] | 6 | kOREaTKeyZw | 4314 | |
Edinburgh Military Tattoo 2012 - Massed Pipes and Drums (1 of 3) | This audio contains a huge amount of people playing a melody on the bagpipes while others are playing a kick sound on every beat. This song may be playing live during a big public event. | 2012-08-11T14:29:06Z | darm49 | Edinburgh Military Tattoo - Wednesday 8th August 2012 Tunes: The Crofter Colin's Cattle The Herding Song Cutting Bracken Clean Please Strae The Wind that Shakes the Barley Na Goisidich Speed the Plough Bands: The Royal Scots Dragoon Guards The Royal Corps of Signals The Royal Highland Fusiliers, 2nd Battalion The Royal Regiment of Scotland The Black Watch, 3rd Battalion The Royal Regiment of Scotland The Highlanders, 4th Battalion The Royal Regiment of Scotland The Rats of Tobruk, Melbourne, Australia Australian Federal Police Pipes & Drums, Canberra, Australia The Manly Warringah Pie Band, Sydney, Australia The Cape Town Highlanders, South Africa The Canadian Army Pipes & Drums The Scots College Pipes & Drums, Sydney, Australia Queen Victoria School Pipes, Drums & Dancers, Dunblane, Scotland | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "bagpipes", "drums", "traditional", "slower tempo"] | 6 | w2MeQg3W7Po | 5231 |
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;