./us_foreign_budget_complete

28 rows where Fiscal Year = 2009, Funding Account Name = "International Narcotics Control and Law Enforcement" and Region Name = "South and Central Asia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type 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
480 480 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 47500000 62681285
487 487 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 34000000 44866604
497 497 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   345044000 Budget for International Narcotics Control and Law Enforcement, Bridge Supplemental Budget for International Narcotics Control and Law Enforcement, Bridge Supplemental 1 Appropriated and Planned 2009 55500000 73238133
499 499 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 1 Appropriated and Planned 2009 84500000 111506706
500 500 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 18 President's Budget Requests 2009 80000000 105568480
781 781 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 202500000 267220214
788 788 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 216000000 285034895
798 798 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345044000 Budget for International Narcotics Control and Law Enforcement, Bridge Supplemental Budget for International Narcotics Control and Law Enforcement, Bridge Supplemental 1 Appropriated and Planned 2009 45500000 60042073
800 800 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 1 Appropriated and Planned 2009 48500000 64000891
801 801 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 18 President's Budget Requests 2009 49000000 64660694
3056 3056 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 800000 1055685
3264 3264 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 200000 263921
7560 7560 144 LKA Sri Lanka 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Sri Lanka 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 20000 26392
7565 7565 144 LKA Sri Lanka 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Sri Lanka 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 350000 461862
17206 17206 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 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 400000 527842
29285 29285 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 1000000 1319606
29371 29371 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 1000000 1319606
29432 29432 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 330000 435470
29443 29443 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 8000000 10556848
31497 31497 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 1634000 2156236
31504 31504 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 2600000 3430976
31632 31632 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 16554000 21844758
31639 31639 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 21700000 28635450
31649 31649 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 1 Appropriated and Planned 2009 65500000 86434193
31650 31650 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 18 President's Budget Requests 2009 60500000 79836163
31748 31748 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 3812000 5030338
31755 31755 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 7700000 10160966
31964 31964 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 10 Administrative Costs 912 Program Design and Learning 91020 Program Design and Learning 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345047000 Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental 18 President's Budget Requests 2009 5000000 6598030

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
);