How modelearth/community-zipcodes works
This repository publishes ZIP-code economic data by NAICS industry and year. The documented workflow fetches Census data, populates DuckDB tables, and exports state-organized CSVs for users. The active modules cover population, database management, and export/query behavior; the README supplies the broader workflow where source excerpts are incomplete. Deprecated equivalents are shown separately because they are substantial indexed modules, not as part of the active path. Some implementation details and wiring are unsampled, so undocumented links are omitted.
Main entry points: populator/db_zip_populator.py ZIP populator · populator/db_zip_populator.py Legacy ZIP fetch · duck_db_exporter.py CSV exporter · database_populator.py Dimension population
Components 15
Data ingestion
- ZIP populator
industries/naics/duck_zipcode_db/populator/db_zip_populator.py - Dimension population
industries/naics/duck_zipcode_db/populator/database_populator.py
DuckDB storage
- DuckDB manager
industries/naics/duck_zipcode_db/zip_data/duck_db_manager/duckdb_manager.py
CSV access
- CSV exporter
industries/naics/duck_zipcode_db/exporter/duck_db_exporter.py - ZIP query
industries/naics/duck_zipcode_db/exporter/query.py - Published CSVs
industries/naics/US/zip
Deprecated pipeline
- Legacy ZIP fetch
deprecated/populator/db_zip_populator.py - Legacy dimensions
deprecated/populator/database_populator.py - Legacy DB manager
deprecated/zip_data/duck_db_manager/duckdb_manager.py - Legacy exporter
deprecated/zip_data/duck_db_manager/dataexporter.py - Legacy query
deprecated/zip_data/duck_db_manager/query.py - Legacy table exports
deprecated/zip_data/duck_db_manager/database/exported_tables
Other components
- Data developer
- Census API
- Data users
Connections 14
- Data developer → ZIP populator: runs ingestion
README.md - ZIP populator → Dimension population: initializes dimensions
industries/naics/duck_zipcode_db/populator/db_zip_populator.py - ZIP populator → Census API: requests ZIP data
industries/naics/duck_zipcode_db/populator/db_zip_populator.py - Dimension population → Census API: requests geography
industries/naics/duck_zipcode_db/populator/database_populator.py - ZIP populator → DuckDB manager: writes entries
- DuckDB manager → CSV exporter: provides stored data
- CSV exporter → ZIP query: filters rows
industries/naics/duck_zipcode_db/exporter/duck_db_exporter.py - CSV exporter → Published CSVs: writes CSVs
README.md - Data users → Published CSVs: accesses data
README.md - Legacy ZIP fetch → Legacy dimensions: initializes dimensions
deprecated/populator/db_zip_populator.py - Legacy ZIP fetch → Census API: requests ZIP data
deprecated/populator/db_zip_populator.py - Legacy ZIP fetch → Legacy DB manager: writes entries
- Legacy DB manager → Legacy table exports: exports tables
deprecated/zip_data/duck_db_manager/duckdb_manager.py - Legacy exporter → Legacy query: filters rows
deprecated/zip_data/duck_db_manager/dataexporter.py