ipeds-database
Build a harmonized DuckDB database from 20+ years of IPEDS higher education data
File Explorer
- ba_degrees.png
- degree_plots.R
- econ_masters.png
- econ_masters_plot.R
- mba_degrees.png
- mba_expanded.png
- mba_expanded_plot.R
- mba_stacked.png
- mba_stacked_plot.R
- phd_degrees.png
- README.md
- residence_count.png
- residence_pct.png
- residence_plot.R
- query_examples.sql
- .gitignore
- .python-version
- add_datapond_metadata.py
- build_database.py
- DICTIONARY.md
- LICENSE
- pyproject.toml
- README.md
- uv.lock
# Use via CDN
jsDelivrjsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.
Command Glossary
Commands referenced in this DOCs, explained below.
duckdb
View Details ▼
duckdb
Client for DuckDB, an in-process analytical SQL engine.
duckdb
Start an interactive shell with a transient in-memory database:
duckdb {{path/to/dbfile}}
Start an interactive shell on a database file. If the file does not exist, a new database is created:
duckdb -c "{{SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'}}"
Query a CSV, JSON, or Parquet file using SQL:
git clone
View Details ▼
git clone
Clone an existing repository.
git clone {{remote_repository_location}} {{path/to/directory}}
Clone an existing repository into a new directory (the default directory is the repository name):
git clone --recursive {{remote_repository_location}}
Clone an existing repository and its submodules:
git clone {{[-n|--no-checkout]}} {{remote_repository_location}}
Clone only the `.git` directory of an existing repository:
pip install
View Details ▼
pip install
Install Python packages.
pip install {{package1 package2 ...}}
Install one or more packages:
pip install {{package1 package2 ...}} {{[-U|--upgrade]}}
Upgrade all specified packages to the latest version, installing any that are not already present:
pip install {{package}}=={{version}}
Install a specific version of a package:
uv run
View Details ▼
uv run
Run a command or script in the project environment.
uv run {{path/to/script.py}}
Run a Python script:
uv run {{[-m|--module]}} {{module_name}}
Run a Python module:
uv run {{[-w|--with]}} {{package}} {{command}}
Run a command with additional packages installed temporarily:
uv sync
View Details ▼
uv sync
Update the project's environment to match the lockfile.
uv sync
Sync the project environment with the lockfile:
uv sync --all-extras
Sync and include all optional dependencies:
uv sync --extra {{extra_name}}
Sync with specific optional dependencies: