Skip to content

open-numbers/ddf--unfao--aquastat

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
etl
etl
 
 
.gitattributes
.gitattributes
 
 
.gitignore
.gitignore
 
 
README.md
README.md
 
 
datapackage.json
datapackage.json
 
 
ddf--concepts--continuous.csv
ddf--concepts--continuous.csv
 
 
ddf--concepts--discrete.csv
ddf--concepts--discrete.csv
 
 
ddf--datapoints--agricultural_water_withdrawal_as_pct_of_total_renewable_water_resources--by--area--year.csv
ddf--datapoints--agricultural_water_withdrawal_as_pct_of_total_renewable_water_resources--by--area--year.csv
 
 
ddf--datapoints--agricultural_water_withdrawal_as_pct_of_total_water_withdrawal--by--area--year.csv
ddf--datapoints--agricultural_water_withdrawal_as_pct_of_total_water_withdrawal--by--area--year.csv
 
 
ddf--datapoints--agriculture_value_added_pct_gdp--by--area--year.csv
ddf--datapoints--agriculture_value_added_pct_gdp--by--area--year.csv
 
 
ddf--datapoints--agriculture_value_added_to_gdp--by--area--year.csv
ddf--datapoints--agriculture_value_added_to_gdp--by--area--year.csv
 
 
ddf--datapoints--arable_land_area--by--area--year.csv
ddf--datapoints--arable_land_area--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_full_control_irrigation_actually_irrigated--by--area--year.csv
ddf--datapoints--area_equipped_for_full_control_irrigation_actually_irrigated--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_full_control_irrigation_localized_irrigation--by--area--year.csv
ddf--datapoints--area_equipped_for_full_control_irrigation_localized_irrigation--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_full_control_irrigation_sprinkler_irrigation--by--area--year.csv
ddf--datapoints--area_equipped_for_full_control_irrigation_sprinkler_irrigation--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_desalinated_water--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_desalinated_water--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_agricultural_drainage_water--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_agricultural_drainage_water--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_non_treated_municipal_wastewater--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_non_treated_municipal_wastewater--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_not_treated_municipal_wastewater--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_not_treated_municipal_wastewater--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_treated_municipal_wastewater--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_direct_use_of_treated_municipal_wastewater--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_groundwater--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_groundwater--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_mixed_surface_water_and_groundwater--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_mixed_surface_water_and_groundwater--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_by_surface_water--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_by_surface_water--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_irrigation_drained--by--area--year.csv
ddf--datapoints--area_equipped_for_irrigation_drained--by--area--year.csv
 
 
ddf--datapoints--area_equipped_for_power_irrigation_surface_water_or_groundwater--by--area--year.csv
ddf--datapoints--area_equipped_for_power_irrigation_surface_water_or_groundwater--by--area--year.csv
 
 
ddf--datapoints--area_salinized_by_irrigation--by--area--year.csv
ddf--datapoints--area_salinized_by_irrigation--by--area--year.csv
 
 
ddf--datapoints--area_waterlogged_by_irrigation--by--area--year.csv
ddf--datapoints--area_waterlogged_by_irrigation--by--area--year.csv
 
 
ddf--datapoints--capacity_of_the_municipal_wastewater_treatment_facilities--by--area--year.csv
ddf--datapoints--capacity_of_the_municipal_wastewater_treatment_facilities--by--area--year.csv
 
 
ddf--datapoints--collected_municipal_wastewater--by--area--year.csv
ddf--datapoints--collected_municipal_wastewater--by--area--year.csv
 
 
ddf--datapoints--cultivated_area_arable_land_permanent_crops--by--area--year.csv
ddf--datapoints--cultivated_area_arable_land_permanent_crops--by--area--year.csv
 
 
ddf--datapoints--dam_capacity_per_capita--by--area--year.csv
ddf--datapoints--dam_capacity_per_capita--by--area--year.csv
 
 
ddf--datapoints--dependency_ratio--by--area--year.csv
ddf--datapoints--dependency_ratio--by--area--year.csv
 
 
ddf--datapoints--direct_use_of_agricultural_drainage_water--by--area--year.csv
ddf--datapoints--direct_use_of_agricultural_drainage_water--by--area--year.csv
 
 
ddf--datapoints--direct_use_of_not_treated_municipal_wastewater_for_irrigation_purposes--by--area--year.csv
ddf--datapoints--direct_use_of_not_treated_municipal_wastewater_for_irrigation_purposes--by--area--year.csv
 
 
ddf--datapoints--direct_use_of_treated_municipal_wastewater--by--area--year.csv
ddf--datapoints--direct_use_of_treated_municipal_wastewater--by--area--year.csv
 
 
ddf--datapoints--direct_use_of_treated_municipal_wastewater_for_irrigation_purposes--by--area--year.csv
ddf--datapoints--direct_use_of_treated_municipal_wastewater_for_irrigation_purposes--by--area--year.csv
 
 
ddf--datapoints--environmental_flow_requirements--by--area--year.csv
ddf--datapoints--environmental_flow_requirements--by--area--year.csv
 
 
ddf--datapoints--exploitable_irregular_renewable_surface_water--by--area--year.csv
ddf--datapoints--exploitable_irregular_renewable_surface_water--by--area--year.csv
 
 
ddf--datapoints--exploitable_regular_renewable_groundwater--by--area--year.csv
ddf--datapoints--exploitable_regular_renewable_groundwater--by--area--year.csv
 
 
ddf--datapoints--exploitable_regular_renewable_surface_water--by--area--year.csv
ddf--datapoints--exploitable_regular_renewable_surface_water--by--area--year.csv
 
 
ddf--datapoints--exploitable_total_renewable_surface_water--by--area--year.csv
ddf--datapoints--exploitable_total_renewable_surface_water--by--area--year.csv
 
 
ddf--datapoints--flood_occurrence_wri--by--area--year.csv
ddf--datapoints--flood_occurrence_wri--by--area--year.csv
 
 
ddf--datapoints--fresh_groundwater_withdrawal--by--area--year.csv
ddf--datapoints--fresh_groundwater_withdrawal--by--area--year.csv
 
 
ddf--datapoints--gdp_deflator_2015--by--area--year.csv
ddf--datapoints--gdp_deflator_2015--by--area--year.csv
 
 
ddf--datapoints--gdp_per_capita--by--area--year.csv
ddf--datapoints--gdp_per_capita--by--area--year.csv
 
 
ddf--datapoints--gender_inequality_index_gii_equality_0_inequality_1--by--area--year.csv
ddf--datapoints--gender_inequality_index_gii_equality_0_inequality_1--by--area--year.csv
 
 
ddf--datapoints--gross_domestic_product_gdp--by--area--year.csv
ddf--datapoints--gross_domestic_product_gdp--by--area--year.csv
 
 
ddf--datapoints--groundwater_accounted_inflow--by--area--year.csv
ddf--datapoints--groundwater_accounted_inflow--by--area--year.csv
 
 
ddf--datapoints--groundwater_accounted_outflow_to_other_countries--by--area--year.csv
ddf--datapoints--groundwater_accounted_outflow_to_other_countries--by--area--year.csv
 
 
ddf--datapoints--groundwater_entering_the_country_total--by--area--year.csv
ddf--datapoints--groundwater_entering_the_country_total--by--area--year.csv
 
 
ddf--datapoints--groundwater_leaving_the_country_to_other_countries_total--by--area--year.csv
ddf--datapoints--groundwater_leaving_the_country_to_other_countries_total--by--area--year.csv
 
 
ddf--datapoints--groundwater_produced_internally--by--area--year.csv
ddf--datapoints--groundwater_produced_internally--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_bananas--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_bananas--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_citrus--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_citrus--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_cocoa_beans--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_cocoa_beans--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_coconuts--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_coconuts--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_coffee--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_coffee--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_grapes--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_grapes--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_grass_and_fodder--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_grass_and_fodder--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_oil_palm--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_oil_palm--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_olives--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_olives--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_other_crops--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_other_crops--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_other_fruits--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_other_fruits--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_plantains--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_plantains--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_rubber--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_rubber--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_tea--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_tea--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_permanent_crop_area_total--by--area--year.csv
ddf--datapoints--harvested_irrigated_permanent_crop_area_total--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_barley--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_barley--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_cassava--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_cassava--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_cotton--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_cotton--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_flowers--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_flowers--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_fodder--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_fodder--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_groundnuts--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_groundnuts--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_leguminous_crops--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_leguminous_crops--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_maize--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_maize--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_millet--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_millet--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_cereals--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_cereals--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_crops--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_crops--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_roots_and_tubers--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_other_roots_and_tubers--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_potatoes--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_potatoes--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_rice--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_rice--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sesame--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sesame--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sorghum--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sorghum--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_soybeans--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_soybeans--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sugar_beet--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sugar_beet--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sugarcane--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sugarcane--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sunflower--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sunflower--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_sweet_potatoes--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_sweet_potatoes--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_tobacco--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_tobacco--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_total--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_total--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_vegetables--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_vegetables--by--area--year.csv
 
 
ddf--datapoints--harvested_irrigated_temporary_crop_area_wheat--by--area--year.csv
ddf--datapoints--harvested_irrigated_temporary_crop_area_wheat--by--area--year.csv
 
 
ddf--datapoints--human_development_index_hdi_highest_1--by--area--year.csv
ddf--datapoints--human_development_index_hdi_highest_1--by--area--year.csv
 
 
ddf--datapoints--industrial_water_withdrawal_as_pct_of_total_water_withdrawal--by--area--year.csv
ddf--datapoints--industrial_water_withdrawal_as_pct_of_total_water_withdrawal--by--area--year.csv
 
 
ddf--datapoints--industry_value_added_to_gdp--by--area--year.csv
ddf--datapoints--industry_value_added_to_gdp--by--area--year.csv
 
 
ddf--datapoints--interannual_variability_wri--by--area--year.csv
ddf--datapoints--interannual_variability_wri--by--area--year.csv
 
 
ddf--datapoints--irrigated_cropping_intensity--by--area--year.csv
ddf--datapoints--irrigated_cropping_intensity--by--area--year.csv
 
 
ddf--datapoints--irrigation_potential--by--area--year.csv
ddf--datapoints--irrigation_potential--by--area--year.csv
 
 
ddf--datapoints--irrigation_water_requirement--by--area--year.csv
ddf--datapoints--irrigation_water_requirement--by--area--year.csv
 
 
ddf--datapoints--long_term_average_annual_precipitation_in_depth--by--area--year.csv
ddf--datapoints--long_term_average_annual_precipitation_in_depth--by--area--year.csv
 
 

Repository files navigation

Aquastat dataset from FAO

source: http://www.fao.org/nr/water/aquastat/data/query/index.html?lang=en

download source data

because there is no bulk download available for this dataset, so we need to download the source using the query interface from fao.

  1. select a group of variables. (selecting all group won't will result in a error because there are too much data to display)
  2. select all country
  3. select all period
  4. select 'None' in metadata
  5. click Submit
  6. download flat CSV in the result page.

Issue

There are some measures that share same name/description but different varialbe Id in the dataset. Issue #1

About

No description, website, or topics provided.

Resources

Readme
Activity
Custom properties

Stars

1 star

Watchers

2 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •  

Languages