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 = 3184 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
16688 Temporary accommodation in England - UK Government (2018) 
{
    "link": "https://www.gov.uk/government/statistical-data-sets/live-tables-on-homelessness#statutory-homelessness-live-tables",
    "retrievedDate": "24th January 2018",
    "additionalInfo": "Figures report the number of households, households with children and number of children in 'temporary accommodation' (TA).\n\nTemporary accommodation (typically given for a period of 28 days or less) is allocated to households without permanent housing, and are therefore included in annual homelessness accounts. Temporary accommodation includes relocation to bed and breakfasts, hostels, shelters, local authority or privately-owned temporary accommodation.\n\nThe UK National Statistics note: \"Complete temporary accommodation data was provided by 299 (92%) local authorities. A further 23 local authorities did provide a return but their totals have been omitted from the release due to quality concerns that placements may have been underreported or double reported.\"\n\nTemporary accommodation data is reported quarterly: to maintain consistency with rough sleeper statistics (recorded in Autumn) we have assumed Q3 results for each year.",
    "dataPublishedBy": "UK Government (2018). Ministry of Housing, Communities & Local Government."
}
 2019-01-24 20:12:01 2019-01-24 20:12:01 Temporary accommodation in England - UK Government (2018) 3184 Figures report the number of households, households with children and number of children in 'temporary accommodation' (TA). Temporary accommodation (typically given for a period of 28 days or less) is allocated to households without permanent housing, and are therefore included in annual homelessness accounts. Temporary accommodation includes relocation to bed and breakfasts, hostels, shelters, local authority or privately-owned temporary accommodation. The UK National Statistics note: "Complete temporary accommodation data was provided by 299 (92%) local authorities. A further 23 local authorities did provide a return but their totals have been omitted from the release due to quality concerns that placements may have been underreported or double reported." Temporary accommodation data is reported quarterly: to maintain consistency with rough sleeper statistics (recorded in Autumn) we have assumed Q3 results for each year. https://www.gov.uk/government/statistical-data-sets/live-tables-on-homelessness#statutory-homelessness-live-tables UK Government (2018). Ministry of Housing, Communities & Local Government.

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