Biodiversity Habitat Loss (Williams Et Al. 2021)

@owid.habitat_loss

Table List

1 table(85.86 KB)

Biodiversity Habitat Loss (Williams Et Al. 2021)

@owid.habitat_loss.owid_habitat_loss

85.86 KB
256 rows
55 columns

country Country	year Year	all_species_number All Species Number	amphibian_species_number Amphibian Species Number	bau_change_cropland_km2 Bau Change Cropland Km2	bau_change_pct Bau Change Pct	bau_habitat_loss_all Bau Habitat Loss All	bau_habitat_loss_amphibians Bau Habitat Loss Amphibians	bau_habitat_loss_birds Bau Habitat Loss Birds	bau_habitat_loss_mammals Bau Habitat Loss Mammals	bird_species_number Bird Species Number	combined_change_cropland_km2 Combined Change Cropland Km2	combined_change_pct Combined Change Pct	combined_habitat_loss_all Combined Habitat Loss All	combined_habitat_loss_amphibians Combined Habitat Loss Amphibians	combined_habitat_loss_birds Combined Habitat Loss Birds	combined_habitat_loss_mammals Combined Habitat Loss Mammals	countries_losing_25_species Countries Losing 25 Species	diets_change_cropland_km2 Diets Change Cropland Km2	diets_change_pct Diets Change Pct	diets_habitat_loss_all Diets Habitat Loss All	diets_habitat_loss_amphibians Diets Habitat Loss Amphibians	diets_habitat_loss_birds Diets Habitat Loss Birds	diets_habitat_loss_mammals Diets Habitat Loss Mammals	mammal_species_number Mammal Species Number	trade_change_cropland_km2 Trade Change Cropland Km2	trade_change_pct Trade Change Pct	trade_habitat_loss_all Trade Habitat Loss All	trade_habitat_loss_amphibians Trade Habitat Loss Amphibians	trade_habitat_loss_birds Trade Habitat Loss Birds	trade_habitat_loss_mammals Trade Habitat Loss Mammals	waste_change_cropland_km2 Waste Change Cropland Km2	waste_change_pct Waste Change Pct	waste_habitat_loss_all Waste Habitat Loss All	waste_habitat_loss_amphibians Waste Habitat Loss Amphibians	waste_habitat_loss_birds Waste Habitat Loss Birds	waste_habitat_loss_mammals Waste Habitat Loss Mammals	yields_change_cropland_km2 Yields Change Cropland Km2	yields_change_pct Yields Change Pct	yields_habitat_loss_all Yields Habitat Loss All	yields_habitat_loss_amphibians Yields Habitat Loss Amphibians	yields_habitat_loss_birds Yields Habitat Loss Birds	yields_habitat_loss_mammals Yields Habitat Loss Mammals
Afghanistan	2050	639	3	6993.2705078125	21.15581512451172	-2.412324905395508	-14.720062255859375	-2.374009847640991	-2.275925636291504	508	-9233.349609375	-27.932430267333984	4.419147968292236	-3.902022123336792	4.1775803565979	5.572896480560303		25886.025390625	78.30956268310547	0.8854154944419861	-20.977964401245117	0.8467177748680115	1.551419973373413	128	10267.548828125	31.06105613708496	-2.694797992706299	-17.45269203186035	-2.5394043922424316	-2.965627908706665	177.25022888183594	0.5362116694450378	-0.18149033188819885	-4.701783657073975	-0.3825729489326477	0.7225006818771362	-18645.7734375	-56.406593322753906	2.062427520751953	7.907567024230957	1.7611769437789917	3.1210196018218994
Albania	2050	408	10	-196.31324768066406	-7.274684906005859	-0.48157253861427307	2.0227859020233154	-1.4257996082305908	3.0141849517822266	319	-555.5570068359375	-20.587005615234375	6.461404800415039	11.849678993225098	4.864223957061768	12.228720664978027		-217.55982971191406	-8.06200885772705	2.9877688884735107	7.250382423400879	1.4840967655181885	8.519987106323242	79	8.263640403747559	0.30622172355651855	-1.245279312133789	-1.1717051267623901	-1.7326481342315674	0.713390052318573	-684.5763549804688	-25.368013381958008	2.1520884037017822	8.646808624267578	0.6168120503425598	7.529378890991211	-196.31231689453125	-7.274650573730469	2.907480239868164	3.843231678009033	2.006732702255249	6.42622709274292
Algeria	2050	495	8	5436.11767578125	14.016950607299805	-3.1466057300567627	-7.792255401611328	-2.489779472351074	-5.316871166229248	387	-9232.353515625	-23.80548858642578	3.7467923164367676	8.306267738342285	3.7300808429718018	3.4467077255249023		10130.515625	26.12138557434082	-0.5947828888893127	-5.315409183502197	0.059344224631786346	-2.7486047744750977	100	9051.2607421875	23.338544845581055	-3.330519437789917	-11.066354751586914	-2.6266000270843506	-5.435820579528809	-2220.608154296875	-5.725805759429932	-1.0270529985427856	-1.541933298110962	-0.6028041839599609	-2.6277055740356445	-14848.3408203125	-38.286231994628906	1.424361228942871	8.581475257873535	1.2524468898773193	1.5171009302139282
American Samoa	2050	71				-2.2606520652770996		-2.3512163162231445	-0.7436985969543457	67			-0.6478343605995178		-0.7011913061141968	0.24589453637599945				-1.3547313213348389		-1.435986042022705	0.00628591887652874	4			-2.2181875705718994		-2.306246519088745	-0.743199348449707			-1.7391438484191895		-1.815820574760437	-0.4548080563545227			-1.6107734441757202		-1.6888244152069092	-0.3034188747406006
Andorra	2050	184	3			0.5156802535057068	1.6567444801330566	-0.04283434897661209	1.9503891468048096	132			6.405496597290039	7.128526210784912	4.357633590698242	11.877921104431152				3.77595853805542	5.394216537475586	2.183133125305176	7.967757701873779	49			-0.5681989192962646	-0.45182526111602783	-0.5775267481803894	-0.5501956939697266			2.9798665046691895	4.996820449829102	1.5637086629867554	6.671335697174072			2.8128836154937744	2.2155144214630127	1.9601624011993408	5.146583080291748
Angola	2050	1309	80	12444.16796875	37.54046630859375	-9.32153034210205	-6.943393707275391	-8.294374465942383	-13.538506507873535	952	-19522.61328125	-58.89409637451172	2.0636379718780518	1.010660171508789	1.931660532951355	2.8213303089141846	152	8013.0908203125	24.17318344116211	-6.216185569763184	-4.090732574462891	-5.549424171447754	-9.121576309204102	277	3325.5986328125	10.03237247467041	-7.158666610717773	-5.092652797698975	-6.4507246017456055	-10.188420295715332	4744.68408203125	14.313343048095703	-7.025995254516602	-4.973905563354492	-6.25505256652832	-10.268250465393066	-14682.3671875	-44.2924690246582	0.7066378593444824	0.7015836238861084	0.5151851773262024	1.366086721420288
Anguilla	2050	159	1			-4.585597991943359		-4.554290294647217	-6.937337398529053	154			3.022830009460449		2.974076271057129	5.6555609703063965				0.4361906349658966		0.39218828082084656	2.2393298149108887	4			-4.742622375488281		-4.704228401184082	-7.40645694732666			-2.1010520458221436		-2.071687698364258	-3.7568469047546387			-2.71850323677063		-2.74749755859375	-2.281850814819336
Antarctica	2050	78				-2.9422833919525146		-2.9422833919525146		78			-0.7475205063819885		-0.7475205063819885					-1.501570224761963		-1.501570224761963					-3.011754274368286		-3.011754274368286				-2.1815690994262695		-2.1815690994262695				-2.1769301891326904		-2.1769301891326904
Antigua and Barbuda	2050	265	3			-4.259600639343262		-4.32985258102417	-3.6264450550079346	254			3.1299855709075928		3.0932202339172363	5.471028804779053				0.6179645657539368		0.5423079133033752	3.2517995834350586	8			-4.46317720413208		-4.522541046142578	-4.25206995010376			-1.902744174003601		-1.9460817575454712	-1.2403054237365723			-2.2849292755126953		-2.365847110748291	-0.5726326704025269
Argentina	2050	1466	111	155065.15625	53.81333541870117	-7.303564548492432	-10.68569564819336	-6.310856342315674	-9.379535675048828	1039	18260.970703125	6.337231159210205	0.34579959511756897	-0.3155112862586975	0.47462135553359985	0.1545327752828598	71	67147.703125	23.302732467651367	-1.8340177536010742	-3.4547600746154785	-1.3441557884216309	-2.8753597736358643	316	155065.15625	53.81333541870117	-7.473068714141846	-10.920196533203125	-6.451006889343262	-9.622724533081055	105416.9140625	36.58356475830078	-5.083919048309326	-7.3974289894104	-4.440762042999268	-6.385945796966553	85972.484375	29.835628509521484	-3.9199917316436768	-5.8824944496154785	-3.387549877166748	-4.981287479400635


