Baselight

Mexican Crime Statistics:Comprehensive (2015-2023)

An Extensive Compilation of Criminal Incidents in Mexico, Sourced from Official

@kaggle.elanderos_official_crime_stats_mexico_2015_2023

Mexico Crime
@kaggle.elanderos_official_crime_stats_mexico_2015_2023.mexico_crime

  • 427.69 KB
  • 332416 rows
  • 9 columns
year

Year

entity_code

Entity Code

entity

Entity

affected_legal_good

Affected Legal Good

type_of_crime

Type Of Crime

subtype_of_crime

Subtype Of Crime

modality

Modality

month

Month

count

Count

20151AguascalientesLife and bodily integrityHomicideIntentional HomicideWith firearmJanuary3
20151AguascalientesLife and bodily integrityHomicideIntentional HomicideWith sharp weaponJanuary1
20151AguascalientesLife and bodily integrityHomicideIntentional HomicideWith another elementJanuary
20151AguascalientesLife and bodily integrityHomicideIntentional HomicideNot specifiedJanuary2
20151AguascalientesLife and bodily integrityHomicideManslaughterWith firearmJanuary
20151AguascalientesLife and bodily integrityHomicideManslaughterWith sharp weaponJanuary
20151AguascalientesLife and bodily integrityHomicideManslaughterIn traffic accidentJanuary14
20151AguascalientesLife and bodily integrityHomicideManslaughterWith another elementJanuary
20151AguascalientesLife and bodily integrityHomicideManslaughterNot specifiedJanuary2
20151AguascalientesLife and bodily integrityInjuriesIntentional InjuryWith firearmJanuary2

CREATE TABLE mexico_crime (
  "year" BIGINT,
  "entity_code" BIGINT,
  "entity" VARCHAR,
  "affected_legal_good" VARCHAR,
  "type_of_crime" VARCHAR,
  "subtype_of_crime" VARCHAR,
  "modality" VARCHAR,
  "month" VARCHAR,
  "count" BIGINT
);