musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_names contains "Foghorn" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- instrumental · 3 ✖
- acordion 1
- aerophone 1
- amateur music recording 1
- background music 1
- brass band 1
- brass instrument 1
- buzzing 1
- cheerful 1
- classical 1
- counting 1
- counting in french 1
- emotional 1
- fast tempo 1
- french horn 1
- french horn tutorial 1
- happy 1
- holding notes 1
- hot signal 1
- humming 1
- intricately coiled instrument 1
- keeping beat 1
- male voice 1
- male voice speaking 1
- meditative 1
- melancholic 1
- melodious harmony 1
- merry 1
- monotone 1
- ominous music 1
- organ playing chords 1
- passionately 1
- pensive 1
- pleasant harmonious 1
- poor audio quality 1
- rich 1
- sad 1
- saxophone 1
- slow tempo 1
- song intro 1
- the horn 1
- trombone 1
- trumpet 1
- tuba 1
- tutorial 1
- unpleasant 1
- wind instrument 1
- wind instruments 1
- wood wind 1
musiccaps_names (array) 9 ✖
- Foghorn · 3 ✖
- Musical instrument · 3 ✖
- Brass instrument 2
- Music 2
- Bass guitar 1
- Guitar 1
- Plucked string instrument 1
- Speech 1
- Trombone 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 | ||
Tocata Enxovia CCB (Rancho do Ezequiel) | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | 2016-10-10T21:54:41Z | Doglinha Vieira | Acordeon Fabricio Sousafone Doglinha Trombone Ezequiel Saxofone Everton | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | 7 | rOOBAGxxjBk | 4873 | |
Michael Manring "Adhan" | The song is an instrumental. The tempo is slow with an organ playing sustained chords. The audio quality is poor with a lot of hissing and strong gains that are distorted. The song is background music for a home video. The song is emotional and ominous. | 2007-12-06T05:04:31Z | Brian Wilson | Mr Manring, Hyperbass and 2 eBowS. Michael says this song was inspired by the sounds of the Muslim call to prayer. Haters telling me to take this down because it's blasphemy? Get an afterlife. | ["Bass guitar", "Guitar", "Foghorn", "Music", "Musical instrument", "Plucked string instrument"] | ["poor audio quality", "ominous music", "song intro", "meditative", "pensive", "melancholic", "slow tempo", "organ playing chords", "buzzing", "humming", "hot signal", "background music", "sad", "emotional", "instrumental", "amateur music recording", "unpleasant", "passionately"] | 1 | xx1RccwlF5g | 5365 |
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;