sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5167 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
17897 United States Department of Transportation, Bureau of Transportation Statistics (BTS) 
{
    "link": "https://www.bts.gov/content/energy-intensity-passenger-modes",
    "retrievedDate": "11th September 2020",
    "additionalInfo": "Energy intensity of transport is measured by the US Bureau of Transport Statistics (BTS) in btu per passenger-mile. We have converted this data to kilowatt-hours per passenger-kilometer using the following conversion factors:\n\u2013 BTU to kWH = 0.000293071\n\u2013 mile to km = 1.60934\n\nThe US BTS notes the following about transport categories:\n\"Data from 2007 were calculated using a new methodology developed by FHWA. Data for these years are based on new categories and are not comparable to previous years. The new category [Small passenger vehicles] replaces the old category Passenger car and includes passenger cars, light trucks, vans and sport utility vehicles with a wheelbase (WB) equal to or less than 121 inches. The new category [Large road vehicles] replaces Other 2-axle, 4-tire vehicle and includes large passenger cars, vans, pickup trucks, and sport/utility vehicles with wheelbases (WB) larger than 121 inches. This edition of 4-20 is not comparable to those before the 2019 edition.\"",
    "dataPublishedBy": "United States Department of Transportation. Bureau of Transportation Statistics (BTS)."
}
 2020-09-11 11:58:57 2020-09-11 11:58:57 Energy efficiency by passenger mode in USA (BTS) 5167 Energy intensity of transport is measured by the US Bureau of Transport Statistics (BTS) in btu per passenger-mile. We have converted this data to kilowatt-hours per passenger-kilometer using the following conversion factors: – BTU to kWH = 0.000293071 – mile to km = 1.60934 The US BTS notes the following about transport categories: "Data from 2007 were calculated using a new methodology developed by FHWA. Data for these years are based on new categories and are not comparable to previous years. The new category [Small passenger vehicles] replaces the old category Passenger car and includes passenger cars, light trucks, vans and sport utility vehicles with a wheelbase (WB) equal to or less than 121 inches. The new category [Large road vehicles] replaces Other 2-axle, 4-tire vehicle and includes large passenger cars, vans, pickup trucks, and sport/utility vehicles with wheelbases (WB) larger than 121 inches. This edition of 4-20 is not comparable to those before the 2019 edition." https://www.bts.gov/content/energy-intensity-passenger-modes United States Department of Transportation. Bureau of Transportation Statistics (BTS).

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");