Military Power By Country 2022

CREATE TABLE global_firepower_2022_wide (
  "country" VARCHAR,
  "country_code" VARCHAR,
  "active_personnel" BIGINT,
  "aircraft_carriers" BIGINT,
  "armored_vehicles" BIGINT,
  "attack_helicopters" BIGINT,
  "available_manpower" BIGINT,
  "coastline_coverage" BIGINT,
  "corvettes" BIGINT,
  "dedicated_attack" BIGINT,
  "defense_budget" BIGINT,
  "destroyers" BIGINT,
  "external_debt" BIGINT,
  "fighters_interceptors" BIGINT,
  "fit_for_service" BIGINT,
  "foreign_exchange_gold" BIGINT,
  "frigates" BIGINT,
  "helicopter_carriers" BIGINT,
  "helicopters" BIGINT,
  "labor_force" BIGINT,
  "merchant_marine_fleet" BIGINT,
  "mine_warfare" BIGINT,
  "navy_ships" BIGINT,
  "oil_consumption" BIGINT,
  "oil_production" BIGINT,
  "oil_proven_reserves" BIGINT,
  "paramilitary" BIGINT,
  "patrol_vessels" BIGINT,
  "ports_trade_terminals" BIGINT,
  "purchasing_power_parity" BIGINT,
  "railway_coverage" BIGINT,
  "reaching_mil_age_annually" BIGINT,
  "reserve_personnel" BIGINT,
  "roadway_coverage" BIGINT,
  "rocket_projectors" BIGINT,
  "self_propelled_artillery" BIGINT,
  "shared_borders" BIGINT,
  "special_mission" BIGINT,
  "square_land_area" BIGINT,
  "submarines" BIGINT,
  "tanker_fleet" BIGINT,
  "tanks" BIGINT,
  "total_aircraft_strength" BIGINT,
  "total_population" BIGINT,
  "towed_artillery" BIGINT,
  "trainers" BIGINT,
  "transports" BIGINT,
  "waterways_usable" BIGINT
);