Quick stats

Top 25 addresses by SR

 cnt |                   address
-----+---------------------------------------------
 926 | 7900 S STONY ISLAND AVE, CHICAGO, IL, 60617
 785 | 4700 S LAKE PARK AVE, CHICAGO, IL, 60615
 773 | 9500 S STONY ISLAND AVE, CHICAGO, IL, 60617
 702 | 7900 S KEDZIE AVE, CHICAGO, IL, 60652
 652 | 8700 S WESTERN AVE, CHICAGO, IL
 645 | 9500 S JEFFERY AVE, CHICAGO, IL, 60617
 616 | 2400 W PETERSON AVE, CHICAGO, IL, 60659
 612 | 1000 W HOLLYWOOD AVE, CHICAGO, IL, 60660
 560 | 8700 S STATE ST, CHICAGO, IL, 60619
 556 | 3200 W BELMONT AVE, CHICAGO, IL, 60618
 525 | 4801 N CICERO AVE, CHICAGO, IL, 60630
 498 | 7100 S PULASKI RD, CHICAGO, IL, 60629
 491 | 8700 S STONY ISLAND AVE, CHICAGO, IL, 60617
 482 | 2400 W OGDEN AVE, CHICAGO, IL, 60608
 464 | 8300 S VINCENNES AVE, CHICAGO, IL, 60620
 462 | , CHICAGO, IL
 459 | 2400 W FULLERTON AVE, CHICAGO, IL, 60647
 439 | 6700 S STONY ISLAND AVE, CHICAGO, IL, 60649
 434 | 8700 S LAFAYETTE AVE, CHICAGO, IL, 60620
 423 | 7100 S STONY ISLAND AVE, CHICAGO, IL, 60649
 409 | 6400 N CALDWELL AVE, CHICAGO, IL, 60646
 398 | 1000 N LAKE SHORE DR, CHICAGO, IL, 60611
 396 | 9500 S ASHLAND AVE, CHICAGO, IL, 60643
 391 | 7900 S GREENWOOD AVE, CHICAGO, IL, 60619
 390 | 5700 S KENTON AVE, CHICAGO, IL, 60629

cwfy=# SELECT COUNT(*) AS cnt, service_name FROM service_requests WHERE address = '7900 S STONY ISLAND AVE, CHICAGO, IL, 60617' GROUP BY service_name ORDER BY cnt DESC;
 cnt |          service_name
-----+--------------------------------
 761 | Traffic Signal Out
  75 | Pothole in Street
  61 | Street Lights All / Out
   8 | Restaurant Complaint
   6 | Graffiti Removal
   5 | Street Light 1 / Out
   4 | Pavement Cave-In Survey
   3 | Sanitation Code Violation
   2 | Rodent Baiting / Rat Complaint
   1 | Building Violation
(10 rows)

cwfy=# SELECT COUNT(*) AS cnt, service_name FROM service_requests WHERE address = '4700 S LAKE PARK AVE, CHICAGO, IL, 60615' GROUP BY service_name ORDER BY cnt DESC;
 cnt |          service_name
-----+--------------------------------
 610 | Pothole in Street
  70 | Traffic Signal Out
  54 | Street Lights All / Out
  16 | Pavement Cave-In Survey
  12 | Graffiti Removal
  10 | Building Violation
   3 | Rodent Baiting / Rat Complaint
   3 | Street Cut Complaints
   3 | Restaurant Complaint
   2 | Sanitation Code Violation
   1 | Tree Debris
   1 | Street Light 1 / Out
(12 rows)

SR by Type

cwfy=# SELECT COUNT(*) AS cnt, service_name FROM service_requests GROUP BY service_name ORDER BY cnt DESC;
  cnt   |          service_name
--------+--------------------------------
 927865 | Graffiti Removal
 444532 | Pothole in Street
 348829 | Street Lights All / Out
 195729 | Rodent Baiting / Rat Complaint
 173859 | Abandoned Vehicle
 151718 | Alley Light Out
 144910 | Building Violation
 142025 | Tree Debris
 141323 | Street Light 1 / Out
 123047 | Traffic Signal Out
 114055 | Sanitation Code Violation
  39235 | Pavement Cave-In Survey
  18292 | Restaurant Complaint
   7836 | Street Cut Complaints
(14 rows)

Unique Addresses

cwfy=# SELECT COUNT(DISTINCT(address)) FROM service_requests;
 count
--------
 706324

2013 So far

cwfy=# SELECT COUNT(*) AS cnt, service_name FROM service_requests WHERE requested_datetime >= '2013-01-01'::date GROUP BY service_name ORDER BY cnt DESC;
  cnt  |          service_name
-------+--------------------------------
 76745 | Graffiti Removal
 50162 | Pothole in Street
 23723 | Street Lights All / Out
 12989 | Rodent Baiting / Rat Complaint
 11539 | Building Violation
 10848 | Abandoned Vehicle
 10785 | Traffic Signal Out
  9708 | Street Light 1 / Out
  9348 | Sanitation Code Violation
  9073 | Tree Debris
  7296 | Alley Light Out
  3893 | Pavement Cave-In Survey
  1326 | Restaurant Complaint
   931 | Street Cut Complaints
(14 rows)