Aquastat data

From Pardee Wiki
Jump to navigation Jump to search
Table1
Variable Table Group Definition Extended Source Defn Units Years Source Original Source Notes Last IFs Update Aggregation Disaggregation TreatNullsAs0s Proprietary Name in Source UsedInPreprocessor CompareOtherForecast Code in Source Country Concordance
DesalinatedWater SeriesDesalinatedWater Environment, Infrastructure, Water Desalinated Water Produced No Extended Source 10^9 m3/year 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQUASTAT No Original Source EWF 1/20/2011 SUM GDP No No No Name in Source FALSE No Desalinated water produced (10^9 m3/yr)
LandCultivatedArea SeriesLandCultivatedArea Economic, Infrastructure Cultivated area (1000 ha) No Extended Source 1000 ha 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Cultivated area (1000 ha) FALSE No Cultivated area (1000 ha) FAO Countries
LandIr%Grain SeriesLandIr%Grain Agriculture, Infrastructure % of total grain production irrigated (%) No Extended Source Percentage 1984, 1988-1995 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 AVG GDP No No % of total grain production irrigated (%) FALSE No % of total grain production irrigated (%) FAO Countries
LandIrActual%Equip SeriesLandIrActual%Equip Agriculture, Infrastructure Area equipped for irrigation: actually irrigated, %
Percentage 1962, 1967, 1972, 1975, 1977, 1980-1982, 1985, 1987-2012 AQU 2013 BATCH PULL
EWF 7/18/2013 AVG GDP No No % of area equipped for irrigation actually irrigated (%) FALSE No % of the area equipped for irrigation actually irrigated (%) FAO Countries
LandIrAreaEquip SeriesLandIrAreaEquip Agriculture, Infrastructure Area equipped for irrigation: total (1000 ha) No Extended Source 1000 ha 1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Area equipped for irrigation: total (1000 ha) FALSE No Area equipped for irrigation: total (1000 ha) FAO Countries
LandIrAreaSalinized SeriesLandIrAreaSalinized Agriculture, Infrastructure Area salinized by irrigation (1000 ha) No Extended Source 1000 ha 1972, 1987-1995, 1997-2006, 2009-2010 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Area salinized by irrigation (1000 ha) FALSE No Area salinized by irrigation (1000 ha) FAO Countries
LandIrEquip%Cultivated SeriesLandIrEquip%Cultivated Agriculture, Infrastructure % of cultivated area equipped for irrigation (%) No Extended Source Percentage 1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 AVG GDP No No % of cultivated area equipped for irrigation (%) FALSE No % of the cultivated area equipped for irrigation (%) FAO Countries
LandIrEquip%Potential SeriesLandIrEquip%Potential Agriculture, Infrastructure % of irrigation potential equipped for irrigation (%) No Extended Source Percentage 1962, 1967, 1970, 1972, 1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 AVG GDP No No % of irrigation potential equipped for irrigation (%) FALSE No % of irrigation potential equipped for irrigation (%) FAO Countries
LandIrEquip%WaterManaged SeriesLandIrEquip%WaterManaged Agriculture, Infrastructure, Water % of agricultural water managed area equipped for irrigation (%)
Percentage 1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL
EWF 7/18/2013 AVG GDP No No % of agricultural water managed area equipped for irrigation (%) FALSE No % of agricultural water managed area equipped for irrigation (%) FAO Countries
LandIrEquipActual SeriesLandIrEquipActual Agriculture, Infrastructure Area equipped for irrigation: actually irrigated (1000 ha)
1000 ha 1962, 1967, 1972, 1975, 1977, 1980, 1982-1983, 1985-2011 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Area equipped for irrigation: actually irrigated (1000 ha) FALSE No Area equipped for irrigation: actually irrigated (1000 ha) FAO Countries
LandIrEquipDrained SeriesLandIrEquipDrained Agriculture, Infrastructure Area equipped for irrigation drained (1000 ha)
1000 ha 1985, 1987, 1990-2006, 2008-2010 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Area equipped for irrigation drained (1000 ha) FALSE No Area equipped for irrigation drained (1000 ha) FAO Countries
LandIrHarvest%Equip SeriesLandIrHarvest%Equip Economic, Infrastructure Harvested irrigated crop area as % of area equipped for full control irrigation (%) No Extended Source Percentage 1984, 1987, 1989-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 AVG GDP No No Harvested irrigated crop area as % of area equipped for full control irrigation (%) FALSE No Harvested irrigated crop area as % of area equipped for full control irrigation (%) FAO Countries
LandIrHarvest%FullControl SeriesLandIrHarvest%FullControl Economic, Infrastructure Harvested irrigated crop area as % of full control irrigation area actually irrigated (%) No Extended Source Percentage 1962, 1967, 1972, 1977, 1982, 1987, 1989-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 AVG GDP No No Harvested irrigated crop area as % of full control irrigation area actually irrigated (%) FALSE No Harvested irrigated crop area as % of full control irrigation area actually irrigated (%) FAO Countries
LandIrHarvestedCropArea SeriesLandIrHarvestedCropArea Agriculture, Infrastructure Total harvested irrigated crop area (1000 ha) No Extended Source 1000 ha 1961, 1966, 1971-1972, 1975-1977, 1980-1982, 1984-1985, 1987-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Total harvested irrigated crop area (1000 ha) FALSE No Total harvested irrigated crop area (full control irrigation) (1000 ha) FAO Countries
LandIrPotential SeriesLandIrPotential Agriculture, Infrastructure Irrigation potential (1000 ha)
1000 ha 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2005, 2007-2008, 2011 AQU 2013 BATCH PULL No Original Source EWF; AS 7/18/2013 SUM GDP No No Irrigation potential (1000 ha) water No Irrigation potential (1000 ha) FAO Countries
LandIrPotentialReached SeriesLandIrPotentialReached Agriculture, Infrastructure Irrigation potential (1000 ha) for countries that reached the potential already
1000 ha 2009 AQUASTAT, at http://www.fao.org/nr/water/aquastat/dbase/index.stm
DSR; looked at FAO/Aquastat data to find countries with no growth/decline in the recent period 11/16/2011 SUM GDP No No Irrigation potential (1000 ha) water No Irrigation potential (1000 ha) for countries that reached the potential already
LandIrWaterLogged SeriesLandIrWaterLogged Agriculture, Infrastructure Area waterlogged by irrigation (1000 ha) No Extended Source 1000 ha 1990-1993, 1995, 1997-2000, 2002-2007 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Area waterlogged by irrigation (1000 ha) FALSE No Area waterlogged not irrigated (1000 ha) FAO Countries
TotalDamCapacity SeriesTotalDamCapacity Economic, Infrastructure Total dam capacity (km3) No Extended Source km3 1960, 1965, 1970, 1975, 1977, 1980, 1984-1985, 1989-1998, 2000-2008, 2010 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Total dam capacity (km3) FALSE No Total dam capacity (km3) FAO Countries
WasterwaterTreated SeriesWasterwaterTreated Economic, Infrastructure Wastewater: treated volume (10^9 m3/yr) No Extended Source 10^9 m3/yr 1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Wastewater: treated volume (10^9 m3/yr) FALSE No Treated municipal wastewater (10^9 m3/yr) FAO Countries
WastewaterProduced SeriesWastewaterProduced Economic, Infrastructure Wastewater: produced volume (10^9 m3/yr) No Extended Source 10^9 m3/yr 1965, 1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Wastewater: produced volume (10^9 m3/yr) FALSE No Produced municipal wastewater (10^9 m3/yr) FAO Countries
WastewaterTreatedReused SeriesWastewaterTreatedReused Economic, Infrastructure Treated wastewater reused (10^9 m3/yr) No Extended Source 10^9 m3/yr 1962, 1967, 1971-1972, 1975, 1977, 1982, 1985, 1987, 1989-1998, 2000-2012 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No Treated wastewater reused (10^9 m3/yr) FALSE No Direct use of treated municipal wastewater (10^9 m3/yr) FAO Countries
WaterDependencyRatio SeriesWaterDependencyRatio Agriculture, Infrastructure, Environment, Water Dependency ratio, percentage of total renewable water resources originating outside of the country
Percent 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF; reviewed by JFM 7/18/2013 AVG GDP No No
FALSE No Dependency ratio (%) FAO Countries
WaterDesalinated SeriesWaterDesalinated Environment, Infrastructure, Water Desalinated Water Produced No Extended Source Cubic Km 1988-1997, 1999-2008, 2010 AQUASTAT
EWF; ME 1/20/2011 SUM GDP No No
FALSE No Desalinated water produced (10^9 m3/yr)
WaterGroundEntering SeriesWaterGroundEntering Infrastructure, Water, Health Groundwater entering the country (natural)
Cubic Km Per Year 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No Groundwater Entering Country FALSE No Groundwater: entering the country (actual) (10^9 m3/yr) FAO Countries
WaterGroundLeaving SeriesWaterGroundLeaving Infrastructure, Water, Health Groundwater leaving the country (naturally)
Cubic Km Per Year 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No Groundwater Leaving FALSE No Groundwater: leaving the country (actual) (10^9 m3/yr) FAO Countries
WaterGroundProdInternal SeriesWaterGroundProdInternal Infrastructure, Water, Health Groundwater produced internally (natural)
Cubic Km Per Year 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No Groundwater Produced Internally FALSE No Groundwater produced internally (10^9 m3/yr) FAO Countries
WaterGroundTotal SeriesWaterGroundTotal Infrastructure, Water, Health Groundwater total renewable
Cubic Km Per Year 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No Groundwater Total FALSE No Total renewable groundwater (actual) (10^9 m3/yr) FAO Countries
WaterGroundWithD SeriesWaterGroundWithD Environment, Infrastructure, Water Ground Water Withdrawal No Extended Source 10^9 m3/year 1980, 1985, 1987-1990, 1992-2010 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No No Name in Source FALSE No Fresh groundwater withdrawal (primary and secondary) (10^9 m3/yr) FAO Countries
WaterResExploitGround SeriesWaterResExploitGround Environment, Infrastructure, Water Exploitable: regular renewable groundwater (10^9 m3/yr)
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL
SGH, PJO 2/19/2014 SUM GDP No No
FALSE No Exploitable: regular renewable groundwater (10^9 m3/yr) FAO Countries
WaterResExploitSurface SeriesWaterResExploitSurface Environment, Infrastructure, Water Exploitable: total renewable surface water (10^9 m3/yr)
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL
SGH, PJO 2/23/2014 SUM GDP No No
FALSE No Exploitable: total renewable surface water (10^9 m3/yr) FAO Countries
WaterResOverlap SeriesWaterResOverlap Environment, Infrastructure, Water Overlap between surface and groundwater
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL
SGH, PJO 2/19/2014 SUM GDP No No
FALSE No Overlap between surface water and groundwater (10^9 m3/yr) FAO Countries
WaterResTotalExploit SeriesWaterResTotalExploit Agriculture, Infrastructure, Environment, Water Water resources: total exploitable
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997-1998, 2000-2003, 2005, 2007, 2011 AQU 2013 BATCH PULL
EWF; reviewed by JFM 7/18/2013 SUM GDP No No
FALSE No Total exploitable water resources (10^9 m3/yr) FAO Countries
WaterResTotalRenew SeriesWaterResTotalRenew Agriculture, Infrastructure, Environment, Water Water resources: total renewable (actual)
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992-2007, 2011 AQU 2013 BATCH PULL
EWF; holes filled by Eric in WaterResTotalRenew: use most recent year or data from WaterTotalRenewPC, multiplying by population; Czech Republic, Ethopia, Slovak Republic 7/18/2013 SUM GDP No No
FALSE No Total renewable water resources (actual) (10^9 m3/yr) FAO Countries
WaterResTotalRenewGround SeriesWaterResTotalRenewGround Environment, Infrastructure, Water Total renewable groundwater (actual) (10^9 m3/yr)
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL
SGH, PJO 2/19/2014 SUM GDP No No
FALSE No Total renewable groundwater (actual) (10^9 m3/yr) FAO Countries
WaterResTotalRenewSurface SeriesWaterResTotalRenewSurface Environment, Infrastructure, Water Total renewable suface water (actual)
Cubic Km 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL
SGH, PJO 2/19/2014 SUM GDP No No
FALSE No Total renewable surface water (actual) (10^9 m3/yr) FAO Countries
WaterSurfaceWithD SeriesWaterSurfaceWithD Environment, Infrastructure, Water Surface Water Withdrawal No Extended Source 10^9 m3/year 1980, 1985, 1987-1990, 1992-2010 AQU 2013 BATCH PULL No Original Source EWF 7/18/2013 SUM GDP No No No Name in Source FALSE No Fresh surface water withdrawal (primary and secondary) (10^9 m3/yr) FAO Countries
WaterTotalAgManagedArea SeriesWaterTotalAgManagedArea Agriculture, Infrastructure, Environment, Water Total agricultural water managed area
1000 ha 1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL
EWF; reviewed by JFM 7/18/2013 SUM GDP No No
FALSE No Total agricultural water managed area (1000 ha) FAO Countries
WaterTotalRenewPC SeriesWaterTotalRenewPC Agriculture, Infrastructure, Environment, Water Water resources: total renewable per capita (actual)
Cubic Meter 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL
EWF; holes filled in WaterTotalRenewPC: divide WaterResTotalRenew by population data 7/18/2013 POP GDP No No
FALSE No Total renewable water resources per capita (actual) (m3/inhab/yr) FAO Countries
WaterTotalWithd SeriesWaterTotalWithd Environment, Infrastructure, Water Total water withdrawal (summed by sector)
Cubic Km 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQUASTAT
EWF 1/20/2011 SUM GDP No No
FALSE No Total water withdrawal (10^9 m3/yr)
WaterTotalWithdPC SeriesWaterTotalWithdPC Environment, Infrastructure, Water Total water withdrawal per capita
Cubic Meter 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 POP GDP No No
FALSE No Total water withdrawal per capita (m3/inhab/yr) FAO Countries
WaterTotalWithdSector SeriesWaterTotalWithdSector Agriculture, Infrastructure, Environment, Water Total water withdrawal (summed by sector)
Cubic Km 1988-1997, 1999-2006 AQUASTAT
EWF; reviewed by JFM 2/20/2010 SUM GDP No No
FALSE No Total water withdrawal (10^9 m3/yr)
WaterTotalWithdSources SeriesWaterTotalWithdSources Agriculture, Infrastructure, Environment, Water Total water withdrawal (summed by sources)
Cubic Km 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL
EWF; ME 7/18/2013 SUM GDP No No
FALSE No Total freshwater withdrawal (primary and secondary) (10^9 m3/yr) FAO Countries
WaterWith%Agric SeriesWaterWith%Agric Agriculture, Infrastructure, Environment, Water Water withdrawals, percent used in agriculture (1990=70-99;2000=update, mostly 2000)
Percent 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 POP GDP No No
FALSE No Agricultural water withdrawal as % of total water withdrawal (%) FAO Countries
WaterWith%Fresh SeriesWaterWith%Fresh Agriculture, Infrastructure, Environment, Water % of total actual renewable freshwater resources withdrawn (%)
Percent 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1987, 1990-1997, 1999-2010 AQU 2013 BATCH PULL
EWF; reviewed by JFM 7/18/2013 POP GDP No No
FALSE No Freshwater withdrawal as % of total actual renewable water resources (%) FAO Countries
WaterWith%Household SeriesWaterWith%Household Environment, Infrastructure, Water Water withdrawals, percent used by households (1990=70-99;2000=update, mostly 2000)
Percent 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 POP GDP No No
FALSE No Municipal water withdrawal as % of total withdrawal (%) FAO Countries
WaterWith%Ind SeriesWaterWith%Ind Environment, Infrastructure, Water Water withdrawals, percent used in industry (1990=70-99;2000=update, mostly 2000)
Percent 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 POP GDP No No
FALSE No Industrial water withdrawal as % of total water withdrawal (%) FAO Countries
WaterWithAgr%FreshAquastat SeriesWaterWithAgr%FreshAquastat Agriculture, Infrastructure, Environment, Water % of total actual renewable water resources withdrawn by agriculture (%)
Percent 1988-2011 AQU 2013 BATCH PULL
EWF; reviewed by JFM 7/18/2013 POP GDP No No
FALSE No Agricultural water withdrawal as % of total actual renewable water resources (%) FAO Countries
WaterWithdAgriculture SeriesWaterWithdAgriculture Agriculture, Infrastructure, Environment, Water Agricultural water withdrawal
Cubic Km 1965, 1969-1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No
FALSE No Agricultural water withdrawal (10^9 m3/yr) FAO Countries
WaterWithdIndustrial SeriesWaterWithdIndustrial Environment, Infrastructure, Water Industrial water withdrawal
Cubic Km 1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No
FALSE No Industrial water withdrawal (10^9 m3/yr) FAO Countries
WaterWithdMunicipal SeriesWaterWithdMunicipal Environment, Infrastructure, Water Municipal water withdrawal
Cubic Km 1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL
EWF 7/18/2013 SUM GDP No No
FALSE No Municipal water withdrawal (10^9 m3/yr) FAO Countries


File:TestExcel.xlsx