zensus2pgsql

German census data, now in PostgreSQL!

A CLI program that imports German census CSV data (spelled "zensus" in German) into PostgreSQL with PostGIS geographic data types. All data is provided by the Statitisches Bundesamt of Germany. Currently, only data from the 2022 census is available.

If you want to download the raw data yourself or see the website it comes from, check out the link below:

Zensus 2022 Publikationen

Installing

To install this program, run:

pip install zensus2pgsql

Using

To get started using this tool, you'll first want to see what datasets are availble:

zensus2pgsql list

For now, the names of the data sets are only available in German, so please use translation software if you need help figuring out what they mean!

After you've fond a dataset to import, you can do so by running the following command:

zensus2pgsql create \
  --host localhost \
  --port 5432 \
  --user username \
  --schema public \
  heizungsart eigentuemerquote

The above command will import two dataset related to the type of heating a house uses and the percentage of those who own their home in a particular area.

Contributing

Contributions are welcome and can ake the following forms:

Creating a bug report if you've found an issue
Creating a feature request if you'd like to see new functionality added
Creating a pull request to accomplish either of the two above
Leaving a star on the repository

Before creating a pull request, I kindly ask that you either create a bug report or a feature request first, so I can sign off on having it added to the project.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

zensus2pgsql-0.1.2.tar.gz (503.1 kB view details)

Uploaded Nov 25, 2025 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

zensus2pgsql-0.1.2-py3-none-any.whl (28.7 kB view details)

Uploaded Nov 25, 2025 Python 3

File details

Details for the file zensus2pgsql-0.1.2.tar.gz.

File metadata

Download URL: zensus2pgsql-0.1.2.tar.gz
Upload date: Nov 25, 2025
Size: 503.1 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for zensus2pgsql-0.1.2.tar.gz
Algorithm	Hash digest
SHA256	`d0b2acc18114bc3b627d19ed353e8103091c23fd87794fcb7bf6515c022ca7f1`
MD5	`ca76992bb447a0c3da505266979e578e`
BLAKE2b-256	`9e954ef54fb7acb701aa84f9bb834c9f8e4458d7b29fad5e315be6e14cc50527`

See more details on using hashes here.

Provenance

The following attestation bundles were made for zensus2pgsql-0.1.2.tar.gz:

Publisher: publish.yml on travishathaway/zensus2pgsql

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: zensus2pgsql-0.1.2.tar.gz
- Subject digest: d0b2acc18114bc3b627d19ed353e8103091c23fd87794fcb7bf6515c022ca7f1
- Sigstore transparency entry: 725186374
- Sigstore integration time: Nov 25, 2025
Source repository:
- Permalink: travishathaway/zensus2pgsql@b9cd347dd721463a10b38e89c67777e6c807a853
- Branch / Tag: refs/tags/0.1.2
- Owner: https://github.com/travishathaway
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish.yml@b9cd347dd721463a10b38e89c67777e6c807a853
- Trigger Event: release