A list and count of all unique employers from registrations filed in 2012. This view is created based on lobbyists registrations from 2012 to present.

A public passenger vehicle is a vehicle used for the transportation of passengers for hire by a public chauffeur. This filtered view contains only licensed taxicabs. The dataset of public passenger vehicles on which this view is based includes licensed taxicabs (medallions), liveries, ambulances, medicars, charter-sightseeing buses, horse-drawn carriages, and pedicabs. For more information, please see http://www.cityofchicago.org/city/en/depts/bacp/supp_info/bacppublicvehicles.html.

Combined statements of revenues, expenditures, and changes in fund balances for the year ending December 31, 2009.

When moisture seeps into pavement, it expands when it freezes and contracts when it thaws. This flexing of the pavement, combined with the melted water and the stress of vehicular traffic, causes pavement to deteriorate and potholes to form. The Department of Transportation (CDOT) responds to potholes reported through 311’s Customer Service Requests (CSR) system by mapping open pothole requests each morning and routing crews in geographic clusters so as to fill as many potholes as possible per day. This metric tracks the average number of days CDOT takes to complete pothole repairs per week. Total number of requests fulfilled per week is also available by mousing over columns. The target response time for pothole repairs is within 7 days. For more information about pothole repairs, see CDOT’s pothole Frequently Asked Questions page: http://www.cityofchicago.org/content/dam/city/depts/cdot/PotholeFAQ_winter1011.pdf

Beginning July 1, 2017, pharmaceutical representatives who market or promote pharmaceuticals within the City of Chicago for more than fifteen calendar days per year are required to obtain a Pharmaceutical Representative License, under an ordinance passed by City Council in the fall of 2016.

Pharmaceutical representatives must complete an online education session at the time of initial application and then complete at least five hours per year of approved continuing education thereafter. When requested by the Commissioner of the Chicago Department of Public Health, pharmaceutical representatives also must disclose information related to the marketing or promotion of the pharmaceuticals, pharmacological classes, or categories of pharmaceuticals listed on the Chicago Department of Public Health website.

For more information on the Pharmaceutical Representative License, see https://www.cityofchicago.org/city/en/depts/cdph/provdrs/behavioral_health/svcs/pharmaceutical-representative-license.html.

List of public events sponsored by the Chicago Department of Public Health

Total number of TIF districts with creation and end dates, and summary of eligibility factors.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- This dataset contains all open 311 reports of one or more lights out on a wooden pole in the alley and all completed requests since January 1, 2011. If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open)”. Once the alley light is repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.

A Bed and Breakfast License is required to rent out rooms in a home to overnight guests, and to provide a breakfast meal. Currently the performance target for processing Bed and Breakfast Licenses is 15 days.

A public passenger vehicle is a vehicle used for the transportation of passengers for hire by a public chauffeur. This filtered view contains only licensed taxicabs. The dataset of public passenger vehicles on which this view is based includes licensed taxicabs (medallions), liveries, ambulances, medicars, charter-sightseeing buses, horse-drawn carriages, and pedicabs. For more information, please see http://www.cityofchicago.org/city/en/depts/bacp/supp_info/bacppublicvehicles.html.

This lists individual Divvy bike sharing trips, including the origin, destination, and timestamps for each trip. Trips are included when there is an starting and end date. Trips using a subscriber pass will include some basic demographic data (gender and age) that is associated with the account. This view excludes those trips. For more information see https://ride.divvybikes.com/system-data.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- All open and completed tree trim requests made to 311 since January 1, 2011. The Department of Streets and Sanitation maintains all trees growing in the public way and performs regular maintenance trimming in response to 311 requests. Crisis trimming is performed on an emergency basis in response to hazardous conditions such as broken or hanging branches. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

Ranking of the number of clients per industry. This view is created based on lobbyists registrations from 2012 to present.

A public passenger vehicle is a vehicle used for the transportation of passengers for hire by a public chauffeur. This filtered view contains only licensed taxicabs. The dataset of public passenger vehicles on which this view is based includes licensed taxicabs (medallions), liveries, ambulances, medicars, charter-sightseeing buses, horse-drawn carriages, and pedicabs. For more information, please see http://www.cityofchicago.org/city/en/depts/bacp/supp_info/bacppublicvehicles.html.

