India-RoadforPopulation-Data

The dataset has been compiled used the Annexures of the Transport ministry .

@kaggle.zsinghrahulk_india_roadforpopulation_data

Table List

1 table(27.96 KB)

India Road Population Data

@kaggle.zsinghrahulk_india_roadforpopulation_data.india_road_population_data

27.96 KB
36 rows
27 columns

name_of_the_states Name Of The States	national_highways National Highways	state_highways State Highways	district_roads District Roads	rural_roads Rural Roads	urban_roads Urban Roads	project_roads Project Roads	total_road_length Total Road Length	total_area Total Area	n__urban_road_density Urban Road Density	n__rural_road_density Rural Road Density	entire_state_road_length_per_1000_sq_km Entire State Road Length Per 1000 Sq Km	urban_road_lngth_per_1000_sq_km Urban Road Lngth Per 1000 Sq Km	rural_road_lngth_per_1000_sq_km Rural Road Lngth Per 1000 Sq Km	road_density Road Density	road_density_per_1000_sq_km_national_highways Road Density Per 1000 Sq. Km - National Highways	road_density_per_1000_sq_km_state_highways Road Density Per 1000 Sq. Km - State Highways	road_density_per_1000_sq_km_district_roads Road Density Per 1000 Sq. Km - District Roads	road_density_per_1000_sq_km_rural_roads Road Density Per 1000 Sq. Km - Rural Roads	road_density_per_1000_sq_km_urban_roads Road Density Per 1000 Sq. Km - Urban Roads	road_density_per_1000_sq_km_project_roads Road Density Per 1000 Sq. Km - Project Roads	area Area	rural_area_2011_census Rural Area (2011 Census)	urban_area_2011_census Urban Area (2011 Census)	rural_pop_2011_census Rural Pop (2011 Census)	urban_pop_2011_census Urban Pop (2011 Census)	total_population Total Population
Andhra Pradesh(*)	10709	15649	58083	180833	22724	28907	316906	275045	2893.1	676.8	1152	0.81	3.21	1152.2	38.9	56.9	211	657.47	82.62	105.1	275045	267191	7855	56361702	28219075	84580777
Arunachal Pradesh	2537	13500	8616	25832	59	4717	55262	83743			660	0.19	24.22	659.9	30.3	161.2	103	308.47	0.71	56.33	83743			1066358	317369	1383727
Assam	3909	2530	6093	372510	6268	7813	399122	78438	4974.7	4826.6	5088	1.42	13.9	5088.38	49.8	32.3	78	4749.11	79.9	99.6	78438	77178	1260	26807034	4398542	31205576
Bihar	5358	4006	12797	259507	14308	2230	298205	94163	6154.9	2825.7	3167	1.22	2.81	3166.91	56.9	42.5	136	2755.93	151.95	23.68	94163	91838	2325	92341436	11758016	104099452
Chhattisgarh	3606	4176	12221	56575	12824	15672	105074	135192	3943.8	428.8	777	2.16	2.89	777.22	26.7	30.9	90	418.48	94.86	115.92	135192	131940	3252	19607961	5937237	25545198
Goa	293	279	824	16054	912	334	18697	3702	1192.7	5465.9	5051	1.01	29.1	5050.61	79.1	75.5	223	4336.69	246.4	90.29	3702	2937	765	551731	906814	1458545
Gujarat	6635	16746	31262	132467	30920	31343	249373	196244	4175.3	701.5	1271	1.2	3.82	1270.73	33.8	85.3	159	675.01	157.56	159.71	196244	188839	7405	34694609	25745083	60439692
Haryana	3166	1602	22051	7027	14853	1594	50292	44212	7516.3	166.4	1138	1.68	0.43	1137.53	71.6	36.2	499	158.93	335.95	36.06	44212	42236	1976	16509359	8842103	25351462
Himachal Pradesh	2607	827	4277	53033	4706	7781	73230	55673	17376.1	957.2	1315	6.83	8.59	1315.37	46.8	14.9	77	952.57	84.53	139.77	55673	55402	271	6176050	688552	6864602
Jammu & Kashmir	2423	310	19695	75684	2096	19826	120034	222236	1682.1	342.5	540	0.61	8.31	540.12	10.9	1.4	89	340.56	9.43	89.21	222236	220990	1246	9108060	3433242	12541302


CREATE TABLE india_road_population_data (
  "name_of_the_states" VARCHAR,
  "national_highways" BIGINT,
  "state_highways" BIGINT,
  "district_roads" BIGINT,
  "rural_roads" BIGINT,
  "urban_roads" BIGINT,
  "project_roads" BIGINT,
  "total_road_length" BIGINT,
  "total_area" BIGINT,
  "n__urban_road_density" DOUBLE,
  "n__rural_road_density" DOUBLE,
  "entire_state_road_length_per_1000_sq_km" BIGINT,
  "urban_road_lngth_per_1000_sq_km" DOUBLE,
  "rural_road_lngth_per_1000_sq_km" DOUBLE,
  "road_density" DOUBLE,
  "road_density_per_1000_sq_km_national_highways" DOUBLE,
  "road_density_per_1000_sq_km_state_highways" DOUBLE,
  "road_density_per_1000_sq_km_district_roads" BIGINT,
  "road_density_per_1000_sq_km_rural_roads" DOUBLE,
  "road_density_per_1000_sq_km_urban_roads" DOUBLE,
  "road_density_per_1000_sq_km_project_roads" DOUBLE,
  "area" BIGINT,
  "rural_area_2011_census" DOUBLE,
  "urban_area_2011_census" DOUBLE,
  "rural_pop_2011_census" BIGINT,
  "urban_pop_2011_census" BIGINT,
  "total_population" BIGINT
);