Top 500 Indian Cities

What story do the top 500 cities of India tell to the world?

@kaggle.zed9941_top_500_indian_cities

Table List

1 table(76.25 KB)

Cities R2

@kaggle.zed9941_top_500_indian_cities.cities_r2

76.25 KB
493 rows
22 columns

name_of_city Name Of City	state_code State Code	state_name State Name	dist_code Dist Code	population_total Population Total	population_male Population Male	population_female Population Female	n_0_6_population_total 0-6 Population Total	n_0_6_population_male 0-6 Population Male	n_0_6_population_female 0-6 Population Female	literates_total Literates Total	literates_male Literates Male	literates_female Literates Female	sex_ratio Sex Ratio	child_sex_ratio Child Sex Ratio	effective_literacy_rate_total Effective Literacy Rate Total	effective_literacy_rate_male Effective Literacy Rate Male	effective_literacy_rate_female Effective Literacy Rate Female	location Location	total_graduates Total Graduates	male_graduates Male Graduates	female_graduates Female Graduates
Abohar	3	PUNJAB	9	145238	76840	68398	15870	8587	7283	103319	58347	44972	890	848	79.86	85.49	73.59	30.1452928,74.1993043	16287	8612	7675
Achalpur	27	MAHARASHTRA	7	112293	58256	54037	11810	6186	5624	92433	49347	43086	928	909	91.99	94.77	89	21.257584,77.5086754	8863	5269	3594
Adilabad	28	ANDHRA PRADESH	1	117388	59232	58156	13103	6731	6372	83955	46295	37660	982	947	80.51	88.18	72.73	19.0809075,79.560344	10565	6797	3768
Adityapur	20	JHARKHAND	24	173988	91495	82493	23042	12063	10979	125985	71470	54515	902	910	83.46	89.98	76.23	22.7834741,86.1576889	19225	12189	7036
Adoni	28	ANDHRA PRADESH	21	166537	82743	83794	18406	9355	9051	101292	56203	45089	1013	968	68.38	76.58	60.33	15.6322227,77.2728368	11902	7871	4031
Agartala	16	TRIPURA	1	399688	199616	200072	33635	17341	16294	343633	174524	169109	1002	940	93.88	95.75	92.02	23.831457,91.2867777	52711	30215	22496
Agra	9	UTTAR PRADESH	15	1574542	849771	724771	186516	105279	81237	880530	503805	376725	853	772	63.44	67.67	58.54	27.1766701,78.0080745	185813	106082	79731
Ahmadabad	24	GUJARAT	7	5570585	2935869	2634716	589076	317917	271159	4464303	2459823	2004480	897	853	89.62	93.96	84.81	23.022505,72.5713621	769858	435267	334591
Ahmadnagar	27	MAHARASHTRA	26	350905	179755	171150	36712	19748	16964	287468	152819	134649	952	859	91.49	95.51	87.33	19.0952075,74.7495916	51661	29832	21829
Aizawl	15	MIZORAM	3	291822	143803	148019	35147	17667	17480	253588	125256	128332	1029	989	98.8	99.3	98.31	23.727107,92.7176389	26832	14900	11932


CREATE TABLE cities_r2 (
  "name_of_city" VARCHAR,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "dist_code" BIGINT,
  "population_total" BIGINT,
  "population_male" BIGINT,
  "population_female" BIGINT,
  "n_0_6_population_total" BIGINT,
  "n_0_6_population_male" BIGINT,
  "n_0_6_population_female" BIGINT,
  "literates_total" BIGINT,
  "literates_male" BIGINT,
  "literates_female" BIGINT,
  "sex_ratio" BIGINT,
  "child_sex_ratio" BIGINT,
  "effective_literacy_rate_total" DOUBLE,
  "effective_literacy_rate_male" DOUBLE,
  "effective_literacy_rate_female" DOUBLE,
  "location" VARCHAR,
  "total_graduates" BIGINT,
  "male_graduates" BIGINT,
  "female_graduates" BIGINT
);