Applications to the Chicago Department of Transportation for permits under its jurisdiction, which typically are permits to block or otherwise affect public streets in some way. Because all permits start as applications, this dataset also serves as a list of permits granted. See more information about CDOT permits at http://www.cityofchicago.org/city/en/depts/cdot/provdrs/construction_information/svcs/online-permit-portal.html.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- All open tree debris removal requests made to 311 and all requests completed since January 1, 2011. Large piles of branches or bushes may be picked up by the Department of Streets and Sanitation.
311 sometimes creates duplicate requests for tree debris removal. When there is an open tree debris request, a duplicate request is created when the exact same address and the exact same service request type are used. Streets and Sanitation responds to the initial request opened and closes the duplicates. A forestry "Clam" is the name of the vehicle the Forestry Bureau deploys to collect tree debris.
Data Owner: Streets and Sanitation (http://www.cityofchicago.org/content/city/en/depts/streets.html).
Time Period: January 1, 2011 to present.
Frequency: Data is updated daily.
Related Applications: 311 Service Request Status Inquiry (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=createsrquery2) and
Request Tree Debris Removal (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=locform&invSRType=SEL&invSRDesc=Tree%20Debris&locreq=Y).

City of Chicago Mental Health, Sexually Transmitted Infection (STI) Specialty, and Women Infant Children (WIC) clinic locations, hours of operation and contact information.

Combined statements of revenues, expenditures, and changes in fund balances for the year ending December 31, 2009.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- This dataset contains all open 311 reports of one or two lights out on metal poles on a residential or arterial street and all completed requests since January 1, 2011. Whenever CDOT receives a report of a street light outage, the electrician assigned to make the repair looks at all the lights in a group (circuit) to make sure that they are working properly. If two requests regarding the same group are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open).” Since the electrician will be looking at all the lights in a group to verify that they are all working the “Duplicate (Open)” address will also be observed and repaired. Once the street lights are repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.

When moisture seeps into pavement, it expands when it freezes and contracts when it thaws. This flexing of the pavement, combined with the melted water and the stress of vehicular traffic, causes pavement to deteriorate and potholes to form. The Department of Transportation (CDOT) responds to potholes reported through 311’s Customer Service Requests (CSR) system by mapping open pothole requests each morning and routing crews in geographic clusters so as to fill as many potholes as possible per day. This metric tracks the average number of days CDOT takes to complete pothole repairs per week. Total number of requests fulfilled per week is also available by mousing over columns. The target response time for pothole repairs is within 7 days. For more information about pothole repairs, see CDOT’s pothole Frequently Asked Questions page: http://www.cityofchicago.org/content/dam/city/depts/cdot/PotholeFAQ_winter1011.pdf

Combined statements of revenues, expenditures, and changes in fund balances for the year ending December 31, 2009.

When moisture seeps into pavement, it expands when it freezes and contracts when it thaws. This flexing of the pavement, combined with the melted water and the stress of vehicular traffic, causes pavement to deteriorate and potholes to form. The Department of Transportation (CDOT) responds to potholes reported through 311’s Customer Service Requests (CSR) system by mapping open pothole requests each morning and routing crews in geographic clusters so as to fill as many potholes as possible per day. This metric tracks the average number of days CDOT takes to complete pothole repairs per week. Total number of requests fulfilled per week is also available by mousing over columns. The target response time for pothole repairs is within 7 days. For more information about pothole repairs, see CDOT’s pothole Frequently Asked Questions page: http://www.cityofchicago.org/content/dam/city/depts/cdot/PotholeFAQ_winter1011.pdf

Combined statements of revenues, expenditures, and changes in fund balances for the year ending December 31, 2009.

The Chicago Park District tests water samples at beaches along Chicago's Lake Michigan lakefront, which it tests for E. coli in order to monitor swimming safety. Multiple samples may be taken from a beach and samples may be tested by culture, DNA testing, or both.

What do these numbers mean?

The modeling prediction numbers forecast real-time Escherichia coli (E. coli) bacteria levels present in the water. The Chicago Park District (CPD) in partnership with the US Geological Survey, has developed statistical prediction models by using weather data pulled from CPD buoys (https://data.cityofchicago.org/d/qmqz-2xku) and weather stations (https://data.cityofchicago.org/d/k7hf-8y75). E. coli is an indicator species for the presence of disease-causing bacteria, viruses, and protozoans that may pose health risks to the public.

The culture based testing numbers indicate E. coli levels present in the water. This method requires 18-24 hours of processing to receive results. US Environmental Protection Agency (USEPA) recommends notifying the public when E. coli bacteria levels are above the federal water quality Beach Action Value (BAV), which is 235*CFU. When bacteria levels exceed 235 CFU, a yellow or red flag will be implemented. This standard is used at beaches throughout the Great Lakes region. For more information please refer to the USEPA Recreational Water Quality Criteria.

The rapid testing method (qPCR analysis) is a new method that measures levels of pathogenic DNA in beach water. Unlike the culture based test that requires up to 24 hours of processing, the new rapid testing method requires a few hours for results. The Chicago Park District can use results of the rapid test to notify the public when levels exceed UPEPA recommended levels. US Environmental Protection Agency (USEPA) recommends notifying the public when DNA bacteria levels are above the federal water quality Beach Action Value (BAV), which is 1000*CCE. When DNA bacteria levels exceed 1000 CCE, a yellow or red flag will be implemented. For more information please refer to the USEPA Recreational Water Quality Criteria (http://water.epa.gov/scitech/swguidance/standards/criteria/health/recreation).

* The unit of measurement for Escherichia coli is Colony Forming Units (CFU) per 100 milliliters of water.
*The unit of measuring DNA is Enterococci Calibrator Cell Equivalents (CCE) per 100 milliliters of water.