Location Of Facilities For The 65+ Demographic
Cambridgeshire Insight
@ukgov.location_of_facilities_for_the_65_demographic1
Cambridgeshire Insight
@ukgov.location_of_facilities_for_the_65_demographic1
CREATE TABLE care_facility_completions_and_commitments (
"case_no" VARCHAR,
"alternative_ref" VARCHAR,
"district_name_full" VARCHAR,
"parish" VARCHAR,
"sub_area" VARCHAR,
"csr" VARCHAR,
"location_address" VARCHAR,
"proposal" VARCHAR,
"applicant" VARCHAR,
"agent" VARCHAR,
"application_type" VARCHAR,
"development_type" VARCHAR,
"development_class" VARCHAR,
"greenbrown" VARCHAR,
"decision_date" TIMESTAMP,
"appeal_decision_date" TIMESTAMP,
"lapse_date" VARCHAR,
"entry_no" BIGINT,
"primary_use" VARCHAR,
"subuse" VARCHAR,
"monitrstatus" VARCHAR,
"as_at_date" TIMESTAMP,
"target_lost" BIGINT,
"target_new" BIGINT,
"target_net" BIGINT,
"outline" VARCHAR,
"uc" BIGINT,
"ui" BIGINT,
"alloc" DOUBLE,
"total" BIGINT,
"comp_2003" DOUBLE,
"comp_2004" DOUBLE,
"comp_2005" DOUBLE,
"comp_2006" DOUBLE,
"comp_2007" DOUBLE,
"comp_2008" DOUBLE,
"comp_2009" DOUBLE,
"comp_2010" DOUBLE,
"comp_2011" DOUBLE,
"comp_2012" DOUBLE,
"comp_2013" DOUBLE,
"comp_2014" DOUBLE,
"completed_total" BIGINT,
"developable_site_area" DOUBLE,
"outline_ha" VARCHAR,
"uc_ha" DOUBLE,
"ui_ha" DOUBLE,
"alloc_ha" DOUBLE,
"total_ha" DOUBLE,
"comp_2014_ha" DOUBLE,
"comp_2003_ha" DOUBLE,
"comp_2004_ha" DOUBLE,
"comp_2005_ha" DOUBLE,
"comp_2006_ha" DOUBLE,
"comp_2007_ha" DOUBLE,
"comp_2008_ha" DOUBLE,
"comp_2009_ha" DOUBLE,
"comp_2010_ha" DOUBLE,
"comp_2011_ha" DOUBLE,
"comp_2012_ha" DOUBLE,
"comp_2013_ha" DOUBLE,
"completed_total_1" DOUBLE,
"occupier" VARCHAR,
"comment" VARCHAR,
"b_to_housing" VARCHAR,
"unnamed_65" BIGINT,
"unnamed_66" BIGINT,
"unnamed_67" VARCHAR
);
Anyone who has the link will be able to view this.