musiccaps_details (view)

1 row where musiccaps_aspects contains "punchy "4 on the floor" kick pattern", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Rock music"

✎ 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
1967 The Summer Of Love - One Summer Dream The low quality recording features an electro song that contains soft male vocal singing over punchy "4 on the floor" kick pattern, shimmering hi hats and open hats, claps, groovy acid synth bass and mellow synth pad chords. It sounds energetic, groovy and hypnotic. 2008-07-26T01:26:26Z plugsong In 1967 young people believed they could change the world. It was perhaps a naive dream as time would prove, but during that summer anything seemed possible. Quickly spreading from its Haight Ashbury epicentre to Canada and the UK, where pirate radio broadcasted music to a new generation, the culture lived on for another few years, through Woodstock in 1969. But it was in 1967 that the hippie dream was at its most pure. It was a magical time for rock music which expanded in many directions aided by the use of LSD and pot, some music overtly political set against the grim reality of war in Vietnam, It was a clash between old and young, the 'beautiful people' firmly believing love could change everything, following Timothy Leary's exhortation to 'turn on. tune in, drop out'. This video hopefully gives a flavour of that heady time. Music and clip details: I have recorded with a 'four to the floor' beat Jeff Lynne's (ELO) lovely song 'One Summer Dream', as that title so neatly describes The Summer Of Love. (Yes I know it's not musically correct nor from the time and I've seen harsh comments about it. If you don't like it just watch the video with Jefferson Airplane or whoever playing on your old vinyl. I was around at the time and part of it was about non-conformity! My video, my recording, my choice :) Around 1967 Jeff Lynne (who lived just around the corner from me when young) was playing with 'The Idle Race'. My band 'Breakthru' would sometimes be on the same bill. Breakthru's keyboard player Bill Hunt would later join ELO's first line up. I have used a few Idle Race and ELO samples within this track. ('Idle Race' albums are available on re-release and much recommended, Jeff Lynne's growing song writing and production talents are very evident. See Amazon links below to buy Idle Race and Breakthru albums.) http://www.amazon.com/Back-Story-Idle-Race/dp/B000LE1EQE http://www.amazon.co.uk/Adventures-Highway-Breakthru/dp/B000VZPRZW/ref=sr_1_1?ie=UTF8&s=music&qid=1217080938&sr=1-1 The clips and stills are drawn fro… ["Music", "Rock music", "Progressive rock", "Soundtrack music"] ["low quality", "electro", "soft male vocal", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "shimmering open hats", "claps", "groovy acid synth bass", "mellow synth pad chords", "energetic", "groovy", "hypnotic"] 4 qI-Ji4gtBPM 4774

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;