Chicago Crime 2018

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
Neighborhood Neighborhood.neighborhood Neighborhood.area_number Community_Area Community_Area.area_number Community_Area.community_area_name Community_Area.side District District.district_number District.name District.address District.zip_code District.commander District.email District.phone District.fax District.tty District.twitter FBI_Code FBI_Code.code FBI_Code.title FBI_Code.description FBI_Code.crime_against 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 IUCR IUCR.iucr IUCR.primary_description IUCR.secondary_description IUCR.index code Crime Crime.crime_id Crime.case_number Crime.date Crime.block Crime.iucr Crime.location_description Crime.arrest Crime.domestic Crime.beat Crime.district Crime.ward Crime.community_area Crime.fbi_code Crime.latitude Crime.longitude Crime JOIN District ON Crime.district = District.district_number Crime JOIN IUCR ON Crime.iucr = IUCR.iucr Crime JOIN Ward ON Crime.ward = Ward.ward_no Crime JOIN FBI_Code ON Crime.fbi_code = FBI_Code.code Crime JOIN Community_Area ON Crime.community_area = Community_Area.area_number Neighborhood JOIN Community_Area ON Neighborhood.area_number = Community_Area.area_number