COPY (SELECT locations.latitude, locations.longitude, (SELECT COUNT(*) FROM eventzimmer.events WHERE events.location = locations.name) FROM eventzimmer.locations) TO stdout WITH csv;