musiccaps_details (view)
4 rows where "youtube_published" is on date 2008-02-16
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- energetic 2
- low quality 2
- mono 2
- acoustic guitar accompaniment 1
- addictive 1
- addictive staccato violin melody 1
- ambient 1
- blues 1
- boomy bass 1
- claps 1
- country blues 1
- dj scratching sound effects 1
- dulcet 1
- emphatic lead 1
- energetic drums 1
- exotic 1
- fluid 1
- groovy bass lines 1
- haunting female vocals melody 1
- hip hop 1
- instrumental 1
- lap steel guitar 1
- live performance 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mood 1
- noisy 1
- nostalgic 1
- passionate 1
- pleasant 1
- punchy snare 1
- retro pop 1
- rock and roll 1
- romantic 1
- simple melody 1
- slide guitar 1
- slow tempo 1
- soft 1
- steady drumming 1
- steel drums melody 1
- twangy high pitched licks 1
- upright bass guitar 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
violon vs scratch | The low quality recording features a hip hop song that contains boomy bass, punchy snare layered with claps, DJ scratching sound effects, addictive staccato violin melody and haunting female vocals melody in the background. The recording is in mono and it sounds energetic and addictive, regardless of the quality of the recording. | 2008-02-16T03:18:15Z | Finnels Workshop | c trop mortel style hip hop associé au style celtik ca donne un mix kje kiffe a mort | ["Scratching (performance technique)", "Music", "Musical instrument", "Scratch", "Violin, fiddle"] | ["low quality", "mono", "hip hop", "boomy bass", "punchy snare", "claps", "dj scratching sound effects", "addictive staccato violin melody", "haunting female vocals melody", "energetic", "addictive"] | 4 | A_oaLt-n4fQ | 1137 | |
I've Got a New Heartache | This is a bluesy country style song played on a lap steel guitar. There is a walking bassline, and slide guitar being played. The singer has a burly, calm voice. The song would be heard in an old school bar in Texas - which might be called a "saloon". | 2008-02-16T09:58:41Z | Brian Folks | A Real Good Swingin' Country Song...Has Lots of Pedal Steel Guitar in it...Enjoy. Brian... | ["Blues", "Music", "Steel guitar, slide guitar"] | ["lap steel guitar", "blues", "upright bass guitar", "country blues", "twangy high pitched licks", "slide guitar"] | 3 | nU7x170OvJ4 | 4543 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 |
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;