BPK Audit Report On Sub-National Budget

@worldbank.indonesia_database_for_policy_and_economic_research.bpk_aud_subn

11.3 kB
24,660 rows
3 columns

CREATE TABLE bpk_aud_subn (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Agriculture (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_agr_cr

15.39 kB
24,660 rows
3 columns

CREATE TABLE dak_agr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Education (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_edu_cr

19.94 kB
24,660 rows
3 columns

CREATE TABLE dak_edu_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Environment (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_envr_cr

12.86 kB
24,660 rows
3 columns

CREATE TABLE dak_envr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Forestry (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_frst_cr

9.51 kB
24,660 rows
3 columns

CREATE TABLE dak_frst_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Fishery (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_fsh_cr

15.83 kB
24,660 rows
3 columns

CREATE TABLE dak_fsh_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Government Sector (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_govt_cr

11.26 kB
24,660 rows
3 columns

CREATE TABLE dak_govt_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Health Sector (Subsect: Basic Services) (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_he_bsrv_cr

10.97 kB
24,660 rows
3 columns

CREATE TABLE dak_he_bsrv_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Health (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_he_cr

19.32 kB
24,660 rows
3 columns

CREATE TABLE dak_he_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Health Sector (Subsect: Recommended Services) (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_he_rsrv_cr

9.78 kB
24,660 rows
3 columns

CREATE TABLE dak_he_rsrv_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Infrastructure (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_infr_cr

21.67 kB
24,660 rows
3 columns

CREATE TABLE dak_infr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Infrastructure Sector (Subsect: Water) (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_infr_h2o_cr

16.21 kB
24,660 rows
3 columns

CREATE TABLE dak_infr_h2o_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Infrastructure Sector (Subsect: Irrigation) (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_infr_irig_cr

17.04 kB
24,660 rows
3 columns

CREATE TABLE dak_infr_irig_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Infrastructure Sector (Subsect: Road) (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_infr_rod_cr

20.54 kB
24,660 rows
3 columns

CREATE TABLE dak_infr_rod_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Demographic (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_pop_cr

11.29 kB
24,660 rows
3 columns

CREATE TABLE dak_pop_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Trade (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_trad_cr

9.59 kB
24,660 rows
3 columns

CREATE TABLE dak_trad_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Specific Allocation Grant For Village (in IDR Billion)

@worldbank.indonesia_database_for_policy_and_economic_research.dak_vilg_cr

9.03 kB
24,660 rows
3 columns

CREATE TABLE dak_vilg_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Capital Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.ec_xpd_cap_cr

93.28 kB
24,660 rows
3 columns

CREATE TABLE ec_xpd_cap_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Goods And Services Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.ec_xpd_gsr_cr

95.56 kB
24,660 rows
3 columns

CREATE TABLE ec_xpd_gsr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Others Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.ec_xpd_othr_cr

94.45 kB
24,660 rows
3 columns

CREATE TABLE ec_xpd_othr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Personnel Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.ec_xpd_staf_cr

96.48 kB
24,660 rows
3 columns

CREATE TABLE ec_xpd_staf_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.ec_xpd_totl_cr

97.95 kB
24,660 rows
3 columns

CREATE TABLE ec_xpd_totl_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Consumer Price Index In 42 Cities Base 1996

@worldbank.indonesia_database_for_policy_and_economic_research.ep_cpi_1996

11.14 kB
24,660 rows
3 columns

CREATE TABLE ep_cpi_1996 (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Consumer Price Index In 45 Cities Base 2002

@worldbank.indonesia_database_for_policy_and_economic_research.ep_cpi_2002

10.48 kB
24,660 rows
3 columns

CREATE TABLE ep_cpi_2002 (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Consumer Price Index In 66 Cities Base 2007

@worldbank.indonesia_database_for_policy_and_economic_research.ep_cpi_2007

11.61 kB
24,660 rows
3 columns

CREATE TABLE ep_cpi_2007 (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Consumer Price Index In 82 Cities Base 2012

@worldbank.indonesia_database_for_policy_and_economic_research.ep_cpi_2012

12.04 kB
24,660 rows
3 columns

CREATE TABLE ep_cpi_2012 (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Consumer Price Index In 90 Cities Base 2018

@worldbank.indonesia_database_for_policy_and_economic_research.ep_cpi_2018

8.87 kB
24,660 rows
3 columns

CREATE TABLE ep_cpi_2018 (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

General Administration Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_admn_cr

55.02 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_admn_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Agriculture Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_agr_cr

53.18 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_agr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Economy Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_econ_cr

53.12 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_econ_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Education Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_edu_cr

91.25 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_edu_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Environment Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_envr_cr

84.13 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_envr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Health Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_he_cr

90.47 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_he_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Housing And Public Facilities Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_hous_cr

33.52 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_hous_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Infrastructure Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_infr_cr

53.95 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_infr_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Social Protection Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_prot_cr

47.49 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_prot_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Public, Law And Order Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_publ_cr

73.72 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_publ_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Religious Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_relg_cr

14.28 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_relg_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Tourism And Culture Function Expenditure (in IDR)

@worldbank.indonesia_database_for_policy_and_economic_research.fc_xpd_tour_cr

76.86 kB
24,660 rows
3 columns

CREATE TABLE fc_xpd_tour_cr (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Agriculture (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_agr_totl

11.23 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_agr_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Business (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_bus_totl

11.24 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_bus_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Utilization: Consumption (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_cnsp_totl

11.31 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_cnsp_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Construction (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_cnst_totl

11.2 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_cnst_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Utilization: Investment (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_invs_totl

11.29 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_invs_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Mining And Quarrying (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_minq_totl

10.84 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_minq_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Manufacture (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_mnf_totl

11.26 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_mnf_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Other Services (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_srv_othr_totl

11.32 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_srv_othr_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Social Services (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_srv_socl_totl

11.15 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_srv_socl_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Trade (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_trad_totl

11.3 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_trad_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Total Credit By Sector: Transportation (province Level, In IDR Million)

@worldbank.indonesia_database_for_policy_and_economic_research.fn_cred_tran_totl

11.17 kB
24,660 rows
3 columns

CREATE TABLE fn_cred_tran_totl (
  "economy" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE
);

Tables