Dataset: 911 Calls

About this Dataset

911 Calls

• Context The police/cops are always there to help out people
that require their assistance. They are the reason that people are
able to live peacefully and happily without any fear. This data set
contains the data of such 911 calls that were made in the past.
• Content: The data set contains the data about latitude and
longitude of the places from where call was made. It also
contains a short description of the call, the station that took the
call, the reason behind the call and other relevant data.

Tables

N 911

@kaggle.sailohitakshreddyd_911_calls.n_911

4.63 MB
99492 rows
9 columns


CREATE TABLE n_911 (
  "lat" DOUBLE,
  "lng" DOUBLE,
  "desc" VARCHAR,
  "zip" DOUBLE,
  "title" VARCHAR,
  "timestamp" TIMESTAMP,
  "twp" VARCHAR,
  "addr" VARCHAR,
  "e" BIGINT
);

Addressdata

@kaggle.sailohitakshreddyd_911_calls.addressdata

1.59 MB
86637 rows
6 columns


CREATE TABLE addressdata (
  "index" BIGINT,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "zip" BIGINT,
  "addr" VARCHAR,
  "twp" VARCHAR
);

Crimedata

@kaggle.sailohitakshreddyd_911_calls.crimedata

618.03 KB
86637 rows
3 columns


CREATE TABLE crimedata (
  "index" BIGINT,
  "type" VARCHAR,
  "subcategory" VARCHAR
);

Timedata

@kaggle.sailohitakshreddyd_911_calls.timedata

668.21 KB
86637 rows
6 columns


CREATE TABLE timedata (
  "index" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "holiday" VARCHAR,
  "weekday" VARCHAR,
  "noon" VARCHAR
);