musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- e-bass 4
- e-guitar 4
- uptempo · 4 ✖
- acoustic drums 3
- male voice singing 2
- acoustic drum 1
- background-noises 1
- female higher register voice 1
- harmonica 1
- high school rock 1
- higher pitch 1
- indie7rock/pop 1
- organ 1
- positive energy 1
- positive vibes 1
- rock 1
- rock&roll 1
- rock/ska 1
musiccaps_names (array) 8 ✖
- Independent music · 4 ✖
- Music 4
- Funk 1
- Progressive rock 1
- Reggae 1
- Rock music 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Strawberry Alarm Clock - California Day | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | 2010-06-27T08:13:10Z | Optinon | Genre: Pop/Psychedelic Pop Released: 1970 Release: California Day / Three | ["Music", "Independent music"] | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | 6 | BHu95Y_kVQA | 1225 | |
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;