musiccaps_details (view)
1 row where musiccaps_aspects contains "boomy bass", musiccaps_aspects contains "distorted bass" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Nino D'Aprile @ Sound X-Plosion SCRATCH -30.1.10- Tronix AFTERHOUR | Distorted, low fidelity house music live recorded from a nightclub featuring a boomy, blown out bass, male vocal sample and a woman shouting. Poorly recorded music for a boozy night out. | 2010-02-01T14:35:15Z | Save The Vinyl | X-Herford [Eks] Atomix Mr.Twister aka Marc Fisher / Twelve Inch aka Patrick Meier / Who Is Who / Millhouse / Nico De Luxe / Sopradoze aka Hou$egeflippt & No.23 / Dj Deville / Bob Morane / Spedro / NINO / Housegeflippt ( Late Night Beatz ) / G-Maxx / Ed Cee ( Keven Yard Limit Club - Lighthouse loud and proud minden ) / The Tablesliderz / Mr. Deepstar / Mighty Marc ( Go Parc Herford ) / Novel T. & Kay Topic ( Green Mark - Play Room Werry Kidz - Weser Beatz ) / Muzik Twinz ( michimuzik & A_Maze) X-Herford [Eks] Atomix ) Osianixx / 90-sechzig-90 / Booming B. / La Loona / Rekardo Rivalo / Dominic S. / Felix Kröcher / Format B / Moritz Piske / Hanne & Lore / Norman Zube / Rockwell & Landers / Funky Disco House - Minimal - Techno - Tech House - Electro - Speed Garage / Bünde / Herford / Bielefeld / Herford / Bad Qeynhausen / Müster / Melle / Osnabrück / Ego / Go Parc / Tronix / Depot / Dockland / Kick / Phuture Club / Mystic Land / Omen / Weser Beatz / PW / Stemwede / Waldfrieden / Underground / Level / Projekt / Break In / Cafe Europa / Dk Dance / Sound Garten / Aura / Glashaus / Fahrenheit / Relax / Dockland / Fusion / Index / Sfera / Mediahall / Gigaparc / Elephant Club / Stereo / Sams / Impuls / Stellwerk / Index / Bunker / Pollerwiesen / Sonne Mond Und Sterne / Time Warp / Love Family Park / Blauer See / Kiesgrube / Nature One / Loveparade / Street Parade / - DJ - Musik - Music - House - Electro - Minimal - Techhouse - Techno - Speed Garage - Club - Sound - Disco - Scratch - Scratchen - Mix - Mixe - Pioneer - CDJ 400 800 850 900 1000 mk3 mk2 Technics 1210 Turntable Party DJM 400 600 700 800 900 2000 | ["Beatboxing", "Music"] | ["low fidelity", "blown out", "house music", "boomy bass", "distorted bass", "woman shouting", "too loud", "nightclub", "poorly recorded", "live recording"] | 8 | j9hAUlz5kQs | 4240 |
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;