Cyber Crime Statewise (INDIA)

This file contains statewise cyber crime in India from year 2016-2018

@kaggle.amritvirsinghx_cyber_crime_statewise

Table List

1 table(8.9 KB)

Cyber Crimes

@kaggle.amritvirsinghx_cyber_crime_statewise.cyber_crimes

8.9 KB
39 rows
9 columns

s_no S. No	category Category	state_ut State/UT	n_2016 2016	n_2017 2017	n_2018 2018	percentage_share_of_state_ut_2018 Percentage Share Of State/UT (2018)	mid_year_projected_population_in_lakhs_2018 Mid-Year Projected Population (in Lakhs) (2018)+	rate_of_total_cyber_crimes_2018 Rate Of Total Cyber Crimes (2018)++
1	State	Andhra Pradesh	616	931	1207	4.4	520.3	2.3
2	State	Arunachal Pradesh	4	1	7		14.9	0.5
3	State	Assam	696	1120	2022	7.4	340.4	5.9
4	State	Bihar	309	433	374	1.4	1183.3	0.3
5	State	Chhattisgarh	90	171	139	0.5	284.7	0.5
6	State	Goa	31	13	29	0.1	15.3	1.9
7	State	Gujarat	362	458	702	2.6	673.2	1
8	State	Haryana	401	504	418	1.5	284	1.5
9	State	Himachal Pradesh	31	56	69	0.3	72.7	0.9
10	State	Jammu & Kashmir	28	63	73	0.3	134.3	0.5


CREATE TABLE cyber_crimes (
  "s_no" VARCHAR,
  "category" VARCHAR,
  "state_ut" VARCHAR,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "percentage_share_of_state_ut_2018" DOUBLE,
  "mid_year_projected_population_in_lakhs_2018" DOUBLE,
  "rate_of_total_cyber_crimes_2018" DOUBLE
);