Name: US Military Interventions
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

US Military Interventions

From the project website: https://sites.tufts.edu/css/mip-research/mip-dataset/

The Military Intervention Project (MIP) within the Center for Strategic Studies (CSS) seeks to solve the puzzle of US foreign military interventions. It is building a new, comprehensive dataset of all US military interventions from 1776 until 2017 to measure the costs, benefits, and unintended consequences of US military involvements abroad. In other words, this dataset will provide strong empirical evidence regarding the trade-offs of US military interventions – a current hot topic in Congress, the media, and in public opinion. MIP will measure the costs and benefits to US national interests, economic growth, international reputation as well as human rights, democratic, and economic outcomes within the target state, and much more.

Tables

Case Universe

@kaggle.konradb_us_military_interventions.case_universe

12.98 kB
569 rows
10 columns

CREATE TABLE case_universe (
  "target_state" VARCHAR,
  "target_cow_id" VARCHAR,
  "start_year" BIGINT,
  "end_year" DOUBLE,
  "uncertain" BIGINT,
  "mid" DOUBLE,
  "imi" DOUBLE,
  "mips" DOUBLE,
  "crs" DOUBLE,
  "acd" DOUBLE
);

Duration

@kaggle.konradb_us_military_interventions.duration

3.12 kB
21 rows
2 columns

CREATE TABLE duration (
  "name" VARCHAR,
  "duration" BIGINT
);

Main Table

@kaggle.konradb_us_military_interventions.main_table

398.57 kB
570 rows
245 columns

CREATE TABLE main_table (
  "state_b" VARCHAR,
  "state_b_code" VARCHAR,
  "styear" BIGINT,
  "stateb_primary_target" VARCHAR  -- StateB Primary Target?,
  "name" VARCHAR,
  "location" VARCHAR,
  "dispnum" VARCHAR,
  "removecase" BIGINT,
  "stday" DOUBLE,
  "stmon" DOUBLE,
  "endday" DOUBLE,
  "endmon" DOUBLE,
  "endyear" DOUBLE,
  "ongoing" DOUBLE,
  "cumdurat" DOUBLE,
  "era" DOUBLE,
  "decade" DOUBLE,
  "presname" VARCHAR,
  "frontier_war" DOUBLE,
  "era2" DOUBLE,
  "us_hihost" DOUBLE,
  "us_highact" DOUBLE,
  "dyadic_hostility" DOUBLE,
  "dyadic_highact" DOUBLE,
  "hihostb" DOUBLE,
  "highactb" VARCHAR,
  "us_orig" DOUBLE,
  "originata" DOUBLE,
  "originatb" DOUBLE,
  "sideaa" DOUBLE,
  "intertype" DOUBLE,
  "objective" VARCHAR,
  "objectivecode" VARCHAR,
  "foreignreg" DOUBLE,
  "buildreg" DOUBLE,
  "empire" DOUBLE,
  "territory" DOUBLE,
  "policy" DOUBLE,
  "socialprot" DOUBLE,
  "economic" DOUBLE,
  "protown" DOUBLE,
  "outcome" VARCHAR,
  "battlefatus" VARCHAR,
  "battlefatb" VARCHAR,
  "battlefat" VARCHAR,
  "battlelevus" VARCHAR,
  "battlelevb" VARCHAR,
  "battlelev" VARCHAR,
  "fatus" VARCHAR,
  "fatb" VARCHAR,
  "fatalities" VARCHAR,
  "fatlevus" VARCHAR,
  "fatlevb" VARCHAR,
  "fatlev" VARCHAR,
  "maxcost" VARCHAR,
  "maxtroops" VARCHAR,
  "maxnavy" VARCHAR,
  "maxair" VARCHAR,
  "mip" DOUBLE,
  "additions_to_mid" DOUBLE,
  "mid_dummy" DOUBLE,
  "imi_dummy" DOUBLE,
  "mips_dummy" DOUBLE,
  "crs_dummy" DOUBLE,
  "acd_dummy" DOUBLE,
  "national_interest_index" DOUBLE,
  "contiguity" DOUBLE,
  "contiguitydummy" DOUBLE,
  "war" DOUBLE,
  "us_milex" DOUBLE,
  "us_milper" DOUBLE,
  "us_irst" DOUBLE,
  "us_pec" DOUBLE,
  "us_tpop" DOUBLE,
  "us_upop" DOUBLE,
  "us_cinc" DOUBLE,
  "state_b_milex" DOUBLE,
  "state_b_milper" DOUBLE,
  "state_b_irst" DOUBLE,
  "state_b_pec" DOUBLE,
  "state_b_tpop" DOUBLE,
  "state_b_upop" DOUBLE,
  "state_b_cinc" DOUBLE,
  "defense" DOUBLE,
  "neutrality" DOUBLE,
  "nonaggression" DOUBLE,
  "entente" DOUBLE,
  "alliancedummy" DOUBLE,
  "alliances_1_4" DOUBLE  -- Alliances (1-4),
  "colonial_land" DOUBLE,
  "colonial_sea" DOUBLE,
  "colonial_contiguity" DOUBLE,
  "colonialdummy" DOUBLE,
  "us_imports" DOUBLE,
  "us_exports" DOUBLE,
  "state_b_imports" DOUBLE,
  "state_b_exports" DOUBLE,
  "trade_flow1" DOUBLE,
  "trade_flow2" DOUBLE,
  "smoothflow1" DOUBLE
);