musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-06-22
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- addictive brass melody 1
- alternative rock 1
- atmospheric synthesiser 1
- claps 1
- disco 1
- energetic 1
- experimental 1
- flat male vocal 1
- funky 1
- funky synth lead melody 1
- grimelectronic music 1
- groovy 1
- groovy bass 1
- halluciatory 1
- harsh 1
- indie roc 1
- indie rock 1
- instrumental 1
- intense 1
- keyboard harmony 1
- live performance 1
- loud 1
- low quality 1
- meditative 1
- medium tempo 1
- messy 1
- mono 1
- muddy 1
- muffled male vocal 1
- noisy 1
- passionate 1
- pensive 1
- progressive rock 1
- psychedelic 1
- punchy kick 1
- punchy snare 1
- reggae 1
- rock 1
- shimmering cymbals 1
- simple hi hats 1
- subtle bass 1
- surround sound 1
- synth keys chords 1
- synth pop 1
- thin 1
- trance music 1
- trippy 1
- wide funky electric guitar melody 1
musiccaps_names (array) 6 ✖
- Music 3
- Funk 1
- Music of Latin America 1
- Sampler 1
- Ska 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raskahuele--LA Sound System | The low quality recording features a live performance of a reggae song that consists of shimmering cymbals, addictive brass melody and muffled male vocal singing over it. It is noisy and in mono, and it sounds thin, harsh, muddy, messy and energetic. | 2008-06-22T17:38:28Z | Geovanni De Leon | LASS | ["Music", "Ska", "Music of Latin America"] | ["low quality", "shimmering cymbals", "noisy", "mono", "addictive brass melody", "muffled male vocal", "live performance", "reggae", "loud", "thin", "harsh", "muddy", "messy", "energetic"] | 4 | GkB_BkyVyPs | 1752 | |
*Classy Freak* | The Disco song features a flat male vocal singing over a wide funky electric guitar melody, groovy bass, synth keys chords, funky synth lead melody, punchy kick, punchy snare layered with some claps and simple hi hats. It sounds passionate, funky and groovy. | 2008-06-22T21:32:10Z | IwYlAj | PLAIR 1984 Label: P.A.R. | ["Funk", "Music"] | ["disco", "wide funky electric guitar melody", "synth keys chords", "funky synth lead melody", "groovy bass", "punchy kick", "punchy snare", "simple hi hats", "claps", "flat male vocal", "passionate", "funky", "groovy"] | 4 | p8xxC2um9xQ | 4688 | |
PROGRESSIVE ROCK Madrugada Reborn from "Madrugada" (1974) | This music is instrumental. The tempo is medium with atmospheric synthesiser, soft keyboard harmony and subtle bass lines in the background. The music is progressive with a lot of digital sounds giving it a psychedelic,meditative, trippy, trance like vibe. This instrumental is Synth Rock/Progressive Rock. | 2008-06-22T13:32:05Z | Otnip54 | Madrugada Reborn (Gianfranco Pinto) MADRUGADA: Gianfranco Pinto: Keyboards & Vocals Billy Zanelli: Bass & Vocals Pietro Rapelli: Drums & Vocals Madrugada (1974) new issue from BTF (2007) Buy at: http://amzn.to/1tlD1CJ Incastro (1976) new issue from BTF (2007) Buy at: http://amzn.to/1tlDZ23 More on: http://www.italianprog.com/a_madrugada.htm | ["Sampler", "Music", "Synthesizer"] | ["instrumental", "medium tempo", "indie rock", "experimental", "meditative", "pensive", "grimelectronic music", "atmospheric synthesiser", "surround sound", "intense", "psychedelic", "trippy", "halluciatory", "trance music", "keyboard harmony", "subtle bass", "rock", "alternative rock", "synth pop", "indie roc", "progressive rock"] | 7 | xb07gLlmkL8 | 5342 |
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;