musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-06-18 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- instrumental 2
- aerophone 1
- amateur recording 1
- ambient sounds 1
- brass instrument 1
- breeze 1
- chill 1
- counting 1
- counting in french 1
- easygoing 1
- french horn 1
- french horn tutorial 1
- groovy bass 1
- holding notes 1
- incoherent music 1
- inferior audio recording 1
- intricately coiled instrument 1
- keeping beat 1
- low quality 1
- male voice 1
- male voice speaking 1
- medium tempo 1
- melodious 1
- monotone 1
- muddled audio 1
- muffled snare 1
- noisy 1
- offbeat piano chords 1
- people talking 1
- reggae 1
- rich 1
- shimmering hi hats 1
- steel drum 1
- steel pan 1
- the horn 1
- tinny percussive elements 1
- tutorial 1
- white noise 1
- wide harmonizing low male vocals 1
- wind instrument 1
musiccaps_names (array) 8 ✖
- Music 2
- Brass instrument 1
- Echo 1
- Foghorn 1
- Musical instrument 1
- Reggae 1
- Speech 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Corno Francés II | This music is an instrumental tutorial. A male musician is keeping count in French to the drone-like tune of a French Horn. The audio is not clear and has a lot of static. | 2009-06-18T02:11:08Z | orquestachile | ["Brass instrument", "Foghorn", "Musical instrument", "Speech"] | ["instrumental", "monotone", "male voice", "brass instrument", "wind instrument", "aerophone", "rich", "intricately coiled instrument", "the horn", "french horn", "counting in french", "male voice speaking", "counting", "keeping beat", "tutorial", "french horn tutorial", "holding notes"] | 7 | gX9OuOKLLTQ | 4036 | ||
Echo Sound System - Echo Sound (None A Jah Jah Children Riddim) | The low quality recording features a reggae song that consists of wide harmonizing low male vocals singing over groovy bass, muffled snare, shimmering hi hats, tinny percussive elements and offbeat piano chords. The recording is noisy and it sounds easygoing and chill. | 2009-06-18T03:20:15Z | Voxcesar Selektah | Album:Tempo Vai Dizer, Artist: Echo Sound System & General Smiley Year: 2005 , Label: Phantom , Tracks: 21 | ["Echo", "Music", "Reggae"] | ["reggae", "low quality", "wide harmonizing low male vocals", "offbeat piano chords", "groovy bass", "muffled snare", "tinny percussive elements", "shimmering hi hats", "noisy", "easygoing", "chill"] | 4 | yVWk3yq3Abc | 5415 | |
Trinidad Music - Youth plays steelpan - Indian Trail Church | This music is instrumental. The tempo is medium with a melodic steel pan harmony. The audio quality however is inferior and amateur,so the music is muddled. There are ambient sounds of breeze and people talking , indicating that this is a live performance. | 2009-06-18T20:47:10Z | Home and Happy. | A youth pannist plays at Indian Trails Open Bible Church. Steelpans (also known as steeldrums or pans, and sometimes collectively with musicians as a steelband) is a musical instrument and a form of music originating from Trinidad. Steelpan musicians are called pannists. | ["Music", "Steelpan"] | ["white noise", "instrumental", "medium tempo", "steel pan", "amateur recording", "muddled audio", "steel drum", "inferior audio recording", "incoherent music", "melodious", "ambient sounds", "people talking", "breeze"] | 7 | _ALGXHquYkM | 3450 |
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;