Metro-Systems-Worldwide

List of Metro System Worldwide

@kaggle.drahulsingh_metro_systems_worldwide

Table List

1 table(16.63 KB)

Metro Systems Worldwide

@kaggle.drahulsingh_metro_systems_worldwide.metro_systems_worldwide

16.63 KB
205 rows
8 columns

city City	country_region Country Region	name Name	service_opened Service Opened	last_expanded Last Expanded	stations Stations	system_length System Length	annual_ridership_millions Annual Ridership (millions)
Algiers	Algeria	Algiers Metro	2011	2018	19	18.5 km (11.5 mi)	45.3 (2019)
Buenos Aires	Argentina	Buenos Aires Underground	1913	2019	78	56.7 km (35.2 mi)	74.0 (2020)
Yerevan	Armenia	Yerevan Metro	1981	1996	10	12.1 km (7.5 mi)	23.3 (2022)
Sydney	Australia	Sydney Metro	2019	–	13	36 km (22 mi)	16.3 (2022)
Vienna	Austria	Vienna U-Bahn	1978	2017	98	83.3 km (51.8 mi)	459.8 (2019)
Baku	Azerbaijan	Baku Metro	1967	2022	27	40.7 km (25.3 mi)	202.5 (2022)
Dhaka	Bangladesh	Dhaka Metro Rail	2022	–	9	11.7 km (7.3 mi)	nan
Minsk	Belarus	Minsk Metro	1984	2020	33	40.8 km (25.4 mi)	225.9 (2022)
Brussels	Belgium	Brussels Metro	1976	2009	59	39.9 km (24.8 mi)	96.3 (2021)
Belo Horizonte	Brazil	Belo Horizonte Metro	1986	2002	19	28.1 km (17.5 mi)	54.4 (2019)


CREATE TABLE metro_systems_worldwide (
  "city" VARCHAR,
  "country_region" VARCHAR,
  "name" VARCHAR,
  "service_opened" BIGINT,
  "last_expanded" VARCHAR,
  "stations" BIGINT,
  "system_length" VARCHAR,
  "annual_ridership_millions" VARCHAR
);