Baselight

Location Of Facilities For The 65+ Demographic

Cambridgeshire Insight

@ukgov.location_of_facilities_for_the_65_demographic1

About this Dataset

Location Of Facilities For The 65+ Demographic

This dataset looks at how close important facilities are located to the 65+ demographic, including Residential/Nursing home, doctor surgeries, pharmacies, bus stops etc...
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z

Tables

Care Facility Completions And Commitments

@ukgov.location_of_facilities_for_the_65_demographic1.care_facility_completions_and_commitments
  • 62.43 KB
  • 54 rows
  • 68 columns

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

Share link

Anyone who has the link will be able to view this.