home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

16 rows where Activity ID = 345096000, Fiscal Year = 2018 and Funding Account ID = "19x1143"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category ID, International Purpose 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 Account ID Funding Account 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
54485 54485 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 1200000 1370294
54496 54496 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 1350000 1541581
54510 54510 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 38800000 44306166
54522 54522 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 43650000 49844437
54560 54560 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Humanitarian Migrants to Israel 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 7500000 8564336
54571 54571 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Humanitarian Migrants to Israel 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 7500000 8564336
54618 54618 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - East Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 124700000 142396364
54629 54629 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - East Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 57600000 65774102
54676 54676 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Migration 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 37100000 42364917
54687 54687 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Migration 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 30335000 34639885
54739 54739 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Protection Priorities 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 434402000 496048639
54751 54751 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Protection Priorities 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 113506000 129613806
54804 54804 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Western Hemisphere 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 87300000 99688874
54816 54816 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - Western Hemisphere 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 51300000 58580060
54831 54831 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2018 203800000 232721563
54843 54843 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 19x1143 Department of State, Migration and Refugee Assistance 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2018 410000000 468183714

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
);
Powered by Datasette · Queries took 7266.53ms