musiccaps_details (view)

2 rows where musiccaps_aspects contains "electric guitar" and "youtube_published" is on date 2008-12-20

✎ 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
Crazy Fan at Miranda Lambert's Concert This is an amateur recording of a rock music concert. There is an electric guitar playing the main tune while another electric guitar is starting to play a solo. A bass guitar can be heard in the background playing the root notes of the tune. There is a loud acoustic drum beat in the rhythmic background. The recording is a bit outdated so the quality is pretty low. 2008-12-20T21:42:01Z soonerbme Watch the clip at the end. A crazy fan makes her mad & she leaves the stage. We missed the last song, but it was a great concert anyway! ["Music", "Whoop", "Inside, public space"] ["amateur recording", "live performance", "rock music", "electric guitar", "bass guitar", "acoustic drums", "fans shouting", "screams"] 9 7PtHb9jQCtg 844
Michael Jackson - Off The Wall - Girlfriend This is a funk/disco music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the keyboard with the backing of the electric guitar and the bass guitar. The rhythm is being played by the acoustic drums. The atmosphere is groovy. This piece could be played at a retro-themed party at a dance club. 2008-12-20T19:44:15Z Sccuderia Sorry for the HUGE delay but youtube wouldn't let me log in...anyway...Enjoy! Lyrics: [1st Verse] Girlfriend I'm Gonna Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What You Do To Me Late At Night When The Wind Is Free [2nd Verse] Girlfriend I'm Gonna Show Your Boyfriend (Yeah) Show Him (Woo Hoo) The Letters I've Been Savin' (Yeah) Show Him How You Feel Inside An' How Love Could Not Be Denied (Oh No) [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine [3rd Verse] Girlfriend You Better Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What He Needs To Know Or He May Never Let You Go [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do.. [Ad-Lib To Fade] ["Music", "Soul music"] ["funk", "disco", "male vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "easygoing", "danceable"] 9 l6LUPlmua6I 4375

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;