Name: India-RoadforPopulation-Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

28.63 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  -- Urban Road Density,
  "n__rural_road_density" DOUBLE  -- Rural Road Density,
  "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 - National Highways,
  "road_density_per_1000_sq_km_state_highways" DOUBLE  -- Road Density Per 1000 Sq. Km - State Highways,
  "road_density_per_1000_sq_km_district_roads" BIGINT  -- Road Density Per 1000 Sq. Km - District Roads,
  "road_density_per_1000_sq_km_rural_roads" DOUBLE  -- Road Density Per 1000 Sq. Km - Rural Roads,
  "road_density_per_1000_sq_km_urban_roads" DOUBLE  -- Road Density Per 1000 Sq. Km - Urban Roads,
  "road_density_per_1000_sq_km_project_roads" DOUBLE  -- Road Density Per 1000 Sq. Km - Project Roads,
  "area" BIGINT,
  "rural_area_2011_census" DOUBLE  -- Rural Area (2011 Census),
  "urban_area_2011_census" DOUBLE  -- Urban Area (2011 Census),
  "rural_pop_2011_census" BIGINT  -- Rural Pop (2011 Census),
  "urban_pop_2011_census" BIGINT  -- Urban Pop (2011 Census),
  "total_population" BIGINT
);