musiccaps_details (view)
3 rows where musiccaps_aspects contains "cymbals crashing", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- cymbals crashing · 3 ✖
- instrumental music · 3 ✖
- poor audio quality · 3 ✖
- energetic 2
- adrenaline rush 1
- advertisement jingle 1
- african tribal percussions 1
- ambient room noises 1
- busy office ambience 1
- busy work day 1
- camera click noises 1
- conductor 1
- day at the office 1
- death metal music 1
- exciting 1
- fast tempo 1
- groovy bas slime 1
- groovy bass line 1
- groovy rhythm 1
- guitar playing rhythm 1
- head banging 1
- hissing tones 1
- horns playing 1
- keyboard accompaniment 1
- medium fast tempo 1
- medium tempo 1
- mosh pit 1
- office adventure 1
- passionate 1
- percussive bass line 1
- philharmonic orchestra 1
- printer blues 1
- printer sounds 1
- retro death metal hits 1
- rock drumming 1
- safari adventure 1
- smooth jazz music 1
- spirited 1
- steady drumming rhythm 1
- string section 1
- strong drumming rhythm 1
- toner sounds 1
- violins playing 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sony A77II - Review On Sony A77 MARK II Digital SLR Camera | The song is an instrumental. The song is medium fast tempo with African folk drumming rhythm, string section, violins playing, horns and woodwinds playing in harmony. The song is adventurous and exciting. The song is an advertisement jingle for a DSLR camera complete with camera click tones. The audio is of poor quality. | 2014-05-02T05:19:05Z | SonyA77II | http://amzn.to/2n9wRW6 - Click the link Now For best offer Sony A77II - Review On Sony A77 MARK II Digital SLR Camera The α77II has the world's fastest continuous shooting speed in its class1—up to 12 frames per second at full resolution. Equipped with a 79 point AF sensor and advanced auto focus tracking, technology, you never have to miss a moment. The α77II outperforms even more expensive rivals with continuous auto focus and auto exposure when shooting at 12fps at full 24.3MP resolution and can capture up to 60 frames in a single burst when in JPEG fine setting. The α77II houses a large APS-C sensor with approx. 24.3 effective megapixels for incredible detail and gorgeous enlargements. Its high resolving power adopts the same gapless on-chip lens structure as the α77II features the latest-generation RGB color filter and other cutting-edge device technologies developed by Sony, the number 1 manufacturer of image sensors https://www.youtube.com/watch?v=2ZfthfWQowE Like US - https://www.facebook.com/Sonya77lldigitalslrcamera Vist for best shopping : www.lykamart.com | ["Music", "Single-lens reflex camera"] | ["instrumental music", "african tribal percussions", "medium fast tempo", "string section", "violins playing", "groovy bas slime", "cymbals crashing", "philharmonic orchestra", "energetic", "poor audio quality", "strong drumming rhythm", "horns playing", "conductor", "advertisement jingle", "exciting", "safari adventure", "camera click noises"] | 1 | 2ZfthfWQowE | 379 | |
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 | |
Crematory - Tick Tack | The song is an instrumental. The tempo is medium fast with strong metal drumming, groovy bass line, distorted guitar playing rhythm and cymbals crashing. The song is high on adrenaline and exciting. The audio quality is poor. | 2009-05-09T13:45:07Z | pavenpaul | Artist: Crematory Song: Tick Tack Album: Revolution Genre: Gothic metal Track # 6 | ["Music", "Rock music", "Angry music"] | ["instrumental music", "death metal music", "retro death metal hits", "poor audio quality", "cymbals crashing", "fast tempo", "groovy rhythm", "guitar playing rhythm", "rock drumming", "energetic", "adrenaline rush", "passionate", "head banging", "mosh pit", "spirited", "percussive bass line"] | 1 | gCSShNsw-_A | 4013 |
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;