musiccaps_details (view)

5 rows where musiccaps_author = 2 and musiccaps_names contains "Rock and roll"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Whir - Daria's Theme (Live at Circus Bar - 2001) The rock music features a male voice singing a repeating melody and being backed by other male vocals. The electric guitar plays fast chords with a distortion effect on and the bass guitar follows with the same speed. The drums play a fast repeating rhythm. The quality of the audio is really low and so this leads me to believe this is an amateur recording. 2007-12-16T16:36:07Z Rety Matos É isso aí: Show do Whir - Torto, mal gravado, com erros, muitos amigos e foda. Bem, pelo menos pra mim era muito foda... :) Sétima música do show: 7) Daria's Theme (Splendora Cover) Ah, show gravado no Circus Bar em 2001, dia do meu aniversário \o/ Abertura do Fuss. ["Music", "Whir", "Rock and roll"] ["low quality recording", "male voice", "male backing vocals", "electric guitar", "distortion effect", "drums", "bass guitar", "rock genre", "fast tempo"] 2 3sIlpn9nvKU 510
Stray Cat Strut by The Nosey Joe Band The music features a male voice singing a descending melody that repeats. The instrumental consists of a drum kit that's playing a light rhythm, a double bass that's playing a repeating descending melody and an electric guitar that's strumming chords once per beat. The quality of the audio recording is not so good which leads me to believe this is an amateur recording and not something professional. 2008-05-28T02:57:13Z pookyfmr This is our version of the song made famous by the Stray Cats. ["Blues", "Singing", "Music", "Rock and roll"] ["male voice", "reverb effect", "electric guitar", "double bass", "drums", "low audio recording quality"] 2 FvQgVl5IBHw 1676
Little girls dancing to Hello Good Morning/wobble (trimmed) The hip-hop music features a male voice singing repetitive short bits of melody. The music excerpt contains a strong beat rhythm which drives the pulsation of the music. A synth sound is playing a repeating melody throughout the passage. The music sounds as if it was recorded by a phone from a playing speaker. 2010-10-11T01:45:52Z Mooruneque Texas Girls Fair, Dallas texas ["Disco", "Music", "Rock and roll", "Music of Latin America"] ["male voice", "hip-hop beat", "synth sound", "speakers", "hip-hop genre"] 2 MVq9PYtypy0 2275
Yeah Yeah (Je-Je) - Deja Voodoo - Urgente Rock and Roll The punk-rock music features a male voice singing a static melody. An electric guitar with a distortion effect accompanies the singer with repetitive chords. The drums play a simple and repetitive rhythm. 2008-12-23T04:36:51Z opentaker si alguien sabe como se llama y quien la canta me deja el comentario para modificar el video por favor ["Music", "Roll", "Rock and roll"] ["male voice", "static melody", "drums", "electric guitar", "distortion effect", "punk-rock genre"] 2 OFP5MYVDa4g 2419
ITV Chart Show Indie Chart May 1989 The excerpt is actually a song collage and it features third songs. In the first one a male voice is singing and the song has a dance feel to it. In the second song a male voice is singing and being backed by male voices at the same time. The instruments used are more close to the rock genre. The third song lasts for a few milliseconds and so it's hard to notice anything about it. 2007-08-05T19:39:57Z David Bryant Features: Wire - Eardrum Buzz My apologies for not including Pixies "Monkey Gone To Heaven" again. Please see April's edition for the featured version. ["Disco", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Pop music", "Rock music", "Rock and roll"] ["collage", "male voices", "indie music"] 2 oT6ud0OdR_E 4633

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;