About this Dataset

Crowdfund Plymouth

Datasets showing information on Crowdfund Plymouth; a Plymouth City Council campaign which allows the council to review local projects and pledge towards them. Datasets to be updated at the end of each financial year.
Publisher name: Plymouth City Council
Last updated: 2025-03-03T04:00:03Z

Tables

Crowdfund Plymouth Projects 2015 - 2016

@ukgov.cfp.crowdfund_plymouth_projects_2015_2016

9.16 kB
22 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2015_2016 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2016 - 2017

@ukgov.cfp.crowdfund_plymouth_projects_2016_2017

8.72 kB
15 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2016_2017 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2017 - 2018

@ukgov.cfp.crowdfund_plymouth_projects_2017_2018

8.7 kB
17 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2017_2018 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2018 - 2019

@ukgov.cfp.crowdfund_plymouth_projects_2018_2019

8.88 kB
17 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2018_2019 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2019 - 2020

@ukgov.cfp.crowdfund_plymouth_projects_2019_2020

9.1 kB
22 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2019_2020 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2020 - 2021

@ukgov.cfp.crowdfund_plymouth_projects_2020_2021

11.24 kB
37 rows
9 columns

CREATE TABLE crowdfund_plymouth_projects_2020_2021 (
  "project_ref" VARCHAR  -- Project Ref.,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "switched_to_forever_funding" VARCHAR  -- Switched To Forever Funding?,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2021 - 2022

@ukgov.cfp.crowdfund_plymouth_projects_2021_2022

9.43 kB
25 rows
8 columns

CREATE TABLE crowdfund_plymouth_projects_2021_2022 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" VARCHAR,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2022 - 2023

@ukgov.cfp.crowdfund_plymouth_projects_2022_2023

8.63 kB
8 rows
9 columns

CREATE TABLE crowdfund_plymouth_projects_2022_2023 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "switched_to_forever_funding" VARCHAR  -- Switched To Forever Funding?,
  "project_url" VARCHAR
);

Crowdfund Plymouth Projects 2023 - 2024

@ukgov.cfp.crowdfund_plymouth_projects_2023_2024

9.69 kB
17 rows
9 columns

CREATE TABLE crowdfund_plymouth_projects_2023_2024 (
  "project_reference" VARCHAR,
  "project_name" VARCHAR,
  "ward" VARCHAR,
  "total_pledged_by_ccf" VARCHAR,
  "number_of_supporters" BIGINT,
  "final_total_raised" VARCHAR,
  "date_project_closed" TIMESTAMP,
  "swtiched_to_forever_funding" VARCHAR  -- Swtiched To Forever Funding?,
  "project_url" VARCHAR
);