musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic rhythm guitar chords progression", musiccaps_aspects contains "cover", musiccaps_aspects contains "fun" and musiccaps_names contains "/t/dd00004"

✎ 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
2012 Ron Paul Song (Shelby with Friends) The low quality recording features a cover of a rock song sung by passionate female vocalists, followed by acoustic rhythm guitar chord progression and shimmering shaker. It is a bit reverberant and noisy, as they are playing in a room. It gives off happy and fun vibes. 2007-09-19T07:25:51Z ThatsTheTicket86 Ron Paul for President Reprise for 2012 - Campaign Song Written and performed by Shelby Lindley. Some silly friends dropped in and joined me on this version. ;) Permission to use this song in its original form or as an mp3/audio version at rallies and public events in support of Ron Paul is given providing notice is sent to the copyright holder, Shelby Lindley, via email on this YouTube website or the PO box below. Any alteration or editing must get writer's approval. All other rights reserved. MP3 is available for download at "http://www.myspace.com/shelbylindley" More music of Shelby Lindley can be heard at "http://www.myspace.com/landgmusic" and "http://www.shelbytiegandtara.com" So for those of you asking, here are the song lyrics... The Ron Paul Song Music and Lyrics by Shelby Lindley There is a man out there who wants us all happy To do that there's a vision to change foreign policy What a clever idea to change the situation He's gonna restore the republic, put a dime in for the nation Ron Paul Ron Ron Ron Ron Paul Doo doo doo do Do-do do-do Doo doo doo do Now he has got a concept for complete eradication Of the IRS and CIA, deserves a validation Far too many people ain't out of the water yet He's gonna help us stop inflation, and to get us out of debt Ron Paul Ron Ron Ron Ron Paul La la la la La-la la-la La la la la Just take a second now to clear your head The bright new revolution should be lead By Ron Paul Ron Ron Ron Ron Paul There is just one more thing that I'll say before I go Now it's all in my opinion, but I thought that you should know That if there is one man I think that you would like to be, It's the man that paints the picture to make this nation truly free Ron Paul Ron Ron Ron Ron Paul Ron Paul Ron Ron Ron Ron Paul (Copyright © 2007-2011 Shelby Lindley. All rights reserved.) ["Singing", "Guitar", "Music", "Plucked string instrument", "/t/dd00004"] ["low quality", "noisy", "shimmering shaker", "reverberant", "passionate female vocal", "cover", "acoustic rhythm guitar chords progression", "rock", "happy", "fun"] 4 v6A7Iggebm4 5156

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;