./us_foreign_budget_complete

34 rows where Funding Agency Acronym = "DOD" and Income Group ID = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Transaction Type ID, Fiscal Year

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
2631 2631 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 175098 212429
2632 2632 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 4661000 5977187
2633 2633 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 343000 431940
4242 4242 52 BRB Barbados 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 3637 4412
4243 4243 52 BRB Barbados 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 130000 166710
4244 4244 52 BRB Barbados 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 841000 1059071
5335 5335 96 BRN Brunei 1 East Asia and Oceania 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 93099 112948
8032 8032 152 CHL Chile 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 18118 21981
8033 8033 152 CHL Chile 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 604000 774559
13962 13962 276 DEU Germany 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 1406000 1803030
13963 13963 276 DEU Germany 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 597000 751802
14574 14574 300 GRC Greece 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 4000 5037
18831 18831 380 ITA Italy 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 937000 1201593
23200 23200 428 LVA Latvia 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 410000 391057
24286 24286 440 LTU Lithuania 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 410000 391057
24287 24287 440 LTU Lithuania 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 410000 382030
28975 28975 512 OMN Oman 3 Middle East and North Africa 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 312049 378577
32220 32220 591 PAN Panama 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 129190 156733
32221 32221 591 PAN Panama 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 7987000 10242392
32222 32222 591 PAN Panama 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 4166000 5246244
33888 33888 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 420000 400595
33889 33889 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 290000 270216
35109 35109 659 KNA St. Kitts and Nevis 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 3637 4412
36453 36453 702 SGP Singapore 1 East Asia and Oceania 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 43000 55142
36505 36505 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 139729 169519
36506 36506 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 410000 391057
36507 36507 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 350000 326123
40927 40927 780 TTO Trinidad and Tobago 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 19391 23525
40928 40928 780 TTO Trinidad and Tobago 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 130000 166710
40929 40929 780 TTO Trinidad and Tobago 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 294000 370234
44363 44363 826 GBR United Kingdom 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 2812000 3606061
45267 45267 858 URY Uruguay 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 168437 204348
45268 45268 858 URY Uruguay 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 110000 141062
45269 45269 858 URY Uruguay 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 79000 99485

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