List of free flu clinics offered throughout Chicago for the 2021-2022 flu season, either by the Department of Public Health or in collaboration with it.

Limited amounts of high-dose flu vaccines for seniors may be available throughout the season. Check https://www.chicago.gov/city/en/depts/cdph/supp_info/health-protection/flu-clinics-in-the-city-of-chicago.html for updates.

This view and the underlying dataset approximately follow https://github.com/codeforamerica/flu-shot-spec/blob/master/data-format.csv and are designed for use by https://github.com/tkompare/chicagoflushots.

For more information about the flu, go to https://www.cityofchicago.org/city/en/depts/cdph/provdrs/flu.html.

In order to help contractors and private residents avoid existing utility lines (including gas, electrical, and water lines) when digging, the Chicago Department of Transportation maintains 811 Chicago, a free, 24-hour service to private contractors and homeowners in Chicago. Anyone planning to dig within Chicago must obtain a “dig ticket” from 811 Chicago. 811 Chicago notifies all utilities of the impending excavations. The utility owners then send out staff to mark the location of the underground facilities within 48 hours (excluding emergencies), not counting Saturdays, Sundays, and holidays.

The dataset on which this filtered view is based shows these utility notifications. Since it is common for the same dig ticket to produce multiple notifications, the same dig ticket will appear multiple times and the dataset cannot be used without further refinement to count, map, or analyze unique excavations in Chicago.

This filtered view shows only the columns that should remain constant for a dig ticket and de-duplicates them, Therefore, it should represent a unique list of dig tickets. Because of the technique used, while it is possible to show the LATITUDE and LONGITUDE columns, it is not possible to show the LOCATION column and therefore not possible to create map views directly from this filtered view within the data portal software.

See https://ipi.cityofchicago.org/Digger for more information on the dig ticket system.

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 shows those trips. For more information see https://divvybikes.com/system-data.

A filtered view of records where the ACTIVE column contains, Yes -- indicating that the the code is in active use -- from the underlying "Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) Codes" dataset. Values of No indicate retired codes, retained for historical reference.

See the dataset description of the underlying dataset (linked above) for information about the data.

Transportation Network Provider Trips in 2023

A filtered view of only Community Area records from the parent CCVI dataset.

All lobbyist registration filings submitted to the Board of Ethics beginning with the 2012 reporting period. / All lobbyists must register with the City of Chicago Board of Ethics by filing a Statement of Registration within five business days of engaging in lobbying activity and annually thereafter by January 20th. Lobbyist registration information is submitted to the Board of Ethics in paper form and is available in its entirety in the Board's offices. The Board has, since 2000, compiled and posted static lists of all lobbyists and their clients online. Previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. From this point forward, the Board of Ethics will electronically compile more data about lobbyists and their activities and automatically report this information online.

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

The Chicago Building Energy Use Benchmarking Ordinance calls on existing municipal, commercial, and residential buildings larger than 50,000 square feet to track whole-building energy use, report to the City annually, and verify data accuracy every three years. The law, which phases in from 2014-2017, covers less than 1% of Chicago’s buildings, which account for approximately 20% of total energy used by all buildings. For more details, including ordinance text, rules and regulations, and timing, please visit www.CityofChicago.org/EnergyBenchmarking

The ordinance authorizes the City to share property-specific information with the public, beginning with the second year in which a building is required to comply.

This view shows data for a single year.

All trips, starting November 2018, reported by Transportation Network Providers (sometimes called rideshare companies) to the City of Chicago as part of routine reporting required by ordinance.

Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes. Fares are rounded to the nearest $2.50 and tips are rounded to the nearest $1.00.

For a discussion of the approach to privacy in this dataset, please see http://dev.cityofchicago.org/open%20data/data%20portal/2019/04/12/tnp-taxi-privacy.html.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- All open rodent baiting requests and rat complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets & Sanitation investigates reported rat sightings. Alley conditions are examined. If any damaged carts are identified, Sanitation Ward Offices, which distribute the carts are notified. Rodenticide is placed in rat burrows to eradicate nests. 311 sometimes receives duplicate rat complaints and requests for rodent baiting. 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 reports/requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

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

All lobbyist registration filings submitted to the Board of Ethics beginning with the 2012 reporting period. / All lobbyists must register with the City of Chicago Board of Ethics by filing a Statement of Registration within five business days of engaging in lobbying activity and annually thereafter by January 20th. Lobbyist registration information is submitted to the Board of Ethics in paper form and is available in its entirety in the Board's offices. The Board has, since 2000, compiled and posted static lists of all lobbyists and their clients online. Previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. From this point forward, the Board of Ethics will electronically compile more data about lobbyists and their activities and automatically report this information online.

The Chicago Building Energy Use Benchmarking Ordinance calls on existing municipal, commercial, and residential buildings larger than 50,000 square feet to track whole-building energy use, report to the City annually, and verify data accuracy every three years. The law, which phases in from 2014-2017, covers less than 1% of Chicago’s buildings, which account for approximately 20% of total energy used by all buildings. For more details, including ordinance text, rules and regulations, and timing, please visit www.CityofChicago.org/EnergyBenchmarking

The ordinance authorizes the City to share property-specific information with the public, beginning with the second year in which a building is required to comply.

This view shows data for a single year.

Records are added to the Building Code Scofflaw List every six months and these records are the ones in effect until the next update. Older records are kept in the dataset for historical reference. This filtered view shows just the current records -- those with the most recent BUILDING LIST DATE.

Please see the description section for the full dataset for further information about the data.

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.

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- All open graffiti removal requests made to 311 and all requests completed since January 1, 2011. The Department of Streets & Sanitation's Graffiti Blasters crews offer a vandalism removal service to private property owners. Graffiti Blasters employ "blast" trucks that use baking soda under high water pressure to erase painted graffiti from brick, stone and other mineral surfaces. They also use paint trucks to cover graffiti on the remaining surfaces. Organizations and residents may report graffiti and request its removal.
311 sometimes receives duplicate requests for graffiti removal. 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 reports/requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

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

Note: This filtered view shows only those service requests from the underlying dataset that are not marked as duplicates. -- All open sanitation code complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets and Sanitation investigates and remedies reported violations of Chicago’s sanitation code. Residents may request service for violations such as overflowing dumpsters and garbage in the alley.
311 sometimes receives duplicate sanitation code complaints. Requests that have been labeled as duplicates are in the same geographic area as a previous request and have been entered into 311’s Customer Service Request (CSR) system at around the same time. Duplicate complaints are labeled as such in the status field, as either "Open - Dup" or "Completed - Dup."
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 Report Sanitation Code Complaint (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=locform&invSRType=SCB&invSRDesc=Sanitation%20Code%20Violation&locreq=Y&stnumreqd=Y).

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

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.

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.

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