Name: Public Transport Traffic Data In France
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Public Transport Traffic Data In France

Hello,

Data

This Dataset give lot of informations about trains and transports network in France.
This Dataset contains 2 csv and 1 shapefile.

1st CSV: Regularities by liaisons Trains France.csv

From https://data.sncf.com/explore/dataset/regularite-mensuelle-tgv-aqst/information/?sort=periode

It includes data from 2019-07-01 to 2020-05-01.

Look at the file description below for more details.

2nd CSV: Travel titles validations in Paris and suburbs.csv

From https://data.sncf.com/explore/dataset/validations-sur-le-reseau-ferre-nombre-de-validations-par-jour-1er-semestre-2015/information/

It includes data from 2019-07-01 to 2019-12-31.

Look at the file description below for more details.

3rd shp file:

from https://data.iledefrance-mobilites.fr/explore/dataset/referentiel-arret-tc-idf/table/?sort=fichier

Look at the file description below for more details.

Ideas

Time series forecasting: Forecast the number of people per station per day, etc...
Data visualization on the most delayed liaisons etc...

Tables

Regularities By Liaisons Trains France

@kaggle.gatandubuc_public_transport_traffic_data_in_france.regularities_by_liaisons_trains_france

885.43 kB
7,806 rows
32 columns

CREATE TABLE regularities_by_liaisons_trains_france (
  "year" BIGINT,
  "month" DOUBLE,
  "departure_station" VARCHAR,
  "arrival_station" VARCHAR,
  "average_travel_time_min" DOUBLE  -- Average Travel Time (min),
  "number_of_expected_circulations" DOUBLE,
  "number_of_cancelled_trains" DOUBLE,
  "number_of_late_trains_at_departure" DOUBLE,
  "average_delay_of_late_departing_trains_min" DOUBLE  -- Average Delay Of Late Departing Trains (min),
  "average_delay_of_all_departing_trains_min" DOUBLE  -- Average Delay Of All Departing Trains (min),
  "comment_optional_delays_at_departure" VARCHAR  -- Comment (optional) Delays At Departure,
  "number_of_trains_late_on_arrival" DOUBLE,
  "average_delay_of_late_arriving_trains_min" DOUBLE  -- Average Delay Of Late Arriving Trains (min),
  "average_delay_of_all_arriving_trains_min" DOUBLE  -- Average Delay Of All Arriving Trains (min),
  "comment_optional_delays_on_arrival" VARCHAR  -- Comment (optional) Delays On Arrival,
  "n__trains_late_due_to_external_causes_weather_obstacle_b144048c" DOUBLE  -- % Trains Late Due To External Causes (weather, Obstacles, Suspicious Packages, Malevolence, Social Movements, Etc.),
  "n__trains_late_due_to_railway_infrastructure_maintenance_works" DOUBLE  -- % Trains Late Due To Railway Infrastructure (maintenance, Works),
  "n__trains_late_due_to_traffic_management_rail_line_tra_3e7e60d2" DOUBLE  -- % Trains Late Due To Traffic Management (rail Line Traffic, Network Interactions),
  "n__trains_late_due_to_rolling_stock" DOUBLE  -- % Trains Late Due To Rolling Stock,
  "n__trains_late_due_to_station_management_and_reuse_of_material" DOUBLE  -- % Trains Late Due To Station Management And Reuse Of Material,
  "n__trains_late_due_to_passenger_traffic_affluence_psh__a7a2ca19" DOUBLE  -- % Trains Late Due To Passenger Traffic (affluence, PSH Management, Connections),
  "number_of_late_trains_15min" DOUBLE  -- Number Of Late Trains \u003e 15min,
  "average_train_delay_15min" DOUBLE  -- Average Train Delay \u003e 15min,
  "number_of_late_trains_30min" DOUBLE  -- Number Of Late Trains \u003e 30min,
  "number_of_late_trains_60min" DOUBLE  -- Number Of Late Trains \u003e 60min,
  "period" TIMESTAMP,
  "delay_due_to_external_causes" DOUBLE,
  "delay_due_to_railway_infrastructure" DOUBLE,
  "delay_due_to_traffic_management" DOUBLE,
  "delay_due_to_rolling_stock" DOUBLE,
  "delay_due_to_station_management_and_reuse_of_material" DOUBLE,
  "delay_due_to_travellers_taken_into_account" DOUBLE
);

Travel Titles Validations In Paris And Suburbs

@kaggle.gatandubuc_public_transport_traffic_data_in_france.travel_titles_validations_in_paris_and_suburbs

4.46 MB
883,958 rows
5 columns

CREATE TABLE travel_titles_validations_in_paris_and_suburbs (
  "date" TIMESTAMP,
  "station_name" VARCHAR,
  "id_refa_lda" DOUBLE,
  "title_category" VARCHAR,
  "nb_valid" VARCHAR
);