Baselight
Sign In

Capital Improvements Plan Project Submittals (Fiscal Year 2015)

State of Oklahoma

@usgov.state_of_oklahoma_capital_improvements_plan_project_su_8e19f0ac

Loading...
Loading...

About this Dataset

Capital Improvements Plan Project Submittals (Fiscal Year 2015)

This dataset contains all projects submitted by State of Oklahoma agencies for consideration by the Long Range Capital Planning Commission for inclusion in the FY 2015-2022 Capital Improvements Plan and FY2015 Annual Capital Budget.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:56:49.461567
Tags: 2015, budget, capital-improvement, commission, fiscal-year, project, submittals

Tables

Data - Fiscal Year 2015 Capital Improvements Plan Project Submittals

@usgov.state_of_oklahoma_capital_improvements_plan_project_su_8e19f0ac.n__fiscal_year_2015_capital_improvements_plan_project__a548c89c
  • 444.9 kB
  • 1,518 rows
  • 81 columns
Loading... 
CREATE TABLE n__fiscal_year_2015_capital_improvements_plan_project__a548c89c (
  "agency_name" VARCHAR,
  "agency_number" BIGINT,
  "project_number" VARCHAR,
  "project_name" VARCHAR,
  "project_city" VARCHAR,
  "project_county" VARCHAR,
  "useful_life" DOUBLE,
  "project_description" VARCHAR,
  "prior_state_appropriations" VARCHAR,
  "n_2015_state_appropriations" VARCHAR  -- 2015 STATE APPROPRIATIONS,
  "n_2016_state_appropriations" VARCHAR  -- 2016 STATE APPROPRIATIONS,
  "n_2017_2022_state_appropriations" VARCHAR  -- 2017-2022 STATE APPROPRIATIONS,
  "total_appropriations" VARCHAR,
  "prior_federal_funds" VARCHAR,
  "n_2015_federal_funds" VARCHAR  -- 2015 FEDERAL FUNDS,
  "n_2016_federal_funds" VARCHAR  -- 2016 FEDERAL FUNDS,
  "n_2017_2022_federal_funds" VARCHAR  -- 2017-2022 FEDERAL FUNDS,
  "total_federal_funds" VARCHAR,
  "previous_revolving_funds" VARCHAR,
  "n_2015_revolving_funds" VARCHAR  -- 2015 REVOLVING FUNDS,
  "n_2016_revolving_funds" VARCHAR  -- 2016 REVOLVING FUNDS,
  "n_2017_2022_revolving_funds" VARCHAR  -- 2017-2022 REVOLVING FUNDS,
  "total_revolving_funds" VARCHAR,
  "prior_gifts" VARCHAR,
  "n_2015_gifts" VARCHAR  -- 2015 GIFTS,
  "n_2016_gifts" VARCHAR  -- 2016 GIFTS,
  "n_2017_2022_gifts" VARCHAR  -- 2017-2022 GIFTS,
  "total_gifts" VARCHAR,
  "prior_general_obligation_bonds" VARCHAR,
  "n_2015_general_obligation_bonds" VARCHAR  -- 2015 GENERAL OBLIGATION BONDS,
  "n_2016_general_obligation_bonds" VARCHAR  -- 2016 GENERAL OBLIGATION BONDS,
  "n_2017_2022_general_obligation_bonds" VARCHAR  -- 2017-2022 GENERAL OBLIGATION BONDS,
  "total_general_obligation_bonds" VARCHAR,
  "prior_revenue_bonds" VARCHAR,
  "n_2015_revenue_bonds" VARCHAR  -- 2015 REVENUE BONDS,
  "n_2016_revenue_bonds" VARCHAR  -- 2016 REVENUE BONDS,
  "n_2017_2022_revenue_bonds" VARCHAR  -- 2017-2022 REVENUE BONDS,
  "total_revenue_bonds" VARCHAR,
  "prior_section_13_funds" VARCHAR,
  "n_2015_section_13_funds" VARCHAR  -- 2015 SECTION 13 FUNDS,
  "n_2016_section_13_funds" VARCHAR  -- 2016 SECTION 13 FUNDS,
  "n_2017_2022_section_13_funds" VARCHAR  -- 2017-2022 SECTION 13 FUNDS,
  "total_section_13_funds" VARCHAR,
  "prior_section_13_offset_funds" VARCHAR,
  "n_2015_section_13_offset_funds" VARCHAR  -- 2015 SECTION 13 OFFSET FUNDS,
  "n_2016_section_13_offset_funds" VARCHAR  -- 2016 SECTION 13 OFFSET FUNDS,
  "n_2017_2022_section_13_offset_funds" VARCHAR  -- 2017-2022 SECTION 13 OFFSET FUNDS,
  "total_section_13_offset_funds" VARCHAR,
  "prior_2014_other_funds" VARCHAR,
  "n_2015_other_funds" VARCHAR  -- 2015 OTHER FUNDS,
  "n_2016_other_funds" VARCHAR  -- 2016 OTHER FUNDS,
  "n_2017_2022_other_funds" VARCHAR  -- 2017-2022 OTHER FUNDS,
  "total_other_funds" VARCHAR,
  "prior_all_sources" VARCHAR,
  "n_2015_all_sources" VARCHAR  -- 2015 ALL SOURCES,
  "n_2016_all_sources" VARCHAR  -- 2016 ALL SOURCES,
  "n_2017_2022_all_sources" VARCHAR  -- 2017-2022 ALL SOURCES,
  "prior_equipment_costs" VARCHAR,
  "n_2015_equipment_costs" VARCHAR  -- 2015 EQUIPMENT COSTS,
  "n_2016_equipment_costs" VARCHAR  -- 2016 EQUIPMENT COSTS,
  "n_2017_2022_equipment_costs" VARCHAR  -- 2017-2022 EQUIPMENT COSTS,
  "total_equipment_costs" VARCHAR,
  "prior_construction_costs" VARCHAR,
  "n_2015_construction_costs" VARCHAR  -- 2015 CONSTRUCTION COSTS,
  "n_2016_construction_costs" VARCHAR  -- 2016 CONSTRUCTION COSTS,
  "n_2017_2022_construction_costs" VARCHAR  -- 2017-2022 CONSTRUCTION COSTS,
  "total_construction_costs" VARCHAR,
  "prior_other_costs" VARCHAR,
  "n_2015_other_costs" VARCHAR  -- 2015 OTHER COSTS,
  "n_2016_other_costs" VARCHAR  -- 2016 OTHER COSTS,
  "n_2017_2022_other_costs" VARCHAR  -- 2017-2022 OTHER COSTS,
  "total_other_costs" VARCHAR,
  "prior_project_costs" VARCHAR,
  "n_2015_project_costs" VARCHAR  -- 2015 PROJECT COSTS,
  "n_2016_project_costs" VARCHAR  -- 2016 PROJECT COSTS,
  "n_2017_2022_project_costs" VARCHAR  -- 2017-2022 PROJECT COSTS,
  "total_project_costs" VARCHAR,
  "recommended" VARCHAR  -- RECOMMENDED?,
  "n_2015_recommendation" VARCHAR  -- 2015 RECOMMENDATION,
  "n_2016_recommendation" VARCHAR  -- 2016 RECOMMENDATION,
  "n_2017_2022_recommendation" VARCHAR  -- 2017-2022 RECOMMENDATION
);

