Chicago Crime

Database Diagram for Chicago Crime Data

2001 - 2002 - 2003 - 2004 - 2005 - 2006 - 2007 - 2008 - 2009 - 2010 - 2011 - 2012 - 2013 - 2014 - 2015 - 2016 - 2017 - 2018 - 2019
Community_Area Community_Area.community_area_no Community_Area.community_area_name Community_Area.side Community_Area.population Crime Crime.report_no Crime.case_number Crime.date Crime.block Crime.iucr_no Crime.location_description Crime.arrest Crime.domestic Crime.beat Crime.district_no Crime.ward_no Crime.community_area_no Crime.fbi_code_no Crime.latitude Crime.longitude Crime.location District District.district_no District.district_name District.address District.zip_code District.commander District.email District.phone District.fax District.tty District.twitter FBI_Code FBI_Code.fbi_code_no FBI_Code.title FBI_Code.description FBI_Code.crime_against IUCR IUCR.iucr_no IUCR.primary_description IUCR.secondary_description IUCR.index_code Neighborhood Neighborhood.neighborhood_name Neighborhood.community_area_no Ward Ward.ward_no Ward.alderman_first_name Ward.alderman_last_name Ward.alderman_name_suffix Ward.ward_office_address Ward.ward_office_zip Ward.ward_email Ward.ward_office_phone Ward.ward_office_fax Ward.city_hall_office_room Ward.city_hall_office_phone Ward.city_hall_office_fax Ward.population District JOIN Crime ON District.district_no = Crime.district_no Crime JOIN FBI_Code ON Crime.fbi_code_no = FBI_Code.fbi_code_no Crime JOIN Community_Area ON Crime.community_area_no = Community_Area.community_area_no Community_Area JOIN Neighborhood ON Community_Area.community_area_no = Neighborhood.community_area_no Crime JOIN IUCR ON Crime.iucr_no = IUCR.iucr_no Crime JOIN Ward ON Crime.ward_no = Ward.ward_no