musiccaps_details (view)
4 rows where "youtube_published" is on date 2009-04-16 sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- "4 on the floor" kick pattern 1
- backup singers 1
- bad audio quality 1
- bright synth 1
- clean sound 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- dance hall rhythm 1
- dance music 1
- eighties 1
- electric guitar 1
- electro-funk 1
- energetic 1
- flat male vocal 1
- fun 1
- funk 1
- groovy bassline 1
- guitar leads 1
- guitar lesson 1
- guitar strumming 1
- happy 1
- high pitched male vocal 1
- instructive speaking 1
- keyboard accompaniment 1
- lesson recording 1
- love song 1
- low quality 1
- madly in love 1
- male chants 1
- male singer 1
- male voice 1
- medium tempo 1
- modern country love songs 1
- passionate 1
- percussive bass line 1
- plucked sitar melody 1
- romantic 1
- simple bass 1
- simple tune 1
- soul 1
- syncopated snare 1
- synth stabs 1
- trumpety-synth 1
- vocal harmony 1
musiccaps_names (array) 11 ✖
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 | |
remix funk de tueur | This is a groovy, electro-funk track which works well for dancing. A song like this would be heard in the eighties. It is soulful and upbeat. There are synth stabs and a trumpety synth motif in the background. | 2009-04-16T11:00:07Z | CHRIS CARA | dj ozzir | ["Funk", "Music"] | ["funk", "bright synth", "dance music", "eighties", "electro-funk", "soul", "groovy bassline", "trumpety-synth", "synth stabs"] | 3 | 4Vg0PQuHTk0 | 578 | |
'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 | |
Punjabi jingle bell | The low quality recording features a dance hall rhythm Christmas song that consists of flat male vocals, alongside high pitched male vocals at the very beginning, singing over syncopated snare, plucked sitar melody, "4 on the floor" kick pattern and simple bass. It sounds fun and happy, like something kids would listen to. | 2009-04-16T13:09:36Z | Basis Morse | Punjabi jingle bell | ["Jingle (music)", "Music"] | ["low quality", "dance hall rhythm", "flat male vocal", "high pitched male vocal", "male chants", "plucked sitar melody", "syncopated snare", "simple bass", "\"4 on the floor\" kick pattern", "fun", "happy"] | 4 | MHkfPjW0aRg | 2253 |
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;