Israel Vs Palestine

A brief look at the socio economic and military strengths( 2000 - 2020)

@kaggle.zsinghrahulk_israel_vs_palestine

Table List

1 table(15.26 KB)

Israel Palestine

@kaggle.zsinghrahulk_israel_vs_palestine.israel_palestine

15.26 KB
44 rows
16 columns

year Year	country Country	gdp_in_usd GDP (in USD)	population Population	gdp_growth_rate GDP Growth Rate (%)	fertility_rate Fertility Rate	infant_mortality_rate_per_1_000_live_births Infant Mortality Rate (per 1,000 Live Births)	maternal_mortality_rate_per_100_000_live_births Maternal Mortality Rate (per 100,000 Live Births)	agricultural_output_in_usd Agricultural Output (in USD)	active_military_personnel Active Military Personnel	reserve_military_personnel Reserve Military Personnel	literacy_rate Literacy Rate (%)	it_output_in_usd IT Output (in USD)	number_of_tanks Number Of Tanks	number_of_submarines Number Of Submarines	number_of_armoured_vehicles Number Of Armoured Vehicles
2000	Israel	132.02 billion	6049000	5.18	2.89	5	7.2	5.71 billion	168000	445000	97.1	6.78 billion	2760	3	10760
2000	Palestine	4.56 billion	3374000	5.33	5.36	24.6	26	880 million			90.3	0.115 billion
2001	Israel	131.02 billion	6165000	-0.47	2.89	4.8	6.7	5.17 billion	166500	445000	97.5	6.89 billion	2791	3	10814
2001	Palestine	4.59 billion	3400000	-50	5.22	22.5	24.4	925 million			90.8	0.122 billion
2002	Israel	126.64 billion	6263000	-0.35	2.98	4.6	5.9	4.76 billion	163000	375000	97.9	7.02 billion	2821	3	10885
2002	Palestine	4.34 billion	3421000	-46.3	5.07	20.2	21.3	914 million			91.2	0.132 billion
2003	Israel	129.56 billion	6684000	2.8	2.81	4.3	6.1	5.10 billion	160000	445000	97.9	7.15 billion	2819	3	10885
2003	Palestine	3.56 billion	3693000	-16.1	5.15	23	30.9	819 million			91.7	0.143 billion
2004	Israel	143.53 billion	6830000	4.5	2.84	4.1	6.8	5.33 billion	159000	428000	97.9	7.36 billion	2798	3	10886
2004	Palestine	3.89 billion	3791000	10.5	4.95	21.6	29.4	876 million			92.1	0.154 billion


CREATE TABLE israel_palestine (
  "year" BIGINT,
  "country" VARCHAR,
  "gdp_in_usd" VARCHAR,
  "population" BIGINT,
  "gdp_growth_rate" DOUBLE,
  "fertility_rate" DOUBLE,
  "infant_mortality_rate_per_1_000_live_births" DOUBLE,
  "maternal_mortality_rate_per_100_000_live_births" DOUBLE,
  "agricultural_output_in_usd" VARCHAR,
  "active_military_personnel" DOUBLE,
  "reserve_military_personnel" DOUBLE,
  "literacy_rate" DOUBLE,
  "it_output_in_usd" VARCHAR,
  "number_of_tanks" DOUBLE,
  "number_of_submarines" DOUBLE,
  "number_of_armoured_vehicles" DOUBLE
);