CREATE TABLE owid_habitat_loss (
  "country" VARCHAR,
  "year" INTEGER,
  "all_species_number" INTEGER,
  "amphibian_species_number" INTEGER,
  "bau_change_cropland_km2" FLOAT,
  "bau_change_pct" FLOAT,
  "bau_habitat_loss_all" FLOAT,
  "bau_habitat_loss_amphibians" FLOAT,
  "bau_habitat_loss_birds" FLOAT,
  "bau_habitat_loss_mammals" FLOAT,
  "bird_species_number" INTEGER,
  "combined_change_cropland_km2" FLOAT,
  "combined_change_pct" FLOAT,
  "combined_habitat_loss_all" FLOAT,
  "combined_habitat_loss_amphibians" FLOAT,
  "combined_habitat_loss_birds" FLOAT,
  "combined_habitat_loss_mammals" FLOAT,
  "countries_losing_25_species" INTEGER,
  "diets_change_cropland_km2" FLOAT,
  "diets_change_pct" FLOAT,
  "diets_habitat_loss_all" FLOAT,
  "diets_habitat_loss_amphibians" FLOAT,
  "diets_habitat_loss_birds" FLOAT,
  "diets_habitat_loss_mammals" FLOAT,
  "mammal_species_number" INTEGER,
  "species_losing_more_25pct" INTEGER,
  "species_losing_more_25pct_combined" INTEGER,
  "species_losing_more_25pct_yields" INTEGER,
  "species_losing_more_50pct" INTEGER,
  "species_losing_more_50pct_combined" INTEGER,
  "species_losing_more_50pct_yields" INTEGER,
  "species_losing_more_75pct" INTEGER,
  "species_losing_more_75pct_combined" INTEGER,
  "species_losing_more_75pct_yields" INTEGER,
  "species_losing_more_90pct" INTEGER,
  "species_losing_more_90pct_combined" INTEGER,
  "species_losing_more_90pct_yields" INTEGER,
  "trade_change_cropland_km2" FLOAT,
  "trade_change_pct" FLOAT,
  "trade_habitat_loss_all" FLOAT,
  "trade_habitat_loss_amphibians" FLOAT,
  "trade_habitat_loss_birds" FLOAT,
  "trade_habitat_loss_mammals" FLOAT,
  "waste_change_cropland_km2" FLOAT,
  "waste_change_pct" FLOAT,
  "waste_habitat_loss_all" FLOAT,
  "waste_habitat_loss_amphibians" FLOAT,
  "waste_habitat_loss_birds" FLOAT,
  "waste_habitat_loss_mammals" FLOAT,
  "yields_change_cropland_km2" FLOAT,
  "yields_change_pct" FLOAT,
  "yields_habitat_loss_all" FLOAT,
  "yields_habitat_loss_amphibians" FLOAT,
  "yields_habitat_loss_birds" FLOAT,
  "yields_habitat_loss_mammals" FLOAT
);