Dataset: Geospatial Sao Paulo Crime Database

About this Dataset

Geospatial Sao Paulo Crime Database

Context

There's a story behind every dataset and here's your opportunity to share yours.

Content

On this dataset, you have an rich data about crime incidents on São Paulo which specifies what has happened in the victim's view, as well as field indicating what objects were lost.

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Tables

Dataset Limpo

@kaggle.danlessa_geospatial_sao_paulo_crime_database.dataset_limpo

3.32 MB
12899 rows
36 columns


CREATE TABLE dataset_limpo (
  "id" BIGINT,
  "bairro" VARCHAR,
  "created_at" TIMESTAMP,
  "descricao" VARCHAR,
  "endereco" VARCHAR,
  "id_1" BIGINT,
  "ip_address_origin" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "registrou_bo" VARCHAR,
  "sexo" BIGINT,
  "tipo_assalto_id" BIGINT,
  "titulo" VARCHAR,
  "uri" VARCHAR,
  "user_id" DOUBLE,
  "valor_prejuizo" DOUBLE,
  "bicicleta" VARCHAR,
  "bolsa_ou_mochila" VARCHAR,
  "carteira" VARCHAR,
  "cart_o_de_cr_dito" VARCHAR,
  "celular" VARCHAR,
  "computador" VARCHAR,
  "dvd" VARCHAR,
  "dinheiro" VARCHAR,
  "documentos" VARCHAR,
  "equipamento_de_som" VARCHAR,
  "estepe" VARCHAR,
  "mp4_ou_ipod" VARCHAR,
  "m_veis" VARCHAR,
  "notebook" VARCHAR,
  "outros" VARCHAR,
  "rel_gio" VARCHAR,
  "som" VARCHAR,
  "tablet" VARCHAR,
  "tv" VARCHAR,
  "time" TIMESTAMP
);