home / musiccaps

musiccaps_details (view)

3 rows where "youtube_published" is on date 2008-09-23

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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;
Powered by Datasette · Queries took 557.307ms · About: simonw/musiccaps-datasette