musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "mono" and musiccaps_names contains "Soul music" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- low quality 3
- mono · 3 ✖
- groovy bass 2
- vintage 2
- 4 on the floor kick 1
- claps 1
- energetic 1
- exciting 1
- flat male vocal 1
- fun 1
- funky electric guitar 1
- funky guitar chords 1
- groovy piano melody 1
- groovy spanish acoustic guitar melody 1
- groovy synth keys 1
- house 1
- melodic background male vocals 1
- muddy 1
- noisy 1
- northern soul 1
- nostalgic 1
- punchy "4 on the floor" kick pattern 1
- sentimental 1
- shimmering open hats 1
- shimmering shakers 1
- warm 1
musiccaps_names (array) 8 ✖
- Music 3
- Soul music · 3 ✖
- Electronica 1
- Funk 1
- House music 1
- Ska 1
- Swing music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Youtube mix - Deep, Soulful, Underground Part 6 | The low quality recording features an electro house song that consists of punchy "4 on the floor" kick pattern, claps, funky electric guitar melody, groovy synth keys, groovy bass that glues everything together and shimmering shakers. It sounds a bit muddy, but also energetic, fun and exciting - like something you would hear in clubs during 70s and 80s a lot. | 2007-07-07T04:25:13Z | laurentkm3 | Cue Kids -- Fruity Grooves part 2 (In Love) Cajmere feat Dajae--Brighter Days (Original Mix) Laurent presents Center of the Earth Music - The Deep.The Soulful.The Underground. I do a live one hour deep, soulful, and underground mix show from 11am-noon every Tuesday EST at http://www.faderwave.net/ Just go to the website and look at the top left hand side where it says "TUNE IN NOW!" ENJOY!!!!! | ["House music", "Music", "Techno", "Soul music", "Electronica"] | ["low quality", "mono", "house", "punchy \"4 on the floor\" kick pattern", "claps", "funky electric guitar", "groovy synth keys", "groovy bass", "shimmering shakers", "energetic", "exciting", "fun", "muddy"] | 4 | EmSZKb0LdVM | 1587 | |
Camarón & Paco Cepero - Tangos - 1976 | The low quality recording features a groovy Spanish acoustic guitar. It sounds very noisy, vintage and the guitar was recorded in mono. | 2011-12-09T02:59:34Z | QuintoSertorio1987 | IV Festival Joaquín el de la Paula 1976 | ["Swing music", "Music", "Soul music"] | ["low quality", "groovy spanish acoustic guitar melody", "noisy", "mono", "vintage"] | 4 | ktTrTDQidsE | 4363 | |
Dooley Silverspoon - Game Players : Northern Soul | The low quality recording features a northern soul song that consists of flat male vocals, alongside melodic male background vocals, singing over funky guitar chords, groovy piano chords, groovy bass, "4 on the floor" kick pattern and shimmering open hats. It is noisy and in mono and therefore vintage, but it also sounds warm, nostalgic and sentimental. | 2013-05-03T20:08:03Z | Mike Patterson | Dooley Silverspoon - Game Players : Northern Soul, with some Northern Soul Video Clips | ["Funk", "Music", "Ska", "Soul music"] | ["low quality", "vintage", "northern soul", "groovy bass", "groovy piano melody", "funky guitar chords", "shimmering open hats", "4 on the floor kick", "flat male vocal", "melodic background male vocals", "mono", "warm", "nostalgic", "sentimental"] | 4 | EUNTykrvpok | 1563 |
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;