musiccaps_details (view)
2 rows where musiccaps_aspects contains "cymbals crashing", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- cymbals crashing · 2 ✖
- groovy bass line · 2 ✖
- poor audio quality 2
- steady drumming rhythm · 2 ✖
- amateur music mix 1
- ambient room noises 1
- backups singers 1
- busy office ambience 1
- busy work day 1
- cheerful 1
- choppy music 1
- choral harmony 1
- crooning 1
- cumbria rhythm 1
- day at the office 1
- disconcerting music 1
- dj 1
- emotional 1
- groovy 1
- groovy bas slime 1
- hissing tones 1
- inspiring 1
- instrumental music 1
- keyboard accompaniment 1
- latin percussions 1
- latin rhythm 1
- male singer 1
- medium tempo 1
- mismatched tempos 1
- office adventure 1
- passionate 1
- pop song 1
- pop superhit 1
- printer blues 1
- printer sounds 1
- remix 1
- smooth jazz music 1
- toner sounds 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Happy Version cumbia - Pharrell Williams (Tato Dj) | A male singer sings this pop melody with back up singers in choral harmony. The song is medium tempo with a superimposed Latin Cumbia rhythm, which creates a discombobulated rhythm structure. The song audio quality is very poor. | 2014-03-14T22:04:39Z | Viktor Radchenko | Tato DJ Twitter: https://twitter.com/Tatoarata Original song by Pharrell Williams | ["Music", "Maraca"] | ["cumbria rhythm", "pop song", "choppy music", "latin rhythm", "disconcerting music", "cheerful", "pop superhit", "emotional", "inspiring", "groovy", "passionate", "male singer", "backups singers", "crooning", "choral harmony", "groovy bas slime", "steady drumming rhythm", "poor audio quality", "remix", "dj", "cymbals crashing", "groovy bass line", "latin percussions", "mismatched tempos", "amateur music mix"] | 1 | C6roSYqchkk | 1331 | |
The New Gladio ID Card Printer | The song is an instrumental. The song is medium tempo with a keyboard accompaniment, groovy bass line and a funky drumming rhythm. There is a lot of office ambient noises, like a printer motor noises, wind noise and other office environmental sounds. The music track acts as a background to the ambient office sound environment. The audio quality is very poor. | 2012-11-26T21:24:12Z | AllianceIDSolutions | The new Gladio ID Card Printer raises the bar for card printers when it comes to speed, reliability and quiet operation. The machine features lighting fast printing and whisper quiet operation and is field upgradeable. The sleek design provides reduced size and weight and outstanding performance, all at a great price. | ["Printer", "Music"] | ["instrumental music", "ambient room noises", "day at the office", "printer blues", "office adventure", "busy work day", "smooth jazz music", "hissing tones", "cymbals crashing", "printer sounds", "toner sounds", "poor audio quality", "medium tempo", "keyboard accompaniment", "steady drumming rhythm", "groovy bass line", "busy office ambience"] | 1 | YFXSbPFaxcA | 3270 |
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;