Addresses by Zipcode

Count addresses in each zipcode

Custom SQL query returning 12 rows (hide) 

SELECT zipcode, COUNT(*) as addresses, COUNT(DISTINCT street_name) as streets FROM addresses GROUP BY zipcode ORDER BY addresses DESC

Edit SQL

This data as json, CSV

zipcodeaddressesstreets
94704 13577 49
94703 10525 70
94702 9199 86
94709 6738 36
94705 6600 76
94710 6182 48
94707 4327 80
94708 4235 96
94706 676 20
94720 85 2
94618 57 5
94609 25 1