30 Indian Cities

the dataset serves as a valuable tool for understanding the progress of India.

@kaggle.willianoliveiragibin_30_indian_cities

Table List

1 table(33.42 KB)

Ict Subdimension Dataset New

@kaggle.willianoliveiragibin_30_indian_cities.ict_subdimension_dataset_new

33.42 KB
180 rows
20 columns

city City	year Year	household_internet_access Household Internet Access (%)	fixed_broadband_subscriptions Fixed Broadband Subscriptions (%)	wireless_broadband_subscriptions Wireless Broadband Subscriptions (%)	wireless_broadband_coverage_3g Wireless Broadband Coverage 3G (%)	wireless_broadband_coverage_4g Wireless Broadband Coverage 4G (%)	smart_water_meters Smart Water Meters (%)	smart_electricity_meters Smart Electricity Meters (%)	dynamic_public_transport_information Dynamic Public Transport Information (%)	traffic_monitoring Traffic Monitoring (%)	availability_of_wifi_in_public_areas_count Availability Of WIFI In Public Areas (count)	water_supply_ict_monitoring Water Supply ICT Monitoring (%)	drainage_storm_water_system_ict_monitoring Drainage / Storm Water System ICT Monitoring (%)	electricity_supply_ict_monitoring Electricity Supply ICT Monitoring (%)	demand_response_penetration Demand Response Penetration (%)	intersection_control Intersection Control (%)	open_data Open Data (%)	e_government E-Government (%)	public_sector_e_procurement Public Sector E-procurement (%)
Mumbai	2019	79.45	48	50.35	91.57	59.19	33.3	43.4	10.04	15.3	137	31.31	20.72	33.88	10.05	15.48	4.85	19.07	24.2
Delhi	2019	88.62	54.7	61.7	88.99	59.02	38.33	31.03	10.12	15.44	149	28.64	20.66	35.79	9.66	15.64	4.87	19.31	24
Bengaluru	2019	79.1	47.53	67.9	94.31	58.18	21.98	37.43	9.59	14.51	152	31.26	19.64	36.72	9.68	14.32	4.78	20.38	23.97
Hyderabad	2019	86.82	60	50.69	89.12	61.76	26.13	40.12	10.11	14.27	111	30.85	19.4	33.67	9.89	14.5	4.75	20.96	24.29
Chennai	2019	80.84	48.03	66.79	92.83	61.85	28.01	31.51	10.47	15.36	103	29.74	19.28	34.39	9.83	14.65	4.81	19.7	23.89
Ahmedabad	2019	64.27	37.33	42.31	85.57	60.28	22.1	31.71	9.58	14.4	102	28.88	20.85	35.34	9.86	14.42	4.97	19.2	25.76
Aizawl	2019	56.96	37.99	44.32	89.75	61.75	21.75	18.53	9.65	15.57	67	29.01	20.93	35.64	10.05	14.79	5.09	20.97	25.81
Amaravati	2019	73.1	39.8	51	92.23	62.23	20.97	25.19	9.88	14.41	75	30.07	19.86	35.47	9.71	14.32	4.91	19.23	25.85
Amritsar	2019	53.65	31.29	33	92.93	58.37	24.67	17.64	10.15	15.12	119	31.18	20.99	36.5	9.6	15.66	4.84	20.15	25.61
Bhopal	2019	59.81	42.62	51.61	89.99	61.57	24.99	29.09	10.32	15.37	100	30.26	19.58	36.38	10.22	15.13	5.23	20.12	24.59


CREATE TABLE ict_subdimension_dataset_new (
  "city" VARCHAR,
  "year" BIGINT,
  "household_internet_access" DOUBLE,
  "fixed_broadband_subscriptions" DOUBLE,
  "wireless_broadband_subscriptions" DOUBLE,
  "wireless_broadband_coverage_3g" DOUBLE,
  "wireless_broadband_coverage_4g" DOUBLE,
  "smart_water_meters" DOUBLE,
  "smart_electricity_meters" DOUBLE,
  "dynamic_public_transport_information" DOUBLE,
  "traffic_monitoring" DOUBLE,
  "availability_of_wifi_in_public_areas_count" BIGINT,
  "water_supply_ict_monitoring" DOUBLE,
  "drainage_storm_water_system_ict_monitoring" DOUBLE,
  "electricity_supply_ict_monitoring" DOUBLE,
  "demand_response_penetration" DOUBLE,
  "intersection_control" DOUBLE,
  "open_data" DOUBLE,
  "e_government" DOUBLE,
  "public_sector_e_procurement" DOUBLE
);