musiccaps_details (view)
3 rows where "youtube_published" is on date 2012-07-29 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- acoustic guitar harmony 1
- amateur recording 1
- baby shaker toy 1
- bass guitar 1
- blues 1
- country blues 1
- country music 1
- country song 1
- crunchy electric guitar playing 1
- drums 1
- empahtic electric guitar feedback 1
- empahtic melody 1
- fiddle 1
- indie rock 1
- instrumental 1
- intense 1
- male backing vocal 1
- male voice 1
- melancholy 1
- powerful 1
- punchy energetic drumming 1
- raspy male vocals 1
- regional music 1
- repeated refrain 1
- rock 1
- rock and roll genre 1
- rugged 1
- saxophones 1
- slow tempo 1
- vivid 1
musiccaps_names (array) 6 ✖
- Music 3
- Bluegrass 1
- Blues 1
- Country 1
- Independent music 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Country blues music | This music is instrumental. The tempo is slow with an acoustic guitar harmony, loud electric guitar feedback and fiddle. The music is intense, rugged, vivid, melancholic, pensive, raw, powerful, emphatic and strong. This music is classic Blues Country Music. | 2012-07-29T11:41:29Z | PROMETHEUS | Country, blues song :D | ["Blues", "Country", "Music", "Bluegrass"] | ["instrumental", "slow tempo", "melancholy", "vivid", "empahtic melody", "rugged", "powerful", "country blues", "blues", "country music", "country song", "regional music", "empahtic electric guitar feedback", "acoustic guitar harmony", "country music", "intense", "rugged", "fiddle"] | 7 | cGorUmWMrwo | 3693 | |
Da HONK - Need all my friends | This is a gritty and upbeat indie pop song. The lead singer has a raspy voice. The drummer plays a build-up drum roll into a high energy chorus refrain. | 2012-07-29T11:35:46Z | da honk | Da HONK - UNBEWEGLICH 2012 | ["Music", "Independent music"] | ["rock", "indie rock", "raspy male vocals", "crunchy electric guitar playing", "punchy energetic drumming", "repeated refrain"] | 3 | UEel3wTf0Sk | 2900 | |
Shake, rattle an roll | The rock and roll music features a male voice singing a melody and at times singing in unison with a male backing voice. The band that accompanies the singer consists of a drum kit playing a light and simple rhythm, a bass guitar that plays in the style of walking bass, and a section of saxophones. On top of this recording one can hear a rattle that sounds close to a baby shaker toy. The recording quality is not that good, which leads me to believe it's an amateur phone recording of a speaker playing the song. | 2012-07-29T15:34:40Z | Yvonne Bradt | Sesame street babies | ["Music", "Rattle (instrument)"] | ["male voice", "male backing vocal", "saxophones", "bass guitar", "drums", "amateur recording", "baby shaker toy", "rock and roll genre"] | 2 | Xxe6vTEwFvs | 3240 |
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;