home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

12 rows where Funding Agency ID = 29 and US Category Name = "Environment"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Operating Unit, International Category ID, International Category Name, International Sector Code, International Sector Name, International Purpose Code, International Purpose Name, US Sector ID, US Sector Name, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount

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
58219 58219 1002 WLD World 7 World       998   Unknown - Budget Data OECA Immediate Office 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344889000 Budget for Enforcement Budget for Enforcement 1 Appropriated and Planned 2023 45000 42921
58220 58220 1002 WLD World 7 World       998   Unknown - Budget Data OECA Immediate Office 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344889000 Budget for Enforcement Budget for Enforcement 18 President's Budget Requests 2024 45000 41930
58222 58222 1002 WLD World 7 World       998   Unknown - Budget Data Office of Atmospheric Protection 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344888000 Budget for Clean Air and Climate Budget for Clean Air and Climate 1 Appropriated and Planned 2023 9826000 9372023
58223 58223 1002 WLD World 7 World       998   Unknown - Budget Data Office of Atmospheric Protection 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344888000 Budget for Clean Air and Climate Budget for Clean Air and Climate 18 President's Budget Requests 2024 19400000 18076522
58258 58258 1002 WLD World 7 World       998   Unknown - Budget Data Office of International and Tribal Affairs 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344891000 Budget for International Programs Budget for International Programs 1 Appropriated and Planned 2023 15826000 15094813
58259 58259 1002 WLD World 7 World       998   Unknown - Budget Data Office of International and Tribal Affairs 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344891000 Budget for International Programs Budget for International Programs 18 President's Budget Requests 2024 38285000 35673178
58269 58269 1002 WLD World 7 World       998   Unknown - Budget Data Office of Pollution Prevention & Toxics 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344887000 Budget for Chemical Risk Review and Reduction Budget for Chemical Risk Review and Reduction 1 Appropriated and Planned 2023 10000 9538
58270 58270 1002 WLD World 7 World       998   Unknown - Budget Data Office of Pollution Prevention & Toxics 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344887000 Budget for Chemical Risk Review and Reduction Budget for Chemical Risk Review and Reduction 18 President's Budget Requests 2024 140000 130449
58271 58271 1002 WLD World 7 World       998   Unknown - Budget Data Office of Radiation and Indoor Air 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344890000 Budget for Indoor Air and Radiation Budget for Indoor Air and Radiation 1 Appropriated and Planned 2023 265000 252757
58272 58272 1002 WLD World 7 World       998   Unknown - Budget Data Office of Radiation and Indoor Air 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344890000 Budget for Indoor Air and Radiation Budget for Indoor Air and Radiation 18 President's Budget Requests 2024 1000000 931780
58565 58565 1002 WLD World 7 World       998   Unknown - Budget Data RCRA Waste Minimization 2 Health and Population 140 Water Supply and Sanitation 14050 Waste management / disposal 6 Environment 36 Clean Productive Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344892000 Budget for Resource Conservation and Recovery Act Budget for Resource Conservation and Recovery Act 1 Appropriated and Planned 2023 600000 572279
58566 58566 1002 WLD World 7 World       998   Unknown - Budget Data RCRA Waste Minimization 2 Health and Population 140 Water Supply and Sanitation 14050 Waste management / disposal 6 Environment 36 Clean Productive Environment 68x0108 Environmental Protection Agency, Environmental Programs and Management 29 Environmental Protection Agency EPA   344892000 Budget for Resource Conservation and Recovery Act Budget for Resource Conservation and Recovery Act 18 President's Budget Requests 2024 600000 559068

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 4245.323ms