musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-07-07 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- amateur production 1
- beeping tones 1
- claps 1
- classical afghan music 1
- energetic 1
- exciting 1
- experimental 1
- explosions 1
- flute 1
- fun 1
- funky electric guitar 1
- game soundtrack 1
- gamers 1
- groovy bass 1
- groovy synth keys 1
- guns shooting rhythmically 1
- harp 1
- higher key 1
- house 1
- instrumental music 1
- low quality 1
- male voice singing 1
- medium tempo 1
- mono 1
- muddy 1
- percussive blasts 1
- poor audio quality 1
- projectile explosions 1
- punchy "4 on the floor" kick pattern 1
- shimmering shakers 1
- slower tempo 1
- spirited 1
- tablas 1
- theme song 1
- unconventional instrumentation 1
- video game 1
- war game 1
- zitar 1
musiccaps_names (array) 8 ✖
- Music 3
- Classical music 1
- Electronica 1
- House music 1
- Soul music 1
- Tap 1
- Techno 1
- Wedding music 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 | |
Counter-Strike Gun Sounds 2 | The song is an instrumental. The song is medium tempo with various explosive sounds played percussively, along with counter beeps. The song is exciting and very novel. The song is probably the theme song of a modern video game. | 2007-07-07T15:05:14Z | djct1213cs | Counter-Strike Gun Sounds 2 CS1.6 Non-Steam: Cool CS Music Weapons | ["Music", "Tap"] | ["video game", "beeping tones", "medium tempo", "experimental", "spirited", "gamers", "percussive blasts", "theme song", "explosions", "guns shooting rhythmically", "poor audio quality", "amateur production", "projectile explosions", "game soundtrack", "instrumental music", "unconventional instrumentation", "war game"] | 1 | 70pyoqX0U9Y | 802 | |
Classical Music of Afghanistan | Someone is playing a simple repeating melody on a zitar along with a small harp. A flute is playing the same melody in the higher mid-range. A male voice is singing along. Someone is playing tabla. This song sounds calm and repetitive. This song may be playing live at a local performance place. | 2007-07-07T21:06:12Z | Afghan Culture | Classical Music of Afghanistan by a group that was established in 1986. | ["Music", "Wedding music", "Classical music"] | ["classical afghan music", "zitar", "flute", "tablas", "harp", "male voice singing", "higher key", "slower tempo"] | 6 | y6iMm7Pltq0 | 5383 |
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;