./us_foreign_budget_complete

44 rows where Fiscal Year = 2013 and Managing Sub-agency or Bureau Name = "International Narcotics and Law Enforcement Affairs"

✎ View and edit SQL

This data as json, CSV (advanced)

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
52824 52824 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Alien Smuggling/Border Security 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 2013 1000000 1236669
52828 52828 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Alien Smuggling/Border Security 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 2013 750000 927502
52840 52840 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Anti-Money Laundering Programs 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 1 Appropriated and Planned 2013 4148000 5129703
52847 52847 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Anti-Money Laundering Programs 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 2013 3600000 4452008
52859 52859 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - CFSP, Critical Flight Safety Program 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 2013 4200000 5194010
52864 52864 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - CFSP, Critical Flight Safety Program 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 2013 4200000 5194010
52870 52870 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - CFSP, Critical Flight Safety Program 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 2013 8185000 10122135
52881 52881 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - CFSP, Critical Flight Safety Program 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 2013 8185000 10122135
52900 52900 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Criminal Justice Assistance and Partnership 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 2013 4200000 5194010
52910 52910 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Criminal Justice Assistance and Partnership 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 2013 3800000 4699342
52924 52924 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Criminal Youth Gangs 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 1 Appropriated and Planned 2013 3000000 3710007
52929 52929 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Criminal Youth Gangs 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 2013 3000000 3710007
52934 52934 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Cyber Crime and IPR 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 1 Appropriated and Planned 2013 4739000 5860574
52945 52945 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Cyber Crime and IPR 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 2013 3500000 4328341
52959 52959 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Demand Reduction 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 2013 12499000 15457125
52971 52971 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Demand Reduction 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 2013 12500000 15458362
52985 52985 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Fighting Corruption 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2013 5001000 6184581
53008 53008 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Fighting Corruption 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 2013 3900000 4823009
53027 53027 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - ILEA, International Law Enforcement Academy 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 2013 27000000 33390062
53039 53039 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - ILEA, International Law Enforcement Academy 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 2013 24000000 29680055
53050 53050 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - IPPOS, International Police Peacekeeping Operations Support 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 2013 7500000 9275017
53058 53058 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - IPPOS, International Police Peacekeeping Operations Support 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 2013 5000000 6183345
53067 53067 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 1 Appropriated and Planned 2013 100000 123667
53068 53068 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 2013 100000 123667
53072 53072 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 2013 4271000 5281813
53078 53078 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 2013 4271000 5281813
53088 53088 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 2013 41958000 51888156
53100 53100 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Inter-regional Aviation Support 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 2013 41951000 51879499
53114 53114 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organizations 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 1 Appropriated and Planned 2013 1100000 1360336
53125 53125 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organizations 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 2013 1100000 1360336
53137 53137 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organizations 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 2013 3900000 4823009
53148 53148 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organizations 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 2013 3400000 4204674
53158 53158 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organized Crime 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 1 Appropriated and Planned 2013 5000000 6183345
53169 53169 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organized Crime 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 2013 750000 927502
53188 53188 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 1 Appropriated and Planned 2013 1570000 1941570
53200 53200 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 1303000 1611380
53214 53214 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2013 785000 970785
53226 53226 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2013 651000 805071
53240 53240 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 8241000 10191389
53252 53252 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 6839000 8457579
53266 53266 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 14892000 18416474
53278 53278 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 12358000 15282755
53292 53292 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 13736000 16986885
53304 53304 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - Program Development and Support 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 2013 11399000 14096789

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