Baselight

Military Power By Country 2022

40+ metrics of military power by country in 2022.

@kaggle.prasertk_military_power_by_country_2022

Global Firepower 2022 Wide
@kaggle.prasertk_military_power_by_country_2022.global_firepower_2022_wide

  • 61.77 KB
  • 140 rows
  • 48 columns
country

Country

country_code

Country Code

active_personnel

Active Personnel

aircraft_carriers

Aircraft Carriers

armored_vehicles

Armored Vehicles

attack_helicopters

Attack Helicopters

available_manpower

Available Manpower

coastline_coverage

Coastline Coverage

corvettes

Corvettes

dedicated_attack

Dedicated Attack

defense_budget

Defense Budget

destroyers

Destroyers

external_debt

External Debt

fighters_interceptors

Fighters/Interceptors

fit_for_service

Fit-for-Service

foreign_exchange_gold

Foreign Exchange/Gold

frigates

Frigates

helicopter_carriers

Helicopter Carriers

helicopters

Helicopters

labor_force

Labor Force

merchant_marine_fleet

Merchant Marine Fleet

mine_warfare

Mine Warfare

navy_ships

Navy Ships

oil_consumption

Oil Consumption

oil_production

Oil Production

oil_proven_reserves

Oil Proven Reserves

paramilitary

Paramilitary

patrol_vessels

Patrol Vessels

ports_trade_terminals

Ports / Trade Terminals

purchasing_power_parity

Purchasing Power Parity

railway_coverage

Railway Coverage

reaching_mil_age_annually

Reaching Mil Age Annually

reserve_personnel

Reserve Personnel

roadway_coverage

Roadway Coverage

rocket_projectors

Rocket Projectors

self_propelled_artillery

Self-Propelled Artillery

shared_borders

Shared Borders

special_mission

Special-Mission

square_land_area

Square Land Area

submarines

Submarines

tanker_fleet

Tanker Fleet

tanks

Tanks

total_aircraft_strength

Total Aircraft Strength

total_population

Total Population

towed_artillery

Towed Artillery

trainers

Trainers

transports

Transports

waterways_usable

Waterways (usable)

AfghanistanAFG530146119019905000028400000082426115000000000847800035000600002360000000007867953490313598765223037466414601200
AlbaniaALB8000761513309362192400000931100000019128476840000000019110400070192900014000168300000500194380000000006776176839456912874819308838541
AlgeriaALG13000064614520916812998622970000000055740000005521777929010000000000052681085900011420140500012600001220000000020000025124700000000003973697227135000104000334545673492381741652196552435766914508758
AngolaANG107000121015672852916001810592700004208000000029933642651699500000011712510000542401300001600000952300000010000376205700000000285233642626000118285369212467003202993364264658561301300
ArgentinaARG83000800201805744989963064800000427852400000021817153488450000000008518000000202478060004900002162000000200001310900000000000369176879742812902675119681027804002234921845864941172702211000
ArmeniaARM450006732016865011063250000011637000000641382329220000000036150700080004300400000000007804517421000077009438157029743288643011609145102
AustraliaAUS59000176522108401892576037446180000003311591300000043088786316000000000082133125680005814431175000285000182100000012291250900000000333432839102000087357331774122066594302580997354113382000
AustriaAST230005423998189343200000068843400000010235983702200000000063373900026800013000412000004465100000000580097734160000137039622524838715610288848641311
AzerbaijanAZR65000176217503831971311170000000017410000000149377359867000000001874939000305724100000800000700000000015000131140000000000294415423430000024981291167246886600451014910282283319322
BahrainBAH1000083322824542161215388000005215000000011070238723490000001518316002054861000400001246000003000442700000000001679641221738760180110152692926373

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

Share link

Anyone who has the link will be able to view this.