Name: Performance Metrics - 311 Call Center
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Performance Metrics - 311 Call Center

To make 311 effective for residents, visitors, and business owners, 311 representatives must respond to calls in a timely and accurate manner.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:06.345732
Tags: performance-metrics, service-delivery

Tables

Table 1

@usgov.city_of_chicago_performance_metrics_311_call_center.table_1

35.97 kB
270 rows
23 columns

CREATE TABLE table_1 (
  "sort" BIGINT,
  "dates" VARCHAR,
  "average_number_of_operators_mon_fri_7_00am_3_00pm" DOUBLE  -- Average Number Of Operators, Mon-Fri, (7:00AM-3:00PM),
  "average_number_of_operators_mon_fri_3_00pm_11_00pm" DOUBLE  -- Average Number Of Operators, Mon-Fri, (3:00PM-11:00PM),
  "average_number_of_operators_mon_fri_11_00pm_7_00am" DOUBLE  -- Average Number Of Operators, Mon-Fri, (11:00PM-7:00AM),
  "average_number_of_operators_sat_sun_7_00am_3_00pm" DOUBLE  -- Average Number Of Operators, Sat-Sun, (7:00AM-3:00PM),
  "average_number_of_operators_sat_sun_3_00pm_11_00pm" DOUBLE  -- Average Number Of Operators, Sat-Sun, (3:00PM-11:00PM),
  "average_number_of_operators_sat_sun_11_00pm_7_00am" DOUBLE  -- Average Number Of Operators, Sat-Sun, (11:00PM-7:00AM),
  "call_volume_7_00am_3_00pm" DOUBLE  -- Call Volume (7:00AM-3:00PM),
  "call_volume_3_00pm_11_00pm" DOUBLE  -- Call Volume (3:00PM-11:00PM),
  "call_volume_11_00pm_7_00am" DOUBLE  -- Call Volume (11:00PM-7:00AM),
  "efficiency_7_00am_3_00pm" DOUBLE  -- Efficiency (7:00AM-3:00PM),
  "efficiency_3_00pm_11_00pm" DOUBLE  -- Efficiency (3:00PM-11:00PM),
  "efficiency_11_00pm_7_00am" DOUBLE  -- Efficiency (11:00PM-7:00AM),
  "utilization_7_00am_3_00pm" DOUBLE  -- Utilization (7:00AM-3:00PM),
  "utilization_3_00pm_11_00pm" DOUBLE  -- Utilization (3:00PM-11:00PM),
  "utilization_11_00pm_7_00am" DOUBLE  -- Utilization (11:00PM-7:00AM),
  "abandoned_7_00am_3_00pm" DOUBLE  -- Abandoned (7:00AM-3:00PM),
  "abandoned_3_00pm_11_00pm" DOUBLE  -- Abandoned (3:00PM-11:00PM),
  "abandoned_11_00pm_7_00am" DOUBLE  -- Abandoned (11:00PM-7:00AM),
  "average_wait_time_seconds_7_00am_3_00pm" DOUBLE  -- Average Wait Time (seconds): 7:00AM-3:00PM,
  "average_wait_time_seconds_3_00pm_11_00pm" DOUBLE  -- Average Wait Time (seconds): 3:00PM-11:00PM,
  "average_wait_time_seconds_11_00pm_7_00am" DOUBLE  -- Average Wait Time (seconds): 11:00PM-7:00AM
);