home / 2025-02-03_foreign-assistance

./us_foreign_aid_dac_sector

83 rows where International Sector Name = "Disaster Prevention and Preparedness"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ International Category ID International Category Name International Sector Code International Sector Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
2104 2104 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2006 87264000 122006834
2105 2105 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2007 78226000 106451266
2106 2106 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2008 78785000 105021649
2107 2107 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2009 151107000 199401702
2108 2108 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2010 81464000 106573464
2109 2109 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2011 142811000 183138384
2110 2110 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2012 104755000 131917972
2111 2111 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2013 169820000 210011122
2112 2112 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2014 175481000 212893279
2113 2113 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2015 161928000 194224145
2114 2114 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2016 319884000 380530816
2115 2115 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2017 219617000 256671639
2116 2116 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2018 427827000 488540569
2117 2117 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2019 313251000 350833320
2118 2118 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2020 493069000 544955056
2119 2119 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2021 711163000 760437775
2120 2120 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2022 1123718000 1123718000
2121 2121 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2023 945064912 901401383
2122 2122 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2001 331913 544798
2123 2123 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2002 387256 625793
2124 2124 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2003 542800 860626
2125 2125 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2004 5888229 9113427
2126 2126 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2005 5336795 8016027
2127 2127 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2006 9799046 14255389
2128 2128 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2007 36343293 51454718
2129 2129 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2008 41165334 57096371
2130 2130 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2009 82671039 113504146
2131 2131 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2010 64715555 88089065
2132 2132 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2011 108081061 144222303
2133 2133 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2012 155267651 203494987
2134 2134 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2013 111456701 143472740
2135 2135 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2014 143012008 180794084
2136 2136 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2015 157269583 196780439
2137 2137 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2016 152441763 189226829
2138 2138 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2017 177931123 217200514
2139 2139 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2018 220614415 263455323
2140 2140 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2019 210597316 246927438
2141 2141 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2020 261369947 302507145
2142 2142 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2021 257233647 287814038
2143 2143 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2022 298071061 311706789
2144 2144 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2023 452225132 452225132
2145 2145 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2024 387927318 377836801
2146 2146 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2001 21028731 34516300
2147 2147 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2002 6233613 10073300
2148 2148 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2003 2532468 4015306
2149 2149 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2004 5826643 9018109
2150 2150 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2005 4237289 6364536
2151 2151 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2006 3645515 5303398
2152 2152 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2007 6471709 9162620
2153 2153 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2008 22032401 30558965
2154 2154 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2009 38140437 52365341
2155 2155 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2010 61045924 83094065
2156 2156 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2011 80842925 107875992
2157 2157 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2012 93244547 122207008
2158 2158 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2013 116392931 149826907
2159 2159 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2014 122848262 155303302
2160 2160 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2015 146171660 182894385
2161 2161 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2016 154353103 191599371
2162 2162 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2017 141575184 172820796
2163 2163 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2018 158592084 189388949
2164 2164 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2019 169439036 198668935
2165 2165 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2020 168228285 194705819
2166 2166 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2021 207190383 231821531
2167 2167 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2022 320269120 334920338
2168 2168 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2023 365814154 365814154
2169 2169 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2024 352911431 343731760
2170 2170 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2008 17449000 23259793
2171 2171 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2009 81591000 107667972
2172 2172 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2010 129419000 169309527
2173 2173 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2011 105333000 135077237
2174 2174 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2012 76152000 95898214
2175 2175 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2013 111683000 138114896
2176 2176 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2014 139763000 169560258
2177 2177 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2015 149780000 179653256
2178 2178 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2016 198428000 236047968
2179 2179 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2017 154857000 180985077
2180 2180 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2018 120321000 137395933
2181 2181 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2019 172776000 193504818
2182 2182 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2020 18000000 19894154
2183 2183 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2021 17500000 18712533
2184 2184 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2022 220211000 220211000
2185 2185 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2023 703169000 670681453
2186 2186 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2024 608275000 566778179

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "./us_foreign_aid_dac_sector" (
"International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);
Powered by Datasette · Queries took 5198.969ms