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 = 5636 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
22620 CSIS Aerospace Security Project (2022) 
{
    "link": "https://aerospace.csis.org/data/international-astronaut-database/",
    "retrievedDate": "2022-06-06",
    "additionalInfo": "The source notes that the definition of \u201castronaut\u201d is not unanimously agreed upon among the world\u2019s space launch providers. The CSIS database includes all those who have flown to an altitude of 100 kilometers or higher. This particular definition of \u201couter space\u201d is used by the World Air Sports Federation (FAI), an international record-keeping body for aeronautics and astronautics. This database also includes those who were killed in a space-bound mission, like the first-time astronauts aboard STS-51-L. It does not include, however, those who have flown to altitudes below 100 kilometers or first-time astronauts who were killed in non-space-bound missions without having previously flown to space.",
    "dataPublishedBy": "CSIS Aerospace Security Project"
}
 2022-06-06 14:42:43 2023-03-03 10:52:03 CSIS - Astronauts launched by year 5636 The source notes that the definition of “astronaut” is not unanimously agreed upon among the world’s space launch providers. The CSIS database includes all those who have flown to an altitude of 100 kilometers or higher. This particular definition of “outer space” is used by the World Air Sports Federation (FAI), an international record-keeping body for aeronautics and astronautics. This database also includes those who were killed in a space-bound mission, like the first-time astronauts aboard STS-51-L. It does not include, however, those who have flown to altitudes below 100 kilometers or first-time astronauts who were killed in non-space-bound missions without having previously flown to space. https://aerospace.csis.org/data/international-astronaut-database/ CSIS Aerospace Security Project

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");