musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-09-23 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- "4 on the floor" kick pattern 1
- addictive 1
- bad audio quality 1
- building tension 1
- buzzy synth bass 1
- climactic 1
- composer 1
- conductor 1
- crackle 1
- dramatic finish 1
- energetic 1
- female singer 1
- harmonizing male vocals 1
- high pitched vocals 1
- medium tempo 1
- movie soundtrack 1
- opera hall 1
- opera singer 1
- operatic theme 1
- percussion 1
- philharmonic orchestra 1
- poor audio quality 1
- rhythm 1
- rhythm section 1
- shimmering hi hats 1
- simple synth lead melody 1
- song ending 1
- steel pan 1
- string section crescendo 1
- syncopated snare hits 1
- tropical sound 1
- tuning 1
- urban latin 1
musiccaps_names (array) 7 ✖
- Music 3
- Classical music 1
- Music of Africa 1
- Musical instrument 1
- Opera 1
- Percussion 1
- Steelpan 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Diva Song (Blood Plus) | A female opera singer sings this climatic high pitched finish. The song is medium tempo with a string section accompaniment and a rhythm Section. The song is dramatic and high on adrenaline. The audio quality is very poor. | 2008-09-23T15:24:36Z | Lagaczaka | Divas Song -+-+- great anime with best story Queen of the Chiropteran and her Aria... | ["Music", "Opera", "Classical music"] | ["female singer", "opera singer", "opera hall", "rhythm section", "philharmonic orchestra", "poor audio quality", "composer", "conductor", "operatic theme", "high pitched vocals", "bad audio quality", "song ending", "dramatic finish", "building tension", "climactic", "string section crescendo", "movie soundtrack", "medium tempo"] | 1 | X2gHQb5ubco | 3160 | |
Nuego - xanw ton elegxo | The Urban Latin song features a harmonizing male vocals singing over "4 on the floor" kick pattern, shimmering hi hats, syncopated snare hits layered with simple synth lead melody and buzzy synth bass. It sounds energetic and addictive, like something you would hear in clubs. | 2008-09-23T13:47:11Z | Tony D | xanw ton elegxo - Nuego | ["Music of Africa", "Music"] | ["urban latin", "syncopated snare hits", "buzzy synth bass", "\"4 on the floor\" kick pattern", "simple synth lead melody", "shimmering hi hats", "energetic", "addictive", "harmonizing male vocals"] | 4 | w8c7JFU6by4 | 5243 | |
Steel pan tuning - Philippe Maignaut | This is a recording of the steel pan tuning process. The performer repeatedly hits different parts of the steel pan to check if the tuning is correct. The instrument gives off a tropical sound. There is an irritating crackle sound coming from the recording. If it were not for this noise, the piece could be sampled for use in beat-making. | 2008-09-23T13:24:45Z | philpanSteeldrums | Etapes de fabrication de steel drum par Philippe Maignaut, fabricant. (http://www.steeldrums.fr) | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["steel pan", "tuning", "percussion", "rhythm", "tropical sound", "crackle"] | 9 | FBXBDe3OU5s | 1621 |
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;