Rail Transport Performance In Europe 2021

European Commission - REGIO B1

@esifunds.bp5k_ynxy

Table List

1 table(49.6 KB)

Table 1

@esifunds.bp5k_ynxy.table_1

49.6 KB
1000 rows
16 columns

country_larger_city Country Larger City	hdc_code_larger Hdc Code Larger	larger_city Larger City	pop_larger_city Pop Larger City	country_smaller_city Country Smaller City	hdc_code_smaller Hdc Code Smaller	smaller_city Smaller City	pop_smaller_city Pop Smaller City	crossborder Crossborder	distance_centroids Distance Centroids	av_dist_opti Av Dist Opti	time_opti Time Opti	speed_opti Speed Opti	av_dist_avt Av Dist Avt	time_avt Time Avt	speed_avt Speed Avt
FR	GEOSTAT11_450	Paris	8900172	BE	GEOSTAT11_349	Bruxelles / Brussel	1233487	true	more than 120 km	260.8	1.44	182.1	261.6	1.71	153.5
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_361	Lille	911478		more than 120 km	202	1	202.1	201.9	1.29	157.3
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_418	Rouen	298297		114.6	110	1.24	88.7	110	1.67	65.9
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_434	Cergy-Pontoise	273138		30.6	4.8	0.07	67.9	4.8	0.17	27.9
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_499	Tours	211915		more than 120 km	187.7	0.86	218.2	200.4	1.54	130.6
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_427	Reims	201158		more than 120 km	128.7	0.82	157.9	129.5	1.65	79
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_443	Maurepas / Montigny-le-Bretonneux	195018		27.5	4.6	0.08	61.8	4.6	0.13	37.1
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_482	Orléans	175802		108.2	99.6	0.85	118.2	107.2	1.38	77.7
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_367	Lens	168979		more than 120 km	174.2	1.1	159.2	175.2	2.01	87.5
FR	GEOSTAT11_450	Paris	8900172	FR	GEOSTAT11_475	Le Mans	142171		more than 120 km	173.2	0.79	219.3	178	1.39	128.8


CREATE TABLE table_1 (
  "country_larger_city" VARCHAR,
  "hdc_code_larger" VARCHAR,
  "larger_city" VARCHAR,
  "pop_larger_city" BIGINT,
  "country_smaller_city" VARCHAR,
  "hdc_code_smaller" VARCHAR,
  "smaller_city" VARCHAR,
  "pop_smaller_city" BIGINT,
  "crossborder" BOOLEAN,
  "distance_centroids" VARCHAR,
  "av_dist_opti" DOUBLE,
  "time_opti" DOUBLE,
  "speed_opti" DOUBLE,
  "av_dist_avt" DOUBLE,
  "time_avt" DOUBLE,
  "speed_avt" DOUBLE
);