musiccaps_details (view)

3 rows where musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Electronic organ"

✎ 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
Tony Lucas & Kris Brooks Shouting Music Praise Break Pt.1 The low quality recording features groovy organ keys played over punchy kick and snare hits, shimmering cymbals and groovy bass guitar. It sounds energetic, passionate and uptempo. The recording is noisy. 2009-10-12T04:12:24Z Ovaljean Tony Lucas & Kris Brooks playing Shouting Music at Temple St. Jude. Filmed by Anthony Holston, Ovaljean Productions ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] ["low quality", "uptempo", "noisy", "groovy organ keys", "punchy snare", "punchy kick", "groovy bass guitar", "shimmering cymbals", "energetic", "passionate"] 4 6gTrMRQPZMU 776
Brian Auger - Compared to what (Live at Baked Potato) The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. 2011-11-22T14:17:10Z Bluedreams The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] 4 CrkxrgTiVyk 1410
Love me two times 2 (Doors) played on Gibson and piano bass The low quality recording features a synth lead melody and groovy synth piano playing over rock songs played on playback. The song consists of a punchy kick and snare hits, shimmering hi hats, funky electric guitar melody, groovy bass and passionate male vocals singing over it in the beginning. It sounds funky and groovy, while the recording is a bit noisy. 2007-04-13T18:21:38Z serenities The Doors; Love me two times, played on a Gibson G101 (1967) and a Fender Rhodes Piano Bass (1966). Original background song by The Doors. ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] ["low quality", "noisy", "rock playback", "punchy snare", "shimmering hi hats", "funky electric guitar melody", "groovy bass", "passionate male vocal", "punchy kick", "groovy synth keys", "synth lead melody", "groovy", "funky"] 4 Simd4JoehW8 2782

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;