musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "oriental string melody" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- acoustic drums 1
- e-bass 1
- e-guitar 1
- hardrock/metal 1
- highly aggressive and loud 1
- male voice streaming 1
- oriental string melody · 1 ✖
musiccaps_names (array) 2 ✖
- Angry music 1
- Music 1
musiccaps_names 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Memphis May Fire - The Commanded | An acoustic drum is playing a groove with crash hits and a double-bass drum along with the e-bass and an e-guitar playing bass notes along with the complex kickdrum. A oriental sounding string and brass-section is playing a melody. The male voice sounds very aggressive, screaming with full force. This song may be playing at a live concert. | 2011-04-24T03:47:48Z | riserecords | iTUNES: http://smarturl.it/mmf-hollow MERCH: http://riserecords.merchnow.com/catalogs/Memphis-May-Fire I felt the ground start to shake. Oh God, oh God, Everything's up in flames. I prayed that it would have ended Just as fast, just as fast as it came. All I could hear was: "March on, march on. Quick on your feet, March on, march on. March on, march on. Whether you like or not, March on, march on!" (Finish what you started. Just remember You can't bring them back, Just remember You can't bring them back.) Heads will roll, bullets will fly. We've all been turned Into bloody thirsty cannibals. Just don't close your eyes! Just don't close eyes, Sleep with one open! Everything's put into perspective When you're staring down The barrel of a gun. I've come to peace with the fact That I can't take it back, What's done is done! But the bodies still haunt my dreams, Oh, the bodies still haunt my dreams. The bodies still haunt my dreams And they always will! "March on, march on. March on, march on. Quick on your feet!" (Finish what you started. Just remember You can't bring them back, Just remember You can't bring them back.) (Finish what you started. Just remember You can't bring them back, Just remember You can't bring them back.) How many of them will be forgotten, Laying a part of the ashes? No words can describe the guilt, But I had no choice! We were surrounded, No words can describe. We were surrounded, I had no choice. Words can't describe The guilt that I felt, But I had no choice. (Finish what you started. Just remember You can't bring them back, Just remember You can't bring them back.) (Finish what you started. Just remember You can't bring them back, Just remember You can't bring them back.) How many of them will be forgotten, Laying among of the ashes? | ["Music", "Angry music"] | ["hardrock/metal", "oriental string melody", "male voice streaming", "acoustic drums", "e-guitar", "e-bass", "highly aggressive and loud"] | 6 | 2nsZhXxes68 | 406 |
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;