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 = 2891 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
15619 IPUMS 
{
    "link": "https://usa.ipums.org/usa/",
    "retrievedDate": "06/11/2020",
    "additionalInfo": "Samples of the decennial Census (1900-2000) and the 2018 ACS from IPUMS-USA has been used to construct variables on the percentage of Americans living alone, by age and sex. \n\nWe include only those people who are reported to be living in a one-person household and who do not live in group quarters. \n\nThe IPUMS defines group quarters as \"largely institutions and other group living arrangements, such as rooming houses and military barracks. The definitions vary from year to year, but the pre-1940 samples have generally used a definition of group quarters that includes units with 10 or more individuals unrelated to the householder.\"\n\nWe have excluded those recorded to be living in institutions, other group quarters, and additional households under the 2000 definition.",
    "dataPublishedBy": "Steven Ruggles, Sarah Flood, Ronald Goeken, Josiah Grover, Erin Meyer, Jose Pacas, and Matthew Sobek. IPUMS USA: Version 8.0 [dataset]. Minneapolis, MN: IPUMS, 2018. https://doi.org/10.18128/D010.V8.0",
    "dataPublisherSource": "Census data samples"
}
 2018-08-24 10:28:12 2018-08-28 10:36:14 Percentage of Americans living alone, by age - IPUMS 2891 Samples of the decennial Census (1900-2000) and the 2018 ACS from IPUMS-USA has been used to construct variables on the percentage of Americans living alone, by age and sex. We include only those people who are reported to be living in a one-person household and who do not live in group quarters. The IPUMS defines group quarters as "largely institutions and other group living arrangements, such as rooming houses and military barracks. The definitions vary from year to year, but the pre-1940 samples have generally used a definition of group quarters that includes units with 10 or more individuals unrelated to the householder." We have excluded those recorded to be living in institutions, other group quarters, and additional households under the 2000 definition. https://usa.ipums.org/usa/ Steven Ruggles, Sarah Flood, Ronald Goeken, Josiah Grover, Erin Meyer, Jose Pacas, and Matthew Sobek. IPUMS USA: Version 8.0 [dataset]. Minneapolis, MN: IPUMS, 2018. https://doi.org/10.18128/D010.V8.0

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