musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2008-11-02
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- background music 1
- dance party 1
- funky piano 1
- funny spring sound effect 1
- groovy bass 1
- groovy bass line 1
- guitar accompaniment 1
- gun reload sound effect 1
- in game sound effects 1
- jazzy 1
- keyboard accompaniment 1
- male singer backup singers 1
- man grunting sound effects 1
- people dancing 1
- poor audio quality 1
- rapping vocals 1
- reggae music 1
- retro reggae 1
- saxophone 1
- steady drumming rhythm 1
- sway to the music 1
- tropical dance party 1
- uptempo drums 1
- video game sound 1
- weird beeping sound effect 1
musiccaps_names (array) 4 ✖
- Music · 2 ✖
- Buzz 1
- Electronic music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Toy Story 2 Buzz Lightyear To The Rescue Gameplay Level 2 | The Video Game Sound recording features a lot of in-game sound effects of the main character and his surroundings, followed by background, jazzy music in the background. The music contains funky piano chord progression, groovy bass and uptempo drums. There are some man grunts sound effects, funny spring sound effects, some beeping sound effects and at the very end of the loop a gun reload sound effect. | 2008-11-02T15:51:13Z | David Miles | Level 2 from this classic Toy Story game on Playstation, N64, Dreamcast and GBC. Enjoy! | ["Music", "Buzz"] | ["video game sound", "groovy bass", "in game sound effects", "man grunting sound effects", "funky piano", "groovy bass", "jazzy", "saxophone", "uptempo drums", "background music", "weird beeping sound effect", "funny spring sound effect", "gun reload sound effect"] | 4 | On9epzZ_ceI | 2468 | |
Best Dancehall of the 90's part 1 | A male singer sings this melody with a backup singer singing rapping vocals. The song is medium tempo, with a steady drumming rhythm, groovy bass line and keyboard accompaniment. The song is groovy and exciting. The song is a retro reggae song but has a poor audio quality. | 2008-11-02T05:58:19Z | Jason | Best Dancehall of the 90's part 1 Add me on Facebook... Dj-Mix Vybz Catch My live broadcast every Wednesday night at www.284radio.com from 8-11 Subscribe and check out the rest of my vids | ["Electronic music", "Music", "Ska"] | ["poor audio quality", "reggae music", "groovy bass line", "sway to the music", "dance party", "steady drumming rhythm", "guitar accompaniment", "people dancing", "tropical dance party", "rapping vocals", "retro reggae", "keyboard accompaniment", "male singer backup singers"] | 1 | p28jmA01BHo | 4679 |
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;