Name: Roller Coaster Database
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Roller Coaster Database

The Rollercoaster Database

This data contains information about over 1000 rollercoasters. Information was scraped from wikipedia.

Code can be found here: https://github.com/RobMulla/twitch-stream-projects/tree/main/001-rollercoaster-dataset

Tables

Coaster Db

@kaggle.robikscube_rollercoaster_database.coaster_db

173.07 KB
1087 rows
56 columns


CREATE TABLE coaster_db (
  "coaster_name" VARCHAR,
  "length" VARCHAR,
  "speed" VARCHAR,
  "location" VARCHAR,
  "status" VARCHAR,
  "opening_date" VARCHAR,
  "type" VARCHAR,
  "manufacturer" VARCHAR,
  "height_restriction" VARCHAR,
  "model" VARCHAR,
  "height" VARCHAR,
  "inversions" DOUBLE,
  "lift_launch_system" VARCHAR,
  "cost" VARCHAR,
  "trains" VARCHAR,
  "park_section" VARCHAR,
  "duration" VARCHAR,
  "capacity" VARCHAR,
  "g_force" VARCHAR,
  "designer" VARCHAR,
  "max_vertical_angle" VARCHAR,
  "drop" VARCHAR,
  "soft_opening_date" VARCHAR,
  "fast_lane_available" VARCHAR,
  "replaced" VARCHAR,
  "track_layout" VARCHAR,
  "fastrack_available" VARCHAR,
  "soft_opening_date_1" VARCHAR,
  "closing_date" VARCHAR,
  "opened" VARCHAR,
  "replaced_by" VARCHAR,
  "website" VARCHAR,
  "flash_pass_available" VARCHAR,
  "must_transfer_from_wheelchair" VARCHAR,
  "theme" VARCHAR,
  "single_rider_line_available" VARCHAR,
  "restraint_style" VARCHAR,
  "flash_pass_available_2901e9" VARCHAR,
  "acceleration" VARCHAR,
  "restraints" VARCHAR,
  "name" VARCHAR,
  "year_introduced" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "type_main" VARCHAR,
  "opening_date_clean" TIMESTAMP,
  "speed1" VARCHAR,
  "speed2" VARCHAR,
  "speed1_value" DOUBLE,
  "speed1_unit" VARCHAR,
  "speed_mph" DOUBLE,
  "height_value" DOUBLE,
  "height_unit" VARCHAR,
  "height_ft" DOUBLE,
  "inversions_clean" BIGINT,
  "gforce_clean" DOUBLE
);