musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2009-04-16
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- backup singers 1
- bad audio quality 1
- clean sound 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- electric guitar 1
- energetic 1
- guitar leads 1
- guitar lesson 1
- guitar strumming 1
- instructive speaking 1
- keyboard accompaniment 1
- lesson recording 1
- love song 1
- madly in love 1
- male singer 1
- male voice 1
- medium tempo 1
- modern country love songs 1
- passionate 1
- percussive bass line 1
- romantic 1
- simple tune 1
- vocal harmony 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
intermediate to advanced guitar lesson -Blues Soul R&B Funk Jazz Progression | This is the recording of a guitar lesson. The instructor at first plays the chords on a clean sounding electric guitar and then describes the nature of the chord that he is playing. The chords that were strummed could be used as clean electric guitar samples in beat-making. | 2009-04-16T18:13:58Z | GuitarJamz Lessons | http://guitarjamz.com here is a great progression to solo over, or practice your soloing!! follow me at twitter http://twitter.com/martyschwartz http://youtube.com/martyfs74 | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["lesson recording", "guitar lesson", "electric guitar", "clean sound", "simple tune", "male voice", "instructive speaking"] | 9 | 3noh9LiQNrs | 503 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 |
Advanced export
JSON shape: default, array, newline-delimited
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;