Performance Metrics - Business Affairs & Consumer Protection - Retail Food Licenses

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id uxj2-up34
Name Performance Metrics - Business Affairs & Consumer Protection - Retail Food Licenses
Attribution City of Chicago
Category Administration & Finance
Tags performance metrics, service delivery, business, licenses
Created 2011-09-21T22:21:09Z
Publication Date 2011-10-19T18:54:20Z

Description

All restaurants and food stores selling perishable items are required to apply for a Retail Food License (RFL). This metric tracks the average number of days the Department of Business Affairs and Consumer Protection (BACP) takes to issue RFLs. The target response time for processing is within 15 days.

Columns

| Included | Schema Type    | Field Name                    | Name                          | Data Type | Render Type |
| ======== | ============== | ============================= | ============================= | ========= | =========== |
| Yes      | time           | week                          | Week                          | text      | text        |
| Yes      | numeric metric | total_licenses_issued         | Total Licenses Issued         | number    | number      |
| Yes      | numeric metric | average_days_to_issue_license | Average Days to Issue License | number    | number      |
| Yes      | numeric metric | median_days_to_issue_license  | Median Days to Issue License  | number    | number      |
| Yes      | numeric metric | target_days_to_issue_license  | Target Days to Issue License  | number    | number      |
| No       |                | quarter                       | Quarter                       | text      | text        |
| Yes      | numeric metric | weeks_target_was_achieved     | Weeks Target Was Achieved     | number    | number      |
| Yes      | numeric metric | weeks_target_was_not_achieved | Weeks Target Was Not Achieved | number    | number      |

Time Field

Value = week
Format & Zone = ww,yyyy

Series Fields

Excluded Fields = quarter

Data Commands

series e:uxj2-up34 d:2011-04-04T00:00:00.000Z m:median_days_to_issue_license=13 m:target_days_to_issue_license=15 m:weeks_target_was_not_achieved=0 m:average_days_to_issue_license=23.9 m:weeks_target_was_achieved=0 m:total_licenses_issued=22

series e:uxj2-up34 d:2011-04-11T00:00:00.000Z m:median_days_to_issue_license=26 m:target_days_to_issue_license=15 m:weeks_target_was_not_achieved=0 m:average_days_to_issue_license=72.5 m:weeks_target_was_achieved=0 m:total_licenses_issued=22

series e:uxj2-up34 d:2011-04-18T00:00:00.000Z m:median_days_to_issue_license=17 m:target_days_to_issue_license=15 m:weeks_target_was_not_achieved=0 m:average_days_to_issue_license=56 m:weeks_target_was_achieved=0 m:total_licenses_issued=34

Meta Commands

metric m:total_licenses_issued p:integer l:"Total Licenses Issued" t:dataTypeName=number

metric m:average_days_to_issue_license p:float l:"Average Days to Issue License" t:dataTypeName=number

metric m:median_days_to_issue_license p:double l:"Median Days to Issue License" t:dataTypeName=number

metric m:target_days_to_issue_license p:integer l:"Target Days to Issue License" t:dataTypeName=number

metric m:weeks_target_was_achieved p:integer l:"Weeks Target Was Achieved" t:dataTypeName=number

metric m:weeks_target_was_not_achieved p:integer l:"Weeks Target Was Not Achieved" t:dataTypeName=number

entity e:uxj2-up34 l:"Performance Metrics - Business Affairs & Consumer Protection - Retail Food Licenses" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/uxj2-up34

property e:uxj2-up34 t:meta.view v:id=uxj2-up34 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/performance v:averageRating=0 v:name="Performance Metrics - Business Affairs & Consumer Protection - Retail Food Licenses" v:attribution="City of Chicago"

property e:uxj2-up34 t:meta.view.owner v:id=vi9p-p863 v:screenName="Eric Phillips" v:displayName="Eric Phillips"

property e:uxj2-up34 t:meta.view.tableauthor v:id=vi9p-p863 v:screenName="Eric Phillips" v:displayName="Eric Phillips"

Top Records

| week                 | total_licenses_issued | average_days_to_issue_license | median_days_to_issue_license | target_days_to_issue_license | quarter | weeks_target_was_achieved | weeks_target_was_not_achieved | 
| ==================== | ===================== | ============================= | ============================ | ============================ | ======= | ========================= | ============================= | 
| Apr 4-10, 2011       | 22                    | 23.9                          | 13                           | 15                           | Q1 2011 | 0                         | 0                             | 
| Apr 11-17, 2011      | 22                    | 72.5                          | 26                           | 15                           | Q1 2011 | 0                         | 0                             | 
| Apr 18-24, 2011      | 34                    | 56                            | 17                           | 15                           | Q2 2011 | 0                         | 0                             | 
| Apr 25-30, 2011      | 25                    | 49.6                          | 23                           | 15                           | Q2 2011 | 0                         | 0                             | 
| May 2-8, 2011        | 34                    | 33.7                          | 13                           | 15                           | Q2 2011 | 0                         | 0                             | 
| May 9-15, 2011       | 30                    | 17.6                          | 12                           | 15                           | Q2 2011 | 0                         | 0                             | 
| May 16-22, 2011      | 22                    | 59.9                          | 18.5                         | 15                           | Q2 2011 | 0                         | 0                             | 
| May 23-29, 2011      | 39                    | 33.4                          | 18.5                         | 15                           | Q2 2011 | 0                         | 0                             | 
| May 30 - Jun 5, 2011 | 21                    | 45.3                          | 19                           | 15                           | Q2 2011 | 0                         | 0                             | 
| Jun 06-12, 2011      | 23                    | 52.3                          | 19                           | 15                           | Q2 2011 | 0                         | 0                             |