Delhi Metro Dataset

"Comprehensive Data on Delhi Metro Stations, Distances, Lines, and Opening Years

@kaggle.arunjangir245_delhi_metro_dataset

Table List

1 table(16.66 KB)

Delhi Metro

@kaggle.arunjangir245_delhi_metro_dataset.delhi_metro

16.66 KB
285 rows
8 columns

id_station_id ID (Station ID)	station_names Station Names	dist_from_first_station_km Dist. From First Station(km)	metro_line Metro Line	opened_year Opened(Year)	layout Layout	latitude Latitude	longitude Longitude
1	Shaheed Sthal(First Station)		Red line	08-03-2019	Elevated	28.6706109	77.4155822
2	Hindon River	1	Red line	08-03-2019	Elevated	28.878965	77.4154832
3	Arthala	2.5	Red line	08-03-2019	Elevated	28.676999	77.3918919
4	Mohan Nagar	3.2	Red line	08-03-2019	Elevated	28.60631905	77.10608185
5	Shyam park	4.5	Red line	08-03-2019	Elevated	28.6988072	28.6988072
6	Major Mohit Sharma	5.7	Red line	08-03-2019	Elevated	28.6776112	77.3581426
7	Raj Bagh	6.9	Red line	08-03-2019	Elevated	28.6408602	77.2094999
8	Shaheed Nagar	8.2	Red line	08-03-2019	Elevated	28.5307795	77.2120573
9	Dilshad Garden	9.4	Red line	04-06-2008	Elevated	28.67592	77.32142
10	Jhil Mil	10.3	Red line	04-06-2008	Elevated	28.67579	77.31239


CREATE TABLE delhi_metro (
  "id_station_id" BIGINT,
  "station_names" VARCHAR,
  "dist_from_first_station_km" DOUBLE,
  "metro_line" VARCHAR,
  "opened_year" VARCHAR,
  "layout" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);