./us_foreign_budget_complete

24 rows where Fiscal Year = 2023 and Funding Account ID = "19x1143"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Sector Code, International Purpose Name, Transaction Type ID

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
56425 56425 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Administrative Expenses 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 2448000 2334898
56427 56427 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Administrative Expenses 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 2156000 2056389
56431 56431 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 79152000 75495049
56433 56433 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 67844000 64709497
56443 56443 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - 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 39 Migration Management 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 5000000 4768992
56445 56445 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - 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 39 Migration Management 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 5000000 4768992
56449 56449 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 773900000 738144566
56451 56451 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 822500000 784499167
56456 56456 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration, Overseas Assistance (DOS) - Migration 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 50000000 47689919
56458 56458 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration, Overseas Assistance (DOS) - Migration 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 61500000 58658600
56461 56461 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration, Overseas Assistance (DOS) - Protection Priorities 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 421140000 401682649
56463 56463 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration, Overseas Assistance (DOS) - Protection Priorities 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 257700000 245793842
60374 60374 1016 ENS Eastern Asia Region 1 East Asia and Oceania       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, East Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 113200000 107969977
60376 60376 1016 ENS Eastern Asia Region 1 East Asia and Oceania       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, East Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 247500000 236065099
60868 60868 1018 EUN Europe Region 2 Europe and Eurasia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Europe 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 34100000 32524525
60870 60870 1018 EUN Europe Region 2 Europe and Eurasia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Europe 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 80000000 76303870
61305 61305 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Near East 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 655448000 625165240
61307 61307 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Near East 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 1048000000 999580701
61670 61670 1029 SAN Southern Asia Region 4 South and Central Asia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, South Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 9300000 8870325
61672 61672 1029 SAN Southern Asia Region 4 South and Central Asia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, South Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 85000000 81072862
62141 62141 1033 SSN Sub-Saharan Africa Region 5 Sub-Saharan Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Africa 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 282900000 269829561
62143 62143 1033 SSN Sub-Saharan Africa Region 5 Sub-Saharan Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Africa 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 848300000 809107165
62288 62288 1035 WHN Western Hemisphere Region 6 Western Hemisphere       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Western Hemisphere 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2023 474100000 452195812
62290 62290 1035 WHN Western Hemisphere Region 6 Western Hemisphere       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Western Hemisphere 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2023 398000000 379611755

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