musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-12-28 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- amateur recording 2
- background voices 1
- bagpipe 1
- bavarian folk music 1
- bells 1
- brass elements 1
- cheerful 1
- christmas music 1
- festive 1
- folkmusic 1
- happy 1
- holidays 1
- jingles 1
- live performance 1
- male vocal 1
- male voice speaking 1
- melodic singing 1
- no vocals 1
- poor quality 1
- positive 1
- schoenhut piano 1
- subtle strings 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Walkin on Edinburgh | A male voice is speaking. In the background you can hear other voices. Then someone starts playing a bagpipe in a higher register underlaying its own drone. This song may be played on the streets by a busker. | 2007-12-28T14:39:18Z | Edu Vedder | Last travel. Beautiful place Edimburgh. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["folkmusic", "amateur recording", "male voice speaking", "background voices", "bagpipe"] | 6 | r0I-G70gyo0 | 4842 | |
ICEBERG FULL OF PENGUINS | The track features a Christmas song with no vocals. The melody is very simple and it's played by a Schoenhut Piano that's accompanied by subtle strings. The atmosphere is positive and very Christmas-like. | 2007-12-28T23:18:22Z | Kitty B | the iceberg was full of penguin with rudolph antlers ,to tip the iceberg and to protect the tree. | ["Bell", "Music"] | ["christmas music", "jingles", "subtle strings", "holidays", "positive", "happy", "bells", "schoenhut piano", "no vocals"] | 5 | JCsuOzlwJqA | 1978 | |
Joachim Mattis on Tour Original bavarian bavaria music from Munich !! Bavariaband Bavarianband | This is an amateur recording of a Bavarian folk music performance. The audio quality is not that great. There is a male vocalist singing in the lead. Then, brass elements start playing a cheerful tune. There is a festive atmosphere in this recording. It could be playing in the background at an Oktoberfest event. | 2007-12-28T09:12:08Z | Alpenjockel | https://www.facebook.com/profile.php?id=100010674222667 | ["Music", "Happy music"] | ["bavarian folk music", "live performance", "amateur recording", "poor quality", "male vocal", "melodic singing", "brass elements", "cheerful", "festive"] | 9 | pHFHsubQVpg | 4695 |
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;