National transit database records

National transit database record

Last imported 10:04AM UTC on Tuesday, March 26, 2013. See log

Individual records from the U.S. National Transit Database.

Imported from the U.S. National Transit Database.

Citing this data

To cite this data, reference Brighter Planet, "National transit database records," <http://data.brighterplanet.com/national_transit_database_records>, retrieved 2013-05-18 18:40:48 UTC.

Download

Total: 1,310 records.

Random data sample

Sample: 5 records.

name company mode code service type vehicle distance vehicle distance units vehicle time vehicle time units passenger distance passenger distance units passengers electricity electricity units diesel diesel units gasoline gasoline units lpg lpg units lng lng units cng cng units kerosene kerosene units biodiesel biodiesel units other fuel other fuel units other fuel description
1 DR PT 1 DR Purchased Transportation 16053200.0 kilometres 657222.0 hours 18990000.0 kilometres 1142450.0 0.0 kilowatt_hours 4198050.0 litres 100185.0 litres
1 LR DO 1 LR Directly Operated 96802.0 kilometres 11207.0 hours 667261.0 kilometres 451203.0 556000.0 kilowatt_hours
1 MB DO 1 MB Directly Operated 50341800.0 kilometres 2550830.0 hours 736435000.0 kilometres 90502000.0 0.0 kilowatt_hours 39459700.0 litres
1 MB PT 1 MB Purchased Transportation 1338160.0 kilometres 71947.0 hours 4377250.0 kilometres 846678.0 0.0 kilowatt_hours 116973.0 litres 526100.0 litres
1 TB DO 1 TB Directly Operated 5441770.0 kilometres 513091.0 hours 57331700.0 kilometres 19719200.0 16918000.0 kilowatt_hours

Import steps

Click a step for more detail.

  1. Import US National Transit Database service data

    1. Fetch data from .
    2. Store
      • name
      • company_id
      • mode_code
      • service_type (using dictionary)
      • vehicle_distance
      • vehicle_time
      • passenger_distance
      • passengers
      .

  2. Import US National Transit Database fuel consumption data

    1. Fetch data from .
    2. Store
      • name
      • company_id
      • mode_code
      • service_type (using dictionary)
      • electricity
      • diesel
      • gasoline
      • lpg
      • lng
      • cng
      • kerosene
      • biodiesel
      • other_fuel
      • other_fuel_description
      .

Table structure

CREATE TABLE ntd_records
  (
     name                     CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     company_id               CHARACTER VARYING(255),
     mode_code                CHARACTER VARYING(255),
     service_type             CHARACTER VARYING(255),
     vehicle_distance         FLOAT,
     vehicle_distance_units   CHARACTER VARYING(255),
     vehicle_time             FLOAT,
     vehicle_time_units       CHARACTER VARYING(255),
     passenger_distance       FLOAT,
     passenger_distance_units CHARACTER VARYING(255),
     passengers               FLOAT,
     electricity              FLOAT,
     electricity_units        CHARACTER VARYING(255),
     diesel                   FLOAT,
     diesel_units             CHARACTER VARYING(255),
     gasoline                 FLOAT,
     gasoline_units           CHARACTER VARYING(255),
     lpg                      FLOAT,
     lpg_units                CHARACTER VARYING(255),
     lng                      FLOAT,
     lng_units                CHARACTER VARYING(255),
     cng                      FLOAT,
     cng_units                CHARACTER VARYING(255),
     kerosene                 FLOAT,
     kerosene_units           CHARACTER VARYING(255),
     biodiesel                FLOAT,
     biodiesel_units          CHARACTER VARYING(255),
     other_fuel               FLOAT,
     other_fuel_units         CHARACTER VARYING(255),
     other_fuel_description   CHARACTER VARYING(255)
  );