Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add other SQLite DBs to data dictionary #4

Open
1 task
jdangerx opened this issue Jan 13, 2025 · 2 comments
Open
1 task

Add other SQLite DBs to data dictionary #4

jdangerx opened this issue Jan 13, 2025 · 2 comments

Comments

@jdangerx
Copy link
Member

Overview

The raw FERC SQLite tables appear to be pretty popular, based on Zenodo downloads.

We should try to add those to the data dictionary also.

Success Criteria

How will we know that we're done?

  • all ferc_... DBs available in data dictionary.

Next steps

Preview Give feedback
@zaneselvans
Copy link
Member

There's also the Census DP1 SQLite DB.

DuckDB is certainly happy to query SQLite, though IIRC you need to install the SQLite plugin.

@jdangerx
Copy link
Member Author

Yeah, I'm slightly nervous that we'll run into some wackiness with duckdb-wasm vs. just normal duckdb for the plugin. But it'll probably be fine 🤞

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: New
Development

No branches or pull requests

2 participants