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

Document codes and data structures associated with the EIA 176 #562

Closed
Tracked by #2603
zaneselvans opened this issue Mar 11, 2020 · 4 comments
Closed
Tracked by #2603

Document codes and data structures associated with the EIA 176 #562

zaneselvans opened this issue Mar 11, 2020 · 4 comments
Labels
eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. inframundo new-data Requests for integration of new data.

Comments

@zaneselvans
Copy link
Member

The full dataset can be downloaded from here, and consists of about 60MB worth of CSVs (uncompressed). Lots of data about natural gas production and consumption.

@zaneselvans zaneselvans added new-data Requests for integration of new data. epic Any issue whose primary purpose is to organize other issues into a group. labels Mar 11, 2020
@karldw
Copy link
Contributor

karldw commented Mar 11, 2020

Things I've learned this morning:

  • The LINE variable is the form line number multiplied by 100
  • The ATYPE variable refers to the column of the answer. For the questions I'm interested in, VL is gas volume in 1000s of cubic feet, CS is revenue in dollars, and CT is customer count. I figured these out by comparing the numbers in the bulk download with the data browser. I'm not sure if they're documented somewhere.
  • There are duplicates for name-state-year, even when ID-state-year is unique.

@zaneselvans zaneselvans added eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. and removed epic Any issue whose primary purpose is to organize other issues into a group. labels Apr 26, 2021
@zaneselvans zaneselvans changed the title Integrate EIA Form 176 Natural Gas Data Document codes and data structures associated with the EIA 176 Apr 26, 2021
@zaneselvans
Copy link
Member Author

Reopening with a more prescribed scope since we are going to integrate this data, and Karl has done some data sleuthing already.

@MichaelTiemannOSC
Copy link

Noting that 176 can and should be cross-checked against 857

https://www.eia.gov/dnav/ng/TblDefs/NG_DataSources.html#s176
https://www.eia.gov/dnav/ng/TblDefs/NG_DataSources.html#s857

@zaneselvans
Copy link
Member Author

I think this is superceded by the subtasks within #2603 now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
eia176 Issues related to the EIA Form 176 natural gas supply and disposition dataset. inframundo new-data Requests for integration of new data.
Projects
Archived in project
Development

No branches or pull requests

5 participants