musiccaps_details (view)

3 rows where "youtube_published" is on date 2011-07-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: musiccaps_author, youtube_published (date)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
TC Electronic Hall Of Fame Reverb The low quality recording features an emotional electric guitar chord progression being played with a huge reverb effect on it. It sounds like it is played in a huge space. 2011-07-25T22:15:58Z Prymaxe Bound to go down in history as one of the greatest, most versatile reverb pedals of all time, the TC Electronic Hall Of Fame will not disappoint. Featuring 11 fully tweakable reverb sounds and TC Electronics unique toneprint function, so you can have the reverb tone of all of your favourite artists at your fingertips! The TC Electronic Hall of Fame can also be used stereo, and includes stereo inputs for those who run stereo! Cool! The TC Electronic Hall Of Fame is much much more than just your average amp reverb. Get the tone of the pros and pick up your TC Electronic Hall Of Fame Reverb at https://www.prymaxe.com today! ["Effects unit", "Electric guitar", "Music", "Chorus effect", "Distortion"] ["low quality", "emotional electric guitar chord progression", "reverb pedal effect", "huge space"] 4 CGYflJRiLt0 1345
Ouverture de l'opéra-ballet Pygmalion This is a French opera/opera-ballet music piece. There is no singer in this piece. The only instrument that is being played is a harpsichord. The sound and the tunes are reminiscent of the medieval era. There is a theatrical feel to the piece. This piece could be used in the soundtrack of a historical drama that takes place in the medieval era. It could also be used as an accompaniment piece for a theater play or a ballet dance performance. 2011-07-25T21:59:45Z Jory Vinikour Jean-Philippe Rameau, composer (transcribed by Claude Balbâtre) Jory Vinikour, harpsichord French double harpsichord by Cucchiara and Pierce Recorded April 13, 2011 in Shaker Heights, Ohio USA ["Harpsichord", "Keyboard (musical)"] ["french opera", "opera-ballet", "no singer", "instrumental", "harpsichord", "medieval sounding", "theatrical", "ballet dance"] 9 Iz611KubW70 1957
ECS VS BBH Thailand DotA Tournament Razer Final Round 21/07/54 The low quality recording features a metal song that consists male vocals with a wide echoing effect on, wide filter modulated electric guitar chords, noisy snare hits, punchy kick and pulsating synth riser that appears towards the end of the loop. It sounds exciting, as it prepares the listener for an energetic drop. 2011-07-25T03:18:55Z ReaperTH www.thaicybergames.com ["Music", "Angry music"] ["low quality", "metal", "echoing male vocal", "wide filter mod electric guitar chords", "noisy snare hits", "punchy kick", "pulsating synth riser", "energetic", "exciting"] 4 gXzqZIoM5g8 4038

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;