Government Major Projects Portfolio Data For HMRC
HM Revenue and Customs
@ukgov.government_major_projects_portfolio_data_for_hmrc
HM Revenue and Customs
@ukgov.government_major_projects_portfolio_data_for_hmrc
CREATE TABLE government_major_projects_portfolio_data_for_hmrc (
"project_name" VARCHAR,
"columbus_formerly_aspire_replacement_programme" VARCHAR,
"building_our_future_locations_programme" VARCHAR,
"customs_declaration_services_cds_programme" VARCHAR,
"making_tax_digital_for_business" VARCHAR,
"tax_free_childcare" VARCHAR,
"compliance_for_the_future_programme" VARCHAR,
"making_tax_digital_for_individuals" VARCHAR
);
CREATE TABLE n_2018_19_government_major_project_portfolio_gmpp (
"project_name" VARCHAR,
"building_our_future_locations_programme" VARCHAR,
"columbus_formerly_aspire_replacement_programme" VARCHAR,
"compliance_for_the_future_programme" VARCHAR,
"customs_declaration_services_cds_programme" VARCHAR,
"government_gateway_transformation" VARCHAR,
"making_tax_digital_for_business" VARCHAR,
"tax_free_childcare" VARCHAR
);
CREATE TABLE n_2019_20_government_major_project_portfolio_gmpp (
"gmpp_id_number" VARCHAR,
"hmrc_0015_1617_q1" VARCHAR,
"hmrc_0014_1415_q4" VARCHAR,
"hmrc_0017_1617_q2" VARCHAR,
"hmrc_0020_1819_q3" VARCHAR,
"hmrc_0012_1415_q1" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE n_2020_21_government_major_project_portfolio_gmpp (
"gmpp_id_number" VARCHAR,
"project_name" VARCHAR,
"department" VARCHAR,
"annual_report_category" VARCHAR,
"description_aims" VARCHAR,
"ipa_delivery_confidence_assessment_a_delivery_confiden_7ea25c9f" VARCHAR,
"departmental_commentary_on_actions_planned_or_taken_on_79fbed53" VARCHAR,
"project_start_date_latest_approved_start_date" TIMESTAMP,
"project_end_date_latest_approved_end_date" TIMESTAMP,
"departmental_narrative_on_schedule_including_any_devia_99963a91" VARCHAR,
"financial_year_baseline_m_including_non_government_costs" VARCHAR,
"financial_year_forecast_m_including_non_government_costs" VARCHAR,
"financial_year_variance" VARCHAR,
"departmental_narrative_on_budget_forecast_variance_for_035c26b1" VARCHAR,
"total_baseline_whole_life_costs_m_including_non_govern_6fb1c0f7" VARCHAR,
"departmental_narrative_on_budgeted_whole_life_costs" VARCHAR
);
CREATE TABLE n_2021_22_government_major_project_portfolio_gmpp (
"gmpp_id_number" VARCHAR,
"project_name" VARCHAR,
"department" VARCHAR,
"annual_report_category" VARCHAR,
"description_aims" VARCHAR,
"ipa_delivery_confidence_assessment_a_delivery_confiden_6e62958b" VARCHAR,
"sro_delivery_confidence_assessment_a_delivery_confiden_f263a832" VARCHAR,
"departmental_commentary_on_actions_planned_or_taken_on_79fbed53" VARCHAR,
"project_start_date_latest_approved_start_date" TIMESTAMP,
"project_end_date_latest_approved_end_date" TIMESTAMP,
"departmental_narrative_on_schedule_including_any_devia_99963a91" VARCHAR,
"financial_year_baseline_m_including_non_government_costs" VARCHAR,
"financial_year_forecast_m_including_non_government_costs" VARCHAR,
"financial_year_variance" VARCHAR,
"departmental_narrative_on_budget_forecast_variance_for_e61b5a98" VARCHAR,
"total_baseline_whole_life_costs_m_including_non_govern_6fb1c0f7" VARCHAR,
"departmental_narrative_on_budgeted_whole_life_costs" VARCHAR
);
CREATE TABLE n_2022_23_government_major_project_portfolio_gmpp (
"gmpp_id_number" VARCHAR,
"project_name" VARCHAR,
"department" VARCHAR,
"annual_report_category" VARCHAR,
"description_aims" VARCHAR,
"ipa_delivery_confidence_assessment_a_delivery_confiden_6e62958b" VARCHAR,
"sro_delivery_confidence_assessment_a_delivery_confiden_f263a832" VARCHAR,
"departmental_commentary_on_actions_planned_or_taken_on_79fbed53" VARCHAR,
"project_start_date_latest_approved_start_date" TIMESTAMP,
"project_end_date_latest_approved_end_date" TIMESTAMP,
"departmental_narrative_on_schedule_including_any_devia_99963a91" VARCHAR,
"financial_year_baseline_m_including_non_government_costs" DOUBLE,
"financial_year_forecast_m_including_non_government_costs" DOUBLE,
"financial_year_variance" BIGINT,
"departmental_narrative_on_budget_forecast_variance_for_e61b5a98" VARCHAR,
"total_baseline_whole_life_costs_m_including_non_govern_6fb1c0f7" BIGINT,
"departmental_narrative_on_budgeted_whole_life_costs" VARCHAR,
"total_baseline_benefits_m" VARCHAR,
"departmental_narrative_on_budgeted_benefits" VARCHAR
);
CREATE TABLE n_2023_24_government_major_project_portfolio_gmpp (
"gmpp_id_number" VARCHAR,
"project_name" VARCHAR,
"department" VARCHAR,
"annual_report_category" VARCHAR,
"description_aims" VARCHAR,
"ipa_delivery_confidence_assessment_a_delivery_confiden_6e62958b" VARCHAR,
"sro_delivery_confidence_assessment_a_delivery_confiden_f263a832" VARCHAR,
"departmental_commentary_on_actions_planned_or_taken_on_79fbed53" VARCHAR,
"project_start_date_latest_approved_start_date" TIMESTAMP,
"project_end_date_latest_approved_end_date" TIMESTAMP,
"departmental_narrative_on_schedule_including_any_devia_99963a91" VARCHAR,
"financial_year_baseline_m_including_non_government_costs" DOUBLE,
"financial_year_forecast_m_including_non_government_costs" DOUBLE,
"financial_year_variance" BIGINT,
"departmental_narrative_on_budget_forecast_variance_for_5efe7bd1" VARCHAR,
"total_baseline_whole_life_costs_m_including_non_govern_6fb1c0f7" BIGINT,
"departmental_narrative_on_budgeted_whole_life_costs" VARCHAR,
"total_baseline_benefits_m" BIGINT,
"departmental_narrative_on_budgeted_benefits" VARCHAR
);
Anyone who has the link will be able to view this.