musiccaps_details (view)
2 rows where musiccaps_aspects contains "hissing tones" and musiccaps_aspects contains "steady drumming rhythm" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- hissing tones · 2 ✖
- keyboard accompaniment 2
- medium tempo 2
- steady drumming rhythm · 2 ✖
- ambient room noises 1
- bad audio quality 1
- brass band 1
- busy office ambience 1
- busy work day 1
- cymbals crashing 1
- day at the office 1
- emotional 1
- fans 1
- football match theme 1
- groovy bass line 1
- heavy bass drum rhythm 1
- instrumental music 1
- male singers 1
- office adventure 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- printer blues 1
- printer sounds 1
- smooth jazz music 1
- spirited 1
- toner sounds 1
- trumpet playing in unison 1
- vocal harmony 1
musiccaps_names (array) 4 ✖
- Music 2
- Jazz 1
- Middle Eastern music 1
- Printer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
music wydad 2010 | A male singer leads backup singers in a vocal harmony. The song is medium tempo with a heavy percussive drum rhythm, strong bass line, keyboard accompaniment and a trumpet playing in unison with the vocals. The song is groovy and passionate and sounds like the theme song of a football club. The song audio quality is very poor. | 2010-10-01T18:21:22Z | zouhir564 | music wydad 2010 | ["Jazz", "Music", "Middle Eastern music"] | ["male singers", "vocal harmony", "trumpet playing in unison", "percussive bass line", "heavy bass drum rhythm", "brass band", "football match theme", "bad audio quality", "hissing tones", "spirited", "emotional", "medium tempo", "passionate", "fans", "steady drumming rhythm", "keyboard accompaniment"] | 1 | A3vsvL-Yx0Q | 1063 |
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;