https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Approximately 10 people are shot on an average day in Chicago.
http://www.chicagotribune.com/news/data/ct-shooting-victims-map-charts-htmlstory.html http://www.chicagotribune.com/news/local/breaking/ct-chicago-homicides-data-tracker-htmlstory.html http://www.chicagotribune.com/news/local/breaking/ct-homicide-victims-2017-htmlstory.html
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. This data includes unverified reports supplied to the Police Department. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time.
Update Frequency: Daily
Fork this kernel to get started.
https://bigquery.cloud.google.com/dataset/bigquery-public-data:chicago_crime
https://cloud.google.com/bigquery/public-data/chicago-crime-data
Dataset Source: City of Chicago
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source —https://data.cityofchicago.org — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.
Banner Photo by Ferdinand Stohr from Unplash.
What categories of crime exhibited the greatest year-over-year increase between 2015 and 2016?
Which month generally has the greatest number of motor vehicle thefts?
How does temperature affect the incident rate of violent crime (assault or battery)?
https://cloud.google.com/bigquery/images/chicago-scatter.png" alt="">
https://cloud.google.com/bigquery/images/chicago-scatter.png
This dataset contains individual-level homicide and non-fatal shooting victimizations, including homicide data from 1991 to the present, and non-fatal shooting data from 2010 to the present (2010 is the earliest available year for shooting data). This dataset includes a "GUNSHOT_INJURY_I " column to indicate whether the victimization involved a shooting, showing either Yes ("Y"), No ("N"), or Unknown ("UKNOWN.") For homicides, injury descriptions are available dating back to 1991, so the "shooting" column will read either "Y" or "N" to indicate whether the homicide was a fatal shooting or not. For non-fatal shootings, data is only available as of 2010. As a result, for any non-fatal shootings that occurred from 2010 to the present, the shooting column will read as “Y.” Non-fatal shooting victims will not be included in this dataset prior to 2010; they will be included in the authorized-access dataset, but with "UNKNOWN" in the shooting column.
Each row represents a single victimization, i.e., a unique event when an individual became the victim of a homicide or non-fatal shooting. Each row does not represent a unique victim—if someone is victimized multiple times there will be multiple rows for each of those distinct events.
The dataset is refreshed daily, but excludes the most recent complete day to allow the Chicago Police Department (CPD) time to gather the best available information. Each time the dataset is refreshed, records can change as CPD learns more about each victimization, especially those victimizations that are most recent. The data on the Mayor's Office Violence Reduction Dashboard is updated daily with an approximately 48-hour lag. As cases are passed from the initial reporting officer to the investigating detectives, some recorded data about incidents and victimizations may change once additional information arises. Regularly updated datasets on the City's public portal may change to reflect new or corrected information.
A version of this dataset with additional crime types is available by request. To make a request, please email dataportal@cityofchicago.org with the subject line: Violence Reduction Victims Access Request. Access will require an account on this site, which you may create at https://data.cityofchicago.org/signup.
How does this dataset classify victims?
The methodology by which this dataset classifies victims of violent crime differs by victimization type:
Homicide and non-fatal shooting victims: A victimization is considered a homicide victimization or non-fatal shooting victimization depending on its presence in CPD's homicide victims data table or its shooting victims data table. A victimization is considered a homicide only if it is present in CPD's homicide data table, while a victimization is considered a non-fatal shooting only if it is present in CPD's shooting data tables and absent from CPD's homicide data table.
To determine the IUCR code of homicide and non-fatal shooting victimizations, we defer to the incident IUCR code available in CPD's Crimes, 2001-present dataset (available on the City's open data portal). If the IUCR code in CPD's Crimes dataset is inconsistent with the homicide/non-fatal shooting categorization, we defer to CPD's Victims dataset. For a criminal homicide, the only sensible IUCR codes are 0110 (first-degree murder) or 0130 (second-degree murder). For a non-fatal shooting, a sensible IUCR code must signify a criminal sexual assault, a robbery, or, most commonly, an aggravated battery. In rare instances, the IUCR code in CPD's Crimes and Victims dataset do not align with the homicide/non-fatal shooting categorization:
Other violent crime victims: For other violent crime types, we refer to the IUCR classification that exists in CPD's victim table, with only one exception:
Note: The definition of “homicide” (shooting or otherwise) does not include justifiable homicide or involuntary manslaughter. This dataset also excludes any cases that CPD considers to be “unfounded” or “noncriminal.” Officer-involved shootings are not included.
Note: The initial reporting officer usually asks victims to report demographic data. If victims are unable to recall, the reporting officer will use their best judgment. “Unknown” can be reported if it is truly unknown.
Note: In some instances, CPD's raw incident-level data and victim-level data that were inputs into this dataset do not align on the type of crime that occurred. In those instances, this dataset attempts to correct mismatches between incident and victim specific crime types. When it is not possible to determine which victims are associated with the most reliable crime determination, the dataset will show empty cells in the respective demographic fields (age, sex, race, etc.).
Note: Homicide victims names are delayed by two weeks to allow time for the victim’s family to be notified of their passing.
Note: The initial reporting officer usually asks victims to report demographic data. If victims are unable to recall, the reporting officer will use their best judgment. “Unknown” can be reported if it is truly unknown.
Note: This dataset includes variables referencing administrative or political boundaries that are subject to change. These include Street Outreach Organization boundary, Ward, Chicago Police Department District, Chicago Police Department Area, Chicago Police Department Beat, Illinois State Senate District, and Illinois State House of Representatives District. These variables reflect current geographic boundaries as of November 1st, 2021. In some instances, current boundaries may conflict with those that were in place at the time that a given incident occurred in prior years. For example, the Chicago Police Department districts 021 and 013 no longer exist. Any historical violent crime victimization that occurred in those districts when they were in existence are marked in this dataset as having occurred in the current districts that expanded to replace 013 and 021."
This dataset contains aggregate data on violent index victimizations at the quarter level of each year (i.e., January – March, April – June, July – September, October – December), from 2001 to the present (1991 to present for Homicides), with a focus on those related to gun violence. Index crimes are 10 crime types selected by the FBI (codes 1-4) for special focus due to their seriousness and frequency. This dataset includes only those index crimes that involve bodily harm or the threat of bodily harm and are reported to the Chicago Police Department (CPD). Each row is aggregated up to victimization type, age group, sex, race, and whether the victimization was domestic-related. Aggregating at the quarter level provides large enough blocks of incidents to protect anonymity while allowing the end user to observe inter-year and intra-year variation. Any row where there were fewer than three incidents during a given quarter has been deleted to help prevent re-identification of victims. For example, if there were three domestic criminal sexual assaults during January to March 2020, all victims associated with those incidents have been removed from this dataset. Human trafficking victimizations have been aggregated separately due to the extremely small number of victimizations.
This dataset includes a " GUNSHOT_INJURY_I " column to indicate whether the victimization involved a shooting, showing either Yes ("Y"), No ("N"), or Unknown ("UKNOWN.") For homicides, injury descriptions are available dating back to 1991, so the "shooting" column will read either "Y" or "N" to indicate whether the homicide was a fatal shooting or not. For non-fatal shootings, data is only available as of 2010. As a result, for any non-fatal shootings that occurred from 2010 to the present, the shooting column will read as “Y.” Non-fatal shooting victims will not be included in this dataset prior to 2010; they will be included in the authorized dataset, but with "UNKNOWN" in the shooting column.
The dataset is refreshed daily, but excludes the most recent complete day to allow CPD time to gather the best available information. Each time the dataset is refreshed, records can change as CPD learns more about each victimization, especially those victimizations that are most recent. The data on the Mayor's Office Violence Reduction Dashboard is updated daily with an approximately 48-hour lag. As cases are passed from the initial reporting officer to the investigating detectives, some recorded data about incidents and victimizations may change once additional information arises. Regularly updated datasets on the City's public portal may change to reflect new or corrected information.
How does this dataset classify victims?
The methodology by which this dataset classifies victims of violent crime differs by victimization type:
Homicide and non-fatal shooting victims: A victimization is considered a homicide victimization or non-fatal shooting victimization depending on its presence in CPD's homicide victims data table or its shooting victims data table. A victimization is considered a homicide only if it is present in CPD's homicide data table, while a victimization is considered a non-fatal shooting only if it is present in CPD's shooting data tables and absent from CPD's homicide data table.
To determine the IUCR code of homicide and non-fatal shooting victimizations, we defer to the incident IUCR code available in CPD's Crimes, 2001-present dataset (available on the City's open data portal). If the IUCR code in CPD's Crimes dataset is inconsistent with the homicide/non-fatal shooting categorization, we defer to CPD's Victims dataset.
For a criminal homicide, the only sensible IUCR codes are 0110 (first-degree murder) or 0130 (second-degree murder). For a non-fatal shooting, a sensible IUCR code must signify a criminal sexual assault, a robbery, or, most commonly, an aggravated battery. In rare instances, the IUCR code in CPD's Crimes and Victims dataset do not align with the homicide/non-fatal shooting categorization:
Other violent crime victims: For other violent crime types, we refer to the IUCR classification that exists in CPD's victim table, with only one exception:
Note: All businesses identified as victims in CPD data have been removed from this dataset.
Note: The definition of “homicide” (shooting or otherwise) does not include justifiable homicide or involuntary manslaughter. This dataset also excludes any cases that CPD considers to be “unfounded” or “noncriminal.”
Note: In some instances, the police department's raw incident-level data and victim-level data that were inputs into this dataset do not align on the type of crime that occurred. In those instances, this dataset attempts to correct mismatches between incident and victim specific crime types. When it is not possible to determine which victims are associated with the most recent crime determination, the dataset will show empty cells in the respective demographic fields (age, sex, race, etc.).
Note: The initial reporting officer usually asks victims to report demographic data. If victims are unable to recall, the reporting officer will use their best judgment. “Unknown” can be reported if it is truly unknown.
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://data.cityofchicago.org/Public-Safety/Chicago-Police-Department-Illinois-Uniform-Crime-R/c7ck-438e
This project's main goal was to develop an analytical framework that could be used for analysis of rare crimes observed at local (intra-city) levels of geographic aggregation. To demonstrate the application of this framework to a real-world issue, this project analyzed the occurrence of different types of homicide at both the census tract and neighborhood cluster level in Chicago. Homicide counts for Chicago's 865 census tracts for 1989-1991 were obtained from HOMICIDES IN CHICAGO, 1965-1995 (ICPSR 6399), Part 1: Victim Level Data. The types of homicide examined were gang-related, instrumental, family-related expressive, known person expressive, stranger expressive, and other. Demographic and socioeconomic data at the census tract level for the year 1990 were obtained from the Neighborhood Change Database (NCDB) at the Urban Institute. Part 1 contains these data, as initially obtained, at the census tract level. Part 2 contains an aggregated version of the same data for Chicago's 343 neighborhood clusters as defined by the Project on Human Development in Chicago's Neighborhoods.
CSV file of Homicide Crimes in Chicago for the year 2017.For use with the Chicago Crime NCEA Level 2 Geography assessment.Downloaded from the City of Chicago data portal July 2023.
NOTE: This dataset has been retired and marked as historical-only.
This dataset is a companion to the COVID-19 Daily Cases and Deaths dataset (https://data.cityofchicago.org/d/naz8-j4nc). The major difference in this dataset is that the case, death, and hospitalization corresponding rates per 100,000 population are not those for the single date indicated. They are rolling averages for the seven-day period ending on that date. This rolling average is used to account for fluctuations that may occur in the data, such as fewer cases being reported on weekends, and small numbers. The intent is to give a more representative view of the ongoing COVID-19 experience, less affected by what is essentially noise in the data.
All rates are per 100,000 population in the indicated group, or Chicago, as a whole, for “Total” columns.
Only Chicago residents are included based on the home address as provided by the medical provider.
Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the date the test specimen was collected. Deaths among cases are aggregated by day of death. Hospitalizations are reported by date of first hospital admission. Demographic data are based on what is reported by medical providers or collected by CDPH during follow-up investigation.
Denominators are from the U.S. Census Bureau American Community Survey 1-year estimate for 2018 and can be seen in the Citywide, 2018 row of the Chicago Population Counts dataset (https://data.cityofchicago.org/d/85cm-7uqa).
All data are provisional and subject to change. Information is updated as additional details are received and it is, in fact, very common for recent dates to be incomplete and to be updated as time goes on. At any given time, this dataset reflects cases and deaths currently known to CDPH.
Numbers in this dataset may differ from other public sources due to definitions of COVID-19-related cases and deaths, sources used, how cases and deaths are associated to a specific date, and similar factors.
Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, U.S. Census Bureau American Community Survey
This dataset reflects reported incidents of crime that have occurred in the City of Chicago over the past year, minus the most recent seven days of data. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited.
The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. Any use of the information for commercial purposes is strictly prohibited. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily.
These datasets contain information on every homicide in the murder analysis files of the Chicago Police Department for the years 1965-1995. For the victim-level file, Part 1, data are provided on the relationship of victim to offender, whether the victim or offender had previously committed a violent or nonviolent offense, time of occurrence and place of homicide, type of weapon used, cause and motivation for the incident, whether the incident involved drugs, alcohol, gangs, child abuse, or a domestic relationship, if or how the offender was identified, and information on the death of the offender(s). Demographic variables such as the age, sex, and race of each victim and offender are also provided. The victim-level file contains one record for each victim. Information for up to five offenders is included on each victim record. The same offender information is duplicated depending on the number of victims. For example, if a sole offender is responsible for five victims, the file contains five victim records with the offender's information repeated on each record. Part 2, Offender-Level Data, is provided to allow the creation of offender rates and risk analysis that could not be accurately prepared using the victim-level file due to the repeating of the offender information on each victim record. Offender variables were reorganized during the creation of the offender file so that each known offender is associated with a single record. A majority of the variables in the offender-level file are replicas of variables in the victim-level file. The offender records contain demographic information about the offender, demographic and relationship information about the offender's first victim (or sole victim if there was only one), and information about the homicide incident. Information pertaining to the homicide incident such as location, weapon, or drug use are the same as in the victim-level file. In cases where the offender data were completely missing in the victim-level data, no offender records were generated in the offender-level file. The offender-level data do not contain information about the victims in these cases. Geographic variables in both files include the census tract, community area, police district, and police area.
NOTE: This dataset has been retired and marked as historical-only. Only Chicago residents are included based on the home ZIP Code as provided by the medical provider. If a ZIP was missing or was not valid, it is displayed as "Unknown". Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the week the test specimen was collected. For privacy reasons, until a ZIP Code reaches five cumulative cases, both the weekly and cumulative case counts will be blank. Therefore, summing the “Cases - Weekly” column is not a reliable way to determine case totals. Deaths are those that have occurred among cases based on the week of death. For tests, each test is counted once, based on the week the test specimen was collected. Tests performed prior to 3/1/2020 are not included. Test counts include multiple tests for the same person (a change made on 10/29/2020). PCR and antigen tests reported to Chicago Department of Public Health (CDPH) through electronic lab reporting are included. Electronic lab reporting has taken time to onboard and testing availability has shifted over time, so these counts are likely an underestimate of community infection. The “Percent Tested Positive” columns are calculated by dividing the number of positive tests by the number of total tests . Because of the data limitations for the Tests columns, such as persons being tested multiple times as a requirement for employment, these percentages may vary in either direction from the actual disease prevalence in the ZIP Code. All data are provisional and subject to change. Information is updated as additional details are received. To compare ZIP Codes to Chicago Community Areas, please see http://data.cmap.illinois.gov/opendata/uploads/CKAN/NONCENSUS/ADMINISTRATIVE_POLITICAL_BOUNDARIES/CCAzip.pdf. Both ZIP Codes and Community Areas are also geographic datasets on this data portal. Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, Illinois Vital Records, American Community Survey (2018)
Note: This dataset is historical only and there are not corresponding datasets for more recent time periods. For that more-recent information, please visit the Chicago Health Atlas at https://chicagohealthatlas.org. This dataset contains the cumulative number of deaths, average number of deaths annually, average annual crude and adjusted death rates with corresponding 95% confidence intervals, and average annual years of potential life lost per 100,000 residents aged 75 and younger due to selected causes of death, by Chicago community area, for the years 2006 – 2010. A ranking for each measure is also provided, with the highest value indicated with a ranking of 1. See the full description at: https://data.cityofchicago.org/api/views/6vw3-8p6f/files/CqPqfHSv8UUAoXCBjn4_tLqcQHhb36Ih4-meM-4zNzs?download=true&filename=P:\EPI\OEPHI\MATERIALS\REFERENCES\MORTALITY\Dataset_Description_06_10_PORTAL_ONLY.pdf
The goal of the Chicago Women's Health Risk Study (CWHRS) was to develop a reliable and validated profile of risk factors directly related to lethal or life-threatening outcomes in intimate partner violence, for use in agencies and organizations working to help women in abusive relationships. Data were collected to draw comparisons between abused women in situations resulting in fatal outcomes and those without fatal outcomes, as well as a baseline comparison of abused women and non-abused women, taking into account the interaction of events, circumstances, and interventions occurring over the course of a year or two. The CWHRS used a quasi-experimental design to gather survey data on 705 women at the point of service for any kind of treatment (related to abuse or not) sought at one of four medical sites serving populations in areas with high rates of intimate partner homicide (Chicago Women's Health Center, Cook County Hospital, Erie Family Health Center, and Roseland Public Health Center). Over 2,600 women were randomly screened in these settings, following strict protocols for safety and privacy. One goal of the design was that the sample would not systematically exclude high-risk but understudied populations, such as expectant mothers, women without regular sources of health care, and abused women in situations where the abuse is unknown to helping agencies. To accomplish this, the study used sensitive contact and interview procedures, developed sensitive instruments, and worked closely with each sample site. The CWHRS attempted to interview all women who answered "yes -- within the past year" to any of the three screening questions, and about 30 percent of women who did not answer yes, provided that the women were over age 17 and had been in an intimate relationship in the past year. In total, 705 women were interviewed, 497 of whom reported that they had experienced physical violence or a violent threat at the hands of an intimate partner in the past year (the abused, or AW, group). The remaining 208 women formed the comparison group (the non-abused, or NAW, group). Data from the initial interview sections comprise Parts 1-8. For some women, the AW versus NAW interview status was not the same as their screening status. When a woman told the interviewer that she had experienced violence or a violent threat in the past year, she and the interviewer completed a daily calendar history, including details of important events and each violent incident that had occurred the previous year. The study attempted to conduct one or two follow-up interviews over the following year with the 497 women categorized as AW. The follow-up rate was 66 percent. Data from this part of the clinic/hospital sample are found in Parts 9-12. In addition to the clinic/hospital sample, the CWHRS collected data on each of the 87 intimate partner homicides occurring in Chicago over a two-year period that involved at least one woman age 18 or older. Using the same interview schedule as for the clinic/hospital sample, CWHRS interviewers conducted personal interviews with one to three "proxy respondents" per case, people who were knowledgeable and credible sources of information about the couple and their relationship, and information was compiled from official or public records, such as court records, witness statements, and newspaper accounts (Parts 13-15). In homicides in which a woman was the homicide offender, attempts were made to contact and interview her. This "lethal" sample, all such homicides that took place in 1995 or 1996, was developed from two sources, HOMICIDES IN CHICAGO, 1965-1995 (ICPSR 6399) and the Cook County Medical Examiner's Office. Part 1 includes demographic variables describing each respondent, such as age, race and ethnicity, level of education, employment status, screening status (AW or NAW), birthplace, and marital status. Variables in Part 2 include details about the woman's household, such as whether she was homeless, the number of people living in the household and details about each person, the number of her children or other children in the household, details of any of her children not living in her household, and any changes in the household structure over the past year. Variables in Part 3 deal with the woman's physical and mental health, including pregnancy, and with her social support network and material resources. Variables in Part 4 provide information on the number and type of firearms in the household, whether the woman had experienced power, control, stalking, or harassment at the hands of an intimate partner in the past year, whether she had experienced specific types of violence or violent threats at the hands of an intimate partner in the past year, and whether she had experienced symptoms of Post-Traumatic Stress Disorder related to the incidents in the past month. Variables in Part 5 specify the partner or partners who were responsible for the incidents in the past year, record the type and length of the woman's relationship with each of these partners, and provide detailed information on the one partner she chose to talk about (called "Name"). Variables in Part 6 probe the woman's help-seeking and interventions in the past year. Variables in Part 7 include questions comprising the Campbell Danger Assessment (Campbell, 1993). Part 8 assembles variables pertaining to the chosen abusive partner (Name). Part 9, an event-level file, includes the type and the date of each event the woman discussed in a 12-month retrospective calendar history. Part 10, an incident-level file, includes variables describing each violent incident or threat of violence. There is a unique identifier linking each woman to her set of events or incidents. Part 11 is a person-level file in which the incidents in Part 10 have been aggregated into totals for each woman. Variables in Part 11 include, for example, the total number of incidents during the year, the number of days before the interview that the most recent incident had occurred, and the severity of the most severe incident in the past year. Part 12 is a person-level file that summarizes incident information from the follow-up interviews, including the number of abuse incidents from the initial interview to the last follow-up, the number of days between the initial interview and the last follow-up, and the maximum severity of any follow-up incident. Parts 1-12 contain a unique identifier variable that allows users to link each respondent across files. Parts 13-15 contain data from official records sources and information supplied by proxies for victims of intimate partner homicides in 1995 and 1996 in Chicago. Part 13 contains information about the homicide incidents from the "lethal sample," along with outcomes of the court cases (if any) from the Administrative Office of the Illinois Courts. Variables for Part 13 include the number of victims killed in the incident, the month and year of the incident, the gender, race, and age of both the victim and offender, who initiated the violence, the severity of any other violence immediately preceding the death, if leaving the relationship triggered the final incident, whether either partner was invading the other's home at the time of the incident, whether jealousy or infidelity was an issue in the final incident, whether there was drug or alcohol use noted by witnesses, the predominant motive of the homicide, location of the homicide, relationship of victim to offender, type of weapon used, whether the offender committed suicide after the homicide, whether any criminal charges were filed, and the type of disposition and length of sentence for that charge. Parts 14 and 15 contain data collected using the proxy interview questionnaire (or the interview of the woman offender, if applicable). The questionnaire used for Part 14 was identical to the one used in the clinic sample, except for some extra questions about the homicide incident. The data include only those 76 cases for which at least one interview was conducted. Most variables in Part 14 pertain to the victim or the offender, regardless of gender (unless otherwise labeled). For ease of analysis, Part 15 includes the same 76 cases as Part 14, but the variables are organized from the woman's point of view, regardless of whether she was the victim or offender in the homicide (for the same-sex cases, Part 15 is from the woman victim's point of view). Parts 14 and 15 can be linked by ID number. However, Part 14 includes five sets of variables that were asked only from the woman's perspective in the original questionnaire: household composition, Post-Traumatic Stress Disorder (PTSD), social support network, personal income (as opposed to household income), and help-seeking and intervention. To avoid redundancy, these variables appear only in Part 14. Other variables in Part 14 cover information about the person(s) interviewed, the victim's and offender's age, sex, race/ethnicity, birthplace, employment status at time of death, and level of education, a scale of the victim's and offender's severity of physical abuse in the year prior to the death, the length of the relationship between victim and offender, the number of children belonging to each partner, whether either partner tried to leave and/or asked the other to stay away, the reasons why each partner tried to leave, the longest amount of time each partner stayed away, whether either or both partners returned to the relationship before the death, any known physical or emotional problems sustained by victim or offender, including the four-item Medical Outcomes Study (MOS) scale of depression, drug and alcohol use of the victim and offender, number and type of guns in the household of the victim and offender, Scales of Power and Control (Johnson, 1996) or Stalking and Harassment (Sheridan, 1992) by either intimate partner in the year prior to the death, a modified version of the Conflict Tactics Scale (CTS)
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://data.cityofchicago.org/Public-Safety/Chicago-Police-Department-Illinois-Uniform-Crime-R/c7ck-438e
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘COVID-19 Daily Rolling Average Case, Death, and Hospitalization Rates’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/7acadb5f-3204-4ca3-8e83-2741d562f100 on 13 February 2022.
--- Dataset description provided by original source is as follows ---
This is the place to look for important information about how to use this dataset, so please expand this box and read on!
This is the source data for some of the metrics available at https://www.chicago.gov/city/en/sites/covid-19/home/latest-data.html.
For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.
This dataset is a companion to the COVID-19 Daily Cases and Deaths dataset (https://data.cityofchicago.org/d/naz8-j4nc). The major difference in this dataset is that the case, death, and hospitalization corresponding rates per 100,000 population are not those for the single date indicated. They are rolling averages for the seven-day period ending on that date. This rolling average is used to account for fluctuations that may occur in the data, such as fewer cases being reported on weekends, and small numbers. The intent is to give a more representative view of the ongoing COVID-19 experience, less affected by what is essentially noise in the data.
All rates are per 100,000 population in the indicated group, or Chicago, as a whole, for “Total” columns.
Only Chicago residents are included based on the home address as provided by the medical provider.
Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the date the test specimen was collected. Deaths among cases are aggregated by day of death. Hospitalizations are reported by date of first hospital admission. Demographic data are based on what is reported by medical providers or collected by CDPH during follow-up investigation.
Denominators are from the U.S. Census Bureau American Community Survey 1-year estimate for 2018 and can be seen in the Citywide, 2018 row of the Chicago Population Counts dataset (https://data.cityofchicago.org/d/85cm-7uqa).
All data are provisional and subject to change. Information is updated as additional details are received and it is, in fact, very common for recent dates to be incomplete and to be updated as time goes on. At any given time, this dataset reflects cases and deaths currently known to CDPH.
Numbers in this dataset may differ from other public sources due to definitions of COVID-19-related cases and deaths, sources used, how cases and deaths are associated to a specific date, and similar factors.
Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, U.S. Census Bureau American Community Survey
--- Original source retains full ownership of the source dataset ---
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that have occurred in the City of Chicago over the past year, minus the most recent seven days of data. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited.
The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://bit.ly/rk5Tpc.
This dataset contains detailed information on homicides in eight United States cities: Philadelphia, Newark, Chicago, St. Louis, Memphis, Dallas, Oakland, and "Ashton" (a representative large western city). Detailed characteristics for each homicide victim include time and date of homicide, age, gender, race, place of birth, marital status, living arrangement, occupation, socioeconomic status (SES), employment status, method of assault, location where homicide occurred, relationship of victim to offender, circumstances surrounding death, precipitation or resistance of victim, physical evidence collected, victim's drug history, victim's prior criminal record, and number of offenders identified. Data on up to two offenders and three witnesses are also available and include the criminal history, justice system disposition, and age, sex, and race of each offender. Information on the age, sex, and race of each witness also was collected, as were data on witness type (police informant, child, eyewitness, etc.). Finally, information from the medical examiner's records including results of narcotics and blood alcohol tests of the victim are provided.
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
This study investigates the factors and conditions in robbery events that cause victim injury or death. The investigators compare three robbery events: those that resulted in death, those that cause injury, and nonfatal robberies of all types. The events were compared on a variety of demographic variables. The data address the following questions: (1) To what extent are homicides resulting from robbery misclassified as homicides for which motives are undetermined? (2) How often do homicides resulting from robbery involve individuals who do not know each other? (3) Are robberies that involve illicit drugs more likely to result in the death of the victim? (4) To what extent does a weapon used in a robbery affect the probability that a victim will die? (5) To what extent does victim resistance affect the likelihood of victim death? (6) To what extent does robbery lead to physical injury? (7) Do individuals of different races suffer disproportionately from injuries resulting from robbery? (8) Are injuries and homicides resulting from robbery more likely to occur in a residence, commercial establishment, or on the street? (9) Are women or men more likely to be victims of homicide or injury resulting from robbery? (10) To what extent does robbery (with or without a homicide) occur between or within races? (12) How long does it take to solve robbery-related crimes? Major variables characterizing the unit of observation, the robbery event, include: location of the robbery incident, numbers of offenders and victims involved in the incident, victim's and offender's prior arrest and conviction histories, the extent of injury, whether or not drugs were involved in any way, type of weapon used, victim/offender relationship, and the extent of victim resistance.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘COVID-19 Cases, Tests, and Deaths by ZIP Code’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/04f6ebfb-8a04-45ff-9335-984cd5a4e200 on 13 February 2022.
--- Dataset description provided by original source is as follows ---
This is the place to look for important information about how to use this dataset, so please expand this box and read on!
This is the source data for some of the metrics available at https://www.chicago.gov/city/en/sites/covid-19/home/latest-data.html.
For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.
Only Chicago residents are included based on the home ZIP Code as provided by the medical provider. If a ZIP was missing or was not valid, it is displayed as "Unknown".
Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the week the test specimen was collected. For privacy reasons, until a ZIP Code reaches five cumulative cases, both the weekly and cumulative case counts will be blank. Therefore, summing the “Cases - Weekly” column is not a reliable way to determine case totals. Deaths are those that have occurred among cases based on the week of death.
For tests, each test is counted once, based on the week the test specimen was collected. Tests performed prior to 3/1/2020 are not included. Test counts include multiple tests for the same person (a change made on 10/29/2020). PCR and antigen tests reported to Chicago Department of Public Health (CDPH) through electronic lab reporting are included. Electronic lab reporting has taken time to onboard and testing availability has shifted over time, so these counts are likely an underestimate of community infection.
The “Percent Tested Positive” columns are calculated by dividing the number of positive tests by the number of total tests . Because of the data limitations for the Tests columns, such as persons being tested multiple times as a requirement for employment, these percentages may vary in either direction from the actual disease prevalence in the ZIP Code.
All data are provisional and subject to change. Information is updated as additional details are received.
To compare ZIP Codes to Chicago Community Areas, please see http://data.cmap.illinois.gov/opendata/uploads/CKAN/NONCENSUS/ADMINISTRATIVE_POLITICAL_BOUNDARIES/CCAzip.pdf. Both ZIP Codes and Community Areas are also geographic datasets on this data portal.
Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, Illinois Vital Records, American Community Survey (2018)
--- Original source retains full ownership of the source dataset ---
The Chicago Department of Public Health (CDPH) receives weekly deidentified provisional death certificate data for all deaths that occur in Chicago, which can include both Chicago and non-Chicago residents from the Illinois Department of Public Health (IDPH) Illinois Vital Records System (IVRS). CDPH scans for keywords to identify deaths with COVID-19, influenza, or respiratory syncytial virus (RSV) listed as an immediate cause of death, contributing factor, or other significant condition. The percentage of all reported deaths that are attributed to COVID-19, influenza, or RSV is calculated as the number of deaths for each respective disease divided by the number of deaths from all causes, multiplied by 100. This dataset reflects death certificates that have been submitted to IVRS at the time of transmission to CDPH each week – data from previous weeks are not updated with any new submissions to IVRS. As such, estimates in this dataset may differ from those reported through other sources. This dataset can be used to understand trends in COVID-19, influenza, and RSV mortality in Chicago but does not reflect official death statistics. Source: Provisional deaths from the Illinois Department of Public Health Illinois Vital Records System.
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org. Disclaimer: These crimes may be based upon preliminary information supplied to the Police Department by the reporting parties that have not been verified. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time. The Chicago Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. All data visualizations on maps should be considered approximate and attempts to derive specific addresses are strictly prohibited. The Chicago Police Department is not responsible for the content of any off-site pages that are referenced by or that reference this web page other than an official City of Chicago or Chicago Police Department web page. The user specifically acknowledges that the Chicago Police Department is not responsible for any defamatory, offensive, misleading, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. The unauthorized use of the words "Chicago Police Department," "Chicago Police," or any colorable imitation of these words or the unauthorized use of the Chicago Police Department logo is unlawful. This web page does not, in any way, authorize such use. Data is updated daily Tuesday through Sunday. The dataset contains more than 65,000 records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. To access a list of Chicago Police Department - Illinois Uniform Crime Reporting (IUCR) codes, go to http://data.cityofchicago.org/Public-Safety/Chicago-Police-Department-Illinois-Uniform-Crime-R/c7ck-438e
https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Approximately 10 people are shot on an average day in Chicago.
http://www.chicagotribune.com/news/data/ct-shooting-victims-map-charts-htmlstory.html http://www.chicagotribune.com/news/local/breaking/ct-chicago-homicides-data-tracker-htmlstory.html http://www.chicagotribune.com/news/local/breaking/ct-homicide-victims-2017-htmlstory.html
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. This data includes unverified reports supplied to the Police Department. The preliminary crime classifications may be changed at a later date based upon additional investigation and there is always the possibility of mechanical or human error. Therefore, the Chicago Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information and the information should not be used for comparison purposes over time.
Update Frequency: Daily
Fork this kernel to get started.
https://bigquery.cloud.google.com/dataset/bigquery-public-data:chicago_crime
https://cloud.google.com/bigquery/public-data/chicago-crime-data
Dataset Source: City of Chicago
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source —https://data.cityofchicago.org — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.
Banner Photo by Ferdinand Stohr from Unplash.
What categories of crime exhibited the greatest year-over-year increase between 2015 and 2016?
Which month generally has the greatest number of motor vehicle thefts?
How does temperature affect the incident rate of violent crime (assault or battery)?
https://cloud.google.com/bigquery/images/chicago-scatter.png" alt="">
https://cloud.google.com/bigquery/images/chicago-scatter.png