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

Get EIA861 short form data into db tables #2768

Open
aesharpe opened this issue Aug 3, 2023 · 0 comments
Open

Get EIA861 short form data into db tables #2768

aesharpe opened this issue Aug 3, 2023 · 0 comments
Assignees
Labels
bug Things that are just plain broken. eia861 Anything having to do with EIA Form 861

Comments

@aesharpe
Copy link
Member

aesharpe commented Aug 3, 2023

The EIA861 Form has a short version for entities reporting less than 100K MWh of power. In 2019 the responses to the short form were included/distributed throughout the other tables with a boolean column called short_form. All other years since the inception of the short form (2012) utilize a separate short_form csv. Right now, the short form csv is getting extracted but not included/distributed throughout the other tables meaning that there is only short form data for 2019.

This is largely because the short form data is reported differently. For example, the sales data is not separated by customer class and the DSM / net metering data is just a boolean rather than detailed information.

We should figure out:

  1. Why / how the 2019 data got integrated. Is it possible to replicate with other years??
  2. What to do with the existing short form data - right now it's not even getting published to the database. Maybe we should at least publish it as it's own table?

Also, the EIA861 documentation page could use some sprucing up. See https://docs.google.com/document/d/1v_5yzyzizNK_xmuCT7_wHTQVSQy-XQ7r8WDEQFZbEEs/edit for more details.

@aesharpe aesharpe added bug Things that are just plain broken. eia861 Anything having to do with EIA Form 861 labels Aug 3, 2023
@aesharpe aesharpe self-assigned this Aug 3, 2023
@e-belfer e-belfer moved this from New to Backlog in Catalyst Megaproject Aug 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Things that are just plain broken. eia861 Anything having to do with EIA Form 861
Projects
Status: Backlog
Development

No branches or pull requests

1 participant