Dataset: India-RoadforPopulation-Data

About this Dataset

India-RoadforPopulation-Data

The dataset has been made after combining 2 sets of data's taken from the GOI official website.
It reflects on the street , road , highway density of India and is reflective of the land infrastructure per capita per Indian state.

Tables

India Road Population Data

@kaggle.zsinghrahulk_india_roadforpopulation_data.india_road_population_data

27.96 KB
36 rows
27 columns


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
);