The Hellas Database aims to gather population and other data from ELSTAT in a clean format, ready to perform data analysis and visualizations.
Click here to see an interactive map of Greece based on this database.
- Legal and real population for 13 500 + locations in Greece based on ELSTAT data.
- Region, decentralized administration, nomos (province), dimos (municipality) and minicipal unit of each location.
- Coordinates for ~ 97,5 % of locations.
- Terrain information: urban/rural, plains/mountains.
- Administrative information during the application of the Kapodistrias plan (1998 - 2010).
- Other information: capital seats, islands, etc.
final_databases/hellas_db.csv: final database.final_databases/hellas_db.xlsx: final database as an Excel spreadsheet.
- Downloading ELSTAT census for 1991, 2001 and 2011 years, as well as other documents for coordinates and terrain data.
- Adding coordinates (
lat,long) and altitude (h) for most location through several complex functions. - Incorporating terrain information (
astikotita,orinotita). - Postprocessing to obtain information abour capital seats and other relevant data for analysis.
- Generating an interactive dashboard in Tableau.
- Convert location names in Katharevousa Greek to Dimotiki Greek.
- Find coordinates for the last remaing 300 units without data.
- Separate the capital columns (
edres_) to form a new table. - Generate a version using Latin characters instead of Greek letters to improve accesibility for non-Greek-speaking users.
In this project the following libraries were used:
