musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2009-04-26 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- aggressive 1
- aggressive electric guitar riffs 1
- bongos 1
- catchy 1
- discarded oil drums 1
- double pedal kick 1
- energetic 1
- groovy distorted bass guitar 1
- guider sound of breeze 1
- guiero rhythm 1
- guiro rhythm 1
- instrumental 1
- keyboard harmony 1
- lively 1
- manic 1
- manic solo electric guitar melody 1
- medium fast tempo 1
- metal 1
- people talking 1
- punchy snare 1
- recycled instrument 1
- rhythmic congas 1
- shimmering crash cymbals 1
- shimmering hi hats 1
- simple music 1
- sound of bike starting 1
- sound of breeze 1
- steady bass line 1
- steel pan 1
- upbeat 1
- windy 1
musiccaps_names (array) 8 ✖
- Music 2
- Bass drum 1
- Cacophony 1
- Drum 1
- Drum kit 1
- Musical instrument 1
- Percussion 1
- Steelpan 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Testament - Eerie Inhabitants | The Metal song features a manic solo electric guitar melody over shimmering hi hats, shimmering crash cymbals, double pedal kick hits, punchy snare, groovy distorted bass guitar and aggressive electric guitar riffs. It sounds aggressive, manic and energetic - like something you would jump to at the concerts. | 2009-04-26T05:02:15Z | TestAmenTtoons | Testament - 1. Eerie Inhabitants - The New Order [Music: Peterson, Skolnick / Lyrics: Skolnick, Billy, Peterson] A world of chaos A world of fear A world of anger and corruption When all is lost And millions starve Is this humanity's destruction? Life! A game that people play Cryout! Will they see another day? No one help us, The children pray Nobody listens to their crying This great depression When will it end? To live like this is worse than dying Life! A game that people play Cryout! Will they see another day? Your destiny is over Your fate has declined Refuse to discover What so many could find Death's endless toil As I long for rest Life's now forsaken Condemned to repress! No sign of Heaven No sign of Hell Just the sign of pain and sorrow This generation inhabits all To form an order for tomorrow Life! A game that people play Cryout! Will we see another day? | ["Music", "Cacophony"] | ["metal", "energetic", "manic solo electric guitar melody", "shimmering hi hats", "shimmering crash cymbals", "double pedal kick", "punchy snare", "groovy distorted bass guitar", "aggressive electric guitar riffs", "aggressive", "manic"] | 4 | OEuBITrf-kE | 2417 | |
Brazil | This song is an instrumental. The tempo is medium fast with melodious steel pan, rhythmic percussion like bongos and congas, guitar sound, steady bass line and keyboard harmony. The sound of the breeze in the background indicates that music is being played outdoors. The music is invigorating, playful, light, pleasant, mellifluous and warm. | 2009-04-26T18:16:34Z | Steel Drum Music | Now on iTunes ♫ → click the 'Show More' button for info ↓ ↓ ↓ Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net The very popular samba 'Brazil' performed at ER Bradley's in West Palm Beach on 4/25/09 | ["Drum", "Drum kit", "Music", "Musical instrument", "Bass drum", "Percussion", "Steelpan"] | ["instrumental", "medium fast tempo", "lively", "steel pan", "sound of bike starting", "sound of breeze", "windy", "guiero rhythm", "recycled instrument", "discarded oil drums", "keyboard harmony", "steady bass line", "people talking", "guider sound of breeze", "guiro rhythm", "simple music", "catchy", "upbeat", "rhythmic congas", "bongos"] | 7 | NtM3gudMBCQ | 2375 |
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;