Crowdfund Plymouth
Plymouth City Council
@ukgov.cfp
Plymouth City Council
@ukgov.cfp
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,
"project_url" VARCHAR
);
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
);
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
);
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
);
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
);
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
);
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
);
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,
"project_url" VARCHAR
);
CREATE TABLE crowdfund_plymouth_projects_2020_2021 (
"project_ref" 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,
"project_url" VARCHAR
);
Anyone who has the link will be able to view this.