Name: Ferndale Drug Incidents And NARCAN Use, 2007-2017
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero

About this Dataset

Ferndale Drug Incidents And NARCAN Use, 2007-2017

The incident numbers have been anonymized, and do not correlate with the CLEMIS (internal police data) number. Note that there are sometimes multiple rows for the same incident.
The data set includes the number of Narcan Kits used by police in each incident.
Because there can be multiple rows for the same incident, the Narcan use and kits can also be duplicated. There are 31 current uses of Narcan by the Police, but 37 rows are flagged as having used Narcan because of multiple codes on the same incident. This is important to note so users of the data set doesn't double count the number of incidents, or artificially inflate the number of kits used by counting them multiple times for the same incident.
The addresses have been anonymized to the block level.
All drug-related incidents since 2007 have been pulled (codes 35XX), but several instances of Narcan use were in other categories. Therefore the data set also includes all C3225 incidents (drug overdose), as well as 3 other codes (C3217, C3208, C3332) because they had Narcan uses. However, these 3 were only for the incidents that involved Narcan (so all other incidents of C3217, C3208, and C3332 codes were not pulled).
Sometimes a block number is given, sometimes two cross streets, and sometimes only a general street for location data. This is just a limitation of what was entered into CLEMIS at the time. The addresses were geocoded in a batch process.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:59:06.756672
Tags: fern_featured, fern_new, ferndale, narcan, police, safety

Tables

Table 1

@usgov.city_of_ferndale_michigan_ferndale_drug_incidents_and__c7adc22f.table_1

68.55 KB
2078 rows
20 columns


CREATE TABLE table_1 (
  "incident_anonymous_number" BIGINT,
  "date_key" BIGINT,
  "description" VARCHAR,
  "crime_class" VARCHAR,
  "block_number" DOUBLE,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_name_suffix" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "cross_street_direction" VARCHAR,
  "cross_street_name" VARCHAR,
  "cross_street_name_sfx" VARCHAR,
  "narcan_kits_used" DOUBLE,
  "narcan_used" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "e_f_g_h_i_j_k_undefined_undefin" VARCHAR,
  "fid" BIGINT
);