(T) - Annual Capital Budget Recommendations: FY 2015

@usgov.state_of_oklahoma_capital_improvements_plan_project_su_8e19f0ac.n__t_annual_capital_budget_recommendations_fy_2015
  • 444.9 kB
  • 1,518 rows
  • 81 columns
Loading... 
CREATE TABLE n__t_annual_capital_budget_recommendations_fy_2015 (
  "agency_name" VARCHAR,
  "agency_number" BIGINT,
  "project_number" VARCHAR,
  "project_name" VARCHAR,
  "project_city" VARCHAR,
  "project_county" VARCHAR,
  "useful_life" DOUBLE,
  "project_description" VARCHAR,
  "prior_state_appropriations" VARCHAR,
  "n_2015_state_appropriations" VARCHAR  -- 2015 STATE APPROPRIATIONS,
  "n_2016_state_appropriations" VARCHAR  -- 2016 STATE APPROPRIATIONS,
  "n_2017_2022_state_appropriations" VARCHAR  -- 2017-2022 STATE APPROPRIATIONS,
  "total_appropriations" VARCHAR,
  "prior_federal_funds" VARCHAR,
  "n_2015_federal_funds" VARCHAR  -- 2015 FEDERAL FUNDS,
  "n_2016_federal_funds" VARCHAR  -- 2016 FEDERAL FUNDS,
  "n_2017_2022_federal_funds" VARCHAR  -- 2017-2022 FEDERAL FUNDS,
  "total_federal_funds" VARCHAR,
  "previous_revolving_funds" VARCHAR,
  "n_2015_revolving_funds" VARCHAR  -- 2015 REVOLVING FUNDS,
  "n_2016_revolving_funds" VARCHAR  -- 2016 REVOLVING FUNDS,
  "n_2017_2022_revolving_funds" VARCHAR  -- 2017-2022 REVOLVING FUNDS,
  "total_revolving_funds" VARCHAR,
  "prior_gifts" VARCHAR,
  "n_2015_gifts" VARCHAR  -- 2015 GIFTS,
  "n_2016_gifts" VARCHAR  -- 2016 GIFTS,
  "n_2017_2022_gifts" VARCHAR  -- 2017-2022 GIFTS,
  "total_gifts" VARCHAR,
  "prior_general_obligation_bonds" VARCHAR,
  "n_2015_general_obligation_bonds" VARCHAR  -- 2015 GENERAL OBLIGATION BONDS,
  "n_2016_general_obligation_bonds" VARCHAR  -- 2016 GENERAL OBLIGATION BONDS,
  "n_2017_2022_general_obligation_bonds" VARCHAR  -- 2017-2022 GENERAL OBLIGATION BONDS,
  "total_general_obligation_bonds" VARCHAR,
  "prior_revenue_bonds" VARCHAR,
  "n_2015_revenue_bonds" VARCHAR  -- 2015 REVENUE BONDS,
  "n_2016_revenue_bonds" VARCHAR  -- 2016 REVENUE BONDS,
  "n_2017_2022_revenue_bonds" VARCHAR  -- 2017-2022 REVENUE BONDS,
  "total_revenue_bonds" VARCHAR,
  "prior_section_13_funds" VARCHAR,
  "n_2015_section_13_funds" VARCHAR  -- 2015 SECTION 13 FUNDS,
  "n_2016_section_13_funds" VARCHAR  -- 2016 SECTION 13 FUNDS,
  "n_2017_2022_section_13_funds" VARCHAR  -- 2017-2022 SECTION 13 FUNDS,
  "total_section_13_funds" VARCHAR,
  "prior_section_13_offset_funds" VARCHAR,
  "n_2015_section_13_offset_funds" VARCHAR  -- 2015 SECTION 13 OFFSET FUNDS,
  "n_2016_section_13_offset_funds" VARCHAR  -- 2016 SECTION 13 OFFSET FUNDS,
  "n_2017_2022_section_13_offset_funds" VARCHAR  -- 2017-2022 SECTION 13 OFFSET FUNDS,
  "total_section_13_offset_funds" VARCHAR,
  "prior_2014_other_funds" VARCHAR,
  "n_2015_other_funds" VARCHAR  -- 2015 OTHER FUNDS,
  "n_2016_other_funds" VARCHAR  -- 2016 OTHER FUNDS,
  "n_2017_2022_other_funds" VARCHAR  -- 2017-2022 OTHER FUNDS,
  "total_other_funds" VARCHAR,
  "prior_all_sources" VARCHAR,
  "n_2015_all_sources" VARCHAR  -- 2015 ALL SOURCES,
  "n_2016_all_sources" VARCHAR  -- 2016 ALL SOURCES,
  "n_2017_2022_all_sources" VARCHAR  -- 2017-2022 ALL SOURCES,
  "prior_equipment_costs" VARCHAR,
  "n_2015_equipment_costs" VARCHAR  -- 2015 EQUIPMENT COSTS,
  "n_2016_equipment_costs" VARCHAR  -- 2016 EQUIPMENT COSTS,
  "n_2017_2022_equipment_costs" VARCHAR  -- 2017-2022 EQUIPMENT COSTS,
  "total_equipment_costs" VARCHAR,
  "prior_construction_costs" VARCHAR,
  "n_2015_construction_costs" VARCHAR  -- 2015 CONSTRUCTION COSTS,
  "n_2016_construction_costs" VARCHAR  -- 2016 CONSTRUCTION COSTS,
  "n_2017_2022_construction_costs" VARCHAR  -- 2017-2022 CONSTRUCTION COSTS,
  "total_construction_costs" VARCHAR,
  "prior_other_costs" VARCHAR,
  "n_2015_other_costs" VARCHAR  -- 2015 OTHER COSTS,
  "n_2016_other_costs" VARCHAR  -- 2016 OTHER COSTS,
  "n_2017_2022_other_costs" VARCHAR  -- 2017-2022 OTHER COSTS,
  "total_other_costs" VARCHAR,
  "prior_project_costs" VARCHAR,
  "n_2015_project_costs" VARCHAR  -- 2015 PROJECT COSTS,
  "n_2016_project_costs" VARCHAR  -- 2016 PROJECT COSTS,
  "n_2017_2022_project_costs" VARCHAR  -- 2017-2022 PROJECT COSTS,
  "total_project_costs" VARCHAR,
  "recommended" VARCHAR  -- RECOMMENDED?,
  "n_2015_recommendation" VARCHAR  -- 2015 RECOMMENDATION,
  "n_2016_recommendation" VARCHAR  -- 2016 RECOMMENDATION,
  "n_2017_2022_recommendation" VARCHAR  -- 2017-2022 RECOMMENDATION
);

Share link

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