musiccaps_details (view)
5 rows where musiccaps_aspects contains "digital", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| How to make Green Fire from Borax / How to make Boric Acid/ How to make wildfire | The low quality recording features an electro song that consists of a punchy kick, buzzy synth bass, claps and shimmering hi-hats. It sounds exciting and a bit too digital - like something you would hear in old video games. | 2013-06-17T07:13:48Z | PAChemistry | "Music courtesy of Kevin MacLeod (www.smartsound.com/royalty-free-music/incompetech)" If you already have boric acid or want to use borax, skip to 4:20 In this video i show you how to make your own boric acid from borax and other common chemicals to produce a green flame when mixed with methanol | ["Ringtone", "Music", "Rhythm and blues"] | ["low quality", "electro", "claps", "punchy kick", "buzzy synth bass", "shimmering hi hats", "digital", "exciting"] | 4 | 8pl1D6oG38k | 952 | |
| Tecktonik Music | The low quality recording features an electro song that consists of a "4 on the floor" kick pattern, groovy, buzzy synth bass and a reverberant down sweep at the very beginning of the loop. It sounds energetic and very digital - like something you would hear in old video games. | 2010-02-01T23:28:45Z | 0oLoboTeko0 | |Tecktonik Toluca | Unas cuantas canciones que quise compartir n_n :.:. lista de canciones .:.: 1.-Fly with me-Dj antonie 2.-House of house-Dj Dess 3.-oh i like (whitenoise remix)-like woah 4.-Push That System (Lazy Rich Remix) -Costello feat Ninelives Cat 5.-mario bros-tecktonik 6.-Tecktonik dance (original mix)-Dj chick 7.-work-Dj antonie | ["Drum and bass", "Music", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | ["groovy buzzy synth bass", "4 on the floor kick", "punchy snare", "reverberant down sweep", "electro", "low quality", "energetic", "digital"] | 4 | CLx4iYWSB1c | 1354 | |
| As a beginner you need a special music maker software | The low quality recording features an electro song that consists of a punchy "4 on the floor" kick pattern, shimmering hi hats, mellow claps, repetitive synth bass, short snare roll, subtle synth bells melody and loud synth lead melody. Even though it is thin, it is still something you would hear as an energetic track in a club. | 2013-12-26T09:58:11Z | Rosanne Bertao | http://tinyurl.com/kczhfp9 As a beginner you need a special music maker software Just making slight modifications can be a horrible and frustrating struggle if you don't have a ton of experience. Not like Dr. Drum, which makes it all come naturally. | ["Music", "Techno", "Dubstep", "Electronic dance music", "Ambient music", "Dance music", "Electronica"] | ["low quality", "digital", "repetitive synth bass", "punchy \"4 on the floor\" kick pattern", "mellow clapping", "shimmering hi hats", "subtle synth bells melody", "loud synth lead melody", "short snare roll", "electro", "energetic", "thin"] | 4 | VDYqYuPzW8E | 2985 | |
| Registradora Juguete | The low quality recording features a detuned synth lead melody played on some kind of kids toy. It sounds very digital, like an 8bit melody and the recording is very noisy. | 2012-03-07T14:18:06Z | Alberto Provedo | ["Cash register", "Music"] | ["low quality", "detuned synth lead melody", "noisy", "tapping sound effect", "digital", "8 bit", "kids toys"] | 4 | _qP21HqOmA0 | 3495 | ||
| 80s Synth Riffs | The low quality recording features synth strings in the left channel, synth keys melody, synth bells melody in the right channel of the stereo image, groovy bass, shimmering hi hats and mellow snare. It sounds digital, but it gives off happy and fun vibes. | 2015-01-10T07:13:55Z | shochan8883 | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["low quality", "synth strings melody", "synth lead melody", "synth keys melody", "synth bells melody", "groovy bass", "shimmering hi hats", "mellow snare", "digital", "fun", "happy"] | 4 | xVi1wNljxjk | 5336 |
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;