./us_foreign_budget_complete

18 rows where Activity Description = "Budget for Economic Support Fund", Fiscal Year = 2018 and Income Group Acronym = "LMIC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Operating Unit, International Category Name

Link rowid ▼ Country ID Country Code Country Name Region ID Region Name Income Group ID Income Group Name Income Group Acronym Managing Sub-agency or Bureau ID Managing Sub-agency or Bureau Acronym Managing Sub-agency or Bureau Name Operating Unit International Category ID International Category Name International Sector Code International Sector Name International Purpose Code International Purpose Name US Category ID US Category Name US Sector ID US Sector Name Funding Agency ID Funding Agency Name Funding Agency Acronym OCO Flag Activity ID Activity Name Activity Description Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
5442 5442 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 2000000 2283823
5580 5580 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 151 Government and Civil Society 15111 Public finance management 2 Democracy, Human Rights, and Governance 9 Political Competition and Consensus-Building 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 6130000 6999917
5596 5596 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 500000 570956
5608 5608 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 8 Good Governance 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 3770000 4305006
5631 5631 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 10845000 12384030
5668 5668 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 151 Government and Civil Society 15160 Human rights 2 Democracy, Human Rights, and Governance 7 Rule of Law and Human Rights 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 8805000 10054531
5703 5703 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 22750000 25978487
5731 5731 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 880000 1004882
5750 5750 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 19000000 21696318
5768 5768 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 8020000 9158130
16942 16942 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 3000000 3425734
17097 17097 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 6000000 6851469
17105 17105 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 8 Good Governance 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 3000000 3425734
17202 17202 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 4000000 4567646
17238 17238 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 1000000 1141911
17284 17284 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 6000000 6851469
17293 17293 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 1000000 1141911
36940 36940 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2018 30000000 34257345

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_budget_complete" (
"Country ID" INTEGER,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Region ID" INTEGER,
  "Region Name" TEXT,
  "Income Group ID" INTEGER,
  "Income Group Name" TEXT,
  "Income Group Acronym" TEXT,
  "Managing Sub-agency or Bureau ID" INTEGER,
  "Managing Sub-agency or Bureau Acronym" TEXT,
  "Managing Sub-agency or Bureau Name" TEXT,
  "Operating Unit" TEXT,
  "International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "International Purpose Code" INTEGER,
  "International Purpose Name" TEXT,
  "US Category ID" INTEGER,
  "US Category Name" TEXT,
  "US Sector ID" INTEGER,
  "US Sector Name" TEXT,
  "Funding Account ID" TEXT,
  "Funding Account Name" TEXT,
  "Funding Agency ID" INTEGER,
  "Funding Agency Name" TEXT,
  "Funding Agency Acronym" TEXT,
  "OCO Flag" INTEGER,
  "Activity ID" INTEGER,
  "Activity Name" TEXT,
  "Activity Description" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);