musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "lively" and musiccaps_aspects contains "male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic drums · 2 ✖
- electric guitar 2
- lively · 2 ✖
- male vocal · 2 ✖
- banjo 1
- bass guitar 1
- country music 1
- danceable 1
- hard-hitting 1
- keyboard 1
- preach-like singing 1
- raspy voice 1
- ska punk 1
- spanish language 1
- upbeat 1
- upright bass 1
- violin 1
musiccaps_names (array) 4 ✖
- Music 2
- Ska 2
- Rock and roll 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Strawfoot - churchyard cough live | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | 2009-06-01T06:07:26Z | Word Smith | Dirge-Country pioneers, Strawfoot, bring a dark sound of candy-coated salvation and eternal hellfire and damnation to the public with haunting cautionary tales of outlaw scarecrows, wayward preachers, falling pianos, and the devil. Strawfoot creates an original sound steeped in the rich, dark history of America and beyond. Fronted by a crazed and angry preacher, Strawfoot is a seven-piece band consisting of violin, banjo, harmonica, upright bass, guitar, percussion and the occasional mandolin and accordian. Strawfoot has quickly become a fan favorite wherever they take the stage, gaining fans across America and abroad. | ["Music", "Ska", "Song", "Rock and roll"] | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | 9 | adYFXYPqo2M | 3562 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 |
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;