musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-10-02 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality 2
- acoustic guitar 1
- blues 1
- boomy 1
- brass solo melody 1
- classical 1
- emotional 1
- filtered monotone male vocal 1
- flamenco 1
- flute lick 1
- groovy bass 1
- groovy organ keys chords 1
- instrumental 1
- joyful 1
- noisy 1
- percussion 1
- poor mix 1
- punchy snare 1
- repeating theme 1
- shimmering cymbals 1
- soft kick hits 1
- spanish 1
- sustained brass melody 1
musiccaps_names (array) 8 ✖
- Music 2
- Brass instrument 1
- Flamenco 1
- French horn 1
- Grunge 1
- Orchestra 1
- Trombone 1
- Trumpet 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hellsing Opening (Full Song) | The low quality recording features a blues song that consists of filtered monotone male vocal singing over groovy bass, groovy organ keys, chords, soft kick hits, punchy snare and shimmering cymbals. The song is poorly mixed, as the vocals are not so much in the face as they should be, probably because the bass is eating the other elements - making it sound boomy. | 2008-10-02T19:30:20Z | M00skit0 | Hellsing Op. Full. Yasushi Ishii - Logos naki World | ["Music", "Grunge"] | ["blues", "punchy snare", "groovy bass", "filtered monotone male vocal", "shimmering cymbals", "soft kick hits", "groovy organ keys chords", "boomy", "low quality", "poor mix"] | 4 | d-KxsdWX9xE | 3754 | |
Blue Bells of Scotland - SBO Perg | The low quality recording features a classical song that consists of a brass solo melody played over sustained brass melody and short flute lick. It sounds emotional, joyful and the recording is noisy. | 2008-10-02T07:05:43Z | bgbtvmusik | Solostück für Posaune Solist Emil Haderer aufgenommen am 9.4.2005 im Turnsaal der Hauptschule Baumgartenberg, Sinfonisches Blasorchester Perg (SBO) Leitung: Harald Buchner | ["Brass instrument", "French horn", "Orchestra", "Trombone", "Trumpet"] | ["low quality", "noisy", "classical", "flute lick", "brass solo melody", "sustained brass melody", "emotional", "joyful"] | 4 | dbBlYyaFKTQ | 3800 | |
(Full) Oogie Boogie's Song - Rodrigo y Gabriela [HQ] | This music is a flamenco piece. There are two acoustic guitars, one playing the leading arpeggio melody and the other creating the rhythmic background by strumming the chords. The characteristics of the song makes it clear that it is influenced by Spanish music. It could be used in a thriller movie soundtrack or as a flamenco dance accompaniment piece for dancing courses. | 2008-10-02T07:06:54Z | HSMRocksMedia | Nightmare Revisited Oogie Boogie's Song - Rodrigo y Gabriela No copyright infringement intended | ["Flamenco", "Music"] | ["flamenco", "acoustic guitar", "percussion", "instrumental", "repeating theme", "spanish"] | 9 | fow1TC_MpHs | 3977 |
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;