musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "uptempo", musiccaps_author = 6 and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bad Manners - Don't Knock The Bald Head (Live) Part 3 | An acoustic drum is playing a faster groove along with a bassline and a harmonica playing a chord on the offbeat and in a lower key. A e-guitar is playing a melody in the mid range. There are some background noises that remind me of someone brushing his/her teeth. This song may be playing live at a bar. | 2009-04-09T13:42:52Z | OxBlood66 | 3 tracks from Don't Knock The Bald Head. Skaville UK, Walking In The Sunshine, King Ska/FA. | ["Funk", "Music", "Independent music", "Reggae", "Ska"] | ["rock/ska", "e-bass", "acoustic drums", "e-guitar", "harmonica", "background-noises", "uptempo", "positive energy"] | 6 | KdNhYvN4Xoo | 2101 | |
White Clouds & Gunfire - Reflection (Official Lyric Video) | The drums are playing a steady rock groove with a half open hi hat constantly ringing through the song. The e-guitar is panned to the left and right side of the speakers or two e-guitars are shredding the same distorted chords along with the bass silently playing in the background. The female voice is singing in a higher pitch and is accompanied by a female backing voice singing a deeper harmony. This sounds like a typical high school rock song. This song may be played chilling in your room sitting on the bed daydreaming. | 2014-11-02T15:57:55Z | White Clouds & Gunfire | Lyric video for the song Reflection taken from our debut album, For All The Non Believers. iTunes: https://itunes.apple.com/gb/album/for-all-the-non-believers/id683464733 Facebook: www.facebook.com/wcagf Twitter: @wcag_uk Video by: facebook.com/tfxtx | ["Music", "Independent music", "Rock music", "Progressive rock"] | ["rock", "female higher register voice", "acoustic drums", "e-guitar", "e-bass", "uptempo", "high school rock"] | 6 | Nep_3Y81E_w | 2354 | |
Top 30 Indie Songs I Think You Should Listen To | This song contains someone playing acoustic drums along with an e-bass. They both sound in the foreground. A male voice is singing in the high mids and with reverb and a little delay on his voice. Then the song breaks into the next part and an e-guitar comes in with a strummed melody. This song may be playing with headphones lost in thoughts. | 2009-09-27T17:23:53Z | top30music | Follow me on twitter!: @Top30music 30 great indie songs from bands from 12 different countries!!... if you know a good indie song dont keep it to yourself... comment about it! If you're looking for new music, don't hesitate on clicking here: http://www.youtube.com/watch?v=1xXuKvtOlaw amazing artist! | ["Singing", "Music", "Independent music"] | ["indie7rock/pop", "male voice singing", "higher pitch", "acoustic drums", "e-bass", "e-guitar", "uptempo"] | 6 | atWaDoSyGgY | 3584 |
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;