REVENUES OF GOVERNMENT

Getting to know the INCOME SOURCES of Government

@kaggle.vaibhavkh_revenues_of_government

Table List

2 tables(26.82 KB)

Details Of Tax Revenue

@kaggle.vaibhavkh_revenues_of_government.details_of_tax_revenue

12.29 KB
120 rows
10 columns

group Group	scheme Scheme	sub_scheme_name Sub Scheme Name	programme_name Programme Name	sub_programme_name Sub Programme Name	major_head_code Major Head Code	actuals_2020_2021 Actuals 2020-2021	budget_2021_2022 Budget 2021-2022	revised_2021_2022 Revised 2021-2022	budget_2022_2023 Budget 2022-2023
Tax Revenue	Corporation Tax	Collections	nan	nan	20	412013.46	473365.39	549519.23	623076.92
Tax Revenue	Corporation Tax	Surcharge	nan	nan	20	14078.58	52596.15	61057.69	69230.77
Tax Revenue	Corporation Tax	Health and Education Cess	nan	nan	20	17795.16	21038.46	24423.08	27692.31
Tax Revenue	Corporation Tax	Penalties	nan	nan	20	79.47
Tax Revenue	Corporation Tax	Interest Recoveries	nan	nan	20	1754.61
Tax Revenue	Corporation Tax	Tax on Discounted Profits of Domestic Companies	nan	nan	20	3800.98
Tax Revenue	Corporation Tax	Tax on Distributed Income to Unit Holders	nan	nan	20	8007.03
Tax Revenue	Corporation Tax	Miscellaneous Receipts	nan	nan	20	189.68
nan	Total-Corporation Tax	nan	nan	nan		457718.97	547000	635000	720000
Tax Revenue	Taxes on Income	Collections	nan	nan	21	442607.02	474663.47	514903.85	588461.54


CREATE TABLE details_of_tax_revenue (
  "group" VARCHAR,
  "scheme" VARCHAR,
  "sub_scheme_name" VARCHAR,
  "programme_name" VARCHAR,
  "sub_programme_name" VARCHAR,
  "major_head_code" DOUBLE,
  "actuals_2020_2021" DOUBLE,
  "budget_2021_2022" DOUBLE,
  "revised_2021_2022" DOUBLE,
  "budget_2022_2023" DOUBLE
);